🧮 Calculators · Updated November 9, 2026 · 6 min read

Loan Payment Formula: Work Out Any Monthly Bill by Hand

Amount + rate Monthly payment 💰

To calculate a loan payment, use the standard amortization formula: M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the amount borrowed, r is the annual rate divided by 12, and n is the number of monthly installments. For a $25,000 car loan at an example rate of 6.9 percent over 60 months, that works out to $493.85 a month and $4,631.08 of interest over the life of the note. Below, every step is shown with real numbers, including how each installment splits between interest and principal, what an extra $50 a month does, and how to check a home loan in GrabCast's free Mortgage and Loan Calculator. The rates used here are illustrations, not quotes or advice; your lender's disclosure is the number that counts.

🏠 Try the Mortgage Calculator tool now — freeOpen →
Amortization schedule for the 60-month car loan with balance chart and yearly rows of principal and interest
Check the schedule: interest shrinks and principal grows each year.
💡 Why do the math yourself

A dealer or lender quote usually leads with the monthly figure, because that is the number that feels affordable. Working it out yourself shows the other half of the picture: the same $25,000 costs $3,679.85 in interest over 48 months and $5,601.85 over 72 months at the same 6.9 percent example rate, so stretching the term lowers the monthly bill by $172.47 but adds almost $2,000 in total cost. Knowing the formula also lets you catch errors and padding. If a quoted monthly figure is higher than the formula predicts for the stated rate, term and amount, something else has been folded in, such as an add-on warranty, gap coverage or fees that were financed rather than paid up front. That is a question to ask before signing, not after the first statement arrives. The same skill helps when refinancing, since you can see exactly how much a lower rate or shorter term changes both numbers.

The amortization formula, term by term

The formula spreads a fixed rate over equal monthly installments so the balance reaches exactly zero at the end. Each symbol has one job:

If the rate is zero, the formula divides by zero; the answer is simply P divided by n. Use the note rate for this math. The APR on a disclosure can be slightly higher because it also folds in certain fees.

A $25,000 car loan worked by hand

Take P = 25,000, an example annual rate of 6.9 percent, and n = 60. First, r = 0.069 ÷ 12 = 0.00575. Next, (1.00575)^60 = 1.410595. The top of the fraction is 25,000 × 0.00575 × 1.410595 = 202.7731. The bottom is 1.410595 − 1 = 0.410595. Divide: 202.7731 ÷ 0.410595 = $493.85 a month.

Multiply by 60 to get $29,631.08 repaid in total, so the cost of borrowing is $4,631.08. Change only the term and the trade-off is clear:

Where each installment goes

The monthly amount stays fixed, but its split shifts every month. Interest is always the current balance times r, and whatever is left reduces the principal.

That is why early extra principal is so effective. Adding $50 to each installment on this example pays the balance off in 54 months instead of 60 and cuts total interest to about $4,116.74, a saving of roughly $514. Check first that your lender applies extra money to principal and charges no prepayment penalty.

Checking a mortgage in the free calculator

GrabCast's Mortgage and Loan Calculator uses this same formula and adds the costs a home carries. Enter the home price, down payment as a percent or dollar amount, rate and a term in years or months, and it shows the full monthly figure with property tax, insurance, PMI and HOA, plus the amount borrowed, total interest, payoff date and a yearly or monthly amortization schedule with a balance chart and CSV download.

For a five-year auto or personal note, switch to the Auto / personal loan tab and pick 60 months, or check it in a spreadsheet: =PMT(0.069/12, 60, -25000) returns 493.85.

Specifically for vehicle financing, the Auto Loan Calculator applies the same math to a car payment.

Step-by-step

1234
1Write down the amount borrowed, the annual rate from your quote, and the number of monthly payments in the term
Auto / personal loan tab selected in the mortgage calculator with a loan amount of $25,000 field
Choose the Auto / personal loan tab and enter the $25,000 amount borrowed.
2Convert the rate to a monthly decimal by dividing by 100 and then by 12, and compute (1 + r) raised to the power n
Interest rate 6.9 percent and loan term 60 months in the loan calculator after switching the term unit to months
Enter the quoted APR and set the term unit to months for 60 payments.
3Plug the numbers into M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1) and round the result to the cent
Monthly payment of about $494 for the $25,000 car loan with total interest and payoff date cards
Read the monthly payment to compare with your hand calculation.
4Check the answer with a spreadsheet PMT function or, the Mortgage and Loan Calculator with extras set to zero, using the Auto / personal loan tab for a car note
Amortization schedule for the 60-month car loan with balance chart and yearly rows of principal and interest
Check the schedule: interest shrinks and principal grows each year.

Common mistakes to avoid

⚠️Using the annual rate as r instead of dividing it by 12, which produces a monthly figure many times too high
⚠️Entering the term in years for n when the formula needs the number of monthly payments
⚠️Comparing loans only by monthly payment and ignoring the extra interest a longer term adds
⚠️Forgetting that a home payment also includes property tax, insurance and possibly PMI or HOA on top of principal and interest

Pro tips

✓Keep at least five decimal places in the growth factor; rounding it early can move the answer by several dollars
✓Run the numbers for two or three terms side by side before choosing, since total interest changes far more than the monthly bill
✓Ask any lender for the note rate, the APR and a full amortization schedule, then compare them with your own math
✓Before adding extra principal, confirm in writing that there is no prepayment penalty and the money reduces principal
✓Treat the example rates in this guide as placeholders and replace them with the rate on your actual quote

Frequently asked questions

What is the formula for a monthly loan payment

M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1). P is the amount borrowed, r is the annual rate divided by 12 as a decimal, and n is the number of monthly payments. For $25,000 at an example 6.9 percent over 60 months, M is $493.85.

Does the formula work for car loans, student loans and mortgages

Yes, for any fixed-rate loan with equal monthly payments. It does not cover interest-only periods, balloon payments or adjustable rates after they reset. Mortgages also carry escrow items such as property tax and insurance, which sit on top of the principal and interest amount.

How do I calculate payments in Excel or Google Sheets

Use =PMT(rate/12, months, -amount). For the car example, =PMT(0.069/12, 60, -25000) returns 493.85. The minus sign in front of the amount makes the result positive. The spreadsheet uses the same amortization formula shown in this guide.

Why is my lender's number different from mine

Small differences usually come from rounding or the first payment date. Larger gaps often mean fees, add-on products or taxes were financed into the balance, or the quote includes escrow for tax and insurance. Ask for an itemized breakdown and compare it with your own calculation.

Is this guide financial advice

No. It explains standard loan math with example rates so you can check quotes yourself. The right loan, term or rate depends on your full situation, so rely on official disclosures and consider talking with a licensed professional before a big borrowing decision.

📌 Bottom line

Any fixed-rate monthly installment follows one formula: M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), with r as the monthly rate and n as the number of payments. Work one example by hand, compare terms by total interest, and use the calculator to see a full home payment with tax, insurance and PMI.

Open the Mortgage Calculator tool →

Related guides

Browse more: all calculator guides · the Mortgage Calculator tool