IN EXCEL, PLEASE

Stock Valuation: As a broker at Churnem & Burnem Securities, you recommend stocks to your clients. After gathering data on Furniture Factory, you have found that its dividend has been growing at a rate of 4% per year to the current (DO) $1.35 per share. The stock is now selling for $24.50 per share, and you believe that an appropriate rate of return for this stock is 11% per year. 2. Create a data table showing the stock value using the above models for long-run growth rates between 0% and 15% in 1% increments. Use an XY Scatter chart to visualize the results