Cash-to-close and proceeds worksheet

Start with your figures and explicit assumptions

Use your own estimates or amounts from your lender and closing professionals. Blank fields count as zero. No commission, tax rate, loan rate or closing-cost percentage is assumed. Include each expense or credit once, and use the appropriate property, tax year and contract allocation.

Calculations happen in the browser and are not submitted. Entries reset when the page is left or reloaded. Print the result if you want to keep it. This simplified worksheet does not determine eligibility, tax treatment, contractual allocation or final settlement amounts; actual lender and closing documents govern.

Buyer: additional cash to close

The planning formula is purchase price minus the loan applied to the purchase, plus closing costs and prepaids or initial escrow funding, minus other closing credits and earnest money already credited. Enter the total purchase loan rather than also deducting a down payment. Keep earnest money separate from other credits.

Ask the lender which credits can be applied, what limits govern them and what changes before closing. Account for tax adjustments and other settlement items in the applicable cost or credit field. A negative estimate is a flag to reconcile the figures, not a promised payment to the buyer.

Seller: estimated proceeds

The planning formula is sale price minus mortgage and lien payoff, closing and selling costs, credits to the buyer and other deductions. Obtain a payoff statement rather than assuming the latest principal balance is the complete amount due. Include negotiated representation costs and applicable transfer, tax and association adjustments once.

Have the closing professionals reconcile the contract and actual closing statement. A negative estimate can indicate funds needed to complete the sale; it does not resolve lien release, lender consent or the obligations that apply to your transaction.

Read the transaction context