Monthly Loan Overpayment Comparison

Calculate using the labelled inputs: Monthly Loan Overpayment Comparison.

Payoff months without extra payments
10
Payoff months with entered extra payments
7
Interest without extra payments
0.00
Interest with extra payments
0.00
Modeled interest saved
0.00
Whole months saved
3

Calculation and assumptions

r=annual/1200; interest_m=round(balance_(m−1)·r,2); payment_m=min(regular+extra,balance_(m−1)+interest_m); balance_m=balance_(m−1)+interest_m−payment_m.

The lump payment reduces principal before the first interest charge and cannot exceed it. Regular payment stays fixed; extra monthly payments follow each interest charge. Interest rounds monthly, halves away from zero. A dash means that scenario does not reduce principal or remains unpaid after 1200 months; savings require both scenarios to finish. No payment recasting, penalties, fees or lender-specific rules. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

r=annual/1200; interest_m=round(balance_(m−1)·r,2); payment_m=min(regular+extra,balance_(m−1)+interest_m); balance_m=balance_(m−1)+interest_m−payment_m.

What assumptions apply?

The lump payment reduces principal before the first interest charge and cannot exceed it. Regular payment stays fixed; extra monthly payments follow each interest charge. Interest rounds monthly, halves away from zero. A dash means that scenario does not reduce principal or remains unpaid after 1200 months; savings require both scenarios to finish. No payment recasting, penalties, fees or lender-specific rules. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →