Investment Portfolio Analyzer & Strategy Builder

Portfolio Analysis and Strategy: $200K Growth Portfolio, Moderate Risk, 18-Year Horizon

Summary Scorecard

1. Allocation Review

How I built the model: I split the portfolio into three buckets, one for each goal.

• Bucket 1, emergency fund ($15K): kept in the HYSA, never invested.
• Bucket 2, down payment ($25K, needed in about 3 years): short-term Treasuries, CDs, or HYSA. Stocks have historically had a meaningful chance of losing money over a 3-year window, so money you need that soon shouldn't be in them.
• Bucket 3, retirement ($160K, 18 years): about 77.5% stocks and real estate, 20% bonds, 2.5% Bitcoin. That's a growth-leaning mix that still fits a moderate risk tolerance.

Right now your cash covers the emergency fund with only $1K to spare. The down payment money is effectively invested in stocks, which is the biggest mismatch in the portfolio.

2. Diversification Check

Single-stock exposure, including what your funds hold (estimated):

• Nvidia is about 8.7% of QQQ and Apple about 7.8% (ChartRow). VTI holds them too (my estimate: roughly 5–7% each).
• Nvidia: $16K direct + ~$2.6K through QQQ + ~$4K through VTI ≈ $22.6K, about 11%
• Apple: $18K direct + ~$2.3K through QQQ + ~$3.4K through VTI ≈ $23.7K, about 12%
• A sensible cap is 5% per company for a moderate investor. Both are more than double that.

Sector: QQQ is about 50–60% tech, VTI about 30%, and you add two tech stocks on top. Tech and related sectors come to roughly 40–45% of the portfolio, compared with about 30–33% in the overall US market.

Geography: International is 12% of the portfolio, or about 16% of your stocks. A global market-weight portfolio is about 35–40% non-US. You are underweight international.

Overlap: QQQ's top holdings are also VTI's largest holdings, so QQQ adds concentration more than it adds diversification.

3. Risk Assessment

These are my rough estimates using typical long-run volatilities, not precise figures.

How your holdings move together:

• Nvidia, Apple, QQQ and VTI tend to fall together. Their correlation is about 0.8–0.9 during sell-offs.
• REITs are about 0.7 correlated with stocks and are sensitive to interest rates.
• Bitcoin has recently behaved like a high-beta tech asset, falling hard when tech falls.
• Bonds are your only real diversifier. Intermediate Treasuries have usually protected best in crises, though they didn't in 2022, when rates rose.

Biggest drawdown risks:

1. A sharp drop in large-cap tech or AI stocks. Nvidia and QQQ have each lost more than 50% at their worst.
2. A crash that hits in the 1–3 years before the down payment.
3. Bitcoin losing 70% or more, as it has in past cycles. This is small in dollar terms.

4. Goal Fit: Is 7–8% Realistic?

• Vanguard's 10-year forecasts are about 3.9–5.9% a year for US stocks, only 2.3–4.3% for US growth stocks, and 5.8–7.8% for value stocks (Vanguard). International stocks are around 7.1% (Vanguard Mexico CMM). Vanguard names high-quality US bonds, US value stocks, and developed international stocks as the best risk/return opportunities (PR Newswire).
• Using those forecasts, my estimate for your retirement bucket is about 5–6% a year. Over long periods, 70/30 to 80/20 portfolios have earned 7–9% historically, so 7–8% is possible but should be treated as an upside case, not the base case.
• The trade-off: chasing 8% would mean more stocks and more tech concentration, which is exactly the growth segment with the lowest forecasts. That would mean more risk without a reliable increase in expected return.
• What it means in dollars: with no new contributions, $160K grows to about $420K at 5.5% or $590K at 7.5% after 18 years. Regular contributions will matter more than squeezing out extra return.

Rebalancing Plan

Result: Apple and Nvidia each drop to about 3% through your funds (down from about 12% and 11%), and stocks fall to about 57% of the whole portfolio, or about 77.5% of the retirement bucket once you count REITs.

Timing: Rebalancing inside the Roth has no tax cost. In the taxable account, spread the sales over Q4 2026 and January 2027 so the gains fall into two tax years. Buy the down payment reserve first.

Opportunities & Gaps

• ESG versions of your core funds: broad US and international ESG index funds that exclude tobacco, thermal coal, and weapons typically cost about 0.09–0.15% a year. Switching the whole taxable account would trigger gains, so use new money and the Roth for ESG funds first, or switch when a position has a loss.
• Short/intermediate Treasuries as the main crash protection. Treasury interest is also exempt from state income tax.
• US value or small-value tilt (optional, 5–10% of stocks): these have better forecast returns than growth stocks and offset the QQQ tilt.
• International small caps and emerging markets: partly covered by VXUS already. A small extra tilt is optional.
• Bitcoin through a spot ETF (optional): fits your funds-only preference and is easier to track for taxes. Only switch if the tax cost is small.
• Cheaper Nasdaq-100 option: the same issuer offers a lower-cost share class of the Nasdaq-100 fund if you keep that tilt.

Risk Management

• Cash buffers: the $15K emergency fund stays separate from the $25K down payment money. Consider locking in current yields with a CD or Treasury ladder, since HYSA rates can drop if the Fed cuts.
• Down payment de-risking: once the money is in, keep it there. If the purchase date changes, extend or shorten the ladder rather than reinvesting in stocks.
• Hedging: options or inverse ETFs aren't recommended at this risk level. Your bond allocation is the hedge, and rebalancing within set bands does the rest.
• Position caps: no single fund-level stock tilt above 5%, and Bitcoin no higher than 3%.
• Behavior: in a 2008-style crash the plan could still fall about 33%. If that feels unbearable, raise bonds in the retirement bucket to 25–30%.

Tax Efficiency

• Selling the stocks in the taxable account:
  • Sell the highest-cost lots first (specific-lot identification).
  • Make sure each lot has been held more than 1 year, so it's taxed at the lower long-term rate.
  • Offset gains with any losses you have.
  • If your income is above $200K single or $250K joint, watch the 3.8% net investment income tax.
  • Nvidia likely has a large gain, so it's the best candidate to split across 2026 and 2027.
  • If you give to charity, donating appreciated shares avoids the gain entirely.
• Account placement: keeping the REIT fund in the Roth is ideal. Bonds in the Roth are reasonable, but Roth space is most valuable for high-growth assets. Over time, consider holding international or small-value stocks in the Roth and bonds in taxable (Treasuries or munis, depending on your bracket). Keep international stocks in taxable if you want the foreign tax credit.
• Tax-loss harvesting: in taxable, pair each fund with a similar but not identical fund, such as an ESG version of the same index. Avoid wash sales, including purchases in the Roth.
• Roth and the house: your Roth contributions (not earnings) can come out tax- and penalty-free. First-time buyers can also withdraw up to $10K of earnings once the 5-year rule is met. That's a useful backup, but don't plan to use it, because you lose tax-free growth.
• Use new contributions: max out the Roth each year if your income allows, and direct new money to underweight assets. Rebalancing with new money means selling less.

Review Cadence

• Quarterly (15 minutes): check the emergency fund, the down payment ladder, and the Bitcoin cap.
• Twice a year: check drift using 5/25 bands. Rebalance if a major asset class moves 5 points or more from target, or a small one moves 25% from its own target.
• Once a year (full review, e.g., each January): return assumptions, tax-loss harvesting, contributions, and the ESG transition.
• Life events: house purchase, job or income change, marriage or children. After the home purchase, reassess the emergency fund, since homeowners often need 6–9 months.
• From age 50 on: start gradually shifting toward more bonds ahead of retirement at 60.

When to see a licensed professional: a CPA for the gain-realization plan and Roth eligibility, and a fee-only fiduciary CFP for the retirement income plan.

Three Clarifying Questions

1. What is your cost basis and holding period for AAPL, NVDA, and QQQ, and exactly which account holds each position? This decides how fast you can sell them tax-efficiently.
2. What is your tax bracket and household income? This affects Roth eligibility, munis vs. Treasuries, and the 3.8% surtax.
3. Do you have other retirement accounts (401(k)/403(b)), and how much do you save each year? Those accounts change both the right allocation here and whether 5–6% returns are enough to reach your goal.

This is educational information, not personalized financial, tax, or investment advice. Consult a licensed professional before acting.

Sources:

• Vanguard – 2026 outlook: Economic upside, stock market downside
• Vanguard Capital Markets Model forecasts (Vanguard Mexico)
• PR Newswire – Vanguard Releases 2026 Economic and Market Outlook
• ChartRow – QQQ Holdings (2026)