Constant Growth Model | P=D1/(K-g) | |||||
Example 1 | Example 2 | Example 3 | Example 4 | Example 5 | Example 6 | |
D1 | 2.05 | 4.1 | 1.25 | 2.15 | 6.35 | 2.25 |
K | 11% | 15% | 8% | 18% | 12% | 13% |
g | 9% | 10% | 5% | 10% | 5% | 8% |
P= | 0.041 | 0.205 | 0.0375 | 0.172 | 0.4445 | 0.1125 |
Calculating D1 = | (1+g) * D0 | |||||
D0 | 2.25 | 3.75 | 1.25 | 1.5 | 4.25 | 2 |
D1 | 2.43 | 4.125 | 1.3125 | 1.65 | 4.4625 | 2.16 |
K | 13% | 15% | 8% | 18% | 12% | 13% |
g | 8% | 10% | 5% | 10% | 5% | 8% |
P= | 0.1215 | 0.20625 | 0.039375 | 0.132 | 0.312375 | 0.108 |
Zero Growth Model | P=Do/K | |||||
D0 | 1.5 | 5 | 2 | |||
K | 15% | 5% | 10% | |||
P= | 10 | 100 | 20 | |||
P/E Ratio Model | Stock Price = Estimated EPS x Expected P/E | |||||
EPS growth | 20% | 15% | 10% | 25% | 10% | |
Last Years EPS | $ 2.25 | $ 3.00 | $ 1.75 | $ 0.25 | $ 4.10 | |
Expected P/E ratio | 5 | 20 | 15 | 10 | 28 | |
Estimated EPS | ? |
? |
? | ? | ? | |
Stock Price= | ? | ? | ? | ? | ? | |
CAPM | RRR= RFR + (Beta x (Market Return - RFR)) | |||||
Risk Free Rate | 5.5% | 3.5% | 2.5% | 4.5% | 5.5% | |
BETA | 1.30 | 2.00 | 1.25 | 2.50 | 0.75 | |
Market Return | 15% | 13% | 14% | 11% | 10% | |
Risk Free Rate | 5.5% | 3.5% | 2.5% | 4.5% | 5.5% | |
RRR | 17.85% | 22.50% | 16.88% | 20.75% | 17.13% |
Solve for estimated EPS and stock price.
example 1
estimated EPS=2.25×1.20=2.7
estimated stock price
=(2.25* 1.20)×5=13.5
example 2
Estimated eps=3×1.15=3.45
estimated stock price=3.45×20=69
example 3
estimated EPS=1.75×1.1=1.925
Estimated stock price=1.925×15=28.875
example 4
estimated EPS=0.25×1.25=0.3125
estimated stock price=0.3125×10=3.125
example 5
estimated stock price=4.10×1.1=4.51
estimated stock price=4.51×28=126.28.
Constant Growth Model P=D1/(K-g) Example 1 Example 2 Example 3 Example 4 Example 5 Example 6...
50. The Constant Dividend Model for calculating the intrinsic value of a stock is Io =D1/(k-g) where K is the expected return of the market and g is growth rate of the company. The growth rate (g) of the company can be calculated by using the Capital Asset Pricing Model. a. True. b. False.
I want the answer to be in excel formula , for example (D1,D1,,..) Problem 8-1 Stock Values. ? X - Sign In Saf Calculating stock price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW P M Calibri - 11 - Á À = % 1 Paste B I U . 3- A - Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font G Styles Cells - A1 A B C D E F G H...
Constant Growth Stock Valuation You are analyzing Jillian’s Jewelry (JJ) stock for a possible purchase. JJ just paid a dividend of $1.25 yesterday. You expect the dividend to grow at the rate of 7% per year for the next 3 years, if you buy the stock; you plan to hold it for 3 years and then sell it. What dividends do you expect for JJ stock over the next 3 years? In other words, calculate D1, D2 and D3. Note...
Conc Ratio Temp Time Rating 2 4 180 7 2.25 2 4 100 3 1.6 2 13 140 1 3.1 4 7 140 3 4.8 4 10 180 3 4.5 4 10 160 5 4.6 4 13 100 7 4.3 4 1 180 7 1.8 4 1 100 1 1.3 4 1 100 1 1.4 4 1 100 1 1.45 5 4 160 7 4.5 5 1 100 7 1.4 5 4 100 1 1.7 5 13 140 1 4.5...
1. Please show me the Gordon Growth Model formula. (Just copy it done. P,-?, 0.1 point) 2. As we mentioned, g not only governs the growth of d, g also tells us how P changes along the time. Please rewrite Pin terms of P, and g. (0.2 point) 3. Now, according to 1. and 2., we know 2 ways to express P. Equate them and derive d, in terms of P. 9, and r. (0.5 point) 4. Following 3., substitute...
Question 6 Bonus 1. Please show me the Gordon Growth Model formula. (Just copy it done. P,-?, 0.1 point) 2. As we mentioned, g not only governs the growth of d, g also tells us how P changes along the time. Please rewrite Pin terms of P, and g. (0.2 point) 3. Now, according to 1. and 2., we know 2 ways to express P. Equate them and derive d, in terms of P. 9, and r. (0.5 point) 4....
collegelink//course resource/section/7470/assignment/14040 5 Arpandeep Kaur K n 4 (3) n 5 (2) -n 6(1) en 7 (2) Question 11 of 13 How much more would you need to deposit at the end of every month to accumulate $288,500 over 22 years if the interest rate earned is 5.5% compounded annually instead of 5.5% compounded monthly? on 8 (1) on 9 (2) On 10 (1) on 11 (1) on 12 (1) on 13 (1) Round to the nearest cent Next Question...
Question Number 3 1. Please show me the Gordon Growth Model formula. (Just copy it done. P,-?, 0.1 point) 2. As we mentioned, g not only governs the growth of d, g also tells us how P changes along the time. Please rewrite Pin terms of P, and g. (0.2 point) 3. Now, according to 1. and 2., we know 2 ways to express P. Equate them and derive d, in terms of P. 9, and r. (0.5 point) 4....
3. Problem 8-20 Value a Constant Growth Stock (LG8-5) Financial analysts forecast Limited Brands (LTD) growth rate for the future to be 11.5 percent. LTD’s recent dividend was $0.60. What is the value of Limited Brands stock when the required return is 13.5 percent? (Round your answer to 2 decimal places.) 8. Problem 8-32 Changes in Growth and Stock Valuation (LG8-5) Consider a firm that had been priced using an 8.5 percent growth rate and a 10.5 percent required return....
B А 1 Next Dividend (D.) 2 Dividend Growth Rate 3 Stock Price 4 Flotation Cost 5 Beta 6 Risk-free Rate 7 Expected Market Return 8 Cost of New Common Equity 2.25 4.00% $35.00 6.00% 1.15 2.50% 9.00% ? What is the correct formula for B7 to find the cost of new common equity using the constant growth dividend discount model? =B1/B3*(1-B4))+B2 =B1/(B3"(1-B4))+B2 B5+B4 B6 -B1/B3+B2