The formula: multiply the loan amount by the monthly interest rate, then divide by what you still owe

The standard way to calculate a monthly car payment uses four pieces of information: the amount you're borrowing, the interest rate, how many months you'll be paying, and a mathematical formula that accounts for how interest compounds each month. The formula is:

Monthly Payment = [Loan Amount × Monthly Interest Rate × (1 + Monthly Interest Rate)^Number of Payments] ÷ [(1 + Monthly Interest Rate)^Number of Payments − 1]

This looks complicated, but it solves a real problem: your lender wants to be paid back gradually, and they charge interest on the balance that remains each month. The formula spreads that interest across all your payments so each one is the same amount. You don't need to do this math by hand—a calculator, spreadsheet, or lender's tool will do it for you—but understanding what the numbers mean helps you see why your payment is what it is.

The monthly interest rate is not the annual rate divided by 12. If your loan carries a 6% annual rate, you divide 6 by 100 to get 0.06, then divide that by 12 to get 0.005 as your monthly rate. That 0.005 is what goes into the formula.

Key Takeaways

  • Monthly payment depends on three things: how much you borrow, the annual interest rate, and how many months you have to repay it.
  • The monthly interest rate is the annual rate divided by 100, then divided by 12—a 6% annual rate becomes 0.005 per month.
  • A spreadsheet or online calculator will do the math faster and more accurately than doing it by hand.
  • Changing the loan term (36 months versus 60 months) changes your monthly payment more than small changes to the interest rate do.
  • The payment formula assumes you make the same payment every month and that the interest rate does not change.

Breaking down each number: loan amount, rate, and term

The loan amount is what you actually borrow—the car's price minus your down payment. If the car costs $25,000 and you put down $5,000, you're borrowing $20,000. Some dealers roll fees or add-ons into the loan, so check your paperwork to see what number the lender is actually using.

The interest rate comes from your credit score, the lender's policies, and market conditions. A dealer might quote you 4.9%, 6.2%, or 8.5%—these are annual rates. The lender will tell you this rate before you sign, and it should be in writing on your loan agreement. If the rate varies (some loans have adjustable rates, though this is rare for cars), the payment calculation changes when the rate changes.

The loan term is how many months you have to repay. Common terms are 36, 48, 60, or 72 months. A longer term spreads the payments over more months, so each payment is smaller—but you pay more interest overall because you're borrowing the money for longer. A 60-month loan at 6% costs more in total interest than a 48-month loan at the same rate, even though your monthly payment is lower.

Using a spreadsheet to calculate the payment yourself

Excel, Google Sheets, and most spreadsheet programs have a built-in function called PMT that does this calculation for you. The syntax is:

=PMT(rate, nper, pv)

Here, "rate" is your monthly interest rate (annual rate divided by 100, then divided by 12), "nper" is the number of payments, and "pv" is the loan amount as a negative number. For a $20,000 loan at 6% annual interest over 60 months, you would type:

=PMT(0.06/12, 60, -20000)

The spreadsheet returns a number like 386.66, which is your monthly payment. The negative sign on the loan amount tells the spreadsheet you're borrowing money (money going out), so the result comes back as a positive payment (money you owe each month). If you forget the negative sign, the result will be negative and look wrong.

You can change any of the three numbers and see how the payment shifts. Try 72 months instead of 60, or 7% instead of 6%, and watch the payment change. This is useful for comparing offers: if one lender quotes you 5.9% for 60 months and another quotes 6.5% for 48 months, you can calculate both and see which payment fits your budget.

Online calculators and what they show you

Most banks, credit unions, and car dealers have payment calculators on their websites. You enter the loan amount, interest rate, and term, and the calculator shows your monthly payment when ready. Many also show you a breakdown: how much of your first payment goes to interest versus principal, and how much total interest you'll pay over the life of the loan.

These calculators are accurate as long as you enter the right numbers. The catch is that they assume a fixed interest rate—if your rate changes during the loan, the payment calculation changes too. They also don't account for taxes, registration fees, or insurance, which are separate costs you'll pay on top of the loan payment.

Some calculators let you add a down payment, and they'll subtract it from the car price before calculating the loan amount. This is helpful for seeing how a larger down payment lowers your monthly payment. A $5,000 down payment instead of $2,000 reduces the loan amount by $3,000, which noticeably lowers your monthly cost.

Why the interest rate matters more than you might think

A 1% difference in interest rate does not sound like much, but it adds up. On a $20,000 loan over 60 months, the difference between 5% and 6% is about $20 per month—$1,200 over the life of the loan. The difference between 6% and 7% is another $20 per month. These gaps widen on larger loans or longer terms.

Your interest rate depends mainly on your credit score. Lenders see a higher score as lower risk, so they offer a lower rate. If your score is below 620, you may face rates above 10%. If it's above 740, you might get rates below 5%. Checking your credit report before you shop for a car gives you a realistic sense of what rate to expect, and it lets you fix errors that might be dragging your score down.

You can sometimes negotiate the rate with a dealer or shop around between lenders. A credit union often offers lower rates than a bank or dealer, especially if you're a member. Getting pre-approved for a loan before you go to the dealership tells you what rate you may have access to for, so you know whether the dealer's offer is competitive.

How the loan term changes your total cost

Stretching the loan from 48 to 72 months lowers your monthly payment but raises your total interest cost. Here's why: you're borrowing the money for 24 extra months, and the lender charges interest for those extra months. The longer you owe money, the more interest you pay.

On a $20,000 loan at 6%, a 48-month term costs about $2,150 in total interest. A 60-month term costs about $3,180 in total interest. A 72-month term costs about $4,300 in total interest. Your monthly payment drops from $469 to $386 to $333, but you're paying an extra $2,150 in interest to get that lower monthly payment.

The choice between terms depends on your budget. If you can afford the higher payment, a shorter term saves you money. If you need the lower payment to fit your monthly expenses, a longer term is the trade-off. Some people choose a middle ground: a 60-month loan balances a reasonable payment with moderate total interest.

What happens if your rate is variable or changes mid-loan

Most car loans have a fixed interest rate, meaning the rate stays the same for the entire loan. Your payment never changes. But some loans, especially older ones or those from certain lenders, have adjustable rates that change on a set schedule or when market conditions shift.

If your rate is adjustable, the payment calculation only works for the period before the rate changes. Once the rate adjusts, the lender recalculates your remaining balance and your new payment based on the new rate and the remaining months. Your payment could go up or down depending on whether rates rose or fell.

Before you sign a loan, ask whether the rate is fixed or adjustable. If it's adjustable, ask when it changes, what it can change to, and whether there's a cap on how high it can go. This information should be in your loan agreement. Fixed-rate loans are simpler to budget for because your payment never changes.

Frequently Asked Questions

Can I calculate my payment if I don't know the exact interest rate yet?

Yes. Use the rate range your lender quoted you and calculate both the low and high end. This shows you the range your payment could fall into. Once you have a firm rate offer, recalculate with the exact number.

Does the down payment affect the interest rate?

No. The interest rate is based on your credit score and the lender's policies, not on how much you put down. A larger down payment lowers the loan amount, which lowers your monthly payment, but it doesn't change the rate itself.

What if I want to pay off the loan early—does the formula still work?

The formula calculates your regular monthly payment. If you pay extra or pay off the loan early, you'll pay less total interest because you're not borrowing the money for the full term. Your lender should tell you whether there's a prepayment penalty (most car loans don't have one).

Why is my actual payment different from what the calculator showed?

The most common reason is that the calculator didn't include taxes, registration, or dealer fees that got rolled into the loan. Check your loan paperwork to see the exact amount financed—that's the number to use in the calculator.

How do I know if the interest rate I'm being offered is fair?

Compare offers from at least two lenders—a bank, a credit union, and the dealer. Your credit score determines the range you'll see, so checking your score beforehand tells you what to expect. Rates also vary by region and market conditions, so there's no single "fair" rate, but you can see what's typical for your situation.