Excel Hile Edit View Insert Format Tools Data Window $ Help Spreadshe O O O 2.2.7. G 100% Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment A . Calibri (Body) - 11 A A = = abc Wrap Text Paste Clear BI VEDA EEE31 Merge K5 fx A B C D E T G H 1 Inputs for GE Dividend Div growth Term value Investor CF 2 beta 11 1.041 3 mkt prem 0.08 2018 121 0.0251 2019 1.41 141 k equity 0 11301 2020 1.60 6 term gwth 0.0601 0.1544 1.85 2022 2.11 0.1450 2.11 8 2023 01355 2.40 2024 2.70 0.1261 2.70 2025 3102 0.1166 3.02 2026 3.34 0.1072 3.34 12 2027 0.0978 13 forecasts of 2028 0.0883 3.99 14 Annual dividends 2029 010789 4.31 2030 4.61 0.0694 4.611 2031 0.0600 489 17 Transitional period 2032 5.18 0.0600 103.57 108.75 18 with slowing dividend 19 growth 35.70 PV of CF Beginning of constant E17 (1+F1717(B5 - F17) wed Browth period NPV(BS,H2:H17) 2021 1.60 185 240 10 3.99 15 4.89 + K Normal View Sprd 18.1 Ready Problem 18-15 Calculate the intrinsic value of GE in each of the following scenarios by using the three-stage growth model of Soreadsheet 18 Treat each scenario independently. a. The terminal growth rate will be 10.80%. (Round your answer to 2 decimal places.) Intrinsic value b. GE's actual beta is 108. (Round your answer to 2 decimal places.) intrinsic value 2 c