A debt repayment schedule shows how each payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term to estimate the monthly payment and total interest; this calculator assumes equal monthly payments at a fixed rate.
Formula
The payment formula calculates a fixed monthly amount that pays down a balance over a set number of months, accounting for interest each month:
Payment = round[ P × r ÷ (1 − (1 + r)−n), 2 ]
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
- n is the number of monthly payments, calculated as loan term in years × 12.
- Payment is the monthly amount in dollars, rounded to the nearest cent.
For this schedule estimate, total interest is monthly payment × number of payments − principal. This uses the rounded monthly payment shown by the calculator. Actual loan statements may differ because of payment dates, rounding methods, fees, or other contract terms.
Worked Example
Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the payment count: 5 × 12 = 60 months.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month after rounding.
- Calculate total paid using the rounded payment: $405.53 × 60 = $24,331.80.
- Subtract principal: $24,331.80 − $20,000 = $4,331.80 total interest.
The estimated monthly payment is $405.53. The calculation uses the exact APR-based monthly rate internally and rounds the payment to cents for the total.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal, made monthly, and treated as occurring at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
How a Debt Repayment Schedule Works
At the start of a payment period, interest accrues on the outstanding balance. A payment first covers that period’s interest; the remainder reduces principal. Because the balance generally declines with each on-time payment, the interest portion usually shrinks over time while the principal portion grows. The scheduled payment remains level under the calculator’s fixed-rate assumptions.
For example, on a $20,000 balance at 8% APR, the first month’s estimated interest is about $133.33 ($20,000 × 8% ÷ 12). Of a $405.53 payment, about $272.20 then goes toward principal, leaving roughly $19,727.80. Later interest is calculated on the lower balance. Small differences can arise when a lender uses daily interest or a different rounding convention.
A full schedule lays out each period’s opening balance, payment, interest, principal reduction, and closing balance. This calculator gives the payment and total interest rather than listing every month. To build a month-by-month estimate, apply the same process repeatedly: calculate interest on the current balance, subtract it from the payment to find principal paid, then subtract that principal from the balance. The final payment may need adjustment for rounding.
Choosing Inputs and Reading the Estimate
Use the principal and APR that apply to the debt you are modelling, and enter the repayment term in years. APR is an annual percentage, not a monthly percentage: the calculator divides it by 1,200 to obtain a monthly decimal rate. If you have several debts with different balances or rates, calculate each separately; combining them into one balance and one rate will not reproduce their individual schedules.
- Principal: enter the amount being repaid, not the amount originally borrowed if payments have already reduced the balance.
- APR: use the rate relevant to the period being estimated. If it can change, one fixed-rate schedule cannot forecast later changes.
- Term: enter the remaining repayment period, not necessarily the original contract term.
- Outputs: monthly payment is the estimated level amount; total interest is the estimated interest across all scheduled payments.
For an existing debt, check whether the displayed payment matches the required payment on a current statement. If it does not, possible reasons include a different balance, rate, remaining term, payment frequency, or account charges. The calculator does not retrieve account data or determine a contractual amount.
Common Problems and Limits
A frequent mistake is treating APR as the monthly rate. At 8% APR, the monthly rate used here is approximately 0.6667%, not 8%. Another is assuming total interest is simply principal multiplied by APR and years: that ignores principal repayments along the way. The balance falls over time, so interest is calculated on a changing amount.
The estimate also assumes the same payment every month and no extra principal payments. Extra payments, missed or late payments, variable rates, fees added to the balance, and payment dates can all change the actual payoff path. If a payment is below the interest accruing in a period, the balance may not decline as expected; the fixed-payment formula should not be used as a guarantee of payoff for a changing or unusual arrangement.
Rounding matters over many payments. This calculation rounds the monthly payment to cents and multiplies that amount by the number of payments for total interest. A lender may calculate interest daily, round each period separately, or make a final payment that differs slightly. Use the lender’s account statement and loan disclosure for contractual figures.
Frequently Asked Questions
What is a debt repayment schedule?
A debt repayment schedule is a timeline showing planned payments and how each payment affects interest and the remaining principal. It may show one summary estimate or a separate line for each payment period.
How do I calculate a monthly debt payment?
Convert APR to a monthly decimal by dividing by 1,200, convert the term to months, and use the fixed-payment formula shown above. The result assumes a fixed rate and equal end-of-month payments.
Does this calculator show my exact payoff amount?
No. It estimates scheduled payments and interest using the inputs and assumptions listed here. A payoff quote can include accrued interest through a particular date and other contract-specific amounts not modelled by this calculator.
Why does the principal portion increase over time?
With a fixed payment and declining balance, each period generally accrues less interest. More of the same payment can therefore go toward principal as repayment progresses.
Can I use it for credit cards or variable-rate debt?
Only as a simplified illustration if you enter a balance, rate, and term. Credit-card payments and variable-rate debts may change over time, and this fixed-payment model does not represent their changing terms or payment rules.
This result is an estimate for education; 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 | $ | 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
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Game Schedule: Dates, Times and Where to Check
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate