How would you solve using Excel?

a. Over The Top Parachutes Corporation is experiencing a decline market. Its last annual dividend declined to a level of $1.25 per share; the next dividend is expected to decline by another 10 percent, and subsequent dividends are expected to decline ar rate of 15 percent per year for the foreseeable future. If the required rate of return for this firm is 16 percent, what is this stock worth?

b. Papaya Drinks Corp. just paid an annual dividend of $1.50 per share, and the next two dividends are expected to frow at an annual rate of 8%. If the stock is currently selling for $23 per share and has a required rate of return of 15 percent per year, what is the long-term expected growth rate of Papaya's dividends?