Amortization Table Calculator and Payment Schedule

Generate an amortization table by entering a loan amount, annual interest rate, and term; this calculator estimates the fixed monthly payment and total interest. The schedule itself can be built month by month from those figures, showing how each payment is divided between interest and principal and what balance remains.

Formula

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

Payment = round(P × r / [1 − (1 + r)⁻ⁿ], 2)

• P is the starting loan principal, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 1200.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the monthly amount, rounded to the nearest cent.

The calculator’s total-interest estimate is monthly payment × number of payments − principal. A full table uses a repeated calculation for each period: interest for the month equals the opening balance × r; principal repaid equals the payment − interest; closing balance equals the opening balance − principal repaid. The next month begins with that closing balance.

Worked Example

Using the calculator’s default inputs: principal P = $20,000, APR = 8%, and term = 5 years.

1. Convert the APR to a monthly decimal rate: r = 8 ÷ 1200 = 0.0066666667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066666667 ÷ [1 − (1.0066666667)⁻⁶⁰] = $405.527….
4. Round the monthly payment to cents: $405.53.
5. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The first schedule row starts with a $20,000 balance. Interest is $20,000 × 0.0066666667, or $133.33 when rounded to cents. Of the $405.53 payment, $272.20 therefore reduces principal, leaving an estimated balance of $19,727.80. Later payments generally devote more to principal because the balance, and therefore monthly interest, declines.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, made monthly, and treated as occurring at the end of each monthly period.
• Interest is calculated monthly using APR ÷ 12, expressed as a decimal rate.
• Fees, taxes, insurance, mortgage insurance, escrow, and other charges are not included.
• The final payment is not separately adjusted to account for lender-specific rounding or payment dates.

How to Read an Amortization Table

A typical amortization table has one row per payment and columns for the payment number or date, opening balance, scheduled payment, interest, principal, and closing balance. The opening balance in each row should match the preceding row’s closing balance. Over time, the interest portion usually falls and the principal portion rises, as long as payments and the rate remain unchanged.

For example, a table can help explain why paying the same amount every month does not mean the same amount of principal is repaid each month. Interest is based on the unpaid balance. Early in repayment, that balance is larger; after principal has been paid down, less interest accrues for a monthly period.

Rounding can cause a small difference between a hand-built table and a lender’s statement. If interest is rounded to cents in every row, small rounding differences accumulate. A lender may also adjust the final payment, use specific day-count conventions, or include charges outside principal and interest. Treat a calculator schedule as an estimate, not a transaction record.

When to Use the Schedule

An amortization table is useful for understanding the planned path of a fixed-payment loan. It can show the approximate remaining balance at a particular payment number and how much of the scheduled payments is allocated to interest over the modeled term. The calculator summarizes the regular payment and total interest; a spreadsheet or loan statement can lay out each monthly row.

To create a basic schedule, start with the loan’s actual principal, rate, and repayment term from the lender’s disclosure. Then repeat these steps for each month:

1. Multiply the opening balance by the monthly rate to estimate interest.
2. Subtract that interest from the scheduled payment to find principal repaid.
3. Subtract principal repaid from the opening balance to get the closing balance.
4. Use the closing balance as the next month’s opening balance.

Use unrounded values during intermediate calculations if the spreadsheet permits, and round displayed currency amounts to cents. If reproducing a lender’s official schedule, follow its stated rounding and payment conventions.

Limits and Common Mistakes

• Entering a monthly rate as an APR: The APR input is annual. The formula divides it by 12 and by 100 to get a monthly decimal rate.
• Confusing payment with total borrowing cost: The calculated payment covers modeled principal and interest only. It does not automatically include taxes, insurance, fees, or other amounts due.
• Assuming every loan is fixed-rate: A changing rate or payment means the future rows cannot be determined from one constant rate and one fixed payment.
• Ignoring extra payments: Additional principal payments can change the payoff date and future interest. This calculator assumes only the regular payment; an extra-payment schedule needs those amounts and their timing.
• Treating APR as a complete schedule specification: The stated rate, compounding convention, dates, and lender calculations can affect the actual figures. Use the lender’s documents for exact amounts.

The formula is for a fully amortizing loan with a positive fixed rate and equal monthly payments. It does not model interest-only periods, balloon payments, skipped payments, variable rates, payment holidays, or fees financed into the loan unless those are already reflected in the principal and the payment structure matches the assumptions.

Frequently Asked Questions

Can I generate a full amortization table with this calculator?
The calculator gives the monthly payment and estimated total interest. To display every monthly row, apply the interest, principal, and balance steps above in a spreadsheet or use a schedule tool that accepts the same inputs.

Why does the principal portion increase over time?
With a fixed rate and payment, interest is calculated on the remaining balance. As the balance declines, less of each later payment goes to interest, leaving more to reduce principal.

Does the payment include taxes and insurance?
No. This calculation estimates principal and interest only. Taxes, insurance, escrow, fees, and similar charges are not inputs and are not included.

Can the table show the balance after a particular month?
Yes. A row-by-row schedule identifies the estimated closing balance after each payment. For exact payoff or statement figures, use the lender’s records because dates, rounding, and charges may differ.

What happens if I make extra payments?
Extra payments can reduce principal faster and change later interest and the payoff date. The results depend on amount, timing, and how the lender applies the payment, none of which this fixed-payment estimate models.

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

Related

• Amortization Table Google Sheets: Formula and Example
• Amortization Table in INR: Calculate Your EMI
• Vehicle Loan Amortization Table Calculator

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