A Loan Estimate worksheet for comparing points and lender fees
Separate discount points from other charges and avoid comparing mortgage rates without the associated price.
By Kyle Bell · Original examples and linked primary references · November 17, 2026
Collect comparable written offers
Begin with the loan amount, term, loan type and rate-lock information. If these differ, resolve those differences before interpreting the result as a points comparison. A lower displayed rate can come with a different upfront price, so a rate-only list leaves out an important part of the offer.
The CFPB's Loan Estimate rules itemize points as both a percentage and a dollar amount. The note interest rate is also different from the disclosed APR. Use the contractual note rate in the monthly amortization formula. APR reflects certain financing costs and should not be substituted for that rate in this model.
Compare the incremental charge
Suppose the baseline $300,000, 30-year offer has a 6.50% note rate, no points and $1,200 of other compared lender fees. The alternative has a 6.25% note rate, one point costing $3,000 and $700 of other compared fees. The alternative's extra upfront cost is not $3,000 in this comparison.
Compute the difference: ($3,000 + $700) − $1,200 = $2,500. The alternative already has $500 less in the other compared charges. With the same $49.052469 monthly payment saving used in the worked example, payment-only break-even becomes approximately 50.97 months instead of 61.16. At 60 payments, the interest-plus-fee advantage is approximately $1,264.36.
This arithmetic only works when the entered items are genuinely comparable and not counted elsewhere. If an appraisal charge is entered in both a points field and an other-fees field, the comparison overstates the cost. Keep the point percentage separate from the dollar amounts for other charges.
Do not confuse an escrow deposit with a points price
A closing worksheet can contain prepaid interest, tax or insurance amounts, escrow deposits and lender charges. Those lines serve different purposes. The calculator is a limited comparison of entered upfront costs and modeled principal-and-interest payments, rather than a complete cash-to-close reconstruction.
If a cost is identical under both offers, it cancels from the difference, although you still need the cash to pay it. If a cost truly differs, document why it differs before adding it to the comparison. Initial escrow amounts and closing dates can change timing without creating the same kind of permanent cost difference as a lender fee.
Check cash available after closing
For a separate cash-planning illustration, assume $25,000 available savings and $18,000 of closing cash needs before an optional $3,000 points purchase. The remaining cash would be $7,000 without those points or $4,000 with them. Neither figure tells you what reserve is appropriate; it simply makes the cash tradeoff visible.
Save the source documents and note the date of each quote. Ask the lender to explain any label you cannot classify. A comparison with uncertain inputs can look precise while answering the wrong question. The worksheet should make those uncertainties obvious instead of silently treating a blank line as a verified zero.
Sources and method notes
- CFPB Regulation Z: Loan Estimate disclosures
- CFPB: trends in discount points
- CFPB: compare Loan Estimates
Sources checked November 17, 2026. Worked figures are independently calculated hypothetical examples under the assumptions shown; they are not lender offers.
Keep learning
Why the quoted rate reduction matters more than the point count alone