Suppose you are buying a $400,000 home with 10% down, which means a $360,000 loan. A rule-of-thumb estimate of 2% gives you $8,000 in closing costs, so you plan for $48,000 in cash to close. Then the Closing Disclosure arrives showing $12,350. In this illustration, the $4,350 gap comes from items the shortcut never counted: about $960 of prepaid interest, a $1,100 owner’s title policy, a $1,500 first-year insurance premium, and $790 in recording and transfer charges. Cash to close is now $52,350, and you learned it days before signing.
A closing cost estimate worksheet built on the structure of the actual federal forms closes that gap. By Duane Buziak, NMLS #1110647: the seven strategies below take you from a blank grid to a tool that compares offers on equal footing and checks the final numbers before you sign. They work for first-time buyers and for investors running several deals.
Contents
- 1. Start With the Loan Estimate’s Three-Section Fee Structure
- 2. Separate Lender Fees From Third-Party Fees
- 3. Budget Prepaids and Escrow Deposits as Their Own Block
- 4. Add State and County Transfer Taxes, Recording Fees, and Title Costs
- 5. Include Loan-Program Costs
- 6. Run the Worksheet Against Multiple Lender Quotes Side by Side
- 7. Reconcile the Worksheet Against the Closing Disclosure Before You Sign
- Closing Cost Estimate Worksheet Questions, Answered
- Where to Start: Template, Comparison, Then the Local Lines
1. Start With the Loan Estimate’s Three-Section Fee Structure
The Loan Estimate is the three-page form a lender must deliver within three business days of receiving your application, as explained by the Consumer Financial Protection Bureau. Page two lists every closing cost under lettered headings. If your worksheet uses the same headings, every number you track maps to a line on a real document, and nothing is left to a percentage guess.
Take the $360,000 loan. A 1% origination charge is $3,600 and lands in Section A. The appraisal sits in Section B (services you cannot shop for), and title services usually sit in Section C (services you can shop for). The exact lines differ by lender and file, which is why you copy them rather than assume them.
- Create one row for each lettered section: A, B, C, E (taxes and government fees), F (prepaids), G (initial escrow payment), and H (other). Add total rows for D, I, and J.
- Add a column for the estimate and a blank column for the final figure.
- Fill the estimate column from the first Loan Estimate you receive, line by line.
- Add a row below J for your down payment and any credits, so cash to close is calculated rather than assumed.
The common mistake is applying a flat percentage of the purchase price and skipping line items. That also hides a frequent misconception: your down payment is not your cash to close. Cash to close is the down payment plus closing costs, minus credits and deposits already paid.
What to measure: the share of Loan Estimate lines mapped to a worksheet row. The target is every one of them, including lines you do not understand yet.
2. Separate Lender Fees From Third-Party Fees
Lender charges, such as origination and underwriting, are set by the lender and can sometimes be reduced. Third-party charges, such as the appraisal and title work, are set by vendors, and your leverage there is shopping, not haggling. Splitting them shows where a conversation can actually change a number.
Consider two illustrative quotes that both total $6,500. One carries $4,500 in lender fees and $2,000 in third-party fees. The other is the reverse. The first gives you far more to negotiate, because lender fees are the part a lender controls.
The Loan Estimate also sorts fees by tolerance, meaning how much a charge may rise between estimate and closing. Per the CFPB, some charges, including lender origination fees, cannot increase at all. Others, such as recording fees and third-party services chosen from the lender’s list, can rise by a combined 10%. Prepaids, escrow deposits, and services you shop for on your own have no cap. Verify the current rules on consumerfinance.gov before relying on them.
- Add a lender-fee subtotal and a third-party subtotal.
- Add a tolerance flag column: cannot increase, 10% bucket, or no limit.
- Ask each lender in writing which fees can be reduced or waived.
The mistake to avoid is comparing only the grand total. A low title quote can mask a high origination fee, and the total will hide it.
What to measure: the lender-fee subtotal across quotes, and the dollar reduction you negotiate on any of them.
3. Budget Prepaids and Escrow Deposits as Their Own Block
Prepaids are costs you pay in advance at closing, namely prepaid interest, the first-year homeowner’s insurance premium, and sometimes property tax. Escrow deposits (Section G) fund the account your servicer uses to pay taxes and insurance later. These depend on your closing date and local bills, not on the lender’s pricing, so they deserve their own block.
Interest is the clearest example. A $360,000 loan at an illustrative 6.5% accrues about $64 a day ($360,000 × 0.065 ÷ 365). In a 30-day month, closing on the 3rd means roughly 28 days of prepaid interest, about $1,795. Closing on the 28th means about three days, roughly $190. The same loan costs about $1,600 less in cash to close, purely from the calendar. For current rate context, check the Freddie Mac Primary Mortgage Market Survey as of October 2026 rather than relying on a rate in an article.
- List the annual insurance premium, months of tax reserves, prepaid interest days, and a cushion row.
- Get a homeowner’s insurance quote early, since the premium is often the largest prepaid.
- Ask the lender how many months of reserves they will collect. Under RESPA, servicers may hold a cushion of no more than two months of escrow payments, as described in the CFPB’s escrow guidance.
- Rerun the block for two or three closing dates.
Two mistakes recur. Buyers treat escrow deposits as lost fees, when the money stays yours and pays your own bills. Others forget the first-year insurance premium entirely.
What to measure: prepaids and escrow as a share of total cash to close, compared across closing-date scenarios.
4. Add State and County Transfer Taxes, Recording Fees, and Title Costs
Generic calculators rarely handle government and title charges because they vary by state and often by county. This is the block where a worksheet earns its keep.
A sourced state example
As of 2026, Florida’s Department of Revenue lists documentary stamp tax on deeds at $0.70 per $100 of consideration, and on a mortgage note at $0.35 per $100 of the note, plus a separate intangible tax on the mortgage. Confirm current rates on the Florida Department of Revenue documentary stamp tax page. On our illustrative $360,000 loan, note stamps come to $1,260. Deed stamps on a $400,000 price would be $2,800, though who pays them is a matter of local custom and contract. Some counties add their own surtaxes on top.
Putting it into the worksheet
- Ask the title company for a written fee schedule for your county.
- Check the state department of revenue and the county clerk’s recording rates.
- Add the lender’s title policy and the owner’s title policy as separate rows. The lender’s policy protects the lender, while the owner’s policy protects you, and many buyers overlook the second one.
- Mark which party customarily pays each tax in your state.
The mistake is importing another state’s rules. A buyer comparing a Virginia purchase to a Florida one will find that the taxes, the payer, and the title customs differ. Treat each file as its own jurisdiction.
What to measure: the variance between your government and title lines and the title company’s final figures. Over a few files, that number shows how reliable your local inputs are.
5. Include Loan-Program Costs: Mortgage Insurance, Funding Fees, and Upfront Premiums
Program charges change both what you pay at the table and what you pay each month, so they need rows of their own. Compare the same $400,000 purchase with 10% down on two programs.
On FHA, HUD’s published structure includes an upfront mortgage insurance premium of 1.75% of the base loan, which is $6,300 on $360,000, plus an annual premium. At 0.50% a year, that is $1,800, or $150 a month, for this loan size and down payment. Verify current figures on hud.gov, since premiums and limits are revised periodically. A conventional loan with 10% down has no upfront premium in this illustration, and private mortgage insurance might run around $135 a month, though it varies widely with credit score. Over five years, FHA totals about $15,300 ($6,300 + 5 × $1,800), against about $8,100 for the conventional example.
VA loans use a funding fee instead, which varies by down payment and prior use; see va.gov for the current table.
- Add a row for each program charge.
- Add a paid-in-cash or financed toggle.
- If financed, add the amount to the loan balance and recompute the payment.
The pitfall is assuming a financed premium is free. Rolling $6,300 into the loan at 6.5% adds roughly $40 a month and about $2,000 in extra interest over five years, in this illustration.
What to measure: upfront program costs plus five-year mortgage insurance cost, per option.
6. Run the Worksheet Against Multiple Lender Quotes Side by Side
A worksheet filled in once is a guess. Filled in three times, it becomes a comparison. The lowest rate does not guarantee the lowest cost, because points and fees move the total in the other direction.
Here is an illustrative grid for the same $360,000 loan, with $40,000 down.
| Line | Quote A | Quote B | Quote C |
|---|---|---|---|
| Interest rate | 6.500% | 6.250% | 6.375% |
| APR (illustrative) | 6.64% | 6.52% | 6.50% |
| Discount points | $0 | $3,600 | $1,800 |
| Other lender fees | $3,600 | $1,400 | $1,200 |
| Third-party fees | $2,900 | $3,100 | $2,700 |
| Government fees | $1,300 | $1,300 | $1,300 |
| Prepaids and escrow | $4,700 | $4,700 | $4,700 |
| Total closing costs | $12,500 | $14,100 | $11,700 |
| Cash to close | $52,500 | $54,100 | $51,700 |
| Monthly principal and interest | $2,275 | $2,217 | $2,246 |
Quote B has the lowest rate and the highest cash to close. Its payment is about $59 a month lower than Quote A’s, but it costs $1,600 more upfront, so the break-even is roughly 27 months. Quote C has the lowest cash to close here and a payment between the other two.
- Request Loan Estimates on the same day, with matching loan amount, program, and lock period.
- Enter each into one grid, using your Strategy 1 rows.
- Add an independent view: Duane Buziak provides a free rate comparison across hundreds of wholesale lenders that does not affect your credit.
The mistake is comparing quotes with different lock periods, points, or programs. Those differences change the numbers for reasons unrelated to price.
What to measure: the spread in total cash to close, and the spread in five-year cost (fees plus interest paid) across quotes.
7. Reconcile the Worksheet Against the Closing Disclosure Before You Sign
The Closing Disclosure is the five-page final statement of the loan and costs. Under CFPB rules, you must receive it at least three business days before closing, which gives you a review window. Your worksheet is the audit tool for that window.
Consider this illustrative variance check:
| Line | Estimate | Final | Change | Action |
|---|---|---|---|---|
| Origination charge | $3,600 | $3,600 | $0 | None; this line cannot increase |
| Title services (Section C) | $1,400 | $1,750 | +$350 | Request an itemized explanation and ask the lender to check the 10% tolerance bucket |
| Appraisal | $650 | $650 | $0 | None |
| Prepaid interest | $960 | $960 | $0 | None; confirm closing date |
The $350 title change is about 0.7% of $52,350 in estimated cash to close. Whether it triggers a lender credit depends on the combined total of the 10% bucket, so ask for that math in writing.
- Copy each final figure beside its estimate.
- Calculate the difference line by line.
- Email questions to the lender and the title company, so answers are documented.
- Do not sign until every unexplained increase has an answer.
The common mistake is checking only the cash-to-close total. Two errors can offset each other and leave the total looking fine.
What to measure: total line-item variance as a percentage of estimated cash to close, against a personal threshold such as 5%.
Closing Cost Estimate Worksheet Questions, Answered
What should a closing cost estimate worksheet include?
It should include every Loan Estimate line, grouped by section: origination charges, services you can and cannot shop for, government fees, prepaids, escrow deposits, and other costs. Add columns for the estimate and the final figure.
How accurate is a closing cost estimate worksheet?
It is only as accurate as its inputs. Filled from a Loan Estimate and a title fee schedule, it tracks closely. Filled from a flat percentage, it can miss by thousands.
What is the difference between a Loan Estimate and a Closing Disclosure?
The Loan Estimate is the early quote, delivered within three business days of application. The Closing Disclosure is the final statement, delivered at least three business days before closing.
Is cash to close the same as my down payment?
No. Cash to close is the down payment plus closing costs, minus credits and deposits already paid.
Are escrow deposits closing costs I never get back?
No. Escrow deposits fund your own tax and insurance bills. They are cash due at closing, but not a fee paid to anyone.
Does the lowest rate mean the lowest closing costs?
Not necessarily. A lower rate often comes with discount points, which raise cash to close. Compare rate, points, fees, and break-even time together.
Rocket vs. a mortgage broker: how do I compare closing costs?
Structurally, a single-lender retail company quotes its own products, while an independent broker can quote across many wholesale lenders. Request Loan Estimates from each on the same day with identical terms, then compare them in one grid.
Can I use a closing cost worksheet with a lower credit score?
Yes. A lower score typically changes your rate, points, and mortgage insurance cost, so the worksheet matters more, because those lines can shift the total quickly. Run it for each scenario you qualify for.
How should self-employed borrowers use a closing cost worksheet?
The worksheet works the same way, since fees are fees. Self-employed borrowers should add a cushion row, as documentation requirements can affect timing and rate locks, which in turn move prepaid interest.
What can I do if closing costs increase after the Loan Estimate?
Compare the changed line to its tolerance category. Some charges cannot increase, and others can rise within a 10% combined limit. Email the lender asking for the reason and whether a credit applies.
Where to Start: Template, Comparison, Then the Local Lines
Do strategies 1, 2, and 6 first. They create the template, split the fees into those you can negotiate and those you cannot, and put several quotes side by side. That alone shows you which offers deserve a second look. Then add the location-specific lines from strategy 4, the program-specific costs from strategy 5, and the prepaid block from strategy 3. Save strategy 7 for the day your Closing Disclosure arrives, with a finished worksheet ready to check it against.
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 recognized as one of Virginia’s top loan officers, with no obligation and no hidden fees. Grand Rates by Duane Buziak will show you the numbers in the same structure as your worksheet.
