A loan repayment simulator estimates your regular payment and total interest from the amount borrowed, annual percentage rate (APR), and loan term. Enter those figures to see an approximate monthly payment and the interest paid over the scheduled repayment period.
Formula
The simulator uses the standard fixed-rate, level-payment amortization formula. It first calculates the monthly payment, then subtracts the original principal from all scheduled payments to estimate total interest:
- Monthly payment: P × r ÷ [1 − (1 + r)−n]
- Total interest: M × n − P
Here, P is the loan principal in dollars, APR is the annual percentage rate entered as a percentage, r is the monthly rate (APR ÷ 1,200), n is the number of monthly payments (years × 12), and M is the monthly payment in dollars. The payment is displayed rounded to the nearest cent; total interest is calculated using that rounded payment.
Worked Example
Using the default inputs—$20,000, an 8% APR, and a five-year term:
- Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
- Convert the term to monthly payments: 5 × 12 = 60.
- Substitute into the payment formula: 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] = $405.53 per month, rounded to cents.
- Calculate total interest using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.
Assumptions
- The interest rate remains fixed for the full term.
- Payments are made monthly at the end of each period, with the first payment one month after borrowing.
- Interest compounds monthly at APR ÷ 12.
- The estimate excludes fees, taxes, insurance, PMI, and escrow because they are not inputs.
When to Use a Repayment Simulator
A simulator is useful for understanding how principal, rate, and term affect a scheduled payment. You can change one input at a time to see the mathematical effect. For example, a longer term generally spreads repayment across more months and lowers the calculated payment, while increasing the total number of periods during which interest accrues. A higher APR increases the payment and, under the same term and principal, the estimated total interest.
These comparisons are arithmetic, not a recommendation about which borrowing arrangement to choose. Use the actual figures supplied for the loan you are examining. If the rate, term, or amount changes later, the result may no longer describe the repayment schedule.
How to Read the Results
The monthly payment is the regular principal-and-interest amount implied by the inputs. Early in a typical amortizing schedule, a larger part of each payment goes toward interest; over time, the interest portion falls as the outstanding balance declines. The total-interest result is the sum of scheduled payments minus the amount borrowed, based on the rounded monthly payment.
That total is not the total cost of every loan-related expense. Upfront charges, recurring fees, optional products, or other amounts outside the formula are not included. A lender’s payment quote or disclosure may therefore differ, particularly if its calculation uses a different payment date, rate convention, rounding method, or included charges.
Common Problems and Limitations
- Entering APR incorrectly: Enter 8 for 8%, not 0.08. The formula converts the percentage to a monthly decimal rate.
- Mixing term units: This simulator asks for years and converts them to months. A 60-month term is five years, not 60 years.
- Assuming every loan is fixed-rate: The calculation holds the APR constant. It does not model a rate that changes over time, deferred payments, balloon payments, or an irregular schedule.
- Confusing payment with full housing or borrowing cost: The output is principal and interest only. Costs such as taxes, insurance, and escrow are excluded.
- Rounding differences: The displayed payment is rounded to cents. A lender may round each period or calculate using exact dates, so a final balance or interest total can differ slightly.
The formula is designed for a fully amortizing loan with equal monthly payments. It does not account for late payments, extra principal payments, payment holidays, fees financed into the balance unless included in the principal, or a payoff before the scheduled end. To estimate those situations, you need a calculator that explicitly models the relevant dates, fees, or additional payments.
Frequently Asked Questions
What information do I need for a loan repayment simulator?
Enter the amount borrowed, the APR as a percentage per year, and the loan term in years. For a closer estimate, use the principal, rate, and schedule shown in the lender’s documents.
Does the monthly payment include fees and insurance?
No. This calculation estimates principal and interest only. It does not include fees, taxes, insurance, PMI, or escrow.
Why can my lender’s payment differ from this result?
The lender may use different dates, rounding, included charges, or repayment terms. Check whether the quoted amount covers principal and interest alone and compare the assumptions before interpreting a difference.
Does a longer loan term always mean less interest?
No. A longer term often lowers the scheduled monthly payment for the same principal and APR, but it also means more payment periods. Under this fixed-rate formula, the total interest is determined by the payment schedule, so compare both outputs rather than the monthly amount alone.
Can I use this for a variable-rate loan?
Only as a snapshot using one assumed APR. Because the formula holds the rate constant, it cannot predict payments or total interest after the rate changes.
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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term