calculate-loan

01 Loan payments

Loan Payment Table: Calculate Monthly Payments

Calculator No. 01-6524 · 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.

A loan payment table shows how each scheduled payment is divided between principal and interest, along with the remaining balance. Enter the loan amount, annual percentage rate (APR), and term below to calculate an estimated monthly payment and total interest; the table itself can then be built by applying the same amortization calculation to each month.

Formula

This calculator uses the fixed-payment amortization formula. It assumes equal monthly payments, a constant APR, and monthly periods. The payment is calculated as:

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

  • P is the starting principal, in dollars.
  • r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
  • n is the number of monthly payments, calculated as years × 12.

The displayed payment is rounded to the nearest cent. Total interest is estimated as the rounded monthly payment multiplied by the number of payments, minus the original principal. Real loan schedules can differ if the lender uses different payment dates, accrual conventions, rounding, or fees.

Worked Example

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

  1. Convert the 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 payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  4. The unrounded result is approximately $405.53, so the monthly payment is $405.53.
  5. Using the displayed, cent-rounded payment, total interest is ($405.53 × 60) − $20,000 = $4,331.80.

A payment table would show 60 rows, one for each scheduled payment. For the first month, interest is approximately $20,000 × 0.0066667 = $133.33. The principal portion is $405.53 − $133.33 = $272.20, leaving an estimated balance of $19,727.80. Later rows repeat the process using the previous row’s balance. Small differences from a lender’s final schedule can arise from rounding and payment timing.

Assumptions

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

How to Read a Loan Payment Table

A conventional amortization table commonly includes a payment number or due date, payment amount, interest charged, principal repaid, and ending balance. The scheduled payment generally stays level in this model, but the division between interest and principal changes over time.

  • Interest: The period’s interest is calculated from the balance before that payment.
  • Principal: The payment amount minus that period’s interest, assuming no separate charges.
  • Ending balance: The starting balance minus principal repaid.

At the beginning of a fully amortizing loan, the balance is larger, so the interest portion tends to be larger. As principal is repaid, the balance falls and a greater share of each level payment goes toward principal. This is why the payment amount alone does not show how quickly the debt is being reduced. A table also makes the expected payoff point and cumulative interest easier to inspect.

When This Estimate Is Useful

A payment table can help explain the mechanics of a loan offer, check how a stated term affects repayment, or show how scheduled payments reduce a balance. To estimate a particular loan, use the principal actually financed, the APR supplied in the lender’s disclosure, and the term expressed in years. If the term is given in months, divide it by 12 before entering it here.

Compare like with like when reviewing estimates: the same principal, rate basis, term, and payment frequency should be used. APR may reflect certain borrowing costs differently from a note or nominal interest rate, depending on the loan and disclosure. Do not substitute a quoted rate without checking which rate the lender provides and how it applies to the calculation. The calculator’s rate field is an input, not a claim about any current rate.

Common Errors and Limits

A frequent mistake is entering 8 instead of 0.08 into a formula that expects a decimal interest rate. This calculator asks for APR as a percentage and converts it internally, so enter 8 for 8% APR. Another mistake is using a term in months where years are required; a 60-month term should be entered as five years.

Rounding each month’s interest and principal to cents can make a manually constructed table differ by a few cents from an unrounded mathematical schedule. A lender may adjust the last payment to clear the remaining balance. The standard formula also does not model variable rates, interest-only periods, deferred payments, balloon payments, late charges, extra principal, or fees added to the balance. Such features require different calculations or additional inputs.

Extra payments generally change the balance and the future interest path, so a standard fixed-payment table will not show their effect. Likewise, this calculator does not determine the amount a person can borrow or whether an application will be approved. It provides arithmetic based only on the values entered; obtain the actual rate, fees, payment schedule, and other loan terms from the lender.

Frequently Asked Questions

What does a loan payment table show?
A loan payment table lists each planned payment and typically breaks it into principal and interest, then shows the balance remaining after the payment.

How do I calculate the monthly payment from a loan table?
For a fixed-rate loan with equal monthly payments, use the amortization formula with the principal, monthly rate (APR divided by 12), and number of monthly payments. The calculator above applies that formula.

Why does the interest portion decrease over time?
Interest for each period is calculated on the remaining balance. As scheduled principal payments reduce that balance, the next period’s interest charge generally falls.

Does the monthly payment include taxes and insurance?
Not in this calculation. It estimates principal and interest only; taxes, insurance, escrow, PMI, fees, and other charges are excluded.

Why might my lender’s table show a different amount?
Differences can result from the actual APR or financed amount, payment dates, daily versus monthly accrual, fees, rounding, or other contract terms. Check the lender’s disclosure for the exact schedule.

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 →