Question

Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which...

Excel Online Structured Activity: Constant growth

You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.50 a share at the end of the year (D1 = $1.50) and has a beta of 0.9. The risk-free rate is 2.7%, and the market risk premium is 4.5%. Justus currently sells for $27.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.

Assuming the market is in equilibrium, what does the market believe will be the stock price at the end of 3 years? (That is, what is ?) Round your answer to two decimal places. Do not round your intermediate calculations.

Homework Answers

Answer #1

Using excel spread sheet to calculate

Expected Year end dividend(D1) 1.5
Beta coefficient 0.9
Risk free rate(rrf) 2.70%
Market risk premium(RPm) 4.5%
Current Stock Price(P0) 27
Calculate reuired return Formulas
Required Return on common stock 6.75% (=2.7%+0.9*4.5%)
Calculate constant growth Formulas
Total Return on common stock 6.750% 6.75%
Expected Dividend yield 5.56% (=1.5/27)
Expected capital gain yield 1.19% (=6.75%-5.56%)
Calculate stock Price in 3 years P3
Number of Years 3
Calculate P3 using P0 27.98 (=27*(1+1.19%)^3
Alternative calculation
Calculate P3 using dividends 27.98 (=1.5*(1+1.19%)/(6.75%-1.19%)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which...
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.50 a share at the end of the year (D1 = $1.50) and has a beta of 0.9. The risk-free rate is 5.6%, and the market risk premium is 5.5%. Justus currently sells for $40.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft...
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which...
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.00 a share at the end of the year (D1 = $2.00) and has a beta of 0.9. The risk-free rate is 3.8%, and the market risk premium is 4.5%. Justus currently sells for $42.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.25 a share at the end of the year (D1 = $2.25) and has a beta of 0.9. The risk-free rate is 5.0%, and the market risk premium is 4.5%. Justus currently sells for $38.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft Excel Online file below. Open the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.75 a share at the end of the year (D1 = $1.75) and has a beta of 0.9. The risk-free rate is 5.4%, and the market risk premium is 5.0%. Justus currently sells for $49.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft Excel Online file below. Open the...
Problem 9-13 Constant growth You are considering an investment in Justus Corporation's stock, which is expected...
Problem 9-13 Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.50 a share at the end of the year (D1 = $1.50) and has a beta of 0.9. The risk-free rate is 5.6%, and the market risk premium is 5.5%. Justus currently sells for $27.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market...
CONSTANT GROWTH You are considering an investment in Justus Corporation's stock, which is expected to pay...
CONSTANT GROWTH You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.00 a share at the end of the year (D1 = $2.00) and has a beta of 0.9. The risk-free rate is 4.5%, and the market risk premium is 5.0%. Justus currently sells for $40.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.50 a share at the end of the year (D1 = $1.50) and has a beta of 0.9. The risk-free rate is 4.8%, and the market risk premium is 4.5%. Justus currently sells for $35.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.75 a share at the end of the year (D1 = $1.75) and has a beta of 0.9. The risk-free rate is 4.9%, and the market risk premium is 4%. Justus currently sells for $27.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.00 a share at the end of the year (D1 = $2.00) and has a beta of 0.9. The risk-free rate is 4.3%, and the market risk premium is 5%. Justus currently sells for $48.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $3.00 a share at the end of the year (D1 = $3.00) and has a beta of 0.9. The risk-free rate is 4.9%, and the market risk premium is 5.0%. Justus currently sells for $44.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • The following sample observations were randomly selected. (Round intermediate calculations and final answers to 2 decimal...
    asked 12 minutes ago
  • what type of graph is best suitable for data obtained from customer ratings. The ratings are...
    asked 15 minutes ago
  • Determine the cumulative 15-year 18 kip ESAL’s in the design lane for 2-lane highway for the...
    asked 23 minutes ago
  • Q: Dr.Grimace, the evil dentist, is trying to find out if his patients suffer from periodontal...
    asked 23 minutes ago
  • After collecting data on 19283 dogs, you find that male vallhunds have an average weight of...
    asked 25 minutes ago
  • Research Target Corporation and assess your satisfaction with the company you researched and make recommendations about...
    asked 26 minutes ago
  • Evidence suggests that 70% of FSU students like turtles. Suppose we randomly sampled 15 FSU students....
    asked 26 minutes ago
  • Ulrich challenges the appropriateness of the nearly universal symbolism of the spinning wheel as the marker...
    asked 27 minutes ago
  • Differential Equations: Please try to computer type, if not possible be clear and organize. Thank you...
    asked 27 minutes ago
  • In your opinion, what are the three (3) most important benefits an employer can give to...
    asked 33 minutes ago
  • In a test of the effectiveness of garlic for lowering​ cholesterol, 81 subjects were treated with...
    asked 35 minutes ago
  • How does the 95% confidence interval correspond to the reported conclusion at a 0.05 significance level?...
    asked 36 minutes ago