DCF Valuation Model (WACC + Sensitivity Tables)
$39 · Excel (.xlsx), works in Google Sheets and Numbers
Buy for $39
Description
Value any public company with a discounted cash flow model built the way a bank analyst builds one, in a spreadsheet you fully control. This Excel template walks from historical financials through a complete WACC build, a five year unlevered free cash flow forecast, terminal value under both the Gordon growth and exit multiple methods, and a bridge to implied share price. Two sensitivity grids stress test that price against WACC, terminal growth, and exit multiple, all built cell by cell with formulas rather than Excel's Data Table feature, so they still work if you protect the sheet or move it into Google Sheets.
Every input lives on one tab in blue font. Every other number on every other tab is a live formula that recalculates the moment you change an input, so dropping in your own company's numbers updates the WACC, the forecast, the terminal value, both sensitivity tables, and both charts at once. A README tab explains the six step workflow, the color coding, and exactly where to pull each input from a 10-K, Yahoo Finance, or Damodaran's published data sets, so you are never guessing which line goes where.
Built with AI assistance and formula-checked. The formulas are fully open. Nothing is hidden, locked, or hardcoded, so you can trace every number back to its source, audit the model, or extend it for your own coursework, stock pitch, or client deck.
The workbook ships with a fictional sample company already filled in, so you can see a finished model before you touch a single cell, then clear the blue cells and replace them with your own company's figures.
Known issue, fix in progress. With the mid-year toggle on, the exit multiple method discounts the terminal value at year 4.5 when it should use year 5. An exit multiple value is measured at the end of year 5 so it takes the full period. On the sample company this overstates the exit-method price by about 4% ($49.46 shown vs about $47.49 correct). The Gordon growth method is not affected. Until the patched file ships you can fix it in one cell: on the DCF tab, when the method selector is set to exit multiple, the terminal value discount period should be the full 5 and not 5 minus the mid-year half. Make the same change in Sensitivity grid 2. Anyone who buys before the fix gets the patched file free by email.
For education and planning only, not financial advice.
What is inside
- README: purpose, six step how-to, color legend, and a sourcing guide for every input
- Inputs: every editable assumption in one place, historical financials, projection drivers, WACC and net debt bridge inputs
- WACC: cost of equity (CAPM plus size premium), after-tax cost of debt, market value weights, and the blended WACC
- DCF: five year unlevered free cash flow build, mid-year convention discounting, terminal value, and the bridge to implied share price
- Sensitivity: two 5x5 formula-driven grids, WACC versus terminal growth and WACC versus exit multiple, shaded where price beats the current quote
- Charts: unlevered free cash flow projection and a min, base, max implied price comparison against the current share price