The formula for your monthly payment
Your monthly car loan payment is calculated using a standard formula that accounts for three things: the amount you borrowed, the interest rate, and how many months you have to repay it. Lenders use this same formula, so you can verify their math or estimate what a payment will be before you sign.
The formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1], where M is your monthly payment, P is the principal (the amount borrowed), r is your monthly interest rate (annual rate divided by 12), and n is the total number of payments.
You do not need to do this by hand. A calculator or spreadsheet will do it faster and more accurately. But understanding what goes into the number helps you see why a longer loan term lowers your monthly payment but costs you more in total interest.
Key Takeaways
- Your monthly payment depends on three factors: how much you borrowed, your interest rate, and the length of your loan in months.
- A longer loan term (60 months instead of 48) lowers your monthly payment but increases the total amount of interest you pay over the life of the loan.
- Online calculators and spreadsheet formulas produce the same result as your lender's calculation, so you can check their numbers before signing.
- Your actual payment may be higher if it includes insurance, taxes, or fees rolled into the loan, so ask your lender for the breakdown.
What information you need to gather
Before you calculate, collect three pieces of information from your loan documents or lender. First, the principal — the actual amount of money you borrowed, after any down payment. If you put $5,000 down on a $25,000 car, your principal is $20,000, not $25,000.
Second, your annual interest rate, usually shown as APR (annual percentage rate). This is the cost of borrowing, expressed as a percentage per year. A 6% APR means you pay 6% of the principal each year in interest. Your lender must disclose this before you sign.
Third, the loan term in months. Common terms are 36, 48, 60, or 72 months. A 60-month loan is five years. Check your contract to confirm — do not assume.
If your lender quoted you a monthly payment that seems high, ask whether it includes insurance, registration fees, or other costs bundled into the loan. These are separate from the principal and interest calculation and will inflate your payment.
Using an online calculator
The fastest way to calculate your payment is an online car loan calculator. Search "car loan payment calculator" and you will find dozens of free tools. Enter your principal, annual interest rate, and loan term in months, and the calculator returns your monthly payment in seconds.
Most calculators also show you a amortization schedule — a month-by-month breakdown of how much of each payment goes toward principal and how much toward interest. Early payments are mostly interest; later payments are mostly principal. This schedule helps you understand why paying extra toward principal early saves you significant interest over time.
Verify the calculator's result by trying a second one. If two independent calculators give you the same number, you can trust it. If they differ, check that you entered the same principal, rate, and term into both.
Doing the math in a spreadsheet
If you prefer to build your own calculation, most spreadsheet programs (Excel, Google Sheets, LibreOffice) have a built-in function for loan payments. In Excel, the function is =PMT(rate, nper, pv). In Google Sheets, it is the same.
Here is how to set it up: In one cell, enter your monthly interest rate (annual rate divided by 12). In another, enter the total number of payments. In a third, enter the principal as a negative number (this is a spreadsheet convention). Then in a fourth cell, type the PMT formula with those three cell references.
For example, if your annual rate is 6%, your term is 60 months, and your principal is $20,000, you would enter: =PMT(0.06/12, 60, -20000). The result is your monthly payment. The spreadsheet does the exponents and division for you.
Why your actual payment may differ from the calculation
The formula above calculates principal and interest only. Your actual monthly payment to the lender may be higher because it includes other costs.
Loan insurance (gap insurance or payment protection insurance) is sometimes added to the loan. Property taxes on the vehicle may be rolled in. Registration and title fees sometimes are. If you financed the down payment or rolled negative equity from a trade-in into the new loan, that increases your principal.
Ask your lender for an itemized payment breakdown before you sign. It should show principal and interest separately from any insurance, taxes, or fees. This tells you exactly what you are paying for and lets you decide whether to finance those costs or pay them upfront.
How loan term affects your total cost
A longer loan term lowers your monthly payment but raises the total amount you pay. Here is a concrete example: a $20,000 loan at 6% APR costs $366 per month for 60 months (total paid: $21,960) or $299 per month for 72 months (total paid: $21,528).
Wait — the 72-month loan costs less total? That is because the interest is spread over more months, so the monthly interest charge is smaller. But if you compare a 48-month term ($461/month, $22,128 total) to a 72-month term ($299/month, $21,528 total), the longer term saves you money overall.
The real trade-off is monthly cash flow versus total cost. A shorter term means higher monthly payments but less total interest paid. A longer term means lower monthly payments but more total interest paid. Your budget and how long you plan to keep the car should guide this choice.
What to do if the lender's payment does not match your calculation
If you calculate a monthly payment and the lender quotes you something different, do not assume you made an error. Ask the lender to explain the difference in writing.
Common reasons for a mismatch: the principal includes fees or insurance you did not account for, the interest rate is different from what you thought (check whether it is APR or a different rate), or the term is different. Some lenders also round payments to the nearest dollar, which can create small differences.
If the lender cannot explain the difference clearly, or if the explanation does not match your loan documents, ask to see the Truth in Lending Act (TILA) disclosure. This is a required document that shows the principal, interest rate, term, and total amount you will pay. It is your right to see it before you sign.
Frequently Asked Questions
Does my credit score affect the monthly payment calculation?
Your credit score does not change the formula, but it determines the interest rate the lender offers you. A higher credit score usually means a lower interest rate, which lowers your monthly payment. The calculation itself stays the same — you just plug in a different rate.
What if I want to pay off the loan early?
The monthly payment calculation assumes you make every payment on schedule. If you pay extra toward principal or pay off the loan early, you will pay less total interest. Your lender can tell you the payoff amount at any point, which accounts for interest already accrued.
Does the down payment affect the monthly payment?
Yes, but indirectly. A larger down payment lowers the principal you borrow, which lowers your monthly payment. If you put $10,000 down instead of $5,000, your principal drops by $5,000, and your monthly payment drops accordingly.
Can I use this formula for other loans?
Yes. The same formula works for personal loans, mortgages, and any fixed-rate loan where you make equal monthly payments. The only inputs that change are the principal, interest rate, and term.
What is the difference between APR and interest rate?
APR includes the interest rate plus other costs of borrowing, like origination fees. For car loans, APR is what you should use in the payment calculation because it reflects the true cost of the loan. Your lender must disclose the APR before you sign.