Microsoft Excel File Edit View Insert Format Tools Data Help Mon Dec 4 5:48PM AutoSave X: Ch07 P25 Build a Model.xlsx - Read-Only Comments Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Insert General Paste Arial Cab Wrap Text Merge \& Center \$ %, fx Format 3/13/23 Build a Mode Chapter: Problem: Corporate Valuation, Stock Valuation, and Stock Market Equilibrium Rates Selected data for the Derby Corporation are shown below. Use the data to answer the following questions. INPUTS (In millions) Free cash flow Marketable Securities Notes payable Long-term bonds Preferred stock iWACC Number of shares of stock a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately lafter the Year-4 free cash flow). Assume growth becomes constant after Year 3. Build a Model Solution Select destination and press ENTER or choose Paste