Study guide
1.3 Data Gathering, Net Worth Analysis, and Retirement Cash Flow Modeling
CRPC Chartered Retirement Planning Counselor Study Guide 2026 Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Exam Overview & The Retirement Planning Process
1.1 CRPC Designation Overview, Exam Logistics, and Continuing Education 1.2 The Comprehensive Retirement Planning Framework & Client Engagement 1.3 Data Gathering, Net Worth Analysis, and Retirement Cash Flow Modeling 1.4 Capital Needs: Preservation and Depletion
2 Chapter 2: Investment Principles & Portfolio Strategies for Retirement
2.1 Risk Tolerance, Capacity, and Asset Allocation Across Life Stages 2.2 Portfolio Risk, Diversification, and Allocation Methods 2.3 Investment Vehicles for Retirement Portfolios 2.4 Sequence of Returns Risk, Volatility Drag, and Longevity Risk 2.5 Portfolio Rebalancing, Glide Paths, and Asset Location 2.6 Investment Policy, Constraints, and Implementation 2.7 Stock Strategies and Risk-Adjusted Performance
3 Chapter 3: Social Security, Military & Government Retirement Benefits
3.1 Social Security Eligibility, AIME, and PIA Calculations 3.2 Social Security Claiming Strategies, Spousal, and Survivor Benefits 3.3 Windfall Elimination Provision (WEP) and Government Pension Offset (GPO) 3.4 Military and Federal Civil Service Retirement Systems 3.5 Federal Civil Service Pensions and TSP 3.6 Benefit Records, Family Limits, and Claim Corrections
4 Chapter 4: Bridging the Income Gap: Pensions & Employer-Sponsored Plans
4.1 Defined Benefit Plans and Payout Decisions 4.2 Pension Maximization and Survivor Trade-Offs 4.3 Defined Contribution Plans: 401(k), 403(b), 457(b), and TSP 4.4 Plan Loans and Early-Retirement Distribution Exceptions 4.5 Executive Compensation and Deferred Compensation Plans 4.6 Equity Compensation and Retirement Concentration 4.7 Housing Wealth, Reverse Mortgages, and Phased Retirement 4.8 Traditional and Roth IRA Contribution Rules 4.9 Life Insurance, Cash Values, and Settlement Choices
5 Chapter 5: Healthcare, Medicare & Long-Term Care in Retirement
5.1 Medicare Architecture and Covered Services 5.2 Medicare Enrollment Periods, Late Penalties, and IRMAA Surcharges 5.3 Medigap Supplemental Insurance vs. Medicare Advantage (Part C) 5.4 Long-Term Care Planning, Insurance Models, and Health Savings Accounts 5.5 HSA Retirement Healthcare Funding 5.6 Health Insurance and ACA Planning Before Medicare 5.7 Medicaid Long-Term Services, Transfers, and Estate Recovery
6 Chapter 6: Emotional, Behavioral & Lifestyle Transition to Retirement
6.1 Psychological Transition, Identity Shifting, and Non-Financial Life Design 6.2 Behavioral Finance Traps and Cognitive Biases in Decumulation 6.3 Intergenerational Family Dynamics, Caregiving, and Relocation Considerations 6.4 Early Retirement Offers, Severance, and Delayed Retirement
7 Chapter 7: Retirement Distribution & Income Stream Design
7.1 Systematic Withdrawal Strategies and Dynamic Guardrails 7.2 Time-Segmented "Bucket" Allocation Strategies 7.3 Commercial Annuities and Guaranteed Income Streams 7.4 Liability-Driven Investing and Essential vs. Discretionary Spending Floors 7.5 Plan Access, Rollovers, Withholding, and Employer Stock
8 Chapter 8: Tax Planning, RMDs & Distribution Sequencing
8.1 Tax-Efficient Distribution Sequencing Across Account Types 8.2 Required Minimum Distribution (RMD) Rules Under SECURE 2.0 8.3 Roth Conversions and Tax Bracket Arbitrage 8.4 Qualified Charitable Distributions (QCDs) and Charitable Tax Strategies
9 Chapter 9: Estate Planning & Wealth Transfer in Retirement
9.1 Essential Estate Documents and Incapacity Planning 9.2 Financial Powers, Digital Assets, and Guardianship 9.3 Property Titling, Beneficiary Designations, and Probate Avoidance 9.4 Trusts in Retirement Planning: Revocable Living vs. Irrevocable Trusts 9.5 Federal Gift, Estate, and GST Taxes and Basis Rules
10 Chapter 10: Fiduciary Duty, Regulatory Standards & Professional Ethics
10.1 Fiduciary Standards, Broker Suitability, and SEC Regulation Best Interest (Reg BI) 10.2 SEC Form CRS, Relationship Summaries, and Conflict Management 10.3 College for Financial Planning / Kaplan Code of Ethics and Professional Standards 10.4 Protecting Vulnerable Adults: Diminished Capacity, Financial Exploitation, and FINRA Rules 10.5 ERISA Fiduciary Status and Current DOL Rules
1.3 Data Gathering, Net Worth Analysis, and Retirement Cash Flow Modeling
Key Takeaways Explain This Topic AI
Net worth is current assets less liabilities; it is not the same as investable capital.
Cash-flow discovery separates essential, discretionary, tax, and healthcare expenses.
Expense budgeting tests the individual household rather than assuming a replacement ratio is universally adequate.
Last updated: October 2026
Data Gathering, Net Worth Analysis, and Retirement Cash Flow Modeling
Building an enduring retirement strategy requires precise financial measurement. Before an advisor can model distribution longevity or evaluate investment risks, they must construct an accurate balance sheet, analyze historical and prospective cash flows, and rigorously quantify post-retirement spending needs. This section explores quantitative data gathering, financial statement modeling, expenditure classification, and the mathematical mechanics of Capital Needs Analysis.
Quantitative Data Collection & Documentation
Sound retirement planning begins with an exhaustive quantitative audit. Relying on client estimates or memory often introduces severe discrepancies. Advisors must assemble and inspect primary source documentation across seven critical areas:
Tax Returns: Federal and state Forms 1040 (including Schedules A, B, C, D, and E) for the preceding 2 to 3 years, revealing effective tax brackets, ordinary income, capital gains, carryforward losses, and deductions.
Social Security Statements: Current Social Security Administration statements (Form SSA-7004) detailing earnings records and estimated Primary Insurance Amounts (PIA) at age 62, Full Retirement Age (FRA), and age 70.
Qualified Plan & IRA Statements: Balances, contribution histories, employer vesting schedules, and pre-tax versus Roth designated balances across 401(k), 403(b), 457(b), Traditional IRA, and Roth IRA accounts.
Non-Qualified & Brokerage Statements: Taxable accounts, cost basis records, unrealized capital gains, individual stock concentration risks, and executive deferred compensation plans.
Pension Documents: Summary Plan Descriptions (SPDs) and individualized benefit estimates detailing defined benefit pension formulas, cost-of-living adjustments (COLAs), and joint and survivor payout elections.
Debt Instruments: Mortgages, home equity lines of credit (HELOCs), promissory notes, vehicle loans, and credit cards, documenting outstanding balances, interest rates, and payoff amortization schedules.
Insurance Declarations: Policy contracts for term life, permanent cash-value life, disability, long-term care (LTC), property and casualty, and commercial liability umbrella policies.
Statement of Financial Condition (Personal Balance Sheet)
The Statement of Financial Condition is a snapshot of the client's financial position at a single, specific date. Assets are recorded at their current Fair Market Value (FMV) —the price a willing buyer would pay a willing seller in an arm's-length transaction—rather than historical purchase cost.
Assets are classified into three distinct categories based on their function and liquidity:
Liquid Assets (Cash & Cash Equivalents): Cash, checking accounts, money market deposit accounts, short-term certificates of deposit (CDs), and Treasury bills. These assets provide immediate purchasing power, serve as the emergency fund (typically 3 to 6 months of living expenses during working years, expanding to 1 to 2 years of cash reserves during retirement), and fund near-term distribution needs.
Investment & Retirement Assets: Taxable brokerage accounts, mutual funds, individual stocks, municipal bonds, qualified retirement accounts (401(k), traditional and Roth IRAs), real estate investment properties, and annuities. These assets are committed to generating long-term capital appreciation, dividends, and interest to support post-retirement spending.
Personal-Use Assets: Primary residence, second vacation homes, personal vehicles, boats, furniture, art, jewelry, and collectibles. While personal-use assets contribute to total net worth, they are generally illiquid and do not produce spendable income; in fact, they frequently generate ongoing carrying costs such as property taxes, insurance, and maintenance.
Liabilities are segregated by maturity horizon:
Short-Term Liabilities: Debts due within one year, including credit card balances, revolving consumer debt, outstanding medical bills, and estimated unpaid income taxes.
Long-Term Liabilities: Obligations extending beyond one year, including residential mortgages, home equity loans, student loans, and auto loans.
The fundamental accounting equation determines the client's Net Worth : Net Worth = Total Assets − Total Liabilities \text{Net Worth} = \text{Total Assets} - \text{Total Liabilities} Net Worth = Total Assets − Total Liabilities
Key diagnostic ratios evaluated on the balance sheet include the Solvency Ratio , which measures the percentage cushion against financial insolvency: Solvency Ratio = Net Worth Total Assets \text{Solvency Ratio} = \frac{\text{Net Worth}}{\text{Total Assets}} Solvency Ratio = Total Assets Net Worth
and the Liquidity Ratio , which indicates how many months of non-negotiable living costs are covered by cash reserves: Liquidity Ratio = Liquid Assets Monthly Essential Outflows \text{Liquidity Ratio} = \frac{\text{Liquid Assets}}{\text{Monthly Essential Outflows}} Liquidity Ratio = Monthly Essential Outflows Liquid Assets
Statement of Cash Flows & Expenditure Categorization
While the balance sheet reflects a snapshot in time, the Statement of Cash Flows captures financial activity across a specified accounting window (typically 12 months). It tracks gross cash inflows (salaries, business distributions, bonuses, interest, dividends) against all cash outflows, revealing the client's net discretionary cash flow.
When preparing for retirement, expenditures must be divided into functional categories:
Essential (Fixed) Expenses: Non-discretionary baseline survival expenditures that must be paid regardless of economic conditions, including housing (mortgage/rent, property taxes, homeowner's insurance), basic utilities, baseline food and groceries, auto insurance, and baseline health insurance premiums.
Discretionary (Variable) Expenses: Flexible lifestyle expenditures that can be reduced or eliminated during market downturns, including vacation travel, club memberships, luxury dining, entertainment, hobby equipment, and charitable gifting.
Taxes: Federal, state, and local income taxes, which vary significantly based on distribution sequencing and income bracket management.
Healthcare Costs: Medicare Part B, Part D, and Supplemental (Medigap) premiums, Medicare Advantage copayments, out-of-pocket dental, hearing, vision care, and prescription drug costs.
Post-Retirement Cash Flow Shifts
A critical role of the counselor is modeling how pre-retirement expenses transform upon entering retirement:
Expense Category Directional Shift Underlying Financial & Operational Drivers
FICA Payroll Taxes Eliminated The 7.65% to 8.55% FICA tax (6.2% Social Security + 1.45% Medicare + 0.9% additional Medicare) applies only to earned wages; it ceases completely on investment and retirement distributions
Retirement Savings Contributions Eliminated Active contributions of 10% to 20% of gross pay to 401(k), 403(b), or IRA accounts stop immediately upon retirement
Work-Related Commuting & Attire Substantially Reduced Fuel, tolls, parking, mass transit fares, business suits, professional dry cleaning, and weekday restaurant lunches decline dramatically
Residential Mortgage Debt Reduced or Eliminated Many retirees intentionally pay off their 30-year mortgages prior to retirement, eliminating their single largest monthly cash outflow
Healthcare & Medicare Costs Substantially Increased Loss of employer healthcare subsidies often increases out-of-pocket costs; Medicare Part B/D premiums and supplemental Medigap policies create predictable, escalating expenses
Travel & Recreational Leisure Substantially Increased Newly retired individuals in good physical health spend significantly more on travel, recreational sports, hobbies, and family visits during early retirement
Domestic Home Utility Costs Moderately Increased Spending more daytime hours at home increases electricity, heating, air conditioning, and domestic utility usage
Estimating Retirement Living Costs: Replacement Ratio vs. Expense Budgeting
Advisors employ two distinct methodologies to project post-retirement income requirements:
The Income Replacement Ratio Method (Top-Down Approach)
The income replacement ratio method estimates that a retiree requires 70% to 80% of their pre-retirement gross annual income to sustain their standard of living. For instance, a household earning $150,000 gross prior to retirement would target $105,000 to $120,000 in gross annual retirement cash flow ($150,000 × 0.70 = $105,000; $150,000 × 0.80 = $120,000).
Strengths: Simple, quick rule of thumb ideal for early-to-mid career accumulation planning when retirement is decades away.
Limitations: Can produce severe distortions. High-earning households earning $400,000 annually who aggressively save 40% of their income and have paid off their mortgage may need an income replacement ratio of only 40% to 50%. Conversely, lower-income households who spend 95% of their earnings on basic necessities may require an 85% to 95% replacement ratio.
The Expense Budgeting Method (Bottom-Up Approach)
The expense budgeting method constructs an itemized, line-by-line projection of actual anticipated expenditures across the retirement lifecycle. Rather than assuming a flat percentage, it accounts for the three distinct phases of retirement:
The "Go-Go" Years (Ages 62–74): High physical energy and enthusiasm. Discretionary spending on travel, hospitality, second homes, and active hobbies often pushes total expenditures to 100% or more of pre-retirement levels.
The "Slow-Go" Years (Ages 75–84): Natural physical slowing and reduced travel. Discretionary recreation outlays decline, domestic living costs stabilize, and total expenditures often fall to 60% to 75% of pre-retirement levels.
The "No-Go" Years (Ages 85+): Minimal travel and lifestyle expenditures, but sharp increases in prescription drugs, in-home assisted care, memory support, and medical copays.
Method Core Approach Primary Advantage Major Limitation Best Practical Application
Replacement Ratio Top-down percentage of gross pay (70%–80%) Fast calculation; requires minimal client paperwork Ignores individual lifestyle variances, savings rates, and debt status Long-range preliminary accumulation planning (10+ years out)
Expense Budgeting Bottom-up line-item audit across retirement phases Highly accurate; mirrors actual spending patterns and phases Time-consuming; requires exhaustive record-keeping and client tracking Transition planning for pre-retirees within 1–5 years of retirement