🛠️ Passion Project • Built for Personal Wealth & Scenario Modeling

Personal Wealth & Scenario Modeling
System Features & Architecture

Developed as a personal project to address household finance edge cases that standard tools don't cover—including multi-plan scenario trees, private company equity buybacks, statutory state death taxes, and multi-year education tuition schedules.

🔒 Private Family System: Live sign-in is strictly limited to authorized family members. Guests can explore all features using the pre-seeded demo sandboxes below.

Interactive Model

Compare Scenarios: Baseline vs. Child Plans

Projected Net Worth (Age 65)
$14,280,000
Baseline trajectory at 7.0% nominal return
Retirement Readiness
Age 55.0
100% Monte Carlo success probability
529 Education Reserves
$385,000
Segregated custodial wealth for 2 children
Portfolio Outflow Impact
$0 / yr
Living expenses funded from ordinary cash flow
Parent Plan

Baseline Current Trajectory

Your master scenario. All other plans branch off this foundation, inheriting your accounts, salary, and savings rates while testing individual what-if decisions.

💡 Click the tabs above to see how child plans isolate variables without breaking your baseline.
💡 The Core Concept

Why Traditional Calculators Fall Short: The "Parent & Child" Plan Model

Most retirement tools give you a single rigid projection line. But in real life, financial planning is about comparing forks in the road. In this tool, you start with a Parent Plan (your baseline trajectory) and spawn lightweight Child Plans to test specific life decisions side-by-side—like testing "Pay for Harvard" versus "Pay for in-state school"—to see the exact net worth difference and retirement age impact 20 years later without breaking your master numbers.

Pillar 1: Scenario Modeling

Scenario Branching via "Parent & Child" Plan Hierarchies

Instead of managing separate spreadsheet copies, the forecasting engine uses an inheritance hierarchy to compare financial trajectories side-by-side.

Isolated Decision Overrides

A Parent Plan represents baseline ground truth. Specific life decisions (such as college choices or major property purchases) are modeled as lightweight Child Plans that inherit baseline accounts and cash flows while isolating specific modifications.

  • Child Plan Isolation: Test "Pay for Ivy League" vs. "In-State Public" or "Retire at 50" vs. "One More Year" without altering your baseline.
  • Side-by-Side Diff Scorecard: Instantly compare liquid wealth at age 60, retirement readiness age, and cumulative tax drag across plans.
  • One-Click Inheritance Sync: When your real-world savings or salary changes, all child branches automatically update their core assumptions.
Plan Comparison Scorecard Real-Time Simulation
SCENARIO PLAN RETIRE AGE NW AT 65 STATUS
🌿 Baseline Trajectory Age 55.0 $14.28M Optimal
↳ Child: Harvard Tuition Age 56.5 (+1.5y) $13.42M (-$860k) Feasible
↳ Child: In-State Public Age 55.2 (+0.2y) $13.95M (-$330k) Optimal
↳ Child: Vacation Home Age 58.0 (+3.0y) $12.10M (-$2.18M) Trade-Off
⏱️

Continuous Timeline Ribbon Scrubber

Drag the scrubber needle smoothly across a 50-year horizon from 2026 to 2076. Zoom into specific decades to see exactly when children start college, options vest, or mortgages amortize.

Interactive HTML5 Canvas
🎲

1,000-Trial Stochastic Monte Carlo

Stress-test plans against sequence-of-returns risk. Simulates 1,000 randomized market paths with geometric Brownian motion and historical crisis replay (2008 GFC, 1970s stagflation, 2000 dot-com crash).

10th–90th Percentile Corridor
📊

Actuarial Joint Longevity Curves

Incorporates official Social Security Administration cohort life tables to evaluate surviving spouse income safety and joint survival probabilities up to age 100.

SSA Actuarial Integration
Pillar 2: Education Modeling

Tuition Ledger Integration & 529 Outflow Modeling

Connects multi-year school tuition schedules directly to long-term forecast cash flows, modeling tax-free 529 depletion and parental liquidity impact.

Dual-Mode Education Events

Education milestones support two operational modes: syncing directly with recorded tuition schedules, or overriding values to test hypothetical college scenarios.

  • `[ 🔗 Synced with Ledger ]`: The simulation pulls grade progression, enrolled tuition rates, and graduation years directly from your education schedule.
  • Automatic 529 Custodial Depletion: Tuition is drawn tax-free from the child's dedicated 529 reserve first. Only after the 529 is exhausted does the engine draw shortfall cash from parents' liquid brokerage.
  • SECURE 2.0 § 126 Roth Rollover: Up to $35,000 of leftover 529 reserves per child can roll tax-free and penalty-free into their personal Roth IRA.
Event Wizard: Data Source Mode Live Ledger Linked
Education Ledger Synced
Academic Years 2029–2033 • High School Class of 2029 • 529 Reserves: $214,800
ℹ️ When tuition schedules are updated in the Education tab, linked scenario forecasting cash flows update automatically.
Pillar 3: Equity Modeling

Stock Option Vesting, Secondary Liquidity & State Taxes

Models ISO and NSO grant schedules, exercise strikes, cashless company repurchases, and jurisdiction-specific capital gains taxes.

📈

Vesting Schedule Tracking

Tracks multiple grant tranches, exercise strike prices, fair market value (FMV) growth, and 83(b) holding periods across startup and pre-IPO cycles.

ISO & NSO Support
💵

Cashless Company Buyback Modeling

Simulate secondary tenders and executive repurchases. Calculates exact net proceeds after withholding and models immediate reinvestment into index portfolios.

Secondary Liquidity
🏛️

Statutory State Capital Gains Taxes

Computes statutory liabilities including Washington State's 7.0% Capital Gains Tax (§ 82.87) with $250k standard exemption, and California ordinary income tax.

Statutory State Rules
Pillar 4: Estate & Generational Wealth

Statutory State Estate Taxes & Irrevocable Trust Vehicles

Calculates statutory state estate tax liabilities, post-2025 federal exemption sunset impacts, and irrevocable trust cash flows.

State Death Taxes & Trust Cash Flow Modeling

Models state-specific death tax formulas and evaluates the financial effect of transferring appreciating assets into irrevocable trusts.

  • Statutory State Death Tax Engines: Washington (RCW 83.100 graduated 10%–20%), New York (Tax Law § 952 graduated 3.06%–16% with 105% cliff penalty that erases the exemption), Massachusetts & Oregon low thresholds, and 0% states (CA, TX, FL, NV, WY).
  • Federal Exemption Sunset Toggle: Compares current $28M MFJ exclusion against the post-2025 TCJA sunset back to ~$14M MFJ.
  • Irrevocable Trust Vehicles: Model SLATs (Spousal Lifetime Access Trust), IDGTs (Intentionally Defective Grantor Trust with grantor tax burn), GRATs (IRS § 7520 hurdle rate), and ILIT life insurance liquidity.
  • Multi-Decade Inheritance Waterfall: Project net distributions to children and charitable legacies across ages 80, 85, 90, and 95.
State Estate Tax Arbitrage $20M Taxable Estate
Washington State (RCW 83.100) $3,260,000 (16.3%)
New York (105% Cliff Penalty) $2,544,000 (12.7%)
Massachusetts ($2.0M Threshold) $2,080,000 (10.4%)
California, Texas, Florida, Nevada, Wyoming $0 (0.0% State Death Tax)
State calculations reflect statutory formulas, brackets, and exemption cliff rules.
Pillar 5: Tax Modeling

Multi-State Tax Comparison & IRS Transcript Ingestion

Calculates comparative state income tax liabilities across five states and parses IRS Form 1040 Account Transcripts for safe harbor verification.

🗺️

5-State Tax Arbitrage Engine

Side-by-side comparison of net take-home in Washington (0% income tax), California (up to 13.3%), New York (state + NYC local tax), Texas (0%), and Florida (0%).

W-2, Equity & Yield
📜

IRS Account Transcript Reconciliation

Ingests official IRS Form 1040 Account Transcripts, extracting quarterly estimated tax payments, safe harbor thresholds, and refund tracking without manual data entry.

IRS Form 1040 Parser
💳

Payroll Withholding & Safe Harbor

Reconciles bi-weekly payroll withholdings across both spouses to prevent IRS underpayment penalties (IRC § 6654 110% prior-year safe harbor rules).

Penalty Prevention
Security & Privacy Architecture

System Security & Data Isolation

Personal wealth records are protected using column-level Fernet AES-256 encryption at rest and isolated database universes for demo sessions.

🔐
At-Rest Fernet AES-256

All sensitive account balances, salaries, equity grants, and personal identifiers are encrypted at rest using AES-256 (Fernet).

🛡️
Dynamic Encrypted Storage

All personal details and financials are loaded dynamically from encrypted storage.

🌐
Database Universe Routing

Production data is strictly isolated from demo sandboxes using dynamic universe proxies and read-only demo guardrails.

Explore the Demo Sandboxes

Because direct sign-in is reserved for our household, you can experience all functionality—including multi-plan scenario trees, 529 education syncing, and option modeling—through the simulated demo profiles above.

Explore Demo Sandboxes Family Sign In (Restricted)