Confidential Seller Worksheet
A line by line projection of what you keep at settlement.
Drives the property tax proration.
Use the lender's payoff figure, not the statement balance.
Only if the seller agreed to pay it.
Seller side only. In Delaware the buyer usually pays the settlement fee and title work, so this is often just the mortgage satisfaction and wire payoff fees.
Full July 1 to June 30 bill.
Refund of prepaid days. Sewer bills on the calendar year.
Toward the buyer's closing costs, per the contract.
From inspection negotiation, separate from the concession above.
Home warranty, survey, withholding tax, attorney review, unpaid assessments.
Settlement date not set
Costs and adjustments
Commissions
Government and title
Taxes, utilities, and prorations
Credits to buyer
Other
Loan payoffs
Estimated net proceeds to seller
$0.00
Enter a sale price to begin.
Also coming to you Any balance left in your mortgage escrow account is refunded by your lender, separately from settlement, typically 20 to 30 days after the loan is paid off. If the county tax bill is collected at settlement above, that escrow balance is where the money you paid in all year comes back to you. It is not part of the figure above and it is not lost.
How to read this. Amounts in parentheses are deducted from your sale price. Figures in green are credited to you.
Debits minus credits equal the net costs and adjustments line, and net proceeds plus payoffs plus net costs equal the sale price.
This worksheet is an estimate prepared for planning purposes and is not a settlement statement, a payoff quote, or tax advice.
Actual figures are set by the settlement agent on the closing disclosure and will move with the settlement date, per diem interest,
and final prorations. Confirm all payoff amounts directly with your lender.
Property tax proration. New Castle County taxes cover the July 1 to June 30 tax year and are prorated at a daily
rate of the annual bill divided by the days in that year. The seller carries July 1 through the day before settlement and the buyer
reimburses the seller from the settlement day through June 30, so the proration is always a credit to the seller. Set the bill to
Collected when the settlement agent will collect the full year bill at closing, which is standard for a settlement in the new
tax year before the bill is satisfied. Set it to Already paid when the seller or their escrow account has paid the bill
directly, in which case only the credit appears. Either way the seller's true burden is only the days they owned.
Transfer tax. Delaware realty transfer tax runs 4 percent of the sale price, customarily split evenly between buyer
and seller, so 2 percent is the usual seller share. In New Castle County that seller share appears on the closing disclosure as two
lines, roughly 0.75 percent to the county and 1.25 percent to the state.