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.
- Enter the purchase price. Use the accepted offer amount, not the listing price.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 district | Transfer tax source and payer | Recording or local charges | Title and settlement convention | Verified estimate |
|---|---|---|---|---|
| Alabama | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Alaska | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Arizona | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Arkansas | Confirm locally | Confirm locally | Confirm locally | $_____ |
| California | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Colorado | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Connecticut | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Florida | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Georgia | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Illinois | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Maryland | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Massachusetts | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Michigan | Confirm locally | Confirm locally | Confirm locally | $_____ |
| New Jersey | Confirm locally | Confirm locally | Confirm locally | $_____ |
| New York | Confirm locally | Confirm locally | Confirm locally | $_____ |
| North Carolina | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Ohio | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Oregon | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Pennsylvania | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Texas | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Virginia | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Washington | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Wisconsin | Confirm locally | Confirm locally | Confirm locally | $_____ |
| Other states and Washington, D.C. | Confirm locally | Confirm locally | Confirm 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.