Build-a-Model Solution 11/26/2018
Chapter: 21
Problem: 10
INPUTS (In millions) Projected
Current
Horizon unlevered value of operations $5,100.00
Current value of unlevered operations $4,086.77
Current
Interest expense $100.0 $120.0 $120.0 $140.0
Tax savings $25.0 $30.0 $30.0 $35.0
Horizon unlevered value of operations $525.00
Current value of unlevered operations $423.48
Unlevered value of operations $4,086.77
Start with the partial model in the file Ch17 P12 Build a Model.xlsx on the textbook’s Web site. Kasperov
Corporation has an unlevered cost of equity of 12% and is taxed at a 25% rate. The 4-year forecasts of free
cash flow and interest expenses are shown in the following table; free cash flow and interest expenses are
expected to grow at a 5% rate after Year 4. Using the compressed APV model, answer the following
questions.
a. Calculate the estimated horizon value of the tax shield at Year 4 (i.e., immediately after the Year-4 free
Projected
d. Calculate the current value of the tax shield.
d. Calculate the current total value.
b. Calculate the current value of unlevered operations.
Projected
a. Calculate the estimated horizon value of unlevered operations at Year 4 (i.e., immediately after the Year-4
free cash flow).
Free cash flow $200.0 $280.0 $320.0 $340.0
Interest expense $100.0 $120.0 $120.0 $140.0
Long-term growth rate 5%
Tax rate 25%
Unlevered cost of equity 12.00%