Is there a calculator to show how much interest will I pay on my car loan?
Is there a way to know how much interest I’ll pay on my car loan, or is there a calculator that I can use? I want to know how much my loan will cost me so that I know if I should refinance it or not.
using Microsoft Excel or Google Sheets! Just type this formula into a blank cell:
=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)
When you plug in the values specific to your loan and hit enter, the resulting value should be the amount of interest that you’ll pay throughout your loan.
app? Just download the app to compare quotes from multiple lenders without the hassle of researching multiple lenders on your own. Jerry’s app instantly connects you with top companies to help you find a loan that best meets your needs. On average, car owners pay $85 less every month by refinancing their auto loan.
MORE: Does refinancing a car hurt your credit score?
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.