The basic formula: principal, interest rate, and loan term
Your monthly car payment comes from three numbers: the amount you borrowed, the interest rate your lender charges, and how many months you have to repay it. 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 what each piece means.
The formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1]. Here, M is your monthly payment, P is the principal (the amount borrowed), r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments. It looks complicated, but the math is straightforward once you plug in your actual numbers.
Most people do not calculate this by hand. A spreadsheet or online calculator does the work in seconds. But understanding what the formula does—how it spreads the cost across months and builds in interest—helps you see why a longer loan term lowers your monthly payment but costs you more overall.
Key Takeaways
- Your monthly payment depends on three things: how much you borrowed, your interest rate, and how many months you have to pay it back.
- A longer loan term (60 months instead of 48) lowers your monthly payment but increases the total interest you pay over the life of the loan.
- The interest rate matters more than most borrowers realize—a 1% difference in rate can add hundreds of dollars to your total cost.
- You can calculate your payment using a spreadsheet formula, an online calculator, or by asking your lender for an amortization schedule.
- Your actual monthly payment may be higher than the calculated amount if it includes insurance, taxes, or fees rolled into the loan.
Breaking down the three numbers you need
The principal is the amount you actually borrow. If you buy a car for $25,000 and put down $5,000, your principal is $20,000. Some loans include fees or taxes rolled into the principal; your loan documents will show the exact figure.
The interest rate is what the lender charges you for borrowing. Rates vary widely based on your credit score, the lender, the loan term, and current market conditions. A rate of 4.5% annual means you pay 4.5% of the outstanding balance each year. To use it in the formula, divide by 12 to get the monthly rate: 4.5% ÷ 12 = 0.375% per month, or 0.00375 as a decimal.
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, making each one smaller—but you pay more interest overall because you owe money for longer.
A worked example with real numbers
Say you borrow $20,000 at 5% annual interest over 60 months. First, convert the annual rate to a monthly decimal: 5% ÷ 12 = 0.4167% per month, or 0.004167 as a decimal. Your principal P is 20,000, your monthly rate r is 0.004167, and your number of payments n is 60.
Plugging into the formula: M = 20,000 × [0.004167(1.004167)^60] / [(1.004167)^60 − 1]. The calculation yields approximately $377 per month. Over 60 months, you pay $22,620 total—meaning you paid $2,620 in interest.
If you shortened the term to 48 months at the same rate, your monthly payment would rise to about $460, but your total interest would drop to roughly $1,880. The shorter loan costs you more each month but less overall. If you extended to 72 months, your payment would fall to around $333, but total interest would climb to about $3,960.
Using a spreadsheet to calculate your payment
In Excel, Google Sheets, or any spreadsheet program, use the PMT function. The syntax is: =PMT(rate, nper, pv). Here, rate is your monthly interest rate as a decimal, nper is the number of payments, and pv is the principal as a negative number (spreadsheets treat borrowed money as negative).
For the example above, you would type: =PMT(0.004167, 60, -20000). The result is $377.42. You can change any number and when ready see how the payment shifts. This is the fastest way to compare loan scenarios—different rates, different terms, different down payments—without doing the math by hand.
Most lenders also provide an amortization schedule, a month-by-month breakdown showing how much of each payment goes to principal and how much to interest. Early payments are mostly interest; later payments are mostly principal. Asking your lender for this schedule before you sign gives you a clear picture of the loan's true cost.
Why the interest rate makes such a difference
A 1% difference in interest rate sounds small, but it compounds across months. On a $20,000 loan over 60 months, the difference between 4% and 5% is about $40 per month—roughly $2,400 over the life of the loan. The difference between 5% and 6% is another $40 per month.
Your interest rate depends on your credit score, the lender's current rates, whether the loan is secured (backed by the car) or unsecured, and the loan term. A longer term often comes with a higher rate. Before you accept a loan offer, compare rates from multiple lenders—banks, credit unions, and online lenders all price differently. Even a 0.5% difference is worth shopping for on a large loan.
What happens when you add insurance, taxes, and fees
The payment you calculate is the pure loan payment—principal plus interest. But your actual monthly bill may be higher. Some lenders roll in gap insurance (which covers the difference between what you owe and the car's value if it is totaled), extended warranties, or loan origination fees. These get added to the principal, raising your monthly payment.
Property taxes and registration fees vary by state and are sometimes financed as part of the loan. If your lender finances these, they increase the principal and therefore the monthly payment. Always ask your lender for the total amount financed—that is the number to use in your calculation, not just the car's purchase price.
Some states require you to carry loan-related insurance (like gap insurance) as a condition of financing. Others make it optional. Your loan documents will specify what is included and what is not. If you are unsure, ask the lender to break down the financed amount line by line.
Comparing loan offers side by side
When you have multiple loan offers, do not just compare the monthly payment. Calculate the total amount you will pay over the life of each loan. A lower monthly payment on a longer term might cost you more overall than a higher payment on a shorter term.
| Loan Term | Interest Rate | Monthly Payment | Total Paid Over Life of Loan | Total Interest |
|---|---|---|---|---|
| 48 months | 4.5% | $460 | $22,080 | $2,080 |
| 60 months | 4.5% | $368 | $22,080 | $2,080 |
| 60 months | 5.5% | $377 | $22,620 | $2,620 |
| 72 months | 5.5% | $315 | $22,680 | $2,680 |
Notice that the 48-month loan at 4.5% and the 60-month loan at 4.5% have the same total cost but different monthly payments. The 72-month loan looks cheapest per month but costs slightly more overall. This table shows why comparing only the monthly payment is misleading.
Frequently Asked Questions
Can I calculate my payment if I do not know my interest rate yet?
Yes. Use the average rate for your credit range as a placeholder. If you have good credit, try 4% to 5%; if fair credit, try 6% to 7%. This gives you a ballpark figure. Once a lender quotes you an actual rate, recalculate with the real number. The formula works the same way.
What if I want to pay off the loan early?
The monthly payment stays the same, but you pay less total interest because you owe money for fewer months. Some loans charge a prepayment penalty, though this is uncommon for car loans. Check your loan documents or ask your lender whether paying early costs you anything.
Does the down payment affect the monthly payment?
Yes, directly. A larger down payment lowers the principal you borrow, which lowers your monthly payment. A $5,000 down payment instead of $2,000 reduces the amount financed by $3,000, lowering your payment by roughly $50 to $60 per month depending on the rate and term.
Why do lenders quote different rates for different loan terms?
Longer loans carry more risk for the lender—more time for your circumstances to change or the car to lose value. Lenders typically charge higher rates for 72-month loans than 48-month loans to offset that risk. This is why comparing rates across different terms matters.
What if my credit score improves after I take out the loan?
Your current loan terms do not change automatically. You could refinance—take out a new loan at a better rate to pay off the old one—but you would start a new loan term and pay new fees. Refinancing makes sense only if the new rate is significantly lower and you plan to keep the car long enough to recoup the costs.