Debt Amortization Schedule Calculator and Guide

A debt 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 interest rate, and term to calculate an estimated monthly payment and total interest; this calculator summarizes the loan rather than listing every payment date.

Formula

For a fixed-rate loan repaid with equal monthly payments, the payment is calculated using the standard amortizing-loan formula:

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

• M is the monthly payment in dollars, rounded to the nearest cent.
• P is the starting loan principal in dollars.
• r is the monthly interest rate, calculated as the annual percentage rate (APR) divided by 1,200. The APR input is a percentage, so an 8% APR gives r = 8 ÷ 1,200.
• n is the number of monthly payments, calculated as the term in years multiplied by 12.

Total interest in this calculator is I = M × n − P. It uses the rounded monthly payment shown above, so the estimate reflects payments rounded to cents. This assumes every scheduled payment is made and does not add fees or other loan charges.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—the monthly rate is 8 ÷ 1,200 = 0.0066667, and the number of payments is 5 × 12 = 60.

Substitute those figures into the payment formula:

M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53

The total of 60 payments at the rounded amount is 60 × $405.53 = $24,331.80. Estimated interest is $24,331.80 − $20,000 = $4,331.80. A lender’s final payment schedule can differ because of payment dates, rounding conventions, fees, or other contract terms.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and paid at the end of each monthly period.
• Interest compounds monthly using APR divided by 12.
• The calculation excludes fees, taxes, insurance, PMI, and escrow because they are not inputs.

How a Debt Amortization Schedule Works

A full schedule is a table with one row for each payment period. For each row, interest is generally calculated on the balance at the start of the period. The payment first covers that interest; whatever remains reduces principal. The new balance becomes the starting balance for the next period.

For example, at the beginning of the default example, monthly interest on $20,000 at 8% APR is about $133.33. Of the $405.53 payment, about $272.20 therefore goes toward principal, leaving a balance near $19,727.80. The next month’s interest is calculated on that lower balance, so a slightly larger portion of an unchanged payment can go toward principal. Small differences may appear when a schedule rounds interest and balances row by row.

This pattern explains why early payments on a standard amortizing loan usually contain a larger interest share, while later payments contain a larger principal share. It does not mean the lender charges interest on the original principal forever: the interest amount changes as the balance is paid down.

What the Results Tell You

The monthly payment is the modeled amount needed to repay the principal and interest over the stated term under the assumptions above. Total interest is the modeled sum of those payments minus the initial principal. Neither figure, by itself, is a complete statement of the cost of borrowing if the agreement includes charges outside the calculation.

The calculator provides a useful overview for comparing different input scenarios consistently. For a schedule with payment-by-payment dates and balances, use the loan’s disclosed schedule or calculate each period separately. The final installment may be adjusted by a lender to account for accumulated rounding or timing differences.

Common Questions and Calculation Limits

A common misconception is that the monthly payment is divided equally between principal and interest. It is the total payment that is usually level in this model; the split changes each month. Another important distinction is APR versus the periodic rate: the formula converts an annual percentage entered as a percent into a monthly decimal by dividing by 1,200.

• Variable rates: If the rate changes, a single fixed-rate calculation cannot represent the whole repayment period.
• Irregular timing: Daily interest, a first payment due on an unusual date, or missed payments can change accrued interest and balances.
• Extra payments: Additional principal payments can shorten repayment or change interest, but their effect depends on timing and how the loan applies them. They are not included here.
• Rounding: This calculator rounds the monthly payment to cents before estimating total interest. A lender may round each interest entry or adjust the final payment differently.

Use the APR, starting balance, and term stated in the loan documents when making an estimate. If the rate, payment frequency, or repayment rules do not match the model, the result will not reproduce the lender’s schedule.

Frequently Asked Questions

What is a debt amortization schedule?
A table showing each scheduled payment, its interest and principal portions, and the remaining balance over the repayment term.

How do I calculate the monthly payment?
Convert APR to a monthly rate by dividing the percentage by 1,200, convert years to months, then apply the fixed-payment formula shown above.

Why does the interest portion decrease over time?
With a fixed rate, each period’s interest is based on the outstanding balance. As principal is repaid, that balance falls, so the interest portion generally falls too.

Does this calculator include fees or insurance?
No. It models principal and interest only. Check the lender’s disclosures for any other amounts that affect payments or total borrowing cost.

Can I use it for a variable-rate loan?
Only as a snapshot under the entered rate. If the rate changes, later payments and the payoff schedule may change as well.

This result is an estimate; 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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2