DCF Valuation Model (WACC + Sensitivity Tables)

$39 · Excel (.xlsx), works in Google Sheets and Numbers

Etsy title

DCF Valuation Model Excel Template, WACC Build and Sensitivity Tables, Stock Valuation Spreadsheet for Students, Analysts and Investors

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; 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.

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

Etsy tags

• dcf model
• dcf template
• valuation model
• excel finance
• wacc calculator
• stock valuation
• equity research
• finance student
• investment banking
• financial modeling
• sensitivity table
• analyst template
• investing excel

Gumroad description

A complete discounted cash flow valuation model in Excel, with a full CAPM-based WACC build, a five year unlevered free cash flow forecast, Gordon growth and exit multiple terminal values with a one-click method switch, mid-year convention discounting, and two 5x5 sensitivity grids built entirely from formulas rather than Excel's Data Table tool, so they survive sheet protection and conversion to Google Sheets. Every number outside the blue input cells is a live formula tied back to the Inputs tab, and a README explains the workflow, the color legend, and where to source every figure from a 10-K, Yahoo Finance, or Damodaran's data. Built with AI assistance and formula-checked; formulas are fully open, so you can audit or extend every calculation. Ships with a fictional sample company pre-loaded so you can see a finished model on open, then swap in your own company's numbers and watch the WACC, forecast, terminal value, sensitivity tables, and charts all update together.