Course curriculum

  • 1

    Introduction

    • Welcome

    • Course introduction

    • Course learning objectives

    • Instructors

    • Download course presentation

  • 2

    Budgeting Within a Strategic Framework

    • Learning objectives

    • Barriers to strategy execution

    • Translating the strategy into a business plan

    • Interactive exercise 1

    • Balanced scorecards

    • Top reasons to budget

    • What to watch out for

    • Interactive exercise 2

  • 3

    Building a Robust Budgeting Process

    • Learning objectives

    • The master budget

    • 3 categories of budgets

    • Interactive exercise 3

    • Manufacturing company example

    • Retail company example

    • Services company example

    • Quiz

    • Where to start with budgeting

    • Steps in the budgeting process

    • Psychology and target setting

    • Top down vs. bottom up involvement

    • Interactive exercise 4

  • 4

    A Practical Guide to Developing Budgets

    • Learning objectives

    • 4 approaches to budgeting

    • Incremental budgeting

    • Activity based budgeting

    • Value proposition budgeting

    • Zero based budgeting

    • Interactive exercise 5

    • Beyond budgeting

  • 5

    Forecasting Techniques

    • Learning objectives

    • Cost types

    • Modified cost types

    • Cost structure and earnings volatility

    • Cost structure exercise template

    • Cost analysis demonstration

    • Breakeven analysis and margin of safety demonstration

    • Sensitivity analysis with data table

    • Interactive exercise 6

    • Cost control matrix

    • Quantitative forecasting methods

    • Forecasting exercise template

    • Moving averages

    • Simple linear regression

    • Excel FORECAST function

    • Equation of a line regression

    • Multiple linear regression overview

    • Multiple regression Excel demonstration

    • Interpreting regression summary output

    • Using the multiple regression equation

    • Interactive exercise 7

    • PEST analysis

    • Porter's 5 forces

  • 6

    Tracking Budget Performance with Variance Analysis

    • Learning objectives

    • What is variance analysis

    • Volume vs. price variance

    • Cost variance

    • Interactive exercise 8

    • Variance analysis exercise template

    • Variance analysis in Excel

    • Variance impact and waterfall chart data

    • Variance waterfall chart in Excel

    • Variance waterfall chart template

    • Root cause analysis

    • Presenting results of variance analysis

    • Interactive exercise 9

  • 7

    Applied Budgeting Tools and Techniques in Excel

    • Learning objectives

    • Budgeting tools exercise templates

    • Goal Seek tool in Excel

    • Solver tool in Excel

    • Consolidate function in Excel

    • Pivot tables overview

    • Setting up a pivot table in Excel

    • Beyond Excel

    • Interactive exercise 10

  • 8

    Conclusion

    • Conclusion and recap of objectives

    • Download appendices and bonus templates

    • Appendix models

    • Summary

  • 9

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion