EXERCISE: Budget vs Actual vs Forecast Example 3

Please sign up for the course before starting the lesson.

Question

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

1.     We now want to set up a report that automatically pulls through the latest month’s information as well as the year to Date numbers for the given month. Go to the Monthly Variance sheet

2.     In H11 to H22, create a variance calculation comparing Actual to Budget for now. However, keep in mind the issue regarding negative numbers so the formula must be set up so that if expenses decrease it should show an improvement (positive percentage).

3.     Using Conditional Formatting on H11 to H22, create arrows that indicate which costs have improved, worsened or stayed the same

To see the full course contents click here.

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