The basic formula: principal, interest rate, and loan term
A loan payment is calculated using three pieces of information: the amount you borrowed (called principal), the yearly interest rate, and how many months you have to repay it. The formula spreads your debt across equal monthly payments so you pay down both the principal and the interest over time.
The standard formula is called the amortization formula. It looks like this:
Monthly Payment = P × [r(1 + r)^n] / [(1 + r)^n − 1]
Where P is the principal, r is the monthly interest rate (yearly rate divided by 12), and n is the total number of months. You do not need to memorize this—a calculator or spreadsheet does the work—but understanding what each part does helps you see why changing one number changes your payment.
Key Takeaways
- Your monthly payment depends on three things: how much you borrowed, the interest rate, and how long you have to repay it.
- A higher interest rate or shorter loan term raises your monthly payment; a longer term lowers it but costs more in total interest.
- You can calculate payments using an online calculator, a spreadsheet formula, or by hand if you have a scientific calculator.
- The first payments go mostly toward interest; later payments go mostly toward principal, even though the payment amount stays the same.
- Your actual payment may differ from the calculated amount if your loan includes fees, insurance, or a variable interest rate.
How interest rate and loan term change your payment
Lowering the interest rate lowers your monthly payment. A $200,000 loan at 5% over 30 years costs less per month than the same loan at 7%. The difference compounds over time, so a 2% rate increase can add hundreds of dollars to your monthly bill.
Extending the loan term also lowers your monthly payment—spreading the debt over more months means smaller chunks each time. But you pay more interest overall because you are borrowing the money for longer. A 30-year mortgage costs far more in total interest than a 15-year mortgage at the same rate, even though the monthly payment is lower.
Shortening the term raises your monthly payment but saves you money on interest. If you can afford a higher payment, paying off a loan faster is usually the cheaper choice over the life of the loan.
Using a calculator or spreadsheet
The fastest way to find your payment is an online loan calculator. You enter the principal, interest rate, and number of months, and it returns your monthly payment instantly. Most banks and lenders have calculators on their websites for mortgages, car loans, and personal loans.
You can also use a spreadsheet. In Excel or Google Sheets, the function is =PMT(rate, nper, pv). The rate is your monthly interest rate (yearly 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% yearly over 60 months would be =PMT(0.06/12, 60, -10000), which returns about $193.33 per month.
If you prefer to calculate by hand, you need a scientific calculator that handles exponents. The formula is the same one above, but doing it step by step takes several minutes and is easy to get wrong. A calculator or spreadsheet is worth the two minutes it takes to set up.
What happens to your payment over time
Your monthly payment stays the same for the life of a fixed-rate loan, but what that payment covers changes. Early in the loan, most of your payment goes toward interest; very little reduces the principal. As time passes, the balance shrinks, so less of each payment goes to interest and more goes to principal.
This is why paying extra toward principal early in the loan saves you the most money. An extra $50 per month in year one reduces years of future interest; an extra $50 in year 25 saves only a few months of interest. An amortization schedule shows you exactly how much of each payment goes to principal and interest. Your lender can provide one, or you can generate one in a spreadsheet using the same PMT function.
Fees and insurance that change the real payment
The calculated payment covers principal and interest only. Many loans also include fees rolled into the monthly bill: origination fees, servicing fees, or mortgage insurance (PMI on home loans, or credit insurance on personal loans). These are added to the total amount financed, which raises your monthly payment above the calculated number.
Ask your lender for the Truth in Lending Act (TILA) disclosure or Loan Estimate (for mortgages). These documents show the total amount you will pay, the annual percentage rate (APR), and the monthly payment including all fees. The APR is higher than the stated interest rate because it includes fees, so it is a more accurate picture of what the loan actually costs you.
Variable-rate loans and payment changes
If your loan has a variable or adjustable interest rate, your payment will change when the rate changes. Adjustable-rate mortgages (ARMs) often start with a low fixed rate for a few years, then adjust yearly or every few years based on a market index. When the rate goes up, your payment goes up; when it goes down, your payment goes down.
The initial payment is calculated the same way as a fixed-rate loan, but you should plan for the payment to increase. Lenders are required to tell you the maximum rate your loan can reach and show you what your payment would be at that rate. Use that worst-case number to decide whether you can afford the loan if rates rise.
Frequently Asked Questions
Why is my actual payment different from what the calculator shows?
Your lender may have added fees, insurance, or property taxes to the monthly bill. Ask for an itemized payment breakdown. Also check whether the calculator used the exact interest rate and loan term from your loan documents—even a small difference in either number changes the payment.
Can I pay off a loan early without penalty?
Most loans allow early payoff with no penalty, but some—particularly mortgages and car loans—may charge a prepayment penalty. Check your loan agreement or ask your lender. Paying extra toward principal each month shortens the loan and saves interest without triggering a penalty on most loans.
What is APR and how does it differ from the interest rate?
The interest rate is the cost of borrowing the money. The APR (annual percentage rate) includes the interest rate plus fees, insurance, and other costs, expressed as a yearly rate. APR is a more complete picture of what the loan costs, so compare APRs when shopping between lenders, not just interest rates.
If I make a larger down payment, how much does my monthly payment drop?
A larger down payment lowers the principal, which lowers the monthly payment proportionally. If you put down twice as much, the loan amount is half as large, so your payment is roughly half as large (assuming the same rate and term). Use a calculator to see the exact difference for your situation.
How do I know if a loan term is too long?
Compare the total amount you will pay over the life of the loan, not just the monthly payment. A 30-year mortgage costs far more in total interest than a 15-year mortgage. If you can afford a higher monthly payment, a shorter term saves you money overall. Your lender's disclosure documents show the total interest you will pay.