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
Use the mortgage planner as a scenario tool: set one baseline loan, then change rate, term, prepayment, or refinance assumptions one at a time before comparing the outcome.
How it works
The page builds an amortization schedule from loan amount, annual rate, term, and payment method. It reports payment level, total interest, remaining balance, and the effect of lump-sum payments or refinancing, with rounding kept to the display layer.
When to use
Use it when comparing repayment plans, checking whether a lump-sum prepayment shortens the term enough to matter, or estimating whether refinance fees can be recovered before you expect to move or reset the loan.
Common mistakes to avoid
- Comparing refinance offers without adding closing costs and the expected holding period.
- Mixing nominal APR, effective APR, monthly rate, or payment frequency assumptions.
- Changing rate, term, and prepayment together, which hides the cause of payment movement.
- Using rounded monthly totals as lender disclosures or tax advice.
Interpretation and worked example
Keep the current-loan scenario visible, then change only one assumption such as an extra payment or refinance rate. Compare monthly payment, total interest, payoff month, and break-even timing. If the savings arrive after your likely holding period, the lower headline rate may not improve real outcomes.
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 enter first for a mortgage estimate?
Enter loan amount, interest rate, term, and payment frequency first. Add taxes, insurance, fees, or extra payments only when you want a fuller affordability view.