All skills
joellewis avatar

/proposal-generation

@cf3e6ba
by joellewisjoellewis/finance_skills200 stars
37

Generate end-to-end investment proposals covering risk profiling, model portfolio recommendation, fee illustration, projections, and compliance review. Use when the user asks about creating a proposal for a prospect, mapping risk questionnaire scores to model portfolios, building fee illustrations with tiered costs, producing Monte Carlo or scenario projections, analyzing a prospect's current portfolio for improvement opportunities, reviewing proposals for SEC Marketing Rule compliance, or designing proposal templates for a multi-advisor firm. Also trigger when users mention 'investment proposal', 'proposal generation', 'risk profiling', 'Riskalyze', 'Nitrogen', 'fee illustration', 'transition analysis', 'current vs proposed portfolio', or 'proposal compliance review'.

Use this Skill: https://skilld.dev/gh/joellewis/finance_skills/proposal-generation

This session only. Nothing lands on disk.

referencesexamples.md

≈3.4k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Worked Examples — Proposal Generation

Example 1: Generating a proposal for a new prospect with a $2M rollover from a 401(k)

Scenario: A 58-year-old prospect recently left her employer and has $2M in a 401(k) plan invested in a mix of target-date funds and company stock. She is considering rolling the assets to an IRA managed by an advisory firm. She has no other significant investable assets outside her home. She plans to retire at 63 and needs the portfolio to generate $80,000/year (in today's dollars) in retirement income starting at age 63. She completed the firm's risk questionnaire and scored 42 out of 100 (Moderate).

Design Considerations:

  • The rollover is from a 401(k) to a Traditional IRA, which is a tax-free direct rollover if handled properly. The proposal should explicitly note that this is a direct (trustee-to-trustee) rollover, not a distribution, to avoid a taxable event.
  • The 5-year time horizon to retirement combined with a Moderate risk score suggests a portfolio in the Moderate to Moderate Conservative range. While the risk score maps to Moderate (50/50 equity/fixed income), the relatively short time horizon and high dependence on this single portfolio for retirement income argue for a more conservative positioning. The advisor should consider recommending the Moderate Conservative model (35/65) or a custom blend, and document the rationale for any deviation from the standard risk mapping.
  • Retirement income analysis: $80,000/year starting at 63, adjusted for 2.5% inflation, funded by a $2M portfolio over a 30+ year retirement (to age 95). The proposal should include Monte Carlo analysis showing the probability of sustaining this income. At a 4% initial withdrawal rate ($80,000/$2,000,000), the prospect is at the widely cited sustainable withdrawal threshold — the analysis should show the sensitivity of success probability to different return scenarios.
  • The current 401(k) holdings include company stock, which may have Net Unrealized Appreciation (NUA) tax benefits. The proposal should address whether the NUA strategy is advantageous: if the cost basis of the company stock is low, distributing the shares in-kind to a taxable account (not rolling them to the IRA) allows the NUA to be taxed at long-term capital gains rates rather than ordinary income rates upon distribution from the IRA. This requires careful tax analysis and should be presented as a consideration, not as tax advice.
  • Fee illustration: show the firm's tiered fee schedule applied to $2M, the weighted average expense ratio of the recommended funds, and the total cost. Compare this to the prospect's current 401(k) plan expenses (typically 0.50-1.50% all-in for employer plans, depending on plan size and investment options).

Analysis: The proposal document should include: (1) Executive summary framing the recommendation as a retirement transition strategy, not just a portfolio change. (2) Client profile recap emphasizing the 5-year accumulation phase followed by a 30+ year distribution phase. (3) Current portfolio analysis showing the 401(k) allocation — likely over-concentrated in company stock and potentially misallocated in the target-date fund (which may be targeting a different retirement date or risk level than appropriate). Quantify the single-stock concentration risk. (4) Recommended portfolio: Moderate Conservative model with 35% equity, 55% investment-grade fixed income, and 10% alternatives/real assets for inflation protection. Include a holdings detail table with specific funds, expense ratios, and target weights. (5) Retirement income projection using Monte Carlo showing 85-90% probability of sustaining $80,000/year (inflation-adjusted) through age 95 — if the probability is lower, discuss options (delaying retirement, reducing spending, part-time work). (6) Fee illustration showing the blended advisory fee of 0.8375% on $2M ($16,750/year) plus fund expenses of approximately 0.12% ($2,400/year) for a total of $19,150/year, compared to the estimated 401(k) plan cost. (7) NUA analysis as a supplementary section, clearly labeled as requiring tax professional review. (8) Transition plan: direct rollover of all non-company-stock assets; separate analysis for company stock disposition. (9) All required disclaimers regarding projections, past performance, and tax information.

Example 2: Creating a proposal that compares current broker-dealer portfolio vs proposed advisory portfolio

Scenario: A prospect with $1.5M at a full-service broker-dealer is unhappy with performance and fees. The current portfolio consists of 18 individual stocks, 6 actively managed mutual funds (A-shares with front loads previously paid), and a fixed annuity. The prospect is 52 years old, risk score 65 (Moderate Growth), retired military with a pension covering basic expenses, and views the investment portfolio as growth capital with a 20+ year horizon. The advisor wants to demonstrate the advantages of the proposed advisory model vs the current BD portfolio.

Design Considerations:

  • The current portfolio analysis is the most important section of this proposal. The prospect is motivated by dissatisfaction, so the analysis must honestly and accurately quantify the issues with the current portfolio while complying with rules against misleading comparisons.
  • Current portfolio issues to analyze: (a) 18 individual stocks likely create concentration risk — measure diversification vs the recommended model; (b) actively managed A-share mutual funds have higher expense ratios (often 0.75-1.25%) than the ETFs or institutional share class funds in the proposed model (often 0.05-0.25%); (c) the prospect may be paying ongoing 12b-1 fees (0.25%) within the A-shares; (d) the fixed annuity may have surrender charges if liquidated before the surrender period expires — this is a critical transition cost to disclose; (e) calculate the total current cost: any ongoing BD advisory or account fees + fund expense ratios + 12b-1 fees.
  • The comparison must be fair and not misleading. Do not compare the BD portfolio's worst year to the advisory portfolio's best year. Compare on risk-adjusted metrics (Sharpe ratio, Sortino ratio) over the same time periods. If comparing performance, ensure the comparison uses consistent time periods and accounts for survivorship bias in the current holdings.
  • The fixed annuity requires careful handling: if it has a remaining surrender period, disclose the surrender charge and analyze whether the benefit of transition outweighs the surrender cost. If the annuity has favorable guaranteed rates, it may be appropriate to retain it.
  • Transition tax analysis: the 18 individual stocks and mutual funds in a taxable account have embedded gains and losses. The proposal must include a tax lot analysis showing the estimated tax cost of liquidation. A phased transition may be more tax-efficient than an immediate full liquidation.

Analysis: The proposal should present a structured comparison: (1) Side-by-side asset allocation: current portfolio (likely equity-heavy given 18 stocks plus equity funds, possibly 85-90% equity) vs recommended Moderate Growth model (65/35). The current portfolio may actually carry more risk than the prospect's score supports — this is a powerful finding. (2) Cost comparison: Current all-in cost (estimate BD advisory fee at 1.0-1.5% + fund expenses at 0.90% average + 12b-1 fees at 0.25% on applicable funds) vs proposed (advisory fee of approximately 0.90% blended on $1.5M + fund expenses at 0.12%) — expected annual savings of $8,000-15,000 depending on current BD fee structure. Present this as a 10-year and 20-year cumulative savings. (3) Risk comparison: current portfolio standard deviation and max drawdown estimate vs recommended model. If the current portfolio is carrying 85-90% equity risk, the max drawdown in a 2008-type event would have been approximately -45 to -50%, vs -32% for the recommended model. (4) Diversification comparison: current 18-stock portfolio may have 40-50% in 3-4 sectors vs broad market diversification in the recommended model. (5) Transition plan: retain the fixed annuity if surrender charges apply, harvest tax losses in current holdings to offset gains, transition individual stocks with large embedded gains over 12-18 months, immediately transition mutual fund positions (A-share loads are sunk costs and should not factor into the decision to stay or leave). (6) Disclaimers: the comparison uses historical data and assumptions; actual future performance of either portfolio cannot be predicted; the comparison does not account for all factors that may affect performance; the prospect should consider the tax implications with a qualified professional.

Example 3: Building a proposal template system for a multi-advisor firm with standardized models

Scenario: A growing RIA with 25 advisors and $4B AUM is transitioning from an ad-hoc proposal process (each advisor creates their own proposals using PowerPoint and Excel) to a standardized, automated proposal generation system. The firm has 7 model portfolios, a uniform fee schedule, and uses Schwab as its custodian, Orion for portfolio management, and Salesforce for CRM. The chief compliance officer wants every proposal to pass through a compliance workflow before delivery.

Design Considerations:

  • The primary challenge is balancing standardization (for compliance, efficiency, and brand consistency) with advisor flexibility (each advisor has their own style, client base, and value proposition). The system should lock compliance-critical elements (disclaimers, performance presentation, fee disclosure) while allowing advisors to customize narrative sections (personal letter, firm value proposition, service description).
  • Template architecture should include: (a) a master template with locked compliance sections, (b) modular components that advisors can include or exclude (current portfolio analysis module, retirement income module, tax transition module, estate planning integration module), (c) advisor-specific elements (advisor bio, contact information, personal branding within firm guidelines), and (d) model-specific content (each of the 7 models has a pre-written description, historical context, and risk-return profile).
  • Data integration requirements: Salesforce provides prospect data (name, contact, financial information collected during discovery); the risk profiling tool provides the risk score and model mapping; Orion provides model portfolio details (holdings, allocation, historical performance); Schwab provides account data for current portfolio analysis (via account aggregation or statement import); the proposal system assembles all data into the selected template.
  • Compliance workflow: after the advisor generates a proposal, it enters a compliance review queue. The compliance reviewer checks suitability alignment, performance data accuracy, fee calculation correctness, and disclaimer completeness. The system should flag proposals that deviate from standard model mappings or contain customized language that has not been pre-approved. Approved proposals are released for delivery; rejected proposals return to the advisor with specific correction requirements.
  • Version control: when model portfolios are updated (quarterly rebalance, fund substitution), all templates must be refreshed. Proposals generated before the update should be flagged if they are still pending delivery, as they contain stale data. The system should prevent delivery of proposals with outdated model information.

Analysis: The recommended implementation plan: (1) Phase 1 — Template design (weeks 1-4): Work with the compliance team to define the locked compliance sections: disclaimers, performance presentation format, fee disclosure format, and required disclosures. Create the 7 model-specific content blocks with CCO approval. Design the modular components. Build the master template in the proposal platform with content controls that prevent unauthorized editing of locked sections. (2) Phase 2 — Integration (weeks 3-8): Connect Salesforce (prospect data), the risk profiling tool (risk score and model mapping), and Orion (model details and current portfolio data) to the proposal platform via API. Implement the compliance review workflow with status tracking, reviewer assignment, and approval/rejection routing. (3) Phase 3 — Pilot (weeks 8-10): Deploy to 3-5 advisors for testing. Gather feedback on usability, template quality, data accuracy, and compliance workflow efficiency. Identify edge cases that the templates do not handle well (complex trusts, institutional prospects, prospects with annuities). (4) Phase 4 — Rollout (weeks 10-14): Train all 25 advisors. Provide proposal generation guides and best practices. Establish metrics: proposals generated per advisor per month, compliance review turnaround time, revision rate (percentage of proposals requiring revisions), and time from proposal generation to client acceptance. (5) Ongoing governance: Quarterly template review aligned with model portfolio rebalancing. Annual compliance review of all template content. Advisor feedback loop for template improvements. Dashboard monitoring proposal pipeline, compliance review backlog, and conversion rates. The expected outcome is a reduction in proposal generation time from 3-5 hours (ad-hoc PowerPoint/Excel) to 30-60 minutes (templated, data-integrated), a near-elimination of compliance errors in delivered proposals, and consistent brand and message quality across all 25 advisors.

Source: SKILL.md on GitHub

1 warning16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    The skill provides comprehensive instructions for generating investment proposals and managing financial prospect data. It identifies a potential indirect prompt injection surface because the agent is instructed to process untrusted external data such as account statements and CSV files, which could contain malicious instructions. The skill also references several well-known financial services and platforms in a professional and safe context.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer6mo

    1/1 file flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at cf3e6ba. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 months ago.

Steadyupdated 3 months ago

README badge

README badge for joellewis/finance_skills/proposal-generation