How to Calculate Loan Payments Monthly
To calculate loan payments monthly, use the formula M = P × [r(1 + r)n] / [(1 + r)n − 1], where P is the loan amount, r is the monthly interest rate (the annual rate divided by 12), and n is the number of monthly payments. For a $25,000 loan at 7% over five years, that works out to $495.03 a month — and $4,701.80 in total interest over the life of the loan.
This guide works through that example step by step, so you can repeat it with your own numbers, then shows where each payment goes, what the formula leaves out, and how changing the term changes the total you pay.
Key takeaways
- The formula gives you principal and interest only. Fees, add-ons, and — on a mortgage — taxes and insurance sit on top.
- A $25,000 loan at 7% over five years costs $495.03 a month, $29,701.80 in total, and $4,701.80 in interest.
- Dividing the loan by the months gives $416.67 — wrong by $78.36 a month, because it ignores interest entirely.
- In the first month, $145.83 of the payment is interest and only $349.20 reduces the balance. In the last month, $2.87 is interest and $492.16 goes to principal.
- A $15,000 loan at 8.9% costs $476.30 a month over three years but $240.58 over seven — and the seven-year loan costs $3,061.62 more in total interest.
- Paying an extra $100 a month on the $25,000 loan clears it in 49 months instead of 60 and saves $938.99 in interest.
The monthly loan payment formula
Every fixed-rate loan in the US — personal, auto, or mortgage — uses the same formula. It finds the single monthly payment that, paid every month, covers that month’s interest and brings the balance to exactly zero on the last payment. Written out:
M = P × [r(1 + r)n] / [(1 + r)n − 1]
| Symbol | What it is | How to get it |
|---|---|---|
| M | Monthly payment | This is the answer the formula gives you |
| P | Loan amount (principal) | The amount you actually borrow |
| r | Monthly interest rate, as a decimal | Annual rate as a decimal, divided by 12 |
| n | Total number of monthly payments | Loan term in years × 12 (60 for five years) |
Three points about the inputs are worth getting right before you touch a calculator. First, P is the amount you borrow, not the price of the thing you are buying — a $30,000 car with a $5,000 down payment is a $25,000 loan. Second, r is the monthly rate: 7% a year becomes 0.07 ÷ 12 = 0.0058333 a month, and using the annual rate by mistake produces a wildly wrong answer. Third, the rate in the formula is the note rate, not the APR. The APR folds lender fees into the cost of borrowing; using it here overstates the payment slightly, so keep the note rate for the calculation and use the APR for comparing offers.
Worked example: $25,000 at 7% for 5 years
Here is the formula with real numbers, one step at a time. Keep at least seven decimal places for r; rounding it early is the usual reason a hand calculation comes out a few dollars off.
Step 1 — Set the inputs. P = $25,000. Annual rate 7%, so r = 0.07 ÷ 12 = 0.0058333. Term five years, so n = 5 × 12 = 60 payments.
Step 2 — Work out (1 + r)n. (1.0058333)60 = 1.4176. Any scientific calculator or phone calculator handles this with the power key; in Excel it is =POWER(1.0058333,60).
Step 3 — Multiply the top of the fraction. P × r × (1 + r)n = 25,000 × 0.0058333 × 1.4176 = $206.74.
Step 4 — Work out the bottom of the fraction. (1 + r)n − 1 = 1.4176 − 1 = 0.4176.
Step 5 — Divide. M = 206.74 ÷ 0.4176 = $495.03 a month.
That is the fixed payment for all 60 months, assuming the rate never changes. Over the full term you will pay 60 × $495.03 = $29,701.80, of which $4,701.80 is interest. You can check the result against a loan calculator with the same three inputs — it should return the same figure to the cent. If your loan is for a car, an auto loan calculator runs the same calculation with the fields already labelled for vehicle loans.
Where each payment goes: the amortization schedule
The payment stays fixed, but what it buys changes every month. Interest each month is the current balance times r, and the rest of the payment reduces the balance. The Consumer Financial Protection Bureau (CFPB) puts it plainly: in an amortizing loan, a percentage of your monthly payment is applied to the principal and to the interest, and at the beginning of your loan term, more of your payment is generally applied toward the interest rather than the principal. The month-by-month table showing that split is called an amortization schedule.
Here is the schedule for the $25,000 example at the start, and at the end:
| Payment | Monthly payment | Interest | Principal | Remaining balance |
|---|---|---|---|---|
| Month 1 | $495.03 | $145.83 | $349.20 | $24,650.80 |
| Month 2 | $495.03 | $143.80 | $351.23 | $24,299.57 |
| Month 3 | $495.03 | $141.75 | $353.28 | $23,946.29 |
| Month 60 | $495.03 | $2.87 | $492.16 | $0.00 |
Two things in that table are worth noticing. First, the balance falls slowly at the start: after a full year of payments totalling $5,940.36, the balance has dropped by only $4,327.45, to $20,672.55. That is normal, not a mistake — the balance is at its largest in the early months, so the interest slice is at its largest too. Second, the split reverses gradually. Each month the balance is slightly smaller, so slightly less interest accrues and slightly more goes to principal, until the final payment is almost all principal. An amortization calculator lays out the full 60-month schedule for your own numbers.
What the formula leaves out
The $495.03 figure is principal and interest only, and for some loans it is not the number that leaves your bank account. What sits on top depends on the loan type:
- Origination fee. Many personal loans charge one, often 1% to 8% of the loan amount, and it is usually taken out of the money you receive rather than added to the payment. A $25,000 loan with a 5% fee hands you $23,750, while you still repay the full $25,000.
- Dealer add-ons on auto loans. Extended warranties, gap insurance, and paint protection are sometimes rolled into the loan amount. Each one raises P, and therefore the payment, even though it has nothing to do with the car itself.
- Taxes and insurance on a mortgage. A mortgage payment usually includes property tax and homeowners insurance collected into escrow, plus mortgage insurance if the down payment is under 20%. The formula covers none of these. The full picture for a home loan is covered in the guide to monthly mortgage payment calculation.
Before signing, read the loan estimate or the promissory note for the total monthly payment and the total of payments over the life of the loan. Under the Truth in Lending Act, US lenders must disclose the APR and the finance charge for consumer loans before you sign, so those two figures are the ones to compare across offers.
Shorter term vs longer term: the same loan, very different totals
The term is the biggest lever after the rate. Take a $15,000 loan at 8.9%:
| Term | Monthly payment | Total interest | Total paid |
|---|---|---|---|
| 3 years (36 payments) | $476.30 | $2,146.73 | $17,146.73 |
| 7 years (84 payments) | $240.58 | $5,208.35 | $20,208.35 |
Stretching the term from three years to seven cuts the payment by $235.72 a month — but adds $3,061.62 in interest. The pattern holds generally: each added year lowers the payment by less than the year before, while the interest keeps climbing. A longer term is the right call when the shorter payment genuinely does not fit your budget, but check the price of that breathing room in the total column first. If the payment on the shorter term is only slightly out of reach, a smaller loan or a lower rate usually costs less than extra years.
Auto loan example: $30,000 at 6.5%
The same method works for a car loan. For $30,000 at 6.5%:
- 60 months: $586.98 a month, $5,219.07 in total interest.
- 72 months: $504.30 a month, $6,309.45 in total interest.
The extra year drops the payment by $82.68 a month and costs $1,090.38 more in interest. It also matters for a car: cars lose value, and a 72-month loan keeps you owing more than the car is worth for longer. If the car is written off or you need to sell it before the loan ends, the gap between the balance and the car’s value comes out of your pocket unless you have gap insurance.
Calculate it in Excel, Google Sheets, or your phone
The fastest way to use the formula is the PMT function — the same calculation in one cell. In Excel or Google Sheets, type:
=PMT(0.07/12, 60, -25000)
That returns $495.03 — the same answer as the worked example. The three arguments are the monthly rate, the number of payments, and the loan amount with a minus sign so the result comes out positive. Change any of them and the payment updates at once.
On a phone calculator, the steps are the same as the worked example: divide the annual rate by 12, work out (1 + r)n with the power key, then multiply and divide as in steps 3 to 5. If the calculator has no power key, a loan calculator on the web does the same job.
If you prefer code, the same formula in one line of JavaScript is payment = P * r * Math.pow(1 + r, n) / (Math.pow(1 + r, n) - 1), with r = annual rate / 12 and n = years × 12. In Python, the same line works with ** in place of Math.pow.
How to lower the monthly payment — and what it costs
There are four levers, and each one has a price:
- Stretch the term. The payment falls, but total interest rises — as the $15,000 comparison above shows.
- Borrow less. A bigger down payment or a cheaper car lowers P directly, and with it both the payment and the interest — the only lever that cuts both at once.
- Get a lower rate. A better credit score, a secured loan, or a shorter term can all bring the rate down. Even one percentage point matters: on the $25,000 example, dropping from 7% to 6% over five years takes the payment from $495.03 to $483.32 and saves $702.60 in interest.
- Pay extra when you can. An extra $100 a month on the $25,000 loan clears it in 49 months instead of 60 and saves $938.99 in interest. Extra payments go straight to principal, so they work best early in the loan, when the balance — and the interest on it — is at its largest. Before doing this, check the loan has no prepayment penalty, and confirm with the lender that extra payments are applied to principal rather than held as advance payments.
Mistakes that give you the wrong number
- Dividing the loan by the months. $25,000 ÷ 60 = $416.67, which understates the real payment by $78.36 a month because it leaves out interest entirely. This is the single most common error.
- Using the annual rate as the monthly rate. Plugging 7% in as r instead of 0.07 ÷ 12 produces a payment in the thousands. Always divide by 12 first.
- Using the APR in the formula. The APR includes fees, so it overstates the payment — use the note rate here and the APR for comparing offers.
- Rounding r too early. Rounding 0.0058333 to 0.0058 shifts the answer by a few dollars — keep six or seven decimal places until the final step.
- Forgetting the fees. An origination fee or dealer add-on changes the amount you actually receive or repay, even though the formula never sees it.
- Assuming the payment never changes. The formula gives a fixed payment only on a fixed-rate loan. On a variable-rate loan, the payment is recalculated whenever the rate changes.
A short note for UK readers
The maths is identical in the UK: the same formula, the same three inputs, and the same trade-off between term and total interest. What differs is the paperwork. UK personal loans are usually fixed-rate repayment loans quoted with a representative APR, and the lender must show the total amount payable — the figure to compare across offers. Car finance in the UK is often a PCP agreement rather than a straight loan, and on a PCP the monthly payment covers only part of the car’s value, with a large final balloon payment, so the formula above does not apply to it directly.
Frequently asked questions
What is the formula to calculate a monthly loan payment?
M = P × [r(1 + r)n] / [(1 + r)n − 1]. P is the loan amount, r is the monthly interest rate (annual rate ÷ 12), and n is the total number of monthly payments (years × 12). The result is the monthly principal-and-interest payment on a fixed-rate loan.
How much is the monthly payment on a $25,000 loan?
At 7% over five years, $495.03 a month, with $4,701.80 in total interest. The figure changes with the rate and term: at 6% over five years it is $483.32, and at 7% over three years it is $771.93.
How do I calculate loan payments in Excel?
Use =PMT(rate/12, years*12, -loan). For the example in this guide, =PMT(0.07/12, 60, -25000) returns $495.03. The same PMT function works in Google Sheets.
Why is my first payment mostly interest?
Because interest is charged on the balance you still owe, and the balance is at its largest in month one. On the $25,000 example, month one’s interest is $145.83 of the $495.03 payment; by the final month, only $2.87 is interest.
Does a longer loan term always cost more?
In total interest, yes, if the rate is the same. On a $15,000 loan at 8.9%, seven years costs $3,061.62 more in interest than three years. The monthly payment is lower, so a longer term can still be the right choice when the shorter payment does not fit your budget — but check the total first.
Work out your own numbers with the formula above, or run them through a calculator and check the result against the worked examples here. The monthly payment is only half the question — the total interest over the life of the loan is the other half.
This article is general information, not financial advice for any individual. Rates, fees, and terms change, and the figures here are illustrative — check your lender’s quote before making a borrowing decision.