Can someone help me understand how to do these practice questions in Excel?

1) You deposited $5,000 at the end of each year for 15 years into an account that paid 5%. (a) How much is in the account now? (b) If you had deposited the amounts at the beginning of each year, what would be in the account now?

2) You invested $6,000 five years ago. Your investment paid 4% compounded monthly. Your friend, Joe, invested $6,100 at the same time but earned 4.5% compounded quarterly. Who has more money in their investment account now and how much?

3) You are considering an investment that will pay you $7,000 in 10 years. You want to earn a 5% return. What is the maximum amount you would pay for the investment today?

4) Quinlan wants to take a trip that costs $4,250, but currently she only has $2,250 saved. If Quinlan invests this money at 6%, how long will it take for her investment to grow to $4,250?

5) Ten years ago you purchased a house by taking out a $200,000 thirty-year mortgage. The loan has a fixed rate of 6% compounded monthly.

a. What is your monthly mortgage payment?

b. Assume you want to pay off your mortgage today. What would be the payoff amount assuming she just made her most recent monthly mortgage payment? [Hint: the mortgage originally had 360 monthly payments (30 years x 12 months per year) and she has made 10 years x 12 months per year = 120 payments. Todays total payoff would be based on the number of remaining payments and the payment calculated in part (a).]

6) You put $2,000 into an account today. The account will have $3,000 in it at the end of five years. What rate of interest will you earn?

7) Now its your turn! Fill in the blanks for your situation once you graduate and see how much you would need to save each year to reach a retirement goal.

I plan to work for ______________ years. I want to have saved in a retirement account by the time I retire $__________________. If I assume I can earn 5% (after inflation) in my account, the equal amount I need to save at the end of each year is $_______________________.