calculate-loan

01 Loan payments

Debt Repayment Calculator With Schedule

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

Monthly payment $405.53
Total interest
$4,331.80
= Monthly payment × repayment term × 12 − debt balance
Debt balance
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Debt balance ($), Interest rate (APR) (%), Repayment 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 debt repayment calculator with a schedule estimates your fixed monthly payment, total interest, and the balance after each payment. Enter the amount owed, annual percentage rate (APR), and repayment term to see a month-by-month amortization schedule; the schedule below is calculated from the same fixed-payment formula.

Formula

The calculator uses the fixed-payment loan formula. It assumes the balance accrues interest monthly and the same payment is made at the end of each month:

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

  • P is the starting debt balance in dollars.
  • APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
  • r is the monthly interest rate, calculated as APR ÷ 1,200.
  • n is the number of monthly payments, calculated as years × 12.

The payment is rounded to the nearest cent. Total interest is estimated as monthly payment × number of payments − starting balance. The schedule is built month by month: interest for a period is the prior balance multiplied by r; principal repaid is the payment minus that interest; and the next balance is the prior balance minus principal repaid. Small differences can arise in a real account because lenders may adjust the final payment or calculate interest using different dates and conventions.

Worked Example

Using the calculator’s default values: starting debt P = $20,000, APR = 8%, and term = 5 years.

  1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667.
  2. Number of payments: n = 5 × 12 = 60.
  3. Payment before rounding: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] ≈ $405.528.
  4. Monthly payment rounded to cents: $405.53.
  5. Total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

For an illustrative schedule, the first month’s interest is $20,000 × 0.0066667, or about $133.33. The principal portion is $405.53 − $133.33 = $272.20, leaving an estimated balance of $19,727.80. In month two, interest is calculated on that lower balance, so a slightly larger share of the unchanged payment goes toward principal. This pattern continues until the balance is repaid; a lender’s final payment may differ because of its precise interest calculations and rounding.

Assumptions

  • The APR remains fixed throughout the repayment term.
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR ÷ 12.
  • The calculation excludes fees, taxes, insurance, PMI, and escrow, as well as missed or extra payments.

How to Read a Repayment Schedule

A repayment schedule, also called an amortization schedule, separates each payment into interest and principal and shows the balance left after each period. Its common columns are payment number or date, starting balance, payment, interest, principal, and ending balance. The ending balance for one row becomes the starting balance for the next.

At the start of a conventional fixed-rate repayment, the balance is largest, so the interest portion is generally largest too. As principal is repaid, the balance falls and later interest charges shrink. The payment can stay level even though its internal split changes. A schedule is useful for understanding this progression and estimating a payoff timeline, but it is not an account statement or a promise of the exact amount due on a particular date.

When to Use It and What It Leaves Out

This calculator is designed for one debt repaid with equal monthly payments at a fixed APR. It can help translate a stated balance, rate, and term into a projected payment and a sequence of estimated balances. It can also provide a baseline for understanding how payments are allocated over time.

It does not combine multiple debts or determine a payoff strategy. For a credit card or other account where the payment changes, the rate varies, or new charges are added, a fixed-payment schedule may not represent what happens. To model such a debt, you would need to recalculate as the balance, payment, or rate changes, or use a calculator built for that payment structure. The calculator also cannot supply a lender’s rate, fees, or exact payoff quote: use the actual figures in the lender’s documents or request the current account details from the lender.

Common Calculation Problems

  • Entering APR as a decimal: Enter 8 for 8%, not 0.08. The formula converts the percentage to a monthly rate by dividing by 1,200.
  • Confusing years and months: The term field is in years. Five means 60 monthly payments, not five payments.
  • Assuming the whole payment reduces principal: Interest is paid first in each period under this schedule; only the remainder reduces the balance.
  • Treating a rounded estimate as an exact payoff amount: Payment dates, daily interest, fees, payment changes, and rounding can alter the amount due.
  • Assuming extra payments are included: This calculator assumes level payments only. Extra amounts can change the payoff date and interest, and their treatment depends on how the account applies them.

Frequently Asked Questions

How do I calculate a debt repayment schedule?
Start with the balance, APR, and number of monthly payments. Calculate the fixed payment with the amortization formula, then for every month calculate interest from the opening balance, subtract interest from the payment to find principal repaid, and subtract that principal from the balance.

Does the monthly payment include interest?
Yes. In this fixed-payment estimate, each payment includes that month’s interest and a portion of principal. The interest share is calculated from the outstanding balance and monthly rate.

Why does the schedule show more interest at the beginning?
Interest is calculated on the balance still owed. Since the balance is usually higher earlier in repayment, the interest portion is usually larger then; as principal falls, less interest accrues in later periods.

Can I use this calculator for credit card debt?
Only as a simplified estimate if the balance, APR, and payment remain consistent with the fixed-payment assumptions. Variable rates, changing payments, new purchases, and account-specific rules are not represented.

Why might my lender’s payoff amount differ?
A payoff quote can reflect the exact date of payment, interest accrued since the last payment, account terms, and any applicable charges. This calculator uses monthly periods and rounded payments, so it estimates rather than reproduces an account ledger.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Debt balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Repayment 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 →