Please use Excel format!

Task 1: Stock Valuation Collage AI, Inc., is growing rapidly, and now you need to estimate the value of its common stock. Dividends are expected to grow at 15 percent for the next five years, with the growth rate falling to a constant 2.54 percent thereafter. The required return is 9 percent, and the company just paid a dividend of $1.03. Questions: 1. What is the estimated value of the stock in Year 5 ? (5 points) 2. What is the estimated current share price of Collage AI? (5 points)