The Loan Payment Formula Explained
When you take out a fixed-rate personal loan, your monthly payment is determined by an amortization formula. This formula assumes you pay the same amount each month, with a portion going toward interest and the rest toward the principal balance. Over time, the interest portion decreases and the principal portion increases.
The standard formula for calculating a fixed-rate loan payment is: Payment = P × [r(1 + r)^n] / [(1 + r)^n – 1], where P is the loan amount (principal), r is the monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments (loan term in years multiplied by 12).
- P: Loan principal, the amount you borrow.
- r: Monthly interest rate, expressed as a decimal (annual rate divided by 12 and then by 100).
- n: Total number of monthly payments (term in years × 12).
Step-by-Step: How to Calculate a Monthly Payment
To calculate your monthly payment manually, follow these steps. First, convert your annual interest rate to a monthly rate by dividing by 12. For example, an annual rate of 6% becomes a monthly rate of 0.5% (0.06 ÷ 12 = 0.005). Next, determine the total number of payments by multiplying the loan term in years by 12.
Then, plug these numbers into the formula. For a $10,000 loan at 6% annual rate for 3 years (36 months), the calculation is: Payment = 10000 × [0.005(1.005)^36] / [(1.005)^36 – 1]. Using a calculator or spreadsheet will give you approximately $304.22 per month.
This example assumes a fixed interest rate and no additional fees. If your loan includes origination fees, see the section on including origination fees.
- Convert the annual interest rate to a monthly rate: divide the annual rate by 12.
- Calculate total payments: multiply loan term in years by 12.
- Apply the formula: Payment = P × [r(1 + r)^n] / [(1 + r)^n – 1].
- follow this calculation guide or spreadsheet to compute the result.
The Monthly Payment Formula
The monthly payment formula is the core tool for estimating what you'll pay each month on a fixed-rate loan. It is expressed as: Payment = P × [r(1 + r)^n] / [(1 + r)^n – 1]. This formula accounts for the loan amount, the monthly interest rate, and the number of payments to produce a consistent monthly figure.
In this formula, P is the principal, r is the monthly interest rate, and n is the total number of monthly payments. The formula is widely used for amortizing loans, including personal loans, auto loans, and mortgages.
How Loan Term Affects Your Payment and Interest
The length of your loan term directly influences both your monthly payment and the total interest you'll pay over time. A shorter term, such as 24 months, results in higher monthly payments but significantly less total interest, because you pay off the principal faster and accrue interest for a shorter period.
Conversely, a longer term, such as 60 months, lowers your monthly payment but increases the total interest paid over the life of the loan. For example, on a $10,000 loan at 6% annual rate, a 36-month term has a monthly payment of about $304, while a 60-month term drops to about $193 – but the total interest rises from roughly $952 to $1,597.
- Shorter term: higher monthly payments, lower total interest.
- Longer term: lower monthly payments, higher total interest.
How Interest Rate Affects Total Cost
Your interest rate is a major factor in the total cost of a personal loan. Even a small difference in rate can translate into hundreds of dollars over the life of the loan. For example, on a $10,000 loan with a 3-year term, an annual rate of 6% results in a monthly payment of about $304 and total interest of about $952, while an annual rate of 12% raises the payment to about $332 and total interest to about $1,958.
It's important to compare annual percentage rates (APRs) rather than just monthly payments, because a lower monthly payment may come with a longer term and higher overall cost. The APR reflects the yearly cost of the loan, including certain fees, making it a useful tool for comparison.
Including Origination Fees
Some personal loans charge an origination fee, which is a percentage of the loan amount. This fee is often deducted from the loan proceeds, so you receive slightly less than the full amount you borrowed. However, the payment formula typically uses the full loan amount as the principal, meaning your monthly payment is based on the amount you agreed to repay, not the smaller amount you actually receive.
To estimate the effect of an origination fee on your total cost, you can add the fee to the total amount you'll repay. For example, if you borrow $10,000 with a 5% origination fee ($500), you'll receive $9,500, but your monthly payment is calculated on the $10,000 principal. The fee effectively increases the cost of borrowing, and it is included in the APR if the lender discloses it as part of the APR calculation.
- Origination fees reduce the amount you receive, not the principal used in the formula.
- Compare APRs to understand fees: APR includes certain fees and reflects the true cost.
Using a Spreadsheet or Online Guide
While you can calculate loan payments by hand using the formula, most people use spreadsheet software or an online loan payment guide. In spreadsheet software, you can use the PMT function, which requires the monthly rate, number of payments, and loan amount. The syntax is PMT(rate, nper, pv), where rate is the monthly interest rate and pv is the loan amount as a negative number.
For example, in a spreadsheet cell, entering =PMT(0.06/12, 36, -10000) would return approximately $304.22. If you prefer a step-by-step approach, you can build your own spreadsheet by setting up columns for each period, applying the interest rate to the remaining balance, and subtracting the payment.
Manual Estimates and Their Limitations
Manual calculations provide a close estimate, but they may not reflect the exact payment your lender quotes. Lenders may round payments to the nearest dollar or adjust the final payment to offset rounding. They may also use specific day-count conventions or require payments on a certain date.
In addition, if your loan has a variable rate, fees beyond origination (such as late fees), or if you make extra payments, the actual payment schedule will differ. Always review the loan agreement provided by your lender for the precise terms.
How to Convert the Annual Interest Rate to a Monthly Rate
For the monthly payment formula, you need the monthly interest rate, which is the annual interest rate (the note rate) divided by 12. For example, an annual rate of 7.2% becomes a monthly rate of 0.6% (0.072 ÷ 12 = 0.006). Use the note rate, not the APR, when the APR includes fees such as origination fees.
If you only know the APR and it includes fees, you should ask the lender for the underlying annual interest rate to use in the formula. When there are no additional fees, the APR may equal the annual interest rate, but it's safer to confirm with the lender.
Worked Example for a $10,000 Loan
Let's walk through a concrete example. Suppose you borrow $10,000 at a fixed annual rate of 6% for 3 years (36 months). First, convert the annual rate to a monthly rate: 0.06 ÷ 12 = 0.005. Next, calculate the number of payments: 3 years × 12 = 36.
Now apply the formula: Payment = 10000 × [0.005(1.005)^36] / [(1.005)^36 – 1]. Using a calculator, you'll find the monthly payment is approximately $304.22. Over 36 months, you'll pay a total of $10,951.92, which means you'll pay $951.92 in interest.
- Loan amount: $10,000
- Annual rate: 6%
- Term: 3 years (36 months)
- Monthly payment: ~$304.22
- Total interest: ~$951.92
Impact of Loan Term on Payments
The term of your loan has a significant impact on your monthly payment and total interest. Use the formula or a spreadsheet to compare different terms for the same loan amount and rate. For example, a $10,000 loan at 6% annual rate would have the following approximate payments: 24 months – $443.06, 36 months – $304.22, 48 months – $234.85, and 60 months – $193.28. The total interest paid increases with longer terms.
How to Use Payment Estimates When Shopping
When shopping for a personal loan, use payment estimates to compare offers side by side. Know the APR, term, monthly payment, and any fees. Keep in mind that the lowest monthly payment may not be the cheapest loan overall – a longer term increases total interest.
Check whether the APR includes origination fees, and ask the lender for a breakdown of costs. Use the payment formula to verify the lender's quote and ensure you understand the full cost of borrowing.
Frequently asked questions
How do I calculate the total interest I'll pay?
To calculate total interest, first determine your monthly payment using the loan payment formula. Multiply the monthly payment by the number of months in the loan term to get the total amount paid. Then subtract the original loan amount (principal) from that total. The difference is the total interest you'll pay. For example, if you have a $10,000 loan at 6% annual rate for 36 months, your monthly payment is about $304.22. Multiply $304.22 by 36 to get $10,951.92, then subtract $10,000 to get approximately $951.92 in total interest.
What is a good loan term length for a personal loan?
A good loan term length depends on your financial situation and goals. Shorter terms, such as 24 to 36 months, generally mean higher monthly payments but lower total interest. Longer terms, such as 48 to 60 months, offer lower monthly payments but you'll pay more in interest over time. Consider your monthly budget and how much total cost you're willing to pay. There is no universally 'right' term – it's a trade-off between affordability and total cost.
Should I choose a shorter term even if the payment is higher?
Choosing a shorter term typically saves you money on interest, but only if you can comfortably afford the higher monthly payment. If you have stable income and can manage the payment, a shorter term may be a good choice because you'll pay off the loan faster and pay less interest overall. If the higher payment would strain your budget, a longer term might be more practical, though it will cost more in total. Use the payment formula to compare total costs and decide based on your budget and financial goals.
What is the formula for calculating personal loan payments?
The standard amortization formula for fixed-rate loans is: Payment = P × [r(1 + r)^n] / [(1 + r)^n – 1]. Here, P is the principal (loan amount), r is the monthly interest rate (annual rate divided by 12, expressed as a decimal), and n is the number of monthly payments (loan term in years multiplied by 12). For example, for a $10,000 loan at 6% annual rate for 3 years, r = 0.005, n = 36, and the formula yields a monthly payment of about $304.22.
Do personal loan payments include origination fees?
Personal loan payments themselves are calculated on the principal amount you borrow, and the origination fee is typically deducted from the loan proceeds before you receive the funds. So the monthly payment amount reflects the full principal, but the fee is an upfront cost that affects how much money you actually get. The APR is intended to reflect the true cost of the loan, including certain fees, so comparing APRs can help you account for origination fees.
How does the loan term affect my monthly payment?
The loan term directly affects your monthly payment: a longer term spreads the principal over more payments, reducing the monthly amount, while a shorter term increases it because you repay the loan faster. For example, on a $10,000 loan at 6% annual rate, the monthly payment for a 3-year term would be about $304, while a 5-year term would be about $193. However, a longer term means you pay interest for a longer period, increasing the total interest paid.
Can I calculate payments without a calculator?
Yes, you can calculate payments manually using the loan payment formula, though it involves exponentiation and is easier with a calculator or spreadsheet. To do it by hand, you'd need to compute (1 + r)^n, which can be tedious for large n. For practical purposes, most people use spreadsheet software or an online loan payment guide to get accurate results quickly. If you prefer a manual approach, you can follow this formula with a basic scientific practical guide.