Inputs for GE beta mkt_prem 1.1 0.08 0.025 0.1130 0.060 k_equity term_gwth Year r 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 ,2032 Dividend Div growth 1.04 1.23 1.41 1.60 1.85 0.1544 2.11 | 0.1450 2.40 0.1355 2.70 0.1261 3.02 0.1166 3.34 0.1072 3.67 0.0978 3.99 0.0883 4.31 0.0789 4.61 0.0694 4.89 0.0600 5.18 0.0600 Term value | Investor CF 1.04 1.23 1.41 1.60 1.85 2.11 2.40 2.70 3.02 3.34 3.67 3.99 4.31 4.61 4.89 103.57 1 08.75 Value line forecasts of annual dividends Transitional period with slowing dividend growth Beginning of constant growth period 35.70 = PV of CF E17 *(1+F17)/(B5 - F17) NPV(B5,H2:H17) Chapter 18 A Saved Help Save & Exit Submit Check my work 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 9.30%. (Round your answer to 2 decimal places.) points Skipped Intrinsic value eBook Print References b. GE's actual beta is 1.04. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 9.40%. (Round your answer to 2 decimal places.) Intrinsic value Intrinsic value Inputs for GE beta mkt_prem 1.1 0.08 0.025 0.1130 0.060 k_equity term_gwth Year r 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 ,2032 Dividend Div growth 1.04 1.23 1.41 1.60 1.85 0.1544 2.11 | 0.1450 2.40 0.1355 2.70 0.1261 3.02 0.1166 3.34 0.1072 3.67 0.0978 3.99 0.0883 4.31 0.0789 4.61 0.0694 4.89 0.0600 5.18 0.0600 Term value | Investor CF 1.04 1.23 1.41 1.60 1.85 2.11 2.40 2.70 3.02 3.34 3.67 3.99 4.31 4.61 4.89 103.57 1 08.75 Value line forecasts of annual dividends Transitional period with slowing dividend growth Beginning of constant growth period 35.70 = PV of CF E17 *(1+F17)/(B5 - F17) NPV(B5,H2:H17) Chapter 18 A Saved Help Save & Exit Submit Check my work 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 9.30%. (Round your answer to 2 decimal places.) points Skipped Intrinsic value eBook Print References b. GE's actual beta is 1.04. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 9.40%. (Round your answer to 2 decimal places.) Intrinsic value Intrinsic value