Life insurance and estate liquidity worksheet
The worksheet adds the taxes, debts, equalization and settlement costs an estate pays in cash, then subtracts liquid assets and qualifying life insurance to show the remaining gap. Every result reflects only the figures the reader enters as inputs.
Run the numbers
Example values are filled in. Replace them with your own figures.
| Result | Amount |
|---|
What the calculator shows
An estate often owes a lot of cash within a short window after death, while much of the wealth sits in a business, real estate or private holdings that are slow to turn into cash. The worksheet lines up the cash demands against the cash resources. The difference is the remaining gap.
Four kinds of payouts are counted. They are estate taxes, debts and business obligations, an amount to equalize between heirs, and administration and settlement costs. The settlement cost line is a sample figure that the reader fills with a personal estimate.
Two kinds of resources are counted. One is liquid assets the estate will hold, such as cash and marketable securities. The other is life insurance payable to the estate or to a trust that can lend to or buy from the estate. Because the tool is for education, it shows the arithmetic and does not judge any plan.
How the arithmetic works
Step one adds four numbers. Total cash paid out equals estate taxes plus debts plus the equalization amount plus settlement costs. Taxes include any tax triggered by insurance proceeds that sit in the gross estate.
Step two adds the resources. Insurance payable to others does not enter this line.
Step three takes the difference between the two totals. Remaining gap equals total cash paid out minus available cash. A positive result means cash demands exceed resources, and a negative result means resources exceed demands.
How to read the result
A positive gap is the amount of cash the estate would have to raise from somewhere else, such as selling an asset, borrowing or drawing on the business. The larger the gap compared with the illiquid assets, the more pressure sits on those assets at an inconvenient moment.
A gap of zero or below means the listed resources cover the listed payouts. A surplus is not a promise of coverage, since every input is an estimate that moves with values, rates and timing.
Changing one input at a time shows which line moves the result most. Equalization often swings the answer for owners whose business passes to one heir while other heirs receive different assets. Running a few cases with different values for taxes and insurance shows a range instead of a single point.
Where owners get surprised
Insurance proceeds can raise the estate tax bill.
Business obligations are easy to undercount. Loans the owner backed personally, buy-sell commitments, deferred compensation and lease obligations can all come due or become claims when the owner dies. Owners who list only mortgage and credit balances report a payout total smaller than the full set of obligations.
When one heir receives a business or property and the others receive other assets, the cash required to even things out can be large. Leaving that line at zero hides a cash demand that heirs notice when they compare shares.
Common questions
What counts as liquid assets in the worksheet?
Liquid assets are holdings the estate can turn into cash quickly without a steep price cut, such as bank balances and marketable securities. Business interests and most real estate are usually treated as illiquid. The reader decides what to enter on that line.
Why does the worksheet count insurance payable to a trust that can lend to or buy from the estate?
Proceeds paid to such a trust can reach the estate as a loan or as a purchase of estate assets, so the cash becomes usable for the payouts. Insurance paid straight to a beneficiary stays outside the estate cash picture. Whether a given policy qualifies depends on its ownership and terms.
Does a negative gap mean the estate is fully covered?
A negative gap means the entered resources exceed the entered payouts. Because every figure is an estimate, the real outcome can differ from the entered figures. The result is an education aid built from the reader's own numbers.