What is the future value of a. $550 invested for 5 years

Required: Complete the assignment using the formulas embedded in Microsoft Excel and/or a financial calculator. Include an Excel document that shows your calculations. 1. Future Value. What is the future value of a. $550 invested for 5 years at 15 percent compounded annually? b. $650 invested for 15 years at 14 percent compounded annually? 2. Present Value. What is the present value of a. $453 to be received 8 years from now at a 14 percent discount rate? b. $1200 to be received 7 years from now at a 12 percent discount rate? 3. Future Value of an Annuity. What is the future value of a. $1321 a year for 13 years at 13 percent compounded annually? b. $867 a year for 10 years at 13 percent compounded annually? 4. Present Value of an Annuity. What is the present value of a. $487 a year for 5 years at a 9 percent discount rate? b. $798 a year for 13 years at a 11 percent discount rate? 5. Annuity. How many years will it take for a payment of a. $590 to grow to 9090.91 at a compound rate of 14 percent? b. $900 to grow to future value of 10,586.21 at a compound rate of 14 percent? 6. Mortgage. (Hint: P/Y=12) What is the payoff on a 30 year, 7% original mortgage of a. $550,552 with a payment of 3,744.50 with 12 years remaining? b. $190788 with a payment of 1,143.87 with 15 years remaining? 7. Stock. What is the required rate of return on a stock with a a. $0.75 expected dividend and a 34 price with 7% growth? b. $1.25 expected dividend and a 15 price with 8% growth?