The basic formula: principal, interest rate, and loan term

A loan payment has three moving parts: the amount you borrowed (the principal), the interest rate the lender charges, and how many months you have to pay it back. The monthly payment covers both principal and interest, and the formula that calculates it is the same whether you're borrowing $5,000 or $500,000.

The standard formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1], where M is your monthly payment, P is the principal, r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments. You don't need to memorize this—a calculator or spreadsheet does the work—but understanding what each piece does helps you see why changing one number changes your payment.

If you borrow $20,000 at 6% annual interest over 60 months, your monthly payment will be roughly $387. If you stretch that same loan to 84 months, the payment drops to about $285—but you pay more interest overall because you're borrowing the money longer. If you shorten it to 36 months, the payment rises to about $592, but you pay less total interest.

Key Takeaways

  • Your monthly payment depends on three things: how much you borrowed, the interest rate, and how many months you have to repay it.
  • A longer loan term lowers your monthly payment but increases the total interest you pay over the life of the loan.
  • Online loan calculators and spreadsheet formulas can show you the exact payment for any combination of principal, rate, and term.
  • The payment stays the same each month on a fixed-rate loan, but on variable-rate loans it can change when the interest rate changes.
  • Your actual payment may include fees, insurance, or taxes on top of the principal-and-interest calculation.

Using an online calculator versus doing the math yourself

The fastest way to find a payment is to use a loan calculator—most lenders have one on their website, and free calculators are available from banks and financial websites. You enter the loan amount, the interest rate, and the number of months, and the calculator returns your monthly payment in seconds. This is the practical route for most people.

If you want to do the calculation yourself, a spreadsheet is simpler than the formula. In Excel or Google Sheets, use the PMT function: =PMT(rate, nper, pv). The rate is your monthly interest rate (annual rate divided by 12), nper is the number of payments, and pv is the loan amount as a negative number. For a $20,000 loan at 6% annual interest over 60 months, you'd type =PMT(0.06/12, 60, -20000) and get $386.66.

The advantage of the spreadsheet is that you can change one number and when ready see how the payment shifts. You can test what happens if you borrow $25,000 instead of $20,000, or if the rate is 7% instead of 6%, without re-entering everything. This is useful when you're deciding how much to borrow or comparing offers from different lenders.

Why the interest rate matters more than you might think

A small difference in interest rate creates a surprisingly large difference in what you pay. On a $200,000 mortgage over 30 years, the difference between 6% and 7% is about $133 per month—roughly $48,000 over the life of the loan. On a $10,000 car loan over 60 months, the difference between 5% and 8% is about $60 per month, or $3,600 total.

This is why lenders advertise their rates so prominently: even a 0.5% difference is real money. When you're comparing loan offers, the interest rate is often more important than the monthly payment alone. A lender offering a lower rate but a slightly higher payment might cost you less overall if you keep the loan for the full term.

The interest rate also depends on your credit score, the type of loan, and current market conditions. A secured loan (backed by collateral, like a car loan) usually has a lower rate than an unsecured loan (like a personal loan) because the lender has less risk. A longer loan term usually means a higher rate because the lender is taking on more risk over time.

How extra payments and early payoff change the math

The monthly payment formula assumes you pay the same amount every month for the full term. But if you pay extra, you reduce the principal faster, which means less interest accrues, and you finish the loan early.

On a $20,000 loan at 6% over 60 months, your regular payment is $387. If you pay $450 instead, you'll finish in about 45 months instead of 60, and you'll pay roughly $1,500 less in interest. The lender's calculator won't show you this automatically—you have to do the math yourself or use an amortization calculator that lets you add extra payments.

Some loans charge a prepayment penalty if you pay off early, which means the lender keeps some of the interest you would have paid. This is less common now, but it's worth checking your loan agreement. If there's no penalty, paying extra is always cheaper than sticking to the regular payment.

Fixed-rate versus variable-rate loans and payment changes

On a fixed-rate loan, your interest rate and monthly payment stay the same for the entire loan term. You know exactly what you'll pay each month, which makes budgeting straightforward. Most personal loans, car loans, and mortgages are fixed-rate.

On a variable-rate loan (also called an adjustable-rate loan), the interest rate can change at set intervals—usually every year or every few years. When the rate changes, your monthly payment changes too. An adjustable-rate mortgage might start at 4% for the first five years, then adjust to 5% or 6% based on market conditions. When that happens, your payment goes up.

Variable-rate loans often start with a lower rate than fixed-rate loans, which makes the initial payment attractive. But if rates rise, your payment can increase significantly. Before taking a variable-rate loan, ask what the maximum rate could be and what your payment would be at that rate. This tells you the worst-case scenario.

What gets added on top of the principal-and-interest payment

The formula calculates only principal and interest. Your actual monthly payment may include other costs that the lender collects along with the loan payment.

Property taxes and homeowners insurance (on mortgages) are often collected by the lender and paid to the county and insurance company on your behalf. These are added to your mortgage payment but aren't part of the loan calculation itself. Private mortgage insurance (PMI) is required if you put down less than 20% on a home purchase; it protects the lender if you default, and it's added to your monthly payment until you've paid down enough principal.

Loan origination fees are sometimes rolled into the loan amount itself, which increases the principal and therefore the monthly payment. Prepaid interest (called a discount point) can also be added upfront. On car loans, gap insurance (which covers the difference between what you owe and what the car is worth if it's totaled) is sometimes included in the payment.

Always ask the lender for a full breakdown of what's included in your payment. The loan estimate or disclosure document will show principal and interest separately from fees and insurance, so you can see exactly what you're paying for.

Amortization: how your payment is split between principal and interest

Early in a loan, most of your payment goes toward interest. As time goes on, more of each payment goes toward principal. This split is shown in an amortization schedule, which lists every payment and breaks down how much goes to principal versus interest.

On a $200,000 mortgage at 6% over 30 years, your first payment is about $1,199. Of that, roughly $1,000 goes to interest and $199 goes to principal. By payment 180 (halfway through), the split is closer to $600 interest and $599 principal. By the final payment, almost all of it is principal because very little is left to accrue interest on.

This is why paying extra early in the loan saves so much interest: you're reducing the principal when interest is highest. Many lenders provide an amortization schedule with your loan documents, or you can generate one using an online calculator. This schedule is useful for understanding how much of your payment is actually reducing what you owe versus paying the lender's cost of lending.

Frequently Asked Questions

How do I know if a loan payment is reasonable?

Compare the payment to the principal, interest rate, and term using an online calculator. If the numbers don't match what the calculator shows, ask the lender why. Also compare offers from multiple lenders—the same loan amount at the same rate should produce nearly identical payments, so a much higher payment from one lender suggests hidden fees.

Can I calculate a payment if I don't know the interest rate yet?

No, the interest rate is essential to the calculation. If a lender hasn't quoted you a rate, ask for one in writing. Rates vary by credit score and loan type, so you may get different rates from different lenders. Once you have a rate, you can calculate the payment.

What if I want to know how much to borrow to hit a specific monthly payment?

Use a reverse calculator or work backward with a spreadsheet. If you know you can afford $400 per month, the interest rate, and the loan term, you can calculate the maximum principal. Most lender websites have a "how much can I borrow" calculator that does this.

Does the payment change if I make payments bi-weekly instead of monthly?

The total amount you pay stays the same, but the payment amount and frequency change. Bi-weekly payments are smaller but happen 26 times a year instead of 12 times. Some lenders don't offer bi-weekly payments, so check your loan agreement before switching.

What happens to my payment if I refinance?

Refinancing replaces your old loan with a new one, so you get a new payment based on the new interest rate, the remaining balance, and a new term. If you refinance to a lower rate, your payment usually drops. If you extend the term to lower the payment, you pay more interest overall.