Problem 18-15 Calculate the intrinsic value of GE in each of the following scenarios by using the three-stage growth model of Spreadsheet 18.1. Treat each scenario independently. a. The terminal growth rate will be 10.90%. (Round your answer to 2 decimal places.) intrinsic value b. GE's actual beta is 1.09. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 11.00%. (Round your answer to 2 decimal places.) Intrinsic value AutoSave Of 2 Spreadsheet 18.1 - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing J K L M 1.41 7 K5 x fx A B C D E I 1 Inputs for GE Year Dividend Div growth Term value Investor CF 2 beta 1.11 2017 1.04 3 mkt prem 0.08 2018 4 rf 0.025 2019 1.41 5 k_equity 0.11301 2020 1.60 6 term_gwth 0.060 2021 1.851 0.1544 1.85 2022 2.11 0.1450 2.11 8 2023 2.40 0.1355 2.40 7 2024 2.70 0.1261 2.70 10 / 2025 3.02. 0.1166 3.02 2026 3.34 0.1072 3.34 12 Value line V 2027 3.67 0.0978 3.671 13 forecasts of 1 2028 3.99 0.0883 3.99 14 annual dividends 2029 4.31 0.0789 4.31) 15 2030 4.61 0.0694 4.61 16 2031) 4.89 0.0600 4.89 17 Transitional period 2032 5.18 0.0600 103.57 1 08.75 18 with slowing dividend 19 growth 35.70 = PV of CF 20 Beginning of constant E17*(1+F17)/(B5 - F17) growth period | NPV(B5, H2:H17) 11