CFA Level I Exam · Introduction to Financial Statement Modeling
Financial Statement Modeling Overview and Process
Updated 7 October 2026 · Fact-checked
A financial statement model is a forecast of a company's income statement, balance sheet and cash flow statement built from linked assumptions. You build it by understanding the business, forecasting revenue, costs, working capital and capex, then linking the statements so the balance sheet balances and cash ties to the cash flow statement.
Understand Financial Statement Modeling Overview and Process
A financial statement model is a set of linked forecasts of a company's income statement, balance sheet and cash flow statement. Analysts use it to estimate future earnings and cash flows, to value a company, to test how results change under different assumptions, and to judge financing needs.
The process moves from understanding to numbers. First, understand the company, its industry, its business model and its past results. Next, choose the model structure and the key drivers, such as sales growth, margins, days of inventory, capex and the tax rate. Then forecast revenue first, because most other items depend on it. Forecast costs, working capital, capital expenditure and financing next. Finally, review the output, run scenarios and sensitivities, and revise.
The three statements are linked. Net income from the income statement flows into retained earnings on the balance sheet (less dividends) and is the starting point of cash flow from operations. Depreciation reduces net income and PP&E but is added back in cash flow because it is non-cash. Changes in working capital accounts on the balance sheet appear as operating cash flows. Capex raises PP&E and appears in investing cash flow. Debt and equity issuance, repayments and dividends appear in financing cash flow.
The cash flow statement closes the loop. Ending cash from the cash flow statement becomes the cash line on the balance sheet. If assets do not equal liabilities plus equity, there is a linkage error. Interest expense can create circularity, because interest depends on debt, which depends on cash flow, which depends on interest.
A model is only as good as its assumptions. Good practice is to ground drivers in history and industry data, keep assumptions visible, and test several scenarios. Overconfidence and anchoring on past growth are common behavioural risks.
Key formulas to remember
- Balance sheet identity
- Assets = Liabilities + Equity
- Must hold in every forecast period. If it fails, a link is broken.
- Retained earnings roll-forward
- Ending RE = Beginning RE + Net income − Dividends
- Main link from the income statement to the balance sheet.
- PP&E roll-forward
- Ending net PP&E = Beginning net PP&E + Capex − Depreciation
- Assumes no disposals or impairments.
- Cash roll-forward
- Ending cash = Beginning cash + CFO + CFI + CFF
- Ending cash feeds the balance sheet cash line.
- Working capital cash effect
- Increase in operating assets = cash outflow; increase in operating liabilities = cash inflow
- Applies to non-cash working capital items such as receivables, inventory and payables.
- Driver-based forecast
- Forecast item = Driver ratio × Base (e.g. receivables = days sales outstanding × sales ÷ 365)
- Ties balance sheet items to income statement drivers.
How to solve Financial Statement Modeling Overview and Process questions
Use this method for any question on model purpose, build steps or statement links.
- 1Identify what is asked: purpose of the model, order of build steps, or a specific link between statements.
- 2Locate the driver. Most forecast items follow from revenue, so check whether revenue has been forecast first.
- 3Trace the item through all three statements: where does it start, where does it end up on the balance sheet, and what cash effect does it have?
- 4Separate non-cash items (depreciation, amortization) from cash items and apply the correct direction in cash flow.
- 5Check the identities: roll-forwards for retained earnings, PP&E and cash, and Assets = Liabilities + Equity.
- 6Eliminate the two options that reverse a sign, skip a link or break the order of steps.
- 7Check that the assumptions are reasonable and consistent with the business and industry.
Quickest way: Trace the item, check the sign
When to use it: Use when a question asks how a change in one item affects the other statements, and time is short.
- Start at net income. Ask how the change affects it, after tax.
- Move to retained earnings, then to cash flow from operations.
- Add back non-cash items and adjust for working capital.
- Place any capex in investing and any debt, equity or dividend in financing.
- Confirm that the balance sheet still balances; discard options that do not.
Common mistakes in Financial Statement Modeling Overview and Process
Forecasting costs or balance sheet items before revenue.
Students forget that most drivers depend on sales.
Fix: Remember the order: understand the business, forecast revenue, then costs, working capital, capex and financing.
Treating depreciation as a cash outflow.
It is an expense on the income statement, so it looks like cash leaving.
Fix: Add it back in CFO. It lowers net income and net PP&E but not cash directly.
Getting the sign wrong on working capital changes.
Students link a rise in receivables with a rise in cash.
Fix: A rise in operating assets uses cash. A rise in operating liabilities provides cash.
Forgetting to deduct dividends from retained earnings.
Students focus on net income only.
Fix: Use Ending RE = Beginning RE + Net income − Dividends. Dividends also appear in financing cash flow.
Assuming a balanced balance sheet proves the assumptions are right.
Balancing is a mechanical check, not a test of realism.
Fix: Balancing only shows the links work. Assumptions still need review against history and the industry.
Using a single scenario as the forecast.
One base case feels precise.
Fix: Run scenarios and sensitivities, and note that anchoring on past growth can bias the base case.
Worked examples
Example 1
A company starts the year with net PP&E of $500 million. It spends $80 million on capex and records $60 million of depreciation. There are no disposals. What is ending net PP&E? Options: A) $440 million, B) $520 million, C) $640 million.
Show the solution
- Use Ending net PP&E = Beginning + Capex − Depreciation.
- 500 + 80 − 60 = 520.
- Option A subtracts capex and adds nothing; option C ignores depreciation.
Answer: B) $520 million
Example 2
In a forecast, net income is €200 million, depreciation is €50 million, receivables rise by €30 million, payables rise by €10 million, and there are no other operating items. What is cash flow from operations? Options: A) €170 million, B) €230 million, C) €290 million.
Show the solution
- Start with net income: 200.
- Add back non-cash depreciation: 200 + 50 = 250.
- Rise in receivables uses cash: 250 − 30 = 220.
- Rise in payables provides cash: 220 + 10 = 230.
Answer: B) €230 million
Exam tips
- Know the order of build steps and the reason revenue comes first.
- For link questions, trace net income, retained earnings, CFO and cash in that order.
- Expect sign questions on depreciation and working capital; check the direction before choosing.
- Remember that a balancing balance sheet checks mechanics, not assumption quality.
- With 90 seconds per question, use the quick trace rather than building full statements.
Practice questions from Introduction to Financial Statement Modeling
- Which of the following is the most likely limitation of a financial statement forecasting model that relies heavily on historical relationsh…
- An analyst forecasts a retailer's income statement using a top-down approach. Which forecast is the analyst most likely to start with?
- A company's forecast sales next year are 800. Its model assumes receivable days of 45 on a 365-day year using year-end receivables. Opening …
- An analyst forecasts a manufacturer's cost of goods sold. Raw material prices are contractually fixed for the next three years, but the comp…
- An analyst forecasts industry sales of 50 billion next year and expects the company's market share to rise from 12% to 14%. Industry sales w…
Financial Statement Modeling Overview and Process in other exams
The same ground in other exams, if you are preparing for more than one or want another angle on it.
Financial Statement Modeling Overview and Process: frequently asked questions
What are the steps in building a financial statement model?
Understand the company and industry, select the structure and drivers, forecast revenue, then forecast costs, working capital, capex and financing. Link the statements, check that the balance sheet balances, and test scenarios. Revise assumptions as new information arrives.
How are the three financial statements linked in a model?
Net income flows to retained earnings and starts the cash flow statement. Working capital, PP&E and debt changes on the balance sheet drive cash flows. Ending cash from the cash flow statement becomes the balance sheet cash line.
Why is revenue forecast first?
Most costs, working capital items and capex depend on sales volume or growth. An error in revenue spreads through the whole model.
Will I need to build a full model in the CFA Level I exam?
No. Questions are standalone three-option items, so expect to apply a link, a roll-forward or the order of steps, not construct full statements.