Put answers as cell formulas please!

Output area: 1) Total earnings Retention ratio Growth rate Current dividend per share Dlvidend per share next year Value per share 2) Industry EPS Industry payout rabio Industry retention ratio Industry growth rate 315,000 0.71 12.14% 0.90 1.01 Year123558Dividend1.011.131.7 1) Total eamings Retention ratio Growth rate Current dividend per share Dividend per share next year $0.71$$315,00012.14%0.901.01 Value pershare is 2) Industry EPS Industry payout ratio. Industry retention ratio Industry growth rate Year123456$$$$5$Dividend1.011.131.271.421.601.73 Stock value in Year 5 5338 Stock price today 3) Industry PE Ragan PE (oniginal assumpton) Ragan PE (revised assumption) Stock price implied by industry PE 5) ROE