Question: how to figure out car payment with apr?
Answer: =PMT(interest rate as a decimal/12, number of months in loan term, loan amount, with fees) =PMT(.04/12, 60, 13000) =RATE(number of months in loan term, estimated monthly payment, value of loan minus fees)*12. =RATE(60,-239.41,12500)*12.