Question: Hi, i have a finance problem that i cannot fix. Heres the issue: Colgate-Palmolive Company has just paid an annual dividend of $0.96. Analysts are

Hi, i have a finance problem that i cannot fix. Heres the issue:

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, what price does the dividend-discount model predict Colgate stock should sell for?

Im trying to solve it in excel. Hope u can help.

Frederik

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!

5. Note that all of your calculations are done as of the summer of 2004; yet, actions such asselling securities and investing in assets will occur during 2005. What would happen if (a)more or fewer...

Section 1. Another utilization of cash flow analysis is setting the bid price on a project. To calculate the bid price, we set the project NPV equal to zero and find the required price. Thus, the bid...

One. Given the discussions we had during lecture one, use your understanding and knowledge gained from such lecture and answer the following questions. Kindly submit online, your appropriate answers...

Please show work in excel with appropriate formulas (Please do not just copy/paste in cells) Thank you Page 1 of 5 Date: 11/7/16 Course: Managerial Finance Week3 Problem Set 1. Your bank is offering...

Hi, this assignment is Urgent! The instruction is in the attachment ?final project guidelines and rubric?. Using Home Depot Financial Report, (here?s the link)...

When you purchased your house, you took out a 30-year annual-payment mortgage with an interest rate of 6% per year. The annual payment on the mortgage is $12,000. You have just made a payment and...

Please note: The intention of assignment one is to apply what we covered in class to real-world problem solving. For this reason, it is meant to be more challenging and I strongly suggest you set...

Question: Please note: The intention of assignment one is to apply what we covered in class to real-world problem-solving. For this reason, it is meant to be more challenging and I strongly suggest...

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, Highlines earnings are...

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...

The annual number units demanded, x, of a product (in thousands) by consumers at unit price p, in dollars per unit, is modeled by the formula P 2 + x = 8 (a) Write x explicitly as a function of p: x...

The Situation You are the operations manager for a manufacturing plant that produces pudding food products. One of your important responsibilities is to prepare an aggregate plan for the plant. This...

What is the derivative of l n x x l n 2 x 1 x x l n x 1 2 3 4

1. According to this study, what was the most common adverse event after the third treatment cycle? Myalgia Sinusitis Neck pain Musculoskeletal stiffness 2. Imagine you are a doctor specializing in...

Identify types of third-party plans in Canada, how does one apply for them? What are the benefits of having third-party insurance? Can third-party insurance be used across Canada? What are the pro...

You run an agricultural supply store and are setting up a spreadsheet that you will use each day. Worksheet 6 Problem #1 had seven products that you sell, and their prices. The...

1. Normalization works through a series of stages called normal forms. Typically processed. a. 2 . 3 4 d. 5 stages are . 2. Some very specialized applications may require normalization beyond the a....

a - If in fifty million years, geologist aliens from another planet came to earth, how would they recognize the Anthropocene, while looking through the rock record? b - Describe the evolution of the...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Which of the following statements is incorrect? pg85 Descriptive models are used to analyze the impact of alternative courses of action. Linear programming is a descriptive model. Sensitivity...

When estimating a regression, is it necessary to restrict the explanatory variables to quantitative variables? mk85

With respect to simulation, which of the following statements is correct? The simulation approach requires the evaluation of all possible outcomes associated with a decision.: mk74 Simulation...