Amortization Table Sample: Monthly Loan Breakdown

An amortization table shows how each scheduled loan payment is split between interest and principal, along with the balance left afterward. Enter a loan amount, annual APR, and term to calculate the monthly payment and total interest, then use the sample schedule below to see how the balance changes over time.

Formula

The calculator uses the standard fixed-payment loan formula. It first finds the payment that would repay the principal and interest over the selected number of monthly payments:

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

• P is the starting loan principal in dollars.
• r is the monthly interest rate, calculated as annual APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
• n is the total number of monthly payments, calculated as years × 12.

Total interest in this estimate is monthly payment × number of payments − principal. The payment formula shown in the calculator is not rounded internally, but its displayed result is rounded to cents. The sample schedule below rounds each monthly interest charge to cents and sets principal paid to the displayed payment minus that interest. Small differences in the final row can therefore arise from monthly rounding; a servicer’s payment schedule may use its own rounding and payment-processing conventions.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term—the number of payments is 5 × 12 = 60, and the monthly rate is 0.08 ÷ 12 = 0.0066667.

Substitute those values into the formula:

Payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53 per month.

The calculator’s total-interest output uses the unrounded formula payment before display rounding: the payment is approximately $405.528, so total interest is $405.528 × 60 − $20,000 = $4,331.68. This is the formula result rounded to cents. Multiplying the displayed $405.53 by 60 instead gives $24,331.80 in total payments, or $4,331.80 above principal. That 12-cent difference comes from displaying the monthly payment to cents while calculating total interest with the unrounded payment. Actual loan schedules can also differ because scheduled payments are generally stated in cents and interest is calculated according to the loan’s terms.

Here is a sample opening schedule using the displayed $405.53 payment and monthly interest rounded to cents. It illustrates the usual allocation pattern; it is not a lender-issued payoff schedule.

Payment	Starting balance	Payment	Interest	Principal	Ending balance
1	$20,000.00	$405.53	$133.33	$272.20	$19,727.80
2	$19,727.80	$405.53	$131.52	$274.01	$19,453.79
3	$19,453.79	$405.53	$129.69	$275.84	$19,177.95

For each row, monthly interest is the starting balance multiplied by the monthly rate. Principal paid is the payment minus interest, and the ending balance is the starting balance minus principal paid. The schedule continues in the same way, with the final payment adjusted if needed to bring the balance to zero.

How to Read an Amortization Table

The first rows often show the most noticeable pattern: as the outstanding balance falls, the interest charged each month also falls. With a level payment, that leaves more of the payment to reduce principal. Early payments are not “interest-only”; they include principal unless the loan’s structure or payment terms say otherwise.

A full table commonly includes the payment number or date, opening balance, scheduled payment, interest, principal, and closing balance. Some schedules also show extra payments, fees, or cumulative totals. The closing balance of one row should match the opening balance of the next, subject to rounding.

When a Sample Is Useful

A sample table helps explain how a fixed-rate, fully amortizing loan is expected to decline under regular, on-time payments. It can help a reader check the arithmetic in a proposed schedule, understand why the early balance declines gradually, or see how a term affects the payment and total interest in a mathematical example.

• Use the principal actually being financed, not the purchase price if a down payment or other financing changes the loan amount.
• Enter the annual APR as a percentage, such as 8 for 8%, and the term in years.
• Compare like assumptions: payment frequency, rate type, term, and treatment of fees can change a schedule.
• For the exact contractual payment and balance, refer to the lender’s disclosure or account schedule.

Common Sources of Differences

A calculator sample may not match a statement or lender schedule exactly. The APR may not be the same as the note rate used to calculate periodic interest, depending on the loan disclosure and included charges. Payment dates, day-count conventions, first-payment timing, fees financed into the balance, rate changes, and rounding can also affect the figures. This simple calculator assumes monthly payments and a fixed APR; it does not reconstruct every contract detail.

Another frequent misunderstanding is that the total-interest figure is the same as the total amount paid. Total payments include both principal and interest. In the default example, principal is $20,000 and estimated interest is about $4,331.68, so total payments are about $24,331.68 before considering any separate charges. Because the displayed monthly payment is rounded, multiplying it by 60 yields a slightly different figure, as shown above.

Assumptions

• The APR is fixed for the entire term.
• There are 12 equal monthly payment periods each year, with payments made at the end of each period.
• Interest is calculated monthly at APR ÷ 12; the formula assumes a level payment and full repayment over the stated term.
• Fees, taxes, insurance, PMI, escrow, and extra payments are not included.

Frequently Asked Questions

What does an amortization table show?
It shows each scheduled payment’s interest and principal portions and the remaining balance after payment. A schedule may also include dates and cumulative totals.

Why does more of the payment go to interest at the beginning?
Interest for a period is calculated on the outstanding balance. The balance is highest at the start, so the interest portion is larger; as principal falls, periodic interest usually falls too.

Does an amortization table include taxes and insurance?
Not necessarily. A principal-and-interest schedule excludes separate costs unless they are specifically included in the calculation. This calculator does not include taxes, insurance, PMI, escrow, or fees.

Why does my lender’s schedule differ from this sample?
Differences can come from the contract’s rate, fees, payment dates, interest calculation method, financed charges, or rounding. Check the lender’s disclosure for the exact figures and assumptions.

Can I use this table for a variable-rate loan?
This calculator assumes the APR stays fixed. A variable-rate loan needs a schedule that accounts for each rate change and any resulting payment or balance adjustments.

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

Related

• Qualifying Income for SNAP Benefits Explained
• Qualifying Income for Self Assessment Explained
• NCS AP Benefits: Qualifying Income 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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2