calculate-loan

01 Loan payments

Amortization Schedule Calculator: Payments and Balance

Calculator No. 01-20767 · 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 amortization schedule calculator estimates a fixed-rate loan’s monthly payment and total interest, then shows how each payment reduces the balance over time. Enter the loan amount, annual interest rate (APR), and term to see the payment and a month-by-month schedule based on the calculator’s assumptions.

Formula

The calculator uses the standard fixed-payment loan formula. It estimates the monthly payment as:

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

  • P is the original loan principal, in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200, or approximately 0.006667 per month.
  • n is the number of monthly payments, calculated as the term in years × 12.

Total interest is estimated as monthly payment × number of payments − principal. The payment displayed here follows the formula’s full precision; an actual lender’s payment may differ because of rounding conventions, dates, fees, or contract terms. For a schedule built from cent-rounded payments, totals should use that rounded payment consistently.

Worked Example

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

  1. Convert the APR to a monthly 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)−60] ≈ $405.53 per month.
  4. Estimate total interest using the unrounded formula result: approximately $405.53 × 60 − $20,000 = $4,331.80.

The displayed outputs are about $405.53 per month and $4,331.80 in total interest. The total is calculated from the unrounded payment expression, so it can differ slightly from multiplying the displayed, cent-rounded payment by 60.

Assumptions

  • The interest rate is fixed for the full loan term.
  • Payments are equal monthly payments made at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12.
  • The estimate excludes fees, taxes, insurance, PMI, escrow, and any other charges or adjustments not entered as inputs.

How an Amortization Schedule Works

An amortization schedule divides each payment between interest and principal. Early in a level-payment loan, the balance is larger, so the interest portion is generally larger. As principal falls, less interest accrues each period and more of the same payment goes toward principal. The payment stays level in this simplified fixed-rate model, while its components change.

For the first month in the example, estimated interest is $20,000 × 0.0066667, or about $133.33. Subtracting that from a $405.53 payment leaves roughly $272.20 for principal. The new balance is about $19,727.80. Later rows repeat the calculation using the remaining balance. Minor cent-level differences can arise depending on whether interest is rounded each month or carried at more precision.

A complete schedule commonly includes the payment number or date, starting balance, payment amount, interest, principal repaid, and ending balance. The calculator inputs above determine the payment and aggregate interest; an individual loan’s actual schedule also depends on its payment dates, rounding, and contract provisions.

When to Use It and How to Read Results

Use an amortization calculator to understand the mathematical pattern of a fixed-rate loan or to estimate how the principal and interest portions change through time. It can also help explain why a loan’s total interest is not simply its APR multiplied by the principal: interest is charged periodically on the outstanding balance, which decreases as principal is repaid.

  • Monthly payment: the regular principal-and-interest payment estimated by the formula. It is not necessarily the full amount due if the loan has other charges.
  • Total interest: the estimated interest over all scheduled payments, assuming the rate and payment pattern remain unchanged.
  • Ending balance: a schedule’s projected remaining principal after a payment. It should generally decline under these assumptions.

For instance, changing the term while keeping principal and APR fixed changes both the monthly payment and total interest. A longer term spreads repayment across more payments; the exact result is determined by the formula, not by a promise about any particular lender’s offer.

Choosing Inputs and Common Limitations

Enter the amount actually borrowed, not a purchase price that includes a down payment unless that full amount is financed. Use the APR supplied for the specific loan and confirm whether it reflects the rate the contract uses for periodic interest. The term should be entered in years, with the calculator converting it to months.

  • Do not enter a monthly rate in the APR field; the formula divides the annual percentage by 12 and converts percent to a decimal.
  • Do not assume the estimate includes fees, insurance, taxes, or an escrow payment. Those are outside this calculation.
  • Variable rates, skipped or irregular payments, extra principal payments, payment holidays, and a final balloon payment are not represented by the level-payment formula.
  • A lender may use different day-count conventions, payment dates, rounding, or fee treatment. Compare the calculator’s assumptions with the loan disclosure.

A common misconception is that every payment on an amortizing loan reduces principal by the same amount. It does not: under a fixed payment and rate, the interest share usually falls over time and the principal share rises. Another point worth noting is that an amortization schedule is not the same as a payoff quote. A payoff amount may account for interest accrued since the last scheduled payment and other contract-specific items.

Frequently Asked Questions

What is an amortization schedule?
An amortization schedule is a table showing how scheduled payments are allocated between interest and principal and how the loan balance changes over time.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal rate by dividing it by 1,200, convert the term to monthly payments, and use the fixed-payment formula shown above. This method assumes equal end-of-month payments and a fixed rate.

Why does the interest portion change each month?
Interest is calculated on the remaining balance. As scheduled payments reduce principal, less interest accrues in later periods, leaving more of a level payment for principal.

Does the payment include taxes and insurance?
No. This calculator estimates the loan’s principal-and-interest payment only. Taxes, insurance, escrow, PMI, fees, and other charges are not included unless separately modelled.

Can I use this schedule for a variable-rate loan?
Only as a snapshot under a fixed-rate assumption. If the rate changes, the payment allocation and possibly the payment amount can change, so a single fixed-rate schedule will not represent the full loan.

Why might my lender’s numbers differ?
Actual figures can reflect payment dates, rounding, fees, rate conventions, and other loan terms that this simplified estimate does not model. This result is an estimate, and the lender’s disclosure gives the exact figures.

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 →