I85PREP
⌘ K
CCFA study materials
CCFA study resources

CCFA: Financial Modeling and Forecasting

CCFA · Work through your exam, one topic at a time.

All guide sections

Financial Modeling and Forecasting

Financial Modeling and Forecasting tests whether you can build a coherent three-statement model, drive forecasts from operating assumptions, and keep the balance sheet balanced. Expect revenue builds, working capital schedules, debt and interest circularity, and scenario analysis.

Core rules

  • A three-statement model links net income to retained earnings, cash flow to the cash balance, and interest expense to the debt balance. The balance check must equal zero.
  • Forecast revenue from volume × price, segment growth, or market share rather than a flat percentage. Tie costs to the appropriate driver: variable costs to volume, fixed costs to inflation or headcount.
  • Working capital days drive receivables, inventory, and payables. A rising days sales outstanding consumes cash even when revenue grows.
  • The debt schedule is the usual source of circularity: interest depends on debt, debt depends on cash flow, and cash flow depends on interest. Use iterative calculation or a revolver toggle.
  • Scenarios should change operating drivers, not just the final output; sensitivity tables show how value or covenant metrics respond.

Worked example

A company forecasts revenue of 500 in year one, growing 10%. Days sales outstanding are 45, so receivables = 500 × 45/365 = 61.6. In year two revenue is 550, so receivables = 67.8. The increase of 6.2 is a use of cash in the cash flow statement. If DSO rises to 60, year-two receivables become 90.4, an increase of 28.8, cutting free cash flow by 22.6 versus the base case. That is why a working capital assumption can break a covenant even when EBITDA looks healthy.

Traps

  • Hardcoding a number inside a formula breaks the model when assumptions change; keep inputs separate.
  • Forgetting to tax negative EBIT correctly or to preserve loss carryforwards distorts forecasts.
  • A balance sheet that balances by a plug is a warning, not a fix; find the missing link.
  • Forecast periods that extend beyond a credible competitive advantage create false precision.
  • Ignoring revolver commitment fees and cash sweep mechanics understates interest.