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 109. (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 fx Inputs for GE F G Temm value 1 2 3 5 Investor CF 1.04 1.23 1.41 1.60 1.85 2.11 2.40 2.70 3.02 Inputs for GE Year Dividend Div growth beta 1.1 | 2017 | 1.04 mkt_prem 0.08 2018 1.23 0.025 2019 1.41 k_e quity 0.1130 2020 1.60 term_gwth 0.060 2021 1.85 0.1544 2022 2.11 0.1450 2023 2.40 0.1355 2024 2.70 0.1261 2025 3.02 0.1166 2026 3.34 0.1072 Value line 2027 3.67 0.0978 forecasts of X 2028 3.99 0.0883 annual dividends 2029 4.31 0.0789 2030 4.61 0.0694 2031 4.89 0.0600 Transitional period 7 ,2032 5.18 0.0600 with slowing dividend growth Beginning of constant E17*(1+ F17)/B5 - F171 growth period 10 11 12 13 14 15 16 17 18 19 3.34 3.67 3.99 4.31 4.61 4.89 108.75 103.57 35.70 = PV of CF NPV(B5, H2:H17)