Whenever you borrow money – a car loan, a personal loan, a mortgage – one number decides whether the deal fits your life: the monthly payment. Lenders are happy to tell you what it is. They are far less eager to explain how it is built.
That gap matters, because two loans with almost identical monthly payments can differ by thousands of dollars in total cost. The only way to see that difference is to understand the formula behind the number.
This guide walks through the amortization formula, works a full example step by step, shows where your money actually goes each month, and covers the mistakes that quietly cost borrowers the most.
Key Takeaways
- A loan payment depends on three inputs: principal (P), the monthly interest rate (r), and the number of payments (n).
- The formula is: Payment = P x r x (1+r)^n / ((1+r)^n – 1)
- The most common error is using the annual rate directly instead of converting it to a monthly decimal.
- Early payments are mostly interest; the principal portion grows over time.
- A longer term lowers the monthly payment but raises total interest substantially – always compare total cost, not just the monthly figure.
What a Monthly Loan Payment Actually Is
A monthly loan payment on an amortizing loan is a fixed amount you pay every month until the balance reaches zero. It is fixed by design: the lender calculates a single figure that, repeated for the whole term, covers both the money you borrowed and the interest charged on it.
The amount stays the same, but what it is made of does not. Each payment is split between interest and principal, and that split shifts every single month. Early on, most of your money is paying for the privilege of borrowing. Later, most of it is actually clearing the debt.
- Principal – the original sum you borrowed.
- Interest – the lender’s charge for the use of that money.
- Term – how many months you have to repay it.
A Common Misconception
A fixed payment does not mean you are repaying the debt at a steady rate. In the first year of most loans, a large share of every payment is interest, and the balance falls slowly.
The Formula and What Each Symbol Means
The standard amortization formula is:
Payment = P x r x (1 + r)^n / ((1 + r)^n – 1)
Three inputs, but one of them trips up almost everyone. Here is what each represents:
The trap is r. People take an advertised rate of 7% and put 7 straight into the formula. That is wrong twice over: the rate must be monthly, not annual, and it must be a decimal, not a percentage. So 7% annual becomes 7 / 12 / 100 = 0.005833.
Get that one conversion right and the rest is arithmetic.
| Symbol | Meaning | How to Find It |
|---|---|---|
| P | Principal – the amount borrowed | The sum the lender advances |
| r | Monthly interest rate as a decimal | Annual rate / 12 / 100 |
| n | Total number of payments | Years x 12 |
Try the Calculator
You do not need to run the formula by hand. Enter your loan amount, interest rate, and term below to see the monthly payment and total interest instantly.
A Worked Example: A $25,000 Loan at 7%
Say you borrow $25,000 at 7% annual interest over 5 years. The currency does not matter – the same math works in dollars, pounds, or euros. Here it is step by step.
Step 1 – Set your values
- P = 25,000
- r = 7 / 12 / 100 = 0.005833
- n = 5 x 12 = 60
Step 2 – Calculate (1 + r)^n
(1 + 0.005833)^60 = 1.41763 (approximately)
Step 3 – Apply the formula
Payment = 25,000 x 0.005833 x 1.41763 / (1.41763 – 1)
Payment = 145.83 x 1.41763 / 0.41763
Payment = 206.73 / 0.41763 = $495.03
Step 4 – Check the total cost
Total repaid = 495.03 x 60 = $29,701.80
Total interest = 29,701.80 – 25,000 = $4,701.80
You borrowed $25,000 and will hand back nearly $4,702 in interest for the privilege.
Where Your Money Actually Goes Each Month
This is the table lenders rarely put in front of you. Here is how that $495.03 payment splits in the first three months:
In month one you paid $495.03, but the debt only shrank by $349.20. The other $145.83 went to the lender as interest.
Notice the pattern: the interest portion falls a little each month while the principal portion grows. This is why extra payments made early are so much more powerful than the same amount paid near the end – early on, the balance being charged interest is at its largest.
| Month | Interest | Principal | Remaining Balance |
|---|---|---|---|
| 1 | $145.83 | $349.20 | $24,650.80 |
| 2 | $143.80 | $351.23 | $24,299.57 |
| 3 | $141.75 | $353.28 | $23,946.29 |
How the Term Changes Everything
Stretching a loan over more years is the easiest way to make a monthly payment affordable. It is also the most expensive. The same $25,000 at 7% over different terms:
Going from 3 years to 7 years drops the monthly payment by $394.61, which feels like real relief. But total interest climbs from $2,789 to $6,695 – an extra $3,906 for the same $25,000.
The practical rule: choose a payment you can comfortably sustain, then pick the shortest term that fits it. Do not start from the term.
| Term | Monthly Payment | Total Interest |
|---|---|---|
| 3 years | $771.93 | $2,789 |
| 5 years | $495.03 | $4,702 |
| 7 years | $377.32 | $6,695 |
Five Mistakes That Cost Borrowers Money
- Not converting the annual rate. Using 7 instead of 0.005833 produces a wildly wrong answer. This is by far the most frequent error.
- Ignoring fees. Origination or arrangement fees of 1-2% are charged up front and are not in the advertised rate. They raise your real cost.
- Comparing monthly payments instead of total cost. Two offers can have similar payments over different terms and differ by thousands overall.
- Overlooking bundled insurance. Payment protection or credit insurance is sometimes added into the payment, inflating it without being part of the interest rate.
- Assuming a variable rate is fixed. If the rate can move, your payment or your term can move with it. Check which one the lender adjusts.
By Hand, in a Spreadsheet, or With a Calculator?
All three approaches produce the same answer. They differ in speed and in how easy it is to make a mistake.
In any spreadsheet, =PMT(0.07/12, 60, -25000) returns the same $495.03. That is the fastest route if you want to model several options side by side.
If you just need the number and want to compare two or three offers, an online calculator is quicker and removes the risk of a typo in the formula.
| Method | Best For | Drawback |
|---|---|---|
| The formula by hand | Understanding how it works | Slow and error-prone |
| Spreadsheet (PMT function) | Comparing several scenarios at once | Requires some setup |
| Online calculator | Quick, everyday answers | Not all show a full amortization schedule |
Conclusion
The amortization formula looks intimidating, but it only ever needs three things: how much you borrowed, the monthly rate as a decimal, and how many payments you will make. Once you also understand that early payments are mostly interest, the behavior of your loan stops being mysterious.
Before you sign anything, write down two numbers: the monthly payment and the total amount repayable. Ask every lender for both. The offer with the lowest monthly payment is very often not the cheapest one.
Try the Calculator
You do not need to run the formula by hand. Enter your loan amount, interest rate, and term below to see the monthly payment and total interest instantly.
Frequently Asked Questions
What is the formula for calculating a monthly loan payment?
The standard formula is Payment = P x r x (1+r)^n / ((1+r)^n – 1), where P is the principal, r is the monthly interest rate expressed as a decimal, and n is the total number of monthly payments. Remember to divide the annual rate by 12 and then by 100 to get r.
Why is most of my early payment going to interest?
Interest is charged on the outstanding balance, which is at its highest at the start of the loan. As you repay principal the balance falls, so the interest portion of each payment shrinks and the principal portion grows. This is why extra payments made early save the most money.
Does a longer loan term save me money?
No. A longer term lowers your monthly payment but increases the total interest you pay, often substantially. On a $25,000 loan at 7%, extending from 3 to 7 years cuts the payment by about $395 a month but adds roughly $3,900 in total interest.
Can I calculate a loan payment in a spreadsheet?
Yes. Use the PMT function: =PMT(rate/12, number_of_months, -loan_amount). For a $25,000 loan at 7% over 60 months, =PMT(0.07/12, 60, -25000) returns about $495.03. The negative sign on the principal makes the result display as a positive payment.
Does the currency change the calculation?
No. The amortization formula is currency-agnostic – it works identically for dollars, pounds, euros, or any other currency. Only the interest rate, the amount, and the number of payments affect the result.
1 thought on “How to Calculate Monthly Loan Payments: Formula and Examples”
Comments are closed.