Duane Buziak’s 7 Strategies to Build a Mortgage Rate Comparison Worksheet That Shows the True Cost

A practical guide to mortgage rate comparison worksheet.
How to Refinance Your Home: A Step-by-Step Guide for Virginia Homeowners
Duane Buziak

Duane Buziak
Mortgage Maestro | NMLS #1110647 | Coast2Coast Mortgage LLC
Licensed mortgage broker serving Virginia, Florida, Tennessee, Georgia, Washington DC, North Carolina, South Carolina, and Maryland, specializing in VA home loans and first-time homebuyer programs.

A mortgage rate comparison worksheet is a side-by-side grid that puts every quote on the same loan amount, rate lock, points, fees, and APR, so you compare total cost instead of a headline rate. The lowest rate is not automatically the cheapest loan, and you can only see that when every quote runs on identical assumptions. These seven strategies show active rate-shoppers and first-time buyers how to build that grid. Duane Buziak’s free search tool, NoTouch Credit Pull, and Dare to Compare serve as the practical starting points, and the sections that follow define each term as it comes up. All rates and dollar figures in this article are illustrations, not current offers.

1. Standardize the Loan Scenario

Two quotes are only comparable if they answer the same question. When one lender assumes 20% down and another assumes 5%, or one prices a 700 credit score and another a 740, the gap between them reflects assumptions, not pricing. Fixing the inputs first isolates the one thing you want to learn: who charges what for the same loan.

Illustration: a $400,000 purchase with 10% down ($40,000) produces a $360,000 loan. Make that a 30-year fixed on a primary residence, and treat it as the template row at the top of your worksheet. Every quote gets copied into that same row structure.

  1. Write the scenario at the top: price, down payment, loan amount, term, loan type, occupancy, credit band, and expected closing date.
  2. Give each lender or broker those exact inputs in writing, not by phone memory.
  3. Note the county of the property. Loan limits vary by county, and the Federal Housing Finance Agency sets them each year. As of 2026, the baseline conforming limit is $832,750 and the high-cost ceiling is $1,249,125, so a larger loan can move into jumbo pricing.
  4. When a quote comes back, check each input against your template before you copy any numbers.

The common mistake is accepting a quote built on the lender’s default assumptions. A quick “I assumed 20% down” can make a rate look better than anything you would actually receive. Send corrections back and ask for a revised quote.

To measure it, check that all quotes show matching loan amount, term, and loan type, with zero assumption mismatches. If even one quote differs, it goes in a “needs revision” pile, not into the comparison.

2. Use NoTouch Credit Pull for Soft-Pull Quotes

Many shoppers hold back from gathering quotes because they fear each one will ding their credit. The usual worry is that multiple applications always hurt. In practice, scoring models generally treat mortgage inquiries made within a short shopping window as a single inquiry, and the length of that window depends on the scoring model. Even so, a soft pull removes the question entirely for the early, exploratory stage.

Duane Buziak’s NoTouch Credit Pull works that way: you compare options through the free search tool using a soft pull, with no hard inquiry at that point. A broker with access to hundreds of wholesale lenders can then show pricing across many options from that one soft look.

Illustration: a shopper runs the soft-pull comparison first, records the results in the worksheet, narrows to two or three finalists, and authorizes a hard pull only with the one she chooses at the application stage.

  1. Start with the soft-pull comparison and enter results into your scenario template.
  2. Add two columns to the worksheet: pull type (soft or hard) and date of the quote.
  3. Treat any request for a hard pull as a decision point, not a formality.
  4. Authorize the hard pull only when you are ready to apply.

The mistake to avoid is submitting full applications to many lenders just to see a rate. That creates hard inquiries and paperwork before you have learned anything you could not have learned with a soft pull. The Consumer Financial Protection Bureau encourages shopping around, and a soft-pull first step lets you do it with less friction.

Measure the number of hard inquiries before you choose a lender. The target is one, at the application stage.

3. Track Rate, Points, and Credits Together

A rate has a price attached. Discount points are upfront fees paid to lower the rate, with one point equal to 1% of the loan amount. A lender credit works the other way: you accept a higher rate and the lender covers part of your closing costs. A quote that shows only the rate hides which direction the trade went.

Illustration: on a $360,000 loan, 6.25% with 1.5 points costs $5,400 upfront and produces a payment of about $2,217. A 6.625% option with a lender credit might cost far less at closing but carry a payment near $2,305. Neither is correct in the abstract. The cash-to-close gap and the monthly gap only become visible when both appear as columns.

  1. Add columns for rate, points or credit (in dollars, not percentages), monthly principal and interest, and estimated cash to close.
  2. Ask each lender or broker for several rate options on the same scenario: one with points, one near par, one with a credit.
  3. Enter each option on its own row so a single lender can occupy three lines.

The common mistake is comparing only the advertised rate. A lender showing 6.25% and another showing 6.5% may be quoting one with 1.5 points and one with none, which is not a real comparison until the dollars are in the grid.

Measure cash to close and monthly payment side by side for each rate option. Rates here are illustrative, and APR figures appear in the sample worksheet later in this article.

4. Break Out Fees Using the Loan Estimate

The Loan Estimate is a standardized three-page form that lenders must provide after you apply, and its layout is the same from one lender to the next. That makes it the ideal skeleton for your worksheet. The CFPB’s Loan Estimate explainer walks through each section, and you can mirror those sections as worksheet rows.

Illustration: two quotes show identical Section A origination charges, so they look equal at first glance. Quote two, though, has higher Section B and C totals because of a pricier title package and appraisal choice. Without separate rows, you would never see that the gap sits in third-party costs.

  • Section A: origination charges, including points. Often negotiable or comparable across providers.
  • Section B: services you cannot shop for, where the lender selects the provider.
  • Section C: services you can shop for, such as title. Flag these rows, because you can bring your own provider.
  • Section E: taxes and government fees, which are mostly fixed regardless of lender.

To use it, request a Loan Estimate for each finalist, enter Sections A, B, C, and E as separate rows, and mark shoppable services. Then ask the provider to explain any line that looks high relative to the others.

The typical mistake is comparing only the origination line and missing third-party costs, which can differ by hundreds or thousands of dollars. Measure the total Loan Estimate closing costs per quote, plus the number of fee lines you questioned. A worksheet where you challenged zero lines usually means you accepted the first answer.

5. Use APR Wisely

APR, the annual percentage rate, folds certain fees and costs into a yearly rate so that quotes with different fee structures can be compared. It is a useful like-for-like measure, but it assumes you keep the loan for the full term, and it does not capture every cost of owning a home. Believing APR covers everything is a common misconception.

Illustration: two quotes show similar APRs. Quote one has high fees and a lower rate; quote two has low fees and a slightly higher rate. If you sell or refinance in five years, quote two may leave you with less total cost, because you never fully recoup the upfront fees of quote one. APR alone cannot tell you that.

  1. Record the APR from each Loan Estimate in its own column.
  2. Add a “cost at year 5” column: total upfront fees plus 60 monthly payments of principal and interest.
  3. If you expect a different holding period, such as 7 or 10 years, add that column as well.
  4. Place a short APR note next to any rate you display, stating that APR reflects fees and the full loan term and varies by lender and borrower profile.

The mistake is treating APR as the final answer for a loan you are likely to refinance or sell early. Many borrowers do one or the other well before 30 years, so a shorter-horizon view tells you more.

Measure APR together with total cost at your expected holding period. If the two measures disagree on which quote is cheaper, your holding period usually decides it.

6. Run Break-Even Math on Points

Points are a bet on time. You pay more now to pay less each month, and the break-even point is the month when your accumulated savings equal what you paid upfront. Before that month, the points cost you money; after it, they save you money.

A worked illustration

Suppose a $360,000, 30-year fixed loan is offered two ways: 6.50% with no points, or 6.25% with one point ($3,600, which is 1% of $360,000). These rates are for illustration only and are not current offers.

  • Payment at 6.50%: about $2,275 per month in principal and interest.
  • Payment at 6.25%: about $2,217 per month.
  • Monthly savings: about $59.
  • Break-even: $3,600 divided by $59 is roughly 61 months, a little over five years.

If you keep the loan and do not refinance for seven years, the point pays for itself and then some. If you move or refinance in three, you paid $3,600 to save about $2,100.

Putting it in the worksheet

  1. For each rate option, subtract the lower payment from the higher payment to get monthly savings.
  2. Divide the extra upfront cost by that monthly savings figure.
  3. Compare the result with the time you realistically expect to stay in the home or keep the loan.

The common mistake is paying points on a loan you will likely refinance or sell before break-even. Measure break-even months against your planned time in the loan. A margin of at least a year or two gives you a cushion for plans that change.

7. Add Lock Terms and Dare to Compare Finalists

A rate lock is the lender’s commitment to hold a specific rate and pricing for a set number of days. A quoted rate means little if the lock expires before you close, because an extension or relock can erase the savings you worked to find. Capture lock terms in the same worksheet as the price.

Illustration: a 30-day lock at a lower rate looks attractive, but your purchase contract points to closing in about 45 days. A 60-day lock at a slightly higher rate may be the better choice once you price the extension fee, or the risk of an expired lock, on the 30-day option.

  1. Add columns for lock length in days, lock fee (if any), extension cost per day or per period, and whether a float-down option exists.
  2. Calculate lock length minus your expected days to close for every quote.
  3. Bring your finalist Loan Estimates to Duane Buziak for a Dare to Compare review, which tests them against wholesale pricing.

The reason the last step matters is structural. A single lender prices from its own shelf, while a broker can check a quote against many wholesale options. The table below states the factual differences.

DimensionBroker with wholesale accessSingle-shelf lender
Pricing sourcesHundreds of wholesale lendersOne company’s own products and pricing
Rate options per scenarioMultiple lenders’ offers for the same inputsOne set of offers from that lender
Early credit impactSoft-pull comparison available through NoTouch Credit PullVaries by lender; may require an application
Fee and program flexibilityCan shift to a different lender if pricing or guidelines fit betterLimited to the lender’s own guidelines
Lock and extension termsVary by lender; compare each in the worksheetOne set of lock terms

The mistake to avoid is choosing a rate whose lock expires before the expected closing date. Measure lock length minus expected days to close, and record the total-cost gap after Dare to Compare. If a finalist cannot hold up against that review, you have learned something before signing, not after.

A Sample Worksheet With Illustrative Figures

The grid below uses the $360,000 scenario from the first strategy. Every figure is an illustration, not an offer, and closing costs exclude prepaids and escrow deposits. APR figures are estimates that reflect fees and a 30-year term; actual APR varies by lender, borrower profile, and loan details.

Worksheet rowQuote AQuote BQuote C
Scenario$360,000, 30-year fixed, primary residenceSameSame
Pull type and dateSoft, same weekSoft, same weekSoft, same week
Interest rate6.25%6.625%6.50%
Points or credit1.5 points ($5,400)Credit ($2,700)None
Monthly principal and interest$2,217$2,305$2,275
Section A (net of points or credit)$7,200-$900$1,800
Sections B and C$4,200$4,200$4,200
Estimated closing costs$11,400$3,300$6,000
Cash to close (with $40,000 down)$51,400$43,300$46,000
APR (illustrative)6.46%6.69%6.60%
Cost at year 5 (closing costs plus 60 payments)$144,420$141,600$142,500
Lock days / extension / float-down45 / per-day fee / no30 / per-day fee / no60 / included / yes

Read across the grid and the trade-offs show up. Quote A has the lowest rate and the highest cash to close. Quote B asks for the least cash up front but carries the highest payment and APR. Quote C sits in the middle, with the longest lock. Which one wins depends on your cash, your timeline, and how long you plan to keep the loan.

Eight Questions Rate-Shoppers Ask About Comparison Worksheets

Does comparing mortgage rates hurt my credit?

A soft-pull comparison does not create a hard inquiry. Scoring models also generally group mortgage inquiries made within a short shopping window, though the length of that window depends on the model. Using NoTouch Credit Pull for the early comparison means you can shop first and authorize a hard pull only at application.

What should a mortgage rate comparison worksheet include?

At minimum: the loan scenario, pull type and date, rate, points or credits in dollars, monthly payment, Loan Estimate fees by section, cash to close, APR, cost at your expected holding period, and lock terms.

Is the lowest rate the cheapest loan?

Not necessarily. A low rate can come with points and high fees that raise the upfront cost and the APR. Compare total cost at the length of time you expect to hold the loan.

What is APR, and does it cover everything?

APR is a yearly rate that folds certain fees into the interest cost so quotes can be compared. It does not cover every homeownership cost, and it assumes you keep the loan for its full term.

What are discount points and lender credits?

A discount point is an upfront fee equal to 1% of the loan amount, paid to lower your rate. A lender credit is the reverse: you accept a higher rate and the lender covers part of your closing costs.

How do I calculate the break-even on points?

Divide the extra upfront cost by the monthly payment savings. In the illustration above, $3,600 divided by about $59 is roughly 61 months. If you will keep the loan longer than that, the points pay for themselves.

How long should my rate lock be?

Long enough to cover your expected days to close, with some margin. A shorter lock at a lower rate can cost more if you need an extension, so put lock days and extension costs in the worksheet.

What is Dare to Compare?

Dare to Compare is Duane Buziak’s invitation to bring the quotes you have gathered so he can test them against wholesale options. As a broker, he can check your finalists against hundreds of wholesale lenders instead of one company’s shelf.

Where to Begin and How the Pieces Fit

Start with strategies 1 and 2: write the scenario once, then gather soft-pull quotes through NoTouch Credit Pull so nothing you collect costs you a hard inquiry. Next, fill in points, credits, and fees from strategies 3 and 4, and add APR and the cost-at-year-5 view from strategy 5 as the numbers arrive. Finish with the break-even math and lock terms from strategies 6 and 7, then run your finalists through Dare to Compare to see whether wholesale pricing changes the picture.

Duane Buziak has been helping buyers find the right mortgage since 2014, and he is licensed in VA, FL, TN, GA, DC, NC, SC, and MD. Your dream home is within reach: start comparing personalized mortgage rates from trusted lenders today and discover the loan solution that fits your budget and goals. Compare rates now and take the first step toward securing your home with expert guidance every step of the way.

Share:

More Posts

Home Equity Loan Versus HELOC: Which Fits?

Duane Buziak Explains: How to Get a Mortgage for Self Employed Borrowers

Qualifying for a mortgage for self employed borrowers comes down to documenting two years of income, showing lenders your net rather than gross earnings, and comparing programs across multiple wholesale lenders. This guide provides a document checklist, a worked income calculation, and a way to compare offers without a hard credit pull.

Unable to Produce This Article: Compliance Restriction

Duane Buziak Explains: 7 Strategies to Choose Between a Conventional Loan vs FHA Loan

A conventional loan vs FHA loan decision comes down to credit score, down payment, debt-to-income ratio, and how long you plan to pay mortgage insurance. This guide walks through seven strategies in the order buyers actually decide, from sorting your profile to comparing real payments and confirming with free soft-pull pricing that does not affect your credit score.

Send Us A Message