Skip to main content

Mortgage Prepayment Calculator

Debt & Financing

Use the Mortgage Prepayment Calculator

Blend recurring extra payments and one-off lump sums to test mortgage acceleration strategies.

Policy-aware Accessible PDF and Excel
  • Lump-sum impact modeling
  • Interest reduction analysis
  • Mortgage acceleration strategy
Before you calculate

Enter the current mortgage terms, recurring extra payment, and each planned lump sum with its expected timing; retain adequate liquidity and verify how the lender applies prepayments.

What this calculator covers

Inputs you can model

  • Original principal
  • Annual interest rate %
  • Term years
  • Monthly payment
  • Extra monthly payment
  • Lump-sum payment
  • Lump-sum month
  • First repayment date

Results you can review

  • Scheduled payment
  • Original months
  • Accelerated months
  • Interest saved
  • Months saved
  • Original interest
  • Accelerated interest
  • Original amortization schedule
  • Accelerated amortization schedule
Method, policy basis, and limitations

How the estimate is built

The model amortizes the outstanding balance using the entered rate and payment, then applies recurring and scheduled lump-sum principal reductions to compare payoff outcomes.

Important limitation

This is a planning schedule, not a lender payoff statement. Prepayment penalties, recasting rules, escrow, fees, variable rates, and the lender's payment-allocation method may alter savings.

Your inputs

Enter the values you know. Required fields should be completed first, and optional fields can be left blank if they do not apply to your situation.

Preparing your input checklist Visible required fields are checked as you complete them.
Mortgage Prepayment Calculator inputs
Minimum: 0.00.
Minimum: 0.00.
Minimum: 1.00.
Optional. Leave blank to let the calculator derive the scheduled payment. Minimum: 0.00.
Minimum: 0.00.
Minimum: 0.00.
Minimum: 1.00.
Optional. Add repayment dates to both schedules.
Calculating and validating policy inputs...
Your decision view will appear here

Run the calculator to see the planning signal, key measures, reconciliation detail, and any schedules or stress scenarios returned for these inputs.

Your results

The top cards show the most important answers first. Detailed schedules, scenario tables, and supporting notes appear underneath for deeper review.

Planning estimate

This is a planning schedule, not a lender payoff statement. Prepayment penalties, recasting rules, escrow, fees, variable rates, and the lender's payment-allocation method may alter savings.

Debt & Financing
What you will get 7 summary measures and 2 detailed tables.

Run the estimate before PDF, Excel, copy, and print actions become available.

Use the result well

  1. 1

    Enter evidence-based inputs. Use statements, ledgers, contracts, or approved records where available.

  2. 2

    Read the planning signal. Then review the supporting measures and reconciliation detail.

  3. 3

    Compare scenarios. Stress tables are planning heuristics, not forecasts or approvals.

  4. 4

    Save the evidence. Export the inputs, results, and returned tables for review.

Related calculators

Explore the full hub

Browse payroll, debt, savings, and planning tools from the categorized calculator hub.

Open calculator hub