DCF Valuation Explained: How to Value a Company Using Discounted Cash Flow
Every serious investor, investment banker, and corporate finance professional needs to answer one fundamental question: what is this company actually worth? Not what the market says it's worth today, but what it is intrinsically worth based on the cash it will generate over its lifetime. Discounted Cash Flow (DCF) valuation is the framework that answers this question - and it is the gold standard of company valuation for exactly that reason.
A DCF valuation forces you to be explicit about your assumptions. You must forecast how much cash the business will generate, how much risk those cash flows carry, and how the business will behave beyond your forecast horizon. This explicitness is both the strength and the challenge of DCF: it produces a defensible, assumption-driven value estimate, but every output is only as good as the inputs that drive it. Understanding both how to build a DCF and what its limitations are is what makes the difference between an analyst who uses valuation as a tool and one who treats it as a black box.
This guide walks through every component of a DCF model - free cash flow projection, WACC calculation, terminal value methods, the bridge from enterprise value to equity value, and sensitivity analysis - with complete Excel formulas and practical implementation notes. For context on how DCF fits into the broader financial analysis toolkit, Board Infinity's Personal Finance and Investment Planning guide covers the investment principles that underpin valuation decisions.
Who This Guide Is For
This guide is for you if you:
- Are a finance student or early-career analyst learning valuation from scratch
- Have seen DCF mentioned in financial modeling courses but want a complete, formula-level walkthrough
- Are preparing for investment banking, equity research, or corporate finance interviews where DCF is always tested
- Want to value a company yourself and need a structured methodology
- Are interested in how real firms like Colliers use DCF in practice - Board Infinity's Colliers Financial Analyst guide shows DCF applied to real estate acquisition decisions
1. What Is Intrinsic Value?
The central premise of DCF valuation is the time value of money: a dollar received today is worth more than a dollar received in the future because today's dollar can be invested and earn a return. Intrinsic value is the present value of all future cash flows a business will generate, discounted back to today at a rate that reflects the risk of those cash flows.
This stands in contrast to relative valuation (comparing a company to its peers using multiples like EV/EBITDA) which tells you what the market is paying, not what the business is inherently worth. DCF and comparables are complementary - most professional valuations use both and triangulate between the two. Board Infinity's Introduction to Equity Investing guide explains how these valuation principles apply to equity investment decisions.
The DCF formula at its simplest:
Intrinsic Value = PV of Forecast Period Cash Flows + PV of Terminal Value
Where PV (present value) means each future cash flow is divided by (1 + discount rate)^n, where n is the number of years until that cash flow is received.
| Valuation Method | What It Measures | Strength | Weakness |
|---|---|---|---|
| DCF (Intrinsic) | Present value of future cash flows | Fundamental - not dependent on market conditions | Highly sensitive to assumptions - small changes = large impact |
| Comparable Companies | Market multiples vs peers (EV/EBITDA, P/E) | Market-based - reflects current investor sentiment | Only as good as the comparable set - markets can be wrong |
| Precedent Transactions | Acquisition multiples paid in similar deals | Reflects control premium - relevant for M&A | Deal conditions vary - stale data in low-volume sectors |
2. Projecting Free Cash Flows (FCF)
Free Cash Flow (FCF) is the cash a business generates after investing the capital needed to maintain and grow its operations. It is the cash that is genuinely available to all capital providers - both debt and equity holders - which is why DCF uses unlevered FCF (also called Free Cash Flow to Firm, or FCFF) rather than net income.
The formula: FCF = EBIT × (1 - Tax Rate) + D&A - Capex - Change in Working Capital
Breaking this down:
- EBIT × (1 - Tax Rate) = NOPAT (Net Operating Profit After Tax) - tax-adjusted operating profit, removing the impact of debt financing to keep the cash flow unlevered
- + D&A - depreciation and amortization are non-cash charges; they reduced EBIT but no cash actually left the business, so we add them back
- - Capex - capital expenditure is real cash leaving the business to maintain and grow assets - not captured in net income directly
- - Change in Working Capital - increases in accounts receivable or inventory consume cash; increases in accounts payable free up cash
// === ASSUMPTIONS TAB (all blue - hardcoded inputs) === Revenue_Growth_Rate = 12% // Year 1-3; taper to 8% Y4-5 EBIT_Margin = 18% // % of revenue Tax_Rate = 25% DA_Percent = 4% // D&A as % of revenue Capex_Percent = 5% // Capex as % of revenue WC_Percent = 8% // Working capital as % of revenue // === FCF SCHEDULE (one column per year: Y1 through Y5) === Revenue_Y1 = Revenue_Prior * (1 + Revenue_Growth_Rate) // Repeat for Y2-Y5 with tapering growth rate EBIT_Y1 = Revenue_Y1 * EBIT_Margin NOPAT_Y1 = EBIT_Y1 * (1 - Tax_Rate) // tax-adjusted EBIT DA_Y1 = Revenue_Y1 * DA_Percent // add back - non-cash Capex_Y1 = -(Revenue_Y1 * Capex_Percent) // cash outflow - negative // Change in Working Capital = (WC_Y1 - WC_Y0) // WC = Current Assets - Current Liabilities (approx = Revenue * WC%) WC_Y1 = Revenue_Y1 * WC_Percent WC_Y0 = Revenue_Y0 * WC_Percent Delta_WC_Y1 = -(WC_Y1 - WC_Y0) // increase in WC = cash outflow FCF_Y1 = NOPAT_Y1 + DA_Y1 + Capex_Y1 + Delta_WC_Y1 // Repeat formula for Y2 through Y5 // FCF typically grows as revenue grows and margins stabilize // === SAMPLE OUTPUT === // Year: Y1 Y2 Y3 Y4 Y5 // Revenue: $112M $125M $140M $152M $164M // FCF: $18M $22M $27M $30M $33M
Most beginners apply a single, constant revenue growth rate across all 5 forecast years. Real analysts taper: higher growth in early years (when momentum is strongest) declining toward a more sustainable rate by Year 5. A SaaS company growing at 30% today doesn't grow at 30% for 5 years straight. A common pattern: 25% - 22% - 18% - 14% - 10%, with the Year 5 rate roughly aligned with the terminal growth rate assumption. Flat growth rates produce overconfident outputs that experienced analysts spot immediately.
3. Calculating the Discount Rate (WACC)
The discount rate in a DCF model is the Weighted Average Cost of Capital (WACC). It represents the average return required by all capital providers - both equity investors and debt holders - weighted by their proportion in the capital structure. It's the rate at which future cash flows are discounted to present value: a higher WACC means future cash flows are worth less today, producing a lower valuation.
WACC has two components: the cost of equity (calculated using the Capital Asset Pricing Model, or CAPM) and the after-tax cost of debt.
WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))
Where E = market value of equity, D = market value of debt, V = E + D.
Understanding the risk-reward relationship that underlies WACC is fundamental to DCF - Board Infinity's Introduction to Goal Setting and Risk Profiling explains how risk tolerance and required returns interact, which is the conceptual foundation of the discount rate.
// === COST OF EQUITY (CAPM) === Risk_Free_Rate = 4.5% // 10-year US Treasury yield (current) Equity_Risk_Premium = 5.5% // Damodaran estimate for US market Beta = 1.2 // from Bloomberg or comparable company average // Beta > 1 = more volatile than market, Beta < 1 = less volatile Cost_of_Equity = Risk_Free_Rate + (Beta * Equity_Risk_Premium) Cost_of_Equity = 4.5% + (1.2 * 5.5%) = 11.1% // === COST OF DEBT === Pre_Tax_Cost_of_Debt = 6.0% // from credit rating or company's interest rate Tax_Rate = 25% After_Tax_Cost_of_Debt = Pre_Tax_Cost_of_Debt * (1 - Tax_Rate) After_Tax_Cost_of_Debt = 6.0% * (1 - 0.25) = 4.5% // Interest is tax deductible - so debt is cheaper than equity on after-tax basis // === CAPITAL STRUCTURE WEIGHTS === Market_Cap = $800M // equity market value (shares * price) Total_Debt = $200M // from balance sheet Total_Capital = $1,000M Weight_Equity = $800M / $1,000M = 80% Weight_Debt = $200M / $1,000M = 20% // === WACC === WACC = (80% * 11.1%) + (20% * 4.5%) WACC = 8.88% + 0.90% = 9.78% // Round to 10% for sensitivity analysis purposes // Typical WACC range: 8-12% for stable public companies // Higher WACC: more risk, emerging markets, smaller companies
WACC should be calculated using the company's target capital structure - what the debt/equity mix will look like over the long term - not necessarily the current balance sheet. A company that is temporarily over-leveraged due to an acquisition will move toward a more normal structure over time. Using the current (distorted) debt ratio overstates the weight of cheap after-tax debt and understates WACC, producing an inflated valuation. Use peer company averages or management guidance on target leverage when the current structure looks anomalous.
4. Terminal Value: Perpetuity Growth vs Exit Multiple
The terminal value represents the value of all cash flows beyond the explicit 5-year forecast period. It's the most important - and most debated - component of a DCF because it typically represents 60-80% of the total enterprise value. This means your choice of terminal value method and assumptions has an outsized impact on the final output.
There are two standard approaches.
Perpetuity Growth Model (Gordon Growth Model) assumes the business grows at a constant rate forever beyond Year 5. It's theoretically rigorous but highly sensitive to the growth rate assumption - even a 0.5% change can move the enterprise value by 10-15%.
Exit Multiple Method assumes the business is sold at the end of the forecast period at a multiple of its EBITDA (or EBIT, or revenue) consistent with what comparable companies trade at today. It's more market-anchored but introduces circular reasoning - you're embedding market assumptions into an intrinsic valuation.
Best practice: calculate both methods and triangulate. If they produce significantly different values, investigate why - usually it reveals an inconsistency in your assumptions. This same triangulation principle between valuation methods is applied in professional contexts like Goldman Sachs - as shown in Board Infinity's Goldman Sachs GBM Private Summer Analyst guide.
// === METHOD 1: PERPETUITY GROWTH MODEL (Gordon Growth) === FCF_Y5 = $33M // last year of explicit forecast Terminal_Growth_Rate = 2.5% // long-run nominal GDP growth rate WACC = 10.0% // Terminal Value = FCF_Y5 * (1 + g) / (WACC - g) Terminal_FCF = FCF_Y5 * (1 + Terminal_Growth_Rate) Terminal_FCF = $33M * 1.025 = $33.8M Terminal_Value_GGM = Terminal_FCF / (WACC - Terminal_Growth_Rate) Terminal_Value_GGM = $33.8M / (10.0% - 2.5%) Terminal_Value_GGM = $33.8M / 7.5% = $451M // Discount Terminal Value back to today (it's a Year 5 value) PV_Terminal_Value = Terminal_Value_GGM / (1 + WACC)^5 PV_Terminal_Value = $451M / (1.10)^5 = $451M / 1.611 = $280M // === METHOD 2: EXIT MULTIPLE METHOD === EBITDA_Y5 = $45M // from income statement forecast Exit_EV_EBITDA_Multiple = 8.5x // based on current comparable company trading multiples Terminal_Value_EMM = EBITDA_Y5 * Exit_EV_EBITDA_Multiple Terminal_Value_EMM = $45M * 8.5 = $382M PV_Terminal_Value_EMM = Terminal_Value_EMM / (1 + WACC)^5 PV_Terminal_Value_EMM = $382M / 1.611 = $237M // === SANITY CHECK === // GGM implies TV of $280M - EMM implies TV of $237M // ~15% gap is acceptable - triangulate to midpoint $258M // Large gaps (>30%) suggest inconsistency - re-examine assumptions
The perpetuity growth formula TV = FCF × (1+g) / (WACC - g) only works when g is strictly less than WACC. If g equals WACC, you divide by zero - the formula breaks. If g exceeds WACC, you get a negative terminal value, which makes no economic sense. In practice, the terminal growth rate should never exceed the long-run nominal GDP growth rate of the country the company operates in - typically 2-3% for developed markets. Companies do not grow faster than the economy forever; if your model implies they do, your terminal value assumption is wrong.
5. Calculating Enterprise Value and Equity Value
Once you have the present value of the forecast period cash flows and the present value of the terminal value, calculating enterprise value is straightforward addition. Getting from enterprise value to equity value - the value that belongs specifically to shareholders - requires the "bridge" that adjusts for the claims of debt holders and other non-equity stakeholders. Understanding these distinctions is key for investment decision-making, which Board Infinity's Comprehensive Guide to Investing and Insurance addresses from the investor's perspective.
// === STEP 1: SUM PRESENT VALUES === PV_FCF_Y1 = FCF_Y1 / (1 + WACC)^1 = $18M / 1.10 = $16.4M PV_FCF_Y2 = FCF_Y2 / (1 + WACC)^2 = $22M / 1.21 = $18.2M PV_FCF_Y3 = FCF_Y3 / (1 + WACC)^3 = $27M / 1.33 = $20.3M PV_FCF_Y4 = FCF_Y4 / (1 + WACC)^4 = $30M / 1.46 = $20.5M PV_FCF_Y5 = FCF_Y5 / (1 + WACC)^5 = $33M / 1.61 = $20.5M Sum_PV_FCF = $16.4 + $18.2 + $20.3 + $20.5 + $20.5 = $95.9M PV_Terminal_Value = $258M // midpoint from GGM and EMM // === STEP 2: ENTERPRISE VALUE === Enterprise_Value = Sum_PV_FCF + PV_Terminal_Value Enterprise_Value = $95.9M + $258M = $353.9M // Enterprise Value = value of the entire business (debt + equity) // === STEP 3: EQUITY VALUE BRIDGE === Enterprise_Value = $353.9M Less_Total_Debt = ($200M) // debt holders' claim - subtract Add_Cash = $25M // cash reduces net debt - add back Less_Minority_Interest = ($10M) // if applicable - subtract Equity_Value = $353.9M - $200M + $25M - $10M = $168.9M // === STEP 4: IMPLIED SHARE PRICE === Shares_Outstanding = 15M Implied_Share_Price = Equity_Value / Shares_Outstanding Implied_Share_Price = $168.9M / 15M = $11.26 per share // Compare to current trading price // If market price = $9.50: stock appears undervalued by ~18% // If market price = $14.00: stock appears overvalued by ~20%
6. Sensitivity Tables: Testing Your Assumptions
A DCF model produces a single implied value - but that single value is the output of one specific set of assumptions. Presenting a point estimate without showing how it changes under different assumptions is intellectually dishonest and practically useless. Sensitivity tables make the uncertainty visible and give decision-makers the range of outcomes they actually need. This approach to scenario testing mirrors what investment banking professionals apply daily - as Board Infinity's Goldman Sachs GIR Summer Analyst guide shows, quantifying outcome ranges under different assumptions is a core analyst deliverable.
The two most important sensitivity dimensions in any DCF are WACC and terminal growth rate - because these two assumptions together drive the terminal value which dominates the valuation.
// === SETUP IN EXCEL === // 1. Place your Implied_Share_Price formula in the top-left corner cell of the table // 2. Down the LEFT COLUMN: range of WACC values // 3. Across the TOP ROW: range of Terminal Growth Rates // 4. Select entire table range (including the formula cell) // 5. Data > What-If Analysis > Data Table // Row input cell: = your Terminal_Growth_Rate assumption cell // Column input cell: = your WACC assumption cell // Excel calculates every combination automatically // === SAMPLE OUTPUT: Implied Share Price === // 1.5% 2.0% 2.5% 3.0% 3.5% (Terminal Growth Rate) // 8.0% WACC $14.8 $16.2 $18.1 $20.5 $23.8 // 9.0% WACC $12.6 $13.6 $14.9 $16.6 $18.9 // 10.0% WACC $10.8 $11.5 $12.4 $13.6 $15.2 <-- base case // 11.0% WACC $9.3 $9.8 $10.5 $11.4 $12.5 // 12.0% WACC $8.1 $8.5 $9.0 $9.7 $10.6 // Color-code the table using conditional formatting: // Green: prices > current market price (upside) // Red: prices < current market price (downside) // This makes the range of outcomes immediately readable // === SECOND SENSITIVITY: WACC vs Revenue Growth Rate === // Build a second table showing EV or Share Price across: // WACC (rows): 8% to 12% // Revenue Growth (columns): 8% to 20% // Reveals: how sensitive is this valuation to revenue assumptions vs discount rate?
Most DCF sensitivity tables vary WACC and terminal growth rate. That's necessary - but it's not sufficient. Revenue growth rate is often the single most impactful assumption in the forecast period, especially for high-growth companies where cash flows are small today but large in the future. Build a second sensitivity table with WACC on one axis and revenue growth rate on the other. If your valuation changes dramatically across reasonable revenue growth scenarios, that's the key risk to flag in any investment memo or presentation.
7. Limitations of DCF and When Not to Use It
DCF is the gold standard of valuation - but it's not the right tool for every situation. Knowing when to use it, when to supplement it, and when to abandon it in favor of alternative methods is a mark of analytical maturity. Board Infinity's Mastering Investment Banking guide covers how experienced practitioners combine valuation methods depending on context.
| Situation | DCF Suitability | Better Alternative |
|---|---|---|
| Stable, cash-generative business | Excellent - FCF is predictable and meaningful | DCF is primary; verify with comps |
| Pre-revenue startup | Poor - no historical FCF to anchor assumptions | Venture Capital method, revenue multiples |
| Cyclical industry (mining, oil) | Risky - FCF varies wildly with commodity prices | Normalized earnings DCF or NAV for resources |
| Financial institutions (banks) | Poor - debt is an operating input, not financing | Dividend Discount Model, P/B ratio analysis |
| Distressed company | Limited - going concern assumption may not hold | Liquidation analysis, recovery rate models |
| M&A target valuation | Good - combined with precedent transaction comps | DCF + Accretion/Dilution analysis |
The biggest danger of DCF is false precision. A spreadsheet produces a share price to two decimal places - $11.26 - which looks authoritative. But that $11.26 is entirely dependent on assumptions about revenue growth, margins, WACC, and terminal growth that carry enormous uncertainty. Experienced analysts present DCF outputs as ranges - not point estimates. Always show the sensitivity table alongside the base case. And always triangulate with at least one market-based method (comparable companies or precedent transactions). A DCF without a sanity check is a story you told yourself about the future.
Further Reading
Board Infinity Guides:
- Colliers Financial Analyst - Real Estate Interview Guide
- Goldman Sachs GBM Private Summer Analyst Interview Guide
- Goldman Sachs GIR Summer Analyst Interview Guide
- Introduction to Banking: A Beginner's Essential Guide
- Personal Finance and Investment Planning
- Introduction to Equity Investing
- Mastering the Art of Investment Banking
- A Comprehensive Guide to Investing and Insurance
- Introduction to Goal Setting and Risk Profiling
External Resources:
- Damodaran Online - Valuation Tools and Data
- Investopedia - Discounted Cash Flow (DCF)
- Corporate Finance Institute - DCF Model Training
Master Financial Analysis & Modeling Fundamentals on Coursera
This free Coursera course by Board Infinity applies every DCF concept in this guide through a structured, 16-hour curriculum. Build integrated 3-statement models, calculate WACC from scratch, implement multi-stage DCF models, run sensitivity and scenario analysis - all through hands-on project milestones.
✓ Certificate available · ✓ Self-paced · ✓ 16 hours of structured content
Conclusion
DCF valuation is the most rigorous and most defensible framework for answering "what is this company worth?" - because it forces you to be explicit about every assumption that drives the answer. A company is worth the present value of its future free cash flows, discounted at a rate that reflects the risk of those cash flows. This simple principle, implemented through FCF projection, WACC calculation, terminal value estimation, and the enterprise-to-equity bridge, produces a valuation you can defend assumption by assumption.
The most important discipline in DCF work is not mathematical - it's epistemic. A DCF should never produce a single confident answer. It should produce a range of outcomes across a sensitivity table, validated against at least one market-based method, with every assumption documented and defensible. The difference between an analyst who produces a DCF and an analyst who produces a useful DCF is exactly this: one builds a model, the other builds an argument.
From here, the natural extensions are comparable company analysis (the market-based counterpart to DCF), LBO modeling (DCF applied to leveraged buyout scenarios), and precedent transaction analysis. Board Infinity's course on financial analysis and modeling fundamentals covers all of these through a structured, project-based curriculum that takes you from three-statement modeling through full DCF and comparables - the complete valuation toolkit for any analyst role.