How do you work out the APR on a car loan?
Is there a way that I can work out the APR on a car loan on my own? I just want to know the exact rate so I can compare it to other places.
It’s important to shop around for the best loan, so it’s great you’re calculating your APR. To work out the APR on a car loan, you can contact your lender. They can give you information about your loan, including the APR or any other information that you’d like to know. Once you have an official agreement, you can also use that to find your loan’s information.
If you’d rather work out the APR yourself, you can use the RATE function on Microsoft Excel or Google Sheets. Just type in the following equation:
**=RATE(number of payments, payment amount, value of loan minus any fees required to get the loan, final value) 12**
Once you’ve typed this equation into a blank cell on Excel, plug in the numbers specific to your car loan. Be sure not to include any fees in the loan value, as this will change the APR value. You should use 0 for the final value and put a negative sign in front of the payment amount.
You can also figure out the APR by hand using the following equation:
APR = (((total fees + total interest / principal) / days in the loan term) 365) 100)
Again, you’ll need to review your loan documents or contact your lender to find the correct numbers.
It might take some work to find your loan APR, but it’s quick and easy to find the right insurance policy for your vehicle 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 will help you switch companies.
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.
Read advice from car experts at Jerry
Browse by topics
What others are asking
What is the cheapest car loan rate?
How low is the cheapest possible car loan rate? I’ve been comparing deals from different lenders, and I’ve gotten some pretty low offers! That said, I’m wondering if I can get an even cheaper interest rate.
Dec 08, 2021
What is the going interest rate on a car loan?
I’m about to start looking for car loans, but I want to make sure I have an idea of what a good deal looks like before I start. As of now, what’s the average going interest rate on a car loan?
Dec 08, 2021
What is the normal interest rate for a car loan?
I just got an offer for a car loan, but the interest rate seems kind of high. That said, I don’t have a frame of reference. In general, what is the normal interest rate I should expect for a car loan?
Dec 08, 2021