A repayment schedule is a plan showing when loan payments are due and how each payment is allocated, commonly between principal and interest. This calculator estimates the monthly payment and total interest for a fixed-rate loan; enter the loan amount, annual percentage rate (APR), and term to see the results.
Formula
The calculator assumes equal monthly payments on a fixed-rate loan. It calculates the payment using the standard amortizing-loan formula, then estimates total interest from the rounded monthly payment:
- Monthly payment: M = round[P × r / (1 − (1 + r)−n), 2]
- Total interest: I = M × n − P
- Monthly rate: r = APR / 1,200
- Number of payments: n = years × 12
P is the starting loan principal in dollars, APR is the annual percentage rate entered as a percent per year, r is the monthly interest rate as a decimal, n is the number of monthly payments, M is the payment rounded to cents, and I is estimated total interest in dollars. The APR is divided by 1,200 to express a nominal annual rate as a monthly rate under this model.
Worked Example
Using the defaults—$20,000 principal, 8% APR, and a five-year term:
- Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of payments: 5 × 12 = 60.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 when rounded to cents.
- Calculate interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The estimated payment is $405.53 per month, and estimated total interest is $4,331.80. Actual schedules can differ slightly because lenders may calculate interest and handle rounding according to the loan contract.
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 accrues monthly using APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, and escrow because they are not inputs.
- There are no missed, late, or extra payments, and the loan is repaid over the entered term.
What a Repayment Schedule Shows
A full repayment schedule, often called an amortization schedule, lays out each payment by date or payment number. Typical columns show the payment amount, interest charged for that period, principal repaid, and remaining balance. Some schedules also show cumulative interest and principal paid.
At the start of a standard amortizing loan, the balance is relatively high, so interest generally makes up a larger share of each level payment. As principal falls, the interest portion usually shrinks and more of the same payment goes toward principal. Near the end, most of each payment is principal, and the balance approaches zero after the final scheduled payment.
For example, a $400 payment is not necessarily $400 of debt reduction. If $120 is interest for that period, about $280 goes toward principal, before any separately charged amounts. The lender’s schedule or account statement is needed to see the actual breakdown.
How to Read and Use the Estimate
Use the monthly payment as the modeled amount due for principal and interest, not necessarily the entire bill. A mortgage payment, for example, may have separate charges for taxes or insurance, while other loans can include fees or different payment arrangements. Check the contract and lender disclosures for the scheduled amount, due dates, and payment application rules.
Total interest is the estimated interest paid across all modeled monthly payments. It is not the total amount repaid: estimated principal plus interest is $24,331.80 in the worked example. Since the calculator rounds the monthly payment to cents and multiplies that rounded figure by the number of payments, the result can differ from a lender’s final amount by a small rounding adjustment.
The schedule is useful for understanding the timing of payments and how a loan balance changes under stated assumptions. To create a period-by-period schedule, the recurring calculation is:
- Interest for a period = starting balance × monthly rate.
- Principal paid = scheduled payment − period interest.
- Ending balance = starting balance − principal paid.
These steps repeat for each payment. The last payment may be adjusted to clear the remaining balance, depending on the lender’s rounding and servicing methods.
Common Questions About Repayment Schedules
A repayment schedule is not the same as a list of due dates alone. Due dates tell you when to pay; an amortization schedule also estimates how each payment affects principal, interest, and the remaining balance. A schedule may include additional charges if the loan documents or servicing system show them.
Another common misconception is that the APR always captures every cost in the same way for every loan. This calculator uses APR as the rate input in a simplified monthly-interest formula; it does not add upfront charges or model every method used to calculate an advertised APR. Use the lender’s disclosed figures for the contract-specific schedule.
Extra payments can change the balance and future interest, but their effect depends on when they are made and how the lender applies them. This calculator has no extra-payment input, so its results assume only the regular payment. Likewise, a variable-rate loan cannot be represented accurately by one fixed APR if its rate changes during the term.
Frequently Asked Questions
What does repayment schedule mean?
A repayment schedule is a timetable of loan payments showing when they are due and, for an amortizing loan, how much of each payment goes to interest and principal.
Is a repayment schedule the same as an amortization schedule?
The terms are often used interchangeably for a loan schedule that breaks payments into principal, interest, and remaining balance. A repayment schedule can also refer more broadly to payment timing and amounts.
Does the monthly payment include interest?
In a standard amortizing loan, the scheduled payment includes principal and interest. Other charges may be billed separately or included in a broader bill, so check the loan documents.
Why does the interest portion change over time?
With a fixed rate and level payments, interest is calculated on the outstanding balance. As the balance declines, the interest portion generally declines and the principal portion increases.
Can I use this calculator for a variable-rate loan?
Only as a simplified estimate for a period with a specified rate. A changing rate can alter payment amounts, payoff timing, or both, and is not modeled here.
Does this schedule include extra payments or fees?
No. It assumes regular equal monthly payments and excludes extra payments, fees, taxes, insurance, PMI, and escrow.
This result is an estimate; 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 Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate