The basic formula: what you need to know
To calculate a monthly loan payment, you need three pieces of information: the loan amount (called the principal), the annual interest rate, and how many months you have to repay it. The formula that banks and lenders use is:
Monthly Payment = P × [r(1 + r)^n] / [(1 + r)^n − 1]
In this formula, P is your principal, r is your monthly interest rate (annual rate divided by 12), and n is the total number of payments. This is called the amortization formula, and it's the same one lenders use on your loan documents.
If the math feels heavy, that's because it is—which is why most people use a calculator instead of pencil and paper. But understanding what the formula does helps you see why a longer loan term means lower monthly payments but more total interest paid.
Key Takeaways
- You need the loan amount, annual interest rate, and number of months to repay before you can calculate a payment.
- The monthly interest rate is always the annual rate divided by 12, regardless of the loan type.
- Online calculators and spreadsheet functions (like Excel's PMT function) do the amortization formula for you in seconds.
- A longer loan term lowers your monthly payment but increases the total amount of interest you pay over the life of the loan.
- Your actual payment may differ slightly from the calculated amount because of rounding, fees, or insurance added by the lender.
Working through a real example
Say you borrow $20,000 at 6% annual interest over 5 years (60 months). First, convert the annual rate to a monthly rate: 6% ÷ 12 = 0.5% per month, or 0.005 as a decimal.
Plugging into the formula: Monthly Payment = $20,000 × [0.005(1.005)^60] / [(1.005)^60 − 1]. Working through the exponents: (1.005)^60 = 1.3489. So the numerator is $20,000 × [0.005 × 1.3489] = $20,000 × 0.006745 = $134.90. The denominator is 1.3489 − 1 = 0.3489. Dividing: $134.90 ÷ 0.3489 = $386.66 per month.
Over 60 months, you pay $386.66 × 60 = $23,199.60 total. The difference between what you borrowed and what you paid back—$3,199.60—is the interest.
Using a calculator or spreadsheet instead
Most people don't calculate by hand. Online loan calculators are free and when ready: you enter the principal, rate, and term, and the calculator does the formula. Many banks and credit card companies have calculators on their websites.
If you use a spreadsheet like Excel or Google Sheets, the PMT function does the same work. The syntax is =PMT(rate, nper, pv). For the example above, you'd type =PMT(0.005, 60, -20000). The negative sign on the principal tells the spreadsheet you're borrowing money. The result is -$386.66 (the negative sign means money leaving your account).
Spreadsheets are useful if you want to test different scenarios quickly—what if the rate were 5% instead of 6%, or the term were 7 years instead of 5. You can change one number and see the payment recalculate when ready.
Why the interest rate matters more than you might think
A small difference in interest rate creates a large difference in total cost. Using the same $20,000 loan over 5 years, compare these three rates:
| Annual Rate | Monthly Payment | Total Paid Over 5 Years | Total Interest |
|---|---|---|---|
| 4% | $368.33 | $22,099.80 | $2,099.80 |
| 6% | $386.66 | $23,199.60 | $3,199.60 |
| 8% | $405.53 | $24,331.80 | $4,331.80 |
The difference between 4% and 8% is only $37.20 per month, but it costs you $2,232 more in total interest. This is why shopping for a better rate—even a fraction of a percent—matters on larger loans like mortgages or car loans.
How loan term length changes your payment
Stretching out the repayment period lowers your monthly payment but increases total interest. Using the same $20,000 loan at 6% interest, here's what happens when you change the term:
| Loan Term | Monthly Payment | Total Paid | Total Interest |
|---|---|---|---|
| 3 years (36 months) | $599.55 | $21,583.80 | $1,583.80 |
| 5 years (60 months) | $386.66 | $23,199.60 | $3,199.60 |
| 7 years (84 months) | $305.41 | $25,654.44 | $5,654.44 |
A 3-year loan costs $213 more per month than a 5-year loan, but you save $1,615.80 in interest. A 7-year loan drops the payment to $305, but you pay $2,454.84 more in total interest than the 5-year option. The trade-off is always the same: lower monthly payment, higher total cost.
What your actual payment might include beyond the formula
The number you calculate is the principal and interest payment only. Your actual monthly bill may be higher because lenders often add other costs.
On a mortgage, your payment includes principal, interest, property taxes, homeowners insurance, and sometimes mortgage insurance (PMI). On a car loan, you might pay principal, interest, and gap insurance. Credit cards don't use this formula at all—they charge interest monthly on your balance, not on a fixed payment.
Always check your loan documents or call your lender to confirm what's included in the payment you see on your bill. The amortization formula gives you the core number, but the real payment is often slightly higher.
Frequently Asked Questions
What's the difference between APR and the interest rate I use in the formula?
APR (annual percentage rate) includes fees and costs beyond the interest rate itself. For the payment formula, use the interest rate alone, not the APR. Your loan documents will list both—use the interest rate for calculations.
Can I use this formula for credit cards?
No. Credit cards don't work on a fixed payment schedule. Interest is calculated monthly on your current balance, and your payment is up to you. If you want to know how long it takes to pay off a credit card balance, you need a different calculator that accounts for variable interest and changing balances.
What if I want to pay off the loan early?
The formula tells you what you owe each month if you stick to the schedule. If you pay extra, you reduce the principal faster, which means less interest accrues in future months. Your lender can tell you the exact payoff amount if you want to settle the loan early—it's usually less than the remaining scheduled payments.
Does the formula work the same for all types of loans?
Yes, as long as the interest rate is fixed for the entire loan term. It works for car loans, personal loans, mortgages, and student loans. It does not work for variable-rate loans, where the interest rate changes over time, because the payment changes too.
Why do banks use this formula instead of just dividing the total cost by the number of months?
Because you're paying interest on money you've already repaid. Early in the loan, most of your payment goes to interest; later, most goes to principal. The amortization formula accounts for this shift. If lenders just divided total cost by months, you'd pay too much interest early and too little late.