I am using Excel to try and solve these problems but can find the answers or figure out why my answers are wrong, please help.

1. Today, your roommate purchased an annual perpetuity of $1,000. The payments on his perpetuity will begin in one year. You purchased an annual perpetuity of $1,000. Your payments begin immediately. Assuming a 10% discount rate for these perpetuities, which of the following statements is true?

A. Your perpetuity is worth $1,000 more than the roommates.

B. The roommates perpetuity is worth $909.09 more than yours.

C. The perpetuities are of equal value today.

D. Your perpetuity is worth $909.09 more than the roommates.

E. The roommates perpetuity is worth $1,000 more than yours.

2. You invest $2,000 in an account which pays 9.5% compounded quarterly and $2,500 in an account paying 8% compounded quarterly. If you leave the money in the accounts, how many years will it take for the two accounts to have equal values?

3. If you deposit $2,500 at the end of each six months into an account that pays 5.5% interest compounded quarterly, how much will be in the account in 5 years?

4. You just won the lottery! You wish to put enough money away so that you can withdraw $6,000 per month for 40 years. You can earn 9% rate on any funds you deposit. How much will you have to deposit now to meet your goal?

5. An investment offers to pay you $7,000 per month for the next 10 years (The payments start a month after you purchase the investment). If you require 12% rate of return, how much should you pay for this investment? (Answers are rounded.)

6. You borrow $80,000 at 10 percent, compounded quarterly. How many years will it take to pay back the loan if the quarterly payment is $2,700?

7. You plan to retire in 30 years with $1 million. You have an investment available that provides a rate of return of 9% per year, compounded monthly. How much will you have to invest every month to reach your retirement goal?