Start with the partial model in the file Ch08 P25 Build a Model.xlsx. Selected data for the Derby Corporation are shown here. Use the data to answer the questions. INPUTS (In Millions) Year Current 0 Projected 1 > 3 4 Free cash flow $25.0 $25.0 $90.0 $93.6 Marketable securities $40 Notes payable $100 Long-term bonds $300 Preferred stock $.50 WACC 8.00% 40 Number of shares of stock The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermedia Flow valuation Model Start with the partial model in the file Cho P25 Build a Modelahox Selected data for the Derby Corporation are shown here. Use t INPUTS (In Mitions) Year Current Projected 1 2 3 4 Tree cash flow $250 $25.0 100.0 $93.6 Marketable securities 540 Notes payable $100 Long-term bonds $300 Preferred stock 8.50 WACC Number of shares of stock 8.00% 40 The data has been collected in the Microsoft Excel file below, Download the spreadsheet and perform the required analysis to answer the . De Download areadsheet Chos F23 Build a Mod525. 4 fe cash Bowl Amme growth be constant after a Calculate the estimated horizon value (Le, the value of operations at the end of the forecast period immediately after the millions, for example, an answer of $1.23 million should be entered as 1.23, not 1.230,000. Round your answer to two dechal places million b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated year-o value of operations. Enter your are in be antered as 1.23, not 1,230,000. Mound your answers to two decimal places. Present value of my Pret sale of FCF perations . milion milion timated Year O price per share of common equity. Round your answer to the nearest cent Reel Poblan C