Loan Calculator Formula: How to Calculate Payments

This calculator works out the monthly payment for a fixed-rate loan. You enter the loan amount, the annual interest rate, and the loan term in years, and it returns the monthly payment amount, the total interest paid, and the total cost of the loan. The formula used is the standard amortization formula, which is the same one banks and financial institutions use for mortgages, auto loans, and personal loans.

Formula

The monthly payment for a fixed-rate loan is calculated with the amortization formula:

M = P × [ r(1 + r)^N ] / [ (1 + r)^N – 1 ]

Where:

• M = monthly payment (in dollars)
• P = principal loan amount (in dollars)
• r = monthly interest rate (annual rate divided by 12, expressed as a decimal)
• N = total number of payments (loan term in years × 12)

In the calculator above, the annual rate is entered as a percentage, so it is divided by 1200 (12 months × 100) to convert it to a monthly decimal. The exponent ^ -N is the negative power, which accounts for the time value of money.

Worked Example

Using the default values: loan amount = $20,000, annual interest rate = 5%, term = 5 years.

1. Convert annual rate to monthly: r = 5 / 1200 = 0.0041667
2. Total payments: N = 5 × 12 = 60
3. Compute (1 + r)^N = (1.0041667)^60 ≈ 1.28336
4. Plug into formula: M = 20000 × [0.0041667 × 1.28336] / [1.28336 – 1]
5. Numerator: 20000 × 0.0053473 = 106.946
6. Denominator: 0.28336
7. M = 106.946 / 0.28336 ≈ 377.42

The calculator shows a monthly payment of $377.42. Over 60 months, total paid = $22,645.20, and total interest = $2,645.20.

How to Read the Result

The monthly payment is the fixed amount you pay each month for the entire term. The total paid includes both principal and interest. The total interest is what the loan costs you on top of the amount borrowed. A lower monthly payment often means a longer term, which usually results in more total interest. Conversely, a higher monthly payment shortens the term and reduces total interest.

This formula assumes a fixed interest rate and equal monthly payments. It does not include property taxes, insurance, fees, or other charges that might be part of a real loan. Those are separate costs.

Common Mistakes and Misconceptions

• Using the annual rate directly: The formula requires the monthly rate. Dividing the annual percentage by 12 is essential.
• Not converting percentage to decimal: A 5% rate must be entered as 0.05 in the formula, not 5. The calculator handles this conversion automatically.
• Mixing up term and payments: The term is in years, but the number of payments is months. Multiply years by 12.
• Rounding too early: Rounding the monthly rate to 0.004 instead of 0.0041667 can change the result by a few dollars over a long term.
• Assuming the formula includes fees: This is the pure payment formula. Actual loans may have origination fees, closing costs, or prepayment penalties.

When to Use This Formula

Use this formula for any fixed-rate, fully amortizing loan where you pay the same amount each month and the balance goes to zero at the end of the term. Common examples include:

• Auto loans (typically 3-7 years)
• Personal loans (1-5 years)
• Fixed-rate mortgages (15 or 30 years)
• Student loan refinancing (fixed rate)

It does not apply to adjustable-rate loans, interest-only loans, or loans with balloon payments. For those, the payment changes or the balance is not fully paid off by the end.

Limitations of the Formula

The formula gives the exact payment for a simple amortizing loan. Real-world loans may have:

• Fees and points: These increase the effective cost but are not part of the payment calculation.
• Payment frequency: Some loans are bi-weekly, which changes the number of payments per year and the interest calculation.
• Extra payments: Paying extra reduces the principal faster and shortens the term, which the basic formula does not account for.
• Compounding differences: Some loans compound daily or monthly, which can slightly alter the payment.

For most consumer loans, this formula is accurate to within a few cents. Always check with your lender for the exact payment schedule.

Frequently Asked Questions

How do I calculate the monthly payment on a loan?

Use the formula M = P × [ r(1 + r)^N ] / [ (1 + r)^N – 1 ], where P is the principal, r is the monthly interest rate (annual rate / 12), and N is the number of monthly payments. You can also use the calculator above by entering the loan amount, rate, and term.

What is a good interest rate for a personal loan?

Interest rates vary widely based on credit score, income, and market conditions. As of recent years, personal loan rates might range from about 6% to 36%. The rate you qualify for depends on your creditworthiness. The formula above works for any rate.

How does the loan term affect my monthly payment?

A longer term spreads the principal over more payments, lowering the monthly payment but increasing total interest. A shorter term has higher monthly payments but less total interest. For example, a $20,000 loan at 5% for 3 years has a payment of about $599, while the same loan for 5 years has a payment of $377.

Can I use this formula for a mortgage?

Yes, for a fixed-rate mortgage, the formula gives the principal and interest payment. However, your actual monthly payment may include property taxes, homeowners insurance, and PMI, which are not part of this calculation.

What is the difference between APR and interest rate?

The interest rate is the cost of borrowing the principal, while the APR includes the interest rate plus certain fees and costs, expressed as a yearly rate. The APR is usually higher than the interest rate. Use the interest rate in the formula to get the payment; the APR is for comparing loan offers.

How do extra payments affect the loan?

Extra payments reduce the principal balance faster, which means less interest accrues and the loan is paid off earlier. The exact effect depends on the amount and timing of the extra payments. Many lenders allow extra payments without penalty, but check your loan agreement.

Related

• Chemical Formula Calculator: How to Use It
• Barrett Formula Calculator: How It Works
• Time Converter Swimming: Pace & Speed Explained

in p | Loan amount | $ | 20000 | 0
in r | Annual interest rate | % | 5 | 0
in n | Loan term | years | 5 | 1
out monthly | Monthly payment | $ | p * (r/1200) / (1 - (1 + r/1200)^(-n*12)) | 2
out total | Total paid | $ | monthly * n * 12 | 2
out interest | Total interest | $ | monthly * n * 12 - p | 2