A home refinance calculator with prepayment estimates the new loan’s monthly principal-and-interest payment, total interest, and balance after a planned lump-sum payment. Enter the refinance loan amount, annual APR, term, and prepayment details to see how an extra payment changes the projected balance and interest; results are estimates, not lender quotes.
Formula
The calculator first computes a level monthly payment for the refinanced principal. It then estimates the loan balance immediately after the specified prepayment and the interest that the prepayment may avoid if the original monthly payment and end date are otherwise unchanged.
- Monthly rate, r = APR ÷ 1,200, where APR is the annual percentage rate entered as a percent.
- Number of monthly payments, n = term in years × 12.
- Monthly payment = round to cents of P × r ÷ [1 − (1 + r)−n]. P is the refinance loan amount in dollars.
- Balance before prepayment at month k = P(1 + r)k − M × [(1 + r)k − 1] ÷ r. M is the rounded monthly payment, and k is the month selected.
- Balance after prepayment = balance before prepayment − E, where E is the prepayment amount in dollars.
- Estimated interest reduction = E × [(1 + r)(n − k) − 1]. This assumes the prepayment reduces principal at month k and regular payments continue at M through the original scheduled term.
All rates and terms are inputs, not market quotations. The calculator treats the entered APR as a fixed nominal annual rate divided into monthly periods. It does not infer the loan’s exact payoff date or model lender-specific payment allocation.
Worked Example
Using the calculator’s exact defaults: P = $300,000, APR = 6%, term = 30 years, E = $10,000, and k = 60 months.
- Monthly rate: r = 6 ÷ 1,200 = 0.005. Number of scheduled payments: n = 30 × 12 = 360.
- Monthly payment: round [$300,000 × 0.005 ÷ (1 − 1.005−360)] to cents = $1,798.65.
- Balance just before the prepayment at month 60: $300,000 × 1.00560 − $1,798.65 × [(1.00560 − 1) ÷ 0.005] ≈ $278,939.70.
- Balance after the $10,000 prepayment: $278,939.70 − $10,000 = $268,939.70.
- Estimated interest reduction: $10,000 × [(1.005300) − 1] ≈ $34,818.67.
Displayed balances and savings are rounded to cents; calculations may have tiny differences if an intermediate value is rounded differently. The interest-reduction figure is a mathematical projection under the stated assumptions, not a promise of realized savings.
Assumptions
- The refinance has a fixed APR and level monthly principal-and-interest payments.
- Payments are monthly; the prepayment is applied at the end of the selected payment month, after that month’s scheduled payment.
- Interest compounds monthly at APR ÷ 12, with no daily-interest adjustments.
- The estimate excludes refinance fees, closing costs, taxes, insurance, mortgage insurance, escrow, and any charge or restriction related to prepayment.
How to Use a Refinance Calculator With Prepayment
Use the principal amount you expect to borrow in the refinance, not necessarily the home’s value or your current mortgage balance. If fees are financed into the new loan, include them in the loan amount only if that matches the quote you are examining. Enter the APR and term shown in the lender’s written estimate, then enter the amount and month of the additional principal payment you want to examine.
- Choose a prepayment month between 1 and the number of scheduled months. Month 60 means the payment is made after five years of monthly payments.
- Enter zero if you want to see the balance without a lump-sum prepayment.
- Check that the prepayment is not larger than the balance at that point. This calculator does not prevent an overpayment from producing a negative balance.
- Compare results using the same loan amount, APR, term, payment timing, and fee treatment. Changing several inputs at once makes it difficult to identify what caused a difference.
Understanding the Results and the Prepayment Misconception
The monthly payment output is the scheduled principal-and-interest amount; it does not include property-related costs that may be collected with a mortgage payment. The balance output is a snapshot after the lump sum is subtracted. The interest-reduction output estimates avoided interest over the remaining scheduled months, assuming the payment lowers principal and monthly payments are not recalculated.
A lump-sum prepayment does not automatically lower the required monthly payment. In this model, the regular payment stays the same, so the principal is paid down sooner and less interest accrues. A lender may handle an extra payment differently, and a loan could have a recast or other payment-change option subject to its own terms. Ask the servicer how to designate an extra payment as principal and how the payment will affect the account.
The savings number is not the refinance’s overall financial benefit. To assess the full refinance transaction, compare the new loan’s total costs and payment schedule with the existing loan over the period you expect to keep it. That broader comparison requires inputs such as closing costs, remaining balance, current payment, and time horizon, which this calculator does not collect.
Costs, Comparisons, and Calculator Limits
Refinancing replaces an existing loan with a new one, so the amount borrowed, rate, term, and fees may all differ. A lower monthly payment alone does not show whether the total interest or total cost is lower: extending the repayment period can reduce the payment while increasing the number of months interest accrues. Conversely, a shorter term can raise the monthly payment while reducing the time interest is charged. Calculate and compare using actual loan disclosures rather than assumed fees or rates.
This tool models one lump-sum prepayment at one month and does not shorten the term or calculate the exact payoff month. It also does not model recurring extra payments, skipped or late payments, variable rates, payment date conventions, escrow changes, or the timing of closing costs. Its standard amortization formula assumes the APR converts to a monthly rate; actual servicing calculations may use more detailed conventions.
Frequently Asked Questions
Does a prepayment reduce my monthly mortgage payment?
No, not in this calculator. It keeps the scheduled payment fixed and estimates a lower balance and less interest. A lender may offer a separate way to recalculate payments; check the loan terms or ask the servicer.
What month should I enter for a lump-sum payment?
Enter the number of monthly payments made before the extra amount is applied. For example, month 60 represents five years of monthly payments, with the prepayment applied after that month’s scheduled payment in this estimate.
Does the calculator include refinance closing costs?
No. It estimates loan payment and prepayment arithmetic only. Add costs to the modeled loan amount only when they are actually financed, and compare other transaction costs separately using figures from the lender.
Can I enter recurring extra payments?
No. The calculator handles a single lump sum. A series of additional payments changes the balance month by month and requires a schedule that accounts for each payment’s timing.
Why might my lender’s balance differ?
The lender may use different payment dates, rounding, daily-interest conventions, or payment application rules. The entered APR and term may also differ from final loan documents. Use the lender’s payoff or amortization figures for account-specific amounts.
This is estimate arithmetic for education, not financial advice; the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Refinance loan amount | $ | 300000 | 1 | 100000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in extra | Prepayment amount | $ | 10000 | 0 | 100000000 in mon | Month prepayment is made | months | 60 | 1 | 600 out pmt | Monthly principal-and-interest payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out bal | Balance after prepayment | $ | p * (1 + apr / 1200) ^ mon - pmt * ((1 + apr / 1200) ^ mon - 1) / (apr / 1200) - extra | 2 out sav | Interest reduction from prepayment | $ | extra * ((1 + apr / 1200) ^ (yrs * 12 - mon) - 1) | 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 Estimate Calculator
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term