A repayment schedule example shows how each loan payment is divided between interest and principal, and how the balance falls over time. Enter the loan amount, annual percentage rate (APR), and term below to estimate the monthly payment and total interest; the schedule example later shows the month-by-month method.
Formula
For a fixed-rate loan with equal monthly payments, the scheduled payment is calculated using the amortizing-loan formula:
Payment = P × r ÷ [1 − (1 + r)−n]
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200. The APR input is a percentage per year.
- n is the number of monthly payments: loan term in years × 12.
The calculator rounds the monthly payment to the nearest cent. It then estimates total interest as monthly payment × number of payments − principal. Because this total uses the rounded payment, a lender’s final payment or total may differ slightly if it adjusts the last installment or uses different rounding conventions.
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.
- Payment = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60].
- The unrounded result is about $405.527; rounded to cents, the estimated monthly payment is $405.53.
- Total of scheduled payments = $405.53 × 60 = $24,331.80.
- Estimated total interest = $24,331.80 − $20,000 = $4,331.80.
The figures are an illustration of the formula, not a lender quote. A full schedule can be constructed by applying the monthly interest calculation and principal reduction repeatedly.
Assumptions
- The interest rate remains fixed for the entire term.
- Payments are equal, made monthly, and treated as occurring at the end of each monthly period.
- Interest is calculated monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, and any charges not entered as part of the loan principal.
Repayment Schedule Example
For each month, calculate interest on the balance at the start of that month. Subtract that interest from the payment to find the amount that reduces principal. Then subtract the principal portion from the opening balance. With the example’s $20,000 balance, 8% APR, and $405.53 payment, the first months look approximately like this:
- Month 1: Interest is $20,000 × 0.08 ÷ 12 = $133.33. Principal repaid is $405.53 − $133.33 = $272.20. The new balance is about $19,727.80.
- Month 2: Interest is about $19,727.80 × 0.08 ÷ 12 = $131.52. Principal repaid is about $274.01, leaving a balance of about $19,453.79.
- Month 3: Interest is about $19,453.79 × 0.08 ÷ 12 = $129.69. Principal repaid is about $275.84, leaving a balance of about $19,177.95.
Amounts are rounded to cents here, so a displayed schedule may vary by a cent as rounding is applied at each step. Early in a standard amortizing loan, the balance is larger and therefore the interest portion tends to be larger. As the balance declines, less interest accrues and more of the same payment goes to principal. The final installment may be adjusted to clear the remaining balance exactly.
How to Use and Read the Estimate
Enter the principal actually being financed, not necessarily the item’s purchase price. If fees are added to the loan, include them in the principal only when they are part of the amount borrowed. Enter the APR as a percentage—for example, enter 8 for 8%, not 0.08—and the term in years.
The monthly payment is the scheduled installment under the assumptions above. Total interest estimates the cost of borrowing over all scheduled payments; it is not the same as the total amount repaid, which is principal plus interest. The calculator does not produce an individualized, dated statement: payment due dates, daily accrual practices, rounding, and payment posting can affect an actual account balance.
What Changes a Repayment Schedule?
The schedule depends on the loan’s principal, rate, payment amount, and timing. A longer term generally spreads repayment over more installments, while the rate and starting balance determine how much interest accrues during each period. Those relationships are mathematical; this calculator does not determine whether any loan is appropriate for a particular person.
Extra payments can change a real schedule, but their effect depends on how the servicer applies them. A payment may be treated as an early installment, credited toward principal, or handled under another arrangement. The calculator assumes no extra payments, skipped payments, rate changes, late charges, or refinancing. To model a changed schedule accurately, use the lender’s current balance and payment-allocation details rather than assuming every additional amount immediately reduces principal.
Common Mistakes and Limits
- Confusing APR and monthly rate: The example converts 8% annually to 8 ÷ 12 = 0.6667% monthly, or 0.006667 as a decimal.
- Using the wrong term unit: This calculator asks for years; the formula converts years to months. A 60-month term is five years.
- Assuming the payment covers everything: Taxes, insurance, account fees, and other costs are not included unless incorporated into the principal or another model input.
- Expecting an exact payoff quote: The estimate does not account for a specific payment date, accrued interest since the last payment, or a lender’s rounding and servicing practices.
The formula is for a fixed rate and level monthly payments. It does not directly model variable-rate loans, interest-only periods, irregular installments, balloon payments, or payment holidays. For those cases, the payment pattern must be calculated using the relevant contract terms.
Frequently Asked Questions
What is a repayment schedule?
A repayment schedule lists each installment and typically shows its date, payment amount, interest portion, principal portion, and remaining balance.
How do I calculate the interest portion of a monthly payment?
Multiply the balance at the start of the month by the monthly interest rate. For a simple APR-based estimate, convert APR to a decimal and divide by 12.
Why does more of the payment go to principal later?
With a fixed payment and rate, the outstanding balance generally declines. Since monthly interest is calculated on that balance, the interest portion falls and the remaining portion of the payment reduces principal.
Does the schedule include fees or insurance?
No. This example estimates principal and interest only. Review the lender’s disclosure for any separately charged amounts and the complete payment details.
Why might my lender’s numbers differ?
The lender may use different payment dates, rounding, accrual methods, fees, or loan terms. The lender’s disclosure gives the exact figures. This result is an estimate, not financial advice.
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 Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate