Please help me with the correct excel formula

7 Coating stock price Excel FORMULAS DATA REVIEW ALE HOME INSERT PAGE LAYOUT VIEW Car 11 4: Paste BIU- | AA % A. Alignment Number Conditional formata Cell Formatting Table Styles Cele Ioting Core Fort Al X c D F G The Jackson Timberlake Wardrobe Co just paid a dividend of S195 per share on its stock The dividends are expected to grow at a constant rate of 4 percent per year indefinitely if investors require a return of 105 percent on the stock what is the current price? What will the price be in three years? In 15 years? 4 5 6 7 8 Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year 195 4% 10 5% 0 3 15 9 10 11 16 15 16 19 18 Complete the following analysis. Do not hard code values in your calculations. Dividend in one year Price today Dividend in 4 years Price in 3 years Dividend in 16 years Price in 15 years 19 20 21 22 23 25 20 27 Sheet1 READY HI 100%