ALLMARKETS / THE TOOL DESK

Mortgage Extra Payment Planner

Model recurring, annual and one-off principal reductions with a full allocation ledger.

Your inputs

Use consistent units and periods. Defaults are examples.

Your result

Check the assumptions below before relying on a result.

Formula and method

Each month accrues interest at annual rate/12. Apply the original scheduled payment, then eligible monthly extra, annual extra at months 12/24/etc., and any listed lump sums. Cap the final cash payment to principal plus interest. Compare payoff time and total interest against the same loan without extras.

Worked example

At zero interest, a 1,000 balance over ten months requires 100 per month. Adding 25 extra every month clears it in eight months. Total cash paid is still 1,000; the benefit is a shorter term, not interest savings at a zero rate.

Related calculations

How to use this result

  1. Enter the remaining balance, rate and term.
  2. Choose monthly extra and its start/end months.
  3. Add annual extra and specific month-indexed reductions if needed.
  4. Review the final capped payment and compare the original schedule with the accelerated schedule.

Questions about this calculation

Does extra principal reduce the required monthly payment?

The planner keeps the original scheduled payment. It reduces the payoff time; use the recast tool for a lower required payment.

Will later planned extras still be charged after payoff?

No. The calculation stops when the debt is cleared.

How are two lump sums in the same month handled?

Their amounts are added, then capped at the remaining principal after the regular payment.

Continue your calculation