Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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.10%. (Round your answer to 2 decimal places.) Intrinsic value b. GE's actual beta is 1.01. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 10.20%. (Round your answer to 2 decimal places.) Intrinsic value B 1 K A Inputs for GE beta mkt_prem : rf 6 k_equity 5 term_gwth E F G Dividend Div growth Term value 1.04 1.23 1.1 H Investor CF 1.04 1.23 1.41 1.60 1.41 0.08 0.025 0.1130 0.060 D Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 1.60 1.85 2.11 1.85 2.11 7 3 2.40 2.70 3.02 0 1 3.34 3.67 3.99 0.1544 0.1450 0.1355 0.1261 0.1166 0.1072 0.0978 0.0883 0.0789 0.0694 0.0600 0.0600 2.40 2.70 3.02 3.34 3.67 3.99 4.31 4.61 4.89 108.75 2 Value line 3 forecasts of 4 annual dividends 5 6 7 Transitional period 8 with slowing dividend -9 growth 0 Beginning of constant 1 growth period 2. 2029 2030 2031 2032 4.31 4.61 4.89 5.18 103.57 35.70 = PV of CF E17 * (1+ F17)/(B5 - F17) NPV(B5,H2:H17)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started