PLEASE SHOW USING EXCEL

Suppose Budweiser has recently developed a marijuana infused beverage that is well-received by the market.

Budweiser just paid a dividend of $1.60 a share (Do), and this dividend is expected to grow at a rate of 18% each year over the next 6 years.

Beginning in year 7, Budweiser's long-run dividend growth rate will settle down to 5% annually.

What is Budweiser's stock valued at today if you use a 14% discount rate?