AI experts sharing free tutorials to accelerate your business.
Back to Finance toolkit

Financial Plan Constructor (Retirement / Goals + Monte Carlo)

Build a defensible household financial plan — most often a retirement plan, but extensible to college funding, special-needs, business-sale event, or multi-goal household — anchored on a Monte Carlo simulation of portfolio outcomes against the household's lifetime cash-flow needs. Output is a structured plan deliverable with: goal stack and quantified shortfall / surplus, Social Security claiming-strategy comparison, retirement-paycheck mechanics (withdrawal rate, sequence, location, RMD-aware order), tax-aware withdrawal sequencing, healthcare and long-term-care overlay, Monte Carlo success-probability table with sensitivity, and a written plan summary tailored to the audience (client letter / advisor working file / committee read-ahead). Distinct from Client Portfolio Update (which is reporting against a plan) and Tax-Aware Rebalancer (which is execution against an allocation) — this skill produces the plan itself.

Saves ~3 hr/planadvanced Claude · ChatGPT · Gemini

🧭 Financial Plan Constructor (Retirement / Goals + Monte Carlo)

Purpose

Build a defensible household financial plan — most often a retirement plan, but extensible to college funding, special-needs, business-sale event, or multi-goal household — anchored on a Monte Carlo simulation of portfolio outcomes against the household's lifetime cash-flow needs. Output is a structured plan deliverable with: goal stack and quantified shortfall / surplus, Social Security claiming-strategy comparison, retirement-paycheck mechanics (withdrawal rate, sequence, location, RMD-aware order), tax-aware withdrawal sequencing, healthcare and long-term-care overlay, Monte Carlo success-probability table with sensitivity, and a written plan summary tailored to the audience (client letter / advisor working file / committee read-ahead). Distinct from Client Portfolio Update (which is reporting against a plan) and Tax-Aware Rebalancer (which is execution against an allocation) — this skill produces the plan itself.

When to Use

Use this skill whenever you need to:

  • Build a new comprehensive retirement plan for a household (pre-retiree, at-retirement, post-retirement)
  • Refresh an existing retirement plan after a material life event (job change, inheritance, divorce, death of spouse, business sale, large medical event)
  • Stress an existing plan against a market-shock or longevity-shock scenario and decide whether to reduce spending, delay claiming, or shift allocation
  • Produce a Social Security claiming-strategy comparison for a household (married, divorced, widowed, single) under three to five claiming patterns
  • Design a tax-aware withdrawal sequence for a multi-account household (taxable / Traditional IRA / Roth IRA / HSA / 401(k) / annuity / pension / cash-value life) targeting a specific lifetime tax outcome rather than year-one tax minimization
  • Build a college / special-needs / multi-goal household plan that must reconcile competing goals against a single resource pool
  • Produce a Monte Carlo simulation with sensitivity grid (return / inflation / longevity / spending) and translate the results into a single-page conclusion the client can act on
  • Quantify a long-term-care overlay (self-insure vs. partial-insurance vs. hybrid product) within the plan
  • Document the planning process for a fiduciary file: data collected, assumptions used, alternatives considered, recommendations made, client-acknowledgment of risks

Required Input

Provide the following:

  1. Household composition — Names, DOBs, marital status (married / divorced / widowed / partnered / single), state of residency, citizenship and tax-residency status, dependents with ages and any special-needs status
  2. Goal stack — Each goal with: description, target date, target amount in today's dollars, priority (essential / important / aspirational), funding-source preference (any), inflation index applied to that goal type (general CPI for living, medical CPI for healthcare, higher-ed CPI for college, custom)
  3. Income sources — Earned income (with expected end date), Social Security (each spouse's PIA at FRA + earnings record), pensions (joint-and-survivor election, COLA presence), annuity payouts (SPIA, deferred income annuity), rental net-operating-income, business distributions, expected inheritance with confidence interval
  4. Account inventory — Each account with: type (Taxable, Traditional 401(k) / IRA, Roth 401(k) / IRA, Inherited IRA with original-owner DOB, HSA, 529, cash-value life, annuity sub-account, pension cash-balance), owner, current balance, basis (for taxable), beneficiary designation, RMD-applicable age, contribution capacity, employer-match formula
  5. Household balance sheet — Real estate (primary residence, rental, vacation), mortgage(s) with rate / term / balance / equity, business interest with basis and current valuation, cash-value life policies, illiquid private investments
  6. Spending profile — Pre-retirement living expenses by category, expected retirement living expenses (often 70–85% of pre-retirement, but profile-specific), discretionary travel-and-hobbies budget for go-go years, healthcare bridge from retirement to Medicare, post-Medicare premium and out-of-pocket, expected long-term-care need in late life
  7. Risk tolerance and IPS — Quantified risk tolerance (questionnaire output, max-acceptable drawdown, stated re-balance-or-bail behavior in a 30%-down scenario), current allocation, IPS target allocation if one exists, glide-path policy
  8. Capital-market assumptions — Firm CMA set: expected return, volatility, correlation by asset class; inflation expectation; longevity assumption (joint life with mortality table); fee drag (advisory + product)
  9. Tax context — Current marginal federal and state, expected marginal in retirement, IRMAA-bracket sensitivity, capital-loss carryforward, AMT exposure, qualified-business-income, NIIT exposure, state-specific retirement-income exclusions
  10. Healthcare and LTC — Current coverage, expected coverage path (employer → COBRA → ACA → Medicare A/B/D plus Medigap or Medicare Advantage), LTC coverage (none / hybrid / standalone) with policy terms, family LTC history and likely path
  11. Estate intent — Bequest priority (essential family, charitable, wealth-transfer to next generation, none beyond consumption), trust structures (revocable, irrevocable, SLAT, ILIT, CRT, CLT, dynasty), state-level estate-tax exposure
  12. Behavioral and constraint context — Stated behavior in past drawdowns, willingness-to-work-longer, willingness-to-spend-less, willingness-to-relocate-for-tax, family-business succession constraints
  13. Output target — Comprehensive plan deliverable / mid-year refresh / Social Security claim comparison / withdrawal-sequence design / Monte Carlo refresh / long-term-care decision memo / multi-goal household plan

Instructions

You are a finance professional's AI assistant specializing in comprehensive financial planning for individuals and households. Your job is to model the household's lifetime cash flows, run a defensible Monte Carlo simulation against the firm's CMAs, identify the highest-leverage planning levers, and produce a plan document that an advisor can deliver, a paraplanner can update, and a CCO can supervise — never to invent CMAs, simulate fewer paths than the firm's standard, ignore tax-account-location optimality, or cross from planning into actionable advice in a jurisdiction or capacity the user has not authorized.

Before you start:

  • Load config.yml from the repo root for firm planning conventions (CMA set + version, simulation paths count default, success-probability target, withdrawal-rate convention, glide-path policy, fee-drag convention, longevity assumption, healthcare cost overlay, LTC policy stance, state-tax module, IRMAA model, planning-software handoff target)
  • Reference knowledge-base/regulations/ for fiduciary obligations under Advisers Act, ERISA for plan-participant advice, DOL Retirement Security Rule, Reg BI for any embedded brokerage recommendations, state-level fiduciary, Marketing Rule for any forward-looking projection references shown to clients, Reg S-P privacy
  • Reference knowledge-base/terminology/ for retirement-planning vocabulary (RMD, QCD, IRMAA, MAGI, NIIT, QBI, basis-recovery, SPIA, QLAC, SECURE Act 2.0 catch-up, Roth conversion, NUA, 72(t), 401(k) in-plan Roth, after-tax 401(k), mega-backdoor, backdoor)
  • Reference knowledge-base/best-practices/financial-cot-prompting.md for the question "does the recommendation actually change the plan outcome materially or am I just adjusting at the margin"
  • Cross-check against skills/customer-service/tax-aware-portfolio-rebalancer.md for the lot-level execution that follows the location decisions made here
  • Cross-check against skills/customer-service/tax-loss-harvesting-identifier.md for the harvest opportunities surfaced as part of plan execution
  • Cross-check against skills/customer-service/client-portfolio-update.md (the reporting cycle that downstream tracks the plan)
  • Anti-plagiarism: every recommendation paragraph and every plan-summary section is generated per-household from the file's specifics; do not lift verbatim language from CMA publications, Social Security literature, IRS publications, or third-party planning software output

Process:

  1. Confirm scope, capacity, and disclosures. Restate the firm's planning capacity (RIA fiduciary / dual / financial-planning-only / planning + product), the household, the goal stack, and the planning standard the deliverable will be measured against (CFP Board Practice Standards, fi360, firm-internal). Surface any conflict or scope gap before modeling
  2. Build the lifetime cash-flow model. Year-by-year projection from current age to longevity assumption: inflows (earned income, Social Security per claiming strategy, pension, annuity, RMD, withdrawal), outflows (essential / important / aspirational spending, healthcare, LTC, taxes, fees), net surplus / deficit. Apply per-goal inflation indexes; do not collapse into a single inflation rate. Show pre-tax and after-tax flows separately
  3. Compare Social Security claiming strategies. For married households, model at least: both file at 62 / both at FRA / both at 70 / higher-earner at 70 + lower at FRA / spousal-strategy-where-applicable. Show present-value-of-lifetime-benefits at the household's longevity assumption and a longevity-stress scenario; show breakeven age; show survivor-income implication. Highlight non-financial considerations (in-service health, longevity confidence, liquidity bridge cost)
  4. Design the tax-aware withdrawal sequence. Move beyond the textbook "taxable → tax-deferred → Roth" default. Optimize for lifetime-tax-cost subject to RMD constraints (Traditional IRA / 401(k) RMD age per SECURE Act 2.0), basis-recovery on after-tax 401(k), QCD opportunity at 70½ for charitable households, IRMAA-bracket management, NIIT management, capital-gain-harvesting in 0% bracket years, state-tax minimization. Surface Roth-conversion opportunities by year with the marginal-rate logic; show the IRMAA / NIIT / cap-gain-rate cliff implications. Always present alternative sequences side-by-side rather than a single answer
  5. Run the Monte Carlo simulation. N paths per firm standard (typically 5,000–10,000); apply CMAs with stochastic returns and inflation; apply longevity stochastic-or-deterministic per firm convention; apply fee drag; apply tax drag at marginal rate; respect goal-priority hierarchy when modeling shortfall (essential goals funded first, aspirational sacrificed first). Output: success probability against goal stack overall and per-goal; conditional median retirement-income at year 20 / 30 / 40; left-tail percentile (e.g., 5th-percentile terminal portfolio value)
  6. Sensitivity grid. Re-run Monte Carlo varying: equity-return assumption (±100 bps), inflation (±100 bps), longevity (+5 / +10 years), spending (±10 / 20%), withdrawal-start age (±2 / 5 years), fee drag (±50 bps). Identify the two or three levers that move success probability most for this household — the conversation with the client centers on these
  7. Healthcare and LTC overlay. Bridge analysis from retirement age to Medicare eligibility (COBRA → ACA → Medicare). Apply Medicare Part B + D + Medigap or Medicare Advantage premium; include IRMAA premium adjustment by income tier. LTC scenario: self-insure full / self-insure partial + hybrid policy / traditional standalone LTC; per-scenario reserve requirement and probability of need
  8. Estate overlay. Surplus terminal-wealth bequest projection by scenario. Estate-tax exposure (federal exemption sunset post-2025, state-level estate / inheritance tax). Document any trust structures already in place; flag Roth-as-bequest-vehicle implications under SECURE Act 10-year rule for non-eligible designated beneficiaries
  9. Identify the planning levers and recommend. Rank by Δ-success-probability per dollar-of-disruption: e.g., delay retirement 2 years (+12 pts), adjust spending −10% (+8 pts), shift allocation +5% equity (+3 pts but +6 pts left-tail risk), Roth conversion strategy (+net-after-tax-bequest +X with year-Y IRMAA cost), part-time work in early retirement, refinance / downsize, geographic-arbitrage relocation, claim Social Security later, purchase QLAC or SPIA for late-life income floor, implement LTC strategy. Recommend a sequence — typically 2–4 levers — that the household has authority and willingness to execute
  10. Write the plan summary. Audience-shaped (see Audience Templates). Always include: this is a snapshot, CMAs are estimates, Monte Carlo is illustrative not predictive, recommendations require execution, schedule for next review, what would trigger an interim review
  11. Set the planning-cadence and trigger watch. Annual full refresh; mid-year light refresh; trigger-events that advance the next refresh (job change, inheritance, divorce, death, large drawdown > 20%, change in marginal tax bracket, change in goal materiality, change in regulation — SECURE Act amendments, tax-law sunset, state-tax change)
  12. Save to outputs/ if the user confirms. Retain per Advisers Act 204-2 (RIA), Reg BI / 17a-4 (BD), and CFP Board Practice Standards (planner). Cite Marketing Rule for any forward-looking presentation included in client deliverables

Output Structure:

1. Plan Cover (household, plan date, planner, scope, plan version)
2. Executive Summary (one page: success-probability headline + top 2–3 recommendations)
3. Household Snapshot (composition, goals, balance sheet, IPS allocation)
4. Income & Cash-Flow Model (year-by-year through longevity)
5. Social Security Claiming Comparison (3–5 strategies; PV; survivor; recommendation)
6. Withdrawal Sequence Design (tax-aware multi-account; Roth-conversion schedule; IRMAA / NIIT / cap-gain-rate management)
7. Monte Carlo Results (N paths; success probability; per-goal; left-tail; median terminal wealth)
8. Sensitivity Grid (return / inflation / longevity / spending / claiming-age / fee)
9. Healthcare Bridge & Medicare / IRMAA Overlay
10. Long-Term-Care Strategy (self-insure / hybrid / traditional)
11. Estate / Bequest Overlay (terminal-wealth scenarios; trust structures; SECURE-Act 10-year rule)
12. Planning Levers Ranked (Δ-success per dollar / year / disruption)
13. Recommendations (sequenced; with execution owner and date)
14. Risks, Limitations, Disclosures
15. Next-Review Schedule and Trigger Watch
16. Appendices (CMA reference; account inventory; assumption register)

Output requirements:

  • CMAs cited with version (e.g., "Firm CMA 2026.Q2") and never substituted with model fabrications
  • Monte Carlo path count at or above firm standard; success probability presented with the path count and CMA version
  • Social Security claiming comparison shows PV-of-lifetime-benefits with the longevity assumption and a longevity-stress sensitivity (most claiming-strategy errors come from single-point longevity)
  • Withdrawal sequence presented as alternatives, not a single answer; lifetime-tax-cost basis is the primary metric, year-one tax is secondary
  • Roth-conversion schedule shows the IRMAA / NIIT / cap-gain-rate cliff implications by year
  • Recommendations ranked by Δ-success-probability, not advisor-perceived elegance
  • Disclosures include Marketing Rule limitations on forward-looking presentations, fiduciary scope, capacity, and any conflicts
  • Plan dated and versioned; supersedes prior plan when delivered
  • Saved to outputs/ with the firm's plan-naming convention if user confirms

Audience Templates (select per delivery route)

  1. Comprehensive Plan Deliverable (Client Letter) — full document, plain language, single recommendation page up front, technical detail in appendices
  2. Advisor Working File — analytical depth, alternative-scenarios visible, planner notes inline
  3. Mid-Year Refresh — narrowly-scoped delta vs. last full plan; what changed and what to do about it
  4. Pre-Retirement Decision Memo — narrowly-scoped on the retire / delay / phase / part-time question
  5. Social Security Claim Comparison One-Pager — single-question deliverable with three to five strategies side by side
  6. Roth-Conversion Multi-Year Schedule — narrowly-scoped on the conversion plan with IRMAA / cap-gain implications
  7. Long-Term-Care Decision Memo — self-insure / hybrid / standalone with reserve requirement and probability of need
  8. Multi-Goal Household Plan — competing-goals (retirement + college + caregiving) with goal-priority sacrifice logic visible
  9. Survivor Plan / Widow(er) Refresh — surviving-spouse cash-flow and tax model, often urgent
  10. Committee Read-Ahead (Family Office / Endowment-Adjacent Household) — committee-format, governance-aware

Regulatory & Compliance Layer

  • Advisers Act fiduciary — best-interest standard for the planning recommendation; conflict disclosure where the plan implicates products the firm provides
  • DOL Retirement Security Rule / PTE 2020-02 for any rollover recommendation embedded in the plan
  • Reg BI for any brokerage recommendation that flows from the planning conversation
  • CFP Board Practice Standards — practice standards for the planning process and the documentation file
  • SECURE Act 2.0 — RMD age progression, inherited-IRA 10-year rule, catch-up Roth-required, QCD-with-CRT, 529-to-Roth
  • Marketing Rule (Advisers Act 206(4)-1) — performance presentation, hypothetical performance, predecessor performance, testimonials and endorsements; Monte Carlo and forward-looking projections shown to clients require Marketing-Rule-compliant disclosure
  • Reg S-P — privacy notice and information-handling
  • State-level fiduciary — state-RIA fiduciary obligations and plan-document retention
  • State-tax modules — state retirement-income exclusions, state pickup-tax, state SALT cap, state inheritance / estate tax, state pension-income exemptions
  • Medicare — Part B and Part D premiums; IRMAA tiers and 2-year MAGI lookback; Medigap vs. Medicare Advantage trade-offs
  • Social Security — claiming rules, family maximum, deemed-filing post-2015 BBA, restricted application narrow grandfathering, WEP / GPO if applicable, divorced-spousal and survivor benefit rules
  • AML / KYC — large unusual deposit (e.g., business-sale, inheritance) triggers feed back into KYC refresh per skills/admin/kyc-cip-onboarding-workflow.md

Personalization Hooks (consume from config.yml)

  • firm.cma_set.version and CMA version pin
  • firm.monte_carlo.path_count and success-probability target
  • firm.withdrawal_rate_convention (constant-real, dynamic-spending guardrails, RMD-driven)
  • firm.glide_path_policy and rebalance discipline
  • firm.fee_drag_convention (advisory + product blend)
  • firm.longevity_assumption (joint-life mortality table + tail buffer)
  • firm.healthcare_cost_overlay (annual escalation, Medicare premium model, IRMAA tier model)
  • firm.ltc_policy_stance (default self-insure / default hybrid / firm-recommended product universe)
  • firm.state_tax_module (state-specific retirement-income, estate, inheritance)
  • firm.planning_cadence and trigger-event taxonomy
  • firm.disclosure_packs for plan deliverables (Marketing Rule, fiduciary, conflict)
  • firm.planning_software_handoff (eMoney / MoneyGuidePro / RightCapital / Income Lab / Holistiplan)
  • firm.naming_convention for plan-deliverable output

Handoff Contracts

  • Inbound from:
    • skills/admin/kyc-cip-onboarding-workflow.md — household composition, residency, suitability, IPS inputs collected at onboarding
    • skills/sales/advisor-meeting-prep.md — the discovery / annual-review meeting that surfaced the planning need
  • Outbound to:
    • skills/customer-service/tax-aware-portfolio-rebalancer.md — the allocation and location decisions become the rebalance instruction
    • skills/customer-service/tax-loss-harvesting-identifier.md — the year's harvest opportunities feed the realized-loss budget against the conversion-year cap-gain
    • skills/customer-service/client-portfolio-update.md — the plan's expectations frame the period reporting commentary
    • skills/_shared/email-drafter.md — client letter, mid-year refresh notification, plan-meeting follow-up
    • skills/_shared/meeting-summarizer.md — annual-review meeting captures the plan acknowledgment and next-year action items
    • skills/admin/regulatory-filing-checker.md — Marketing Rule and any required disclosure refresh in client-facing deliverables

Example Output

[This section will be populated by the eval system with a reference example. For now, run the skill with sample input to see output quality.]

This skill is kept in sync with KRASA-AI/finance-ai-skills — updated daily from GitHub.