Getting Started

What a financial model actually is

A model is a structured set of assumptions that produces a forecast you can interrogate.

A financial model is a structured representation of a business in numbers. You feed it a set of assumptions — how fast revenue grows, what margins look like, how much the company reinvests — and it produces a forecast of the company's future financial statements. The point is not the single number that comes out the end; it is the ability to ask 'what happens if…' and watch every downstream figure update consistently.

Analysts use models to analyse performance, forecast future results, value a company, test scenarios, and understand how a change in one assumption ripples through the whole business. A good model is a thinking tool: it forces you to be explicit about what you believe, and it shows you the consequences of those beliefs.

The model is an argument Every model is really an argument about the future expressed in numbers. The quality of the model is the quality of the reasoning behind its assumptions — not the number of tabs or the complexity of the formulas.

What good models have in common

• They are driven by a small number of clearly labelled assumptions, not hard-coded numbers buried in formulas.
• They flow in one direction: inputs → calculations → outputs.
• They are internally consistent: the three statements always tie out.
• They are transparent: anyone can trace any output back to the assumption that produced it.

The three-statement core

Income statement, cash flow statement, and balance sheet are one connected system.

The heart of any company model is the three-statement model: the income statement, the cash flow statement, and the balance sheet. These are not three separate reports — they are three views of the same underlying economic activity, and they are mechanically linked.

• The income statement shows profitability over a period: revenue, costs, and the net income that results.
• The cash flow statement reconciles accrual profit to actual cash, across operating, investing, and financing activities.
• The balance sheet is a snapshot at a point in time: what the company owns (assets) and how it is financed (liabilities + equity).

How they link

• Net income from the income statement flows into retained earnings on the balance sheet and is the starting point of the cash flow statement.
• Depreciation, working-capital changes, capex, debt, and dividends move cash on the cash flow statement and update the matching balance-sheet accounts.
• The ending cash balance from the cash flow statement becomes the cash line on the balance sheet.

Why it must balance Assets must always equal liabilities plus equity. If your three statements are linked correctly, the balance sheet balances automatically. When it doesn't, you have a linking error — Unit 10 is devoted to finding it.

Assets = Liabilities + Shareholders' EquityEvery transaction keeps this equation true. A model that breaks it has a bug, not an opinion.

Structure and discipline

Separate inputs, calculations, and outputs — the habit that makes models auditable.

The single most important professional habit in modelling is the separation of inputs, calculations, and outputs. Inputs (assumptions) are the things you choose. Calculations (schedules) turn those assumptions into the statements. Outputs are the summaries and charts you present. Mixing them — typing a number directly into a formula, for example — is how models become un-auditable and how errors hide.

1. Put every assumption in one obvious place and label it.
2. Reference assumptions in your calculations; never hard-code a number inside a formula.
3. Build calculation schedules (revenue, costs, depreciation, working capital, debt) that feed the statements.
4. Keep outputs — the executive summary, charts, valuation — clearly separated from the engine that produces them.

The cardinal sin Hard-coding a number inside a formula (e.g. =Revenue*1.08 instead of =Revenue*(1+GrowthAssumption)) is the most common way models go wrong. The reader can no longer see the assumption, and it can't be flexed in a scenario.

Mapping the course onto the tool

Where each CFA concept lives inside The Cash Flow Projector.

This course follows the CFA Institute's Financial Modeling curriculum unit by unit, but instead of building each schedule by hand in Excel, you'll see it working live in The Cash Flow Projector. The mechanics (HLOOKUP, SUMIF, combo boxes) are handled for you so you can focus on the concepts and the judgement.

Beyond the spreadsheet The tool also covers ground the CFA Excel course doesn't: live SEC EDGAR financials, triangulated Wall Street consensus, AI-clustered event factors, industry peer benchmarking, and reverse solvers that let you dial a target ROE and see what it implies.