Skip to content
← TemplatesFinance & modelling

3-Statement Financial Model with DCF (Excel) — integrated, balancing, ready to use

This is the model every analyst is expected to build and few are taught properly: an income statement, balance sheet and cash flow that link and balance to the cent, with a DCF valuation hanging off them. Change any blue assumption — growth, margin, capex, WACC — and the whole model recomputes and re-balances. It is the finished artifact from the LeadAfrik Financial Modelling course, ready to adapt to your own company.

Get it — KES 100 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

What's inside

  • Fully integrated — change one assumption and all three statements update
  • Balances to the cent: a live BALANCE CHECK row proves Assets = Liabilities + Equity every year
  • Built-in DCF — free cash flow, WACC, terminal value, enterprise and equity value, value per share
  • Blue-input / black-formula convention: one source of truth, no hard-coded numbers
  • Five-year forecast from a real base year — edit the drivers, not the formulas
  • Verified: recomputed formula by formula, zero errors, balances in all six years

The tabs

  • Cover (guide + colour legend)
  • Assumptions (blue inputs)
  • Income Statement
  • Balance Sheet
  • Cash Flow
  • DCF valuation

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Every number in the workbook is one of two things: a labelled blue input you can change, or a black formula that traces back to those inputs. Nothing is hard-coded. That discipline — one source of truth — is what makes a model auditable and safe to reuse: you edit the assumptions, never the engine.

The three statements are genuinely integrated. Net income flows to retained earnings; depreciation and working-capital movements flow through the cash-flow statement to the cash balance; capex and debt repayments update the balance sheet. A live BALANCE CHECK row proves Assets = Liabilities + Equity in every year — if it is ever non-zero you have a broken link, and the model tells you at once.

The DCF tab builds unlevered free cash flow straight from the statements, discounts it at WACC, adds a terminal value, and bridges enterprise value to equity value and a value per share — with terminal value shown as a percentage of enterprise value so you can sanity-check how much of the answer the terminal assumption is carrying. To learn to build this from a blank sheet, take the Financial Modelling course; to value a company interactively in your browser, use the free DCF model tool.

Do it online instead

Value a company live — free DCF tool

Open the free tool →

Frequently asked questions

Is this a real, working model or just a template shell?

It is a real, fully-linked model. We recomputed it formula by formula: zero errors, and the balance sheet balances to the cent in all six years. Open it, change a blue assumption, and every statement — and the valuation — updates and stays balanced.

Will the numbers show when I open it?

Yes. Excel and Google Sheets recalculate formulas on open, so you see every value immediately. The workbook ships formula-driven (not as pasted numbers) so it is genuinely yours to change.

Can I use it for my own company?

That is the point. Replace the base-year revenue and the assumptions with your company's, extend or shorten the forecast, and the model adapts. For the reasoning behind each line, the Financial Modelling course walks you through building it from scratch.