Skip to content
PromptReady to runNewPersonal FinanceFinance

Estate Tax Projection Workbook

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Aug 19, 2026

Editorially graded · Aug 19, 2026

Builds a personalized four-tab federal and state estate-tax projection workbook (EstateTaxImpactSummary.xlsx) from a user's own asset inventory, ownership structure, and domicile, with live formulas for gross estate, deductions, tentative tax, unified credit, and state exposure — all assumptions clearly labeled. Use when an individual, estate planner, or CPA needs a one-time working estate-tax projection to review before or after a major life event (marriage, inheritance, relocation, or a law change like a federal exemption sunset).

What you get

A ready-to-paste prompt you can drop into your AI. Produces an Excel workbook (.xlsx).

Works in
Claude · ChatGPT · Gemini
Paste it in, fill the [brackets]
Any AI assistant
Works anywhere you can paste text

See it in action

A real input → output sample

Sample input
Here's our asset snapshot for the estate projection: 
1. Primary residence — joint tenancy w/ right of survivorship with spouse, FMV $1,850,000, basis $620,000, my contribution was 50%
2. Investment condo — sole ownership, FMV $740,000, basis $310,000
3. Vanguard brokerage — joint tenancy w/ spouse, FMV $3,200,000, basis $1,400,000
4. Traditional IRA — sole, FMV $2,100,000, basis $0
5. Family LLC (closely-held business) — 100% member, FMV $6,500,000, basis $1,200,000
6. Whole life insurance — I own it, death benefit $2,000,000, beneficiary is my spouse
7. Checking/savings — sole, FMV $180,000, basis $180,000
8. Personal property (cars, art, jewelry) — sole, FMV $220,000
State of domicile: New York
Marital status: Married, spouse is a U.S. citizen
Tax year to model: 2024
Sample output
Sample Excel output produced by the Estate Tax Projection Workbook prompt
Produced by an AI assistant following this prompt on the sample input above.
View the full output as text
Example Output
Gross Estate: $14,265,000
Federal Estate Tax Due: $0
State Taxable Estate (NY): $9,740,000
NY Cliff Rule: Triggered (the estate exceeds 105% of the 2024 NY basic exclusion of $6,940,000, so the whole taxable estate is taxed on the graduated schedule — not just the amount over the exclusion)
Screening Estimate of NY Tax: $1,028,080

Questions

What do I need to provide to get my workbook built?

An asset inventory (description, ownership type, value, basis), state of domicile, and marital status/spouse citizenship. If you have debts, prior gifts, or a DSUE amount, include those too. Anything missing is defaulted and listed plainly in the reader note.

What happens if I don't know some of my numbers, like an asset's value or my state of domicile?

It never leaves cells blank or inserts placeholders. Unknown values use a labeled midpoint or conservative estimate; unknown domicile defaults to a federal-only projection with state analysis flagged as skipped. All assumptions are stated plainly in a reader note, ending with "Complete" or "Needs input: N item(s)."

What exactly is in the workbook I receive?

EstateTaxImpactSummary.xlsx with four tabs: Asset Valuation (itemized assets with ownership and basis logic), Federal Estate Tax Projection (gross estate through net tax due, full bracket table), State Tax Snapshot (state-specific exposure and flags like the NY cliff), and Recommendations (narrative tied to your actual numbers plus a disclosure).

Can I edit my numbers after I get the file, or is it locked?

Yes. All input cells are editable and formula cells recalculate live, so changing an asset value or exemption figure updates the whole projection. The workbook is fully unprotected — nothing is password-locked.

How is this different from just asking my assistant a question about estate tax?

It produces an actual editable spreadsheet with linked formulas mirroring Form 706 line structure, not a text answer. It applies the current bracket table, ownership and basis rules, and state-tax distinctions per asset, and clearly labels every assumption instead of giving a one-off narrative response.

Related