Mortgage Points Calculator
Compare two discount-point choices, see the payment tradeoff, estimate break-even time, and follow each mortgage balance over the full term.
Mortgage setup
Advanced assumptions
Point comparison
Side-by-side results
| Metric | Option I | Option II | Difference |
|---|
How quickly does each option pay down?
Annual mortgage schedule
| Year / period end | Opt. I principal | Opt. II principal | Opt. I interest | Opt. II interest | Opt. I balance | Opt. II balance |
|---|
How to use this mortgage points calculator
What this calculator does
This calculator estimates the cost and payment effect of buying mortgage discount points and compares two point levels on the same fixed-rate amortizing loan. It computes the no-points payment, each option's discounted rate, points cost, financed principal when applicable, monthly principal-and-interest payment, monthly savings, simple break-even month, total loan interest, total cash payments, and an annual amortization schedule. The balance chart uses that same schedule to show how the two options pay down over time. It is a planning model, not a lender quote, APR disclosure, tax determination, or recommendation to buy points. Actual rate reductions are set by lenders and may not equal the demonstration assumption. The Consumer Financial Protection Bureau's explanation of points and lender credits is a useful starting point for understanding the upfront-cost versus interest-rate tradeoff.
When to use it
Use the comparison when you have two point quotes from the same lender, when you want to test whether a larger buy-down is likely to recover its upfront cost before you sell or refinance, when you are deciding whether to pay points in cash or finance them, or when you want to understand how a different compounding convention changes the payment produced from a quoted nominal rate. Because a point equals one percent of the loan amount, point costs scale directly with mortgage size even when the point count stays unchanged.
How to calculate
- The calculator opens with a complete demonstration: a $250,000 loan, 30-year term, 3.25% initial rate, monthly compounding, a September 1, 2026 first-payment date, 1 point for Option I, 3 points for Option II, a 0.25 percentage-point discount per point, and upfront payment of points. The example workbook is immediately available through Download Excel.
- Replace Original loan amount, Mortgage term, Initial interest rate, Compounding frequency, and Due date with the terms you want to study. Then enter the Mortgage points for Option I and Option II.
- Open Advanced assumptions when a lender quote implies a different Discount percentage per point or when you want to change Type of payment from upfront to financed. The results update live.
- Read the primary payment comparison, break-even values, side-by-side results, annual balance chart, and schedule. Break-even is a simple cost divided by monthly savings measure; if an option does not reduce the monthly payment, break-even is shown as not available.
- Select Download Excel to create an XLSX workbook from the current validated inputs and canonical calculations. Reset clears the demonstration and all data fields, closes advanced assumptions, removes calculated content, and may disable Download Excel until a complete valid input set is entered again.
Input guide
Original loan amount is a required U.S.-dollar amount greater than zero; the demonstration uses $250,000. A larger amount increases point cost dollar-for-dollar and usually raises payments and lifetime interest. Enter digits with an optional dollar sign, decimal part, and correctly grouped U.S. thousands separators; decimal-comma formats and scientific notation are rejected rather than silently reinterpreted. Mortgage term is a required whole number from 1 to 50 years; 30 years is the example. Longer terms usually lower the required monthly payment while increasing lifetime interest. Initial interest rate is a required annual nominal percentage from 0% to 30%; enter 3.25 or 3.25%, not 0.0325. Higher rates increase the no-points payment and change the savings generated by a fixed point discount.
Compounding frequency is required and may be Yearly, Semi-annually (Canada), Quarterly, or Monthly. The calculator converts the nominal annual rate into an equivalent monthly periodic rate before amortization; the default is Monthly, which uses the annual rate divided by 12. Choosing a different convention can change the effective monthly rate even when the printed annual rate is unchanged. Due date is a required calendar date for the first scheduled payment; the example is 2026-09-01. It determines the period-end month and year shown in the annual schedule labels; it does not change the payment formula itself.
Mortgage points for Option I and Option II are required nonnegative decimal counts from 0 to 10. One point costs 1% of the original loan amount, consistent with the Freddie Mac overview of discount points. The example uses 1 point and 3 points. More points increase the fee and, under the chosen discount assumption, reduce the mortgage rate further. A common mistake is assuming every lender gives exactly the same rate reduction per point; actual pricing varies. Discount percentage per point is a required advanced percentage from 0% to 5%; the example uses 0.25%. It is a modeling assumption, not a universal market rule. If points multiplied by this discount would push the mortgage rate below 0%, the input combination is rejected.
Type of payment is required. Pay points upfront leaves principal equal to the original loan and adds point cost to total cash payments. Roll points into the loan adds the point cost to principal before computing the discounted payment; therefore financing can reduce or eliminate the monthly savings that points would otherwise create. Not every mortgage program permits financed points, so use the mode only to model a structure actually offered to you.
Output guide
Original payment is the monthly principal-and-interest payment before buying points. Option I points cost, Option II points cost, and the corresponding Cost of mortgage points values equal the original loan multiplied by each point percentage. Discount per point mirrors the active advanced assumption. New interest rate is the initial rate minus points multiplied by the discount per point. The primary Lower monthly payment identifies the smaller of the two option payments and states the dollar gap between them. Option I monthly savings and Option II monthly savings compare each discounted payment with the original no-points payment; negative savings mean the option's payment is higher, which can happen when points are financed.
Option I break-even and Option II break-even are estimates in months, calculated as point cost divided by positive monthly savings and rounded up to the next whole month. This is a simple cash-flow break-even and does not discount future savings or model taxes, investment returns, refinancing, or sale proceeds. Total interest is interest paid to the lender over the scheduled term and excludes the upfront point fee. Total payments is scheduled principal and interest plus upfront points when applicable. The side-by-side Difference column is always Option II minus Option I, so a negative monthly-payment difference means Option II costs less per month.
The Annual mortgage schedule groups monthly rows into years. Year / period end identifies each annual group and its final payment month and year. Opt. I principal and Opt. II principal are the principal repaid during that year; Opt. I interest and Opt. II interest are that year's interest charges; Opt. I balance and Opt. II balance are the remaining principals after the year's payments. The Annual balances chart plots those ending balances from the same model series. Higher curves mean more principal remains outstanding at that point in time; both curves should reach approximately zero at the end of a fully amortizing term.
Worked example
With the startup values, the no-points payment on $250,000 for 30 years at 3.25% with monthly compounding is $1,088.02. Option I buys 1 point, so its fee is 1% × $250,000 = $2,500.00. At a 0.25 percentage-point discount per point, its new rate is 3.00%, producing a monthly payment of $1,054.01 and monthly savings of $34.01. Dividing $2,500 by the unrounded monthly savings and rounding up gives a 74-month simple break-even. Option II buys 3 points for $7,500.00, reduces the modeled rate to 2.50%, and produces a payment of $987.80, savings of $100.21, and a 75-month break-even. Over 360 payments, Option I produces $129,443.63 of loan interest and Option II produces $105,608.81. Those values match the first-open results and the workbook checkpoints.
Learn more
Point pricing should be compared with the entire loan offer rather than viewed in isolation. The CFPB's guide to mortgage loan costs explains how points and credits change the balance between cash due at closing and ongoing payments. For U.S. tax questions, points may sometimes be treated as prepaid mortgage interest, but eligibility and timing rules depend on the transaction and taxpayer; consult the IRS guidance on mortgage interest and points rather than assuming the calculator's cost is deductible.
How the payment model works
The calculator first converts the quoted annual nominal rate to an effective monthly rate based on the chosen compounding frequency. If the nominal rate is j and it compounds m times per year, the monthly rate is (1 + j/m)^(m/12) – 1. For monthly compounding this reduces to j/12. The standard fixed-payment amortization formula then produces the monthly principal-and-interest payment from principal, monthly rate, and number of monthly payments. A zero interest rate is handled directly as principal divided by payment count.
Each monthly schedule row allocates interest as the opening balance multiplied by the monthly rate; the rest of the payment reduces principal. The final payment is bounded so rounding cannot drive the modeled balance below zero. Annual rows are sums of the monthly principal and interest allocations plus the ending balance after each group of up to 12 payments.
Interpreting break-even and lifetime cost
Simple break-even is most informative when points are paid upfront and you expect to keep the same mortgage long enough for monthly payment savings to accumulate. If you expect to sell or refinance before the break-even month, the modeled savings have not yet repaid the initial point fee. Staying beyond break-even does not automatically make points the best choice because the upfront cash has an opportunity cost and other loan terms can differ. When points are financed, the calculator still divides the point amount by any positive payment savings to give a comparable timing indicator, but the financed principal itself accrues interest; review total payments and the schedule alongside that number.