Question: 81.06 and 78.88 are not the correct answer for the 1st question Problem 18-15 Calculate the intrinsic value of GE in each of the following

81.06 and 78.88 are not the correct answer for the 1st question

question Problem 18-15 Calculate the intrinsic value of GE in each of

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 9.70%. (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Intrinsic $ 81,06 value b. GE's actual beta is 1.08. (Round your answer to 2 decimal places.) Answer is complete and correct. $36.94 Intrinsic value C. The market risk premium is 9.80%. (Round your answer to 2 decimal places.) Answer is complete and correct. $ 24.95 Intrinsic value Div growth Term value Inputs for GE beta mkt prem rf k equity term gwth 1.1 0.08 0.025 0.1130 0.060 Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Dividend 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 5.18 0.1544 0.1450 0.1355 0.1261 0.1166 0.1072 0.0978 0.0883 0.0789 0.0694 0.0600 0.0600 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 108,75 Value line forecasts of annual dividends 103.57 Transitional period with slowing dividend growth Beginning of constant growth period 35.701 - PV of CF E17*(1+F17)/(B5 - F17) NPV(B5,H2:H117) 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 9.70%. (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Intrinsic $ 81,06 value b. GE's actual beta is 1.08. (Round your answer to 2 decimal places.) Answer is complete and correct. $36.94 Intrinsic value C. The market risk premium is 9.80%. (Round your answer to 2 decimal places.) Answer is complete and correct. $ 24.95 Intrinsic value Div growth Term value Inputs for GE beta mkt prem rf k equity term gwth 1.1 0.08 0.025 0.1130 0.060 Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Dividend 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 5.18 0.1544 0.1450 0.1355 0.1261 0.1166 0.1072 0.0978 0.0883 0.0789 0.0694 0.0600 0.0600 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 108,75 Value line forecasts of annual dividends 103.57 Transitional period with slowing dividend growth Beginning of constant growth period 35.701 - PV of CF E17*(1+F17)/(B5 - F17) NPV(B5,H2:H117)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Selected information from the Iowa Instruments accounting records for April follows: Materials Inventory Debit Credit BB (4/1) 25,000 209,000 174,000 Work-in-Process Inventory Debit Credit Labor...

this is my third time to post the question ! 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...

14 (X) - B I U - A- - % 000 4.0 .00 .00 .0 + #It x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. K5 X foc J K A B D E F H I 1 Inputs for...

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...

A B D E F G H 1 Div growth Term value Inputs for GE beta mkt_prem rt k_equity term_gwth 1.1 0.08 0.025 0.1130 0.060 Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031...

Check my work 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...

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...

2019 2021 Inputs for GE Year DividendDiv grovt.Term valuevestor CF beta 1.1 2017 1.04 1.04 mkt_prem 0.08 2018 1.23 1.23 0.025 1.41 1.41 k_equity 0.1130 2020 1.60 1.60 term_gwth 0.0601 1.85 0.1544 185...

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...

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...

On March 1, 2014, Zobrist Company acquired real estate, on which it planned to construct a small office building, by paying $80,000 in cash. An old warehouse on the property was demolished at a cost...

Population: 4, 10, 12, 12, 13, 21 Find the population variance and standard deviation or the sample variance and standard deviation as indicated.

The availability of free WiFi Internet connections in hotel rooms varies considerably with the luxury level of the hotel and the country. Despite changing attitudes to the necessity of providing free...

What should Sheila have done to avoid interviews like this one? 6 - 3 0 . Explain why Sheila, not Pete, should make the selection decision. 6 - 3 1 . What steps in the selection process were missed,...

2. There is no simple solution to the distractions that we face in our personal and work lives. Jackson states that the solution to the issue is self-discipline. Many distractions are self-initiated....

2. Evaluate how the original problem could have been intercepted before it became a health care crisis.

3. Is your life filled with too many distractions? If so, analyze what can be done to eliminate the stress and tension (distractions) and make room in your life for more meaningful communication. If...