Net to heirs by year of death
At death (Year N)
Net to heirs = trust value + beneficiary value − Illinois estate tax. The memo lines show the income-tax and interest drag that explains the value gap.
Income tax over the whole period
Warnings & overrides
Optional — exact IL estate tax at death
$
$
How to get exact figures
1. Read the Year-N taxable estate from the Year-by-Year tab (final row, columns A: Ben tax estate and B: Ben estate).
2. Enter each in the Illinois AG calculator (box 1 = box 2 when there are no lifetime gifts).
3. Paste the results above to drive the recommendation.
Strategy C — capital gains carried out as DNI
Allow only if the trust instrument (or local law / consistent practice) brings capital gains into DNI under Reg. §1.643(a)-3. When allowed, Strategy C is evaluated alongside A and B; otherwise it's locked out.
Assumptions
Blue values are yours to change. Set these to the client's actuals — the embedded-gain %, the medical amount/duration, and the horizon drive the result most.
Sensitivity — how the decision moves with one assumption
Sweep a single driver across a range (all other inputs held at their current values) and watch net-to-heirs for each strategy. Where the lines cross is the assumption value that flips the recommendation.
Strategy A
Strategy B
dashed = current value
Sensitivity table
Year-by-year projection
Strategy A funds care with a new interest-only loan each year (the stack and its interest grow); Strategy B distributes and sells each year. Scroll right for all columns.
Illinois estate tax — calibrated estimator
Marginal brackets calibrated to the AG calculator. The IL tax is not a direct lookup from the §2011 table — Illinois runs it through an interrelated calculation that lowers the result.
matches the IL AG calculator, $4M–$15M
Exact $4M–$15M (every segment calibrated to your AG data points — see the validation below). Above $15M the 13.79% top marginal (= 16% ÷ 1.16) continues, so the estimate holds at any realistic size; use the overrides for exact Form 700 figures.
Validation — model vs. AG calculator
Quick calculator
$
§2011 State Death Tax Credit table — statutory basis (reference)
Applied to the adjusted taxable estate (estate − $60,000). The frozen federal credit table Illinois uses as its basis; the actual tax is this run through the interrelated calculation (lower). Reference only — not a direct lookup.
Audit trail — stage-by-stage math
Every intermediate quantity for a single year, computed from the current inputs. Use it to tie each figure back to its formula. Advisor-only — hidden in Client view.
yr
Horizon roll-up — what feeds the recommendation
Formula reference
Planning tool, not tax or legal advice. Confirm figures, growth assumptions, and elections with the client's CPA and estate-planning counsel.
brandon-tools.net