Loan Amortization Calculator

TL;DR: To calculate a loan amortization schedule, divide your annual interest rate by 12 to get the monthly rate, multiply the loan term in years by 12 to get the total number of payments, and then apply the formula M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is the monthly payment, P is the principal, r is the monthly rate, and n is the number of months.

What Is the Loan Amortization Calculator?

A loan amortization calculator is a financial tool that determines exactly how much you will pay each month toward a loan and breaks down each payment into its interest and principal components. The output is a complete schedule showing the gradual reduction of your outstanding balance over the life of the loan. This is not just a simple interest calculation — it uses a complex formula that accounts for the fact that you pay interest on a declining principal balance.

This calculator is essential for anyone taking out a fixed-rate mortgage, an auto loan, a student loan, or a personal loan. Real estate investors use it to forecast cash flow, financial advisors use it to plan debt payoff strategies, and individual borrowers use it to compare loan offers from different lenders. The primary value is transparency: seeing the full amortization schedule allows you to understand exactly how much of each payment goes to interest versus principal, and how much total interest you will pay over the entire term. Without this tool, most borrowers underestimate the true cost of borrowing because they only focus on the monthly payment amount.

How to Use the Calculator

Using the loan amortization calculator is straightforward, but accuracy is critical. Follow these steps in order to get a reliable schedule:

1. Enter the Loan Amount (Principal): This is the total amount you are borrowing. For a mortgage, this would be the purchase price minus your down payment. For example, if a home costs $300,000 and you put down $50,000, enter $250,000.
2. Enter the Annual Interest Rate: Input the nominal annual interest rate as a percentage — for example, 4.5 for a 4.5% APR. Do not enter a decimal (0.045 is incorrect). The calculator will convert this to a monthly rate by dividing by 12.
3. Enter the Loan Term (Years): This is the length of time over which you will repay the loan, expressed in years. Common terms are 15, 20, or 30 years for mortgages, and 3 to 7 years for auto loans.
4. Select the Start Date (optional): If the calculator offers a start date field, choose the month and year of your first payment. This will affect the interest accrual for the first partial period.
5. Click Calculate: The calculator will instantly generate your monthly payment amount, total interest, total cost, and a full amortization table showing each monthly payment.
6. Review the Output Table: Examine the breakdown for the first few months. Notice that the interest portion is highest in the first month and decreases over time, while the principal portion increases.

After you perform the calculation, review the summary figures carefully. The monthly payment is your fixed obligation for the entire term, assuming a fixed interest rate. The total interest figure is the sum of all interest paid over the life of the loan — this number is often significantly higher than borrowers expect.

Formula and Calculation Method

The loan amortization calculator relies on a standard mathematical formula used by all financial institutions. In plain language, the formula calculates a fixed monthly payment that, when applied consistently over the loan term, fully amortizes the loan — meaning it pays off both the principal and all accrued interest by the final payment date.

The formula is: M = P × [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]

• M = Monthly payment
• P = Principal loan amount (the amount you borrowed)
• r = Monthly interest rate (annual rate divided by 12)
• n = Total number of payments (loan term in years multiplied by 12)

Let us walk through the exact calculation process using a concrete example: a $250,000 loan at an annual interest rate of 4.5% for 30 years.

Step 1: Convert the annual rate to a monthly rate. Divide the annual percentage rate by 12. Calculation: 4.5% ÷ 12 = 0.375% per month. Expressed as a decimal for the formula: 0.00375.

Step 2: Determine the total number of payments. Multiply the number of years by 12 months. Calculation: 30 years × 12 = 360 monthly payments.

Step 3: Apply the mortgage formula. Plug the values into the formula: M = $250,000 × [0.00375(1.00375)^360] ÷ [(1.00375)^360 – 1].

Step 4: Solve the equation. First, calculate (1.00375)^360, which equals approximately 3.8477. Then, the formula becomes M = $250,000 × [0.00375 × 3.8477] ÷ [3.8477 – 1]. This simplifies to M = $250,000 × [0.014429] ÷ [2.8477]. The result is M = $250,000 × 0.0050665, which gives a monthly payment of $1,266.71.

Step 5: Calculate total interest. Multiply the monthly payment by the total number of payments, then subtract the principal. Calculation: ($1,266.71 × 360) – $250,000 = $456,015.60 – $250,000 = $206,015.60 in total interest.

Practical Examples

To illustrate the calculator's versatility, here are three realistic scenarios with different input values and what the results mean in practice.

Scenario 1: Traditional 30-Year Mortgage

You borrow $300,000 with a 6.5% annual interest rate over 30 years. Using the formula, your monthly payment is $1,896.20. Over 360 payments, you will pay a total of $682,632. The total interest paid is $382,632. This scenario is typical for homebuyers with moderate credit. Note that the total interest exceeds the original principal — a common surprise for first-time homebuyers.

Scenario 2: Shorter Term — 15-Year Mortgage

You borrow the same $300,000 but choose a 15-year term with a lower 5.75% rate. Your monthly payment jumps to $2,491.59. However, the total interest decreases dramatically to $148,486.20. This example demonstrates the trade-off between lower monthly payments and total interest cost. The 15-year loan saves over $234,000 in interest compared to the 30-year example.

Scenario 3: Auto Loan

You finance a $35,000 car for 5 years (60 months) at a 7.2% annual rate. Your monthly payment is $696.86. The total interest is $6,811.60. This shows that even relatively small principal amounts accrue meaningful interest over shorter terms.

In all these scenarios, the monthly payment is your fixed obligation. The total interest figure is the cost of borrowing that you pay over the loan life.

Tips for Accurate Results

To get the most accurate amortization schedule, pay attention to these critical factors that are commonly overlooked:

• Use the Annual Rate, Not the APR: The Annual Percentage Rate (APR) includes fees and closing costs, which inflate the true borrowing cost. The standard amortization formula requires the nominal interest rate. Entering the APR instead of the rate will produce an incorrect monthly payment that is slightly too high.
• Do Not Confuse the Monthly Rate: Always divide the annual rate by 12. Entering 4.5 instead of 0.375 as the monthly rate — or inputting the rate as a decimal (0.045) instead of a percentage (4.5) — will drastically skew your results. A 4.5% annual rate is 0.00375 as a monthly decimal.
• Account for Property Taxes and Insurance: The calculator only computes principal and interest. Your actual mortgage payment will likely include property taxes, homeowners insurance, and possibly PMI (private mortgage insurance). These can add hundreds of dollars to your monthly cost. Adjust your budget accordingly.
• Round Up for Escrow: If the monthly payment is $1,266.71, your lender may round the payment to $1,267 or require an escrow cushion. This small difference affects the amortization schedule slightly.
• Consider Extra Principal Payments: The standard schedule assumes you make only the minimum payment. If you pay an extra $100 per month toward principal, you will shorten the loan term and save thousands in interest. Use the calculator to model this scenario by manually reducing the principal balance.
• Verify Your Start Date: If the calculator includes a start date field, the first payment's interest calculation may differ from subsequent months. For a loan closing mid-month, interest accrues from the closing date to the first payment date, which usually results in a slightly higher first payment.

Frequently Asked Questions

Q: How does making extra principal payments affect my amortization schedule?

Making extra principal payments accelerates the reduction of your outstanding balance, which in turn reduces the total interest you pay over the life of the loan. Here is how it works: When you make an extra payment of $100 toward principal in month 1, your new balance drops by $100. In month 2, the interest is calculated on this lower balance, saving you the interest on that $100 for the remaining 359 months. For a $250,000 mortgage at 4.5% over 30 years, paying an extra $100 per month reduces the loan term from 360 months to about 310 months (approximately 25.8 years). More importantly, it reduces total interest from $206,015.60 to approximately $157,000, saving you nearly $49,000. The amortization schedule reflects this change — the interest portion of each payment decreases faster, and the principal portion increases correspondingly.

Q: What is the difference between amortization and simple interest?

Amortization uses a declining balance method, meaning interest is charged only on the remaining principal balance. In contrast, simple interest calculates interest on the original principal for the entire term. For example, on a $10,000 loan at 5% for 5 years with simple interest, you would pay $10,000 × 0.05 × 5 = $2,500 in interest, regardless of any principal payments made during the term. With amortization, the interest is recalculated monthly on the remaining balance. In the first month, interest is $10,000 × 0.004167 = $41.67. After you pay off $150 in principal, the second month's interest is calculated on $9,850, resulting in interest of $41.04. Over the full term, the total interest on the amortized loan is approximately $1,323, significantly less than the $2,500 under simple interest. All standard mortgages and auto loans use amortization.

Q: Should I refinance based on the amortization schedule?

Refinancing should be a data-driven decision based on your amortization schedule's "break-even point." First, calculate your current remaining balance and remaining term. Then, model a new loan with the proposed rate and term. Consider the closing costs, which typically range from 2% to 5% of the loan amount. The break-even point is determined by dividing your total closing costs by your monthly savings. For example, if refinancing saves $200 per month and closing costs are $4,000, your break-even point is 20 months. If you plan to stay in the home longer than 20 months, the refinance is financially beneficial. However, be cautious about extending your loan term. If you are 10 years into a 30-year mortgage and refinance to a new 30-year loan, you may reset the amortization clock, adding years of interest charges. The calculator will show this clearly: compare the total interest on your current schedule versus the new schedule to make an informed decision.