Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions. a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. c. Calculate the estimated Year-0 price per share of common equity. INPUTS (In Millions) Year Current Projected 0 1 2 3 4 Free cash flow −$20.0 $20.0 $80.0 $84.0 Marketable securities $40 Notes payable $100 Long-term bonds $300 Preferred stock $50 WACC 9.00% Number of shares of stock 40
Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web
site. Selected data for the Derby Corporation are shown here. Use the data to answer the
following questions.
a. Calculate the estimated horizon value (i.e., the value of operations at the end of the
b. Calculate the present value of the horizon value, the present value of the free
flows
c. Calculate the estimated Year-0 price per share of common equity.
INPUTS (In Millions) Year
Current Projected
0 1 2 3 4
Free cash flow −$20.0 $20.0 $80.0 $84.0
Marketable securities $40
Notes payable $100
Long-term bonds $300
Preferred stock $50
WACC 9.00%
Number of shares of stock 40
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 6 images
