Learning Module 12
Introduction to Financial Statement Modeling

Steps in model construction — revenue forecast → COGS → operating expenses → non-operating items → pro forma income statement → cash flow → balance sheet.

Revenue forecast — driven by volume, price/mix, and foreign exchange. Segment-level analysis often provides the most accurate view.

COGS & operating expenses — forecast using historical margins and expected changes (e.g., gross margin expansion from product mix).

Working capital — forecast using efficiency ratios (DOH, DSO, DPO) linked to sales and COGS.

Capital expenditures & depreciation — capex as % of sales; D&A based on prior-year fixed assets.

Balance sheet — generated by linking income statement and cash flow projections; all items must tie out.

Valuation inputs — free cash flow to the firm (FCFF) is derived from EBIT, taxes, D&A, change in working capital, and capex.

Overconfidence — unwarranted faith in own abilities; mitigate by recording and reviewing forecasts, and using scenario analysis.

Illusion of control — overestimating control over outcomes; mitigate by limiting model complexity and focusing on key drivers.

Conservatism (anchoring) — inadequately incorporating new information; mitigate by regular team reviews and flexible models.

Representativeness (base-rate neglect) — classifying new information based on past experiences; mitigate by combining inside view (company-specific) with outside view (industry base rates).

Confirmation bias — seeking information that confirms prior beliefs; mitigate by seeking diverse perspectives (e.g., bearish analysts) and conducting thorough competitor research.

Threat of substitutes — availability of alternative products that can satisfy the same need.

Rivalry — intensity of competition among existing firms; higher rivalry reduces pricing power and margins.

Bargaining power of suppliers — ability of suppliers to raise input prices; low power means more favorable cost structure.

Bargaining power of buyers — ability of customers to drive prices down; high power erodes margins.

Threat of new entrants — barriers to entry; high barriers protect incumbent margins.

Analysis of these forces helps assess a company's ability to maintain prices and margins, which feeds into revenue and cost forecasts.

Inflation impact on sales — depends on price elasticity of demand and ability to pass through costs. Inelastic demand allows price increases without significant volume loss.

Inflation impact on costs — companies can mitigate through input substitution, hedging, long-term contracts, or operational efficiency.

Geographic mix — different inflation rates across countries affect revenue and cost projections.

Pricing strategy — companies may choose to pass on cost increases (protect margins) or absorb them (gain market share).

Deflation — can lead to price wars, lower margins, and inventory write-downs; forecasting requires careful volume–price trade-off analysis.

Explicit forecast period — influenced by investment strategy, industry cyclicality, company-specific events (e.g., acquisitions), and firm policy.

Normalized earnings — mid-cycle earnings excluding temporary factors; used in terminal value calculations.

Terminal value — often derived using a perpetuity growth model or exit multiple; the cash flow used should be normalized.

Inflection points — economic disruption, regulation, and technology can cause future to look different from the past; analysts must anticipate these.

Long-term growth rate — should be realistic (usually ≤ GDP growth for mature companies) and consistent with industry life cycle.