calculate-loan

01 Loan payments

Repayment Schedule Calculator: Payments and Interest

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

Monthly payment $405.53
Total interest
$4,331.80
= 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.

This repayment schedule calculator estimates the fixed monthly payment and total interest for a fully amortizing loan. Enter the loan amount, annual percentage rate (APR), and term in years; the results show the payment and the interest paid over the scheduled term.

Formula

The calculator uses the standard fixed-payment amortization formula. It first calculates the level monthly payment, rounds that payment to the nearest cent, then subtracts the original principal from the total of all scheduled payments to estimate total interest.

Monthly payment: M = round[P × r / (1 − (1 + r)−n), 2]

Total interest: I = M × n − P

  • P is the amount borrowed, in dollars.
  • APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
  • r is the monthly rate as a decimal: APR ÷ 1,200.
  • n is the number of monthly payments: loan term in years × 12.
  • M is the monthly payment in dollars, rounded to cents.
  • I is estimated total interest in dollars, using the rounded monthly payment.

The payment equation spreads repayment across equal monthly installments. Each installment covers interest accrued for the period and reduces the principal. Early in the schedule, a larger share of a payment generally goes to interest; as the balance falls, more goes to principal.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term—the schedule has 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667.

  1. Substitute the values: M = round[20,000 × 0.0066667 ÷ (1 − (1.0066667)−60), 2].
  2. The unrounded payment is about $405.53, so the monthly payment is $405.53.
  3. Total scheduled payments are $405.53 × 60 = $24,331.80.
  4. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.

Assumptions

  • The interest rate stays fixed for the full term.
  • Payments are equal, made monthly, and paid at the end of each monthly period.
  • Interest compounds monthly using the entered APR divided by 12.
  • The calculation does not include fees, taxes, insurance, PMI, escrow, late charges, or other costs.

How to Read a Repayment Schedule

A full repayment schedule, also called an amortization schedule, lays out each payment period and the resulting balance. For each month, interest is calculated on the outstanding principal, the payment is applied, and the remaining amount becomes the next period’s balance. This calculator summarizes the regular payment and total interest; it does not display every row of that month-by-month table.

For example, at the start of the default example, estimated first-month interest is $20,000 × 0.0066667, or about $133.33. Of the $405.53 payment, roughly $272.20 goes toward reducing principal. In later months, interest is calculated on a smaller balance, so the principal portion generally grows. Small differences can appear in a lender’s detailed schedule because of exact posting dates, daily interest, payment rounding, or a final adjustment.

The total-interest result is the estimated interest across all scheduled payments, not the total amount repaid. Add the principal to that figure to see the modeled total repayment. Because the calculation uses the payment rounded to cents, multiplying that displayed payment by the number of months gives the total used in the result.

When to Use It and What It Leaves Out

Use this calculation to understand the basic repayment pattern for a fixed-rate, fully amortizing loan when the principal, APR, and term are known. It can also help illustrate how changing one input changes the arithmetic: a larger principal or longer term affects the payment and total interest differently, while a different APR changes the monthly interest rate. Treat each result as a mathematical estimate, not a statement about an available loan or a personal borrowing decision.

Get the actual APR, fees, payment frequency, and repayment conditions from the lender’s own disclosure. An APR may incorporate certain borrowing costs under the lender’s calculation, but this simple formula does not separately model fees or every method used to determine APR. A variable rate, interest-only period, deferred payments, balloon payment, irregular payment dates, or extra payments can produce a different schedule.

Extra payments are especially important to model separately. If they are applied to principal, they may change the remaining balance and the time required to repay; if they are handled differently, the outcome may differ. This calculator assumes only the equal monthly payment and does not infer how any additional amount would be credited.

Common Calculation Issues

  • Entering APR as a decimal: Enter 8 for 8%, not 0.08. The formula converts the percentage to a monthly decimal rate.
  • Confusing years and months: The term field is in years, and the formula multiplies it by 12. A five-year term means 60 monthly payments.
  • Comparing different loan structures: The standard formula assumes fixed-rate, fully amortizing payments. It does not represent every contract simply because a payment amount is shown.
  • Expecting exact lender totals: Dates, rounding, fees, and servicing conventions may change the actual amount due or the final payment.

The APR input must be greater than zero because this version uses a positive-rate payment formula. The maximum inputs are calculator limits; they are not claims about what a lender offers. The result is an estimate and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What is a repayment schedule?
A repayment schedule shows when payments are due and how each one is divided between interest and principal, along with the remaining balance. A month-by-month schedule is commonly called an amortization schedule.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal rate by dividing by 1,200, convert the term to months, and use the fixed-payment formula shown above. This calculator performs those steps and rounds the payment to cents.

Does the total interest include the amount borrowed?
No. Total interest is the estimated cost of interest only. The total of scheduled payments includes both principal and interest.

Why might my lender’s payment differ?
The lender may use different payment dates, rounding, fees, a variable rate, or a different repayment structure. Compare the assumptions and figures in the loan disclosure with this estimate.

Does this calculator include extra payments?
No. It assumes equal monthly payments and no additional principal payments. Extra payments can change the balance path and payoff timing, depending on how they are applied.

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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 →