Single Sheet DCF Template | Free Excel Model, 10-Year
$0.00
Description
A free single sheet DCF template, built by Finwiserr to help you understand how discounted cash flow valuation actually works — all on one clean, transparent Excel sheet.
Most people meet DCF as a black box: numbers go in, an enterprise value comes out, and the machinery in between stays hidden. This template opens the box. It strips discounted cash flow down to its essentials and lays every step out on a single sheet, so you can see exactly how an assumption at the top becomes a valuation at the bottom.
The template is designed with one actual period and ten forecast periods. You change a handful of drivers, and the intrinsic value responds in front of you — which is the fastest way to build real intuition for how a DCF behaves.
What the Single Sheet DCF Template Includes
Everything is driven from a small set of clearly marked inputs. Yellow cells are assumptions; white cells with black text are calculations — so you always know what you can change and what the model is working out for you. The assumptions cover:
| Revenue Growth Rate | The top-line driver for the forecast period |
| EBITDA Margin | Profitability as a percentage of revenue |
| Capital Expenditure | Reinvestment as a percentage of revenue |
| Working Capital | Working capital requirement as a percentage of revenue |
| Depreciation & Amortisation | D&A as a percentage of revenue |
| Discount Rate | The rate used to bring future cash flows to present value |
| Terminal Growth Rate | The perpetual growth assumption behind terminal value |
| Tax Rate | Applied in the move from EBIT to free cash flow |
What the Template Calculates
From those inputs, the single sheet DCF template works through the full DCF chain, step by visible step:
- Free Cash Flow to Firm (FCFF) — using the conventional build, starting from EBIT and adjusting for taxes, depreciation and amortisation, capital expenditure, and the change in working capital
- Discount Rate — applied to bring each year’s FCFF to present value
- Terminal Value — based on a perpetual growth rate
- Enterprise Value — the sum of discounted cash flows and terminal value
- Implied Valuation Multiples — EV/Revenue and EV/EBITDA, so you can sanity-check the output against the market
Test How Sensitive the Value Is
The template lets you calculate the discount rate and perpetual growth rate across three different steps, so you can see directly how a change in either moves terminal value — and how much of the final number depends on assumptions you cannot observe. That single exercise teaches one of the most important lessons in valuation: a DCF is only ever as good as the assumptions feeding it.
Because every calculation sits in plain view, this single sheet DCF template is as much a learning tool as a model. Trace a number back up the sheet and you can see precisely where it came from.
Who This Is For
The single sheet DCF template is built for anyone who learns valuation better by doing than by reading:
- Finance students and graduates learning valuation before an interview or exam
- Analysts new to modelling who want to see the DCF mechanics laid bare
- Founders and business owners getting a first feel for how their business might be valued
- Anyone curious about DCF who learns better by changing inputs than by reading theory
Please note: this single sheet DCF template is built to teach DCF fundamentals and should not be used for valuation in real-world scenarios. To understand the wider method, see this overview of the discounted cash flow method. For a full, sector-specific valuation, see our industry models below.
Ready for the full picture? Explore our industry-specific DCF valuation templates, or talk to us about financial advisory services.
Learn DCF, Free
One actual period, ten forecast years, and the whole DCF chain on a single transparent sheet. Download it and start experimenting.
