How do you calculate the APR on a car loan?

What do I do to calculate the APR on my car loan? I’m trying to compare my current loan to other options but I’m having trouble finding the APR.

You can use Microsoft Excel or Google Sheets to calculate the APR on your car loan. You’ll need to know:
  • Your monthly payment amount
  • The term of the loan
  • The value of the loan without fees
If you don’t know your monthly payment amount, you can calculate it by typing this formula into a blank cell in your spreadsheet: =PMT(interest rate as a decimal/12, number of months in loan term, loan amount, with fees)
The result should be a negative number. Once you have this number, you can calculate your APR by typing in this formula: =RATE(number of months in loan term, estimated monthly payment as a negative number, value of loan minus fees)*12
The result should be an approximate APR for your loan.
Car loan APRs can be complicated, but it’s easy to save on your car insurance when you use the Jerry app! Just download the app and answer some quick questions to see your policy options in a comprehensive list. When you find a quote you like, Jerry can help you cancel your old policy and sign up.
Liz Jenson
Answered on Dec 14, 2021

Did this answer help you?

Ask us a question by email and we will respond within a few days.

Have a different question?

You can meet us at our office and discuss the details of your question.
Let Jerry’s experts help you find savings on your car insurance!
No long forms or spam · Get quotes from 40+ carriers
Find insurance savings (100% Free)
rating primary
4.7/5 Rating on App Store

Easiest way to compare and buy car insurance

No long forms
No spam or unwanted phone calls
Quotes from top insurance companies
Find insurance savings — it's 100% free