please give answer using excel formula

Chapter 07 Excel Problems i Paste 1 Clipboard Al 10 points eBook References 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 R 21 22 . Saved Editing Alignment Number Conditional Format as Cell Formatting Table Styles T Styles f B C D E F G H 1 J The Jackson-Timberlake Wardrobe Co. just paid a dividend of $1.95 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 10.5 percent on the stock, what is the current price? What will the price be in three years? In 15 years? Current dividend 1.95 Dividend growth rate 4% Required return 10.5% Price in Year 0 Price in Year 3 Price in Year 15 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 vears Sheet1 O BIU- V Font X Cells