Closing Costs by State: Buyer’s Worksheet for Estimating Cash Needed at Closing
home buyingclosing costsmortgagefirst-time buyershome finance

Closing Costs by State: Buyer’s Worksheet for Estimating Cash Needed at Closing

LLivings Editorial Team
2026-11-17
6 min read

Estimate cash needed at closing with a practical worksheet covering down payment, lender fees, prepaid costs, credits, and local charges.

How much cash do you need to close on a house? Use this repeatable worksheet to combine your down payment, lender charges, title and escrow costs, prepaid items, inspections, credits, and location-specific taxes into a more realistic estimate before you make an offer or compare mortgage quotes.

Overview

Closing costs are the cash expenses connected with completing a home purchase. They are separate from the purchase price, although the down payment is usually included in the total cash you must bring to closing. The final amount depends on the property, loan program, lender, location, closing date, insurance requirements, and the terms negotiated with the seller.

A practical starting formula is:

Estimated cash needed at closing = down payment + buyer closing costs + prepaid items and initial escrow deposits − earnest money − seller or lender credits

Some buyers also need to budget for a cash reserve after closing. That reserve is not normally part of the settlement statement, but using every available dollar for the purchase can leave little room for repairs, moving expenses, utility deposits, or an unexpected change in income.

This worksheet is an estimate, not a substitute for the lender’s official disclosures. Use it to compare properties and loan offers, then reconcile it with the Loan Estimate and, later, the Closing Disclosure.

How to estimate

Start with the purchase price and your planned down payment. Then list each expense separately instead of applying one broad percentage to the price. A percentage can be useful for an early screen, but itemizing shows which assumptions are driving the result.

  1. Enter the purchase price. Use the accepted offer amount, not the listing price.
  2. Calculate the down payment. Multiply the purchase price by the percentage required or selected for your loan. Confirm the minimum and any program-specific requirements with the lender.
  3. Add lender charges. Request estimates for underwriting, origination, processing, credit review, rate-lock charges, and discount points. Fees vary by lender and by whether you pay points to reduce the interest rate.
  4. Add property and settlement charges. These may include the appraisal, inspection, survey, title search, title insurance, settlement or attorney fees, escrow charges, and recording fees.
  5. Add prepaid items. Include prepaid interest from the closing date through the end of the month, the first homeowners insurance premium or deposit, and initial property-tax or insurance escrow deposits when required.
  6. Subtract credits. Apply earnest money already paid, eligible seller concessions, lender credits, and other documented funds. Do not count a credit twice or assume every credit can be used for every charge.
  7. Add a reserve. Keep this separate from cash to close so you can see both the required amount and the amount you want available after settlement.

For a personal closing costs calculator, create columns for “estimated,” “confirmed,” “paid,” and “source.” This makes it easier to replace an early guess with a lender quote, insurance binder, title estimate, or local tax figure.

Inputs and assumptions

Use the following worksheet categories. Leave an item blank only after confirming that it does not apply.

  • Purchase price: $__________
  • Down payment: $__________
  • Loan amount: $__________
  • Discount points: $__________
  • Other lender fees: $__________
  • Appraisal: $__________
  • Home inspection and additional inspections: $__________
  • Title search, title insurance, settlement, or attorney fees: $__________
  • Survey, if required or selected: $__________
  • Recording fees: $__________
  • State, county, or municipal transfer taxes: $__________
  • Prepaid interest: $__________
  • Homeowners insurance premium or escrow deposit: $__________
  • Property-tax adjustment and initial escrow deposit: $__________
  • HOA or condominium charges: $__________
  • Earnest money already paid: −$__________
  • Seller concessions: −$__________
  • Lender credits: −$__________

State and local rules can change the mix of charges. Ask whether transfer taxes are imposed by the state, county, city, or more than one level of government; which party customarily pays them; and whether the contract changes that allocation. Recording fees, title practices, attorney or settlement involvement, escrow conventions, and property-tax adjustments also vary by location. Customs are not the same as legal requirements, so confirm the actual obligation in your contract and closing documents.

Loan type matters as well. A government-backed, conventional, or other mortgage program may have different down-payment rules, mortgage-insurance treatment, appraisal requirements, upfront charges, or limits on seller contributions. Ask the lender to identify which figures are fixed, which are estimates, and which may change before closing.

State-by-state reference worksheet

This table is designed for research rather than a fixed rate list. Rules and customary allocations can change, and local charges may differ within a state. Fill in the figures supplied by the lender, title company, settlement agent, attorney, county, or municipality.

State or districtTransfer tax source and payerRecording or local chargesTitle and settlement conventionVerified estimate
AlabamaConfirm locallyConfirm locallyConfirm locally$_____
AlaskaConfirm locallyConfirm locallyConfirm locally$_____
ArizonaConfirm locallyConfirm locallyConfirm locally$_____
ArkansasConfirm locallyConfirm locallyConfirm locally$_____
CaliforniaConfirm locallyConfirm locallyConfirm locally$_____
ColoradoConfirm locallyConfirm locallyConfirm locally$_____
ConnecticutConfirm locallyConfirm locallyConfirm locally$_____
FloridaConfirm locallyConfirm locallyConfirm locally$_____
GeorgiaConfirm locallyConfirm locallyConfirm locally$_____
IllinoisConfirm locallyConfirm locallyConfirm locally$_____
MarylandConfirm locallyConfirm locallyConfirm locally$_____
MassachusettsConfirm locallyConfirm locallyConfirm locally$_____
MichiganConfirm locallyConfirm locallyConfirm locally$_____
New JerseyConfirm locallyConfirm locallyConfirm locally$_____
New YorkConfirm locallyConfirm locallyConfirm locally$_____
North CarolinaConfirm locallyConfirm locallyConfirm locally$_____
OhioConfirm locallyConfirm locallyConfirm locally$_____
OregonConfirm locallyConfirm locallyConfirm locally$_____
PennsylvaniaConfirm locallyConfirm locallyConfirm locally$_____
TexasConfirm locallyConfirm locallyConfirm locally$_____
VirginiaConfirm locallyConfirm locallyConfirm locally$_____
WashingtonConfirm locallyConfirm locallyConfirm locally$_____
WisconsinConfirm locallyConfirm locallyConfirm locally$_____
Other states and Washington, D.C.Confirm locallyConfirm locallyConfirm locally$_____

For states not shown individually, use the same four questions and request a property-specific estimate. A statewide rule may not reveal a city or county charge.

Worked examples

Assume, for illustration, a home priced at $300,000 with a 10% down payment. The down payment is $30,000 and the starting loan amount is $270,000 before any loan-specific adjustments. Suppose the buyer’s preliminary worksheet lists $8,500 in lender, title, settlement, appraisal, inspection, recording, and other closing charges; $3,200 in prepaid interest, insurance, and tax or escrow items; and $4,000 in earnest money already paid.

The estimated cash needed would be:

$30,000 + $8,500 + $3,200 − $4,000 = $37,700

If the seller provides a documented $2,000 credit that can be applied to eligible costs, the estimate becomes $35,700. If the lender later adds discount points or the insurance and tax figures change, update the corresponding line rather than changing the total by guesswork.

Now compare two loan offers using the same property and closing date. One may show a lower upfront fee but a higher interest rate; another may include points or a lender credit. Compare both cash to close and the projected monthly payment. A lower amount due at settlement is not automatically the lower-cost loan over the period you expect to keep it.

When to recalculate

Recalculate whenever a core input changes: the offer price, down payment, interest rate, loan program, points, closing date, insurance quote, property-tax information, HOA charges, inspection scope, or negotiated seller credit. Re-run the worksheet after receiving a Loan Estimate, when the rate is locked, and again when the Closing Disclosure arrives.

Compare the final disclosure with your worksheet line by line. Look for changes in lender charges, title and settlement fees, recording or transfer taxes, prepaid interest, insurance, escrow deposits, credits, and the amount of earnest money applied. Ask the lender or closing professional to explain any unexpected difference before signing.

For a broader affordability check, pair this worksheet with a true monthly housing-cost estimate and a home-buying due-diligence review. If you are still comparing properties, use the same assumptions for each one so that taxes, insurance, HOA costs, and cash reserves do not disappear from the comparison. Save a dated copy of every version; the worksheet will be most useful when you revisit it for a new mortgage quote, a revised offer, a rate change, a refinance decision, or a final closing disclosure.

Related Topics

#home buying#closing costs#mortgage#first-time buyers#home finance
L

Livings Editorial Team

Real Estate and Home Finance Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.