Real Estate Amortization Table: Payments and Balance

A real estate amortization table shows how each scheduled mortgage payment is divided between interest and principal, and how the loan balance changes over time. Enter the loan amount, annual interest rate, and term below to estimate the level monthly payment and total interest; this calculator summarizes those figures rather than printing every monthly row.

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 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.
• Payment is the calculated monthly principal-and-interest amount, in dollars.

The calculator’s total-interest estimate is monthly payment × number of payments − principal. The payment shown is rounded to cents before total interest is calculated, as scheduled payments are generally expressed in currency units. Real loan servicing can involve different rounding and timing details.

Worked Example

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

1. Convert the annual percentage rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Find the number of monthly payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The unrounded payment is about $405.53; rounded to cents, the estimated monthly payment is $405.53.
5. Total payments using the rounded amount are $405.53 × 60 = $24,331.80. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly using the APR divided by 12.
• The estimate excludes fees, property taxes, homeowners insurance, mortgage insurance, escrow deposits, and any other charges because they are not calculator inputs.

What a Real Estate Amortization Table Shows

A full amortization table is a schedule with one row for each payment. Common columns include the payment number or date, payment amount, interest portion, principal portion, and remaining balance. The table begins with the original principal and should approach zero after the final scheduled payment, subject to rounding and contract terms.

For each period, interest is generally calculated on the outstanding balance. The payment first covers that period’s interest; the remainder reduces principal. Early in a fully amortizing loan, the balance is large, so more of a level payment goes to interest. As principal is paid down, the interest portion typically falls and the principal portion rises. The payment can remain level even though its allocation changes.

For example, at the beginning of a loan with a $20,000 balance and an 8% annual rate divided monthly, one month’s approximate interest is $20,000 × 0.08 ÷ 12, or $133.33. With the example payment of $405.53, about $272.20 would reduce principal in that first period. Actual statements may differ by cents because lenders can use specific day-count, posting, and rounding conventions.

How to Read and Use the Estimate

Use the monthly payment to understand the scheduled principal-and-interest component, and the total-interest estimate to see the cost implied by making every scheduled payment for the entire term. Neither number is the complete monthly cost of owning a property. A mortgage payment may be collected alongside taxes, insurance, mortgage insurance, or escrow amounts, but those costs are not part of this calculation.

A table is useful for seeing when principal is expected to fall and for comparing payment schedules using clearly specified loan inputs. To make a meaningful arithmetic comparison, hold the principal, rate assumptions, and term definitions in view. A different term changes both the payment and the number of periods over which interest is calculated; the calculator does not assess whether any loan is appropriate for a particular person.

To interpret a lender-provided table, check that its starting balance, annual rate, payment frequency, term, and first payment date match the loan disclosure. Look for separate treatment of fees or optional extra payments. A schedule based on principal and interest alone will not necessarily match a statement showing an all-in amount due.

Common Misunderstandings and Limits

• Confusing payment with total housing cost: this estimate covers principal and interest only, not property-related charges or loan fees.
• Assuming the same split every month: for a standard fixed-rate amortizing loan, the scheduled payment may stay level while the principal and interest shares change.
• Expecting a variable-rate loan to follow one schedule: a rate change can alter the payment, term, or balance path. This calculator assumes the entered rate remains fixed.
• Ignoring extra payments: additional principal payments can change how quickly a balance falls and how much interest accrues. They are not modeled here, and how they are applied depends on loan terms and servicing.
• Treating rounded estimates as a payoff quote: daily interest, payment dates, fees, and servicing adjustments can make an actual payoff amount different.

The formula also presumes regular periods and a payment large enough to amortize the principal over the selected term. It does not reproduce every loan contract feature, such as an introductory rate, interest-only period, balloon payment, or irregular payment schedule. Use the lender’s disclosed schedule for contractual amounts and dates.

Frequently Asked Questions

What is an amortization table for a mortgage?
It is a payment-by-payment schedule showing how each payment is allocated to interest and principal and what balance remains afterward.

Why does more of a mortgage payment go to interest at first?
Interest for a period is calculated on the outstanding balance. The balance is generally highest at the start, so the interest portion tends to be larger early in a level-payment schedule.

Does this calculator show my full monthly mortgage payment?
No. It estimates principal and interest only. Taxes, insurance, mortgage insurance, escrow, and fees are not included.

Can an amortization table include extra payments?
A detailed schedule can account for extra principal payments if their amount and timing are known. This calculator does not include them, and the effect depends on how the loan servicer applies each payment.

Why might my lender’s table differ by a few cents?
Rounding, payment posting dates, interest accrual conventions, and contract details can affect individual rows. The calculator uses a standard monthly estimate, not the lender’s servicing system.

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

Related

• Qualifying Income for MTD for Landlords Explained
• FIG Qualifying Income: How It’s Defined
• Qualifying Income Exception: What It Means

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