Dividend-discount model predict colgate stock should sell

Assignment Help Financial Management

Reference no: EM131876097

Colgate-Palmolive 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, Colgate’s earnings are expected to grow at the current industry average of 5.2% per year. If Colgate’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 Colgate stock should sell?

Please show me how to find the answer to this problem using Microsoft Excel. I need to know the formula/inputs used in the calculations.

Reference no: EM131876097

Questions Cloud

Calculate the future value of a deposit : Calculate the given on your financial calculator. Show your financial calculator inputs. Use of tables is not acceptable. All rates are expressed as an annual

Describe the corporate social responsibility : Explain why all three of the following will be most useful in a professional career; (1) a savvy entrepreneur, (2) entering foreign markets.

Discuss human impacts on the sustainability of groundwater : Discuss Human Impacts on the Sustainability of Groundwater. Write a 1-page lab report using the following scientific method sections.

Stock market bubble : Suppose the NASDAQ stock market bubble peaked at 4,900 in 2000. What was the percentage decline?

Dividend-discount model predict colgate stock should sell : what price does the dividend-discount model predict Colgate stock should sell?

Define challenging issues in global marketing : Global advertising is one of the most challenging issues in global marketing. One of the main dilemmas resides in a decision whether to standardize.

Developed large group of loyal restaurant customers : Taste-T Company has been in business for 30 years and has developed a large group of loyal restaurant customers.

Why europe initially desired to form a regional trading bloc : Starting with the first part of the previous century, Europe had a growing economy, a flexible social structure, and a good educational system.

Price of the shorter-term bond when interest rates change : Why does the longer-term bond’s price vary more than the price of the shorter-term bond when interest rates change?

User Account

All Pages