Amortization Table Calculator and Accounting Explained

An amortization table shows how each scheduled loan payment is divided between interest and principal, and how the balance changes over time. Enter a loan amount, annual APR, and term to calculate the monthly payment and total interest; the table itself can then be built from those figures.

Formula

The level monthly payment is calculated as:

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

• P is the original principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as loan term in years × 12.

The table’s interest for a month is the opening balance multiplied by r. Principal paid is the payment minus that month’s interest. The closing balance is the opening balance minus principal paid. Total interest over the full schedule is monthly payment × n − P. The calculator displays the payment and total interest rounded to cents; its formula does not separately model a final-payment adjustment due to cent rounding.

Worked Example

Using the calculator’s default values—P = $20,000, APR = 8%, and a five-year term:

1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Number of payments: n = 5 × 12 = 60.
3. Payment before display rounding: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53 per month.
4. Total interest using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.

The displayed result is approximately $405.53 per month and $4,331.80 in total interest. For the first month, interest is $20,000 × 0.0066667, or about $133.33. About $272.20 of the $405.53 payment reduces principal, leaving an estimated balance of $19,727.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, mortgage insurance, escrow, and irregular or extra payments are not included.

What an Amortization Table Shows

An amortization table, sometimes called an amortization schedule, lays out the loan’s repayment period by period. A typical schedule includes the payment number or date, starting balance, payment amount, interest charge, principal reduction, and ending balance. Reading across a row shows how one payment is allocated; reading down the balance column shows how the debt declines.

For a fully amortizing fixed-rate loan with regular payments, the interest portion generally decreases over time because it is calculated on a shrinking balance. The principal portion generally rises, even though the scheduled payment remains level. Early in the schedule, the balance is larger and so is the interest charge. Later, more of each payment goes toward principal. The exact pattern depends on the balance, rate, payment timing, and schedule.

How to Build and Read the Schedule

To create a month-by-month schedule, use the same rate and payment assumptions throughout. For each period, calculate interest on the opening balance, subtract that interest from the payment to find principal repaid, and subtract principal from the opening balance to get the closing balance.

1. Set the opening balance for the first row to the amount borrowed.
2. Multiply that balance by the monthly rate to find the period’s interest.
3. Subtract interest from the scheduled payment to find the principal portion.
4. Subtract that principal portion from the opening balance to find the new balance.
5. Use the new balance as the next period’s opening balance and repeat.

In a real loan, the lender’s schedule may use actual payment dates, daily interest accrual, fees, or a final payment that differs slightly because payments are rounded to cents. Use the loan disclosure or servicing records for the contract-specific figures.

Accounting Meaning and Common Misconceptions

In loan accounting, amortization tables help track the reduction of a liability and the interest expense associated with each period. For a borrower, a payment is not necessarily all principal: the interest component is the cost for that period, while principal reduces the outstanding loan balance. A lender’s accounting records likewise distinguish the loan balance from interest earned, although exact bookkeeping treatment depends on the entity and accounting framework.

“Amortization” also has a separate accounting use: spreading the cost of certain intangible assets over their useful lives. That is not the same calculation as a loan amortization table. A loan schedule is about allocating debt payments between principal and interest; an asset amortization schedule tracks an asset’s cost over time.

A common misconception is that a level payment means equal principal repayments. Usually it does not: the total payment is level under the stated assumptions, but its interest and principal components change each period. Another is that the table necessarily equals the amount paid in every real-world situation. Changes in rates, missed or extra payments, fees, and payment-date conventions can make the actual balance differ from a basic estimate.

When to Use It and What Can Change the Result

A schedule can help explain a quoted payment, estimate the balance after a series of regular payments, or compare the effects of different entered terms and rates as arithmetic scenarios. It is useful for understanding repayment mechanics, but it does not establish what a borrower qualifies for or what a particular lender will charge. Use the lender’s stated APR, payment frequency, term, and payment amount rather than assuming the calculator’s defaults apply.

Check these details when a calculated schedule and a statement do not match:

• APR versus periodic rate: the formula converts annual percentage APR to a monthly rate by dividing by 12, then by 100.
• Term units: this calculator takes years and multiplies by 12; entering months as years would produce a different result.
• Rounding: rounding each monthly interest amount can create a small difference from calculations that retain extra decimal places.
• Payment structure: variable-rate loans, interest-only periods, balloon payments, and irregular payments do not follow this level-payment model throughout.
• Additional charges: fees and other amounts may affect the actual payment or total borrowing cost but are not inputs here.

For extra payments, the effect depends on when the payment is made and how it is applied. If an extra amount is credited to principal, a schedule must be recalculated using the revised balance and the loan’s payment rules; simply subtracting it from total interest is not reliable.

Frequently Asked Questions

What is an amortization table in accounting?
An amortization table is a period-by-period record showing scheduled payments, interest, principal reduction, and remaining loan balance. It supports tracking how a loan liability is repaid and how payment amounts are divided.

How do I calculate the principal portion of a payment?
For a standard monthly schedule, subtract that month’s interest from the payment. Interest is the opening balance multiplied by the monthly rate; the remainder is principal reduction.

Why does the interest portion decrease over time?
With a fixed rate and regular payments, interest is calculated on the outstanding balance. As principal is repaid and the balance shrinks, the interest charged for a period usually falls.

Is an amortization table the same as an amortization calculator?
No. A calculator estimates results from entered assumptions. A table presents the period-by-period breakdown, which can be generated from those assumptions or supplied by a lender.

Why does my lender’s schedule differ from this estimate?
Possible reasons include payment dates, daily rather than monthly interest accrual, fees, a changing rate, rounding conventions, or payments made at different times. The lender’s disclosure gives the contract-specific figures.

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

Related

• Qualifying Income Calculator for Loan Applications
• Roth IRA Earned Income: What Qualifies?
• Qualifying Household Income 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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2