Two Loan Estimates rarely look alike even when the rate seems close, and comparing them by eye is how buyers overpay for years without knowing it. The forms use the same layout by federal design, but fees get shuffled between sections, credits get buried, and a note rate that looks identical on page one can hide a meaningfully different loan by page three. Duane Buziak built this worksheet approach after watching too many buyers pick a lender based on the number in bold at the top of the page. Below are seven ways to break a Loan Estimate down into rows and columns so the real cost differences surface before you lock anything in. This is exactly the kind of comparison the Mortgage Rate Hawk hunt is built for: watch the numbers, compare them side by side, and save what the headline rate would have hidden.
Here’s how a filled-out worksheet looks once you’ve pulled the numbers from three competing Loan Estimates on the same $400,000 loan amount:
| Lender | Rate | Points | Section A Fees | Section B/C Fees | Lender Credit | APR | TIP | Cash-to-Close | Lock Days |
|---|---|---|---|---|---|---|---|---|---|
| Lender A | 6.500% | $0 | $1,650 | $3,200 | $0 | 6.612% | 198% | $84,300 | 45 |
| Lender B | 6.250% | $4,000 | $1,350 | $3,400 | $1,200 | 6.398% | 191% | $86,150 | 30 |
| Lender C | 6.500% | $0 | $1,950 | $3,100 | $2,500 | 6.590% | 197% | $81,900 | 60 |
Notice that no single column tells the whole story. Lender B has the lowest APR but the most cash due at closing. Lender C has the same rate as Lender A but a lower cash-to-close thanks to a bigger credit. That’s the point of building the worksheet out row by row instead of trusting one summary figure.
1. Line Up Section A Origination Charges Side by Side
Section A of every Loan Estimate covers origination charges, the fees the lender charges for processing and underwriting your loan. These are non-negotiable in the sense that you can’t shop them elsewhere, but they vary widely between lenders, and the only way to catch that variation is to put every lender’s fees in the same row rather than reading each PDF as its own island. The CFPB’s Loan Estimate explainer breaks down exactly what belongs in each section, which is worth keeping open while you build your own grid.
Consider a buyer comparing two Loan Estimates who assumed the underwriting fees were roughly equal because both lenders quoted similar total origination charges. Once the fees were placed in the same row on a worksheet, Lender A’s underwriting fee turned out to be $300 higher than Lender B’s, a gap that was invisible when each estimate was read on its own.
- Build a spreadsheet or printed grid with lenders as columns.
- List every individual Section A line item as its own row, not just the total.
- Pull each figure directly from page 2 of the Loan Estimate, not a verbal quote.
- Total the column and compare against the other lenders’ totals.
The common mistake here is comparing a single “origination charge” total without checking whether a fee got reclassified into Section C to make Section A look smaller. Lenders don’t always structure fees the same way, so a low Section A total can simply mean costs moved to a different part of the page. What to measure: the dollar variance in total Section A charges between lenders quoting the same loan amount and term.
2. Separate Services You Can Shop From Services You Can’t
Section B lists services the lender selects on your behalf, while Section C lists services you’re allowed to shop for yourself, things like title insurance and a survey in states where that applies. Treating these two sections as one lump of “closing costs” hides real opportunities to save money. HUD’s homebuying guidance outlines which services typically fall into the shoppable category and why borrowers are entitled to compare providers.
A borrower in one of the states Duane Buziak is licensed in realized after reviewing the worksheet that owner’s title insurance sat in Section C, meaning it was shoppable. A quick call to an outside title company turned up a lower quote than either lender’s Section C estimate, saving several hundred dollars without touching the loan itself.
To put this into practice, add a “Shoppable Y/N” column next to every fee on your worksheet. Mark Section C items as shoppable, but confirm state-specific rules before assuming a fee can be moved, since shoppable categories can differ by jurisdiction. The mistake to avoid is treating a Section B fee, one the lender already selected the provider for, as if you could shop it yourself; that comparison is false and will only waste time. What to measure: the number of shoppable fees you identify and the dollar savings achieved once you source an outside provider.
3. Put APR and Total Interest Percentage in Their Own Row
The note rate is what determines your monthly principal and interest payment, but APR folds in certain fees to express the loan’s cost as a yearly percentage, and Total Interest Percentage (TIP) shows the total interest you’d pay over the full loan term as a percentage of the loan amount. Treating these as interchangeable numbers is how borrowers misjudge which loan actually costs less. Keep the note rate, APR, and TIP as three separate worksheet rows, not one blended figure.
Suppose two lenders quote the same 6.375% note rate on paper. If one lender’s Section A and B fees run $1,500 higher, that lender’s disclosed APR will land a few basis points above the other’s, even though the payment itself is identical. Without a dedicated APR row, that difference is easy to miss.
Pull both figures from page 3 of each Loan Estimate and label them clearly, separate from the note rate row. The mistake worth avoiding is assuming the loan with the lowest APR automatically wins regardless of how long you plan to keep it; APR assumes you hold the loan to term, which most borrowers don’t. What to measure: the spread in basis points between note rate and APR for each lender, tracked side by side so you can see which lender’s fees are doing the most work to inflate that spread.
4. Run the Worked Points-Versus-No-Points Math
Discount points let you pay upfront cash to buy down your rate, and whether that trade makes sense depends entirely on how long you plan to keep the loan. A worksheet that shows the note rate but skips the breakeven math is missing the single most common reason buyers overpay on points they never recoup.
Here’s the worked example: on a $400,000 loan, Lender A quotes 6.5% with no points. Lender B quotes 6.25% with 1 point, which costs $4,000 upfront. The rate difference works out to roughly $65 less per month in principal and interest on Lender B’s loan. Divide the $4,000 points cost by the $65 monthly savings and you get a breakeven of about 62 months, just over five years. If you expect to sell or refinance before that point, the points cost more than they save. If you plan to stay in the home well past five years, paying the points is the better deal.
- Add a worksheet row for the dollar cost of any discount points quoted.
- Add a second row for the monthly payment difference between the pointed and no-points quotes.
- Divide points cost by monthly savings to get the breakeven month count.
- Compare that breakeven against your realistic expected hold period for the home.
The mistake to avoid is paying points simply because the resulting rate “looks better,” without ever calculating whether the timeline supports it. What to measure: breakeven month count compared directly against how long you actually expect to hold the loan, not how long you hope to.
5. Track Lender Credits Separately From the Rate Itself
A lender credit is money the lender applies toward your closing costs, usually in exchange for a slightly higher interest rate. Credits are common with no-out-of-pocket closing options, but a credit-heavy quote can look artificially attractive if you don’t check what rate increase it’s tied to. Isolate the credit dollar amount on its own worksheet row rather than folding it into a single “cost” figure.
Consider a buyer weighing two credit-based quotes with nearly identical advertised rates. One lender’s credit covered the entire Section A and B fee total. The other lender’s credit, despite a similar headline rate, only offset about half of those same fees. The difference only became clear once the credit was tracked on its own line and compared against each lender’s no-credit rate quote.
To implement this, list each lender’s credit amount, then note the rate that credit is attached to versus that same lender’s no-credit rate option, if they’ve provided one. The common mistake is accepting a credit-heavy quote without checking how much the rate rose to generate that credit, since a bigger credit funded by a much higher rate can cost more over time than a smaller credit at a modest rate bump. What to measure: the percentage of your total Section A and B fees the credit actually covers once those fees are totaled.
6. Compare Cash-to-Close, Not Just the Interest Rate
Cash-to-close is the actual dollar amount you need to bring to the closing table after your down payment, closing costs, prepaids, and any lender credits are netted out. It’s the number that determines whether a loan is workable for your budget right now, and it can tell a different story than the rate does.
A borrower comparing two quotes found that the lender with a 0.125% higher rate actually required less cash-to-close once credits were applied, which made it the more practical choice for that particular month’s finances, even though it wasn’t the “cheapest” loan on paper over the full term.
Pull the cash-to-close figure directly from page 2 of each Loan Estimate and give it its own dedicated worksheet row, adjusted for any lender credit you’ve already tracked separately in the previous row. The mistake to avoid is ranking lenders purely by rate while ignoring that a higher upfront cash requirement can knock an otherwise cheaper loan out of reach entirely. What to measure: the final dollar amount of cash-to-close after all credits are applied, compared side by side across every lender on your worksheet.
7. Match Rate-Lock Terms and Program Type Before Declaring a Winner
A rate quote is only as good as the lock period behind it. A floating rate can move before closing, while a locked rate is guaranteed for a set number of days, and comparing the two as if they were equivalent is a common way buyers get surprised late in the process. Fannie Mae’s Selling Guide outlines how rate-lock commitments function on the investor side, which is part of why lock terms aren’t just a formality.
Program type matters just as much. VA, Conventional, and FHA loans carry different leverage limits and eligibility rules, so a lower rate on one program isn’t automatically comparable to a higher rate on another. VA cash-out refinances allow financing up to 100% loan-to-value, while conventional cash-out is capped at a maximum of 90% LTV, a difference that can outweigh a modest rate gap depending on how much equity you’re trying to access. FHFA’s housing data shows how much closing costs and terms can vary by program and region, reinforcing why an apples-to-apples comparison has to include the loan type itself.
A buyer once nearly chose a lender with a lower floating rate over one offering a locked 30-day rate, without realizing the floating quote could still move before closing and erase the apparent savings. Add dedicated worksheet rows for lock days and program type, and note VA borrowers can have their Certificate of Eligibility pulled electronically using just a Social Security number and date of birth, which speeds up confirming program eligibility before you compare numbers. For VA borrowers with remaining entitlement questions, second-tier entitlement is calculated by taking the county loan limit, applying the 25% maximum guarantee, subtracting entitlement already used, and multiplying by four to find the zero-down purchase limit, a calculation worth confirming before assuming two VA quotes are truly comparable. The mistake to avoid is comparing a locked rate to a floating one as if both were guaranteed, or comparing loan programs with different leverage limits as if they were interchangeable. What to measure: days remaining in each lock period and confirmed program eligibility at the time you’re making the comparison.
Ten Questions Buyers Ask About Comparing Loan Estimates
What is a loan estimate comparison worksheet? It’s a spreadsheet or grid that places multiple lenders’ Loan Estimate figures side by side, row by row, so fees, rates, and terms can be compared directly instead of read one PDF at a time.
How do I compare APR between two loan estimates? Pull the APR figure from page 3 of each Loan Estimate and place it in its own row separate from the note rate, then check what fees are driving any gap between the two figures.
Is a lower APR always the better loan? Not necessarily. APR assumes you hold the loan for its full term, so a lower APR loan with higher upfront points can cost more if you plan to sell or refinance within a few years.
What’s the difference between Section A, B, and C fees? Section A covers lender origination charges, Section B covers services the lender selects for you, and Section C covers services you’re permitted to shop for yourself, such as certain title fees.
Can I shop for a lower title insurance quote? In many cases yes, since owner’s title insurance often falls under Section C, though shoppable categories can vary by state, so confirm before assuming.
What does Total Interest Percentage (TIP) tell me? TIP shows the total interest you’d pay over the full loan term as a percentage of the loan amount, giving you a long-term cost view that APR alone doesn’t fully capture.
How do I know if paying discount points is worth it? Divide the dollar cost of the points by your monthly payment savings to find the breakeven month, then compare that number to how long you realistically expect to keep the loan.
What is cash-to-close and why does it matter? Cash-to-close is the total dollar amount you need at closing after down payment, fees, and credits are netted out, and it can make a slightly higher-rate loan more workable than a lower-rate one with a bigger upfront requirement.
Why does a rate lock period matter when comparing quotes? A locked rate is guaranteed for a set number of days, while a floating rate can change before closing, so comparing a floating quote against a locked one isn’t a true apples-to-apples comparison.
Can I compare a VA loan quote against a Conventional quote the same way? Only partially. VA cash-out refinances allow up to 100% loan-to-value while Conventional cash-out caps at 90% LTV, so the leverage difference needs its own worksheet row alongside rate and fees.
Where to Start Building Your Own Worksheet
If you only have time to build out two rows before comparing quotes, start with the Section A/B/C line-up and the points-versus-no-points math. Those two catch the most common overpayment mistakes before you even get to APR or cash-to-close, since they expose reclassified fees and mismatched breakeven timelines right away. Once those rows are solid, layering in APR, TIP, lender credits, cash-to-close, and lock terms rounds out a worksheet that reflects what you’ll actually pay, not just what the headline rate implies.
Building this comparison yourself takes time and a working knowledge of what belongs in each section. Duane Buziak and the Mortgage Rate Hawk team pull these numbers apart for you across hundreds of wholesale lenders, whether you’re weighing a Purchase Home Loan, a VA loan, an FHA loan, or a refinance. Your dream home is waiting, don’t let the mortgage process hold you back. Get your free rate comparison and personalized loan match today, with same-day expert guidance to help you find the right path forward, whether you’re a first-time buyer or ready to refinance.
