In: Finance
Sheldon Corporation projects the following free cash flows (FCFs) and interest expenses for the next 3 years, after which FCF and interest expenses are expected to grow at a constant 7% rate. Sheldon’s unlevered cost of equity is 11% its tax rate is 35%. Year 1 2 3 Free cash flow ($ millions) $20 $30 $40 Interest expense ($ millions) $8 $9 $10 What is Sheldon’s unlevered horizon value of operations at Year 3? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to two decimal places. $ million What is the current unlevered value of operations? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to two decimal places. $ million What is horizon value of the tax shield at Year 3? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to two decimal places. $ million What is the current value of the tax shield? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to two decimal places. $ million What is the current total value of the company? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to two decimal places. $ million
| Growth rate after 3 years | 7% or | 0.07 | |||||
| Unlevered cost of equity | 11% or | 0.11 | |||||
| Tax rate | 35% | ||||||
| 1 | 2 | 3 | |||||
| Free cash flows ($ millions) | 20 | 30 | 40 | ||||
| Interest exp.($ millions) | 8 | 9 | 10 | ||||
| (a) | |||||||
| Unlevered horizon value of operations at year 3 = FCF for year 3 * (1+g) / (ke -g) | |||||||
| 40 * (1 + 0.07) / (0.11-0.07) | |||||||
| 1070 | |||||||
| So, Unlevered horizon value of operations at year 3 is $1070 millions. | |||||||
| (b) | |||||||
| Current unlevered value of operations is present value of FCF for 3 years and present value of horizon value at year 3 | |||||||
| Year | Cash flows | P.V. F. @ 11% | Present value | ||||
| 1 | 20 | 0.9009009 | $18.02 | ||||
| 2 | 30 | 0.81162243 | $24.35 | ||||
| 3 | 40 | 0.73119138 | $29.25 | ||||
| 3 | 1070 | 0.73119138 | $782.37 | ||||
| $853.99 | |||||||
| So, Current value of operations is $853.99 millions. | |||||||
| (c ) | |||||||
| Horizon value of tax shield at 3 Year = Interest expense * (1 + g)* Tax rate / (Ke -g) | |||||||
| 10 * (1+0.07) * 0.35 / (0.11-0.07) | |||||||
| 93.625 | |||||||
| So, Horizon value of tax shild is $93.63 millions. | |||||||
| (d ) | |||||||
| Current value of tax shield is present value of tax shield for 3 years and present value of horizon value at year 3 | |||||||
| Year | Interest exp. | Tax shield@ 35% | P.V. F. @ 11% | Present value | |||
| 1 | 8 | 2.8 | 0.9009009 | $2.52 | |||
| 2 | 9 | 3.15 | 0.81162243 | $2.56 | |||
| 3 | 10 | 3.5 | 0.73119138 | $2.56 | |||
| 3 (horizon value of tax shield) | 93.625 | 0.73119138 | $68.46 | ||||
| $76.10 | |||||||
| So, Current value of the tax shield is $76.10 millions. | |||||||
| (e ) | |||||||
| Current total value of company = Current value of operations + Current value of tax shield | |||||||
| $853.99 + $76.10 | |||||||
| $930.09 | |||||||
| So, the current total value of company is $ 930.09 millions. | |||||||