caydenfivecoats1572 caydenfivecoats1572 Today at 7:54 AM Business Answered Which of the following formulas calculates the number of payment periods for a $5,000 loan that has a monthly payment amount of $117.43. The loan has a 6 percent annual interest rate.=NPER(6%/12,117.43,-5000)