Loan Installment Schedule Calculator and Guide

A loan installment schedule shows each payment date, the amount applied to interest, the amount applied to principal, and the balance remaining after payment. This calculator estimates the level monthly payment and total interest for a fixed-rate loan when you enter the loan amount, annual percentage rate (APR), and term; it does not create a dated, lender-specific payment table.

Formula

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

Payment = P × r / [1 − (1 + r)−n]

• P is the starting principal, in dollars.
• APR is the annual percentage rate entered as a percent per year.
• r is the monthly rate, calculated here as APR ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.

The calculator rounds the monthly payment to cents. Estimated total interest is the rounded monthly payment multiplied by the number of payments, minus the original principal. The calculation assumes that the full payment amount goes toward principal and interest.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term—there are 5 × 12 = 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667.

1. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The unrounded result is about $405.53; rounded to cents, the estimated monthly payment is $405.53.
3. Using that rounded payment, estimated total interest is ($405.53 × 60) − $20,000 = $4,331.80.

The schedule would divide each payment between interest and principal. In the first month, estimated interest is $20,000 × 0.0066667, or about $133.33. The remainder of the $405.53 payment—about $272.20—reduces principal, leaving an estimated balance of $19,727.80. Later payments generally contain less interest and more principal because the outstanding balance declines. A final payment may differ slightly due to rounding or lender-specific calculations.

What a Loan Installment Schedule Shows

An installment schedule, often called an amortization schedule, lays out the repayment of a loan over time. A full schedule commonly includes the payment number or due date, scheduled payment, interest charged for that period, principal repaid, and balance after payment. It can also show cumulative interest and principal paid.

The schedule helps explain why the payment amount alone does not tell the whole story. With a level-payment, fixed-rate loan, the required payment can stay the same while its composition changes. Early in repayment, interest is calculated on a larger balance; as principal is paid down, less interest accrues for each subsequent period.

How to Read and Use the Estimate

Enter the amount borrowed—not necessarily the total purchase price—plus the APR and repayment term. The first output is the estimated monthly principal-and-interest payment. The second is total interest over the term, calculated using the rounded payment. A longer term generally means more scheduled payments; under the same fixed-rate assumptions, it can also increase the total interest paid even when the monthly payment is lower.

This page gives summary figures rather than every installment row. To build a month-by-month schedule, calculate each period’s interest from the opening balance and periodic rate, subtract that interest from the payment to get principal repaid, then subtract principal repaid from the opening balance. Repeat until the balance is paid, adjusting the last payment if needed. The lender’s actual schedule is the reference for due dates and exact amounts.

What Can Change the Schedule

The result is an estimate because lenders can calculate payments and balances using contract-specific terms. A schedule may differ when a loan has a variable rate, irregular payment dates, a non-monthly payment frequency, a payment deferral, a balloon payment, or fees added to the amount financed. Extra principal payments can also alter the remaining balance and the amount of future interest, depending on how the lender applies them.

APR and the rate used to accrue interest are related concepts but are not always interchangeable in every contract. This calculator uses APR ÷ 12 as a monthly rate for the formula. It does not separately model fees, taxes, insurance, escrow, late charges, or other costs. Ask the lender for its payment schedule and the inputs it used if you need contract-level figures.

Common Misunderstandings

• “The whole payment reduces the balance.” Not in a standard amortizing loan. Interest is accounted for first, and the rest reduces principal.
• “Total interest is the same as total payments.” Total payments include repayment of principal. Interest is the amount paid above principal in this simplified calculation.
• “APR alone gives the exact schedule.” The estimate also depends on principal, term, payment frequency, timing, and the loan’s specific accrual and rounding rules.
• “A displayed monthly amount guarantees every bill will match.” Dates, fees, rate changes, and lender rounding can make actual installments or the final payment differ.

Assumptions

• The rate is fixed for the full term; no rate changes are modelled.
• Payments are equal monthly installments, with the first payment one month after the loan begins.
• Interest is treated as accruing monthly at APR ÷ 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and additional payments are not included.

Frequently Asked Questions

What is a loan installment schedule?
An installment schedule is a repayment plan that shows when payments are due and how each payment is divided between interest and principal, along with the remaining balance.

How do I calculate a monthly loan installment?
For equal monthly payments on a fixed-rate loan, use the amortization formula: principal multiplied by the monthly rate, divided by one minus (one plus the monthly rate) raised to the negative number of payments. Convert APR to a monthly rate and years to months.

Why does the interest portion change each month?
In a standard amortizing loan, periodic interest is based on the outstanding balance. As principal falls, the interest charged generally falls too, so more of a level payment can go toward principal.

Does the calculator include fees or insurance?
No. It estimates principal-and-interest payments and interest only. Check the lender’s disclosures for fees and any other amounts that may affect the bill or total cost.

Why might my lender’s payment schedule be different?
The lender may use different dates, accrual conventions, rounding, fees, payment timing, or loan terms. A variable rate or later account changes can also alter the schedule.

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

Related

• Fifth Third Bank Installment Loan ZIP Code Explained
• Emergency Installment Loan Calculator and Options
• Installment Loan: Meaning, Payments and Key Features

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