Amortization Schedule Builder: Payments and Balance

An amortization schedule builder estimates a loan’s fixed monthly payment, total interest, and total of scheduled payments from the amount borrowed, annual percentage rate (APR), and term. Enter those three values to see the payment calculation; a full month-by-month schedule can then be built by applying the same interest-and-principal steps to each payment.

Formula

This estimate assumes equal monthly payments and a fixed rate. The standard level-payment formula calculates the monthly payment from the principal, monthly interest rate, and number of payments:

Payment = round(P × r / [1 − (1 + r)⁻ⁿ], 2)

• P is the original loan principal, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the monthly amount, rounded to cents.

Total of payments is the rounded monthly payment multiplied by n. Estimated total interest is that total minus the original principal. These totals use the rounded payment, so they reflect the arithmetic shown, not an additional unrounded payment amount.

Worked Example

Using the defaults—$20,000 principal, 8% APR, and a five-year term:

1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667 (approximately).
2. Convert the term to payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53 per month.
4. Total of payments: $405.53 × 60 = $24,331.80.
5. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

The monthly payment shown is $405.53, with total interest of $4,331.80 and total payments of $24,331.80.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are equal, made monthly, and treated as occurring at the end of each period.
• Interest accrues monthly using APR divided by 12; this is a simplified standard loan calculation.
• Fees, taxes, insurance, PMI, escrow, late charges, and other amounts are not included.

How an Amortization Schedule Works

An amortization schedule shows how each regular payment is allocated between interest and principal, and how the remaining balance changes over time. For each period, interest is calculated on the outstanding balance. The payment first covers that period’s interest; the remainder reduces principal. As the balance falls, the interest portion generally gets smaller and the principal portion larger, even though the scheduled payment remains level.

For the example, first-month interest is about $133.33 ($20,000 × 0.08 ÷ 12). With a $405.53 payment, about $272.20 goes toward principal, leaving an estimated balance of $19,727.80. Later rows repeat the calculation using the new balance. Small differences can arise when a lender calculates interest using daily balances, uses a different payment date convention, or adjusts the final payment for rounding.

When to Use the Builder

Use an amortization estimate to understand the relationship between a proposed principal, APR, and repayment period, or to check the arithmetic in a quoted payment. It can also help explain why a longer term usually produces a smaller required monthly payment but more scheduled payments, while a shorter term generally pays principal down faster. Those are mathematical effects under the stated assumptions, not a recommendation about which loan to take.

The three summary outputs are useful for different questions:

• Monthly payment: the formula’s equal scheduled payment, rounded to cents.
• Total interest: the estimated amount paid above principal over the full term.
• Total of payments: the total scheduled cash payments, calculated from the rounded monthly amount.

A summary is not the same as a complete schedule. To create monthly rows, start with the opening balance, calculate interest for that month, subtract interest from the payment to find principal repaid, and subtract that principal from the opening balance to get the next balance. Continue through the final period, adjusting for cents if needed.

Common Errors and Limits

Check that APR is entered as a percentage such as 8, not as 0.08, because the calculator converts a percent to a monthly decimal by dividing by 1,200. Enter the loan term in years, not months. Also distinguish the loan principal from the total cost of a purchase: a down payment or financed fees can change the amount actually borrowed.

This formula is for a fixed-rate loan repaid in level monthly installments. It does not model variable rates, irregular payment dates, extra principal payments, skipped payments, interest-only periods, balloon payments, or fees added to the balance. A lender’s payment may differ if its contract uses a different accrual method, payment schedule, or rounding convention. An APR may incorporate certain borrowing costs under the lender’s calculation, but this builder does not itemize or separately model fees.

Frequently Asked Questions

What does an amortization schedule show?
It lists each payment period’s payment, interest, principal reduction, and remaining balance. The split changes over time as the balance is paid down.

Is an amortization schedule builder the same as a loan payment calculator?
Not necessarily. A payment calculator may show only a periodic payment; a schedule builder lays out the payment allocation and remaining balance over successive periods. This builder’s summary estimates the payment and totals, while the monthly rows can be derived using the stated steps.

Why does the first payment include more interest?
Interest for a period is based on the balance at its start. Early in repayment that balance is largest, so more of a level payment goes to interest. As principal falls, the interest charge falls and more of the payment reduces principal.

Does the estimate include taxes and insurance?
No. It estimates principal-and-interest arithmetic only. Taxes, insurance, escrow, PMI, fees, and other charges require separate figures and are not part of these outputs.

Why might my lender’s payment differ?
The lender may use different timing, daily interest accrual, payment rounding, financed charges, or contract terms. Compare the estimate with the loan disclosure and the actual schedule supplied for the loan.

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

Related

• Interest Rate Sensitivity: Meaning and Loan Calculator
• Interest Rate Refinance Calculator: Compare Payments
• Interest Rate Right Now? What the Number 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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2
out tot | Total of payments | $ | pmt * yrs * 12 | 2