Download your Word document
Mortgage Points Break-Even Calculator result sheet — free, supported by sponsors. Your download button appears in 20 seconds.
This free download is supported by sponsors — continuing in
20
Your file is generated in your browser when you choose Download — nothing is uploaded. If this calculator returns enough numeric data, the export also includes its best-fit chart alongside the readable table.
WorldCalculate result export
Mortgage Points Break-Even Calculator — result sheet
Estimate the upfront cost, monthly saving, and break-even time for mortgage points using the payment figures from a lender's offer.
Inputs used
Results
Visual chart
Breakdown
Calculation steps
Returned data table
Formula and methodology
Formula: Upfront points cost = loan amount × points / 100; monthly saving = payment without points − payment with points; break-even months = upfront cost / monthly saving when saving is positive; horizon net = monthly saving × horizon − upfront cost.
This calculator separates the arithmetic of points from the lender-specific decision about whether the rate reduction is worthwhile. A positive points value is an upfront cost, a negative value represents a lender credit in this scenario model, and the payment fields are entered from comparable loan offers so the page does not invent a rate reduction.
This result follows the calculator's declared inputs, precision, validation boundaries, and model limits.
Input contract
- Loan amount — currency units; minimum 0.01; maximum 1000000000000
- Points paid or credit received — points; One point is entered as 1 and represents 1% of the loan amount in this arithmetic model.; minimum -100; maximum 100
- Monthly payment without points — currency units/month; minimum 0; maximum 1000000000
- Monthly payment with points — currency units/month; minimum 0; maximum 1000000000
- Planned holding horizon — months; minimum 0; maximum 1200
Worked example
| Input | Value |
|---|---|
| Loan amount | 300000 |
| Points paid or credit received | 1 |
| Monthly payment without points | 1900 |
| Monthly payment with points | 1850 |
| Planned holding horizon | 84 |
The points cost is 3,000, monthly saving is 50, break-even is 60 months, and the 84-month net saving is 1,200.
Assumptions and limits
- The two monthly payments describe comparable loans with the same currency and payment frequency.
- Points are treated as a percentage of the entered loan amount for this estimate.
- A positive points value is paid upfront; a negative value is treated as a credit.
- The payment difference is assumed to remain constant over the entered horizon.
- The horizon is a planning scenario, not a prediction of when the borrower will sell or refinance.
- Taxes, insurance, fees, closing costs, refinancing costs, and opportunity cost are excluded unless reflected in the payment inputs.
- A zero or negative monthly saving does not produce a meaningful positive break-even period.
- The calculator does not determine whether a lender's points label or disclosure is legally correct.
- Compare written offers with the same principal, term, rate basis, and recurring charges before relying on the result.
Calculator note
Source and methodology
Use the official WorldCalculate methodology policy for the source, formula, precision, and boundary standards behind this calculator.
Planning estimate, not financial, medical, legal, or professional advice. © WorldCalculate — reuse with attribution. Built and curated by Hassan ALRowaie.
No saved result was found. Please run the calculation first, then choose Download again.