calculate-loan

01 Loan payments

Payment Schedule Calculator: Monthly Payments and Interest

Calculator No. 01-14570 · 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 payment schedule calculator estimates a loan’s fixed monthly payment and total interest from the amount borrowed, annual percentage rate (APR), and term. Enter those three figures to see the estimated payment and interest over the full term; the schedule assumes equal monthly payments and a fixed rate.

Formula

The calculator uses the standard amortizing-loan payment formula. It first converts the annual APR into a monthly rate, then calculates the level payment that would repay principal and interest over the specified number of months:

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

Total interest = (monthly payment × n) − P

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

The payment is rounded to the nearest cent before total interest is calculated. That makes the displayed total follow the rounded payment, as payment amounts normally do in a schedule. The formula applies when the rate is above zero; the calculator’s minimum APR is 0.01%.

Worked Example

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

  1. Substitute the values: payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  2. The unrounded result is approximately $405.5278, so the monthly payment rounded to cents is $405.53.
  3. Total of rounded payments = $405.53 × 60 = $24,331.80.
  4. Total interest = $24,331.80 − $20,000 = $4,331.80.

Actual statements can differ slightly because of payment dates, daily interest calculations, rounding practices, or other contract terms.

Assumptions

  • The interest rate remains fixed for the entire term.
  • Payments are equal, made monthly, and paid at the end of each monthly period.
  • Interest compounds monthly using APR divided by 12.
  • The calculation excludes fees, taxes, insurance, private mortgage insurance, and escrow unless included in the loan amount or payment by a separate calculation.

How to Use a Payment Schedule Calculator

Use the principal amount you expect to borrow, the APR supplied for the specific loan, and the repayment term in years. If you are examining an existing loan, use its current principal balance rather than the original amount. Ask the lender or check the loan disclosure for the rate and term that apply; the example’s 8% is only a neutral demonstration, not a statement about available rates.

The result summarizes a standard payment schedule but does not list each month individually. In a full amortization schedule, every payment is divided between interest and principal. Early payments generally allocate a larger portion to interest because the outstanding balance is larger; as principal is repaid, the interest portion typically falls and the principal portion rises. The exact split for a particular payment depends on the loan’s balance, rate, and calculation conventions.

  • Monthly payment: the estimated recurring principal-and-interest amount.
  • Total interest: the estimated interest paid across all scheduled payments, based on the rounded monthly amount.
  • Not the total cost of borrowing: fees and other charges may increase the amount paid, and they are not included here.

What the Result Does—and Does Not—Show

A payment estimate helps illustrate how principal, rate, and term interact. For a fixed principal and rate, extending the term generally lowers the calculated monthly payment but increases the number of payments over which interest accrues. A shorter term has fewer payments, but its calculated monthly amount is higher. These are mathematical effects, not a recommendation about which loan structure to use.

The total-interest figure is not a payoff quote. It assumes every scheduled payment is made on time, at the calculated amount, and that the loan is not changed or paid off early. Extra payments can alter the balance and interest, while missed or late payments may affect the actual schedule under the loan agreement. The calculator does not model either situation.

APR is an annualized rate used as an input here, but the calculation treats it as a nominal annual rate divided into 12 monthly periods. It does not separately account for how fees may be reflected in a lender’s disclosed APR. A loan with variable interest, irregular payment dates, a balloon payment, interest-only periods, or a payment that changes over time needs a different model or the lender’s own schedule.

Common Errors and Limitations

  • Entering the wrong principal: include only the amount being financed for this calculation. A down payment or trade-in can reduce a new loan’s principal; do not subtract it again if the figure entered is already the financed amount.
  • Mixing rate formats: enter 8 for 8%, not 0.08. The formula converts the percentage to a monthly decimal rate.
  • Confusing term units: the term field is in years. A 60-month term is five years, not 60 years.
  • Treating the payment as an all-in bill: housing costs may include taxes, insurance, or escrow, and other loans may have recurring charges. These are not captured by this calculator.
  • Expecting exact statement figures: lenders may use specific timing, rounding, and account rules. Use the loan disclosure or servicer’s schedule for contractual figures.

This is a general fixed-rate amortization estimate, not a tool for determining eligibility, approval, affordability, or the terms a lender will offer. To model fees, extra payments, changing rates, or a specific payment calendar, those details must be calculated separately using the applicable loan terms.

Frequently Asked Questions

What does a payment schedule calculator calculate?
It estimates a fixed monthly payment and total interest from a loan amount, APR, and term. This version does not produce a month-by-month table.

Does the monthly payment include taxes and insurance?
No. The payment shown covers calculated principal and interest only. Taxes, insurance, escrow, and fees are excluded.

Why can my lender’s payment differ from this estimate?
The lender may use different payment dates, rounding, fees, rate terms, or other loan features. Compare the calculator inputs with the loan disclosure and ask the lender how its payment is determined.

Does a longer loan term reduce total interest?
Not necessarily. With the same principal and fixed rate, a longer term usually lowers each scheduled payment but increases the number of periods during which interest accrues, so the calculated total interest is generally higher.

Can I use this for a variable-rate loan?
Only as a simplified snapshot using one assumed APR. It cannot account for future rate changes or payment adjustments.

Can I use the result as an exact payoff amount?
No. A payoff quote can depend on the date, accrued interest, and loan-specific charges or credits. Request an up-to-date payoff figure from the lender or servicer.

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 →