PLEASE PROVIDE FOLLOWING :

Step (1) Solve all these problems using Microsoft-provided Excel Functions Step

(2) Solve all these problems using VBA functions developed by you. Answers in Steps (1) and (2) should match.

1. Amy's grandparents have been depositing $257 into a savings account every month since she was 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? = FVOFGIFT(PAYMENT, RATEYR, FREQUENCY, YEARS) Example: = FVOFGIFT(120, 6%, 12, 18) Clue: Answer contains 52 cents 2. Peter has decided to purchase his dream house for $425,000 today. His down payment is 20% of the purchase price, and he is planning to take a mortgage loan for the remaining 80% of the purchase price. Payments will be made monthly, and the first payment will be made one month from today. a) The interest rate on a 30-year mortgage is 3.50% annually. What will be his monthly mortgage payment? = MONPMT(PURCHASEPRICE, PERCENTDOWN, FREQUENCY, RATEYR, TERM) Example: = MONPMT(425000, 20%, 12, 3.50%, 30) Clue: Answer contains 75 cents b) The bank is also offering a 15-year mortgage at 2.50% annually. What will be his monthly mortgage payment? Reuse the function you developed in step a) with different numerical inputs, as shown below. Example: = MONPMT(425000, 20%, 12, 2.50%, 15) 1. Amy's grandparents have been depositing $257 into a savings account every month since she was 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? = FVOFGIFT(PAYMENT, RATEYR, FREQUENCY, YEARS) Example: = FVOFGIFT(120, 6%, 12, 18) Clue: Answer contains 52 cents 2. Peter has decided to purchase his dream house for $425,000 today. His down payment is 20% of the purchase price, and he is planning to take a mortgage loan for the remaining 80% of the purchase price. Payments will be made monthly, and the first payment will be made one month from today. a) The interest rate on a 30-year mortgage is 3.50% annually. What will be his monthly mortgage payment? = MONPMT(PURCHASEPRICE, PERCENTDOWN, FREQUENCY, RATEYR, TERM) Example: = MONPMT(425000, 20%, 12, 3.50%, 30) Clue: Answer contains 75 cents b) The bank is also offering a 15-year mortgage at 2.50% annually. What will be his monthly mortgage payment? Reuse the function you developed in step a) with different numerical inputs, as shown below. Example: = MONPMT(425000, 20%, 12, 2.50%, 15)