Amortization Schedule Maker: Payments and Balance

An amortization schedule maker estimates each payment on a fixed-rate loan and shows how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term to see the estimated monthly payment and total interest; the schedule itself can then be built by applying the same interest-and-principal calculation to each month.

Formula

The standard fixed-payment amortization formula calculates the monthly payment by spreading repayment of principal and interest across the loan term:

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

• P is the starting principal, or loan amount, 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 monthly payment is rounded to the nearest cent. Total interest is estimated as the rounded payment multiplied by the number of payments, minus the original principal: Total interest = payment × n − P. Because the regular payment is rounded, an actual lender may adjust the final payment slightly to clear the remaining balance.

To calculate an individual schedule row, multiply the balance at the start of that month by the monthly rate to find interest. Subtract that interest from the payment to find the principal paid. Then subtract the principal paid from the starting balance. In symbols: interest = starting balance × r; principal paid = payment − interest; and ending balance = starting balance − principal paid. The next row begins with that ending balance.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:

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 estimated total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

For the first month, estimated interest is $20,000 × 0.0066667, or about $133.33. The remaining $272.20 of the $405.53 payment reduces principal, leaving an estimated balance of $19,727.80. In the next month, interest is calculated on that lower balance. Small differences can arise from rounding displayed values; calculations should retain precision internally and round money amounts for presentation.

Assumptions

• The interest rate remains fixed throughout the stated term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest compounds monthly at APR divided by 12; this is a simplified estimate and may differ from a lender’s day-count method.
• Fees, taxes, insurance, mortgage insurance, escrow, and any irregular or extra payments are not included.

How to Read an Amortization Schedule

A complete schedule usually has one row per payment period. Common columns include the payment number or date, opening balance, payment amount, interest portion, principal portion, and closing balance. Early in a fully amortizing loan, the balance is relatively high, so a larger share of the level payment goes to interest. As the balance falls, the interest portion generally falls too, and more of each payment goes to principal.

The payment may stay level even though its components change. For example, in the first month of this illustration, about $133.33 goes to interest and $272.20 to principal. Later payments use the same estimated $405.53 amount, but the principal share grows as interest is calculated on a smaller balance. The final row should bring the balance to zero, subject to the lender’s rounding and final-payment adjustment.

When to Use a Schedule Maker

An amortization schedule is useful for understanding how a loan’s balance is expected to decline under a stated set of assumptions. It can help someone inspect the relationship among the amount borrowed, rate, term, monthly payment, and total interest without treating the estimate as a lender quote.

• Compare the payment and interest arithmetic for different hypothetical loan amounts or terms, using rate figures supplied by the relevant lender.
• See how much of a particular scheduled payment is allocated to interest versus principal.
• Estimate the balance after a given number of regular payments by following the rows through that period.
• Check whether a quoted payment appears consistent with the entered principal, APR, and term, while accounting for possible fees or other charges separately.

This calculator returns a payment and total-interest estimate rather than a dated, row-by-row table. A full schedule is produced by repeating the row calculation above for each month. If the loan uses a variable rate, changing payment, irregular payment dates, or a different compounding convention, a simple fixed-rate schedule will not represent it accurately.

Common Mistakes and Limitations

Entering an APR as a monthly rate is a frequent unit error. The calculator expects an annual percentage, such as 8 for 8%, and converts it by dividing by 1,200. Entering 0.08 to mean 8% would instead mean 0.08% APR. Check the lender’s stated rate and the calculator’s units before interpreting the result.

Another common misconception is that the entire payment reduces the balance. Interest is charged first in the schedule calculation; only the remainder reduces principal. Total interest is also not the same as total loan cost when a contract includes fees, insurance, taxes, or other charges. Those items are outside this calculator’s inputs.

The schedule assumes a fixed APR and regular monthly payments. Actual loan agreements may use daily interest accrual, payment dates that vary, an adjusted final payment, or other terms. Extra payments can alter the balance path and interest paid, but this basic calculation does not model them. Ask the lender for its payment schedule and the figures disclosed for the specific loan if exact amounts are needed.

Frequently Asked Questions

What does an amortization schedule maker calculate?
It estimates a regular payment and shows, period by period, how much goes to interest and principal and how the remaining balance changes. This calculator summarizes payment and total interest; a full schedule requires repeating the monthly row calculation.

Why does the interest portion decrease over time?
Under the fixed-rate model, each period’s interest is based on the outstanding balance. As payments reduce that balance, the next period’s interest charge is smaller, leaving more of a level payment for principal.

Does the monthly payment include taxes and insurance?
No. The estimate covers principal and interest only. Taxes, insurance, fees, mortgage insurance, and escrow amounts are not included unless entered into a separate calculation.

Why might my lender’s schedule differ?
A lender may use different rounding, payment dates, day-count methods, fees, or contract terms. A variable rate or irregular payment also changes the results. Use the lender’s disclosed schedule for exact contractual figures.

Can I use this for extra payments?
Not directly. Extra principal payments change future balances and interest, so each remaining row must be recalculated with the payment timing and allocation rules that apply to the loan.

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

Related

• Mortgage Interest Rate Calculator and Payment Formula
• I Bond Interest Rate: How It’s Set and Updated
• Car Loan Interest Rate Calculator and Payment Formula

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