Use the below information to solve the requirement in next 5 years:

 

49,200 3.59B stock prices Shares Outstanding Next 5 Years (per annum) 3.10% Forward Dividend & Yield 2.22 (4.38%). Avg Payout Ratio for the prior two years % 35 ww a. Create a timeline in Excel for five years b. Determine the long-term growth rateg =Retention Ratex Return on New Investment c. Use the long-term growth rate to determine the stock price for D year five using P=_ r-g D. Determine the current stock price using: P= (1+Dir)1+ (1+D2r)2 + (1+D3r)3 + (1+D4r)4+ (1+Dsr)s+ (r-Dgn) P= D (r-g) Why does your estimate differ from the actual stock price of CK Asset Holdings?