Ms. Santos is a financial advisor specializing in amortization and accelerated mortgage payoff strategies, ensuring calculations related to prepayment and interest savings are precise and actionable.
The **Mortgage Prepayment Calculator** helps you analyze the impact of making extra payments toward your loan principal. It solves for the **Initial Principal ($P$)**, **Extra Monthly Payment ($M_{extra}$)**, **Total Interest Saved ($I_{saved}$)**, or the **Time Saved ($T_{saved}$) ** (in months), provided you enter the other three variables.
Mortgage Prepayment Calculator
*Enter any 3 values to solve for the 4th. The primary result is the new payoff term or savings.
Prepayment Formulas & Logic
This calculator relies on the standard loan payment formula ($M_{base}$) to determine the original payoff term, and then recalculates the new term ($T_{new}$) based on the accelerated payment ($M_{accel} = M_{base} + M_{extra}$).
1. Original Monthly Payment ($M_{base}$):
$$ M_{base} = P \frac{i(1+i)^{T_{orig}}}{(1+i)^{T_{orig}} - 1} $$
2. New Payoff Term ($T_{new}$ months):
$$ T_{new} = \frac{\ln\left(\frac{M_{accel}}{M_{accel} - P \times i}\right)}{\ln(1 + i)} $$
Where $i$ is the monthly rate and $M_{accel} = M_{base} + M_{extra}$.
Formula Source: Bankrate (Mortgage Calculator Logic)
Variables Explained
- $P$ (Initial Principal): The total amount of money initially borrowed for the mortgage. (F in input map)
- $R$ (Annual Interest Rate): The yearly interest rate on the loan. (P in input map)
- $T_{orig}$ (Original Loan Term): The number of years the loan was originally scheduled to last. (V in input map)
- $M_{extra}$ (Extra Monthly Payment): The fixed extra amount paid toward the principal each month. (Q in input map)
Related Calculators
Strategize your mortgage and loan payoff with these tools:
- Monthly Payment Calculator
- Interest Paid Calculator
- Loan Principal Calculator
- Amortization Period Calculator
What is Mortgage Prepayment?
**Mortgage Prepayment** involves making payments that exceed the minimum required monthly principal and interest amount, accelerating the reduction of the loan’s outstanding balance. By applying extra money directly to the principal, the borrower reduces the base on which interest is calculated in subsequent periods. This is a highly effective strategy for minimizing the total interest paid over the life of the loan.
The two main benefits of prepayment are **Total Interest Saved** and a **Shorter Loan Term (Time Saved)**. Even small, consistent extra payments can shave years off a 30-year mortgage and result in tens of thousands of dollars in savings. However, borrowers must ensure their loan agreement does not include a **prepayment penalty** before adopting this strategy.
Common prepayment methods include adding a fixed extra amount to the monthly payment, making a lump-sum payment once a year (e.g., with a bonus), or adopting a bi-weekly payment schedule (which results in one extra full payment per year). This calculator analyzes the most common strategy: adding a fixed extra amount to the principal each month.
How to Calculate Prepayment Savings (Example)
Scenario: \$200,000 loan, 6% rate, 30 years (original term $T_{orig}=360$ months). The original monthly payment is \$1,199.10.
- Identify the Accelerated Payment:
Borrower decides to pay an extra \$100 ($M_{extra}$) toward the principal each month. The new accelerated payment ($M_{accel}$) is $\$1,199.10 + \$100.00 = \$1,299.10$.
- Calculate New Term ($T_{new}$):
Using the new payment in the payoff term formula, the loan is found to be paid off in approximately **314 months** (26.17 years).
- Determine Time Saved and Total Interest Saved:
Time Saved ($T_{saved}$) = $360 – 314 = 46$ months (3.83 years).
Original Total Interest: $\$1,199.10 \times 360 – \$200,000 = \$231,676$.
New Total Interest: $\$1,299.10 \times 314 – \$200,000 = \$207,617$.
- Conclusion:
Total Interest Saved is $\approx \$24,059$. The loan is paid off almost 4 years early.
Frequently Asked Questions (FAQ)
Yes, but you must clearly instruct your lender that the extra funds are to be applied specifically to the principal balance, not held for the next month’s payment. If you don’t specify, it may be treated as a prepayment of the *next* installment.
Q: What is a bi-weekly payment plan?A bi-weekly plan involves making half the monthly payment every two weeks, resulting in 26 half-payments, or 13 full monthly payments, per year. This is one method of forced prepayment.
Q: Should I prepay my mortgage or invest the money elsewhere?This is the “mortgage vs. investment” dilemma. If the expected rate of return on an investment is reliably higher than your mortgage’s interest rate, investing is mathematically superior. However, prepaying the mortgage offers a guaranteed, tax-free return equal to your mortgage rate (risk-free).