Free download
Free spreadsheet version
Our free Excel download pairs a goal calculator with a commission calculator, so you can see what each deal pays you and how it moves your year. $0, just enter your email.
Download the free spreadsheetFree tool for real estate agents
Help buyers plan for more than the down payment. Enter the purchase price, down payment, lender fees, title and escrow, prepaid interest, insurance, property tax escrow, inspection and appraisal, and seller credits to estimate cash to close, line by line. Print it for your buyer consultation. Free and private: everything runs in your browser.
Estimated cash to close
$88,854.79
A $80,000.00 down payment plus $11,854.79 in closing costs and prepaids, less $3,000.00 in seller credits.
| Down payment 20% of $400,000 | $80,000.00 |
|---|---|
| Origination fee 1% of the $320,000 loan | $3,200.00 |
| Other lender fees | $1,200.00 |
| Title and escrow | $2,500.00 |
| Appraisal | $600.00 |
| Home inspection | $500.00 |
| Prepaid interest 15 days at 6.5% | $854.79 |
| Homeowners insurance First year | $1,800.00 |
| Property tax escrow 3 months of $4,800/yr | $1,200.00 |
| Closing costs and prepaids 2.96% of the price | $11,854.79 |
| Seller credits Applied to closing costs | −$3,000.00 |
| Estimated cash to close | $88,854.79 |
This is an estimate, not a Loan Estimate. The buyer's Loan Estimate and Closing Disclosure from their lender are the authoritative figures. Actual costs depend on the lender, loan program, title and escrow providers, state and local taxes and fees, and the closing date. Earnest money already deposited is usually credited toward cash to close.
How it works
Buyers tend to plan for the down payment and get surprised by everything else. This calculator adds the pieces they'll see on a Loan Estimate: lender fees, title and escrow, the appraisal and inspection, and prepaid items like interest, the first year of homeowners insurance, and the initial property tax escrow deposit. Seller credits then come off the closing costs.
On a $400,000 purchase with 20% down, the buyer puts $80,000 down and borrows $320,000. A 1% origination fee ($3,200), $1,200 in other lender fees, $2,500 for title and escrow, a $600 appraisal, a $500 inspection, 15 days of prepaid interest at 6.5% ($854.79), $1,800 for the first year of insurance, and 3 months of a $4,800 property tax bill ($1,200) add up to $11,854.79, or 2.96% of the price. After a $3,000 seller credit, the estimated cash to close is $88,854.79.
Working the other side? The free seller net proceeds calculator estimates what a seller walks away with.
Take it with you
Save your inputs, compare deals, and track your year in Excel.
Free download
Our free Excel download pairs a goal calculator with a commission calculator, so you can see what each deal pays you and how it moves your year. $0, just enter your email.
Download the free spreadsheetFull system
Lead tracker / CRM, deal pipeline with deadline alerts, commission and income tracker with goal pacing, expense and mileage log, and goal planner in one workbook. $44 one-time (code LAUNCH39 = $39), or $49 for the Agent 2027 Bundle with 12 holiday social posts.
FAQ
Usually lender charges (origination, underwriting, application, and credit report fees), the appraisal, title insurance and settlement or escrow fees, and government recording charges, plus prepaid items: interest from closing to the end of the month, the first year of homeowners insurance, and an initial deposit into the escrow account for property taxes. Many buyers also pay for a home inspection, often before closing. Freddie Mac says closing costs typically run 2% to 5% of the purchase price, and they vary a lot by location and loan.
Closing costs are the fees and prepaid items. Cash to close is everything the buyer brings: the down payment plus closing costs, minus any seller credits. Earnest money already deposited is usually credited toward that amount at closing, so subtract it to see what's still due.
Mortgage interest is paid in arrears, so the first regular payment usually isn't due until the first of the month after a full month has passed. At closing, the buyer prepays the daily interest from the closing date to the end of that month. Closing near the end of the month means fewer prepaid days. This calculator uses a 365-day year; some lenders use 360.
Generally no. Seller credits (concessions) are applied to closing costs and prepaid items, not the down payment, and loan programs limit how much the seller can contribute. This calculator caps the credit at the total closing costs. The buyer's lender can confirm the limit for their loan.
It's a planning estimate for conversations with buyers. The authoritative numbers come from the lender: a Loan Estimate must be provided within three business days of a loan application, and the Closing Disclosure must be received at least three business days before closing. Title, escrow, tax, and insurance figures vary by state, county, and provider.