Update a financial model when new actual results, operating changes, investment decisions or financing terms could alter the decision it supports. A regular review rhythm is useful, but material events should trigger an update rather than waiting for the next scheduled cycle.

Private-school scenario analysisView the financial model on FinancialModelsLab

A scenario view helps separate the current operating case from alternative outcomes without overwriting the assumptions behind the base plan.

Treat the model as a decision tool

The purpose of an update is not simply to replace one month of figures. It is to keep the model relevant to the question the business is considering, such as runway, hiring, a new location, financing or a change in strategy.

Begin by confirming whether the original decision, forecast period and level of detail are still appropriate. A major shift in the business may require a revised structure rather than a mechanical refresh.

Bring in actual performance

Compare actual sales, margins, operating activity, expenses and cash with the assumptions behind the forecast. The difference matters because it may reveal a new starting point or a relationship that is developing differently from the plan.

Preserve the original budget or prior forecast where comparison is useful. Replacing it entirely makes it harder to explain what changed and why.

Update when the operating plan changes

Changes in pricing, product mix, capacity, customer acquisition, staffing, suppliers, locations or launch timing can flow through several parts of the model. Update the underlying drivers and trace the effect through profit, working capital and cash.

A new sales target alone is not enough if the team, inventory, marketing or delivery capacity required to achieve it has also changed.

Reflect investment and financing decisions

Revise the model when capital expenditure, funding amounts, drawdown dates, interest, repayment terms or investor plans become more specific. These changes can alter both the cash requirement and the reporting an audience needs.

Keep proposed terms separate from confirmed agreements. Where an outcome remains uncertain, a clearly named scenario can be more useful than embedding it in the base case.

Set a practical review rhythm

Choose a cadence that matches how the business makes decisions and receives reliable information. The review should be frequent enough to identify meaningful changes before they become urgent, while avoiding updates that add no new evidence.

Use event triggers alongside the calendar:

  • A material variance in sales, margin, collections or spending.
  • A change in launch, hiring, purchasing or expansion timing.
  • A new contract, location, product or revenue stream.
  • Revised funding terms or a new financing conversation.
  • A decision that depends on a downside or alternative scenario.