Chapter 7 of 8
Forecasting: build a model from operating drivers
Connect revenue, margins, working capital, capex and financing instead of applying a single growth percentage everywhere.
In this chapter
Start with quantity and realisation #
For a manufacturer, forecast units sold and revenue per unit. For a store chain, separate existing-store growth and new-store ramp. For a subscription business, connect users, churn and revenue per paying user.
Use the business model’s actual drivers. Revenue growth cannot exceed physical capacity indefinitely without investment, outsourcing or price/mix change. Document which mechanism supports each forecast.
Separate variable and fixed costs #
Variable costs respond to activity under the assumed range; fixed costs may remain stable until a capacity step. Operating leverage can lift margins as utilisation rises and hurt sharply when it falls.
Do not extrapolate a short-run fixed-cost relationship beyond realistic capacity. Add maintenance, staffing, logistics and selling costs required by growth. A spreadsheet can show impossible margins unless someone asks how the business operates.
Link the balance sheet and cash #
Higher sales can need inventory and receivables. Capex changes assets and later depreciation. Debt funds cash shortfalls and adds financing costs. Equity issuance changes ownership and the per-share denominator.
Build the cash bridge before declaring the plan feasible. Use opening balances and explicit assumptions. Avoid circular borrowing/interest calculations unless the method resolves them transparently.
Stress assumptions rather than hiding precision #
Change price, volume, collection days and input costs separately, then consider combined adverse scenarios. Sensitivity is not a probability forecast. A base case is not necessarily the most likely path without an estimation basis.
Compare forecasts with later results using the original assumptions. Diagnose volume error, price error and funding error separately. Preserve the old version instead of overwriting it with the latest management guidance.
Hypothetical worked example
A fictional driver model
An imaginary firm sells 10 lakh units at ₹500: revenue ₹50 crore. Next year 12 lakh units at ₹525 give ₹63 crore, or 26% growth, combining 20% unit growth and 5% price growth.
At ₹300 variable cost per unit, contribution is ₹27 crore before fixed costs. This is not PAT; add fixed costs, depreciation, interest, tax, capex and working capital in their proper schedules.
Common mistakes
- Applying the same growth rate to all statements.
- Forecasting unlimited volume without capacity.
- Calling a sensitivity result a measured probability.
What should follow a revenue forecast before calling growth financeable?
Make this chapter useful
Can you defend the reasoning?
Before moving on, answer the self-check in your own words and write why each alternative fails. Use the worked example to test that explanation. Then apply it in the module research task; keep the assumptions and the evidence that could change your answer.
Desk assignment
What to submit
Submit a three-year driver model with a reconciled cash bridge and adverse volume, cost and collection scenarios.
Use the research ledger for dated evidence, or the module workbooks for calculations. Separate observations, assumptions and interpretation.
Sources and further reading
- NISM: Research Analyst learning topics (scope reference; independent lessons) ↗
- NSE: company integrated financial filings ↗
Further-reading references from the curriculum source list. Contract sizes, expiry calendars, settlement references, margin parameters and tax treatment can change; verify the current operative documents for the actual product. Worked figures are illustrative, not current quotes.
Progress is stored only on this browser.
Back to Financial statements and business modelling · Learning library · Calculators
General financial education. No securities recommendation, assured outcome or personal advice. Read the risk disclosures.