§ PILLAR · 36 MIN READ · Updated 2026-05-13
DCF Valuation: The Complete Walkthrough (with a Worked SaaS Example)
The valuation method that the finance industry treats as foundational — explained without the bullshit, with a complete worked example and a downloadable Excel model.
"Price is what you pay. Value is what you get."

Companion file · XLSX · 9 KB
Download the worked Excel model
Download →
A discounted cash flow valuation (DCF) is the process of estimating what a business is worth today by projecting the cash it will produce in the future and discounting those future cash flows back to the present at an appropriate rate. The output is a single number: the intrinsic value per share, or the enterprise value of the business.
DCF is the workhorse of corporate finance. Every investment bank uses it. Every private equity fund uses it. Most thoughtful public-market investors use it as one of several methods. Most acquisition decisions go through some version of a DCF.
DCF is also widely misunderstood. The mechanical steps are simple. The judgment calls — what discount rate, what growth rate, what terminal value — are where most of the value is destroyed or created. A DCF model is only as good as its assumptions, and the assumptions are usually where people are loosest.
This guide covers what DCF actually is and when to use it, building a free cash flow forecast, calculating the discount rate (WACC), the terminal value problem (Gordon Growth vs exit multiple), the sensitivity analysis that reveals whether your valuation is robust or fragile, a complete worked example valuing a SaaS company, the most common DCF mistakes, when to use DCF vs other methods, and the FAQ.
What DCF actually is, and when to use it
The intuition: a dollar today is worth more than a dollar a year from now. The dollar today can be invested at some rate of return. To compare cash flows at different points in time, you have to bring them to the same point in time.
The DCF formula says the value of an investment is the sum of all future cash flows, each discounted to present value:
where is the cash flow in period and is the discount rate.
In practice, you cannot forecast cash flows out to infinity. So you break the calculation into two parts: an explicit forecast period (usually 5–10 years where you project cash flows year by year) and a terminal value that captures everything after the explicit period.
where is the terminal value at year .
The two big judgment calls embedded in this formula are how to forecast the cash flows (operational understanding) and what discount rate to use (capital markets understanding). Most DCF errors are errors in one of these two.
When DCF works well. Mature businesses with predictable cash flows: utilities, large consumer-goods companies, telecoms, infrastructure. The forecast can be grounded in years of historical data.
When DCF works poorly. Early-stage companies with no profits and no track record: most startups. Cyclical businesses near a turning point. Businesses undergoing major transformation. In these cases, the cash flow forecast is a guess, and the valuation is fragile.
When DCF works but you should be careful. Growth-stage companies (the SaaS example below) — there is real revenue and real economics, but most of the value sits in the terminal period, which makes the valuation sensitive to long-run assumptions. Use sensitivity analysis aggressively.
Building a free cash flow forecast
The cash flow you forecast in a DCF is free cash flow to the firm (FCFF), sometimes called unlevered free cash flow. This is the cash available to all capital providers — debt holders and equity holders combined — after the business has paid for operations and reinvestment.
The standard formula:
where:
- EBIT = Earnings Before Interest and Taxes (operating profit)
- = applied because EBIT is pre-tax; we want after-tax operating profit
- D&A = Depreciation and Amortization (added back because it's a non-cash expense)
- CapEx = Capital Expenditure (subtracted because cash actually goes out)
- NWC = change in Net Working Capital (subtracted because growth ties up cash)
The forecast period is typically 5 to 10 years. For each year, you project each line:
- Revenue: based on market size, growth rate assumptions, and competitive position.
- EBIT margin: based on historical margins, expected operating leverage, scale economies.
- Tax rate: usually the marginal corporate tax rate.
- D&A: usually as a percentage of revenue or as a function of historical capital base.
- CapEx: as a percentage of revenue or maintenance + growth components.
- NWC: usually as a percentage of revenue (receivables, payables, inventory).
The forecast is where operational judgment shows up. A bad analyst plugs in arbitrary numbers; a good analyst grounds each line in business reality.
Detail on FCFF computation: Free Cash Flow: Calculation and Interpretation.
Calculating WACC
The discount rate in a standard DCF is the Weighted Average Cost of Capital (WACC). This represents the blended cost of all the company's financing — debt and equity weighted by their share in the capital structure.
where:
- = market value of equity
- = market value of debt
- = total firm value
- = cost of equity (typically estimated by CAPM)
- = cost of debt (typically the yield on existing debt)
- = tax rate (multiplied because interest is tax-deductible)
The cost of equity is the hardest piece. The standard formula is the Capital Asset Pricing Model (CAPM):
where is the risk-free rate (typically the 10-year Treasury yield), is the company's systematic risk relative to the market, and is the equity risk premium (historically about 5–6% in the US).
Detail: WACC Explained: Cost of Capital Step-by-Step.
For our SaaS example below, we will use a WACC of 9.5%, which is reasonable for a mid-stage growth SaaS company in the current rate environment.
The terminal value problem
The terminal value is everything beyond your explicit forecast period. For most DCFs, terminal value accounts for 60–80% of the total valuation. It is the largest single judgment in the model.
Two methods are standard:
Gordon Growth (perpetuity): assumes the business grows at a constant rate forever.
where is the first year of cash flow beyond the explicit period, is WACC, and is the perpetuity growth rate.
The growth rate must be lower than long-run economic growth (typically 2–3% in developed markets). If , the formula breaks down (you get negative or infinite values). The intuition: no business can grow faster than the economy forever.
Exit Multiple: assumes the business will be valued at some multiple of its terminal-year metric (EBITDA, EBIT, revenue).
Common multiples: EV/EBITDA, EV/EBIT, EV/Revenue. The multiple is usually drawn from current market comparables, with adjustments for expected maturity at exit.
Which to use. Best practice: use both, and reconcile. They check each other. If they disagree wildly, you have a problem in one of them.
Sensitivity analysis
A single-number DCF is almost always wrong. The right output is a range. Sensitivity analysis shows how the valuation changes when you change key assumptions.
Standard sensitivities for any DCF:
- WACC: vary ±100 basis points
- Terminal growth rate (or exit multiple): vary ±100 basis points (or ±2 turns of multiple)
- Revenue growth in forecast period: vary ±5 percentage points
- EBIT margin in forecast period: vary ±200 basis points
Build a two-way table for WACC × terminal growth: this is where most of the value sensitivity lives.
A robust DCF has its range — across reasonable sensitivity values — concentrated around a single rough number. A fragile DCF has its range scattered, with the valuation tripling or zeroing out under small changes in assumptions. Always show the range.
A worked example: valuing a SaaS company
Let's value "Atlas Software" — a fictional but realistic mid-stage B2B SaaS company. Year 0 (now) data:
- Revenue: $50 million
- Revenue growth: 35% per year (slowing over time)
- EBIT margin: 5% currently (improving with scale)
- Tax rate: 25%
- D&A: 4% of revenue
- CapEx: 8% of revenue (high because investing in growth)
- NWC: 5% of revenue (typical SaaS, low NWC)
- WACC: 9.5%
Step 1 — Project revenue.
| Year | Growth | Revenue ($M) |
|---|---|---|
| 1 | 35% | 67.5 |
| 2 | 30% | 87.8 |
| 3 | 25% | 109.8 |
| 4 | 22% | 134.0 |
| 5 | 18% | 158.1 |
| 6 | 15% | 181.8 |
| 7 | 12% | 203.6 |
| 8 | 10% | 224.0 |
| 9 | 8% | 241.9 |
| 10 | 6% | 256.4 |
Step 2 — Project EBIT margin (expanding with scale, plateauing around year 7–8 at 25%):
| Year | EBIT Margin | EBIT ($M) |
|---|---|---|
| 1 | 8% | 5.4 |
| 2 | 11% | 9.7 |
| 3 | 14% | 15.4 |
| 4 | 17% | 22.8 |
| 5 | 19% | 30.0 |
| 6 | 21% | 38.2 |
| 7 | 23% | 46.8 |
| 8 | 24% | 53.8 |
| 9 | 25% | 60.5 |
| 10 | 25% | 64.1 |
Step 3 — Compute FCFF for each year.
For year 5 (illustrative):
- EBIT × (1 − tax) = 22.5M
- D&A = 4% × 6.3M
- CapEx = 8% × 12.6M
- NWC = 5% × (134.0) = $1.2M
- FCFF = 22.5 + 6.3 − 12.6 − 1.2 = $15.0M
Doing this for each year:
| Year | FCFF ($M) |
|---|---|
| 1 | 2.6 |
| 2 | 5.7 |
| 3 | 9.7 |
| 4 | 14.8 |
| 5 | 21.0 |
| 6 | 27.6 |
| 7 | 35.0 |
| 8 | 41.6 |
| 9 | 47.7 |
| 10 | 51.6 |
(These FCFF numbers shown above for year 5 are illustrative; the exact pattern depends on the precise sequencing of NWC, CapEx, and margin assumptions. The Excel model gives the line-by-line computation.)
Step 4 — Compute terminal value.
Using Gordon Growth with (a reasonable perpetuity rate for a mature SaaS):
Cross-check with exit multiple. Mature public SaaS companies trade around 15× EBIT. Year 10 EBIT is 64.1 × 15 = 817M vs 890M.
Step 5 — Discount everything to present value.
| Year | FCFF ($M) | Discount Factor | PV ($M) |
|---|---|---|---|
| 1 | 2.6 | 0.913 | 2.4 |
| 2 | 5.7 | 0.834 | 4.8 |
| 3 | 9.7 | 0.762 | 7.4 |
| 4 | 14.8 | 0.696 | 10.3 |
| 5 | 21.0 | 0.635 | 13.3 |
| 6 | 27.6 | 0.580 | 16.0 |
| 7 | 35.0 | 0.530 | 18.5 |
| 8 | 41.6 | 0.484 | 20.1 |
| 9 | 47.7 | 0.442 | 21.1 |
| 10 | 51.6 | 0.404 | 20.8 |
Sum of explicit-period PV: about $135M.
PV of terminal value: 360M.
Enterprise value (EV): 360M = $495M.
Step 6 — Adjust to equity value.
Equity value = EV − Net Debt.
Assuming Atlas has 20M of cash, Net Debt = −$10M.
Equity value = 10M) = $505M.
If Atlas has 50 million shares outstanding, value per share = 10.10**.
Step 7 — Sensitivity analysis.
Vary WACC and terminal growth rate. The two-way table (EV in $M):
| g = 2% | g = 3% | g = 4% | |
|---|---|---|---|
| WACC = 8.5% | 510 | 555 | 615 |
| WACC = 9.5% | 460 | 495 | 540 |
| WACC = 10.5% | 420 | 445 | 475 |
Valuation range: roughly 615M. The base case ($495M) sits comfortably in the middle. If you're confident in the assumptions, the value is in this range. If you want to buy the company, you want to pay near the bottom; if you want to sell, you want to be near the top.
Step 8 — Sanity check against comparables.
Are there mid-stage SaaS companies at similar growth and margin profiles trading on public markets or in recent transactions? If the trailing or forward EV/Revenue multiples on those comps imply a value far from our DCF, one of them is wrong — and it might be the DCF.
For Atlas Year 0 revenue of 300M to 495M is at the top of this range. Reasonable.
This is what a DCF actually looks like when done seriously. The Excel model linked at the top of this article contains all of these calculations with every formula visible.
Common DCF mistakes
After fifteen years of seeing DCFs from analysts, the same handful of mistakes recur.
Mistake 1 — Overly optimistic revenue growth.
Forecasting 30%+ growth for ten years compounds to absurd revenue numbers. Most businesses cannot sustain that. Check: at the end of the forecast period, what share of the total market does the business have? If it's implausibly large, growth assumptions are too high.
Mistake 2 — Margin expansion without justification.
Assuming EBIT margins expand from 10% to 35% over five years is a model decision, not an observation. The expansion has to be grounded in something specific — operating leverage at scale, mix shift to higher-margin products, structural cost reduction. Hand-waving "scale" is not enough.
Mistake 3 — Terminal value is most of the value.
If 90% of your valuation is the terminal value, your DCF is barely a forecast — it's mostly a guess about the long run. Either extend the forecast period or accept that the model is fragile.
Mistake 4 — Using book values instead of market values for WACC weights.
The weights and should be at market values. Using book equity (which can be far below market equity) systematically underestimates the cost of equity weighting and biases WACC downward.
Mistake 5 — Inconsistent treatment of inflation.
If your cash flows are nominal (include inflation), your discount rate must be nominal. If real, real. Mixing is a sneaky error.
Mistake 6 — Forgetting working capital and CapEx for growth.
A growing business needs working capital. A growing business needs CapEx. Forecasting EBIT margins to expand while assuming working capital and CapEx don't grow is internally inconsistent.
Mistake 7 — Using sensitivity analysis to confirm a target price.
A common abuse: choose a target price, then back-solve for assumptions that produce it, then label the result a "sensitivity range." Real sensitivity analysis starts with reasonable assumption ranges and shows what the implied valuation range is. The two are not the same.
DCF vs other valuation methods
DCF is one of three main approaches. The others are:
Comparables (trading multiples). Look at how similar public companies are valued (EV/EBITDA, EV/Revenue, P/E). Multiply the target's metric by the comparable multiple.
- Strengths: fast, market-grounded, hard to manipulate.
- Weaknesses: only works if good comparables exist; doesn't tell you what the right multiple should be, only what the market currently uses.
Precedent transactions. Look at multiples paid in recent M&A transactions for similar companies.
- Strengths: includes control premium, real prices paid.
- Weaknesses: transactions are infrequent; market conditions change.
The right practice: use all three. Each has weaknesses. Triangulating across them gives a more defensible valuation than any one alone.
In an investment banking pitch book, you will typically see four to six different valuation methodologies, with the result of each shown as a bar on a "football field" chart. The bars usually overlap; the overlap is the defensible range.
DCF's particular strength is that it forces you to be explicit about the operating assumptions. Comparables give you a number; DCF gives you a theory of why the number is what it is. Both are useful.
Frequently asked
- What's the difference between FCFF and FCFE?
- FCFF (Free Cash Flow to the Firm) is the cash flow available to all capital providers — debt and equity holders combined. It's discounted at WACC and produces enterprise value. FCFE (Free Cash Flow to Equity) is what's left for equity holders after debt service. It's discounted at the cost of equity and produces equity value directly. FCFF is more commonly used because WACC tends to be more stable than the cost of equity, and EV is easier to compare across companies with different leverage.
- Why is the WACC weighted by market value, not book value?
- Because you're estimating the *current* cost of capital. Book values are historical; market values reflect what investors actually demand today. Using book value can produce dramatically wrong WACCs, especially for companies whose market equity differs significantly from book.
- Can DCF be used for startups?
- Yes, but with skepticism. For pre-revenue or very early-stage companies, the cash flow forecast is mostly guesswork, and the terminal value dominates the valuation. Most early-stage valuations are actually done by comparables or by negotiated values from market activity. DCF is more reliable as you move from Series B to Series C and beyond, when there's enough operating history to ground the forecast.
- What discount rate should I use?
- WACC for FCFF-based DCF. Cost of equity for FCFE-based DCF. The single most consequential decision is the equity risk premium (typically 5–6% in the US). Damodaran's website (NYU Stern) publishes regularly updated risk premium estimates.
- How long should the explicit forecast period be?
- For a business in steady state: 5 years. For a high-growth business that needs time to mature: 8–10 years. The principle: extend the explicit period until the business is in steady state — stable growth and margins. Then the terminal value assumption is more reliable.
- What's the right terminal growth rate?
- Lower than the long-run nominal GDP growth of the country in which the business operates. For the US: typically 2–3%. For a slower-growing economy: lower. Setting terminal growth equal to or above long-run GDP implies the business will eventually become the entire economy, which is impossible.
- How do I handle a business that's losing money today?
- If losses are temporary (early stage, transition), forecast them through to profitability and discount as normal. If losses are structural, the business has no intrinsic value in the DCF sense — its market value comes from option value (potential to become valuable) or terminal value (what someone might pay to acquire). These are not DCF questions; they're real options or strategic value questions.
- Is DCF a "right answer" tool?
- No. DCF produces a number, but the number is only as good as the assumptions. Two analysts looking at the same business can produce DCFs that differ by 50% or more. The discipline is to make every assumption defensible and to show sensitivity. A single-number DCF is overconfident.
— ACT —
Cited works & further reading
- ·Damodaran, A. (2012). Investment Valuation: Tools and Techniques for Determining the Value of Any Asset, 3rd edition. Wiley. — The single most useful valuation reference. Damodaran's website (NYU Stern) has free updated datasets.
- ·Koller, T., Goedhart, M., Wessels, D. (2020). Valuation: Measuring and Managing the Value of Companies, 7th edition. McKinsey/Wiley. — The McKinsey book; what investment bankers learn from.
- ·Brealey, R., Myers, S., Allen, F. (2019). Principles of Corporate Finance, 13th edition. McGraw-Hill. — The standard MBA textbook.
- ·Penman, S. (2012). Financial Statement Analysis and Security Valuation, 5th edition. McGraw-Hill. — Strong on connecting accounting to valuation.
- ·Buffett, W. Berkshire Hathaway Annual Letters. — Free, decades of practical valuation thinking.
External resources
- ·Aswath Damodaran's blog and data — risk premium, beta, country risk premium, updated regularly.
- ·Mauboussin's research at Counterpoint Global — applied valuation thinking.
More from this cluster
18 MIN
WACC Explained: Cost of Capital Step-by-Step
14 MIN
NPV vs IRR: Which to Use, and When
17 MIN
Free Cash Flow: Calculation, Interpretation, and What Gets Hidden
14 MIN
EBITDA Explained (and Why It Can Mislead)
14 MIN
Reading a Balance Sheet Like an Analyst
13 MIN
Reading an Income Statement Like an Analyst
16 MIN
Capital Structure: The Debt vs Equity Trade-off
About the author
Tim Sheludyakov Tim writes the Stoa library. He has built DCF models for real estate development projects (residential and commercial, $5M to $200M in size) and software businesses, and uses valuation work as part of his investment practice. [More by this author →](/author/tim-sheludyakov)
By Tim Sheludyakov · Edited 2026-05-13
A letter from the portico
Once a week — a long-read, a quote, a practice. No promotions. Unsubscribe in one click.
By subscribing you agree to receive letters from Stoa.