The basic formula for a monthly car payment

A monthly car payment comes down to three numbers: how much you're borrowing, the interest rate, and how many months you have to pay it back. Banks use a standard formula to turn those three numbers into your monthly payment amount.

The simplest way to understand it: if you borrowed $20,000 at 0% interest over 60 months, you'd pay $20,000 ÷ 60 = $333 per month. But almost no one gets 0% interest. When interest is involved, the math gets more complex because you're paying interest on the remaining balance each month, not on the full original amount.

The actual formula that lenders use is: Monthly Payment = [Principal × (Rate × (1 + Rate)^Months)] ÷ [((1 + Rate)^Months) − 1]. You don't need to memorize this — a calculator or spreadsheet does the work — but knowing what goes into it helps you understand why your payment is what it is.

Key Takeaways

  • Your monthly payment depends on three things: the loan amount (principal), the annual interest rate, and the number of months to repay.
  • You can calculate your payment using an online calculator, a spreadsheet formula, or by asking your lender for an estimate before you sign anything.
  • A higher interest rate or shorter loan term raises your monthly payment; a lower rate or longer term lowers it.
  • The payment you calculate should match what the lender shows you in writing before you finalize the loan.

What each number means and where to find it

Principal is the amount of money you're borrowing. If you're buying a $25,000 car and putting $5,000 down, your principal is $20,000. If you're refinancing an existing loan, your principal is the balance you still owe, not the original loan amount.

Interest rate is the annual percentage rate, often called APR. This is the cost of borrowing, expressed as a yearly percentage. A lender might offer you 4.5% APR, for example. You'll find this number in the loan estimate the lender gives you before you sign — it's required by law to be clearly shown. Different lenders offer different rates based on your credit history, income, and the car's age and condition.

Loan term is how many months you have to repay the loan. Common terms are 36, 48, 60, or 72 months. A shorter term (36 months) means higher monthly payments but less interest paid overall. A longer term (72 months) means lower monthly payments but more interest paid over time.

Using an online calculator

The fastest way to see what your payment will be is an online auto loan calculator. You enter the loan amount, the interest rate, and the number of months, and the calculator does the formula work for you when ready. Most banks and credit unions have calculators on their websites, and many car-buying websites have them too.

When you use a calculator, the number it shows you is an estimate. The actual payment might be slightly different because of how the lender rounds, or because of fees or taxes that get added. But it's accurate enough to compare different loan offers or to see how changing the term or rate changes your payment.

To use a calculator accurately, make sure you're entering the right numbers. The loan amount should be the amount you're actually borrowing, not the car's price. The interest rate should be the APR the lender quoted you, not a different rate you found elsewhere. And the term should be in months, not years.

Doing the math in a spreadsheet

If you want to build your own calculation, most spreadsheet programs (Excel, Google Sheets, and others) have a built-in function for this. In Excel or Google Sheets, the function is called PMT. The formula looks like this: =PMT(rate, nper, pv), where rate is your monthly interest rate, nper is the number of months, and pv is the loan amount as a negative number.

To use it, you need to convert your annual interest rate to a monthly rate. If your APR is 4.8%, divide it by 12 and by 100: 4.8 ÷ 12 ÷ 100 = 0.004. Then enter the formula. For a $20,000 loan at 4.8% APR over 60 months, you'd type: =PMT(0.004, 60, -20000). The spreadsheet will show you the monthly payment.

A spreadsheet is useful if you want to test different scenarios quickly — what if the rate drops to 4.2%? What if you extend the loan to 72 months? You can change one number and see the new payment when ready.

How interest rate and loan term affect your payment

The interest rate has a direct effect on your monthly payment. A higher rate means you pay more each month. The difference might seem small at first — the difference between 4% and 5% APR might only be $20 or $30 per month on a typical loan — but it adds up. Over a 60-month loan, that $25 monthly difference equals $1,500 in extra interest.

The loan term also changes your payment in a predictable way. If you shorten the term from 60 months to 48 months, your monthly payment goes up because you're paying back the same amount of money in less time. If you extend it from 60 to 72 months, your monthly payment goes down, but you pay more interest overall because you're borrowing the money for longer.

There's a trade-off between these two. A shorter loan term means higher monthly payments but less total interest. A longer term means lower monthly payments but more total interest. The right choice depends on what monthly payment you can afford and how much total interest you're willing to pay.

What to do with your calculated payment

Once you've calculated what your payment will be, use that number to decide whether the loan makes sense for your budget. A common rule is that your car payment should not be more than 15% to 20% of your monthly take-home pay. If your monthly payment comes out to more than that, the loan might be stretching your budget too thin.

Before you sign any loan paperwork, ask the lender for a written loan estimate. This document will show you the exact monthly payment, the interest rate, the loan term, and the total amount of interest you'll pay over the life of the loan. Compare this to your calculation — they should match or be very close. If they don't match, ask the lender why.

Keep in mind that your actual monthly payment might include more than just principal and interest. Some lenders add insurance, taxes, or fees to the payment. These should all be shown separately on your loan estimate so you can see exactly what you're paying for.

Frequently Asked Questions

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

Calculators show the principal and interest only. Your actual payment might include sales tax, registration fees, insurance, or other charges that the lender adds. Ask your lender for an itemized breakdown so you can see what each part of your payment covers.

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

Yes. You can use an estimated rate to see what a range of payments might look like. If you have fair credit, try 5% to 7%. If you have good credit, try 3% to 5%. This gives you a ballpark figure. Once a lender gives you an actual rate, recalculate with that number.

What happens to my payment if I pay off the loan early?

Your monthly payment stays the same. But if you pay extra toward principal each month, or make a lump-sum payment, you reduce the total amount of interest you pay and shorten how long you're in debt. Check with your lender first — some loans have penalties for early payoff, though most car loans do not.

Does the calculator account for taxes and fees?

No. A basic auto loan calculator shows only principal and interest. Sales tax, registration, documentation fees, and dealer fees are separate. Your lender's loan estimate will show all of these added together, which is the true total you'll owe.

If I put more money down, how much does my payment drop?

Every dollar you put down reduces the principal by that dollar. If you put down an extra $2,000, your loan amount drops by $2,000, which lowers your monthly payment. Use a calculator to see the exact difference — it depends on your interest rate and loan term.