Solve these problems with excel:

- Your broker has offered you an investment opportunity at a cost of $500. The opportunity offers $100 in 1 year, $200 in 2 years, and $300 in 3 years. If you require a 10% return on investments of similar risk, should you take the opportunity?

- Suppose a company offers a dividend payment of $2.5 every year. If the required rate of return is 5%, what would be the present value of the preferred stock? -7. Suppose a company offers a dividend payment of $2.5 every year. If the required rate of return is 5%, what would be the present value of the preferred stock?