The basic formula: principal, rate, and time

To calculate a monthly payment with interest, 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 pay it back). The formula most lenders use is called the amortization formula, and it produces the fixed payment you'll make each month.

The monthly payment formula is: M = P × [r(1 + r)^n] / [(1 + r)^n − 1]. In this formula, 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 months. You don't need to memorize this—most people use a calculator or spreadsheet—but understanding what each part does helps you see why payments change when rates or terms change.

The reason the formula is complex is that each month, interest accrues on the remaining balance, not the original amount. Early payments go mostly toward interest; later payments go mostly toward principal. This is why a 30-year mortgage costs so much more than a 15-year one, even at the same rate.

Key Takeaways

  • Monthly payment depends on three things: how much you borrowed, the annual interest rate, and how many months you have to repay it.
  • You can calculate it by hand using the amortization formula, but a loan calculator or spreadsheet is faster and less error-prone.
  • The monthly interest rate is the annual rate divided by 12, and it compounds—meaning interest accrues on interest.
  • Paying extra toward principal reduces the total interest you pay and shortens the loan term.
  • The same payment formula works for mortgages, car loans, personal loans, and most installment plans.

Using a spreadsheet or online calculator

The fastest way to calculate a monthly payment is to use a spreadsheet formula or an online calculator. In Excel or Google Sheets, the function is PMT. You enter the monthly interest rate, the number of months, and the principal, and the formula returns your payment. For example, if you borrowed $10,000 at 6% annual interest over 36 months, you would type =PMT(0.06/12, 36, -10000) and get approximately $299.71 per month.

Online calculators work the same way but require no formula knowledge. You enter the loan amount, annual interest rate, and loan term in months or years, and the calculator shows your monthly payment instantly. Most banks and lenders provide calculators on their websites for their specific products—mortgage calculators, auto loan calculators, and so on.

The advantage of a spreadsheet is that you can change one number and see how the payment shifts. Raise the interest rate by 1% and watch the payment jump. Extend the term by five years and see it drop. This helps you understand the trade-offs before you commit to a loan.

Breaking down what happens each month

When you make your first payment, most of it goes to interest and only a small portion reduces what you owe. On a $200,000 mortgage at 4% over 30 years, your monthly payment is about $955. In month one, roughly $667 is interest and $288 is principal. You still owe $199,712.

By month 180 (halfway through the loan), the split has flipped. Now about $400 goes to interest and $555 goes to principal. By month 360 (the last payment), almost all of it is principal because the balance is nearly zero.

This is why paying extra toward principal early in the loan saves you the most money. An extra $100 per month on that mortgage, made from the start, can cut years off the loan and save tens of thousands in interest. Late in the loan, the same extra payment saves much less because there is less time for compound interest to work.

How interest rate affects your payment

A small change in interest rate creates a large change in your monthly payment, especially on long-term loans. On a $300,000 mortgage over 30 years, a 3% rate gives you a payment of about $1,265. At 4%, it jumps to $1,432. At 5%, it's $1,610. That's a $345 difference per month—or over $124,000 over the life of the loan—from a 2% rate increase.

This is why shopping for the best rate matters. Even a 0.5% difference can save thousands. On a car loan or personal loan, the effect is smaller in dollar terms but still significant. A $20,000 car loan at 4% over 60 months costs $368 per month. At 6%, it's $386 per month—$18 more each month, or $1,080 over the life of the loan.

Your rate depends on your credit score, the type of loan, the lender, and current market conditions. You cannot control market conditions, but you can improve your credit score before applying, and you can shop multiple lenders to find the best offer.

How loan term affects your payment and total cost

Stretching a loan over more months lowers your monthly payment but raises the total interest you pay. A $15,000 personal loan at 8% costs $304 per month over 60 months and $1,440 in total interest. The same loan over 84 months costs $237 per month but $3,888 in total interest—nearly three times as much.

The trade-off is between affordability now and cost later. A longer term makes the payment fit your budget, but you pay more overall. A shorter term costs less in interest but requires a higher monthly payment. There is no right answer—it depends on your cash flow and priorities.

Some loans let you choose the term. Others, like credit cards, have no fixed term—you pay interest on the balance until you pay it off. Installment plans (like buy-now-pay-later services) usually have a fixed term of 3 to 24 months, and the interest rate or fee is built into the payment.

What happens if you pay early or make extra payments

If you pay off a loan before the term ends, you stop accruing interest on the remaining balance. The interest you save depends on how much principal you paid down and how much time was left. Paying off a $10,000 loan in year two instead of year five saves you three years of interest.

Most loans allow extra payments without penalty. You can make a lump-sum payment toward principal, or you can increase your monthly payment. Either way, the extra money reduces the balance faster, which means less interest accrues. Some lenders apply extra payments to the next month's payment first (so you skip a month), while others apply it directly to principal. Check your loan documents or ask your lender which method they use.

Credit cards and lines of credit work differently. There is no fixed term, so there is no "paying early." You pay interest on whatever balance you carry. The only way to stop paying interest is to pay off the full balance before the due date or transfer the balance to a 0% promotional offer (which has its own term and conditions).

Common mistakes when calculating or comparing payments

The most common mistake is forgetting to convert the annual interest rate to a monthly rate. If the loan agreement says 6% annual interest, you must divide by 12 to get 0.5% per month (or 0.005 as a decimal). Using the annual rate directly in the formula will give you a wildly wrong answer.

Another mistake is confusing the number of payments with the loan term in years. A 5-year loan is 60 months, not 5 months. If you enter 5 instead of 60, your calculated payment will be far too high.

When comparing loans, make sure you are comparing the same term and the same rate type. A 3% fixed-rate mortgage is not the same as a 3% adjustable-rate mortgage (ARM), which can change after an initial period. A 0% promotional rate on a credit card is not the same as a regular purchase rate, which kicks in after the promotion ends. Always read the fine print to understand what rate you are actually getting and for how long.

Frequently Asked Questions

Can I calculate a monthly payment by hand without a calculator?

Yes, but it is tedious and error-prone. You need to convert the annual rate to a monthly decimal, calculate (1 + r) raised to the power of n, and then work through the full formula. A spreadsheet or calculator takes seconds and eliminates arithmetic mistakes. If you must do it by hand, write out each step carefully and double-check your decimal conversions.

Why does my actual payment differ from what the calculator showed?

The most common reason is that your lender rounds the payment to the nearest dollar or includes fees (origination fees, insurance, taxes) that are not part of the base calculation. Some lenders also add a day or two of interest at the start or end of the loan. Check your loan documents or call your lender to see what is included in your payment.

If I pay extra one month, does my payment go down the next month?

Not automatically. Most loans have a fixed monthly payment that stays the same for the entire term. If you pay extra, it reduces your principal balance, which means you pay off the loan faster and pay less interest overall. But your required monthly payment stays the same unless you refinance or your loan has a variable rate that adjusts based on market conditions.

How do I know if a loan is a good deal?

Compare the total amount you will pay (all monthly payments added together) against the principal you borrowed. The difference is the total interest. A $20,000 loan where you pay $24,000 total costs $4,000 in interest. Then compare that to other lenders' offers at similar terms. The lowest total cost is usually the best deal, but also consider whether the monthly payment fits your budget.

Does the calculation change for credit cards or buy-now-pay-later plans?

The underlying math is the same, but the structure is different. Credit cards charge interest on the remaining balance each month, so your payment can vary. Buy-now-pay-later plans usually have a fixed payment and a fixed term, so the calculation is the same as a personal loan. Always check whether interest is being charged and at what rate, because some BNPL services charge no interest if you pay on time.