Real Estate Amortization Table: How to Read It

A real estate amortization table shows how each scheduled loan payment is split between interest and principal, and how the balance changes over time. Enter the loan amount, annual interest rate, and term to estimate the monthly payment and total interest; use the table method below to interpret each period. This calculator assumes a fixed-rate loan with monthly payments.

Formula

The level monthly payment is the loan principal multiplied by the monthly interest rate, divided by one minus the growth factor’s inverse over the full number of payments:

Payment = P × r / (1 − (1 + r)−n)

Here, P is the amount borrowed in dollars, r is the monthly rate as a decimal (annual APR ÷ 12 ÷ 100), and n is the number of monthly payments (years × 12). Total interest in this calculator is monthly payment × n − P. The calculator’s payment formula uses the unrounded payment internally; actual lender schedules may round each payment to cents, which can create a small difference in the final total.

Worked Example

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

1. Convert the annual rate to a monthly decimal: r = 8 ÷ 100 ÷ 12 = 0.0066667.
2. Convert the term to payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ (1 − (1.0066667)−60).
4. The monthly payment is approximately $405.53 when rounded to cents.
5. Total interest from the calculator’s formula is approximately $4,331.71: the unrounded payment multiplied by 60, less $20,000.

These are calculator estimates rounded for display. A lender’s schedule may calculate totals using its own payment rounding and final-payment adjustments.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly at the end of each period.
• Interest accrues monthly using APR divided by 12.
• Fees, taxes, insurance, mortgage insurance, escrow, and extra payments are not included.

Step-by-Step

1. Gather the loan figures. Find the amount financed, the note’s annual interest rate, and the repayment term in years. If you have a lender-provided amortization schedule, use its figures rather than estimates. Do not substitute a home’s purchase price for the loan amount if a down payment or other financing changes the amount borrowed.
2. Enter the inputs. Type the loan amount in dollars, APR as a percentage (for example, enter 6.5 for 6.5%), and term in years. Check that you have not entered a monthly rate in the APR field or a term in months in the years field.
3. Review the estimated payment and interest. The monthly payment shown is the scheduled principal-and-interest amount under the assumptions above. Total interest is the interest implied over all scheduled payments; it is not the total of all homeownership costs.
4. Set up the table columns. For each payment period, record the payment number, opening balance, payment, interest portion, principal portion, and closing balance. A lender’s actual table may also include separate escrow or other charges; keep those distinct from principal and interest.
5. Calculate each period’s interest. Multiply the opening balance by the monthly rate as a decimal. For example, at 8% APR, the monthly rate is 0.08 ÷ 12. If the opening balance were $20,000, estimated first-month interest would be about $133.33.
6. Find the principal portion. Subtract that period’s interest from the scheduled principal-and-interest payment. With a $405.53 payment and $133.33 interest, about $272.20 goes toward principal. The exact cents can differ with the lender’s rounding method.
7. Update the balance. Subtract the principal portion from the opening balance. The resulting closing balance becomes the next period’s opening balance. Repeat for every payment, checking that the balance trends toward zero.
8. Read across and down. A row shows what happens during one period; a column reveals how that part changes over the term. Early in a standard amortizing loan, interest generally takes a larger share because the balance is higher. As principal is repaid, the interest portion generally falls and more of the same payment reduces principal.
9. Compare any proposed changes carefully. If you are modelling extra payments or a different term, those require a schedule that explicitly includes the change. Do not assume this calculator reflects a lender’s treatment of additional payments, fees, or payment dates.

Common Mistakes

• Confusing APR with the monthly rate: enter the annual percentage, not APR divided by 12. The formula performs that conversion.
• Using the home price as principal: the relevant figure is the amount financed, which may differ from the purchase price.
• Treating the payment as the full housing bill: principal and interest do not automatically include taxes, insurance, association charges, or other costs.
• Expecting every row to match exactly: rounding each monthly interest and payment to cents can create small differences from calculations using unrounded values.
• Assuming a changing-rate loan has one fixed schedule: a rate adjustment can change future interest and payments, so a fixed-rate estimate will not represent later periods.

Tips

• Use the lender’s current loan disclosure or statement for the principal, rate, term, and payment assumptions; the calculator cannot look up lender-specific figures.
• Keep a consistent number of decimal places while calculating, then round displayed amounts to cents. Avoid rounding the balance too early in a hand-built table.
• Check the first row independently: interest should equal opening balance times monthly rate, and principal should equal payment minus interest.
• When checking a lender schedule, compare like with like: scheduled principal and interest against the calculator’s payment, not a total that includes escrow or fees.

Troubleshooting

The payment looks too large or small: recheck the principal, APR percentage, and term units. A shorter term generally produces a larger scheduled payment, all else equal. Confirm the quoted rate is the rate you intend to model.

The balance does not reach zero: check for a missing or extra payment period, inconsistent rounding, or an incorrect interest rate. Actual schedules can also include a slightly adjusted last payment.

Your schedule differs from the lender’s: compare the payment date convention, rate, compounding assumptions, rounding, and whether the lender includes fees or other amounts. Ask the lender to explain its disclosure if a difference remains.

The rate changes or you make extra payments: this calculator’s fixed-payment estimate no longer describes the full schedule. Recalculate from the new balance and applicable terms, or use a tool that explicitly supports rate changes and additional payments.

Frequently Asked Questions

What does an amortization table show?
It lists each scheduled payment and separates the amount applied to interest from the amount applied to principal, alongside the remaining balance.

Why does the interest share usually shrink over time?
With a fixed rate and level payments, interest is calculated on the outstanding balance. As principal falls, the interest due per period generally falls too.

Does the monthly payment include property taxes and insurance?
Not in this estimate. It calculates principal and interest only; check the lender’s figures for any separate escrow or other charges.

Can I use the table for an adjustable-rate loan?
Only for a period when the rate and payment assumptions apply. A rate change can alter later interest and payments.

Why is my final balance not exactly zero?
Rounding and payment timing can leave a small difference, and a lender may adjust the last payment. Use its statement or schedule for the account-specific amount.

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

Related

• 15-Year Loan Amortization Table and Calculator
• Annual Loan Amortization Table: Formula and Example
• Amortization Table Example: Monthly Loan Breakdown

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