Free DCF Model Template (Excel)
A free, professional discounted cash flow (DCF) model template in Excel, built the way an analyst would. It projects unlevered free cash flow, discounts it with a full CAPM WACC build-up, and values the business with both Gordon-growth and exit-multiple terminal value, returning a low, mid, and high fair-value per share. A WACC-versus-growth sensitivity table and a Conservative, Base, and Optimistic scenario toggle are built in. Ideal for finance students, valuation and CFA study, and investors running their own numbers. Free to download, no sign-up, and the whole workbook is editable.
What's inside
- Unlevered free-cash-flow DCF with a mid-year convention
- CAPM WACC build-up with a regional risk-free and equity-risk-premium lookup
- Terminal value by both Gordon growth and exit multiple
- WACC-versus-growth sensitivity table and a scenario dial
- Fully editable Excel workbook, plus a PDF preview, no sign-up
Frequently asked questions
Is the DCF template free and editable?
Yes. It is a free Excel (.xlsx) download with no sign-up, and the whole workbook is editable except the header band and logo.
Is it good for learning valuation or the CFA?
Yes. It follows standard DCF methodology, from free-cash-flow build to WACC and terminal value, so it doubles as a worked example for valuation and exam study.