Excel Finance Help

John just took out a $24,000 bank loan to help purchase his dream car. The bank offered a 5-yearloan at a 6% APR. The loan will feature monthly payments and monthly compounding of interest. What is the monthly payment for this car loan?

I need answer for B52, B53,B54

B52) Monthly Payment (Excel Function)

B53) VBA Formula ( please provide the VBA Code)

B54) Math Formula

All 3 answers should be the same

B A 48 Q7) John's Car Payment 49 PV 50 Years (N) 51 Rate (R) 52 Monthly Payment (Excel Function) 53 Your VBA formula 54 Math Formula 55 $24,000.00 5.0 6.00%