The basic formula for any monthly payment
A monthly payment is the amount you owe each month on a loan or credit obligation. To calculate it, you need three pieces of information: the total amount borrowed (called the principal), the interest rate, and how many months you have to repay it. The formula most lenders use is called an amortizing payment calculation, and it produces a fixed amount you pay the same way each month.
The simplest version: if you borrow $10,000 at 0% interest over 12 months, your monthly payment is $10,000 divided by 12, which is $833.33. But almost no loan has 0% interest. When interest is involved, the math gets more complex because interest compounds — you pay interest on the interest — and the amount of interest in each payment changes as your balance shrinks.
Lenders, credit card companies, and banks all use the same underlying calculation. Understanding how it works helps you spot errors on a statement and predict what a loan will actually cost you over time.
Key Takeaways
- A monthly payment on a loan with interest requires the principal amount, annual interest rate, and total number of months to repay.
- The standard formula divides the principal by a factor that accounts for interest compounding over the loan term, producing a fixed monthly amount.
- Early in a loan, most of your payment goes toward interest; later, most goes toward principal.
- Online calculators and spreadsheet formulas (like PMT in Excel) do this calculation when ready, but knowing the steps helps you verify the result.
The formula when interest is involved
When a loan has interest, the monthly payment formula is:
M = P × [r(1 + r)^n] / [(1 + r)^n − 1]
Where M is the monthly payment, P is the principal (amount borrowed), r is the monthly interest rate (annual rate divided by 12), and n is the total number of months. The exponent (^n) means you multiply (1 + r) by itself n times.
This looks intimidating, but it solves a real problem: if you pay the same amount each month, how much of that payment is interest and how much reduces what you owe? The formula balances those two pieces so that by the final payment, your loan is fully repaid.
Example: You borrow $5,000 at 6% annual interest over 24 months. The monthly interest rate is 6% divided by 12, which is 0.5% or 0.005. Plugging into the formula: M = 5000 × [0.005(1.005)^24] / [(1.005)^24 − 1]. Working through the exponents and arithmetic gives you a monthly payment of approximately $219.36.
How to use a spreadsheet or calculator instead
You do not need to do this math by hand. Excel, Google Sheets, and most financial calculators have a built-in function that does it when ready. In Excel or Google Sheets, the function is called PMT. The syntax is =PMT(rate, nper, pv), where rate is the monthly interest rate (annual rate divided by 12), nper is the number of months, and pv is the principal as a negative number.
For the $5,000 loan at 6% over 24 months, you would type =PMT(0.06/12, 24, -5000) and the spreadsheet returns 219.36. Online loan calculators work the same way — you enter the loan amount, interest rate, and term, and it calculates the payment when ready.
The negative sign on the principal matters in spreadsheets because the function treats borrowed money as money flowing out of your account. If you enter it as positive, the result will be negative. Either way, the absolute value is your monthly payment.
Why your payment stays the same but the interest portion changes
On a fixed-rate loan, you pay the same dollar amount every month. But the breakdown of that payment shifts over time. Early in the loan, most of your payment covers interest because your balance is highest. As you pay down the principal, the interest portion shrinks and the principal portion grows.
Using the $5,000 loan example: your first payment of $219.36 includes about $25 in interest (0.5% of $5,000) and $194.36 toward principal. After 12 months, your balance is lower, so the interest portion of each payment drops to about $12. By month 24, interest is only a few dollars and nearly the entire payment reduces what you owe.
This is why paying extra toward principal early in a loan saves you significant interest. A $50 extra payment in month 1 reduces the balance that interest accrues on for the remaining 23 months. The same $50 extra in month 23 saves you interest for only one month.
Calculating payments on credit cards and variable-rate loans
Credit cards and some adjustable-rate mortgages work differently. Credit card issuers typically calculate a minimum payment as a percentage of your balance (often 1% to 3%) plus any interest and fees accrued that month. This is not a fixed amortizing payment — it changes each month based on your balance and spending.
Variable-rate loans (like adjustable-rate mortgages) use the same amortizing formula, but the interest rate changes on a set schedule. When the rate adjusts, the lender recalculates your monthly payment based on the new rate and the remaining balance and term. Your payment may go up or down depending on whether rates rose or fell.
For these products, you cannot calculate a single payment that applies to your entire loan term. Instead, you calculate the payment for each period using the rate and remaining term that applies during that period.
What affects your monthly payment
Three factors determine your monthly payment: the amount you borrow, the interest rate, and the length of the loan. Borrowing more increases your payment. A higher interest rate increases your payment. A longer loan term decreases your payment because you spread the cost over more months — but you pay more interest overall.
A $200,000 mortgage at 4% over 30 years costs about $955 per month. The same loan at 5% costs about $1,074 per month — $119 more each month, or $42,840 more over the life of the loan. Stretching the same loan to 40 years would lower the monthly payment to about $860, but you would pay interest for an extra decade.
Fees and insurance (like mortgage insurance or loan origination fees) are sometimes rolled into the loan amount, which increases your principal and therefore your payment. Other times they are charged separately. Always ask your lender whether the payment they quote includes all costs or just the principal and interest.
Checking your payment calculation against your statement
If you have a loan statement, you can verify the payment is correct by checking the numbers. Find the principal amount, annual interest rate, and loan term. Calculate the monthly interest rate by dividing the annual rate by 12. Count the total number of months from the loan start date to the payoff date. Then use the PMT formula or an online calculator with those three inputs.
The payment you calculate should match what appears on your statement. If it does not, the difference is usually because the statement includes fees, insurance, or taxes that are not part of the base loan payment. Ask your lender to itemize what is included in the payment amount they quoted.
If you are comparing loan offers from different lenders, always ask for the total monthly payment including all required charges — not just the principal and interest portion. A lower interest rate can be offset by higher fees or insurance, and the only way to compare fairly is to see the full monthly cost.
Frequently Asked Questions
What is the difference between principal and interest in a monthly payment?
Principal is the amount you borrowed; interest is the cost of borrowing it. Each monthly payment includes both. Early in a loan, most of your payment is interest. As your balance shrinks, more of each payment goes toward principal. By the final payment, you are paying mostly principal with very little interest.
Why does my monthly payment not change even though my balance goes down?
On a fixed-rate amortizing loan, the payment is calculated so that the same dollar amount each month will fully repay the loan by the end of the term. The interest portion of each payment decreases as your balance shrinks, so the principal portion increases to keep the total payment constant.
Can I calculate a monthly payment if I do not know the interest rate?
No. The interest rate is essential to the calculation. If you have a loan statement or offer letter, the rate should be listed as an annual percentage rate (APR). If you cannot find it, contact your lender directly — they are required to disclose it.
What happens to my monthly payment if interest rates go up?
On a fixed-rate loan, your payment never changes, even if market interest rates rise. On a variable-rate loan, your payment may increase when the rate adjusts. The lender recalculates your payment based on the new rate and the remaining balance and term.
Is there a way to lower my monthly payment?
You can lower your monthly payment by extending the loan term (paying over more months), but this increases total interest paid. You cannot change the interest rate on an existing fixed-rate loan. On a variable-rate loan, you have no control over rate changes. Refinancing to a new loan with a lower rate or longer term is another option, but involves new fees and a new process process.