Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Document preview thumbnail
Preview 3 out of 24 pages
Exam (elaborations)

Discounted Cash Flow Model Exam Wall Street Prep QUESTIONS AND ANSWERS GRADED A+ GUARANTEED PASS Mergers and acquisitions (Erasmus Universiteit Rotterdam)

Document preview thumbnail
Preview 3 out of 24 pages

Discounted Cash Flow Model Exam Wall Street Prep QUESTIONS AND ANSWERS GRADED A+ GUARANTEED PASS Mergers and acquisitions (Erasmus Universiteit Rotterdam) Income statement 0 1 2 3 Assumptions Sales Costs 300.0 (200.0) 306.0 (204.0) 312.1 (208.1) 318.4 (212.2) EBIT Operating taxes 100.0 (30.0) 102.0 (30.6) 104.0 (31.2) 106.1 (31.8) Sales growth Perpetual growth Costs / Sales Invested capital / Sales 1 | P a g e 2 | Page 2 NOPLAT 70.0 71.4 72.8 74.3 Debt / Sales Interest (9.8) (10.0) (10.2) (10.4) Tax rate Tax shield 2.9 3.0 3.1 3.1 Interest rate Net income 63.1 64.4 65.7 67.0 Balance sheet 0 1 2 3 WACC Invested capital 300.0 306.0 312.1 318.4 Risk free rate Spread on debt Debt 200.0 204.0 208.1 212.2 k(D) Equity 100.0 102.0 104.0 106.1 Sources 300.0 306.0 312.1 318.4 Risk free rate Market risk premium Cash flows 0 1 2 3 Industry beta unlevered NOPLAT 71.4 72.8 74.3 Net investments (Delta IC) (6.0) (6.1) (6.2) Enterprise value (market value) FCFO 65.4 66.7 68.0 Debt (market value) Interests (10.0) (10.2) (10.4) Equity (market value) Tax shield 3.0 3.1 3.1 ND / E Debt issues 4.0 4.1 4.2 ND / (ND + E) Total CF to shareholders 62.4 63.6 64.9 E / (ND + E) No cash into net debt because cash is distributed to shareholders Beta relevered k(E)(L) To achieve APV and DCF equivalence: - Need to link WACC to market value of equity WACC - Need to compute tax shields on beginning-of-period debt - Need to keep a constant growth rate, because otherwise k(E)( U) there is a mismatch in growth of the components of APV and DCF 3 | Page 3 2.0% 2.0% 2.0% 2.0% FCFO 65.4 2.0% Continuing value @ FCFO perpetuity 66.7% 66.7% 66.7% 66.7% Continuing value @ Key Value Driver 100.0% 100.0% 100.0% 100.0% 66.7% 66.7% 66.7% 66.7% Discount factor @ WACC 0.92 30.0% 30.0% 30.0% 30.0% Discounted FCFO 59.9 5.0% 5.0% 5.0% 5.0% NOPLAT 71.4 3.0% Initial IC 300.0 2.0% ROIC 23.8% 5.0% Economic profit 44.1 Continuing value - First component 3.0% Continuing value - Second component 5.0% 1.200 Discount factor @ WACC 0.92 Discounted EP 40.4 Invested capital 300.0 200.0 Enterprise value 920.0 720.0 27.8% 21.7% FCFO 65.4 78.3% Continuing value of FCFO Tax shield 3.0 1.533 Continuing value of tax shields 10.7% Discount factor @ k(E)(U) 0.91 9.1% Discounted FCFO 59.8 Discounted TS 2.7 9.4% Unlevered value 879.6 Value of tax shields 40.4 Enterprise value 920.0 0 1 2 3 CV DCF 0 1 Enterprise value 920.0 Economic Profit 0 1 Adjusted present value 0 1 920.0 4 | Page 4 2 3 CV 66.7 68.0 976.3 976.3 0.84 0.77 0.77 56.0 52.4 751.6 2 3 CV 72.8 74.3 306.0 312.1 318.4 23.8% 23.8% 45.0 45.9 513.5 144.5 0.84 0.77 0.77 37.8 35.3 506.5 2 3 CV 66.7 3.1 68.0 3.1 933.5 42.8 0.84 0.76 0.76 55.7 51.9 712.3 2.6 2.4 32.7 Mergers and Acquisitions Final exam format:

Content preview

1




Discounted Cash Flow
Model Exam Wall Street
Prep QUESTIONS AND
ANSWERS GRADED
A+ GUARANTEED
PASS


Mergers and acquisitions (Erasmus Universiteit Rotterdam)




Income statement 0 1 2 3 Assumptions
Sales 300.0 306.0 312.1 318.4 Sales growth
Costs (200.0) (204.0) (208.1) (212.2) Perpetual growth
EBIT 100.0 102.0 104.0 106.1 Costs / Sales
Operating taxes (30.0) (30.6) (31.2) (31.8) Invested capital / Sales

1|Page

, 2



NOPLAT 70.0 71.4 72.8 74.3 Debt / Sales
Interest (9.8) (10.0) (10.2) (10.4) Tax rate
Tax shield 2.9 3.0 3.1 3.1 Interest rate
Net income 63.1 64.4 65.7 67.0

Balance sheet 0 1 2 3 WACC
Invested capital 300.0 306.0 312.1 318.4 Risk free rate
Spread on debt
Debt 200.0 204.0 208.1 212.2 k(D)
Equity 100.0 102.0 104.0 106.1
Sources 300.0 306.0 312.1 318.4 Risk free rate
Market risk premium
Cash flows 0 1 2 3 Industry beta unlevered
NOPLAT 71.4 72.8 74.3
Net investments (Delta (6.0) (6.1) (6.2) Enterprise value (market value)
IC)
FCFO 65.4 66.7 68.0 Debt (market value)
Interests (10.0) (10.2) (10.4) Equity (market value)
Tax shield 3.0 3.1 3.1 ND / E
Debt issues 4.0 4.1 4.2 ND / (ND + E)
Total CF to 62.4 63.6 64.9 E / (ND + E)
shareholders



No cash into net debt because cash is distributed to shareholders Beta relevered

k(E)(L)

To achieve APV and DCF equivalence:

- Need to link WACC to market value of equity WACC


- Need to compute tax shields on beginning-of-period debt
- Need to keep a constant growth rate, because otherwise
k(E)(
U) there is a mismatch in growth of the components of APV and DCF




2|Page

, 3



0 1 2 3 CV DCF 0 1
2.0% 2.0% 2.0% 2.0% FCFO 65.4

2.0% Continuing value @ FCFO perpetuity
66.7% 66.7% 66.7% 66.7% Continuing value @ Key Value
Driver

100.0% 100.0% 100.0% 100.0%

66.7% 66.7% 66.7% 66.7% Discount factor @ WACC 0.92

30.0% 30.0% 30.0% 30.0% Discounted FCFO 59.9
Enterprise value 920.0
5.0% 5.0% 5.0% 5.0%


Economic Profit 0 1
NOPLAT 71.4
3.0% Initial IC 300.0

2.0% ROIC 23.8%

5.0% Economic profit 44.1

Continuing value - First component
3.0% Continuing value - Second component
5.0%

1.200 Discount factor @ WACC 0.92
Discounted EP 40.4

920.0 Invested capital 300.0

200.0 Enterprise value 920.0

720.0
27.8% Adjusted present value 0 1

21.7% FCFO 65.4
78.3% Continuing value of FCFO
Tax shield 3.0

1.533 Continuing value of tax shields
10.7%

Discount factor @ k(E)(U) 0.91
9.1% Discounted FCFO 59.8

Discounted TS 2.7

9.4% Unlevered value 879.6

Value of tax shields 40.4

Enterprise value 920.0



3|Page

Document information

Uploaded on
March 25, 2025
Number of pages
24
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$24.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
laurenjames
3.6
(18)
Sold
101
Followers
17
Items
1623
Last sold
1 week ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions