The basic formula: principal, rate, and time

To find your monthly payment on a loan or credit balance, you need three pieces of information: the principal (the amount you borrowed), the annual interest rate, and the loan term (how many months you have to repay it). The monthly payment covers both the principal you owe and the interest that accrues.

The calculation itself uses what's called an amortization formula. If you have a loan of $10,000 at 6% annual interest over 60 months, your payment won't be a straightforward division of $10,000 by 60. Instead, the formula accounts for the fact that interest is calculated on the remaining balance each month, and your payment is structured so that you pay off the full amount—principal plus all interest—by the end of the term.

Most people don't calculate this by hand anymore. Your lender provides the payment amount, online calculators do the math when ready, and spreadsheet programs have built-in functions. But understanding what the numbers mean helps you spot errors and compare offers.

Key Takeaways

  • Monthly payment = principal × [rate × (1 + rate)^months] / [(1 + rate)^months − 1], where rate is your monthly interest rate (annual rate divided by 12).
  • Your lender is required to disclose the monthly payment and total interest cost before you sign, so you can verify the math yourself.
  • Online loan calculators and spreadsheet functions (like PMT in Excel or Google Sheets) do this calculation when ready and accurately.
  • A higher interest rate or shorter loan term both increase your monthly payment; a longer term lowers the monthly payment but increases total interest paid.
  • The payment stays the same each month on a fixed-rate loan, but the portion going to interest versus principal shifts as your balance shrinks.

Using an online calculator or spreadsheet

The fastest way to find a monthly payment is an online loan calculator. You enter the loan amount, annual interest rate, and number of months, and it returns your monthly payment when ready. These calculators are free and widely available—search "loan payment calculator" and you'll find dozens. They all use the same formula, so the result should be identical regardless of which one you use.

If you use a spreadsheet like Excel or Google Sheets, the PMT function does the same work. The syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate (annual rate divided by 12), nper is the number of months, and pv is the loan amount as a negative number. For example, a $10,000 loan at 6% annual interest over 60 months would be =PMT(0.06/12, 60, -10000), which returns $193.33.

Spreadsheets also let you build an amortization table—a month-by-month breakdown showing how much of each payment goes to interest versus principal. This is useful if you want to see how your balance shrinks over time or understand what happens if you make extra payments.

The math behind the monthly payment

If you want to calculate the payment by hand, the formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1], where M is the monthly payment, P is the principal, r is the monthly interest rate (annual rate divided by 12), and n is the number of months.

Using the $10,000 loan at 6% over 60 months as an example: the monthly rate is 0.06 ÷ 12 = 0.005. Plugging into the formula: M = 10,000 × [0.005(1.005)^60] / [(1.005)^60 − 1]. The numerator works out to 10,000 × 0.00644, and the denominator to 0.34885, giving you a monthly payment of $193.33.

You don't need to memorize or use this formula yourself—lenders calculate it, calculators do it, and spreadsheets do it. But if you see a monthly payment quoted and want to verify it's correct, you can plug the numbers into a calculator or spreadsheet function and check that the result matches.

How interest rate and loan term affect your payment

Two factors change your monthly payment: the interest rate and the length of the loan. A higher interest rate means you pay more each month. A longer loan term means you pay less each month, but you pay interest for more months, so your total interest cost goes up.

For example, a $10,000 loan at 6% interest: over 60 months, your payment is $193.33 and you pay $1,599.80 in total interest. Over 36 months, your payment jumps to $299.55, but you only pay $797.80 in total interest. Over 84 months, your payment drops to $152.84, but you pay $2,838.56 in total interest.

This trade-off is why comparing loan offers means looking at both the monthly payment and the total cost, not just one or the other. A lower monthly payment can feel better in your budget, but it may cost you significantly more over the life of the loan.

What your lender must disclose

Before you sign a loan agreement, your lender is required to provide a disclosure document that shows the monthly payment, the total amount of interest you'll pay, and the total amount you'll repay (principal plus interest). In the United States, this is part of the Truth in Lending Act (TILA) requirements.

For mortgages, you receive a Closing Disclosure at least three days before closing. For credit cards, the monthly statement shows your interest charges and the effect of different payment amounts. For personal loans and auto loans, the lender provides a loan estimate or disclosure form before you sign.

If the monthly payment your lender quotes doesn't match what you calculate using a calculator or spreadsheet, ask the lender to explain the difference. Common reasons include variable interest rates, fees rolled into the loan, or a different payment schedule than you assumed (for example, payments due at the beginning of the month rather than the end).

How the payment breaks down between principal and interest

Each monthly payment covers both principal and interest, but the split changes over time. Early in the loan, most of your payment goes to interest. As your balance shrinks, more of each payment goes to principal.

On a $10,000 loan at 6% over 60 months, your first payment of $193.33 includes $50 in interest (the monthly rate of 0.5% applied to the $10,000 balance) and $143.33 in principal. After that payment, your balance is $9,856.67. The next month's interest is calculated on that lower balance, so slightly less goes to interest and slightly more to principal. By the final payment, almost all of it is principal and almost none is interest.

If you want to see this breakdown month by month, build an amortization table in a spreadsheet or use an online amortization calculator. This is especially useful if you're considering making extra payments toward principal—the table shows you exactly how much faster you'd pay off the loan.

Common mistakes when calculating or comparing payments

One frequent error is confusing the annual interest rate with the monthly rate. If a lender quotes 6% annual interest, the monthly rate is 0.5%, not 6%. Using 6% as your monthly rate would make your payment calculation wildly wrong.

Another mistake is forgetting to account for fees. Some loans include origination fees, processing fees, or insurance premiums that get rolled into the loan amount or added to your monthly payment. The payment your lender quotes should include these, but if you're calculating it yourself, make sure you're using the total amount financed, not just the principal you borrowed.

A third common issue is assuming the payment stays the same if the interest rate is variable. Adjustable-rate loans (common in mortgages and some credit products) have a monthly payment that can change when the interest rate resets. Your initial payment is based on the starting rate, but future payments may be higher or lower depending on market conditions.

Frequently Asked Questions

Can I calculate my monthly payment if I only know the total amount I'll pay back?

Not directly—you need either the interest rate or the loan term to work backward. If you know the total amount paid and the principal, you can find the total interest (total paid minus principal), but that doesn't tell you the monthly payment without knowing how many months the loan runs. Ask your lender for the interest rate and term; they're required to provide both.

What's the difference between straightforward interest and compound interest on a loan payment?

Most personal loans, auto loans, and mortgages use amortizing payments, which account for compound interest—interest calculated on the remaining balance each month. Credit cards sometimes use daily compound interest. The formula and calculators described here assume amortizing loans. If you're dealing with a different structure, ask your lender how interest is calculated.

If I pay extra toward my loan, how much faster will it be paid off?

Extra payments go directly to principal and reduce the total interest you pay. An amortization table shows you the impact: if you add $50 to each payment, you'll see how many months shorter the loan becomes and how much less interest you'll owe. Most lenders allow extra payments without penalty, but confirm this before you start.

Why does my actual monthly payment differ from what the calculator shows?

The most common reason is that your lender includes fees, insurance, or taxes in the payment that the basic calculator doesn't account for. Property taxes and homeowners insurance are added to mortgage payments, for example. Ask your lender for an itemized breakdown of what's included in your quoted payment.

How do I know if an interest rate offer is actually good?

Compare the annual percentage rate (APR) across multiple lenders for the same loan type and term. The APR includes the interest rate plus certain fees, so it's a more complete picture than the interest rate alone. The lower the APR, the less you'll pay overall, all else being equal.