Integrated 3-Statement DCF Valuation Model
Income statement, balance sheet and cash flow that actually tie, feeding a DCF with both terminal methods and the cross-checks analysts use.
Choose the licence on the Gumroad page. Payment and VAT are handled by Gumroad, the merchant of record.
A five-year integrated model built the way a bank analyst builds one, then stripped of everything that makes those hard to read.
- Assumptions sheet drives every line: growth, margins, capex, working-capital days, tax, and a CAPM WACC build-up.
- Three statements fully linked. Cash is the balancing item through the cash flow statement. The balance-sheet check row reads zero in every year, and was verified to before listing.
- DCF with both terminal methods side by side: Gordon growth and exit multiple, plus the two cross-checks that catch bad assumptions: the exit multiple your growth rate implies, and the growth rate your multiple implies.
- Sensitivity grid: value per share across WACC and terminal growth.
- Comps sheet with EV/Revenue, EV/EBITDA and P/E, and the median fed back as a check on the exit multiple.
- Guide sheet explains each design choice, including the ones made for readability: interest on opening debt to avoid circularity, flat debt, no loss carry-forward.
No macros. No hidden sheets. Every cell is either a yellow input or a blue formula. Excel and Google Sheets.
Who it is for: analysts, founders and students who need a valuation that ties out rather than a template that looks finished. Every assumption (growth, margins, capex, working-capital days, tax, WACC) feeds the three statements, and the balance sheet check row reads zero in every year, which was tested before listing rather than assumed. The DCF sheet shows the perpetuity growth and exit multiple methods side by side, with the implied multiple and implied growth cross-checks that catch inconsistent assumptions, plus a WACC and growth sensitivity grid and a comparable companies sheet.
What is inside
1 Excel workbook (.xlsx), sheets: Assumptions, Guide, Income Statement, Balance Sheet, Cash Flow, DCF, Sensitivity, Comps
Use it if
You need an investor-grade valuation you can defend line by line, in Excel or Google Sheets.
Not for
You need an LBO model with debt tranches and returns waterfalls; this is a DCF, not an LBO.
Sheet previews
How buying works
- Choose a licenceSingle user for one person, team for up to 10, consultancy to use with clients. The buttons above go to the Gumroad page.
- Pay on GumroadCard or PayPal; Gumroad is the merchant of record and handles VAT and the receipt.
- Download the fileThe .xlsx arrives on the receipt page and by email. It opens in Excel and Google Sheets; nothing to install.
- Use itYellow cells are inputs, blue cells are formulas, every figure names its source. Questions: reply to the receipt; every reply is read and answered, usually the same day.
Search terms this page answers: three statement dcf model excel template.