Preview full query
Paste the following query into ChatGPT after connecting the brokerage, retirement, banking, credit, and loan accounts you want included in the analysis.
Perform a comprehensive review of my investment portfolio using my linked brokerage account together with my other connected financial accounts.
Act as a retirement portfolio analyst with expertise in:
- Retirement portfolio construction
- Asset allocation and diversification
- ETFs, mutual funds, individual stocks, bonds, and cash equivalents
- Retirement-income planning
- Sequence-of-returns risk
- Inflation and longevity risk
- Portfolio withdrawal strategies
- Traditional and Roth IRAs
- Taxable brokerage accounts
- 401(k), 403(b), and other employer retirement plans
- Social Security coordination
- Cash-flow analysis
- Debt and liquidity management
- Asset location and tax efficiency
- Required minimum distributions
- Roth conversion planning
- Investment expenses and fund overlap
Your objective is to evaluate my investments in the context of my entire financial position, not simply determine whether individual securities are attractive investments.
Step 1 — Verify the Data Available
Before performing the analysis, identify all connected financial accounts that are relevant to the review.
Separate them into:
- Taxable brokerage accounts
- Traditional IRAs
- Roth IRAs
- Employer retirement accounts
- Checking accounts
- Savings and money-market accounts
- CDs or other cash equivalents
- Credit cards
- Mortgages
- Auto loans
- Personal or other loans
- Other significant connected financial accounts
For each relevant account, identify whether the available information appears current and sufficiently complete for the analysis.
Specifically check whether:
- Holdings are available
- Account balances are available
- Investment transactions are available
- Cost basis is available
- Cash positions are identifiable
- Transaction history is complete enough for the requested analysis
- Any connected account appears stale, partially synchronized, or incomplete
Do not assume that missing data means an account has a zero balance or no activity.
Clearly identify any data limitations before proceeding.
Step 2 — Establish My Retirement Context
Use information already available from my connected financial accounts and our conversation.
Do not ask me to repeat information you already have.
Ask me only for material information that is still missing.
At minimum, establish:
- My age
- Whether I am retired or my expected retirement date
- Social Security income
- Pension or annuity income
- Employment or self-employment income
- Approximate annual household spending
- Estimated core or essential annual spending
- Estimated discretionary annual spending
- Expected annual portfolio withdrawals
- Expected major expenses during the next 1, 3, 5, and 10 years
- Cash reserves outside the investment portfolio
- Significant debts and their interest rates
- Investment time horizon
- Risk tolerance
- Risk capacity
- Estate or inheritance objectives
- Any investments or asset classes I specifically want included or excluded
Treat risk tolerance and risk capacity as separate considerations.
Step 3 — Create a Household Financial Snapshot
Using all relevant connected accounts, create a high-level balance sheet showing:
- Cash and cash equivalents
- Taxable investments
- Traditional retirement assets
- Roth retirement assets
- Other investment assets
- Total financial assets
- Credit-card debt
- Mortgages
- Auto loans
- Other significant debt
- Approximate net financial position
Do not count the same asset twice if it appears in multiple datasets.
Clearly distinguish investment assets from emergency cash and operating cash.
Step 4 — Review the Investment Portfolio
Analyze all available investment holdings across the connected brokerage and retirement accounts.
Create a consolidated holdings table showing, where available:
- Account
- Security name
- Ticker symbol
- Security type
- Quantity
- Current value
- Percentage of total investment portfolio
- Cost basis
- Unrealized gain or loss
Reconcile the holdings with the total reported investment-account balances.
Identify material differences or unexplained amounts.
Step 5 — Calculate Asset Allocation
Determine the portfolio's current allocation by both percentage and dollar amount.
At minimum, classify assets into:
- U.S. large-cap stocks
- U.S. mid-cap stocks
- U.S. small-cap stocks
- International developed-market stocks
- Emerging-market stocks
- Investment-grade bonds
- U.S. Treasury securities
- Municipal bonds
- High-yield bonds
- Short-term fixed income
- Cash and cash equivalents
- Real estate securities
- Commodities
- Cryptocurrency
- Other material asset classes
Also provide a simplified summary showing:
- Total equities
- Total fixed income
- Total cash
- Other assets
Do not classify an investment based solely on its ticker or name when its underlying exposure is uncertain. Research or clearly flag uncertain classifications.
Step 6 — Analyze Diversification and Concentration
Evaluate the portfolio for concentration risk.
Review:
- Largest individual holdings
- Percentage represented by the top 5 and top 10 holdings
- Sector concentration
- Industry concentration
- Geographic concentration
- U.S. versus international exposure
- Large-cap versus mid- and small-cap exposure
- Growth versus value exposure
- Bond duration
- Bond credit quality
- Cash concentration
- Cryptocurrency concentration
- Other material concentrations
Identify situations where apparent diversification is misleading.
For example, several ETFs should not be considered independently diversified if they own many of the same underlying companies.
Step 7 — Analyze Fund and ETF Overlap
For ETFs and mutual funds, examine their investment objectives and major underlying holdings.
Identify:
- Funds with substantial overlap
- Funds performing essentially the same portfolio function
- Unnecessary complexity
- Cases where multiple funds could potentially be simplified
- Cases where apparently similar funds actually provide useful diversification
Do not recommend simplification merely to reduce the number of holdings.
Explain whether overlapping funds create a meaningful portfolio problem.
Step 8 — Analyze Investment Costs
For each ETF or mutual fund:
- Identify its current expense ratio
- Estimate the annual expense represented by my current holding
- Estimate total annual fund expenses across the portfolio
Identify:
- High-cost holdings
- Management or advisory fees visible in my account activity
- Fund fees
- Other recurring investment-related costs
When a substantially similar lower-cost investment exists, identify it for comparison.
Do not recommend replacing an investment solely because another fund has a lower expense ratio. Consider differences in exposure, liquidity, tax consequences, bid-ask spreads, and portfolio purpose.
Step 9 — Evaluate Cash and Liquidity
Review cash across:
- Checking
- Savings
- Money-market accounts
- Brokerage cash
- Retirement-account cash
- Other cash equivalents
Separate:
1. Operating cash
2. Emergency reserves
3. Near-term retirement spending reserves
4. Cash awaiting investment
5. Cash intentionally held as part of the investment allocation
Evaluate whether total liquidity appears appropriate given my spending, income, and anticipated withdrawals.
Identify both:
- Excessive idle cash
- Insufficient near-term liquidity
Do not recommend investing money needed for reasonably foreseeable short-term expenses.
Step 10 — Integrate Cash Flow and Portfolio Withdrawals
Compare dependable income with household spending.
Use, when available:
- Social Security
- Pension income
- Employment or self-employment income
- Interest
- Dividends
- Other recurring income
Estimate:
Annual spending minus dependable income = approximate amount that must be supplied by investments.
Show:
- Estimated annual portfolio withdrawal requirement
- Withdrawal as a percentage of investable assets
- Portion of withdrawals required for essential spending
- Portion associated with discretionary spending
Identify whether discretionary spending provides flexibility during poor market conditions.
Step 11 — Evaluate Sequence-of-Returns Risk
Evaluate the risk of needing to sell investments during an extended market decline.
Consider:
- Current stock allocation
- Bond allocation
- Available cash
- Near-term spending requirements
- Dependable retirement income
- Expected withdrawal rate
Estimate how many months or years of anticipated portfolio withdrawals could potentially be covered without selling long-term equity investments.
Discuss whether a cash or short-term fixed-income reserve would materially improve retirement resilience.
Step 12 — Stress Test the Portfolio
Illustrate several hypothetical scenarios.
At minimum analyze:
Scenario A — Significant stock decline
Assume a substantial equity-market decline while bonds remain relatively stable.
Scenario B — Stocks and bonds decline together
Model an environment similar to periods when rising interest rates hurt both stocks and bonds.
Scenario C — Poor returns early in retirement
Illustrate several years of weak or negative returns combined with normal portfolio withdrawals.
Scenario D — Higher inflation
Consider how prolonged elevated inflation could affect purchasing power and withdrawal requirements.
Scenario E — Strong markets
Illustrate how the portfolio could evolve if investment returns are stronger than expected.
These scenarios are illustrations, not forecasts.
Show approximate portfolio impacts and explain the primary risks exposed by each scenario.
Step 13 — Review Income Produced by Investments
Analyze available dividend and interest activity.
Show, when the data allows:
- Dividend income
- Interest income
- Fund distributions
- Estimated annual portfolio income
- Approximate portfolio yield
Separate investment income from sales of securities.
Explain how much of my expected retirement cash requirement could be supported by portfolio income versus sales of assets.
Do not imply that maximizing dividend yield is necessarily preferable to a total-return strategy.
Step 14 — Review Recent Investment Activity
Review available investment transactions for meaningful patterns.
Summarize:
- Purchases
- Sales
- Contributions
- Withdrawals
- Transfers
- Dividends
- Interest
- Fees
- Reinvestment activity
Identify patterns that could undermine the investment strategy, such as:
- Excessive trading
- Repeated market timing
- Accumulating uninvested cash
- Unplanned concentration
- High fees
- Frequent strategy changes
Distinguish intentional portfolio changes from normal account activity.
Step 15 — Analyze Debt Alongside Investments
Review significant connected liabilities.
For each material debt, show:
- Approximate balance
- Interest rate or APR when available
- Required payment
- Type of debt
Compare high-cost debt with expected investment returns cautiously.
Identify cases where paying down debt could reasonably compete with additional investment.
Do not assume that investing is always preferable to debt repayment.
Step 16 — Evaluate Tax Location
Evaluate not just what I own, but where I own it.
Review investments across:
- Taxable brokerage accounts
- Traditional IRAs
- Roth IRAs
- Employer retirement accounts
Identify possible asset-location considerations such as:
- Tax-inefficient bond holdings
- High-distribution investments in taxable accounts
- Growth assets potentially suitable for Roth accounts
- Assets likely to create taxable distributions
Do not recommend moving or selling assets without identifying tax consequences.
For taxable holdings, consider available cost basis and unrealized gains or losses before recommending sales.
Step 17 — Identify Retirement Tax Issues
Identify tax-planning questions that may warrant further analysis, including:
- Traditional IRA withdrawals
- Roth conversions
- Required minimum distributions
- Taxation of Social Security
- Medicare IRMAA thresholds
- Capital gains
- Qualified dividends
- Tax-loss harvesting
- Charitable distributions where applicable
- Interaction between taxable income and retirement withdrawals
Verify current-year tax limits and rules before relying on them.
Clearly distinguish tax-planning opportunities from definitive tax advice.
Step 18 — Compare the Portfolio With Its Actual Purpose
Based on my financial circumstances, state what jobs the portfolio needs to perform.
For example:
- Provide near-term spending
- Generate long-term growth
- Protect against inflation
- Preserve liquidity
- Reduce sequence risk
- Provide legacy assets
- Support unexpected expenses
Then evaluate how well the current portfolio addresses each objective.
Do not judge investments solely by recent performance.
Step 19 — Identify Strengths and Risks
Provide two separate sections:
Portfolio Strengths
Identify elements of the current strategy that appear appropriate and should not be changed without a specific reason.
Issues Requiring Attention
Identify material risks, inefficiencies, concentrations, excessive costs, liquidity problems, tax issues, or other weaknesses.
Prioritize these by financial significance, not by how easy they are to change.
Step 20 — Develop Potential Portfolio Changes
Only after completing the analysis should you propose potential changes.
For each proposed change, explain:
- Current position
- Proposed position
- Approximate dollar amount involved
- Percentage of portfolio involved
- Reason for the change
- Expected benefit
- Important disadvantages
- Tax implications
- Whether the change is urgent or can occur gradually
Do not recommend changes merely to make the portfolio look cleaner.
Retain existing investments when they remain appropriate.
Step 21 — Produce a Current vs. Proposed Allocation
If changes appear warranted, provide a table showing:
Asset Class| Current $| Current %| Proposed $| Proposed %
The proposed portfolio should account for my:
- Retirement spending
- Dependable income
- Cash reserves
- Withdrawal requirements
- Risk capacity
- Time horizon
- Tax circumstances
- Other connected assets and liabilities
Step 22 — Create an Implementation Plan
If changes are recommended, separate them into:
Immediate actions
Items that address significant risk, excessive cost, liquidity problems, or obvious portfolio errors.
Near-term actions
Changes that can reasonably be completed over several months.
Long-term maintenance
Rebalancing, tax planning, withdrawal management, and periodic reviews.
Avoid recommending market timing as an implementation strategy.
Step 23 — Establish Rebalancing Rules
Recommend objective rules for maintaining the portfolio.
For example:
- Annual review
- Percentage-band rebalancing
- Using withdrawals to rebalance
- Using new contributions to rebalance
- Reinvesting dividends selectively
Explain the advantages and disadvantages of the recommended approach.
Step 24 — Identify Information That Needs Verification
Before concluding, identify:
- Missing accounts
- Missing holdings
- Stale balances
- Unavailable cost basis
- Uncertain security classifications
- Incomplete transaction history
- Tax information requiring verification
- Any assumptions that materially affect the conclusions
Do not present uncertain information as fact.
Final Report
Conclude with a Retirement Portfolio Review Summary containing:
- Total financial assets reviewed
- Total investment portfolio
- Total cash and cash equivalents
- Total significant debt
- Current stock/bond/cash allocation
- Largest holdings
- Largest concentration risks
- Estimated annual investment expenses
- Estimated annual portfolio income
- Estimated annual portfolio withdrawal requirement
- Approximate years of near-term withdrawal reserves
- Major tax considerations
- Primary portfolio strengths
- Highest-priority issues requiring attention
- Recommended allocation, if different from current allocation
- Immediate actions
- Near-term actions
- Items requiring additional information or verification
For every major conclusion, distinguish among:
Connected-account facts — information obtained from my linked financial accounts.
Calculated results — values you derived from that information.
Assumptions — information that was unavailable and had to be estimated.
External information — current market, fund, tax, or other information obtained from outside my accounts.
Do not execute trades.
Do not assume that maximizing return is the objective.
The objective is to determine whether my combined financial assets, investment portfolio, cash resources, income sources, debt, and expected withdrawals are structured appropriately to support a sustainable retirement plan.
AI-generated results may be incomplete, inaccurate, or outdated. Verify important information independently and consult an appropriate professional before making financial decisions.