Seller Net Proceeds Sheet
Estimated seller net proceeds, itemized selling costs, the property-tax proration.
Example
You enter
- Sale price ($) 400000
- Mortgage payoff ($) 250000
- Commission (%) 5.5
- Transfer/excise tax (%) 0.5
- Title/escrow/attorney fees ($) 2500
You get
- Estimated net proceeds $123500
- Commission 22000
Checked against published worked examples from: TILA-RESPA Closing Disclosure (12 CFR 1026.38) / RESPA.
Details, formula, and sources
ScopeEstimated seller net proceeds, itemized selling costs, the property-tax proration, and the effective cost of sale percent.
Formula or tablecommission = price*rate; transfer_tax = price*rate; tax_proration = annual_tax*days_seller_owes/365; net = price - payoff - commission - transfer_tax - fees - concessions - proration - other.
Source and editionPer the TILA-RESPA Integrated Disclosure / Closing Disclosure (12 CFR 1026.38) and RESPA (12 CFR 1024), by name; the transfer-tax rate is state/local and user-supplied.
Free accessDistinct from the buyer-side closing-costs tile. Estimate; the settlement statement and closing agent govern. Free at consumerfinance.gov and ecfr.gov.
What governsEstimate. AHJ and licensed professional govern.
API field namesprice, payoff, commission_pct, transfer_tax_pct, fees, net_proceeds, commission
- Payoff includes per-diem interest and any prepayment penalty not in the principal balancesettlement practice