How to Calculate What You'll Actually Pay on a Loan
The Basic Formula: Principal, Rate, and Time
A loan payment with interest is calculated using three pieces of information: how much you borrowed (the principal), the yearly interest rate, and how long you have to pay it back. The lender uses these to figure out how much you owe each month so that by the end of the loan term, you will have paid back both the original amount and the interest.
The simplest way to think about it: interest is the cost of borrowing money. If you borrow $10,000 at 5% interest over five years, you will pay back more than $10,000 because the lender charges you for the use of their money. The exact amount depends on whether the loan uses simple interest (calculated only on the original amount) or compound interest (calculated on the original amount plus accumulated interest). Most personal and student loans use a method called amortization, which spreads the interest across all your monthly payments.
Key Takeaways
- Your monthly payment is determined by the loan amount, the annual interest rate, and the number of months you have to repay it.
- Amortization means each payment includes both principal (what you borrowed) and interest, with the split changing each month.
- Early in the loan, most of your payment goes to interest; later, most goes to principal.
- You can calculate your payment using an online calculator, a spreadsheet formula, or by asking your lender for an amortization schedule.
- A higher interest rate or longer loan term means you pay more total interest, even if your monthly payment looks smaller.
How Amortization Splits Your Payment Between Principal and Interest
When you make a monthly payment on an amortized loan, that payment covers two things: a portion of the original amount you borrowed and a portion of the interest the lender is charging. The split changes every month. Early payments are mostly interest; later payments are mostly principal.
Here is why: interest is calculated on whatever balance remains. In month one, the balance is the full amount you borrowed, so the interest charge is high. After you make that first payment, the balance drops slightly, so the interest charge in month two is a tiny bit lower. This pattern continues for the life of the loan. By the final payment, almost all of it goes to principal because very little balance remains.
This is why paying extra toward principal early in the loan saves you significant money—you reduce the balance that future interest is calculated on. A lender will usually provide an amortization schedule, a month-by-month table showing how much of each payment goes to principal and how much to interest.
The Math: Using the Standard Payment Formula
The formula lenders use to calculate your monthly payment is:
M = P × [r(1 + r)^n] / [(1 + r)^n − 1]
Where M is your 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 payments (years × 12).
Example: You borrow $5,000 at 6% annual interest over three years. The monthly rate is 0.06 ÷ 12 = 0.005. The number of payments is 3 × 12 = 36. Plugging into the formula gives a monthly payment of about $149.86. Over 36 months, you will pay $5,394.96 total, meaning $394.96 goes to interest.
You do not need to memorize or manually calculate this formula. Lenders provide it automatically, and free online loan calculators use it behind the scenes. The formula exists so you understand that your payment is not arbitrary—it is mathematically designed so that by the final payment, your loan is fully repaid.
Using Online Calculators and Spreadsheets
The fastest way to see what you will pay is an online loan calculator. You enter the loan amount, annual interest rate, and loan term in months or years, and the calculator shows your monthly payment and total interest cost. Most banks, credit unions, and loan comparison websites offer these for free.
If you prefer a spreadsheet, Excel and Google Sheets both have a built-in function called PMT that does the calculation for you. In Excel, the formula looks like =PMT(rate, nper, pv), where rate is the monthly interest rate, nper is the number of payments, and pv is the loan amount (entered as a negative number). This gives you the same result as an online calculator and lets you experiment with different loan amounts or terms to see how they affect your payment.
Your lender will also provide an amortization schedule, either when you sign the loan documents or on request. This shows every payment for the life of the loan, broken down into principal and interest. Reviewing this schedule helps you understand exactly where your money goes each month and what happens if you pay extra.
Why the Interest Rate and Loan Term Matter So Much
Two factors have the biggest impact on how much you pay: the interest rate and how long you have to repay. A higher rate means more interest. A longer term means more payments, so more interest accumulates even if the rate stays the same.
Compare two scenarios: a $10,000 loan at 5% over three years costs about $263 per month and $9,457 total (meaning $457 in interest). The same loan at 5% over five years costs about $189 per month but $11,327 total (meaning $1,327 in interest). The monthly payment is lower, but you pay nearly three times as much interest because you are paying for an extra two years.
This is why shopping for a lower interest rate can save you thousands of dollars over the life of a loan. Even a 1% difference in rate changes your total cost significantly. It is also why paying off a loan early—if your lender allows it without penalty—saves money: you stop accumulating interest sooner.
Reading Your Loan Documents and Statements
When you receive loan documents, look for these numbers: the principal amount, the annual percentage rate (APR), and the loan term. The APR includes both the interest rate and any fees the lender charges, so it is more accurate than the interest rate alone for comparing loans.
Your monthly statement will show your payment amount, how much went to principal, how much went to interest, and your remaining balance. If you do not see this breakdown, ask your lender for it or request an amortization schedule. Understanding this breakdown helps you see the real cost of the loan and decide whether paying extra makes sense for your situation.
Some loans have variable interest rates, meaning the rate changes over time based on market conditions. If your loan has a variable rate, your payment may change when the rate adjusts. Your lender is required to notify you before this happens and explain the new payment amount.
What Happens When You Pay Extra or Pay Early
If you pay more than your required monthly payment, the extra goes directly to principal (assuming your lender does not charge a prepayment penalty). This reduces the balance that future interest is calculated on, which means you pay less total interest and finish the loan sooner.
Example: On that $5,000 loan at 6% over three years, your regular payment is $149.86. If you pay $200 per month instead, you will finish in about 26 months instead of 36, and you will pay roughly $300 less in total interest. The earlier you pay extra, the more you save, because you reduce the balance for more months to come.
Before paying extra, check your loan documents for a prepayment penalty—some loans charge a fee if you pay off early. Most personal loans and federal student loans do not have this penalty, but some private student loans and older mortgages do. If there is no penalty, paying extra is almost always worth it.
Frequently Asked Questions
How do I know if my lender calculated my payment correctly?
Use an online calculator or spreadsheet with your loan amount, annual interest rate, and loan term. If the result matches what your lender quoted, the calculation is correct. If it does not match, ask your lender to explain the difference—there may be fees or other charges included in your payment.
Why does my payment stay the same every month if the interest portion changes?
The total payment stays the same because the formula is designed that way. As the interest portion shrinks, the principal portion grows by exactly the same amount, so the total remains constant. This is the whole point of amortization—predictable, equal payments.
What is APR and how is it different from the interest rate?
The interest rate is just the percentage charged on the loan balance. The APR (annual percentage rate) includes the interest rate plus any fees the lender charges, expressed as a yearly rate. APR gives you a more complete picture of the true cost of borrowing, which is why lenders are required to disclose it.
Can I change my loan term after I have already borrowed?
You cannot change the original term, but you can refinance—take out a new loan to pay off the old one with different terms. Refinancing can lower your payment if you extend the term or get a lower rate, or it can save you interest if you shorten the term. Ask your lender whether refinancing makes sense for your situation.
What if I want to pay off my loan in half the time?
Calculate what your payment would be over the shorter term using an online calculator, then ask your lender if you can make those larger payments. Some lenders allow this without refinancing. Paying off early saves you significant interest, but make sure you have the budget to handle the higher payment every month.