A repayment schedule maker estimates a loan’s level monthly payment and total interest from its principal, annual percentage rate (APR), and term. Enter those three figures to see the payment and interest estimate; the calculation assumes regular monthly payments and a fixed rate.
Formula
The calculator uses the standard fixed-payment amortization formula. It first calculates the monthly payment, rounds that payment to the nearest cent, then estimates total interest by subtracting the original principal from all scheduled payments.
Monthly payment: M = round(P × r ÷ [1 − (1 + r)−n], 2)
Total interest: I = M × n − P
- P is the loan principal, or amount borrowed, in dollars.
- APR is the annual percentage rate entered as a percentage per year.
- r is the monthly rate as a decimal: APR ÷ 1,200.
- n is the total number of monthly payments: loan term in years × 12.
- M is the rounded monthly payment in dollars.
- I is estimated total interest in dollars over the full term.
For the formula, the APR input is converted to a monthly decimal rate. For example, 8% becomes 0.08 ÷ 12, or approximately 0.006667 per month. The exponent uses the number of monthly payments, not the number of years.
Worked Example
Using the calculator’s default values—$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.
Monthly payment = round[20,000 × 0.0066667 ÷ (1 − (1 + 0.0066667)−60), 2] = $405.53.
Total interest = $405.53 × 60 − $20,000 = $4,331.80. This total uses the rounded monthly payment, as the calculator does. A lender’s final payment schedule can differ slightly because of payment dates, daily interest calculations, rounding conventions, or other contract terms.
Assumptions
- The interest rate stays fixed for the full repayment term.
- Payments are equal, made monthly, and paid at the end of each monthly period.
- Interest is modelled monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
What a Repayment Schedule Shows
A full repayment schedule, also called an amortization schedule, lists each payment period and divides each payment between interest and principal. Early in a typical fully amortizing loan, the balance is larger, so more of a level payment goes toward interest. As the balance declines, the interest portion generally falls and the principal portion rises. The payment stays level in this model, while its allocation changes.
This calculator returns the regular payment and aggregate interest rather than every row of the schedule. Those figures are useful for understanding the basic repayment pattern, but they do not show the exact date-specific balance after each payment. A detailed schedule requires the payment dates and the lender’s method for applying interest and rounding.
When to Use It and How to Read the Result
Use a repayment schedule maker to estimate the arithmetic of a fixed-rate loan or to see how principal, APR, and term feed into a level payment. Enter the principal amount, the APR supplied for the loan, and the term in years. The result is an estimate of the scheduled monthly amount, followed by estimated interest across all scheduled payments.
The monthly payment is not necessarily the entire amount due on a statement. A loan payment may be accompanied by separately assessed charges or related costs that this calculation does not model. Confirm which amounts are included in the loan’s quoted payment and use the lender’s figures where available. The calculator also assumes every payment is made on schedule and does not account for skipped or late payments.
The interest output is the sum implied by the same rounded monthly payment over the stated number of months. It is not an APR comparison or a forecast of a changing-rate loan. APR definitions and included charges can vary by product, so the APR entered should be the applicable figure from the lender’s disclosure.
Common Errors and Formula Limits
- Entering a percentage incorrectly: Enter 8 for 8%, not 0.08. The calculator converts the percentage to a monthly rate.
- Confusing years and months: The term field is in years. The formula multiplies it by 12 to determine payment count.
- Using a changing rate: A single fixed APR cannot represent a variable-rate loan whose rate changes during repayment.
- Expecting an exact payoff quote: Daily interest, payment dates, fees, and final-payment adjustments may affect the amount due.
- Assuming extra payments are included: Additional principal payments can change the payoff timeline and total interest, but this calculator assumes only the regular payment.
Because the payment is rounded to cents, multiplying it by the number of payments may not match a lender’s final total exactly. Some schedules adjust the final payment to clear a remaining small balance. The model also assumes a positive APR and a fully amortizing loan with equal monthly payments; it does not model interest-only periods, balloon payments, deferred interest, or irregular repayment dates.
Frequently Asked Questions
What is a repayment schedule maker?
It is a tool that estimates how a loan is repaid over time. Depending on the tool, it may calculate a payment, total interest, or a period-by-period breakdown of principal and interest.
How do I calculate a monthly loan payment?
Convert the APR to a monthly decimal rate by dividing by 1,200, convert the term to months, then apply the fixed-payment formula shown above. This calculator performs those steps and rounds the payment to cents.
Does the monthly payment include fees and insurance?
No. This estimate covers principal and interest under its assumptions. Check the lender’s disclosure or payment information for any additional amounts that may apply.
Can I use this for a variable-rate loan?
Only as a simplified estimate for a period when a particular rate applies. A single-rate calculation cannot account for future rate changes or the resulting payment adjustments.
Why might the lender’s schedule differ?
The lender may use exact payment dates, daily interest, different rounding rules, fees, or a final-payment adjustment. The contract and lender disclosure provide the applicable figures.
This result is an estimate for educational purposes; 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 Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate