Excel Finance Help

Daisy just took out a $24,000 bank loan to help purchase her dream car. The bank offered a 5-year loan at a 6% APR. The loan will feature monthly payments and monthly compounding of interest. Suppose that Daisy would like to pay off her car loan's remaining balance at the end of the second year (after 24 payments). What is Daisy's payoff amount?

I need answer for B61,B62,B63

B61) Yearly Payment (Excel Function)

B62) VBA Formula ( please provide the VBA Code)

B63) Math Formula

All 3 answers should be the same

A 56 Q8) Stacy's Car Payment 57 PV 58 Loan Years (N) 59 Rate (R) 60 Payoff after Years 61 Yearly Payment (Excel Function) 62 Your VBA formula 63 Math Formula (Extra Credit, 2 points) 64 $24,000.00 5.0 6.00% 2.00