Start with five separate numbers
Buyers often hear “down payment,” “closing costs,” and “cash to close” used as though they mean the same thing. They do not. Keep these five amounts separate:
- Down payment: the purchase price portion not funded by the primary mortgage, subject to the actual loan structure and other financing.
- Closing costs: upfront loan and transaction charges, excluding the down payment.
- Cash to close: the final amount due from or to the buyer at closing after the transaction's charges, loan proceeds, deposits, and credits are reconciled.
- Monthly ownership cost: principal, interest, taxes, insurance, association dues, and other ongoing items that apply.
- Post-closing reserve: buyer-held money for moving, repairs, deductibles, maintenance, and emergencies; it is not part of the official cash-to-close line.
This guide creates a planning range. It does not decide what a buyer can afford or replace a lender's disclosures, underwriting, settlement statement, or financial advice.
1. Choose one documented scenario
Record the proposed purchase price, loan amount or down-payment structure, loan program, occupancy, property type, target closing date, deposit already paid or planned, and any requested seller or lender credit. Use the lender's current written scenario where one exists. If a fact changes, create a new column rather than overwriting the old one.
Do not assume that a credit, assistance program, gift, secondary financing source, or program fee applies. Ask the lender and appropriate program administrator what is allowed, what documentation is required, and whether the source changes underwriting or timing.
2. Inventory the categories without guessing the amount
Create one row for every item the current source identifies. Depending on the transaction, categories may include:
- down payment and any program-specific upfront charge;
- lender origination charges, points, and services the buyer cannot shop for;
- title, settlement, attorney, escrow, survey, inspection, or other services the buyer may be able to shop for;
- recording, transfer, or other government charges;
- prepaid interest and an advance homeowners-insurance premium;
- initial escrow deposits for taxes, insurance, or other applicable items;
- association, transfer, capital-contribution, or project charges when documented;
- other contract or transaction charges allocated to the buyer; and
- credits, deposit, verified assistance, or amounts already paid.
Do not apply a fixed national percentage to the purchase price. Location, loan, provider, property, closing date, insurance, taxes, negotiated terms, and program rules can change the result. An empty row labeled “quote pending” is better evidence than a plausible but unsupported dollar amount.
3. Give every input a source and confidence state
Use four states:
- Known: fixed by a signed agreement or current official document for the scenario.
- Quoted: supplied in writing by the relevant provider, with date and assumptions.
- Estimated: a planning input with a stated source and reason for the range.
- Unresolved: applicability or amount has not been confirmed.
Record the provider, document, date, expiration if any, and assumption. A lender worksheet is not automatically a Loan Estimate. A seller's current tax or insurance payment is not automatically the buyer's future amount. A verbal credit is not a verified transaction credit.
Use the insurance quote guide for written premium inputs, and the HOA and condo document guide for association charges and assessments.
4. Build low, base, and high planning columns
For each uncertain row, use a documented lower and upper scenario rather than false precision. The planning relationship is:
down payment + buyer transaction charges + prepaids and initial escrow + other verified amounts due − deposits, verified credits, and applicable assistance = planning cash range
This is an organizational formula, not the official settlement calculation. Do not use negative numbers or signs without labeling them clearly. Keep the assumptions visible next to each scenario, especially closing date, interest-rate lock, insurance quote, tax source, seller credit, and chosen service providers.
Run a sensitivity check: which three unresolved rows could move the total most? Assign those first. A larger but well-supported estimate is more useful than a smaller total that omits prepaids, escrow, insurance, project charges, or program costs.
5. Keep offer terms and professional responsibilities visible
Seller credits, deposits, closing date, and cost allocations may be part of the offer or purchase contract, but their availability and effect depend on the actual transaction, loan program, and applicable rules. Send contract wording and negotiation questions to the appropriate transaction or legal professional. Send loan eligibility, permitted credits, and funds-to-close documentation to the lender.
Do not let the cash worksheet recommend a waiver, credit, loan, or offer term. Its job is to show how a proposed term changes the range and which professional must confirm it.
6. Replace the plan with the Loan Estimate
For covered mortgage applications, the Loan Estimate provides standardized loan terms, projected payments, closing-cost details, and calculating-cash-to-close information. When it arrives:
- verify the borrower and property identity;
- compare loan amount, interest rate, points, credits, and whether the rate is locked;
- review loan costs and other costs line by line;
- identify services the buyer can shop for;
- compare taxes, insurance, assessments, prepaids, and escrow with current evidence;
- reconcile deposit and seller or lender credits; and
- replace—not merely average—the earlier planning rows.
If comparing lenders, keep the property, loan type, term, lock status, and other material assumptions aligned. Ask the lender to explain differences rather than inferring that the lowest cash-to-close line is the least expensive loan over time.
7. Reconcile the Closing Disclosure before closing
The Closing Disclosure shows final loan terms and closing costs for covered transactions, and the CFPB explains that borrowers generally receive it at least three business days before closing. Compare it with the most recent Loan Estimate and the purchase agreement. Review changes to loan terms, costs, credits, deposit, adjustments, prepaids, escrow, and cash to close. Ask the lender or settlement agent to correct errors and explain changes.
Do not send money based on an unexpected email. Confirm the closing process and payment instructions through a known, independently verified phone number or in person with the trusted lender or settlement professional. Ask what form of funds is accepted and retain the confirmation process.
A printable cash-to-close range planner
| Cash item | Source and date | Status | Low | Base | High | Owner / next confirmation |
|---|---|---|---|---|---|---|
| Down payment | Lender | |||||
| Loan costs and points | Lender | |||||
| Title, settlement, attorney, survey | Provider / settlement agent | |||||
| Government charges | Official or settlement source | |||||
| Prepaid interest and insurance | Lender / insurer | |||||
| Initial escrow deposit | Lender | |||||
| HOA or project charges | Association / settlement agent | |||||
| Other verified amount due | Applicable professional | |||||
| Less deposit already paid | Contract / settlement agent | |||||
| Less verified credits or assistance | Lender / program / contract | |||||
| Planning cash range | Replace with official disclosure |
Below the table, keep a separate reserve ledger for moving, immediate work, insurance deductibles, maintenance, and emergencies. The worksheet must not subtract that reserve to make an offer appear affordable.
Attach the range to the home-offer evidence worksheet and update it when a source changes. Follow the home-buyer due-diligence checklist through closing. The sample report demonstrates why sourced ownership cost inputs and unresolved amounts should remain distinct from the property's market evidence.