The basic formula for a fixed monthly payment
A fixed monthly installment payment is the amount you owe each month on a loan or purchase plan. The calculation depends on three things: the total amount borrowed, the interest rate, and how many months you have to repay it.
For a simple loan with a fixed interest rate and equal monthly payments, the formula is:
Monthly Payment = [Principal × (Rate × (1 + Rate)^Months)] / [((1 + Rate)^Months) − 1]
This looks complicated, but it accounts for the fact that interest accrues on the remaining balance each month, not just the original amount. Most lenders use this exact calculation, and you do not have to do it by hand — your loan documents, lender's website, or a basic calculator will show you the number.
Key Takeaways
- Your monthly payment depends on the loan amount, the annual interest rate, and the number of months to repay.
- The interest rate must be converted to a monthly rate (annual rate divided by 12) before you plug it into any formula.
- Most lenders provide an amortization schedule that shows exactly how much principal and interest you pay each month.
- A higher interest rate or shorter repayment period will increase your monthly payment; a longer term will lower it.
- Online calculators and spreadsheet functions (like Excel's PMT function) do the math for you if you enter the loan details correctly.
Converting the annual interest rate to a monthly rate
Interest rates are almost always stated as an annual percentage. To use that rate in a monthly payment calculation, you must divide it by 12.
For example, if your loan has a 6% annual interest rate, the monthly rate is 6% ÷ 12 = 0.5% per month, or 0.005 as a decimal. This monthly rate is what goes into the formula above.
If you see a rate stated as "6% APR" (annual percentage rate), that is already the annual rate. Some lenders state a monthly rate directly — check your loan documents to be sure which one you have before you calculate.
A worked example with real numbers
Suppose you borrow $10,000 at 6% APR over 36 months (3 years). Here is how the calculation works:
- Principal (amount borrowed): $10,000
- Annual interest rate: 6%
- Monthly interest rate: 6% ÷ 12 = 0.5% = 0.005
- Number of months: 36
Plugging these into the formula:
Monthly Payment = [10,000 × (0.005 × (1.005)^36)] / [((1.005)^36) − 1]
Monthly Payment = [10,000 × (0.005 × 1.1964)] / [1.1964 − 1]
Monthly Payment = [10,000 × 0.005982] / 0.1964
Monthly Payment = $304.69
So you would pay approximately $304.69 each month for 36 months. Over the life of the loan, you pay $10,968.84 total — the extra $968.84 is the interest.
Using a spreadsheet or online calculator instead
You do not need to do this math by hand. Excel, Google Sheets, and most online loan calculators have a built-in function that does it instantly.
In Excel or Google Sheets, use the PMT function. The syntax is: =PMT(rate, nper, pv)
For the example above, you would type: =PMT(0.005, 36, -10000)
The rate is the monthly rate (0.005), nper is the number of months (36), and pv is the loan amount as a negative number (-10000). The result is $304.69.
Most lenders also provide an online calculator on their website where you enter the loan amount, rate, and term — it calculates your payment instantly. This is the fastest way to see what your actual payment will be.
How changes to the loan terms affect your payment
If you extend the repayment period, your monthly payment goes down but you pay more interest overall. If you shorten it, your payment goes up but total interest falls.
Using the same $10,000 loan at 6% APR:
| Loan Term | Monthly Payment | Total Interest Paid |
|---|---|---|
| 24 months (2 years) | $432.65 | $438.60 |
| 36 months (3 years) | $304.69 | $968.84 |
| 60 months (5 years) | $193.33 | $1,599.80 |
A higher interest rate also raises your monthly payment. At the same $10,000 loan over 36 months, a 9% APR would cost $316.04 per month instead of $304.69 — about $11 more each month, or $396 more over the life of the loan.
Understanding your amortization schedule
An amortization schedule is a month-by-month breakdown of your loan payments. It shows how much of each payment goes toward principal (the amount you borrowed) and how much goes toward interest.
Early in the loan, most of your payment covers interest. As you pay down the principal, more of each payment goes toward the balance itself. By the end, almost all of your payment reduces the principal.
Your lender is required to provide an amortization schedule when you sign the loan documents. You can also generate one using an online calculator or spreadsheet. This schedule is useful if you want to see how much you still owe at any point, or what happens if you make extra payments toward principal.
What happens if the interest rate changes
If your loan has a fixed interest rate, your monthly payment never changes — it stays the same for the entire loan term. This is the most common type of personal loan, car loan, and mortgage.
If your loan has a variable or adjustable interest rate, your payment may change when the rate adjusts. Credit cards, home equity lines of credit, and some adjustable-rate mortgages work this way. When the rate goes up, your payment goes up; when it goes down, your payment goes down.
Your loan documents will tell you whether your rate is fixed or variable, and if variable, when and how often it can change.
Frequently Asked Questions
Can I calculate my payment if I know only the total amount I will pay?
Not directly — you need the interest rate and loan term to work backward to a monthly payment. If you have a loan document, it will state all three. If you only know the total amount paid, you can subtract the principal to find total interest, but you still need the rate or term to find the monthly payment.
What if I want to pay more than the monthly payment?
Most loans allow you to pay extra toward principal without penalty. Extra payments reduce the total interest you pay and shorten the loan term. Check your loan documents or ask your lender whether there are any prepayment penalties before you make extra payments.
Does the payment calculation change if I make a down payment?
Yes. The monthly payment is calculated on the amount you actually borrow, not the full purchase price. If you buy something for $20,000 and put down $5,000, the loan amount is $15,000, and that is what goes into the calculation.
Why does my actual payment differ slightly from what the calculator shows?
Rounding, fees, taxes, or insurance added to the loan can cause small differences. Some lenders also round the payment to the nearest dollar or cent. Check your loan documents for the exact payment amount — that is what you owe.
How do I find the interest rate if my loan documents do not clearly state it?
Look for "APR" (annual percentage rate) or "interest rate" on your loan agreement, disclosure statement, or monthly statement. If you cannot find it, contact your lender directly — they are required to provide this information.