Calculatethe following stock valuation problems using Microsoft Excel:

Company X is paying an annual dividend of $1.35 and has decided to pay the same amount forever. How much should you pay for the stock, if you want to earn an annual rate of return of 9.5% on this investment?

You want to purchase common stock of Company X and hold it for 7 years. The company just announced they will be paying an annual cash dividend of $6.00 per share for the next 9 years. How much should you pay for the stock, if you will be able to sell the stock for $28 at the end of seven years and you want to earn an annual rate of return of 11% on this investment?