Closing Cost Estimator Worksheet: The Refi Guy’s Line-by-Line Breakdown for Refinancing Homeowners

Duane Buziak

Mortgage Maestro | NMLS #1110647 | Coast2Coast Mortgage LLC

Licensed Mortgage Broker serving Virginia, Florida, Tennessee, Georgia, and Washington, specializing in VA home loans and first-time homebuyer programs.

Picture this: you’re a Virginia homeowner sitting on a $350,000 mortgage balance at 7.25%. A lender calls and tells you they can get you down to 5.99%. Your ears perk up. Running the numbers on a standard 30-year amortization, your current principal and interest payment sits at roughly $2,388 per month. At 5.99%, that same balance drops to approximately $2,097 per month. That’s a difference of about $291 every single month — real money, the kind that pays a car note or rebuilds a savings cushion.

But here’s the thing: that $291 figure is completely meaningless until you know what it costs to get there. Closing costs on a refinance aren’t a rounding error. They’re a real, upfront financial event — typically thousands of dollars — and if you don’t map every line item before you sign anything, you’re making a go/no-go decision on incomplete information. That’s where a closing cost estimator worksheet earns its keep.

A closing cost estimator worksheet is exactly what it sounds like: a structured, line-by-line accounting of every fee you’ll encounter between application and closing table. It’s the tool that converts a lender’s rate quote into a real break-even calculation. Without it, you’re comparing monthly savings to a mystery number. With it, you know precisely how many months it takes to recover your upfront investment — and whether that timeline makes sense for your situation.

My name is Duane Buziak, NMLS #1110647, and I’ve been running this math for Virginia homeowners for years. In this guide, I’m going to walk you through every cost category a refinancing homeowner will encounter, present a complete line-item worksheet in HTML table format, work through the break-even formula using real numbers, cover the shorter worksheet for streamline and VA IRRRL refis, and answer the ten questions I hear most often about closing costs. There’s also a comparison table and a full FAQ block ahead. Let’s get into it.

Why Your Lender’s Quote and Your Actual Closing Costs Are Two Different Numbers

The first thing to understand is that there’s a structural gap between what a lender quotes you on day one and what you actually pay at closing. This isn’t necessarily bad faith — it’s baked into the regulatory framework itself, and understanding it is the first reason you need a worksheet rather than just trusting the initial quote.

Under CFPB rules established through the TRID/RESPA-TILA integration, lenders are required to deliver a Loan Estimate (LE) within three business days of receiving a completed application. The LE uses a standardized format and breaks fees into distinct sections. Here’s where it gets important for your worksheet:

Section A (Origination Charges): These fees — the lender’s origination charge, discount points, and underwriting fee — cannot increase at all between the Loan Estimate and the Closing Disclosure. Zero tolerance. If a lender quotes you $1,500 in Section A, that number is locked.

Section B (Services You Cannot Shop For): This covers things like the appraisal, credit report, and flood certification. These fees can increase, but only up to 10% in aggregate between the LE and the CD. There’s a cap, but there is movement.

Section C (Services You Can Shop For): Title insurance, settlement agent, and similar third-party services fall here. If you choose a provider not on the lender’s written list of approved vendors, these fees can change without limit. This is the section where homeowners most often get surprised at the closing table.

This three-section structure maps directly to what I call the three-bucket framework for your worksheet. Bucket one is lender fees: origination charges, underwriting, processing, and discount points. Bucket two is third-party fees: appraisal, title search, title insurance (both lender’s and owner’s policies), settlement agent, and recording fees. Bucket three is prepaid and escrow items: homeowners insurance prepaid, property tax escrow deposits, and per-diem interest for the days remaining in your closing month.

Each bucket behaves differently. Lender fees are often the most negotiable — especially when you’re working with an independent broker who can shop across wholesale channels. Third-party fees vary by geography and provider. Prepaid and escrow items are largely driven by your loan size, your rate, and your closing date.

Here’s why geography matters more than most online tools acknowledge: in Henrico County, Virginia — the heart of the Richmond metro — title and settlement fees for a refinance reflect a local market that differs meaningfully from what a national online estimator might populate. Virginia’s recordation tax structure (more on that in Section 6) is a state-specific cost that generic calculators routinely understate. A worksheet built for Virginia, by someone who closes loans in Virginia, is a fundamentally different document than a generic national estimate.

The Complete Closing Cost Worksheet: Every Line Item, Explained

Below is the full line-item worksheet in table format. Every fee category a refinancing homeowner will encounter is represented here, along with what it covers, who charges it, whether it’s negotiable, and a qualitative range descriptor. I’ve deliberately avoided fabricating dollar amounts — the right numbers for your specific loan come from a real Loan Estimate, not a generic chart.

A note on the VA Funding Fee row: this is the line item that fundamentally rewrites the worksheet for eligible veterans. The VA Funding Fee, published and updated at va.gov, replaces private mortgage insurance entirely — no monthly PMI row, no upfront PMI premium row. For a VA IRRRL, the funding fee is 0.5% of the loan amount and can be financed into the new loan balance. Veterans with a service-connected disability rating may be exempt entirely. That’s a worksheet that looks materially different from a conventional refi worksheet.

Also worth calling out: the per-diem interest line is the one fee every homeowner can calculate themselves before ever talking to a lender. The formula is straightforward: (New Loan Balance × New Annual Interest Rate) ÷ 365 × Days Remaining in the Closing Month. On our $350,000 example at 5.99%, that’s roughly $57.44 per day. If you close on the 20th of a 30-day month, you’re looking at 10 days of prepaid interest, or about $574. Close on the 28th, and it’s closer to $115. This is the line item most often misread as a “junk fee” — it’s not. It’s simply the interest clock running between your closing date and the end of the month, after which your first payment covers the following month.

Break-Even Math: Turning Worksheet Totals Into a Go/No-Go Decision

The closing cost estimator worksheet is a planning tool, not a decision. The decision comes from one formula: Total Closing Costs ÷ Monthly Payment Savings = Break-Even Month.

Let’s run it with our real numbers. On the $350,000 refinance from 7.25% to 5.99% on a 30-year term, the monthly P&I savings is approximately $291. Now we need the other side of the equation: total worksheet costs.

Without fabricating a specific number, I can tell you that a typical conventional rate-and-term refinance on a $350,000 balance in Virginia will carry costs across all three buckets — lender fees, third-party fees, and prepaids/escrows — that are meaningful but not insurmountable. The exact figure depends on your county, your title company, your lender’s origination structure, and your closing date. What the worksheet gives you is the ability to populate that number with real quotes rather than guesses.

Once you have a real total, the math is simple division. If your total worksheet costs come to, say, a qualitative “mid-range” figure for a refi of this size, and your monthly savings is $291, you can calculate precisely how many months until you’ve recovered every dollar spent. That month is your break-even point. If you plan to own the home past that point, the refinance makes economic sense. If you’re likely to sell or refinance again before reaching it, the math may not pencil.

Here’s where the no-out-of-pocket closing options change the calculation. You have two structural alternatives to paying closing costs upfront. First, you can roll the costs into the loan balance. On our $350,000 example, rolling in, say, $6,000 in costs brings your new balance to $356,000. Your monthly payment at 5.99% on $356,000 is slightly higher than on $350,000 — narrowing your net monthly savings from $291 to something closer to $255 or $260. The break-even still exists, but it’s pushed out because you’re saving less per month.

Second, you can accept a lender credit in exchange for a slightly higher rate. Instead of 5.99%, you might take 6.25% and receive a credit that covers most or all of your closing costs. Your monthly savings shrinks relative to the rate-buy-down option, but you walk away from closing with no out-of-pocket expense. The break-even, in this case, is essentially immediate — but the long-term cost is a higher rate for the life of the loan.

The worksheet should be re-run any time rates move materially. If rates drop another 50 basis points after your initial quote, your savings column changes while most of your third-party fees stay roughly constant. A worksheet that showed a 30-month break-even at one rate might show a 20-month break-even at a lower rate. This is a living document, not a one-time exercise.

Streamline Refis, VA IRRRLs, and the Shorter Worksheet

Not every refinance requires the full 15-row worksheet. FHA Streamline and VA IRRRL refinances operate under a fundamentally different — and shorter — cost structure, and your worksheet should reflect that.

The VA Interest Rate Reduction Refinance Loan (IRRRL) is designed specifically for veterans who want to lower their rate on an existing VA loan. The worksheet for a VA IRRRL is shorter for three reasons: most IRRRLs skip the full appraisal, skip income re-verification, and carry a capped fee structure. The VA Funding Fee on an IRRRL is 0.5% of the loan amount — far lower than the fee on a new VA purchase or cash-out refi — and it can be financed into the new loan balance.

Critically, the VA IRRRL has a regulatory floor built into the savings column of your worksheet. The VA’s “net tangible benefit” test requires that the new interest rate be at least 0.5% lower than the existing rate (for a fixed-to-fixed refinance). This means the worksheet’s savings row must clear a regulatory threshold, not just an economic one. If the rate reduction doesn’t meet that floor, the loan doesn’t qualify as an IRRRL regardless of how the other numbers look.

FHA Streamline refinances work similarly — no full appraisal in most cases, simplified income documentation — but the worksheet has a different complexity: the FHA MIP (Mortgage Insurance Premium) structure. According to HUD, FHA loans originated after June 3, 2013 with an original LTV above 90% carry an annual MIP for the life of the loan. The upfront MIP (UFMIP) is 1.75% of the base loan amount and is financeable into the new loan balance.

For FHA borrowers considering a switch to conventional, the worksheet needs an additional row: “PMI Removal Value.” If an FHA borrower has built sufficient equity to qualify for a conventional loan without PMI — or to trigger automatic PMI cancellation under the Homeowners Protection Act at 78% LTV — the monthly MIP savings from switching to conventional can dramatically shorten the break-even timeline. That row belongs on every FHA-to-conventional worksheet comparison.

For rural Virginia homeowners, the USDA Streamline refinance is also worth noting briefly. Like the VA IRRRL and FHA Streamline, the USDA streamline skips the full appraisal and has a specific annual fee structure. Eligibility and fee details are published by the USDA — confirm current program terms directly with a licensed originator, as program parameters can shift. The worksheet for a USDA streamline is similarly abbreviated, but the annual guarantee fee row must be included and properly calculated.

Fees You Can Negotiate, Fees You Cannot, and Where Brokers Change the Math

One of the most practical uses of a closing cost estimator worksheet is visual separation: fixed fees on one side, negotiable fees on the other. Knowing which is which tells you exactly where to focus your energy.

Fixed, Non-Negotiable Fees: Recording fees are set by the county circuit court clerk’s fee schedule — you cannot negotiate them. Virginia’s recordation tax on a deed of trust is set by the Virginia Code (current rates at tax.virginia.gov) and applies to the new loan amount being recorded. The VA Funding Fee is set by federal statute. These rows on your worksheet are locked numbers — your job is to calculate them accurately, not to negotiate them down.

Negotiable Third-Party Fees: Title insurance premiums, settlement agent fees, and in some cases appraisal fees fall into the “services you can shop for” category. In Virginia, title insurance rates are state-filed, but different title companies can offer different service packages and fee structures within that framework. The settlement agent fee — what the closing attorney or settlement company charges for conducting the actual closing — varies by provider and is worth comparing.

Here’s where the broker advantage enters the worksheet in a meaningful way. An independent mortgage broker, like me operating through hundreds of wholesale lenders, can shop origination fees and rate/point combinations across the wholesale channel. Retail direct lenders — including large online lenders — have origination charges set by internal policy. You take their number or you walk. A wholesale broker can present multiple pricing options across multiple lenders, often resulting in lower lender-side fees on the Section A portion of your worksheet. That’s a structural advantage, not a marketing claim.

The LoanOptimizer approach takes this one step further: rather than building your worksheet from estimates and general ranges, you can use a soft-pull pre-qualification to generate a real Loan Estimate populated with actual quoted figures. No credit impact, no commitment, no hard inquiry on your credit report. The soft-pull process gives you real Section A, B, and C numbers from an actual lender — which means your worksheet moves from estimate to verified data in a single step.

For Virginia homeowners specifically, the conforming loan limit for 2026 in most Virginia counties is $806,500 for a single-unit property. Loans at or below this limit qualify for conventional conforming pricing — which affects the rate/point combinations available on your worksheet. Jumbo loans above this limit carry a different pricing structure and often higher lender fees.

From Estimate to Closing Table: Putting the Worksheet to Work

The closing cost estimator worksheet doesn’t live in a drawer. It’s a working document that travels with you from first quote to closing table — and it becomes a compliance audit tool in the final stretch.

Here’s the practical sequence. First, build your worksheet estimate using the line items from the table in Section 2. Use qualitative ranges where you don’t have real quotes, and flag the rows where you need real provider numbers. Second, request a real Loan Estimate from at least one lender — ideally through a soft-pull process that doesn’t affect your credit. Third, compare the LE’s Section A, B, and C fees against your worksheet line by line. Where the LE number differs from your estimate, understand why. Is it a provider difference? A county-specific fee you underestimated? A lender fee that’s higher than the market average?

Fourth — and this is the step most homeowners skip — at closing, compare the Closing Disclosure against both the Loan Estimate and your worksheet. CFPB rules prohibit certain fee increases between the LE and the CD. Section A fees cannot increase at all. Section B fees cannot increase by more than 10% in aggregate. If you see a fee on your CD that’s materially higher than the corresponding LE line and it falls in a zero-tolerance or limited-tolerance category, you have grounds to question it before you sign.

For Virginia homeowners specifically, the recordation tax deserves its own attention. Virginia charges a deed of trust recordation tax on the new loan amount being recorded with the county circuit court. This tax has both a state component and a local add-on that varies by locality. The current rate structure is published at tax.virginia.gov — look up the current rate before finalizing your worksheet, because an out-of-state lender’s generic estimate tool will frequently understate this line. In Henrico County, as in most Virginia localities, the recordation tax is a meaningful line item that belongs prominently on your worksheet, not buried in a footnote.

The worksheet is the planning tool. A real Loan Estimate from a licensed originator turns those estimates into binding numbers. If you’re ready to move from estimates to real figures, a soft-pull pre-qualification through FreePreQuals.com gives you a real LE with no credit impact and no obligation. Duane Buziak, NMLS #1110647, can have real numbers in front of you faster than most lenders can schedule a callback.

Frequently Asked Questions: Closing Cost Estimator Worksheet

1. What is a closing cost estimator worksheet and how is it different from a Loan Estimate?

A closing cost estimator worksheet is a planning document you build before applying for a refinance. It maps every anticipated fee line by line so you can estimate break-even and compare lender quotes intelligently. A Loan Estimate is a legally standardized document a lender must provide within three business days of a completed application — it contains actual quoted figures, not estimates. The worksheet helps you evaluate the LE when it arrives; the LE gives you the real numbers to plug into the worksheet.

2. How much are typical closing costs on a refinance?

Closing costs on a refinance vary based on loan size, loan type, the state and county where the property is located, and the lender’s fee structure. They typically include lender fees, third-party fees, and prepaid/escrow items. Rather than citing a percentage that may not apply to your situation, the right approach is to request a real Loan Estimate — ideally through a soft-pull process — so the numbers reflect your actual loan, property, and location.

3. Which closing costs are negotiable on a refinance?

Lender origination fees and discount points are negotiable before you apply — and comparing multiple lenders (especially through a wholesale broker) is the most effective way to reduce them. Title insurance and settlement agent fees fall in the “services you can shop for” category and can vary by provider. Recording fees, transfer taxes, and government-mandated fees like the VA Funding Fee are fixed by statute and cannot be negotiated.

4. What closing costs does a VA IRRRL refinance eliminate compared to a conventional refi?

A VA IRRRL typically eliminates the full appraisal fee, skips income re-verification costs, and replaces private mortgage insurance entirely with the VA Funding Fee (0.5% of the loan amount for an IRRRL, financeable into the balance). The VA also caps certain lender fees under the 1% origination rule. The result is a significantly shorter and often lower-cost worksheet compared to a conventional rate-and-term refinance. Details on current VA IRRRL eligibility are published at va.gov.

5. How do I calculate the prepaid interest line on my closing cost worksheet?

Use this formula: (New Loan Balance × New Annual Interest Rate) ÷ 365 × Days Remaining in the Closing Month. On a $350,000 loan at 5.99%, the daily interest accrual is approximately $57.44. If you close on the 25th of a 30-day month, you owe five days of prepaid interest, or roughly $287. Closing later in the month reduces this line item.

6. What is the break-even point on a refinance and how do I calculate it?

Break-even month = Total Closing Costs ÷ Monthly Payment Savings. If your worksheet totals come to a specific dollar figure and your monthly P&I savings is $291 (as in our $350,000 example going from 7.25% to 5.99%), divide the total costs by $291 to find the month at which you’ve recovered every dollar spent on the refinance. If you plan to own the home past that month, the refinance makes economic sense.

7. Can I roll closing costs into my refinance loan?

Yes — this is one of two no-out-of-pocket closing options available on most refinances. Rolling costs into the loan increases your new balance and therefore your monthly payment, which narrows your net monthly savings. The break-even still exists but takes longer to reach. The alternative is a lender credit, where you accept a slightly higher rate in exchange for the lender covering some or all of your closing costs. Both options have real trade-offs that your worksheet should model explicitly.

8. What Virginia-specific fees must I include on my closing cost worksheet?

Virginia homeowners must include the deed of trust recordation tax, which is charged on the new loan amount being recorded with the county circuit court. This tax has a state component and a local add-on that varies by locality. Current rates are published at tax.virginia.gov. Recording fees charged by the county circuit court clerk are also fixed by Virginia Code. Both are non-negotiable and are frequently understated by out-of-state generic estimate tools.

9. How does a lender credit work and how does it change my worksheet math?

A lender credit is a dollar amount the lender contributes toward your closing costs in exchange for a higher interest rate. On your worksheet, a lender credit reduces the “cash to close” figure — potentially to zero — but raises the rate row, which reduces monthly savings. The break-even calculation changes: instead of measuring months to recover upfront costs, you’re measuring whether the higher rate over the life of the loan costs more or less than the closing costs you avoided. For homeowners who plan to move or refinance again within a few years, a lender credit often makes sense.

10. How soon after getting a closing cost estimate should I lock my rate?

Rate locks typically range from 15 to 60 days, with longer locks sometimes carrying a small cost. The right time to lock is when you’ve received a real Loan Estimate, your worksheet math confirms the refinance makes sense at the quoted rate, and you’re confident you can close within the lock period. Waiting for rates to drop further is a timing bet — if rates move up instead, your worksheet math changes in the wrong direction. A soft-pull pre-qualification gives you real numbers without starting the lock clock.

Is Duane Buziak a mortgage broker or a mortgage lender?

Both, in the most useful sense of the word. As an independent mortgage broker operating through hundreds of wholesale lenders, I shop origination fees and rate/point combinations across the wholesale channel to find the structure that fits your specific situation. I also have correspondent and in-house funding capability for loans that are best served through that channel. The practical result: your worksheet’s lender-fee section gets shopped across multiple pricing options rather than locked into a single retail lender’s internal rate sheet.

The Bottom Line: Your Worksheet, Your Decision

A closing cost estimator worksheet isn’t paperwork — it’s the structure that separates a real refinance decision from a gut feeling. The three-bucket framework (lender fees, third-party fees, prepaids and escrows) gives you a mental model for every line item you’ll encounter. The break-even formula turns the worksheet total into a go/no-go date. And the comparison between your worksheet, the Loan Estimate, and the Closing Disclosure gives you a compliance audit tool that protects you all the way to the closing table.

A few things to keep in mind as you build your own worksheet. Streamline refis and VA IRRRLs have shorter worksheets — skip the appraisal row, adjust the funding fee row, and verify the net tangible benefit floor. No-out-of-pocket closing options don’t eliminate costs; they restructure them, and your worksheet should model both the rolled-in and lender-credit scenarios before you decide. Virginia’s recordation tax and recording fee structure are fixed, non-negotiable, and frequently understated by generic online tools — always pull current rates from tax.virginia.gov before finalizing your estimate.

The worksheet gets you to an informed estimate. A real Loan Estimate from a licensed originator gets you to binding numbers. If you’re ready to move from estimates to real figures, call (804) 212-8663 now for your free soft-pull rate analysis — no credit impact, no obligation, real numbers from a real Loan Estimate. Duane Buziak, NMLS #1110647, is licensed in Virginia, Florida, Tennessee, Georgia, DC, North Carolina, South Carolina, and Maryland.