The basic formula: what you're actually paying
A loan payment with interest is calculated using a standard formula that accounts for three things: how much you borrowed, the interest rate, and how long you have to pay it back. The formula is called the amortization formula, and it tells you what your monthly (or periodic) payment will be.
The formula looks like this: M = P × [r(1 + r)^n] / [(1 + r)^n − 1], where 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. You do not need to memorize this—a calculator or spreadsheet does the work—but understanding what each piece means helps you see why your payment is what it is.
The key insight: your payment stays the same every month, but the split between interest and principal changes. Early payments go mostly toward interest. Later payments go mostly toward principal. By the end, you have paid back everything you borrowed plus the cost of borrowing it.
Key Takeaways
- Monthly payment depends on three numbers: the amount borrowed, the annual interest rate, and the number of months to repay.
- You can calculate it by hand using the amortization formula, but a loan calculator or spreadsheet is faster and more reliable.
- Early payments are mostly interest; later payments are mostly principal, even though the total payment stays the same.
- The interest rate matters enormously—a 1% difference in rate can add thousands of dollars over the life of a loan.
- Always confirm the actual payment with your lender, because fees, insurance, or taxes may be added on top of the calculated amount.
Using a loan calculator instead of doing the math by hand
The amortization formula is mathematically sound, but doing it by hand is tedious and error-prone. A loan calculator—available free online through sites like Bankrate, NerdWallet, or your lender's website—takes the three numbers (principal, rate, term) and gives you the payment when ready.
To use one, you enter the loan amount, the annual interest rate (as a percentage), and the loan term in months or years. The calculator returns your monthly payment. Many calculators also show you an amortization schedule, which is a month-by-month breakdown of how much of each payment goes to interest versus principal.
If you prefer a spreadsheet, Excel and Google Sheets both have a built-in function called PMT that does the same calculation. The syntax is =PMT(rate, nper, pv), where rate is the monthly interest rate (annual rate ÷ 12), nper is the number of periods, and pv is the loan amount (entered as a negative number). This method is useful if you want to test different scenarios—what if the rate were 5% instead of 6%, or the term were 60 months instead of 48.
Why the interest rate makes such a large difference
A small change in interest rate produces a surprisingly large change in total cost. Consider a $20,000 car loan over 60 months: at 4% annual interest, your monthly payment is roughly $368 and you pay about $2,080 in interest total. At 6% annual interest, your monthly payment is roughly $387 and you pay about $3,220 in interest total. That extra 2% costs you $1,140 over five years, even though your monthly payment only went up by $19.
This is why shopping for the best rate matters. A 1% difference in rate on a $200,000 mortgage over 30 years can mean $60,000 or more in total interest paid. Lenders, credit unions, and banks all price loans differently based on your credit score, income, and the type of loan. Getting quotes from multiple sources before you commit is standard practice and takes a few hours.
The interest rate is also why the order of payments matters. If you make extra payments toward principal early in the loan, you reduce the amount that future interest accrues on, which saves you money. If you wait until late in the loan to make extra payments, the savings are smaller because there is less principal left to accrue interest on.
Understanding the amortization schedule
An amortization schedule is a table that shows, for each payment period, how much of your payment goes to interest and how much goes to principal, plus the remaining balance. Most loan calculators generate this automatically.
Here is what a simplified schedule looks like for a $10,000 loan at 6% annual interest over 12 months (monthly payment approximately $860):
| Month | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | $860 | $50 | $810 | $9,190 |
| 2 | $860 | $46 | $814 | $8,376 |
| 12 | $860 | $4 | $856 | $0 |
Notice that in month 1, most of the $860 goes to interest ($50) and only $810 goes to principal. By month 12, almost all of it ($856) goes to principal and only $4 goes to interest. The total payment stays the same, but the composition shifts. This is how amortization works on every loan—mortgage, car, personal, student.
You can use an amortization schedule to answer specific questions: How much will I owe after 24 payments? (Look at month 24 in the balance column.) How much interest will I pay in the first year? (Add up the interest column for months 1–12.) If I make an extra $100 payment in month 6, how much faster will the loan be paid off? (Recalculate with a higher payment amount and see where the balance hits zero.)
What happens if the interest rate changes
For fixed-rate loans (mortgages, car loans, personal loans with a fixed rate), the interest rate does not change, so your payment stays the same for the entire loan term. You know exactly what you will pay each month.
For variable-rate loans (some home equity lines of credit, adjustable-rate mortgages, certain credit cards), the interest rate can change based on market conditions or the terms of the loan. When the rate changes, your payment usually changes too. Your lender will notify you of the new rate and new payment amount. If you want to know what your payment would be under a different rate, use a calculator to test the scenario.
If you have a variable-rate loan and rates are rising, you may want to lock in a fixed rate if that option is available. This is a decision to discuss with your lender, because switching rates may involve fees or closing costs.
Common mistakes when calculating loan payments
The most common mistake is forgetting to convert the annual interest rate to a monthly rate. If your loan has a 6% annual interest rate, the monthly rate is 0.06 ÷ 12 = 0.005 (or 0.5%). If you use 6% instead of 0.5% in your calculation, your payment will be wildly wrong.
Another mistake is confusing the number of payments with the number of years. A 5-year loan has 60 monthly payments, not 5. If you enter 5 instead of 60 in a calculator, the payment will be much higher than it should be.
A third mistake is assuming the calculated payment is the total amount you will pay each month. Many loans also have insurance, taxes, or fees added on top. A mortgage payment, for example, often includes principal and interest plus property tax, homeowners insurance, and possibly mortgage insurance. A car loan may include gap insurance or extended warranty. Always ask your lender what is included in the stated payment and what is added separately.
Frequently Asked Questions
Can I pay off a loan early without a penalty?
Most personal loans, car loans, and mortgages allow early payoff without penalty. Some loans, particularly older mortgages or certain private loans, may have a prepayment penalty. Check your loan documents or ask your lender before making extra payments. If there is no penalty, paying extra toward principal saves you interest.
What is APR and how is it different from interest rate?
The interest rate is the cost of borrowing expressed as a percentage per year. APR (annual percentage rate) includes the interest rate plus other costs like origination fees, closing costs, or insurance, expressed as a yearly rate. APR gives you a more complete picture of the true cost of the loan. Lenders are required to disclose both.
Why does my actual payment differ from what the calculator shows?
The calculator shows principal and interest only. Your actual payment may include property tax, homeowners insurance, mortgage insurance, loan origination fees, or other charges. Ask your lender for an itemized payment breakdown. Some of these costs may be optional or may change over time.
If I make one extra payment per year, how much faster will my loan be paid off?
One extra payment per year typically shortens a 30-year mortgage by about 4–5 years and saves tens of thousands in interest. The exact savings depend on the loan amount, rate, and term. Use an amortization calculator and test the scenario: increase the annual payment amount and see where the balance reaches zero.
What is the difference between straightforward interest and compound interest?
straightforward interest is calculated only on the original principal. Compound interest is calculated on the principal plus accumulated interest. Most loans use compound interest, calculated monthly or daily. Credit cards typically compound daily, which is why the balance grows faster than you might expect.