How do you set up for excel and solve in excel creating a math formula and using an excel formula and creating a VBA formula how to solve this

1. Amy's grandparents have been depositing $500 into a savings account every month since she is born. The 1st payment was made the day Amy was born. The account pays 6% interest annually. Immediately after Amy's grandparents make the monthly deposit on her 18th birthday, Amy went to the bank to check her bank balance. What should be Amy's bank balance? 2. John is planning to buy a house in three years. He thinks he needs to put down $65,000 in three years as a down payment. Currently John has $15,000. He would like to start saving in a bank that offers 8% annual interest rate. How much should John save every month into that bank account so that he can accomplish his goal