intermediate

Advanced Case Study: Discounted Cash Flow (DCF) Valuation

DCF

The prompt

“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.”

📋 What you're given

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:

  • Building assumptions for revenue growth, costs, and CAPEX
  • Estimating free cash flows (FCFs) and terminal value
  • Choosing the right discount rate (WACC)
  • Performing sensitivity analysis

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. – Case Background

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.


Financial Data and Assumptions

Historical Data (Last 3 Years)

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

  • Revenue Growth: 12% per year
  • EBIT Margin: 22%
  • Depreciation as % of Revenue: 4%
  • CAPEX Growth: 8% per year
  • NWC Investment: Increasing by $5M per year
  • Tax Rate: 25%
  • Risk-Free Rate: 3.5%
  • Equity Risk Premium: 6%
  • Beta: 1.3
  • Cost of Debt: 5.5%
  • Debt Tax Shield: 25% Tax Rate
  • Perpetual growth rate (g): 3%
  • Assuming TechVision's capital structure consists of 70% equity and 30% debt

1. Forecasting Free Cash Flow

Task: Using the assumptions below, project Free Cash Flow (FCF) for the next five years.

Show Formula for Free Cash Flow (FCF)

FCF = EBIT × (1 - Tax Rate) + Depreciation - CAPEX - Change in NWC


2. Calculating Discount Rate (WACC)

Task: Compute TechVision’s Weighted Average Cost of Capital (WACC) using the provided inputs.

Show CAPM Formula for Cost of Equity

Re = Risk-Free Rate + Beta × Market Risk Premium

Show After-Tax Cost of Debt Formula

Rd = Cost of Debt × (1 - Tax Rate)

Show WACC Formula

WACC = (E / (E + D) × Re) + (D / (E + D) × Rd)


3. Terminal Value Calculation

Task: Calculate the Terminal Value (TV):

Show Terminal Value Formula

TV = (FCFfinal year * (1 + g)) / (WACC - g)


4. Discounting Cash Flows to Present Value

Task: Discount the forecasted Free Cash Flows and Terminal Value to present value using WACC.

Show Discounting Formula

PV = FCFt / (1 + WACC)t


5. Sensitivity Analysis

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

💡 Model answer

Try answering out loud first — then reveal the model answer and compare.

⚠️ Common mistakes

  • Treating the terminal growth rate as a minor detail — a 100bp change in g can move Enterprise Value by double digits in percentage terms
  • Using a terminal growth rate that exceeds the long-run GDP or inflation growth rate, which implies the company eventually outgrows the entire economy forever
  • Forgetting that WACC changes affect both the explicit forecast period and the terminal value, which is why WACC sensitivity is usually larger than terminal growth sensitivity
  • Discounting the Terminal Value back using the wrong number of periods (it should be discounted from the end of the explicit forecast period, not from year 1)
  • Ignoring the sensitivity table entirely and presenting a single-point valuation, when interviewers specifically want to see how confident you are in the underlying assumptions

⭐ Rate this case

0 ratings

💬 Comments (0)

No comments yet — be the first to ask a question.

Create free account