Question

Calculate the value of a preferred stock with a fixed annual dividend of $2.45, assuming a...

Calculate the value of a preferred stock with a fixed annual dividend of $2.45, assuming a discount rate of 9.5%. Solve the problem two different ways: first by using the algebraic formula for a constant dividend preferred stock, then by using the built-in Excel function PV. hint: Use the Preferred Stock example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make the minor necessary changes to answer this question.
2. Calculate the value of a stock with an expected annual dividend of $2.00 next year and estimated annual dividend growth of 2% per year indefinitely. Assume a discount rate of 8%. Solve the problem two different ways: first by using the algebraic formula for the Gordon Growth Model, then by using Excel to calculate and sum the dividends and their respective present values for the next 150 years. hint: Use the PV Const Growth Dividend example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make the minor necessary changes to answer this question.
3. Calculate the value of a stock with the following expectations for dividend payments: $1.75 in Year 1, $2.00 in Year 2, and then annual dividend growth of 1.5% per year indefinitely. Assume a discount rate of 9%. Solve the problem two different ways: first by using the algebraic formula for the Gordon Growth Model combined with PV of uneven dividend payments, then by using Excel to calculate and sum the dividends and their respective present values for the next 150 years. hint: Use the Uneven, then Const. Growth Div example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make the minor necessary changes to answer this question.
4. Calculate the value of a stock with the following expectations for dividend payments: $1.75 in Years 1, 2 and 3, and then annual dividend growth of 1.5% per year indefinitely. Assume a discount rate of 9%. Solve the problem two different ways: first by using the algebraic formula for the Gordon Growth Model combined with PV of uneven dividend payments, then by using Excel to calculate and sum the dividends and their respective present values for the next 150 years. hint: Use the Uneven, then Const. Growth Div example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make the minor necessary changes to answer this question.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

(1) Annual Preferred Stock Dividend = Dp = $ 2.45 and Discount Rate = kp = 9.5 %

Preferred Stock Price = Dp / kp = 2.45 / 0.095 = $ 25.789474 ~ $ 25.79

NOTE: Please raise separate queries for solutions to the remaining unrelated questions, as one query is restricted to the solution of only one complete question with up to four sub-parts.

Add a comment
Know the answer?
Add Answer to:
Calculate the value of a preferred stock with a fixed annual dividend of $2.45, assuming a...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Dividend Discount Model in stable growth Your task is to value the stock price of Harrington...

    Dividend Discount Model in stable growth Your task is to value the stock price of Harrington Ltd with the Dividend Discount Model (DDM) in stable growth. You have the following information: Dividends per share DIV0 €1.89 Risk-free rate rF 3.00% Beta β 1.182 Expected return on stocks 8.50% Estimated long-term dividends growth rate 2.75% Required: (a) Calculate the value of the stock of Harrington Ltd using the Dividend Discount Model (DDM) in stable growth; (b) The stock currently trades at...

  • Your task is to value the stock price of Tornado with the Dividend Discount Model (DDM)...

    Your task is to value the stock price of Tornado with the Dividend Discount Model (DDM) growth. You have the following information: Recent dividends per share (DIVo) Risk-free rate (rr) Beta of the stock (β) Average stock return on the market n Estimated long-term dividends growth rate g 5.32 3.75% 1.7084 10% 3% 1) Calculate the value of the stock of Tormado using the Dividend Discount Model (DDM stable growth. 2) The stock currently trades at 34.71 in the stock...

  • Your task is to value the stock price of Harrington Ltd with the Dividend Discount Model...

    Your task is to value the stock price of Harrington Ltd with the Dividend Discount Model (DDM) in stable growth. You have the following information: Dividends per share DIV0 €1.89 Risk-free rate rF 3.00% Beta β 1.182 Expected return on stocks 8.50% Estimated long-term dividends growth rate    2.75% Required: (a) Calculate the value of the stock of Harrington Ltd using the Dividend Discount Model (DDM) in stable growth; (b) The stock currently trades at €39.40 in the stock market;...

  • Dick's Co Pays an annual dividend of $6 to its preferred stock. The rate of return...

    Dick's Co Pays an annual dividend of $6 to its preferred stock. The rate of return on T-Bill is 3% and the market risk premium is 8%. What is the intrinsic value of the preferred stock if the beta of the preferred stock is 1.257 Mountain Development Corporation is expected to pay a dividend of $3.00 in the upcoming year. Predicted to grow at the rate of 8% per year. The firms market capitalization rate is 14%. Using the constant...

  • Estimating Stock Value Using Dividend Discount Model with Constant Perpetuity Kellogg pays $2.25 in annual per...

    Estimating Stock Value Using Dividend Discount Model with Constant Perpetuity Kellogg pays $2.25 in annual per share dividends to its common stockholders, and its recent stock price was $82.50. Assume that Kellogg’s cost of equity capital is 5.0%. a. Estimate Kellogg’s stock price using the dividend discount model with constant perpetuity. $Answer b. Compare the estimate obtained in part a with Kellogg’s $82.50 price. What does the difference between these amounts imply about Kellogg’s future growth? The estimated price is...

  • "Assume Highline Company has just paid an annual dividend of $0.96. Analysts are predicting an 11% per year growth rate in earnings over the next five years. After then, Highline’s earnings are expected to grow at the current industry average of 5.2% per

    Assume Highline Company has just paid an annual dividend of $0.96. Analysts are predicting an 11% per year growth rate in earnings over the next five years. After then, Highline’s earnings are expected to grow at the current industry average of 5.2% per year. If Highline’s equity cost of capital is 8.5% per year and its dividend payout ratio remains constant, for what price does the dividend-discount model predict Highline stock should sell?Complete the steps below using cell references to...

  • d. Calculate the series of NATCFs and the NPV for this project at a 10% discount rate assuming that you finance the inve...

    d. Calculate the series of NATCFs and the NPV for this project at a 10% discount rate assuming that you finance the investment using a 7-year loan with a fixed interest rate of 6% (annual compounding and end-of-year payments) and a 50% down payment. Complete the final two columns of Table 1 below. Hint: This will require you to adjust the NATCF calculations that you made for part a. You will need to account for the loan when calculating the...

  • How can i calculate the cost of equity using Security Market Line and Dividend Discount Model...

    How can i calculate the cost of equity using Security Market Line and Dividend Discount Model (DDM), the cost of debt, the market value weights, and the WACC to use your answer from Security Market Line in your calculation for the cost of equity? Please do not use excel Phillips Pharmaceuticals Limited (PPL) shares are publicly traded on the Toronto Stock Exchange. The common shares currently trade at a market price of $30.00 per share. PPL recently paid a dividend...

  • A) Using the multi-stage dividend discount model (DDM), calculate the value of FLT shares. Use scrap...

    A) Using the multi-stage dividend discount model (DDM), calculate the value of FLT shares. Use scrap paper for your workings (15 MARKS). Assume that dividends in the next three years (starting from year 2017) will grow at a rate of 13% annually. Further, it is assumed that dividends will grow at a rate of 11% for the next four years (year 4 to 7). Thereafter it is assumed that the company will grow at a constant growth rate of 7%...

  • Please, help!! Traxo Manufacturing Ltd. shares are publicly traded on the Toronto Stock Exchange under the...

    Please, help!! Traxo Manufacturing Ltd. shares are publicly traded on the Toronto Stock Exchange under the ticker symbol TRX.TO. The shares currently trade at a price of $2.25 per share. Security analysts that follow the stock have estimated it's beta coefficient to be 0.9. Traxo paid a dividend on its common stock last year that totaled $0.08 per share. Dividends have been growing at a 3.25% compound rate for the past three years and the expectation is that this growth...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT