Week 10: Valuation Section B Focus
Master DCF valuation, multiples method, and M&A analysis for Section B (70 marks, ~95 minutes).
The Valuation Pipeline
1. Free Cash Flow (FCF)
Where:
- EBIT ร (1 โ t) = Unlevered Net Income (tax on operating income)
- Depreciation = Add back (non-cash expense)
- CAPEX = Net Fixed Assetsend โ Net Fixed Assetsbegin + Depreciation
- ฮNWC = NWCend โ NWCbegin where NWC = Current Assets โ Current Liabilities
2. Terminal Value
Method A: TV at year before steady state = FCFsteady / (r โ g), discount back
Method B: TV at steady state = FCFsteady ร (1 + g) / (r โ g), discount one more year
3. Enterprise Value to Equity Value
4. Multiple Valuation Method
Remember: EBITDA = EBIT + Depreciation = Sales โ Costs (before depreciation)
5. Comparable Transaction Method
6. Private Company Discount
When valuing private companies using public comps, apply a liquidity discount (typically 15-30%):
Why? Private companies lack marketability, are smaller, and have less diversified operations than public peers.
FCF Calculator
Practice calculating Free Cash Flow step-by-step:
Terminal Value & Enterprise Value
EV โ Equity Value โ Share Price
EV/EBITDA Multiple Calculator
Enter comparable company multiples (comma-separated):
Merger Premium Calculator
Enter merger premiums from comparable transactions (%):
- Industry and business model
- Size and growth profile
- Geographic exposure
- Risk characteristics
Practice Problems (Exam Style)
Problem 1: Complete DCF Valuation
Given the following data for Year 2014:
- EBIT = $500M, Tax rate = 40%
- Depreciation = $100M
- Net Fixed Assets: Beginning = $1,400M, Ending = $1,500M
- NWC: Beginning = $100M, Ending = $140M
Calculate the FCF for 2014.
Show Solution
Step 1: Unlevered Net Income
EBIT ร (1 โ t) = 500 ร (1 โ 0.40) = 500 ร 0.60 = $300M
Step 2: CAPEX
CAPEX = NFAend โ NFAbegin + Depreciation
= 1,500 โ 1,400 + 100 = $200M
Step 3: Change in NWC
ฮNWC = 140 โ 100 = $40M
Step 4: FCF
FCF = Unlevered NI + Depreciation โ CAPEX โ ฮNWC
= 300 + 100 โ 200 โ 40 = $160M
Problem 2: Terminal Value & Enterprise Value
Using FCFs: 2014 = $160M, 2015 = $256M, 2016 (steady) = $314M
WACC = 8%, Growth rate = 3%, Debt = $600M, Cash = $0
Calculate the share price (40M shares outstanding).
Show Solution
Step 1: Terminal Value (at end of 2015)
TV = FCF2016 / (r โ g) = 314 / (0.08 โ 0.03) = 314 / 0.05 = $6,280M
Step 2: Enterprise Value
EV = FCF2014/(1.08) + (FCF2015 + TV)/(1.08)ยฒ
= 160/1.08 + (256 + 6,280)/1.1664
= 148.15 + 5,603.57 = $5,751.72M
Step 3: Equity Value
Equity Value = EV โ Debt + Cash = 5,751.72 โ 600 + 0 = $5,151.72M
Step 4: Share Price
Share Price = 5,151.72 / 40 = $128.79 per share
Problem 3: Multiple Valuation with Private Discount
WIRK company (private) has EBITDA = โฌ102M, Debt = โฌ323M
Comparable public multiples: 7.1, 8.2, 7.6, 5.9, 5.0
Apply a 25% private company discount.
Calculate the equity value.
Show Solution
Step 1: Average Multiple
Avg = (7.1 + 8.2 + 7.6 + 5.9 + 5.0) / 5 = 33.8 / 5 = 6.76
Step 2: Apply Discount
Discounted Multiple = 6.76 ร (1 โ 0.25) = 6.76 ร 0.75 = 5.07
Step 3: Enterprise Value
EV = EBITDA ร Multiple = 102 ร 5.07 = โฌ517.14M
Step 4: Equity Value
Equity Value = EV โ Debt = 517.14 โ 323 = โฌ194.14M
Note: Seller wants โฌ300M, so this looks like a good deal for the PE buyer!
Problem 4: Assess an Acquisition Offer
CVT offers $128/share for TXA (40M shares). Your analysis shows:
- DCF method: $128.79/share
- Multiple method: $129/share
- Transaction method: $127/share
Is the offer reasonable? What should you conclude?
Show Solution
Analysis:
The offer of $128/share falls within the valuation range of $127โ$129 from all three methods.
Conclusion:
CVT's offer is reasonable from CVT's perspective. The offer:
- Is slightly below the DCF and multiple valuations (good for acquirer)
- Aligns with the comparable transaction approach
- Provides fair value to TXA shareholders while not overpaying
Key exam point: When assessing M&A offers, compare against multiple valuation methods and consider if the offer falls within a reasonable range.
- Write the formula first
- Substitute numbers clearly
- Show calculation steps
- Provide interpretation (this is where 40-50% of marks sit!)
Self-Check Quiz
Test your understanding of key valuation concepts.