Meaning and transaction use
CFA Institute describes financial statement modelling as forecasting income statements, balance sheets and statements of cash flows for company and security valuation. [S1]
CFA Institute's modelling curriculum covers revenue, costs, working capital, capital structure, debt and equity schedules, statement construction and troubleshooting. [S2]
The SEC identifies the income statement, balance sheet, statement of cash flows and statement of stockholders' equity as core financial statements and notes that accounting judgments can materially affect reported figures. [S3]
Worked example
Illustrative one-period linkage only. Assume revenue of 100.0 million, operating costs of 70.0 million, depreciation of 5.0 million, interest of 3.0 million, tax of 5.5 million, a 4.0 million increase in working capital, capital expenditure of 8.0 million, 2.0 million of new borrowing, dividends of 3.0 million and opening cash of 10.0 million.
Scroll the table horizontally to view all columns.
| Measure | Calculation | Result |
|---|---|---|
| EBIT | 100.0 - 70.0 - 5.0 | 25.0m |
| Net income | 25.0 - 3.0 - 5.5 | 16.5m |
| Cash from operations | 16.5 + 5.0 - 4.0 | 17.5m |
| Cash from investing | -8.0 capital expenditure | -8.0m |
| Cash from financing | 2.0 borrowing - 3.0 dividends | -1.0m |
| Closing cash | 10.0 + 17.5 - 8.0 - 1.0 | 18.5m |
| Closing retained earnings | 40.0 + 16.5 - 3.0 | 53.5m |
| Balance-sheet check | 150.0 assets - 60.0 liabilities - 90.0 equity | 0.0m |
The illustrative statements produce closing cash of 18.5 million and a zero balance-sheet check. The example demonstrates linkage; it does not establish that the forecast assumptions or accounting treatment are appropriate.
Proposed transaction review process
Set definitions and periods
Define entities, currency, accounting basis, historical periods, forecast horizon and scenario controls.
Load and reconcile history
Tie historical statements and supporting schedules to approved financial records before forecasting.
Build operating and financing schedules
Model revenue, costs, working capital, capital expenditure, tax, debt, equity and other material balances.
Link and test the statements
Flow earnings, cash movements and closing balances through all statements; run balance, cash and roll-forward checks for every period.
Evidence checklist
Historical statements
Audited accounts, management accounts, trial balances and cash-flow reconciliations.
Operating drivers
Volumes, prices, margins, headcount, working-capital days and tax assumptions with owners and dates.
Supporting schedules
Fixed assets, depreciation, debt, interest, leases, equity, retained earnings and cash.
Model controls
Input conventions, version history, change log, scenario definitions, checks and review evidence.
Decision framework
| Situation | Proposed action |
|---|---|
| Historical statements do not reconcile | Resolve or clearly isolate the difference before using history as the forecast base. |
| The model balances through a plug | Identify the underlying linkage or classification error and restrict plugs to transparent, approved financing mechanics. |
| Circularity affects debt and interest | Use a controlled circularity method or a documented approximation and test the effect. |
| A scenario changes cash needs | Trace the effect through funding capacity, covenant headroom and the relevant transaction decision. |
Common errors to check
- Hard-coding forecast outputs that should flow from assumptions or schedules.
- Treating a zero balance-sheet check as validation of the commercial forecast.
- Mixing cash and non-cash items or inconsistent sign conventions.
- Changing formulas across forecast periods without a documented reason and review.
Reconcile the integrated forecast
Bring the historical statements, operating assumptions, supporting schedules, debt terms and scenario requirements to a three-statement model review. Trace every material output through the statements and document unresolved model risks.
Discuss the transactionPrimary references and editorial scope
- CFA Institute, Introduction to Financial Statement Modeling
Forecast financial-statement modelling and its use in valuation. Reference checked 17 September 2026. - CFA Institute, Financial Modeling
Integrated modelling topics, schedules, statements and troubleshooting. Reference checked 17 September 2026. - US SEC, Investor Bulletin: How to Read a 10-K
Core financial statements and the significance of accounting judgments. Reference checked 17 September 2026.
General financial-modelling education. Figures are hypothetical. Model structure and accounting treatment depend on the entity, purpose, accounting framework, tax profile, financing documents and review requirements.
General business information. Obtain advice appropriate to the legal, tax, accounting and financing facts. No offer, lender commitment or transaction outcome is represented. All worked examples use expressly assumed figures. Editorial draft date: 17 September 2026.
