Payment Amortization Table Calculator and Guide

A payment amortization table shows how each scheduled 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 the fixed monthly payment and total interest; the table itself can then be built by applying each payment to the running balance.

Formula

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

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

• P is the starting principal, or loan amount, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 12 ÷ 100.
• n is the total number of monthly payments: loan term in years × 12.

Total interest in this calculator is monthly payment × number of payments − starting principal. Because payments are rounded to cents, the displayed total uses that rounded payment. A lender may adjust the final payment to clear a small remaining balance caused by rounding.

Worked Example

Using the calculator defaults: a $20,000 loan, 8% APR, and a five-year term.

1. Convert the APR to a monthly decimal rate: 8 ÷ 1200 = 0.0066667.
2. Calculate the number of payments: 5 × 12 = 60.
3. Substitute into the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The monthly payment, rounded to cents, is $405.53.
5. Total interest using the rounded payment is $405.53 × 60 − $20,000 = $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 modelled monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, and escrow are not included.

How a Payment Amortization Table Works

The calculator gives the fixed payment and overall interest estimate. An amortization table expands that result into one row per payment, often showing the payment number or date, opening balance, payment, interest charge, principal repaid, and closing balance.

For each period, interest is computed on the balance at the start of that period. The principal portion is the payment minus that period’s interest. Subtracting the principal portion from the opening balance produces the closing balance, which becomes the next period’s opening balance.

• Interest for a month = opening balance × monthly rate.
• Principal paid = scheduled payment − interest for the month.
• Closing balance = opening balance − principal paid.

In the example, the first month’s interest is about $133.33 ($20,000 × 0.0066667). Of the $405.53 payment, about $272.20 reduces principal, leaving a balance near $19,727.80. Later interest charges generally shrink as the balance declines, so more of each level payment goes to principal. The exact cents in a lender’s schedule can differ because of its day-count method, payment dates, and rounding.

How to Read and Use the Results

The monthly payment is the scheduled principal-and-interest amount under the stated assumptions, not necessarily the whole amount due on a bill. A mortgage payment, for example, may also involve escrowed items; other loans may have fees or different payment arrangements. Check the loan documents or lender disclosure for the actual amount and schedule.

Total interest is the sum of the interest portions across the modeled term. It is not the total paid: total scheduled payments equal principal plus interest in this simplified calculation. To understand the timing, review an amortization schedule and compare its early, middle, and final rows rather than relying only on the total.

This calculation is useful for estimating a standard fixed-rate loan payment, checking the effect of a different term or APR, and understanding how a balance declines. It is not a complete loan quote. Enter the contractual APR and term supplied by the lender; the defaults are illustrative inputs, not a claim about available loan terms.

Common Mistakes and Limits

• Using the wrong rate format: Enter APR as a yearly percentage, such as 8 for 8%, not 0.08 or a monthly rate. The calculator converts it to a monthly decimal internally.
• Mixing years and months: The term input is in years. A five-year term means 60 monthly payments.
• Treating payment as total borrowing cost: The payment shown excludes items the calculator does not model, and total interest is separate from principal.
• Assuming every loan amortizes this way: Variable rates, interest-only periods, balloon payments, irregular payment dates, and fees financed into the balance require different calculations.
• Expecting every schedule to match to the cent: Payment rounding and lender-specific interest accrual can create small differences, particularly in the last payment.

Extra payments are not included. When extra principal is applied, it can change the payoff timeline and interest total; the result depends on when the extra amount is credited and how the loan servicer applies it. A separate schedule needs those payment amounts and timing assumptions.

Frequently Asked Questions

What is a payment amortization table?
A payment amortization table is a period-by-period record of a loan’s payments, interest, principal reduction, and remaining balance.

How do I calculate the interest portion of a payment?
Multiply the balance at the start of the period by the interest rate for that period. For this monthly model, the periodic rate is APR divided by 1200.

Why does the principal portion increase over time?
With a fixed payment and fixed rate, the balance generally falls. Interest is therefore charged on a smaller amount, leaving more of each payment to reduce principal.

Does the monthly payment include taxes and insurance?
No. This calculator estimates principal and interest only; taxes, insurance, PMI, escrow, and fees are not included.

Can I use this for a variable-rate or interest-only loan?
Not as a full schedule. The formula assumes a fixed rate and equal monthly payments that repay principal and interest over the stated term.

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

Related

• Balloon Payment Amortization Schedule Calculator
• Auto Loan Extra Payment Amortization Calculator
• Annual Payment Amortization Calculator and Formula

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