One spreadsheet assignment involved the Corporate Valuation Model. The financial projections and inputs are listed below. What is the Excel formula needed to calculate the desired value for spreadsheet cell G18? INPUTS: before to coat of debet el free rate of interest marketinde (SPS) return NO NP Cash and Events Short Term $ NS FW Tarte BON FW market weight for det 40 prowth rate in free cash flow beyon Wha 1.10 Notes puble (2018 S . Long Term Debt (2018) S. 1.000 Short Term investment (2016) 5 250 Number of shares in milions (20161 10 Operating capital (2016 54,722 alles in en Period Ending 2019 2010 021 2022 2023 Total Revenue $9.000 $0.00 $ 10.000 $11.079 SIT) Cost of Revenue $ 7.200 $7.920 $8,7259.50$10.542 Gross Pratt $ 10 $ 1,980 S 2.18 $ 2.19 $ 2015 Deprec/Amart Ep $ 800 $ 60 $ 720 $ 728 Other Exp S1036 S 436 499 329 FIT $ 40 $ 224 $1,06 11 S 12 Interest Capense $105 33051405 350 $ 160 Earnings Before Tees $ 32055945 876 2685 Tere (N) 156'S 178's 2015 Net Income $ 416 5 4715 510 S cos Inventory Current Gros Plant Andere Nethed Ant Total Ass 2019 200 2001 5 73 $ 05 SOS NO 103 2.1 2.4 2.1 UN 12.10 1 1 1 1 1 1 1 1 1 1 5 $ 1.54 5 1.000 $ $ 3 5 4 5 1.100 LS 2.46 SIRI 5 1.100 1.145 114 10 7.110 1.2 5742 7.633 5. $ OCR IN 20 5 $ OUTPUTS: Period ending 2019 1923 I cost of equity 11.70% weighted average cost of capital 7 19 Horizon value of opere 2018 24.582 IQ Value of operassetto S2.25 Value of Equity (0) $ 1,5M la Value of equity per here to SSL.27 1919 2011 203) S 2.560 S 3,036 S 4.30054,738 35,212 $ 3.460 $ 5.456 $ .425 3.447 5 5,441 S 150 S SIS 716 S 787 Acta Paste Notes Payable Aeru Current Long Term Det Corn Stock Retained Gaming Total Equity Total Cline 70 371 41054 $200 $ 200 100 100 100 3000 SLO LIR 13 3 1820 3 3 5 2,160 S 2,372 3 4450 $ 40 $1,350 1.DIOS 460 1460 405 403 5 400 S 318 320 $ 102T 2. 2 5 122 S2 $7.1805 2.0 STATS 25 A aper cap Ref VE 5 Select one: a. =(N8-N5)-(N17-N15) O b. = (N8)-(N17) O C. =(N 12-N8)-(N17-N15) O d. =(N13)-(N22) One spreadsheet assignment involved the Corporate Valuation Model. The financial projections and inputs are listed below. What is the Excel formula needed to calculate the desired value for spreadsheet cell G18? INPUTS: before to coat of debet el free rate of interest marketinde (SPS) return NO NP Cash and Events Short Term $ NS FW Tarte BON FW market weight for det 40 prowth rate in free cash flow beyon Wha 1.10 Notes puble (2018 S . Long Term Debt (2018) S. 1.000 Short Term investment (2016) 5 250 Number of shares in milions (20161 10 Operating capital (2016 54,722 alles in en Period Ending 2019 2010 021 2022 2023 Total Revenue $9.000 $0.00 $ 10.000 $11.079 SIT) Cost of Revenue $ 7.200 $7.920 $8,7259.50$10.542 Gross Pratt $ 10 $ 1,980 S 2.18 $ 2.19 $ 2015 Deprec/Amart Ep $ 800 $ 60 $ 720 $ 728 Other Exp S1036 S 436 499 329 FIT $ 40 $ 224 $1,06 11 S 12 Interest Capense $105 33051405 350 $ 160 Earnings Before Tees $ 32055945 876 2685 Tere (N) 156'S 178's 2015 Net Income $ 416 5 4715 510 S cos Inventory Current Gros Plant Andere Nethed Ant Total Ass 2019 200 2001 5 73 $ 05 SOS NO 103 2.1 2.4 2.1 UN 12.10 1 1 1 1 1 1 1 1 1 1 5 $ 1.54 5 1.000 $ $ 3 5 4 5 1.100 LS 2.46 SIRI 5 1.100 1.145 114 10 7.110 1.2 5742 7.633 5. $ OCR IN 20 5 $ OUTPUTS: Period ending 2019 1923 I cost of equity 11.70% weighted average cost of capital 7 19 Horizon value of opere 2018 24.582 IQ Value of operassetto S2.25 Value of Equity (0) $ 1,5M la Value of equity per here to SSL.27 1919 2011 203) S 2.560 S 3,036 S 4.30054,738 35,212 $ 3.460 $ 5.456 $ .425 3.447 5 5,441 S 150 S SIS 716 S 787 Acta Paste Notes Payable Aeru Current Long Term Det Corn Stock Retained Gaming Total Equity Total Cline 70 371 41054 $200 $ 200 100 100 100 3000 SLO LIR 13 3 1820 3 3 5 2,160 S 2,372 3 4450 $ 40 $1,350 1.DIOS 460 1460 405 403 5 400 S 318 320 $ 102T 2. 2 5 122 S2 $7.1805 2.0 STATS 25 A aper cap Ref VE 5 Select one: a. =(N8-N5)-(N17-N15) O b. = (N8)-(N17) O C. =(N 12-N8)-(N17-N15) O d. =(N13)-(N22)
