calculate-loan

01 Loan payments

Installment Loan Amortization Schedule Calculator

Calculator No. 01-20611 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An installment loan amortization schedule shows how each scheduled payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term to calculate the level monthly payment and total interest; the schedule itself can then be built payment by payment using the same calculation.

Formula

The calculator uses the standard fixed-payment loan formula. It first calculates the monthly payment, then subtracts the original principal from all scheduled payments to estimate total interest:

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

Total interest = (monthly payment × n) − P

  • P is the amount borrowed, in dollars.
  • r is the monthly interest rate as a decimal: APR ÷ 1200. For an 8% APR, r = 0.08 ÷ 12.
  • n is the number of monthly payments: loan term in years × 12.

The monthly payment is rounded to the nearest cent in the calculator. Total interest uses that displayed, rounded payment multiplied by the number of scheduled payments, then subtracts the loan amount. Actual lender calculations can differ slightly because of payment dates, rounding practices, or contract terms.

Worked Example

With the calculator’s default inputs—$20,000 borrowed, 8% APR, and a five-year term—the schedule has 60 monthly payments. The monthly rate is 0.08 ÷ 12 = 0.0066667, and the payment formula is:

$20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] = $405.53 per month

Using the rounded payment, total scheduled payments are $405.53 × 60 = $24,331.80. Subtracting the $20,000 principal gives estimated total interest of $4,331.80.

Assumptions

  • The interest rate stays fixed for the full term.
  • Payments are equal monthly payments made at the end of each monthly period.
  • Interest is calculated monthly using APR divided by 12.
  • Fees, taxes, insurance, PMI, escrow, and other charges are not included.

How an Amortization Schedule Works

An amortization schedule is a table of the loan’s expected payment dates and balances. Each row commonly lists the payment number or date, starting balance, payment amount, interest charged, principal repaid, and ending balance. For a conventional fixed-rate installment loan with regular payments, interest is calculated on the outstanding balance. The remainder of the payment reduces principal.

To calculate a row, multiply the starting balance by the monthly rate to estimate that period’s interest. Subtract that interest from the payment to find principal repaid. Then subtract principal repaid from the starting balance. In symbols:

  • Interest for the period = starting balance × monthly rate.
  • Principal repaid = payment − interest for the period.
  • Ending balance = starting balance − principal repaid.

Early in a fully amortizing loan, the balance is relatively high, so more of a level payment goes toward interest. As the balance falls, the interest portion generally shrinks and more of each payment reduces principal. This does not mean the lender charges a higher rate at the beginning; it reflects interest being calculated on the remaining balance.

Building and Reading the Schedule

For the example, the first month’s interest is approximately $20,000 × 0.0066667 = $133.33. From the $405.53 payment, about $272.20 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 when a lender carries more decimal places internally or uses exact dates rather than a simplified monthly convention.

A schedule is useful for seeing the projected balance at a particular point, understanding the principal-interest split, and checking how total interest relates to the payment and term. To calculate a balance after a particular number of payments, the fixed-payment formula is:

Balance after k payments = P(1 + r)k − M × [(1 + r)k − 1] ÷ r

Here, k is the number of payments made and M is the monthly payment. This formula assumes the same fixed rate and regular payment timing as the payment estimate. The calculator above provides the payment and total interest; a full schedule requires repeating the period-by-period calculations or using this balance formula for selected points.

What Changes the Schedule

The schedule depends on the principal, rate, term, and payment pattern. With the rate and term unchanged, a larger principal produces a larger payment. With principal and rate unchanged, a longer term generally lowers the scheduled payment but means more monthly periods accrue interest. A higher APR also increases the payment and, under the same term assumptions, usually increases total interest.

Extra payments can alter a real loan’s path by reducing principal sooner, which can reduce later interest if the contract applies the extra amount to principal. Their treatment and any resulting payment or maturity changes depend on the loan terms, so this calculator does not model them. A variable-rate loan also will not follow one fixed schedule if its rate changes. For a useful estimate, use the rate and repayment details in the lender’s current disclosure rather than assuming the initial schedule will remain accurate after a change.

Common Mistakes and Limits

  • Confusing APR and monthly rate: enter APR as a yearly percentage, such as 8, not 0.08. The formula converts it to a monthly decimal by dividing by 1200.
  • Using the wrong term units: the input is years; the formula multiplies it by 12 to get monthly payments.
  • Assuming the payment is the whole borrowing cost: the payment excludes charges not included in the inputs. Total interest is also not the same as total fees or total cost of borrowing.
  • Expecting an exact lender payoff figure: payoff amounts can depend on the date, accrued interest, fees, and contract-specific calculation methods.
  • Assuming every installment loan has level payments: this formula models a fixed rate, equal monthly payments, and full repayment by the end of the term. Interest-only periods, balloon payments, changing rates, irregular payments, and extra principal payments require different calculations.

The results are estimates for educational arithmetic, not financial advice. Check the loan disclosure for the actual payment schedule and ask the lender how it treats payment dates, rounding, fees, and extra payments. The result is an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What is an installment loan amortization schedule?
An installment loan amortization schedule is a payment-by-payment breakdown showing how much goes to interest and principal and what balance remains after each payment.

How do I calculate the monthly payment?
Use the fixed-payment formula with the loan principal, monthly rate (APR divided by 1200), and number of monthly payments (years multiplied by 12). The calculator applies that formula and rounds the monthly payment to cents.

Why does more of my early payment go to interest?
Interest for each period is based on the balance at that point. Since the balance is higher near the start, the interest portion is often larger; as principal is repaid, the interest portion generally declines.

Does an amortization schedule include fees and insurance?
Not in this calculation. It estimates principal and interest from the entered amount, APR, and term. Charges such as fees or insurance must be checked separately in the loan documents.

Can I use this for a variable-rate or extra-payment loan?
The displayed estimate assumes a fixed rate and equal monthly payments with no extra principal. Rate changes or additional payments change the schedule and require recalculating with the applicable terms.

Related

Formula used
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

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →