Amortization Schedule Calculator and Loan Payment Breakdown

An amortization schedule shows how each regular loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term to calculate an estimated monthly payment and total interest; the schedule concepts below explain how to interpret each period.

Formula

This calculator uses the standard fixed-rate, fully amortizing loan payment formula. It calculates a level monthly payment intended to repay the starting principal and all interest over the stated number of months:

Monthly payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the original loan principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year, so dividing by 100 converts it to a decimal and dividing by 12 gives the monthly rate.
• n is the total number of monthly payments, calculated as loan term in years × 12.

The displayed payment is rounded to cents. Total interest is estimated as the rounded monthly payment × number of payments − principal. Because it uses the rounded payment, the total is an estimate; a real final payment may be adjusted to settle the remaining balance.

Worked Example

Using the calculator’s default inputs: a $20,000 loan, an 8% annual APR, and a five-year term.

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Convert the term to payments: 5 × 12 = 60 monthly payments.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = about $405.53 per month.
4. Estimate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The calculator therefore returns a monthly payment of $405.53 and estimated total interest of $4,331.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are made monthly, at the end of each monthly period.
• Interest is modeled monthly at APR ÷ 12, with APR entered as a yearly percentage.
• Fees, taxes, insurance, mortgage insurance, escrow, late charges, and extra payments are not included.

How an Amortization Schedule Works

An amortization schedule is a period-by-period table showing the payment, interest charged, principal repaid, and remaining balance. For a standard fixed-rate loan, the payment generally stays level, but its two components change. Interest for a period is calculated on the balance at the start of that period. The principal portion is the payment minus that period’s interest.

For example, with the default figures, the first month’s interest is approximately $20,000 × 0.0066667 = $133.33. Subtracting that from the $405.53 payment leaves about $272.20 to reduce principal. The next month’s interest is calculated on the lower balance, so it is slightly less; consequently, a little more of the same payment goes to principal. This gradual shift is the central feature of amortization.

A schedule may show small differences of a few cents from this illustration. Lenders can calculate daily interest, use different payment dates, or adjust the final payment to account for exact rounding and accrued interest.

How to Read the Results

• Monthly payment: The modeled regular payment for principal and interest. It is not necessarily the full amount due on a mortgage or other loan when separate charges apply.
• Total interest: The estimated interest paid over all scheduled payments, assuming the loan follows the inputs and is paid as modeled.
• Principal balance: The amount still owed after a given payment. A full schedule lists this balance for every period; this calculator gives the payment and total interest rather than printing every row.

To build an individual row, multiply the opening balance by the monthly rate to find interest; subtract that interest from the payment to find principal repaid; then subtract principal repaid from the opening balance. Repeat for the next period. The final balance should approach zero, subject to rounding and the lender’s actual calculation method.

When to Use It and Important Limits

An amortization schedule is useful for understanding the timing of principal repayment, estimating total interest under stated assumptions, or checking how a change in loan amount or term affects the mathematical payment. It is also a way to see why the amount of principal repaid early in a level-payment loan can be smaller than later in the term.

The result is not a quote or a complete loan-cost disclosure. Enter the APR and term shown in the lender’s documents for a closer estimate, and check how that lender handles payment dates, compounding, fees, and rounding. The calculator cannot account for a variable rate, skipped or irregular payments, a balloon payment, a changing payment, or extra principal unless those details are modeled separately.

Common Mistakes and Misconceptions

• Confusing APR with a monthly rate: Enter the quoted annual percentage as a percent, such as 8—not 0.08 and not 8% as a monthly rate. The formula converts it to a monthly decimal rate.
• Treating the payment as the total bill: A payment estimate here covers modeled principal and interest only. Other charges may be billed separately or included in a lender’s payment figure.
• Assuming equal principal portions: In a level-payment schedule, the payment is generally level, but the principal and interest portions vary each month.
• Expecting a quoted total to match exactly: Rounding each payment to cents, daily-interest methods, payment timing, and a final-payment adjustment can change the actual total.

Frequently Asked Questions

What is an amortization schedule?
An amortization schedule is a table that tracks each scheduled payment’s interest and principal portions and the loan balance remaining afterward.

How do I calculate the interest part of a payment?
For this monthly model, multiply the balance at the start of the period by APR ÷ 1,200. The rest of the regular payment is applied to principal.

Why does the principal portion increase over time?
As principal is repaid, the balance used to calculate interest falls. With a level payment, less goes to interest and more goes to principal in later periods.

Does this calculator generate every schedule row?
No. It estimates the monthly payment and total interest. You can calculate rows using the opening balance, monthly rate, and payment, but a lender’s complete schedule may differ because of its exact timing and rounding conventions.

Does extra payment reduce total interest?
When an extra amount is applied to principal and the loan is recalculated on that basis, a lower balance can reduce later interest. The effect depends on the contract and payment handling, neither of which this calculator models.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Market Interest Rate: Meaning and How It Works
• Savings Interest Calculator: Estimate Your Earnings
• MA Interest Rates: Estimate a Loan Payment

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2