Two loan offers can look nearly identical on the first page and still differ by thousands of dollars over the time you keep the loan. A lower rate may be paid for with points, a matching closing cost total may hide a lender credit, and a shorter rate lock may expire before your closing date. Duane Buziak explains how to build a mortgage comparison worksheet that puts every offer on the same footing, so you choose on total cost and fit rather than on a headline rate. The seven strategies below move from setting up clean inputs to scoring the factors that never show up in a rate sheet.
1. Standardize every quote on the same Loan Estimate footing
A worksheet is only as reliable as the numbers feeding it. The Loan Estimate is the standardized three-page form lenders must provide after you apply, and its layout is the same for every lender, which is exactly why it works as the raw material for a comparison. Verbal quotes, advertised rates, and online rate tables do not carry that consistency.
Consider an illustration. Three borrowers each collect a quote for the same purchase. One quote assumes a 30-day lock and an excellent credit tier, another assumes a 60-day lock and a middle tier, and the third assumes a 45-day lock with a slightly lower score band than the others. The third looks cheapest. Re-quote all three at a 45-day lock and the same score band, and the ranking can change, because the original gap came from assumptions, not from the lenders.
To put this into practice:
- Choose one loan amount, purchase price, loan term, and lock period, and write them at the top of the worksheet.
- Ask each lender or broker for a Loan Estimate built on those exact inputs, and confirm the credit score band they used.
- Transcribe the page 1 and page 2 figures into one row per offer: rate, monthly payment, loan costs, other costs, cash to close.
The common mistake is comparing a verbal or online rate quote against a formal Loan Estimate. The informal number usually leaves out fees, assumes ideal credit, or skips the lock period entirely. Treat anything that is not a Loan Estimate as a conversation, not a data point.
To know it is working, check that every offer has a complete Loan Estimate and that the shared assumptions are listed at the top of the sheet. If a row needs an asterisk explaining a different assumption, re-request that quote.
2. Separate the rate from the APR and total interest cost
The note rate sets your monthly principal and interest. The annual percentage rate, explained on the CFPB’s page on interest rate versus APR, folds certain lender fees into a yearly figure so you can see borrowing cost beyond the rate alone. Neither number alone tells you what you will pay. Putting rate, APR, payment, and total interest in adjacent columns shows how fees change the picture.
Here is a labeled illustration, not a quote. Offer A has a slightly lower rate but higher upfront fees. Offer B has a slightly higher rate and lower fees. Over the full 30 years, A’s lower rate may produce less interest. Over seven years, the fee difference can outweigh A’s monthly savings, and B may cost less in total. Which one wins depends on how long you keep the loan.
Build these columns into the worksheet:
- Note rate and APR, copied from the Loan Estimate.
- Monthly principal and interest.
- Total interest over the full term, from a standard amortization calculator.
- Total interest plus upfront loan costs over your expected hold period, such as five or seven years.
The common mistake is treating APR as a guarantee of the cheapest loan regardless of how long you keep it. APR spreads fees across the entire term, so it favors loans you hold for decades and can understate the weight of upfront costs if you sell or refinance sooner.
Measure total cost over your expected ownership period, not just the full term. If you are unsure how long you will stay, run two scenarios, a short one and a long one, and see whether the same offer wins both.
3. Itemize origination charges, points, and credits line by line
Two offers can show the same total closing costs and still be very different loans. The Loan Estimate breaks costs into sections: Section A for origination charges, Section B for services you cannot shop for, and Section C for services you can. A single bottom-line number collapses all of that, including whether the lender is charging you points or giving you money back.
Imagine two offers, both showing roughly the same total closing costs. One reaches that figure by including discount points that lower the rate. The other includes a lender credit that offsets fees but carries a higher rate. The totals match, yet the rates are not comparable, because one buyer paid for a lower rate and the other was paid to accept a higher one.
Set up separate rows for each of these:
- Origination charges (Section A), including any application or underwriting fees.
- Discount points, shown as a dollar amount and as a percentage of the loan.
- Lender credits, entered as a negative number.
- Services you cannot shop for (Section B) and services you can shop for (Section C).
Mark each line as negotiable, shoppable, or fixed. Title and settlement services in Section C are often shoppable, which gives you room to lower costs without touching the rate.
The common mistake is comparing only the bottom-line closing cost number without seeing what produced it. A low total built on a lender credit can look attractive while hiding a higher rate that costs you every month.
The sign that this is working: every fee category is visible and matched across all offers, so any difference between two columns can be traced to a specific line.
4. Calculate the break-even point on points and credits
Discount points are prepaid interest: you pay more at closing to lower the rate. Lender credits run the other way. Whether either makes sense depends on one question, how long it takes the monthly savings to repay the upfront cost. That is the break-even point, and it is simple arithmetic.
Here is a labeled illustration with round numbers, not a rate quote. Suppose you borrow $400,000 on a 30-year loan. Option 1 has no points and a monthly principal and interest payment of $2,500. Option 2 costs $6,000 in points and lowers the payment to $2,400.
- Upfront cost difference: $6,000.
- Monthly payment difference: $2,500 minus $2,400 equals $100.
- Months to break even: $6,000 divided by $100 equals 60 months.
- Convert to years: 60 divided by 12 equals 5 years.
If you expect to keep the loan well beyond five years, the points pay for themselves and then save you $100 a month. If you expect to sell or refinance in three years, you would pay $6,000 to save $3,600 and come out $2,400 behind.
The common mistake is paying points while planning to sell or refinance before the break-even date. Buyers often underestimate how likely a move or refinance is, so be honest about your timeline, and consider that a break-even beyond seven years leaves little margin for a change in plans.
Add a break-even row to the worksheet for every pair of rate options. Compare break-even months against the number of months you realistically expect to keep the loan. A break-even comfortably inside your hold period supports paying points; one outside it points toward a credit or a higher rate with lower upfront cost.
5. Compare loan programs, not just lenders
Shopping five lenders for a conventional loan tells you who is cheapest at conventional. It does not tell you whether conventional is the right program. Each program prices risk differently: conventional loans use private mortgage insurance at lower down payments, FHA charges upfront and annual mortgage insurance premiums, VA charges a one-time funding fee with no monthly mortgage insurance, and USDA charges an upfront guarantee fee plus an annual fee. Adding program-level rows lets you weigh these costs side by side.
For a veteran buyer, consider this illustration. A VA loan carries a funding fee that can be financed into the loan, but no monthly mortgage insurance. A conventional loan at a low down payment avoids the funding fee but adds monthly mortgage insurance until enough equity builds. Over several years, the monthly insurance can outweigh the one-time fee, though the answer depends on your down payment, credit, and the specific quotes.
For each program you may qualify for, add these entries:
- Down payment required and cash to close.
- Mortgage insurance or funding fee, as a monthly and upfront cost.
- Note rate and APR for that program.
Use the VA.gov funding fee and closing costs page for the VA row, and verify the current tiers as of 2026, since they vary by down payment, prior use, and service type.
The common mistake is comparing lenders for only the one program you assumed you needed. Duane Buziak works with hundreds of wholesale lenders across conventional, FHA, VA, USDA, and renovation programs, so a single review can fill several program rows at once instead of leaving you to piece them together across separate applications.
Measure the lowest total monthly cost and the lowest cash to close across all eligible programs. These two can point to different programs, and the worksheet makes that tradeoff visible.
6. Add the costs that never appear in the rate: escrow, insurance, and cash to close
A rate describes the cost of borrowing. It says nothing about property taxes, homeowners insurance, mortgage insurance, or the cash you must bring to the table. Your actual monthly burden is PITI: principal, interest, taxes, and insurance, plus mortgage insurance where it applies. Your upfront burden is cash to close, which includes down payment, closing costs, prepaid items, and escrow deposits, minus any credits.
Take this illustration. Two offers carry identical rates and similar fees. One collects a larger escrow cushion and more prepaid interest and insurance, so its cash to close is several thousand dollars higher. The rate comparison says they are equal; your bank account says otherwise.
To build this section:
- Pull the estimated monthly property tax and homeowners insurance from page 1 of each Loan Estimate, and confirm all offers use the same figures.
- Add monthly mortgage insurance, if any, from the projected payments section.
- Total principal, interest, taxes, insurance, and mortgage insurance into one monthly PITI figure per offer.
- Record cash to close from the Calculating Cash to Close section, including escrow and prepaids.
Slot in a sourced data point for your state where it affects the numbers, such as the local property tax rate or typical insurance costs. Florida’s insurance market and Virginia’s locality-based tax rates, for example, can shift PITI more than a small rate difference, so check current figures from your county or state insurance regulator rather than assuming.
The common mistake is ignoring escrow and prepaids, so the monthly payment seems lower than it really is. If one lender’s estimate leaves out insurance or uses an unrealistically low tax figure, its payment looks better only on paper.
Measure total monthly PITI and total cash to close for each offer. Those two numbers are what you will actually live with.
7. Score the non-price factors: credit pull, lock terms, and service
Price is not the only variable that costs you money. How a lender pulls credit, how long the rate lock lasts, and how reliably the team hits deadlines all affect cost and risk. A cheaper offer that closes late can cost you a lock extension, a rate change, or even the contract.
For credit, the contrast is structural. Some lenders require a hard credit pull before they will show you options. Duane Buziak uses a NoTouch Credit Pull, a soft-pull pre-approval, so you can compare programs and pricing first without a hard inquiry. Hard inquiries made while rate shopping for the same type of loan are generally grouped together by scoring models within a limited window, but the length of that window varies by model, so confirm the current rule before relying on it.
| Feature | Duane Buziak | Typical direct lender | Why it matters |
|---|---|---|---|
| Rate sheets accessed | Hundreds of wholesale lenders | One internal rate sheet | More pricing options for the same file |
| Initial credit pull | NoTouch Credit Pull (soft pull) | Often a hard pull to quote | Compare before any inquiry affects your score |
| Program range | Conventional, FHA, VA, USDA, renovation, commercial | Varies by lender | Lets you fill program rows in one review |
| Application path | One application, multiple investors | One application, one lender | Changes how much comparison you can do from one file |
Add these rows to the worksheet and score each offer from 1 to 5, with a note explaining why:
- Credit pull type required before quoting.
- Lock length and the cost to extend it.
- Promised closing timeline.
- Communication: response time and clarity of answers.
The common mistake is choosing a slightly cheaper offer with a short lock and slow communication, which risks a late closing. Saving a small amount a month means little if an extension fee or a missed deadline erases it.
Check that the lock length covers your expected closing date with some cushion, and that the lender hits the milestones it agreed to, such as appraisal ordered, underwriting decision, and clear to close.
Questions that come up when comparing mortgage offers
What is a mortgage comparison worksheet?
It is a side-by-side table that records each offer’s rate, APR, fees, points, credits, monthly payment, and cash to close under identical assumptions, so you can compare total cost instead of a single rate.
Where do I get the numbers?
From the Loan Estimate each lender provides after you apply. Its standardized format makes figures comparable, and the CFPB publishes an explainer for reading it.
Is the lowest rate always the cheapest loan?
No. Points, origination charges, and credits can make a lower rate more expensive over the time you keep the loan.
Should I rely on APR alone?
No. APR helps expose fees, but it assumes the full term. Compare total cost over your expected hold period as well.
How many offers should I compare?
Three is a practical minimum. A broker with access to hundreds of wholesale lenders can show more options from one application.
Does comparing offers hurt my credit?
A soft-pull pre-approval does not. Hard inquiries for the same loan type within the scoring model’s shopping window are generally treated as one, but verify the current window length.
Which costs can I shop for?
Services listed in Section C of the Loan Estimate, such as title services, are generally shoppable. Section B services usually are not.
When should I pay points?
When your break-even point falls comfortably inside the time you expect to keep the loan.
Where to start, and how to get a credit-safe comparison
Begin with strategies 1 and 2. Standardized Loan Estimates and a clear view of total cost are the foundation, and every other column depends on them. Then apply the break-even calculation and the program comparison before you lock, since those two decisions move the numbers most. Strategy 7 is your tiebreaker when two offers land close together.
Ready to experience the award-winning service that earned us VA Broker of the Year and recognition as a top 1% nationwide mortgage broker? Schedule your no-pressure consultation today and discover how our customized financing strategies across VA, FL, TN, and GA can help you achieve your homeownership or investment goals with credit-safe inquiries and expert guidance every step of the way. Request your comparison from Mortgage Mastermind by Duane Buziak.
