Question: Problem 18-16 (NEEDS TO BE IN EXCEL WITH FORMULAS) You are evaluating a project that requires an investment of $90 million today and provides a

Problem 18-16 (NEEDS TO BE IN EXCEL WITH FORMULAS)
You are evaluating a project that requires an investment of $90 million today and provides a single cash flow of $115 million for sure one year from now. You decide to use 100% debt financing, that is, you will borrow $90 million. The risk-free rate is 5% and the tax rate is 40%. Assume that the investment is fully depreciated at the end of the year, so without leverage you would owe taxes on the difference between the project cash flow and the investment.
a. Calculate the NPV of this investment opportunity using the APV method.
b. Using your answer to part (a), calculate the WACC of the project.
c. Verify that you get the same answer using the WACC method to calculate NPV.
d. Finally, show that flow-to-equity also correctly gives the NPV of this investment opportunity.
Investment today (million) $90.00
Amount of debt (million) $90.00
Cash flow in 1 year (million) $115.00
Tax rate 40%
Risk-free rate 5.00%
a. Calculate the NPV of this investment opportunity using the APV method.
Tax basis at year end (million):_____________
Taxes owed (million):________
FCF at year end (million):____________
VU (million):________
Interest expense (million):__________
Interest tax shield (million):___________
PV of ITS (million):___________
VL (million):___________
NPV (million):___________
b. Using your answer to part (a), calculate the WACC of the project.
Debt-to-value ratio:__________
WACC:_________
c. Verify that you get the same answer using the WACC method to calculate NPV.
VL (million):_________
NPV (million):__________
d. Finally, show that flow-to-equity also correctly gives the NPV of this investment opportunity.
After-tax interest expense (million):________
FCFE (million):__________
NPV (million):__________

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!