I need to understand how to solve these using excell

5- Compute the value of a share of common stock of Lexi's Cookie Company whose most recent dividend was $2.50 and is expected to grow at 10 percent per year for the next 5 years, after which the dividend growth rate will decrease to 5 percent per year indefinitely. Assumellpe cont required rate of return 6- Newman Manufacturing is considered a cash purchase of a stock of Grips Tool. During the yearjust completed, dividends are 2.55 per share(D0=2.55). Grips' earnings and dividends are expected to grow at 25% per year for the next 3 years, after which they are expected to grow at 10% per year to infinity. What is the maximum price per share that Newman should pay for Grips if it had a required