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\mathrm{.}54$ percent thereafter. The required return is $9$ percent, and the company

gust paid a dividend of $$1\mathrm{.}03.$

Questions:

What is the estimated value of the stock in Year $5?(5$ points$)$

What is the estimated current share price of Collage AI$?(5$ points$)$ please check if my solution is correct. Also only do this on excel please