financial-planning-integration

What this skill does

# Financial Planning Integration

## Purpose
Guide the design, implementation, and ongoing operation of financial planning workflows within the advisor technology stack. This skill covers planning tool data flows, goal-based planning frameworks, cash flow modeling, Monte Carlo simulation, plan-to-portfolio linkage, scenario analysis, tax planning integration, Social Security optimization, system integration patterns, and client-facing plan presentation. The focus is on how the financial plan connects to and drives the rest of the advisory practice — from client data gathering through portfolio construction and ongoing monitoring.

## Layer
10 — Advisory Practice (Front Office)

## Direction
prospective

## When to Use
- Designing or evaluating the integration between a financial planning engine and other advisor technology systems (CRM, PMS, custodian, aggregation)
- Building goal-based financial plans that define client objectives and map them to portfolio strategy
- Running Monte Carlo simulations to assess plan probability of success and communicating results to clients
- Linking financial plan outputs (required return, risk capacity, withdrawal schedule) to portfolio construction and the investment policy statement
- Modeling what-if scenarios for client engagement: early retirement, market downturns, Social Security claiming strategies, Roth conversions, spending changes
- Projecting multi-year tax impacts across Roth conversion laddering, RMD management, and withdrawal sequencing
- Evaluating Social Security claiming strategies and their interaction with the broader retirement income plan
- Mapping data flows into and out of the financial planning tool to eliminate manual re-entry and ensure assumption consistency
- Presenting financial plan outputs to clients in a clear, actionable format
- Establishing plan review cadence and event-driven update triggers

## Core Concepts

### Financial Planning System Architecture
The financial planning engine is the analytical hub of the advisor technology stack. It ingests client data from multiple systems, models the client's financial future across a range of scenarios, and produces outputs that drive portfolio construction, cash management, and ongoing advisory recommendations.

**Core functions of the planning engine:**
- Goal definition and prioritization
- Cash flow modeling (income, expenses, savings, withdrawals across the full life cycle)
- Monte Carlo simulation of investment return paths
- Scenario analysis (what-if modeling)
- Tax projection (marginal brackets, capital gains, RMDs, Roth conversions)
- Estate planning (wealth transfer, trust modeling, estate tax projections)
- Insurance needs analysis (life, disability, long-term care)
- Social Security optimization (claiming strategy comparison)

**Relationship to other systems in the advisor technology stack:**
- **CRM (client relationship management):** Source of client demographic data, household composition, employment status, life events, and planning review triggers. The CRM is the system of record for client facts; the planning tool consumes these facts as inputs.
- **PMS (portfolio management system):** Source of current portfolio holdings, asset allocation, and account types. The plan produces a required return target and risk capacity that feed back to the PMS as constraints for portfolio construction.
- **Custodian:** Source of account balances, positions, and transaction history. Custodial data feeds ensure the plan reflects actual account values rather than stale estimates.
- **Aggregation platform:** Source of held-away assets — accounts at other custodians, employer retirement plans, bank accounts, real estate equity estimates, stock options. Aggregation fills the gap between what the advisor custodies and what the client actually owns, which is essential for a complete financial picture.

**Common financial planning platforms:** eMoney Advisor, MoneyGuidePro (Envestnet), RightCapital, Naviplan (InvestCloud), and financial planning modules embedded within all-in-one platforms (e.g., Orion Planning, Advyzon). Platform selection depends on firm size, integration requirements, planning complexity, and client-facing presentation needs. Some platforms emphasize interactive client portals (eMoney, RightCapital); others emphasize advisor-facing analytical depth (MoneyGuidePro, Naviplan).

### Goal-Based Planning Framework
The financial plan is organized around client goals. Each goal is a discrete financial objective with defined attributes, and the plan's purpose is to determine whether the client's resources — current assets, future savings, income sources — are sufficient to fund all goals with an acceptable probability of success.

**Common goal types:**
- Retirement income (the dominant goal for most clients)
- Education funding (529 plans, direct payments, student loans)
- Home purchase or mortgage payoff
- Legacy and estate transfer
- Charitable giving (lifetime giving, donor-advised funds, bequests)
- Major purchases (second home, vehicle, travel)
- Debt payoff (student loans, credit card, business loans)
- Business succession or liquidity event planning

**Goal attributes:**
- **Target amount:** The dollar amount needed, expressed in today's dollars or future dollars
- **Target date:** When the funds are needed (single date or range of dates for ongoing goals like retirement income)
- **Priority:** Essential (must be funded), important (should be funded if possible), or aspirational (funded only if surplus allows)
- **Funding source:** Which accounts and income streams fund this goal (e.g., retirement income funded from 401(k), IRA, and Social Security; education funded from 529 and taxable accounts)
- **Inflation adjustment:** The inflation rate applied to the goal amount (general CPI, education inflation, healthcare inflation)

**Multi-goal optimization:** When total goals exceed projected resources, the plan must prioritize. Essential goals are funded first, then important, then aspirational. Within each priority tier, the advisor and client determine the order. The financial planning engine typically handles this by running the Monte Carlo simulation with all goals included and reporting the probability of funding each goal independently. If the overall plan probability of success is too low, the advisor works with the client to reduce, defer, or eliminate lower-priority goals until the probability reaches an acceptable level.

**Goal progress tracking:** Each goal is assigned a status based on the current probability of success:
- **On track:** Probability of success at or above the target threshold (commonly 80-90%)
- **Needs attention:** Probability between 60-80%, where modest adjustments (increased savings, extended timeline) could restore the goal to on-track status
- **At risk:** Probability between 40-60%, requiring significant changes to the plan
- **Unlikely:** Probability below 40%, where the goal may need to be fundamentally restructured or deprioritized

These status indicators are updated dynamically as market performance, contributions, and withdrawals change the plan's projected outcomes.

### Cash Flow Modeling
Cash flow modeling projects the client's income, expenses, savings, and withdrawals across the entire planning horizon — typically from the current age through life expectancy (often modeled to age 90-95 or beyond).

**Income sources:**
- Salary and bonus (modeled with annual growth rates during working years)
- Social Security benefits (modeled based on claiming age and earnings history)
- Pension income (defined benefit plans, annuities)
- Rental income from real estate
- Part-time or consulting income during transition to retirement
- Required Minimum Distributions (mandatory, not discretionary income)

**Expense categories:**
- Essential expenses (housing, food, utilities, insurance, transportation)
- Discretionary expenses (travel, dining, entertainment, hobbies)
- Healthcare expenses (premiu