Home › CFA® Level I › Financial Statement Analysis
CFA® Level I · Financial Statement Analysis · free lesson
Introduction to Financial Statement Modeling
Valuation and credit decisions rest on forecasts, and most forecasts start from a model of a company's future financial statements. This module shows how to build a sales-driven pro forma model, and how competition, inflation, technology, forecast horizon and the analyst's own behavioral biases shape the assumptions that go into it.
What you will learn
1. Develop a sales-based pro forma model that forecasts revenue, costs, working capital and capital investment to build the income statement, balance sheet and cash flows.
- Top-down: market size x market share; bottom-up: volume x price by segment; hybrid combines both.
- Cost of sales via gross margin; operating expenses split into fixed and variable parts.
- Working capital from DSO, DOH and DPO; PP&E = opening + capex - depreciation.
- Interest from forecast debt; tax from a normalized effective rate.
- Cash (or a revolver) balances the model; test key drivers with sensitivity analysis.
2. Explain how behavioral biases affect analysts' forecasts and describe ways to reduce their effect.
- Overconfidence: ranges too narrow; fix by tracking accuracy and widening ranges.
- Illusion of control: more detail feels like more accuracy; focus on key drivers.
- Conservatism: slow updating and anchoring on prior forecasts.
- Representativeness: extrapolating patterns and ignoring base rates.
- Confirmation bias: seeking supportive evidence; fix with devil's advocates and disconfirming data.
3. Explain how competitive factors, assessed with Porter's five forces, affect forecasts of prices, costs and margins.
- Five forces: substitutes, rivalry, supplier power, buyer power, threat of new entrants.
- Strong forces mean low pricing power, cost pressure and margins that revert to the industry norm.
- Barriers such as patents, brands, scale and network effects protect margins.
- Patent expiries, deregulation and new technology can change industry structure abruptly.
- A small price change has a large effect on gross profit because costs do not change with price.
4. Evaluate how inflation and deflation affect revenue and cost forecasts, including whether a company can pass input cost changes on to customers.
- Pass-through depends on pricing power, elasticity of demand, competitors' exposure and contract lags.
- Revenue growth = (1 + price growth) x (1 + volume growth) - 1.
- Full pass-through of an absolute cost increase still lowers the gross margin percentage.
- Inelastic demand lets a company raise prices with limited volume loss.
- Deflation and currency moves affect costs and prices with lags that models should capture.
5. Explain how technological developments, including disruption and cannibalization, are reflected in revenue and cost forecasts.
- Technology affects costs (supply side) and products and substitutes (demand side).
- Model disruption with adoption curves and scenario analysis, not trend extrapolation.
- Cannibalization factor = share of new product sales taken from existing products.
- Forecast net incremental revenue and compare the margins of new and old products.
- Disruption may require faster depreciation or impairment of exposed assets.
6. Explain how analysts choose an explicit forecast horizon and make projections beyond it, including normalized earnings and terminal value.
- Horizon depends on holding period, cyclicality, company events and predictability.
- Cyclical companies: cover a full cycle and use normalized (mid-cycle) earnings.
- Terminal growth should not exceed long-run nominal economic growth.
- Margins and returns tend to revert to norms as competition responds.
- Terminal value = FCF in year n+1 / (r - g); it is large and highly sensitive to r and g.
Module at a glance
- Sales drive the model: forecast revenue first (top-down, bottom-up or hybrid), then link costs and balances to it.
- Working capital from days ratios; PP&E = opening + capex - depreciation.
- Behavioral biases (overconfidence, illusion of control, conservatism, representativeness, confirmation) distort forecasts.
- Porter's five forces translate into price, cost and margin-reversion assumptions.
- Model price and volume separately; pass-through depends on pricing power and elasticity.
- Count only net incremental revenue from new products after cannibalization.
- Cover a full cycle, normalize earnings and keep terminal growth sustainable.
This free module has 6 lessons, 15 practice questions with full explanations.