Loan Payment Schedule With Amortization Explained

A loan payment schedule with amortization shows each scheduled payment and how it is divided between interest and principal, along with the remaining balance. Enter a loan amount, annual percentage rate (APR), and term to estimate the fixed monthly payment and total interest; the schedule details below explain how payments change the balance over time.

Formula

For a fixed-rate loan with equal monthly payments, the payment is calculated using the standard amortization formula:

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

• M is the monthly payment in dollars.
• P is the amount borrowed, or principal, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200 when APR is entered as a percentage per year.
• n is the number of monthly payments: loan term in years × 12.

The calculator rounds the monthly payment to cents. Total interest is then estimated as the rounded monthly payment multiplied by the number of payments, minus the original principal. Because the displayed payment is rounded, an actual lender’s final payment may be adjusted by a few cents.

Worked Example

Using the calculator’s defaults: a $20,000 loan, 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 monthly payments: 5 × 12 = 60.
3. Substitute into the formula: M = 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. Using the rounded payment, total paid is $405.53 × 60 = $24,331.80. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.

Assumptions

• The rate is fixed for the full term.
• Payments are equal, made monthly, and applied on schedule; the model treats each payment period as one month.
• Interest compounds monthly at APR ÷ 12, with no separate daily-interest timing.
• Fees, taxes, insurance, mortgage insurance, escrow, late charges, and extra payments are not included.

How an Amortization Schedule Works

An amortization schedule is a period-by-period table showing how a loan balance is repaid. For each month, the interest portion is calculated on the outstanding balance. The rest of the scheduled payment reduces principal. After the payment, the balance is lower, so—if the rate and payment remain unchanged—the next month’s interest charge is generally smaller.

For example, in the first month of the sample loan, estimated interest is $20,000 × 0.0066667, or about $133.33. From a $405.53 payment, about $272.20 therefore goes toward principal, leaving an estimated balance of $19,727.80. In later months, more of the same payment goes to principal as the balance declines. The figures in a real schedule can differ slightly because of payment dates, rounding rules, and the lender’s calculation method.

A full schedule commonly has columns for payment number or date, beginning balance, payment, interest, principal, and ending balance. The payment amount is not the same as the principal reduction: interest is part of the payment but does not reduce the amount borrowed.

Reading the Payment and Interest Results

The monthly payment is the model’s level payment for principal and interest, not necessarily the complete amount due on a bill. A mortgage payment, for example, may also include escrowed taxes or insurance; other loans may have fees or optional products. Check the loan disclosure or servicing statement for what is actually included.

Total interest estimates the cost of borrowing over all scheduled payments under the entered assumptions. It is not the same as total paid: total paid includes repayment of the original principal as well as interest. The estimate also assumes all 60 payments are made as scheduled and the rate does not change.

To build a month-by-month schedule, repeat these calculations for each payment period:

• Interest for the period = beginning balance × monthly rate.
• Principal repaid = scheduled payment − interest for the period.
• Ending balance = beginning balance − principal repaid.
• The next period’s beginning balance is the previous period’s ending balance.

At the end of the term, the balance should reach zero, subject to rounding and lender-specific payment handling. The last payment may be slightly different from the regular payment to clear the remaining balance.

When the Estimate Differs From a Loan Statement

This calculator models a simple fixed-rate, fully amortizing loan. It does not create a dated schedule or account for irregular payment intervals. A lender may calculate interest using exact days between payments, apply payments at a different point in the cycle, or use another rounding convention. Those details can make the displayed schedule differ from a statement even when the principal, APR, and term appear to match.

Variable rates also change the calculation: a payment or payoff timeline may be recalculated when the rate changes. Interest-only periods, balloon payments, deferred interest, skipped payments, and fees added to the balance are not represented by this formula. Extra principal payments can reduce future interest and shorten repayment, but their effect depends on when they are received and how the servicer applies them. Use the lender’s figures for the contract-specific schedule.

Common Calculation Mistakes

• Using the annual rate as a monthly rate: when APR is entered as a percentage, divide by 1,200 to get a monthly decimal. For 8%, the monthly rate is about 0.006667, not 0.08.
• Forgetting to convert years to months: a five-year monthly schedule has 60 payments, not five.
• Confusing interest with principal: only the principal portion reduces the balance.
• Comparing unlike payment amounts: confirm whether a quoted figure includes taxes, insurance, fees, or other charges.
• Expecting exact totals after rounding: the model uses a payment rounded to cents; lenders may adjust the final installment or calculate interest differently.

Frequently Asked Questions

What does amortization mean on a loan?
Amortization is the gradual repayment of principal through scheduled payments. Each payment covers interest due for the period and, in a fully amortizing loan, also reduces principal.

How do I calculate the interest portion of a monthly payment?
Multiply the balance at the start of the month by the monthly interest rate. Subtract that interest from the scheduled payment to estimate how much goes toward principal.

Does an amortization schedule include taxes and insurance?
Not necessarily. A basic schedule shows principal and interest. Taxes, insurance, escrow, and other charges are separate unless specifically included in the calculation.

Why does the final payment differ from the others?
Rounding, payment timing, and the lender’s interest method can leave a small residual balance. The final amount may be adjusted to bring the balance to zero.

Can extra payments change an amortization schedule?
Yes. If extra money is applied to principal, the outstanding balance can fall faster, changing later interest and the payoff date. This calculator assumes only the regular fixed monthly payment.

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

Related

• UR Loan Application: Payment Calculator and Guide
• US Bank Auto Loan Payoff Address and Payment Options
• Taking Out a Loan for a Down Payment? What to Know

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