Solve using excel preferably

6. Atlas Home Supply has just paid an annual dividend of $2.00 a share for this year (Year 0 ). The dividend growth rate is expected to be 4 percent for Year 1,5 percent for Year 2,6 percent for Year 3, and a constant 7 percent thereafter. The stock's required return is 10 percent (the same required rate in all years in our analysis). What is the current stock price? A. $63.76 B. $67.47 C. $82.57 D. $22.97 E. $21.06