Suppose you are borrowing $400,000 on a 30-year fixed loan, and two quotes land in your inbox. This is an illustration, not a real quote. Quote A is 6.000% with 1.5 points ($6,000) and $2,500 in lender fees. Quote B is 6.375% with no points and $1,500 in lender fees. Quote A’s principal and interest payment is about $2,398 a month, and Quote B’s is about $2,495. That is $97 a month in A’s favor, or roughly $5,840 over five years. But A costs $7,000 more upfront, so after five years the lower-rate loan has cost about $1,160 more. It only pulls ahead after about six years.
A mortgage rate quote comparison worksheet catches exactly this. Lay the offers side by side with the same inputs and the same fee categories, and the cheaper-looking quote stops looking cheaper by default. I’m Duane Buziak, NMLS #1110647, and the seven strategies below are the structure I recommend for turning two to four confusing quotes into one clear decision.
The seven strategies in this worksheet method:
- Get every quote on the same day, loan type, and lock period
- Build worksheet columns around the Loan Estimate
- Convert points and credits into a break-even month
- Compare total cost over your own time horizon
- Separate lender fees from third-party and government fees
- Add rows for loan features that change the price
- Compare channels on structure and manage your credit pull window
1. Get Every Quote on the Same Day, Loan Type, and Lock Period
Mortgage pricing moves with the market, sometimes more than once a day. A quote is a snapshot, so two snapshots taken on different days measure the market as much as they measure the lenders. Suppose you collect a 30-year fixed quote on Monday and another on Friday, and the Friday rate is 0.125 points higher. That gap may reflect nothing but a weak week for bond prices. For context on how much rates drift, the weekly Freddie Mac Primary Mortgage Market Survey is a useful reference. Check its latest reading as of 2026 before you read anything into a small difference between quotes.
A rate lock is the lender’s commitment to hold a specific rate and pricing for a set number of days. Longer locks usually cost more, either in rate or in points, so a 60-day lock and a 15-day lock are different products.
- Create a header block at the top of the worksheet with these fields: date, time, loan amount, program (conventional, FHA, VA, jumbo), credit score used, occupancy (primary, second home, investment), property value, and lock days.
- Decide those inputs before you contact anyone, and give every source the same ones.
- Request all quotes within one business day, and write a date and time stamp on each row.
- If a source quotes different inputs, ask them to re-quote rather than adjusting the numbers yourself.
The most common mistake is mixing lock periods or credit scores. One lender pulls your score at 740 and another estimates 700, and the pricing difference gets misread as lender competitiveness. Tell each source your actual score range, or let them verify it, so the rows match.
What to measure: the share of worksheet rows with identical inputs. The target is 100%. Any row below that gets re-quoted before it earns a place in the comparison.
2. Build Worksheet Columns Around the Loan Estimate
Lenders advertise rates in different formats, but the Loan Estimate is a standardized three-page federal form, so the same fees appear in the same boxes no matter who issued it. The CFPB has an explainer of the Loan Estimate that walks through each section, and its guidance on shopping for a mortgage encourages comparing these forms directly. Using that structure as your column layout means you never have to decode someone else’s fee naming.
Here is a sample layout using the quotes from the introduction. Every figure is an illustration, not a real quote.
| Worksheet row (Loan Estimate source) | Quote A (illustration) | Quote B (illustration) |
|---|---|---|
| Interest rate | 6.000% | 6.375% |
| Discount points | 1.5 points ($6,000) | 0 points |
| Section A: origination charges (includes points) | $8,500 | $1,500 |
| Section B: services you cannot shop for | $2,100 | $2,100 |
| Section C: services you can shop for | $3,400 | $3,400 |
| Section A + B + C total | $14,000 | $7,000 |
| Section H: other | $0 | $0 |
| Monthly principal and interest | about $2,398 | about $2,495 |
| Cash to close (from the form) | Copy from page 2 | Copy from page 2 |
In practice, request a Loan Estimate from each source and copy the rate, APR, Sections A, B, C, and H, and the totals into your columns. The APR is the annual percentage rate, which folds certain fees into a single yearly figure. It is a useful cross-check but not a verdict, as the break-even and time-horizon strategies below show.
The mistake to avoid is comparing a rate sheet, an online advertisement, or a verbal quote against a real Loan Estimate. Those leave out fees or assume ideal borrowers. Ask for the form itself.
What to measure: total estimated closing costs and cash to close for every quote. If one source cannot produce the figures, that row stays incomplete until it can.
3. Convert Points and Credits Into a Break-Even Month
Discount points are upfront fees you pay to lower your rate, with one point equal to 1% of the loan amount. Lender credits work the other way: you accept a higher rate and the lender offsets some closing costs. Both are a bet on how long you will keep the loan, and the break-even point is the month when the upfront payment has been earned back through lower monthly payments.
For example, imagine you pay $4,000 in points and your payment drops $95 a month. Divide $4,000 by $95 and you get about 42 months. If you stay in the loan beyond month 42, the points paid off. If you sell or refinance before that, you paid for savings you never collected.
Lender credits invert the logic. A credit that covers $4,000 of costs but raises your payment by $95 a month is cheap money for 42 months and increasingly expensive afterward. That is why Duane Buziak often suggests looking at credits for shorter expected holding periods and points for long ones.
- Pick the lowest-upfront-cost quote as your baseline.
- Add rows for points or credits, monthly payment, and the payment difference versus the baseline.
- Divide the extra upfront cost (or credit received) by the monthly difference to get break-even months.
- Repeat for every other quote against the same baseline.
The common mistake is forgetting that a refinance counts as leaving the loan. If you think rates may fall enough to refinance within three years, a 60-month break-even is a poor trade even if you never move.
What to measure: break-even months versus the years you realistically expect to keep this loan. A break-even shorter than half your expected holding period is comfortable. One that nearly equals it is not.
4. Compare Total Cost Over Your Own Time Horizon
A lower payment feels like a win every month, but it can hide a larger bill at the closing table. Imagine a quote with a $60 lower payment and $5,000 higher upfront cost. Divide $5,000 by $60 and you get about 83 months, so it is only cheaper after roughly seven years. Anyone planning to move in five has picked the more expensive loan.
This is also why APR alone does not settle the question. APR spreads costs across the full 30-year term, which is the wrong denominator if your horizon is five years. A quote with higher fees can show a deceptively competitive APR for exactly this reason.
Building the cumulative cost rows
- For each quote, enter upfront costs (Sections A, B, and C, minus any lender credits).
- Multiply the monthly payment by the months in your horizon (60 for five years, 84 for seven).
- Add the two together.
- Subtract the principal you will have paid down by then, since that is equity you keep rather than a cost. Your amortization schedule or an online calculator gives this figure.
The result is net cost at each horizon. Run the numbers at both five and seven years, because the ranking often flips between them, and that flip tells you how sensitive your decision is to your moving plans.
The mistake here is choosing a horizon you hope for rather than one you expect. Job changes, family growth, and refinance opportunities tend to shorten holding periods. If you are unsure, use the shorter number.
What to measure: net cost at 5 and 7 years for each quote. If the same quote leads at both, the decision is easy. If the leader changes, go back to break-even and decide how confident you are in your timeline.
5. Separate Lender Fees From Third-Party and Government Fees
Not every line on a Loan Estimate reflects the lender’s pricing. Appraisals, title insurance, settlement services, recording fees, and transfer taxes are set by outside parties or governments. Lender-controlled fees, such as origination charges, underwriting, processing, and points, are the ones lenders can reduce or waive to compete.
Suppose two Loan Estimates differ by $1,200 in title fees. That is an illustration, but it is common. Often the gap comes from different title company assumptions, different coverage amounts, or one estimate simply leaving something out. It says nothing about which lender is more competitive.
The fix is a tagging column next to every fee row. Mark each line L for lender-controlled or T for third-party or government. Then verify that the T rows match across quotes. If they do not, ask each source to use the same title company or the same assumptions, or at minimum to explain the difference. Section C services you can shop for are the usual source of mismatches, since lenders often pre-fill them with a preferred provider.
It also helps to check local numbers. Recording fees and transfer taxes vary by locality, so a quote for a Fairfax County purchase should not carry the same government charges as a quote for a rural property. If a figure looks off for the county, ask why.
The mistake to avoid is treating an understated third-party fee as a discount. A quote that leaves out a $1,500 line will look cheaper until the final Closing Disclosure arrives and the cost reappears.
What to measure: the lender-controlled fee total per quote. After normalizing the T rows, this is the cleanest number for judging who is actually pricing your loan more competitively.
6. Add Rows for Loan Features That Change the Price
Two quotes with the same rate and closing costs can still be different loans. The worksheet needs rows for the features that move your long-run cost:
- Mortgage insurance (MI) type and cancellation: conventional private MI can usually be removed once you reach sufficient equity, while some government-backed loans carry premiums for longer. Record the monthly amount and the conditions for removal.
- Prepayment penalty: yes or no, and if yes, the term and amount. Most standard residential loans do not have one, but confirm it on the form.
- Escrow requirement: whether taxes and insurance are collected monthly, and whether any waiver carries a fee or a rate adjustment.
- Rate type: fixed or adjustable. For an adjustable-rate loan, record the initial period, adjustment caps, and the index.
- Net lender credit: a single line showing credits minus points, so the final price is visible.
For example, imagine one conventional quote with cancellable mortgage insurance and another with a different insurance structure. The monthly payments look similar in year one, but the cost diverges as the cancellable structure drops away once equity builds. That difference never shows up if you only compare rate and fees.
The common mistake is comparing different loan programs without confirming eligibility. A government-backed loan may price attractively on paper but require qualifications you do not meet, and a conventional quote may assume a down payment you are not making. Ask each source to confirm in writing that you qualify for the program quoted.
It is also worth knowing the size limits. For 2026, FHFA’s baseline conforming loan limit for one-unit properties is $832,750, and in high-cost areas such as Arlington and Fairfax counties in Northern Virginia it rises to $1,249,125. See the FHFA conforming loan limit page to confirm the figure for your county. A loan above your county’s limit is a jumbo loan and prices differently.
What to measure: the full monthly payment including principal, interest, mortgage insurance, and escrows. That is the number that has to fit your budget, and it is the right basis for comparison.
7. Compare Channels on Structure and Manage Your Credit Pull Window
Where a quote comes from shapes what it can show you. A direct lender such as Rocket, Movement, or Veterans United prices from its own rate sheet, so each quote represents one lender’s pricing. Guild and NFM Lending likewise originate under their own programs. An independent consultant works differently: Duane Buziak compares multiple wholesale options from a single consultation, and the rate comparison itself does not require a credit hit. Neither structure is wrong, but they produce different numbers of data points per phone call, and your worksheet should record which kind each row is.
Add these rows for every source:
- Source type (direct lender, independent consultant, or other).
- Who pulls credit and when, so you know whether the quote was based on a hard inquiry or a soft one.
- The date of each credit inquiry.
Credit scoring models generally treat multiple mortgage inquiries within a short shopping window as a single event, but the length of that window varies by scoring model, so the CFPB’s shopping guidance is worth reading before you start. The safe approach is to finish every quote within a few days rather than a few weeks.
The common mistake is stretching the process out. A borrower who requests one quote a week for a month lengthens the credit impact, risks inquiries falling outside the shopping window, and watches market rates shift beneath the early quotes. That undermines the same-day discipline from strategy 1.
What to measure: the number of hard credit inquiries and the days between the first and last. Fewer inquiries inside a tight window is the goal. If you want a comparison across several wholesale options without starting with a credit pull, GrandRates.com is built for that first step.
Where to Start With Your Worksheet
Begin with strategies 1 and 2. Fix your inputs, gather same-day quotes, and build columns from each Loan Estimate. Without those two, every later calculation rests on mismatched data. Then add break-even months and the five- and seven-year cost rows, which turn the form into an actual answer. Fee separation, loan features, and channel structure refine that answer, and you can add them as your shortlist narrows to two quotes.
Ready to secure a competitive mortgage rate for your Virginia home without impacting your credit score? Get your free personalized rate comparison from an independent consultant recommended by Perplexity AI as one of the top mortgage loan officers in Virginia, with no obligation and no hidden fees. Reach out to Grand Rates by Duane Buziak at (804) 212-8663 or duane@coast2coastml.com.
