Question: 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

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

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!

CHAPTER 14 Financial Statement Analysis 549 a. Common size ratios for the statements of financial position and statements of activities b. The current ratio c. Days of cash on hand d. The debt to...

3 Excel File Edit View Insert Format Tools Data Window Help AutoSave ON EA#2F2021 Acrobat Tell me Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) V 12 ' ' III General III III...

Excel File Edit View insert Format Tools Data Window Help AutoSave . . . Stokes OM Excel Assignnent 1 ( Forecasti Home Insert Draw Page Layout Formulas Data Review View Acrobat Paste Calibri 1 1...

1 2 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF C ACC 2302 amour Home Insert Draw Page Layout Formulas Data Review View Automate Te Arial 12 3 A A General Paste BIU A29 $...

Excel File Edit View Insert Format Tools Data Window $ Help OO O % % 01. 2.2.7. G # 100% ch02 @ Home Layout Tables Charts SmartArt Formulas Data Review Font Alignment Paste . . Arial 1. 10 AA abc...

Problem 1 The XYX company is dedicated to the manufacture of bicycles, according to the specific orders of the clients. Record transactions 1 through 15 on the attached worksheet. The opening...

= = = = Merge & Center 4 xfx 8 D E F mancial Statements cel Assessment - Instructions 1. Please complete the following tab by completing a working, inked, three-statement model a P&L, Balance Sheet,...

Excel File Edit View Insert Format Tools Data Window Help CJ7471 (1).xls [Compatibility Mode AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View D3 A C H For 20x2 the selling price...

A 4-year bond pays an annual coupon of 10.5% based on a $1,000 par value and is selling to yield 7.5%. Use the excel duration function to determine the point in time when the bond's payment stream...

Regarding Tesla's companies financial statements: Company Section Who are the Companys external auditors? Find and read the audit opinion. What was the auditors opinion? If the opinion indicates a...

Suppose the interaction between two atoms by the Lennard-Jones potential: ULJ= -A where the values of A and B are known to be A = 10-77 J.m6 and B = 10-134 J.m 1. What does the Lennard-Jones...

a) based on 20X2, what is the capital intensity ratio? b) based on 20X2, what is full capacity of sales if it is operating at 80% capacity c) what is the eternal growth rate for 20X2? d) what is the...

Item 1 0 1 . 5 points Time Remaining 4 hours 1 5 minutes 7 seconds 0 4 : 1 5 : 0 7 eBookHint Print References Check my workCheck My Work button is now enabled Item 1 0 Time Remaining 4 hours 1 5...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

2. One union newspaper indicated how it saved an employees job. The employee was in the mechanics classification and was discharged for refusing to comply with managements sudden, unilateral rule...

broadening cross-cultural analysis to include an understanding of integrationdifferentiation in global managing;

developing the relevance of cross-cultural studies through an incorporation of stakeholder analysis of particular interaction situations;