Please show me using excel formula only example (B2/B5,d4*d2), =FV(d3,d4, , , () , do not hard values, use the cells please,

EXCEL 3: CHAPTER 7 A Seved Help Save & Exit Submit ? - Sign In x FILE HOME Calibri B I INSERT - U. 3- Font Calculating stock price - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - A A % A Alignment Number Conditional Format as Cell - Formatting Table Styles s Cells Skipped Paste Clipboard A1 E F H I 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 retum of 10.5 percent on the stock, what is the current price? What will the price be in three years? In 15 years? 1.95 4% Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend in one year Price today Dividend in 4 years