Question: Please use Excel and post formula, thanks Kellogg Co. (K) recently earned a profit of $2.52 earnings per share and has a P/E ratio of
Please use Excel and post formula, thanks

Kellogg Co. (K) recently earned a profit of $2.52 earnings per share and has a P/E ratio of 19.50. The dividend has been growing at a 9 percent rate over the past few years. If this growth rate continues, what would be the stock price in five years if the P/E ratio remained unchanged? What would the price be if the P/E ratio declined to 14 in five years? (Round your answers to 2 decimal places.) $ Stock price Stock price with new P/E $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
