Long range financial planning: drivers and scenarios

Long range financial planning turns business-unit assumptions into a multiyear view of revenue, costs and cash needs. Build the outlook from operating drivers, calculate consistent scenarios, and use the differences to decide when capacity or funding commitments need to change. A useful plan is easy to revise when an assumption fails.

Start with decisions and a reconciled baseline

List the decisions that extend beyond the annual budget: hiring, equipment, locations, product capacity and financing. Choose a horizon that covers their lead times. The SBA's business-plan guidance describes a multiyear outlook that includes income statements, balance sheets, cash flow statements and capital expenditure budgets, with greater detail in the first year.

Bring the latest closed ledger, sales or service-volume export, payroll summary, capital spending schedule and working capital balances. Use the same business-unit IDs and fiscal periods in every file. Reconcile the starting year before projecting anything from it.

Do not extrapolate an unfinished period as though it were closed; reading a measure before the period closes explains that boundary. A large transaction or temporary vacancy should be visible as an adjustment, with an owner and explanation.

Put the assumptions into rows

This invented US field-services company has East and West business units. Its closed 2026 revenue is $1,600,000, from 1,000 East jobs and 600 West jobs at $1,000 per job. Opening operating working capital is 10% of that revenue, or $160,000.

The base case holds price and variable cost per job constant. Unit leaders submit the job schedule below; fixed costs remain $200,000 for East and $140,000 for West each year. These are assumptions for the example, not external benchmarks.

Enter this Drivers sheet in A:F, starting with headers in row 1:

In G2 calculate revenue, H2 variable costs and I2 operating contribution. Fill down to row 7:

=C2*D2
=C2*E2
=G2-H2-F2

The operating contribution here is revenue less the displayed variable and fixed cash operating costs. There is no depreciation, financing cost or tax in these example rows, so do not label it GAAP net income.

Revenue = Jobs × Price per job

Operating contribution = Revenue - Jobs × Variable cost per job - Fixed costs

Test the assumptions operationally. The job schedule needs an agreed capacity check; holding fixed costs flat needs an owner who can explain how the business will support the planned workload. A spreadsheet formula does not prove either assumption is feasible.

Roll business units into the annual plan

Create a Summary sheet with years in A2:A4. In B2 sum revenue for that year:

=SUMIFS(Drivers!$G$2:$G$7,Drivers!$A$2:$A$7,$A2)

Use the same pattern for variable costs from Drivers H, fixed costs from F and operating contribution from I. Microsoft's SUMIFS documentation explains how multiple criteria select rows for a sum; add a business-unit criterion when reviewing one unit. Covirage is not affiliated with Microsoft.

For every year, revenue minus variable costs minus fixed costs must equal the sum of the unit contributions. Keep a check cell equal to zero; do not overwrite a difference to force the total to agree.

Show what growth requires in cash

Assume closing operating working capital remains 10% of annual revenue. It covers operating receivables and inventory less operating payables under a consistent company definition. The capex schedule is a separate input, not a percentage silently embedded in costs.

On Summary, B:E hold the table above. Put closing working capital in F, its increase in G, capex in H and the simplified cash result in I. Put opening working capital of 160000 in K2.

F2 = B2*10%
G2 = F2-$K$2
I2 = E2-G2-H2
G3 = F3-F2

Enter only the expression beginning with =, not the cell label. Fill F and I down; subsequent working capital increases compare with the preceding year's F cell.

The simplified cash bridge totals 240,000 + 290,000 + 340,000 = $870,000. A full company cash plan must also include taxes, interest, debt movements and other cash items. Annual totals can hide a seasonal shortfall, so expand periods around a large commitment.

Change one driver and compare the downside

Reduce each unit's jobs by 10% in every year. Keep price, unit cost, fixed costs and capex unchanged. This isolates volume risk; it does not assume costs can immediately be removed.

For 2027, 1,620 × (1,000 - 600) - 340,000 = $308,000. Subtract the $2,000 working capital increase and $120,000 capex to get $186,000. All figures are exact whole dollars; no rounding is needed.

Downside cash totals 186,000 + 212,000 + 254,000 = $652,000, a $218,000 reduction from the base case. Leadership can now test whether equipment timing still fits the funding envelope, with a demand trigger for reconsidering the commitment. Use scenario analysis in Excel for broader case mechanics and planning guidance for related operating decisions.

Where it goes wrong

• Revenue growing without capacity. Volume assumptions must connect to available people, equipment or delivery time.
• Nominal and constant-dollar assumptions mixed. State whether prices and costs include inflation, then use that basis consistently.
• Annual profit presented as available cash. Working capital, capex and financing timing require separate schedules.
• Scenario changes stacked accidentally. Label every changed assumption so a volume case does not also contain an unexplained cost revision.
• Plan versions with different baselines. Reconcile the starting year before comparing scenario totals.

Compare your multiyear files in Covirage

Bring a sample of your own business-unit revenue, cost and cash scenarios as files or a Google Sheet. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own plan export.

See FP&A reporting for the supporting finance workflow.