Question
You are an analyst valuing Palm and Sun Industries for a possible acquisition. Below are pro forma estimates of unlevered free cash flow and interest
You are an analyst valuing Palm and Sun Industries for a possible acquisition. Below are pro forma estimates of unlevered free cash flow and interest tax savings for the 3-year planning period. Starting in year 4, you expect a constant growth rate of 4%, which is applicable to both equity- and debt-related cash flows. The unlevered cost of equity is 15% and the cost of debt is 8%. The tax rate is 35%. Cash flows are given in millions. Find the present value of the interest tax shield. Round your answer to the nearest million.
Year 1 | Year 2 | Year 3 | |
Free Cash Flow | 8 | 10 | 13 |
Tax Savings | 2 | 2 | 1 |
Can you show this example in Excel. I am having trouble calculating the interest expense to finish this equation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started