American Amortization Table Calculator and Guide

An American amortization table shows how each fixed loan payment is divided between interest and principal, and how the balance falls over time. Enter a loan amount, annual APR, and term to calculate the monthly payment and total interest; the figures use a standard fixed-rate, monthly-payment formula.

Formula

The calculator uses the standard level-payment amortization formula for a loan with a fixed annual percentage rate and monthly payments. It rounds the monthly payment to the nearest cent, then calculates total interest using that rounded payment.

• Monthly payment: M = round(P × r ÷ [1 − (1 + r)⁻ⁿ], 2)
• Total interest: I = M × n − P
• Monthly rate: r = APR ÷ 1200
• Number of payments: n = loan term in years × 12

P is the original loan principal in dollars, APR is the annual percentage rate entered as a percent, r is the monthly rate as a decimal, n is the total number of monthly payments, M is the monthly payment in dollars, and I is the estimated total interest in dollars. For example, an APR of 8% becomes a monthly rate of 0.08 ÷ 12, or about 0.006667.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term—there are 5 × 12 = 60 monthly payments. The monthly rate is 8 ÷ 1200 = 0.0066667.

1. Substitute the values: M = round(20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰], 2).
2. The unrounded payment is about $405.53, so the monthly payment rounded to cents is $405.53.
3. Total interest is $405.53 × 60 − $20,000 = $4,331.80.

These are scheduled-payment estimates. A lender’s payment schedule may differ if it uses different payment dates, rounding conventions, or loan terms.

What an American Amortization Table Shows

“American amortization” generally refers to the common level-payment method used in many U.S.-style loan examples: the borrower makes a scheduled payment of the same amount each period, while the portions allocated to interest and principal change. The phrase is not a guarantee that a particular loan follows this exact schedule; loan documents define the actual method and terms.

At the start, the outstanding principal is larger, so more of a payment goes toward interest. As principal is repaid, the interest due for a period generally falls and more of the same payment reduces principal. The table’s remaining balance approaches zero over the agreed term, subject to payment timing and rounding.

A full table typically has one row for each payment period, with columns such as:

• Payment number or due date
• Beginning balance
• Scheduled payment
• Interest charged for the period
• Principal repaid
• Ending balance

How to Read a Payment Row

For a basic monthly schedule, period interest is approximately the beginning balance multiplied by the monthly rate. Principal repaid is the payment minus that period’s interest, and the ending balance is the beginning balance minus principal repaid. In later periods, the interest amount is usually lower because the balance has fallen.

For the default example, the first month’s interest is approximately $20,000 × (0.08 ÷ 12), or $133.33. From the $405.53 payment, about $272.20 goes to principal, leaving an estimated balance of $19,727.80. A detailed lender schedule may show a one-cent difference due to the order in which it rounds calculations.

The calculator reports the payment and lifetime interest, not every row of the schedule. To build a period-by-period table, apply the same interest-and-principal steps to each month and carry the ending balance forward as the next month’s beginning balance.

When to Use It and What It Leaves Out

An amortization table helps explain how a fixed-payment loan is expected to be repaid. It can help a reader inspect the effect of the amount borrowed, APR, and term on the payment and total interest. It can also clarify why making payments does not reduce principal by the full payment amount, especially early in the schedule.

The calculator assumes the APR and payment amount remain unchanged throughout the term. It does not model variable rates, irregular payment dates, skipped or late payments, extra principal payments, balloon payments, or a payoff before the end of the term. It also excludes fees and any taxes, insurance, escrow, or other charges that might appear in a real payment. Enter the lender’s applicable rate and loan figures rather than treating the default as a market quote.

Common Misunderstandings and Calculation Limits

• Interest is not a fixed share of every payment. The payment can stay level while the interest and principal portions change from month to month.
• Total interest is not the monthly payment multiplied by the term alone. That multiplication gives total scheduled payments; subtracting the original principal gives interest in this simplified model.
• APR and monthly rate are different units. The formula converts an annual percentage APR to a monthly decimal rate by dividing by 1200. Entering 0.08 instead of 8 would mean 0.08% APR, not 8%.
• Rounding affects displayed totals. This calculator rounds the payment to cents and uses that rounded figure for total interest. A lender may calculate interest daily or use a different rounding convention, so exact statements can vary.

The formula is for a fully amortizing loan with equal monthly payments and a positive fixed APR. It is a mathematical estimate, not a complete payoff quote or a substitute for the loan’s disclosed payment schedule.

Frequently Asked Questions

What is an American amortization table?
An American amortization table is a schedule showing how each periodic payment is split between interest and principal, along with the balance remaining after payment. The term commonly describes a level-payment approach, but the loan agreement determines the actual calculation.

How do I calculate the monthly payment?
Convert APR to a monthly decimal rate by dividing by 1200, multiply the principal by that rate, and divide by one minus the factor (1 + monthly rate) raised to the negative number of monthly payments. Round the result to cents.

Why does the principal fall slowly at first?
Interest for each period is calculated on the outstanding balance. Since the balance is largest at the beginning, the interest portion is also relatively large, leaving less of a level payment to reduce principal.

Does total interest include fees or insurance?
No. The calculation estimates interest from the principal, APR, term, and rounded scheduled payment. It does not include fees, insurance, taxes, escrow, or other charges unless separately modelled.

Will my lender’s amortization table match this result exactly?
Not necessarily. Payment dates, daily versus monthly interest calculations, rounding rules, fees, and contract-specific terms can change the schedule. Use the lender’s disclosure for the exact figures.

Assumptions

• The interest rate is fixed for the full loan term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, PMI, and escrow are not included.

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

Related

• Qualifying Business Income: What It Means for Taxes
• Qualified Income vs Nonqualified Income Explained
• Qualified Income Trust in NJ: Medicaid Explained

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