Answer the following in Excel.

A. Your friend is planning to buy a car and has decided to contribute $300 to an investment account at the beginning of each month for the next 5 years. What will the value of this investment account be at the end of the 5years if your friend can earn a compound return of 8% per year compounded monthly?

B. At the end of year 5, your friend will purchase a car with a price of $40,000 using the final balance on the savings account and a car loan for the balance of the car's price. The loan will have monthly payments for 6 years due at the end of the month. The interest rate on the loan will be 4% compounded monthly. What would the monthly payments your friend will need to make on the loan?