PriceProtect™
DriveShield™
GarageGuard™
Services
Insurance
Car Insurance
Compare Car Insurance with Jerry
Jerry’s Expert Advice
Car Insurance Estimates
Home & Renters Insurance
Renters Insurance
Loans
Car Loan
Compare Car Loans with Jerry
Jerry's Expert Advice
Car Loan Guides
Repairs
Car Repair Estimates
Repair Estimates for Popular Services
Advice
Read Car Content
Browse Jerry Car Advice
Check Out Expert Car QnA
Learn About How We Create Content
Jerry Data & Research
How do you count car loan interest?
Is there a way to count how much I will pay in car loan interest? I want to make sure that my loan is worth it before I get in over my head, but I'm not very good with numbers.
Liz Jenson · Updated on
Reviewed by Shannon Martin, Licensed Insurance Agent.
To count the amount of money that your car loan interest will cost you, you can
calculate the total interest paid by hand
using the following formula:
Monthly Payment = principal balance x (monthly interest rate (1 + monthly interest rate) loan term in months) / ((1+monthly interest rate)loan term in months - 1)Then, multiply the monthly payment by the number of payments you will make. The result will be the total amount that you’ll pay for your loan. To find the total interest paid, simply subtract the principal from this amount.
If you are unsure about any of the values in the equation, you can talk to your lender to learn more about your loan agreement. Your lender can also usually tell you your monthly payment amount!
If this seems like a lot of work, you can use Microsoft Excel or Google Sheets instead! To find the total interest charges on your loan, simply type in the following formula:
=CUMIPMT(yearly interest rate/12, duration of the loan in months, the loan amount before fees and interest, 1, the total number of payments you will make, 1)
Then, press the enter button to see the total interest that you will pay on the loan.
If you do decide to find a new loan, why not refinance with the
Jerry
app? Just download the app to compare quotes from multiple lenders without the hassle of researching and sending documents to potential lenders. Jerry’s app instantly connects you with top companies to help you find a loan that best meets your needs.MORE: What is APR and how is it calculated?
View full answer
- Gregory R.
WHY YOU CAN TRUST JERRY
Jerry partners with more than 50 insurance companies, but our content is independently researched, written, and fact-checked by our team of editors and agents. We aren’t paid for reviews or other content.
Join 4M+ members in lowering their car insurance
You Might Also Be Interested
Read Advice From Car Experts At Jerry
What Others Are Asking
Browse More Content
Insurance for Your Car
Insurance in Your State
Easiest way to compare and buy car insurance
No long forms
No spam or unwanted phone calls
Quotes from top insurance companies
