This calculator estimates a fixed-rate loan’s monthly payment and total interest from the loan amount, APR, and term. It also shows how the balance declines under level monthly payments; use the schedule and figures as arithmetic estimates, not as a lender’s final disclosure.
Formula
A loan repayment schedule is a dated or numbered list of required payments and how each payment is allocated. A standard amortizing schedule usually shows the payment, interest charged, amount applied to principal, and remaining balance for each period. This calculator gives the level monthly payment and total interest for a fixed-rate loan; the underlying schedule can be generated by repeating the balance calculation for each month.
For principal P, monthly interest rate r, and n monthly payments, the level payment is:
M = P × r ÷ [1 − (1 + r)−n]
- P is the starting loan principal, in dollars.
- APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
- r = APR ÷ 1,200 is the monthly rate as a decimal. The division by 100 converts percent to decimal, and by 12 converts annual to monthly.
- n = 12 × years is the number of monthly payments.
- M is the monthly payment, in dollars.
The calculator rounds M to cents. Its total-interest estimate is the rounded monthly payment multiplied by the number of payments, minus the original principal: interest = M × n − P. In an amortization table, month k’s interest is the opening balance multiplied by r; principal paid is M minus that interest; the closing balance is the opening balance minus principal paid. Actual contracts can differ because of rounding, payment dates, fees, or other terms.
Worked Example
Using the calculator’s defaults: P = $20,000, APR = 8%, and term = 5 years.
- Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
- Find the number of monthly payments: n = 5 × 12 = 60.
- Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 per month, rounded to cents.
- Calculate total paid using that rounded payment: $405.53 × 60 = $24,331.80.
- Subtract the principal: $24,331.80 − $20,000 = $4,331.80 total interest.
The payment includes both interest and principal. At the start, the monthly interest is approximately $20,000 × 0.0066667 = $133.33, leaving about $272.20 of the $405.53 payment to reduce principal. Later, interest is calculated on a smaller balance, so more of a level payment goes to principal. Small differences in a real final payment can arise from cent rounding and payment timing.
Assumptions
- The interest rate is fixed for the full term.
- Payments are monthly, equal, and made at the end of each monthly period.
- Interest is modelled monthly at APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and any extra payments because they are not inputs.
How to Read a Repayment Schedule
A full schedule normally has one row per payment period. Common columns include the payment number or due date, opening balance, scheduled payment, interest, principal, and closing balance. The row’s principal and interest portions should add to the payment, subject to rounding; the ending balance becomes the next row’s opening balance.
For example, if a row begins with a $10,000 balance and applies a monthly rate of 0.5%, its interest portion is $50. If the payment is $300, then $250 reduces principal and the new balance is $9,750. This is an illustration of the allocation method, not an additional calculator result. A schedule makes the timing of repayment visible, but it is not necessarily the same thing as the payoff quote on a particular date, which may include accrued interest or contract-specific amounts.
When the Estimate Is Useful—and Its Limits
Use the calculation to understand the relationship among principal, rate, and term, or to check the basic payment arithmetic against figures supplied in loan documents. Enter the actual principal, APR, and repayment term from the relevant disclosure when available. The default rate is only an example input; it does not describe a current, typical, or offered rate. Obtain the applicable rate, payment amount, and charges from the lender.
This formula applies to a fully amortizing loan with a fixed rate and regular monthly payments. It does not produce the exact schedule for a variable-rate loan, an interest-only period, irregular payment dates, a balloon payment, or a loan with fees folded into the balance. APR may also reflect costs differently from the periodic interest rate used in a particular payment calculation; the lender’s disclosed payment terms control. A schedule using unrounded intermediate values can differ slightly from one that rounds interest every month.
Common Mistakes and Related Terms
- Confusing APR with the monthly rate: enter APR as a percentage, not as a decimal monthly rate. The formula converts it to a monthly decimal.
- Using years where months are required: this calculator accepts years and converts them to 12 payments per year.
- Assuming total interest is the same as total paid: total paid includes the principal; estimated interest is total paid minus principal.
- Treating the schedule as a payoff quote: a schedule is a planned repayment breakdown. A payoff figure for a date may account for timing or charges this estimate omits.
“Loan repayment schedule” is a standard descriptive finance phrase, not slang or a nonstandard word. “Schedule” comes through Old French from Latin scedula, a small sheet or slip of paper; “repayment” combines “repay” with the noun-forming suffix “-ment.” In ordinary use, someone might write, “Please review the loan repayment schedule to see how much of each monthly payment reduces the balance.” The phrase can mean the timetable of due dates, the payment breakdown, or a document containing both; context clarifies which.
Frequently Asked Questions
What does a loan repayment schedule show?
A typical amortization schedule lists each payment period, the payment amount, interest, principal reduction, and remaining balance. Some schedules show only due dates and amounts.
Is a repayment schedule the same as an amortization schedule?
Not always. “Amortization schedule” specifically describes the period-by-period allocation of payments between principal and interest. “Repayment schedule” can be used more broadly for the repayment timetable or breakdown.
Why does the interest portion change if my payment stays the same?
With a fixed rate, interest is calculated on the outstanding balance. As principal falls, the interest charged generally falls too, leaving a larger share of each level payment for principal.
Does this calculator include extra payments or fees?
No. It models regular level payments and excludes extra payments and fees. Those can change the balance, payment allocation, or total amount paid.
Why might my lender’s schedule differ?
Differences can result from the contract’s rate and payment dates, rounding method, fees, variable-rate changes, or other loan features. Check the lender’s disclosure for the exact terms and figures.
This result is an estimate, and 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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 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