calculate-loan

01 Loan payments

Interest Amortization Table Calculator

Calculator No. 01-15476 · 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 interest amortization table shows how each scheduled loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual APR, and term to calculate the monthly payment and total interest; the table itself is built by applying the payment and interest formulas month by month.

Formula

This calculator uses the standard fixed-payment loan formula. It finds a monthly payment that pays interest due and gradually repays the starting principal over the selected number of months.

  • Monthly payment: M = P × r / [1 − (1 + r)−n]
  • Total interest: I = M × n − P
  • Monthly rate: r = APR / 1,200
  • Number of payments: n = years × 12

P is the original loan principal in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate as a decimal; n is the number of monthly payments; M is the monthly payment in dollars; and I is total interest in dollars. The payment is rounded to cents for display. The total-interest output uses that displayed, rounded payment multiplied by the number of payments, then subtracts the starting principal. Consequently, it is an estimate based on level payments, not a lender’s payoff quote.

Worked Example

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

  1. Convert APR to a monthly decimal rate: r = 8 / 1,200 = 0.0066667.
  2. Find the payment count: n = 5 × 12 = 60 months.
  3. Apply the payment formula: M = 20,000 × 0.0066667 / [1 − (1.0066667)−60] ≈ $405.53 per month.
  4. Calculate total interest using the rounded payment: I = $405.53 × 60 − $20,000 = $4,331.80.

The calculator therefore returns a monthly payment of $405.53 and estimated total interest of $4,331.80. A real schedule may differ by a few cents because payment dates, daily interest calculations, and the final payment can differ from this monthly model.

Assumptions

  • The interest rate stays fixed throughout the term.
  • Payments are equal, made monthly, and assumed to occur at the end of each monthly period.
  • Interest accrues monthly at APR divided by 12.
  • Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.

How to Read an Interest Amortization Table

A full table usually has one row per payment and columns for the payment number or date, opening balance, payment, interest portion, principal portion, and closing balance. To calculate a row, multiply the opening balance by the monthly rate to estimate that month’s interest. Subtract interest from the payment to get principal repaid, then subtract that principal from the opening balance.

For example, in the first month of the default illustration, interest is about $133.33 ($20,000 × 0.0066667). From a $405.53 payment, roughly $272.20 goes to principal, leaving a balance near $19,727.80. In later months, the balance is smaller, so the interest portion generally falls and the principal portion rises. With a fixed rate and level payment, the total payment stays the same even as its allocation changes.

The calculator provides the payment and total-interest summary rather than printing all 60 rows. You can construct each row with the method above, using the prior row’s closing balance as the next row’s opening balance. Minor rounding adjustments may be needed in the final row to bring the balance to zero.

When to Use the Calculator and What It Leaves Out

An amortization estimate is useful for understanding the scheduled cost of a fixed-rate, fully amortizing loan, checking a quoted payment, or seeing how the balance is expected to decline under regular payments. Enter the principal actually being financed, not an amount that includes costs unless those costs are financed into the loan. Use the APR and term from the lender’s documents or quote; the default figures are only an example.

This basic formula does not model a variable rate, interest-only period, balloon payment, irregular payment dates, skipped payments, extra principal, or a changing payment. It also does not determine an actual payoff amount. A payoff figure can include accrued interest through a particular date and other contract-specific amounts. For the exact schedule and payoff information, consult the lender’s disclosure or account documents.

Common Mistakes and Misconceptions

  • Confusing APR with a monthly rate: Enter APR as an annual percentage, such as 8, not 0.08 or 0.0067. The formula divides the percentage by 1,200.
  • Using the wrong term unit: The input is years. The formula converts years into monthly payments by multiplying by 12.
  • Assuming every payment goes to principal: Interest is charged against the remaining balance first; only the amount left from the payment reduces principal.
  • Treating total interest as every borrowing cost: This output excludes fees and other charges unless they are reflected in the amount and rate supplied.
  • Expecting the last cent to match a statement: The model rounds a fixed payment to cents and uses monthly accrual. A lender may use different timing or rounding conventions.

A common related question is whether the balance falls by the same amount each month. It does not in a standard level-payment schedule: the principal share usually grows over time because less interest is due as the balance declines.

Frequently Asked Questions

What is an interest amortization table?
A schedule showing each payment’s interest and principal portions and the remaining loan balance after payment.

How do I calculate the interest part of a payment?
Multiply the opening balance for that month by the monthly interest rate. For an APR quoted annually, this model uses APR divided by 12, with the percentage converted to a decimal.

Why does the principal portion increase over time?
As principal is repaid, the balance used to calculate interest gets smaller. With an unchanged payment and rate, less of each later payment goes to interest and more goes to principal.

Does this calculator create a complete amortization table?
It calculates the level monthly payment and estimated total interest. A row-by-row table can be generated by calculating each month’s interest and principal from the current balance.

Does the total interest include fees or insurance?
No. The estimate includes interest under the stated fixed-rate monthly model only; it excludes fees, taxes, insurance, PMI, and escrow.

The result is an estimate for educational purposes; 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 →