The basic formula: principal, rate, and time
To find your monthly payment on a loan or credit balance, you need three numbers: the principal (the amount you borrowed), the annual interest rate (usually shown as a percentage), and the loan term (how many months you have to pay it back). 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. If that looks intimidating, know that you do not have to do this by hand—a calculator or spreadsheet does the work. But understanding what each piece means helps you spot errors and compare offers.
Here is a concrete example: you borrow $5,000 at 6% annual interest over 24 months. The monthly rate is 0.06 ÷ 12 = 0.005. Plugging into the formula gives you a monthly payment of about $219. Over 24 months, you pay $5,256 total—the extra $256 is interest.
Key Takeaways
- Your monthly payment depends on three things: how much you borrowed, the annual interest rate, and how many months you have to repay it.
- A loan calculator or spreadsheet formula saves time and removes the risk of arithmetic errors when comparing different loan offers.
- The interest rate matters more than you might think—a 1% difference in rate can change your monthly payment by tens of dollars on larger loans.
- Your lender is required to show you the total interest you will pay and the monthly payment amount before you sign, so always ask for a written breakdown.
Using a loan calculator instead of doing the math yourself
Most lenders provide a calculator on their website, and many banks and credit unions offer free tools that work for any loan. You enter the principal, the annual interest rate, and the number of months, and the calculator returns your monthly payment instantly. This is faster and more accurate than hand calculation, especially when you are comparing multiple offers.
If you want to build your own calculator in a spreadsheet, Excel and Google Sheets both have a PMT function that does the work for you. The syntax is =PMT(rate, nper, pv), where rate is the monthly interest rate, nper is the number of months, and pv is the loan amount as a negative number. For the $5,000 example above, you would type =PMT(0.005, 24, -5000) and get the same $219 result.
Why the interest rate changes your payment more than you expect
A 1% difference in interest rate does not sound like much, but it shifts your monthly payment noticeably. On a $10,000 loan over 36 months, a 4% rate gives you a monthly payment of about $294, while a 5% rate gives you about $299. That is only $5 per month—but over 36 months, you pay an extra $180 in interest.
On larger loans or longer terms, the gap widens. A $200,000 mortgage at 3% over 360 months (30 years) costs about $843 per month. The same mortgage at 4% costs about $955 per month—$112 more every single month, or $40,320 more over the life of the loan. This is why shopping around for the lowest rate matters, especially on mortgages, auto loans, and personal loans.
Your interest rate depends on your credit score, the type of loan, the lender's current rates, and how much you borrow. A higher credit score usually means a lower rate. A secured loan (backed by collateral, like a car loan) usually has a lower rate than an unsecured loan (like a credit card or personal loan).
Understanding amortization: how much goes to interest versus principal
When you make your first payment, most of it goes to interest and only a small portion reduces the principal. As you pay down the loan, this ratio flips—later payments put more toward principal and less toward interest. This schedule is called amortization.
On a $5,000 loan at 6% over 24 months with a $219 monthly payment, your first payment includes about $25 in interest and $194 toward principal. By month 24, you pay almost no interest and nearly the full $219 goes to principal. Your lender can give you an amortization schedule that shows exactly how much of each payment goes where. This matters if you want to pay off the loan early—paying extra early in the term saves you the most interest.
What happens when interest compounds monthly versus daily
Most installment loans (car loans, personal loans, mortgages) use monthly compounding: interest is calculated once per month based on your balance at that time. Credit cards often use daily compounding, which means interest accrues every single day. This makes a difference if you carry a balance.
On a credit card with a 20% annual rate and a $1,000 balance, monthly compounding would charge about $17 in interest that month. Daily compounding charges about $16.44—slightly less because the interest is spread across the days. But if you only make minimum payments and carry the balance for months, daily compounding adds up to noticeably more interest paid overall. This is one reason credit card debt grows faster than installment loan debt at the same stated rate.
How to compare two loan offers side by side
When you have multiple loan offers, ask each lender for the same information in writing: the principal amount, the annual interest rate, the number of months, and the monthly payment. Then calculate the total amount you will pay by multiplying the monthly payment by the number of months, and subtract the principal to find total interest.
| Lender | Principal | Annual Rate | Months | Monthly Payment | Total Paid | Total Interest |
|---|---|---|---|---|---|---|
| Bank A | $10,000 | 4.5% | 60 | $186 | $11,160 | $1,160 |
| Bank B | $10,000 | 5.0% | 60 | $189 | $11,340 | $1,340 |
| Bank C | $10,000 | 4.5% | 72 | $158 | $11,376 | $1,376 |
In this example, Bank A has the lowest monthly payment and the lowest total interest. Bank C has a lower monthly payment than Bank A, but you pay more total interest because you are paying for 12 extra months. The choice depends on your budget—if you need the lowest monthly payment, Bank C works. If you want to pay the least interest overall, Bank A is better.
What to ask your lender before you sign
Before you accept a loan offer, confirm these details in writing: the exact annual interest rate (not a range), whether the rate is fixed or variable, the number of months, the monthly payment amount, the total amount you will pay over the life of the loan, and any fees (origination, prepayment penalty, late fees). Some lenders charge an origination fee upfront, which increases your effective cost even if the stated rate is low.
Ask whether you can pay off the loan early without penalty. Some loans charge a prepayment penalty if you pay faster than the schedule requires. If there is no penalty, paying extra toward principal early in the loan saves you significant interest. Also ask what happens if you miss a payment—how many days before a late fee kicks in, and what the fee is.
Frequently Asked Questions
Can I calculate my payment if the interest rate changes?
If your rate is variable (adjustable), the payment calculation only works for the current rate period. Once the rate changes, your lender recalculates your payment for the remaining balance and term. Ask your lender how often the rate adjusts and what the maximum rate can be—this helps you budget for worst-case scenarios.
What if I want to pay off the loan early?
You can pay extra toward principal at any time, and most lenders allow this without penalty. Use an amortization calculator to see how much interest you save. Paying an extra $50 per month on a 30-year mortgage can cut years off the loan and save tens of thousands in interest. Always confirm with your lender that there is no prepayment penalty before you start.
Why does my actual payment differ from the calculator result?
Small differences (a few dollars) usually come from rounding. Larger differences may mean your lender is including fees, insurance, or taxes in the payment. Ask your lender for an itemized breakdown showing the base payment, any fees, and any other charges rolled into the monthly amount.
How do I know if an interest rate is good?
Interest rates change daily and depend on the type of loan, your credit score, and current market conditions. Check what rates major banks and credit unions are currently offering for your loan type, then compare your offer to those benchmarks. A rate 1% or more above the current average is worth shopping around to avoid.
Does paying biweekly instead of monthly save interest?
Yes, but only if your lender allows it and does not charge a fee. Biweekly payments mean you make 26 payments per year instead of 12, which is equivalent to one extra monthly payment annually. This extra payment goes straight to principal and reduces the total interest you pay. Confirm with your lender that biweekly payments are free before you set them up.