The basic formula: principal, interest rate, and time

A loan payment is calculated using three pieces of information: how much you borrowed (the principal), the annual interest rate, and how long you have to repay it. The lender uses a standard formula to divide the total cost—principal plus interest—into equal monthly payments.

For a fixed-rate loan, every payment is the same amount. That payment covers two things: a portion that reduces what you owe, and a portion that pays the lender's interest. Early in the loan, most of your payment goes to interest. Later, most goes toward principal. By the final payment, you owe nothing.

The exact calculation depends on whether the loan compounds interest monthly, daily, or on another schedule. Most consumer loans—mortgages, car loans, personal loans—compound monthly, which is what we'll focus on here.

Key Takeaways

  • A monthly payment is calculated from the principal amount, the annual interest rate, and the loan term in months using a standard amortization formula.
  • The interest rate is divided by 12 to get the monthly rate, which is why a 12% annual rate becomes 1% per month.
  • Early payments are mostly interest; later payments are mostly principal, even though the total payment stays the same.
  • You can calculate a payment yourself using a spreadsheet formula, a calculator, or by asking the lender for an amortization schedule.

The amortization formula and what each part means

The standard formula for a fixed monthly payment is:

M = P × [r(1 + r)^n] / [(1 + r)^n − 1]

Where M is the 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 (years × 12).

This looks abstract, but it solves a real problem: how to split a loan into equal payments when interest compounds each month. The formula ensures that by the final payment, the balance is exactly zero.

Here's a concrete example. You borrow $10,000 at 6% annual interest over 5 years (60 months). The monthly rate is 0.06 ÷ 12 = 0.005. Plugging into the formula gives a monthly payment of about $193.33. Over 60 months, you pay $11,599.80 total—$1,599.80 in interest.

Why your first payment is mostly interest

In the example above, your first payment of $193.33 includes roughly $50 in interest (the $10,000 balance × 0.005 monthly rate) and $143.33 toward principal. You've only reduced what you owe by $143.33.

The second payment is calculated on the new balance of $9,856.67. Interest is now $49.28, and principal is $144.05. The split shifts slightly each month. By payment 59, interest is less than $2 and principal is over $191. By payment 60, you owe almost nothing, so the final payment is nearly all principal.

This is why paying extra principal early in a loan saves significant interest. An extra $100 on payment one reduces the balance by $100, which then earns no interest for the remaining 59 months. An extra $100 on payment 59 saves only one month of interest.

How to calculate a payment yourself

If you have a spreadsheet program like Excel or Google Sheets, use the PMT function. The syntax is =PMT(rate, nper, pv), where rate is the monthly interest rate, nper is the number of payments, and pv is the loan amount (entered as a negative number).

For the $10,000 loan at 6% over 5 years, you would enter =PMT(0.06/12, 60, -10000). The result is $193.33.

Many online calculators will do this for you—search "loan payment calculator" and enter the principal, annual rate, and term in years. The calculator divides the annual rate by 12 and the years by 12 automatically.

If you want to see the full breakdown—how much of each payment goes to interest versus principal—ask your lender for an amortization schedule. This is a month-by-month table showing the payment amount, interest portion, principal portion, and remaining balance. Lenders provide this for free, usually as a PDF.

Variable-rate loans and how they differ

An adjustable-rate mortgage or variable-rate personal loan works differently. The interest rate changes on a set schedule—often every 6 months or annually. When the rate changes, the lender recalculates your payment based on the new rate and the remaining balance and term.

This means your payment can go up or down. If rates rise, your payment rises. If rates fall, your payment falls. The calculation itself uses the same formula, but it's recalculated each time the rate adjusts.

Variable-rate loans are harder to budget for because you don't know future payments. Some have a cap on how much the rate can rise per adjustment period or over the life of the loan. Always check the loan documents for these limits before signing.

What happens if you pay more than the minimum

If you pay $250 instead of $193.33, the extra $56.67 goes entirely to principal. It does not reduce your next payment—the lender still expects $193.33 the following month. But it does reduce the total interest you'll pay and shorten the loan term.

Using the same $10,000 loan at 6%, paying $250 monthly instead of $193.33 means you'll finish in about 42 months instead of 60, and you'll pay roughly $10,500 total instead of $11,599.80. That's over $1,000 in interest saved.

Some loans charge a prepayment penalty if you pay off the balance early. This is less common now, but it's worth checking your loan documents. If there's a penalty, you need to weigh whether the interest savings outweigh the penalty cost.

How lenders present payment information

When you're offered a loan, the lender must disclose the monthly payment, the annual percentage rate (APR), and the total amount you'll pay in interest. This information appears on a document called a Loan Estimate (for mortgages) or a Truth in Lending disclosure (for other loans).

The APR includes not just the interest rate but also certain fees, so it's usually slightly higher than the stated interest rate. This gives you a more complete picture of the true cost of borrowing.

Always compare the APR across lenders, not just the interest rate. A loan with a 5.5% rate and $500 in fees might have a higher APR than a loan with a 5.8% rate and no fees.

Frequently Asked Questions

Why does the payment stay the same if interest rates change?

On a fixed-rate loan, the rate is locked in when you sign. The payment is calculated once and never changes. On a variable-rate loan, the payment does change when the rate adjusts—the lender recalculates it using the new rate and the remaining balance.

Can I calculate my payment if I don't know the exact interest rate?

You can estimate using a typical rate for your loan type and credit situation, but you won't know the exact payment until the lender quotes you. Interest rates vary by lender, loan term, and your credit profile. Always ask the lender for the rate and payment in writing before you commit.

What's the difference between APR and interest rate?

The interest rate is what the lender charges on the balance. The APR includes the interest rate plus certain fees (like origination fees) spread across the loan term. APR gives a more complete picture of cost, which is why lenders are required to disclose it.

If I pay early, do I owe less interest?

Yes. Interest is calculated on the outstanding balance. If you pay off the loan in 42 months instead of 60, you pay interest for only 42 months. The exact savings depends on how much extra you pay and when you pay it.

How do I know if my payment calculation is correct?

Ask your lender for the amortization schedule. This shows every payment, how much goes to interest and principal, and the remaining balance after each payment. You can also verify using a loan calculator online or the PMT function in a spreadsheet.