How this instrument works
A mortgage acceleration lump sum is one extra payment against principal — not a raised monthly bill, not a switched payment frequency — made once, in a specific month, usually from a bonus, an inheritance, a tax refund, or the leftover proceeds of selling a previous home. The required monthly payment stays exactly what the lender originally quoted; the question this instrument answers is narrower and more useful: if that single sum lands on the balance at month k, how many fewer months does the loan need to reach zero?
The arithmetic runs in two stages, because the payment only exists partway through the schedule. First it projects the loan balance forward to month k with the same compounding formula that prices a balloon loan's remaining debt, then it subtracts the extra payment from that projected balance. From the smaller figure it works backward, using a natural-log payoff formula, to find how many further months are needed at the unchanged payment — the same inversion a payoff-time calculator uses, just starting from a balance that dropped early instead of a payment that grew.
The result assumes the servicer applies the entire sum straight to principal on the date given, with no fee attached and no recalculation of the required payment — a separate product called a recast, where the lender lowers the monthly bill instead of shortening the term, is not what this sheet models. It also says nothing about whether the same sum would have grown faster invested elsewhere; that comparison is a decision this arithmetic deliberately leaves out.
- Enter the amount financed under Loan amount, $, and the lender's quoted rate under Annual interest rate, %.
- Set the loan's original schedule under Loan term, years.
- Enter the size of the windfall under One-time lump-sum payment, $, and the month it lands under Month the lump sum is applied.
- Read Standard monthly payment (unchanged), then compare Balance just before the lump sum against Balance just after the lump sum.
- Check Months needed to finish, after the lump sum against the original schedule, and read Months shaved off the original term for the total time removed.
Worked example — a $20,000 payment at month 24
Borrow $300,000 at 6% over 30 years and the standard formula prices the required payment at $1,798.65 a month, a figure that stays fixed for the rest of the example. By month 24, two years of ordinary payments have brought the balance down to only $292,404.71 — a small dent, because early payments on a 30-year loan are mostly interest, not principal.
Apply a $20,000 windfall at that month and the balance drops in a single step to $272,404.71. Recomputing the payoff time from there, at the same $1,798.65 payment, shows the loan needs 283.85 more months to reach zero instead of the 336 months that would otherwise have remained on the original schedule — a gap of 52.15 months, a bit over four years, removed from the mortgage by one payment continuing to compound in the borrower's favor for the rest of the loan's life.
Questions
Does applying the lump sum change my required monthly payment?
No — the calculator assumes the servicer keeps the original required payment exactly as quoted, and the loan simply finishes early instead of getting cheaper. That differs from a loan recast, where a lender recalculates a lower monthly bill on the same remaining term after a large principal payment; confirm which option your servicer applies before assuming either one.
Why does the month the payment lands change how much time it saves?
A sum applied early removes principal from decades of future interest accrual; the identical dollar amount applied near the end of the term has far less time left to compound in the borrower's favor. Moving the worked example's $20,000 payment from month 24 to a later month shaves fewer months off the loan, even though the payment size never changes.
Is paying down the mortgage worth more than investing the same money?
This calculator does not answer that question — it only computes how many months a principal curtailment removes from a specific loan. Weighing that guaranteed reduction in mortgage interest against the uncertain return of investing the same sum instead is a separate decision the arithmetic here deliberately leaves out.
Does the formula account for a prepayment penalty?
No, it assumes the entire sum applies to principal with no fee attached. Most conventional mortgages originated after 2014 carry no prepayment penalty, but some loans — including certain jumbo and adjustable-rate products — still do; check the note or ask the servicer before sending a large extra payment.
How is this different from a biweekly mortgage schedule?
A biweekly schedule changes the payment habit permanently, squeezing thirteen monthly-equivalents into every twelve calendar months for the life of the loan. This instrument models one payment, made once, in one chosen month — the kind of curtailment a bonus, inheritance, tax refund, or home-sale profit produces, rather than a recurring change to a household budget.
Who actually runs a calculation like this?
Homeowners deciding what to do with a specific windfall — a year-end bonus, an inheritance, vested stock, or leftover proceeds from selling a previous home — use it to see the payoff-time effect of directing that sum at the mortgage before the money is spent or invested elsewhere.
References
- Consumer Financial Protection Bureau — Owning a Home resources
- Federal Reserve — Consumer's guide to mortgage settlement costs
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.