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.