Effective Interest Amortization Table: How It Works

An effective interest amortization table shows how each scheduled payment is divided between interest and principal, using the interest accrued on the outstanding balance. This calculator produces a level-payment loan schedule from the loan amount, annual interest rate, and term; it returns the monthly payment and total interest, while the table itself can be built by applying the same calculation month by month.

Formula

For a fixed-rate loan with equal monthly payments, the payment is the amount that amortizes the starting principal over the full term:

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

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

The calculator rounds the scheduled payment to the nearest cent. Its total-interest estimate is payment × n − P, so it uses that rounded payment. An actual final payment may be adjusted by a lender to clear a small remaining balance caused by rounding or payment-date details.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% annual APR, and five years:

1. Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: 5 × 12 = 60.
3. Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 when rounded to cents.
4. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The outputs are a monthly payment of $405.53 and estimated total interest of $4,331.80.

What an Effective Interest Amortization Table Shows

Each row represents a payment period. The interest portion is calculated on the balance outstanding during that period, rather than on the original principal throughout the loan. The rest of the payment reduces principal. As the balance falls, the interest portion generally declines and the principal portion generally rises, provided the rate and payment stay fixed.

For the first month in the example, interest is $20,000 × 0.0066667, or about $133.33. Subtracting that from the $405.53 payment leaves about $272.20 to reduce principal. The new balance is approximately $19,727.80. For the second month, interest is calculated on that lower balance: about $131.52. The payment remains $405.53, so about $274.01 goes to principal. Small differences in the last cents can occur because the table rounds each period.

A typical schedule includes the payment number, starting balance, payment, interest, principal repaid, and ending balance. The opening balance of each row becomes the next row’s starting balance. A correctly constructed schedule should approach zero at the end, subject to rounding and payment adjustments.

How to Build and Read the Table

To calculate each row, use the following sequence:

1. Start with the loan’s current outstanding balance.
2. Multiply it by the periodic interest rate to calculate interest for that period.
3. Subtract that interest from the scheduled payment to find principal repaid.
4. Subtract principal repaid from the starting balance to get the ending balance.
5. Carry that ending balance into the next period.

For a standard monthly schedule, the periodic rate is usually the annual rate divided by 12 when the quoted APR is being modelled as a nominal annual rate with monthly compounding. The calculator assumes payments are made monthly and applies this convention. A lender’s contract and payment dates determine the actual accrual method; a daily-interest method or an irregular first period can produce different figures.

When This Method Applies—and Its Limits

This table is useful for understanding the planned principal and interest pattern on a fixed-rate loan with equal monthly payments. It can help a reader see how a balance changes over time, estimate scheduled interest over the full term, or compare a calculated schedule with a lender-provided breakdown using the same assumptions.

It does not by itself calculate an account’s full payment when other amounts are collected, nor does it model changing rates, skipped or late payments, extra principal payments, fees added to the balance, or a final payment recalculated by the lender. If a loan’s rate resets, its payment changes, or interest accrues using a different convention, the schedule must reflect those terms. For a variable-rate loan, one fixed-rate table is only a snapshot under the rate entered.

Common Errors and Misconceptions

• Using 8 instead of 0.08: the calculator’s APR input is entered as a percentage, so enter 8 for 8%. The formula converts it to a monthly decimal.
• Dividing the annual rate incorrectly: for this monthly APR method, divide the percentage by 1,200, not just by 12.
• Assuming every payment is principal: interest is paid first in the period’s calculation; only the remainder reduces principal.
• Treating total interest as a separate fixed charge: it is the sum of interest accrued on successive outstanding balances under the assumed schedule.
• Expecting exact lender figures: rounding, dates, fees, and contract-specific accrual rules may make a lender’s disclosure differ from an educational calculation.

Frequently Asked Questions

What does effective interest mean in an amortization table?
It refers to calculating each period’s interest on the balance still outstanding. As principal is repaid, the balance used to calculate later interest declines.

How do I calculate the interest portion of a payment?
Multiply the period’s opening balance by the periodic interest rate. With a monthly rate, use the monthly opening balance and monthly rate.

Why does the principal portion increase over time?
With a fixed rate and level payment, the payment stays the same while interest generally falls as the outstanding balance declines. The amount left after interest therefore becomes a larger principal reduction.

Is an amortization table the same as a payment schedule?
A payment schedule may list due dates and amounts. An amortization table adds the breakdown of each payment into interest and principal and tracks the remaining balance.

Why might my lender’s table differ by a few cents?
Rounding at each payment, exact payment dates, daily accrual, and final-payment adjustments can change individual row amounts or the final balance.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal, made monthly, and occur at the end of each period.
• Interest is calculated monthly using APR ÷ 12; this is a simplified monthly-compounding model.
• Fees, taxes, insurance, PMI, escrow, extra payments, and changes to payment dates are not included.

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

Related

• SNAP Qualifying Income: How Eligibility Is Calculated
• Social Security Qualifying Income: What Counts?
• SC Qualified Retirement Income Deduction: Rules and Limits

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