Summary
| No. | Month | Payment | Principal | Interest | Extra | Balance |
|---|
Mortgage interpretation: payment comfort vs lifetime cost
A lower monthly payment is not automatically a better mortgage. Long terms can reduce immediate pressure but increase total interest substantially. This planner is most useful when you compare tradeoffs explicitly: monthly affordability, total interest paid, and sensitivity to rate changes. Use the table to inspect where money goes over time, not just the headline payment number.
How to use this planner for decisions
- Compare equal payment vs equal principal to understand cash-flow shape.
- Model one or more lump-sum prepayments and observe term/interest impact.
- Run refinance scenarios with realistic fees, not rate-only assumptions.
- Stress-test with a slightly higher rate to check budget resilience.
Common mistakes to avoid
- Evaluating only monthly payment while ignoring total repayment and fees.
- Assuming refinance is always beneficial without break-even analysis.
- Skipping a debt-to-income check before selecting a target payment level.
Interpretation notes
If your decision depends on a narrow difference between scenarios, treat the plan as high-risk and add margin (lower target payment, shorter balance horizon, or higher emergency buffer). For variable-rate or mixed-rate products, rerun this model periodically as market rates and personal income conditions change.
Educational use only. This page does not replace lender disclosures or professional financial advice.
Mini refinance sanity check
A refinance offer with a lower rate can still be inferior if fees are high and you plan to move before break-even. Compare current-loan continuation against refinance under realistic holding periods (for example 3, 5, and 10 years). If the savings only appear far beyond your likely holding horizon, the lower headline rate may not improve real outcomes.
See also
- Refinance break-even calculator to confirm whether fee payback is realistic.
- Mortgage rate scenarios for payment/interest sensitivity testing.
- Loan affordability calculator to align payment with income and DTI.
- Loan amortization schedule to inspect month-level principal and interest behavior.
How to use this calculator effectively
This guide helps you use Mortgage Repayment Planner (Lump Sum & Refinance) in a repeatable way: define a baseline, change one variable at a time, and interpret outputs with explicit assumptions before you share or act on results.
How it works
The page applies deterministic logic to your inputs and shows rounded output for readability. Treat it as a comparison workflow: run one baseline case, adjust a single parameter, and measure both absolute and percentage deltas. If a result seems off, verify units, time basis, and sign conventions before drawing conclusions. This approach keeps your analysis reproducible across teammates and sessions.
When to use
Use this page when you need a fast estimate, a classroom check, or a practical what-if comparison. It works best for planning and prioritization steps where you need direction and magnitude quickly before investing in deeper modeling, manual spreadsheets, or formal external review.
Common mistakes to avoid
- Changing multiple parameters at once, which hides the true cause of output movement.
- Mixing units (percent vs decimal, monthly vs yearly, gross vs net) across scenarios.
- Comparing with another tool without aligning defaults, constants, and rounding rules.
- Using rounded display values as exact downstream inputs without re-checking precision.
Interpretation and worked example
Run a baseline scenario and keep that result visible. Next, modify one assumption to reflect your realistic alternative and compare direction plus size of change. If the direction matches your domain expectation and the size is plausible, your setup is usually coherent. If not, check hidden defaults, boundary conditions, and interpretation notes before deciding which scenario to adopt.
See also
FAQ
What is the difference between equal payment and equal principal?
Equal payment keeps the monthly payment (principal + interest) constant, whereas equal principal keeps the principal portion fixed and gradually reduces the monthly payment. This calculator lets you toggle both methods for comparison.
How are lump-sum prepayments and refinancing reflected?
Lump-sum prepayments reduce the outstanding principal on the selected month and you can choose whether to shorten the term or lower future payments. The refinance comparison recomputes the remaining balance with the new rate, term, and fees to show the cost difference.
Is the APR nominal or effective? How is compounding handled?
Use the nominal annual rate split into r = APR/12 for the schedule. If your lender quotes an effective APR including compounding/fees, approximate by using the per‑period rate and adjusting periods accordingly.
Can I change the payment frequency (biweekly, weekly)?
Not built in. Convert APR to a per‑period rate (e.g., biweekly APR/26) and set the number of periods accordingly, or generate an amortization schedule and aggregate payments at that cadence.
What should I do first on this page?
Start with the minimum required inputs or the first action shown near the primary button. Keep optional settings at defaults for a baseline run, then change one setting at a time so you can explain what caused each output change.