The basic formula: loan amount, interest rate, and loan term

Your monthly car payment comes from three numbers: how much you borrowed, the interest rate the lender charges, and how many months you have to pay it back. The lender uses a standard formula to divide the total cost (principal plus interest) into equal monthly chunks. You can calculate this yourself with a calculator, a spreadsheet, or by hand if you understand the pieces.

The formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1], where M is your monthly payment, P is the loan amount, r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments. This looks complicated, but a spreadsheet or online calculator does the work. What matters is understanding what each number means and where to find it.

Key Takeaways

  • Your monthly payment depends on the loan amount, the annual interest rate, and the number of months you have to repay—usually 36, 48, 60, or 72 months.
  • A higher interest rate or longer loan term both increase your total payment, even though a longer term spreads payments across more months.
  • You can calculate your payment using a spreadsheet formula, an online calculator, or by asking the lender directly—all three should give you the same number.
  • The payment shown before you sign is not final if the interest rate or loan amount changes; always confirm the exact terms in writing before you commit.

Where to find the three numbers you need

The loan amount is the price of the car minus any down payment you make. If you buy a car for $25,000 and put down $5,000, your loan amount is $20,000. Some dealers roll fees into the loan, so the amount you borrow may be slightly higher than the sticker price minus your down payment. Ask the dealer or lender to write down the exact loan amount before you calculate.

The interest rate comes from your lender—a bank, credit union, or the dealer's financing arm. This is called the annual percentage rate, or APR. It varies based on your credit score, the loan term, and current market rates. A lender will tell you the APR before you sign the loan agreement. If you are shopping around, get the APR in writing from each lender so you can compare fairly.

The loan term is how many months you have to pay back the loan. Common terms are 36, 48, 60, or 72 months. Some lenders offer 84-month loans. The longer the term, the lower your monthly payment—but you pay more interest overall because you are borrowing the money for longer. You choose the term when you explore for the loan, and it is part of the contract you sign.

Using a spreadsheet to calculate your payment

If you use Excel, Google Sheets, or another spreadsheet program, you can use the PMT function to calculate your monthly payment. The syntax is: =PMT(rate, nper, pv). The rate is your monthly interest rate (annual APR divided by 12, expressed as a decimal), nper is the number of payments, and pv is the loan amount as a negative number.

Example: you borrow $20,000 at 6.5% APR for 60 months. Your monthly rate is 0.065 ÷ 12 = 0.00542. In a spreadsheet cell, type =PMT(0.00542, 60, -20000). The result is $386.56 per month. The negative sign on the loan amount tells the spreadsheet you are borrowing money, not receiving it. If you forget the negative sign, the result will be negative, which just means you need to flip the sign.

This method is useful because you can change any number and see how it affects your payment when ready. Try a 72-month term instead of 60, or a 7% rate instead of 6.5%, and watch the payment drop or rise. This helps you understand the trade-offs before you commit to a loan.

Online calculators and what they show

Most banks, credit unions, and car-buying websites offer free payment calculators. You enter the loan amount, APR, and term, and the calculator shows your monthly payment. Some also break down how much of each payment goes toward interest versus principal, and show your total interest paid over the life of the loan.

These calculators are accurate as long as you enter the right numbers. The catch is that the numbers you enter must match what the lender actually offers. If you estimate your APR or round the loan amount, your calculated payment will be close but not exact. Once you have a loan offer in writing, use the exact numbers from that offer to verify the payment.

Some calculators also let you see what happens if you make extra payments or pay off the loan early. This is useful for understanding whether paying down the principal faster saves you money on interest—it does, but the savings depend on your specific rate and term.

How interest rate and loan term change your payment

A higher interest rate increases your monthly payment and your total interest paid. A 1% difference in APR can mean $20 to $40 more per month on a $20,000 loan, depending on the term. Over a 60-month loan, that adds up to $1,200 to $2,400 in extra interest.

A longer loan term lowers your monthly payment but raises your total interest. A $20,000 loan at 6% costs about $386 per month over 60 months, or about $323 per month over 72 months. The monthly payment is lower, but you pay about $1,000 more in total interest because you are borrowing for 12 extra months. This is the core trade-off: lower monthly payment now, or less total interest paid over time.

Your credit score affects the APR you are offered. A higher credit score usually means a lower rate. If your score is below 620, you may not be approved for a standard auto loan, or you may be offered a rate of 10% or higher. Improving your credit before you explore for a car loan can save you thousands in interest.

What happens if the terms change before you sign

A lender may give you a payment estimate before the loan is final. This estimate is based on the numbers you provided, but the actual payment can change if the loan amount, APR, or term changes. If the dealer adds fees, your loan amount goes up and so does your payment. If the lender adjusts your APR after a credit check, your payment changes. If you choose a different term at the last minute, your payment changes.

Always ask the lender to confirm the exact payment in the final loan agreement before you sign. The agreement should show the loan amount, APR, term, and monthly payment. If any of these numbers differ from what you calculated or were quoted, ask the lender to explain the difference. Do not sign until you understand and agree with every number.

Frequently Asked Questions

Does my down payment affect my monthly payment?

Yes. A larger down payment reduces the loan amount, which lowers your monthly payment. If you put down $7,000 instead of $5,000 on a $25,000 car, you borrow $18,000 instead of $20,000, and your payment drops accordingly. Down payments also reduce your total interest paid because you are borrowing less.

Can I calculate my payment if I don't know my APR yet?

You can estimate using a typical rate for your credit range, but the real payment depends on the rate the lender offers. Credit unions and banks publish their current rates, so you can use those as a starting point. Once you have a formal loan offer, use the exact APR from that offer to calculate your final payment.

What if I want to pay off the loan early?

Your monthly payment stays the same, but paying extra principal reduces the total interest you pay and shortens the loan term. If your loan agreement allows prepayment without penalty, you can send extra money with your regular payment or make a lump-sum payment toward principal. Ask your lender whether they charge a prepayment penalty before you do this.

Why is my actual payment different from what I calculated?

The most common reasons are that the loan amount, APR, or term changed between your calculation and the final agreement. Some lenders also add fees that get rolled into the loan, increasing the amount you borrow. Always compare your calculated payment to the payment shown in the final loan documents and ask the lender to explain any difference.

Does my monthly payment include insurance and registration?

No. Your monthly car payment covers only the loan principal and interest. Insurance, registration, taxes, and maintenance are separate costs you pay outside the loan. Some lenders offer bundled products that include insurance, but those are optional add-ons, not part of the standard payment calculation.