Estate settlement cash flow worksheet
The worksheet lists the cash arriving in an estate and the payments leaving it during settlement, then subtracts one from the other. It runs on the reader's own numbers for cash, sale proceeds, debts, expenses, taxes and gifts.
Run the numbers
Example values are filled in. Replace them with your own figures.
| Result | Amount |
|---|
What the calculator shows
The worksheet gathers every dollar expected to arrive in an estate and every payment expected to leave it during settlement. Settlement is the stretch between a death and the final handoff to heirs, when the estate pays its bills. Laying both sides in one place shows whether the estate holds enough cash to cover its obligations.
Cash coming in has two sources. One is cash and accounts already held in the estate, and the other is the net amount expected from selling assets such as a business interest or a building. Net means after selling costs and tax on the sale, so only the usable remainder enters the total.
Cash going out has five groups. They are debts and creditor claims, funeral and final expenses, court and administration costs, taxes due at settlement, and cash gifts to heirs. Every figure comes from the reader's own estimates, because the worksheet holds no default values.
How the arithmetic works
Step one totals the cash coming into the estate. Cash in equals estate cash plus sale proceeds net of costs and tax. Step two totals the cash going out, which equals debts plus final expenses plus administration costs plus taxes plus cash gifts. Step three subtracts the total outflow from the total inflow to give the net.
A small example with round sample units shows the flow. If estate cash is 10 and net sale proceeds are 20, cash in is 30 units. If the five outflow groups add to 25 units, the net is 5 units.
The sale proceeds line deserves attention because the formula expects the figure after costs and tax. Entering a gross sale price there would overstate the incoming cash. Tax triggered by the sale belongs inside that net figure, while taxes due at settlement cover the estate's own income tax and any estate tax.
Assumptions and limits
The worksheet does not model timing, and the order in which claims are paid depends on state law.
How to read the result
A positive net means the listed cash covers the listed payments with a surplus. That surplus is cash still held by the estate after settlement on the figures entered. A negative net means payments exceed incoming cash, a shortfall in the totals.
The size of the net matters less than its direction and its cushion. A net near zero leaves little room if a claim arrives late or a sale closes at a lower price. A wide positive net tolerates more surprises in the inputs.
Each outflow group also carries a different degree of certainty. Funeral costs are usually known quickly, while creditor claims and taxes can change as filings are reviewed. Reading the result alongside that uncertainty gives a truer picture than a single number.
Where owners get surprised
Owners often find that wealth sits in assets that do not turn into cash on demand. A business interest, a building or a private fund stake may take a long stretch to sell, so cash in can arrive well after cash out is due. The worksheet shows the gap in totals but not in timing.
Taxes are another common source of surprise. The estate can owe income tax on its own earnings during settlement, and estate tax may apply depending on an exclusion amount which changes over time and comes from an official source. Rates also differ between federal and state systems.
Cash gifts to heirs sit last in the outflow list. Debts, expenses and taxes generally come due before heirs receive anything, so a gift listed in full can turn out smaller when the net is negative.
Common questions
What counts as sale proceeds net of costs and tax?
The figure is the sale price after brokerage, closing and similar costs and after any tax triggered by the sale. Only that remaining amount belongs in the cash-in total. Entering the gross price would overstate the cash available.
Why are cash gifts listed with the payments out?
Cash gifts leave the estate just as debts and expenses do, so the formula counts them as outflow. Listing them shows whether the estate can fund the gifts after covering every other obligation. A negative net signals that gifts, as entered, exceed the remaining cash.
Does the worksheet give a legal or tax answer?
The worksheet is education only and performs arithmetic on the reader's own estimates. Tax rules, exclusion amounts and rates change and vary by place, so each entry reflects the reader's own research. The result describes a hypothetical settlement, not a legal outcome.