What a loan payment calculation shows you
A loan payment calculation tells you how much you owe each month for a specific loan. It takes three numbers — the amount you borrowed, the interest rate, and how many months you have to repay it — and produces a single monthly payment amount. This is the number your lender will quote you, and it's what you'll see on your statement each month.
The calculation matters because it's the foundation of every loan decision. Before you sign, you need to know whether that payment fits your budget. Before you refinance, you need to compare what you're paying now against what you'd pay under new terms. The math is straightforward once you understand what each piece means.
Key Takeaways
- A monthly payment depends on three things: the loan amount, the interest rate, and the number of months you have to repay it.
- You can calculate a payment using a formula, a spreadsheet function, or an online calculator — all three produce the same result.
- The payment stays the same every month on a fixed-rate loan, but changes monthly on a variable-rate loan as the interest rate moves.
- Your actual payment may be higher than the calculated amount if property taxes, insurance, or other costs are rolled into the monthly bill.
- Changing any one of the three inputs — borrowing less, getting a lower rate, or extending the term — lowers your monthly payment.
The three numbers you need
Principal is the amount you borrowed. On a mortgage, this is the home price minus your down payment. On a car loan, it's the vehicle price minus any trade-in credit. On a personal loan, it's simply the amount the lender gives you. This number appears on your loan documents and your first statement.
Interest rate is the annual percentage the lender charges you to borrow. A mortgage might be 6.5 percent, a car loan 7 percent, a personal loan 10 percent or higher. The lender quotes this as an annual rate, but the calculation converts it to a monthly rate by dividing by 12. This rate is locked in on a fixed-rate loan and changes periodically on a variable-rate loan.
Loan term is how many months you have to repay the loan. A 30-year mortgage is 360 months. A 5-year car loan is 60 months. A 3-year personal loan is 36 months. The longer the term, the lower your monthly payment — but you pay more interest overall because you're borrowing for longer.
How to calculate the payment yourself
The standard formula for a fixed-rate loan payment is:
M = P × [r(1 + r)^n] / [(1 + r)^n − 1]
Where M is the monthly payment, P is the principal, r is the monthly interest rate (annual rate divided by 12), and n is the number of months. This formula accounts for the fact that as you pay down the loan, interest applies only to the remaining balance.
Example: You borrow $300,000 at 6 percent for 30 years. The monthly interest rate is 0.06 ÷ 12 = 0.005. The number of months is 30 × 12 = 360. Plugging into the formula gives you a payment of approximately $1,799 per month (before taxes, insurance, or other costs).
Most people don't calculate this by hand. A spreadsheet does it faster and with no arithmetic errors.
Using a spreadsheet to find your payment
Microsoft Excel, Google Sheets, and most other spreadsheet programs have a built-in function called PMT that calculates loan payments. The syntax is slightly different between programs, but the idea is the same: you enter the rate, the number of periods, and the loan amount, and the function returns your payment.
In Excel or Google Sheets, the formula looks like this: =PMT(rate, nper, pv). The "rate" is your monthly interest rate (annual rate divided by 12), "nper" is the number of months, and "pv" is the loan amount as a negative number (because it's money you owe). For the $300,000 mortgage at 6 percent over 30 years, you'd type =PMT(0.06/12, 360, -300000) and the cell will show 1799.20.
This method is faster than the formula and less error-prone. If you change one number — say, you want to see what a 25-year term costs — you just edit that cell and the payment recalculates instantly.
Online calculators and what they show
Most lenders, financial websites, and real estate sites offer free payment calculators. You enter the loan amount, rate, and term, and the calculator shows your monthly payment. Many also break down how much of each payment goes toward principal versus interest, and show a full amortization schedule — a month-by-month table of your balance, payment, and interest.
These calculators are reliable for fixed-rate loans. For variable-rate loans, they can only show you the payment based on today's rate; they cannot predict what your payment will be when the rate adjusts. Some calculators also let you add property taxes, homeowners insurance, and mortgage insurance to see your total monthly housing cost, though those amounts vary by location and lender.
The advantage of an online calculator is that you don't have to know the formula or use a spreadsheet. The disadvantage is that you're dependent on the website being available and accurate. A spreadsheet or the formula itself is something you control and can use offline.
Why your actual payment may differ from the calculation
The calculation gives you the principal and interest portion only. On a mortgage, your lender often collects additional money each month for property taxes, homeowners insurance, and mortgage insurance (if your down payment was less than 20 percent). These are rolled into a single payment called PITI — principal, interest, taxes, and insurance.
On a car loan, your payment is usually just principal and interest. However, if you financed the loan through a dealer and included gap insurance or an extended warranty, those costs are added to the principal, which raises your payment.
On a personal loan, the payment is typically just principal and interest, with no additional costs. However, some lenders charge an origination fee that gets added to the loan amount, which increases the principal and therefore the payment.
Always ask your lender for a loan estimate or disclosure document that shows the exact payment you'll make, including all costs. This is required by law before you sign, and it's the only number that matters for your budget.
How changes to the loan terms affect your payment
If you're deciding between loan options, small changes to the three inputs produce large changes to your payment. Borrowing $50,000 instead of $60,000 lowers your payment by roughly one-sixth. Extending the term from 5 years to 7 years lowers your payment, but you pay significantly more interest over the life of the loan. Getting a 0.5 percent lower interest rate saves you money every month and reduces total interest paid.
The trade-off is always between affordability now and total cost over time. A longer term makes the payment smaller but costs you more in interest. A lower rate costs less overall but may require a larger down payment or better credit. A smaller loan amount lowers the payment but may not cover what you need to buy.
Use a calculator or spreadsheet to run scenarios. See what happens if you put down 15 percent instead of 10 percent, or if you choose a 20-year term instead of 30. This is how you find the balance between a payment you can afford and a total cost you're comfortable with.
Fixed-rate versus variable-rate payments
On a fixed-rate loan, the interest rate is locked in for the entire term. Your monthly payment stays the same from month one through the final payment. This makes budgeting predictable. A 30-year mortgage at 6 percent will have the same payment in year 1 and year 30.
On a variable-rate loan, the interest rate is fixed for an initial period (often 3, 5, 7, or 10 years) and then adjusts periodically based on market conditions. When the rate adjusts, your monthly payment recalculates. An adjustable-rate mortgage (ARM) might start at 5 percent for 5 years, then adjust to 6 percent or higher. Your payment will jump when the adjustment happens.
A variable-rate loan can offer a lower initial payment, which is attractive if you're stretching your budget. However, you're taking on the risk that rates will rise and your payment will become unaffordable. Most people use a fixed-rate loan for predictability, especially on mortgages where the term is 15 or 30 years.
Frequently Asked Questions
Can I calculate a payment if I don't know the exact interest rate yet?
Yes. Use the rate your lender quoted you, or use a rate from recent loans of the same type to estimate. The calculation will show you a ballpark payment. Once you have a formal loan offer, recalculate with the actual rate. Even a 0.25 percent difference will change your payment, so always use the final rate before you commit.
What's the difference between the payment I calculate and the payment on my statement?
The calculation usually shows principal and interest only. Your statement payment includes taxes, insurance, and other costs. Ask your lender for an amortization schedule that breaks down exactly what you're paying each month. This document is part of your loan disclosure and shows the principal and interest separately.
If I pay more than the calculated payment, what happens?
The extra money goes toward principal, which reduces your balance faster and saves you interest over time. You'll pay off the loan sooner. Most lenders allow extra payments without penalty, but check your loan documents to confirm. Some loans charge a prepayment penalty, though this is rare on mortgages and car loans.
How do I know if a payment is actually affordable for me?
A common guideline is that your total monthly housing costs (including taxes and insurance) should not exceed 28 percent of your gross monthly income. For other loans, the rule of thumb is that all debt payments combined should not exceed 36 percent of gross income. These are guidelines, not rules — your own comfort level matters most.
Does the payment change if I make extra payments during the year?
No. Your regular monthly payment stays the same. Extra payments reduce your balance, which means less interest accrues, but they don't change the amount you're required to pay each month. However, making extra payments will shorten the loan term and reduce total interest paid.