Best way to compare actuals with your budgets/ forecasts

Please sign up for the course before starting the lesson.

One of the most common mistakes we see in forward looking spreadsheets is that when it is time to compare the actual results to the budget/ forecast, the formulas for the budget, forecast or financial model are overwritten with the actual numbers.

In all likelihood the spreadsheet will stop working correctly and you will have difficulty trying to piece together what:

  • you initially budgeted/ planned for,
  • the revisions made to your initial planning
  • and what actually happened.

To see the full course contents click here.

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