QUESTION 2 Use the following information to answer Questions 2-6. Consider the f
ID: 2800356 • Letter: Q
Question
QUESTION 2
Use the following information to answer Questions 2-6.
Consider the following forecasts for 2017-2021 of the Future Cash Flows, EBITDA and Future Interest Tax Shield for Firm X if the expansion were not to occur. Assume that the EBITDA Multiple is 8.
Assume a discount factor of 9% for the Free Cash Flows and the Continuation Value, and 9% for the Interest Tax Shield.
Firm Value
2017
2018
2019
2020
2021
Free Cash Flow of Firm
3,307,202
3,313,063
3,318,911
3,324,747
3,330,574
EBITDA
5,193,892
Interest Tax Shield
15,750
15,750
15,750
15,750
15,750
2) What is the Present Value (at December 2016) of the Free Cash Flows forecast of Firm X if the firm where not to do the expansion?
10 points
QUESTION 3
3) What is the Present Value (at December 2016) of the Continuation Value forecast of Firm X if the firm where not to do the expansion?
10 points
QUESTION 4
4) What is the Present Value (at December 2016) of the Interest Tax Shield forecast of Firm X if the firm where not to do the expansion?
10 points
QUESTION 5
5) What is the Firm Value (at December 2016) of Firm X if the firm where not to do the expansion?
10 points
QUESTION 6
"6) True or False: If the Value of Firm X (at December 2016) of doing the expansion is estimated to be $146936194, Firm X should do the expansion (according to the NPV of the expansion)."
True
False
Firm Value
2017
2018
2019
2020
2021
Free Cash Flow of Firm
3,307,202
3,313,063
3,318,911
3,324,747
3,330,574
EBITDA
5,193,892
Interest Tax Shield
15,750
15,750
15,750
15,750
15,750
Explanation / Answer
2) PV can be calculated using NPV function on a calculator or excel
Insert CF1 = 3,307,202...CF5 = 3,330,574, I/Y = 9%
=> Compute NPV = $12,905,456.54
3) Continuation Value = EBITDA x Multiple = 5,193,892 x 8 = 41,551,136
PV = 41,551,136 / (1 + 9%)^5 = $27,005,387.42
4) PV of tax shield can be calculated using PV function
Insert CF1 = CF2....CF5 = 15,750
=> Compute PV = $61,262.01
5) Total Firm Value = 12,905,456.54 + 27,005,387.42 + 61,262.01 = $39,972,105.97
6) True. As the firm firm value increase due to expansion, Firm X should do the expansion.