DCF
“Valuing a company using Discounted Cash Flow (DCF) analysis is one of the most fundamental yet complex methods in corporate finance. This case study will take you through a full DCF valuation process.”
Try answering out loud first — then reveal the model answer and compare.
The Discounted Cash Flow (DCF) valuation method is a fundamental approach to estimating a company's intrinsic value based on its expected future cash flows. This guide provides a detailed step-by-step solution to the TechVision Inc. valuation case study, ensuring even beginners can understand the concepts of cash flow forecasting, discounting, and financial modeling.
Free Cash Flow (FCF) represents the amount of cash available to a company’s investors after covering operating expenses and capital expenditures (CAPEX). The standard formula for FCF is:
FCF = EBIT × (1 - Tax Rate) + Depreciation - CAPEX - Change in Net Working Capital
Using the assumptions from the case study, let's calculate TechVision Inc.'s projected FCF for the next five years:
| Year | Revenue ($M) | EBIT ($M) | Depreciation ($M) | CAPEX ($M) | Change in NWC ($M) | FCF ($M) |
|---|---|---|---|---|---|---|
| 2024 | 740 | 163 | 30 | (43) | (20) | 110 |
| 2025 | 829 | 182 | 33 | (47) | (25) | 120 |
| 2026 | 928 | 204 | 37 | (51) | (30) | 130 |
| 2027 | 1039 | 229 | 41 | (56) | (35) | 140 |
| 2028 | 1164 | 257 | 47 | (61) | (40) | 150 |
Each year, the free cash flow grows as revenues increase and TechVision efficiently manages costs.
The Weighted Average Cost of Capital (WACC) represents the required return from both debt and equity investors. It accounts for the company’s **cost of equity and cost of debt**, weighted by the proportion of financing sources.
WACC = (E / (E + D) × Re) + (D / (E + D) × Rd × (1 - Tax Rate))
Where:
Re = Risk-Free Rate + Beta × Market Risk Premium
Plugging in the case study values:
Re = 3.5% + (1.3 × 6%) = 11.3%
Assuming TechVision's capital structure consists of 70% equity and 30% debt with a pre-tax cost of debt of 5.5%, WACC is:
WACC = (0.7 × 11.3%) + (0.3 × 5.5% × (1 - 25%)) = 9.2%
Beyond the forecast period, we estimate TechVision’s value using the Gordon Growth Model:
TV = (FCFfinal year * (1 + g))/ (WACC - g)
Assuming:
TV = (140.03 * (1 + 3%)) / (9.2% - 3%) = $2.34622 billion
To determine TechVision’s intrinsic value, we discount all projected cash flows to their present value:
PV = FCFt / (1 + WACC)t
Discounted TV = 2346.22 / (1 + 9.15%) = $1.51461 billion
Summing the discounted values, we calculate:
Enterprise Value (EV) = $1.9405 billion
coming soon
This detailed DCF analysis provides insights into how future cash flows drive intrinsic valuation. By adjusting growth rates, discount rates, and WACC assumptions, investors can refine their estimates and improve decision-making.
Valuing a company using Discounted Cash Flow (DCF) analysis is one of the most fundamental yet complex methods in corporate finance. This case study will take you through a full DCF valuation process, including:
This case study focuses on valuing TechVision Inc., a high-growth technology company, and challenges you to make key assumptions and model different valuation scenarios.
TechVision Inc. is a publicly traded software company providing cloud-based AI analytics. With a consistent annual growth rate of 15%, the company is now being evaluated by a private equity firm for a potential acquisition.
You, as an investment analyst, need to perform a detailed DCF valuation to determine TechVision's intrinsic value and compare it to its current market price.
| Financials ($M) | 2021 | 2022 | 2023 |
|---|---|---|---|
| Revenue | 500 | 575 | 661 |
| EBIT (Operating Profit) | 100 | 120 | 145 |
| Depreciation & Amortization | 20 | 25 | 30 |
| Capital Expenditures (CAPEX) | (30) | (35) | (40) |
| Change in Net Working Capital (NWC) | (5) | (10) | (15) |
| Free Cash Flow (FCF) | 85 | 100 | 120 |
Task: Using the assumptions below, project Free Cash Flow (FCF) for the next five years.
FCF = EBIT × (1 - Tax Rate) + Depreciation - CAPEX - Change in NWC
Task: Compute TechVision’s Weighted Average Cost of Capital (WACC) using the provided inputs.
Re = Risk-Free Rate + Beta × Market Risk Premium
Rd = Cost of Debt × (1 - Tax Rate)
WACC = (E / (E + D) × Re) + (D / (E + D) × Rd)
Task: Calculate the Terminal Value (TV):
TV = (FCFfinal year * (1 + g)) / (WACC - g)
Task: Discount the forecasted Free Cash Flows and Terminal Value to present value using WACC.
PV = FCFt / (1 + WACC)t
Task: Perform a sensitivity analysis by adjusting WACC and Terminal Growth Rate.
| WACC (%) | 2.0% Growth | 2.5% Growth | 3.0% Growth |
|---|---|---|---|
| 8.0% | $85 | $90 | $95 |
| 9.0% | $80 | $85 | $90 |
| 10.0% | $75 | $80 | $85 |