EXERCISE: Budget vs Actual vs Forecast Example 2

Please purchase the course before starting the lesson.

Question

Open the Budget vs Forecast vs Actual v1 Step 2 file and do the following:

1.     We now want to create the reports and dashboard components to show what is happening

2.     In the Graphs- Waterfall sheet, do the following:

a.     In G11 column, calculate the variance on each line with a formula that is Actuals minus Budget.

b.     Have a look at I36 columns and the section in C35 to F48 for the setup

c.     You now have the data set up. Using Stock Charts create a waterfall graph explaining why the budgeted profit after tax was not achieved.  If you want, change the colours and move the axis to improve the chart. We offer a Graphing course which goes into this in more detail.

3.     In the Graphs sheet we have extracted some of the information and created some graphs that may be useful. Have a look at how this was setup.

To see the full course contents click here.

Back to: Online Financial Modelling, Budgeting and Forecasting Course > Comparing Budgets and Forecasts to Actuals