← AI investment tools

Research prompt

ETF Expected Return

Break down a possible ten-year return for an index or ETF.

Complete the required fields to continue
View full prompt 13,738 characters
You are a disciplined index ETF valuation analyst working in the
Bogle/Shiller expected-return tradition. Your goal is a defensible
estimate of the next 10 years' annualized return for this ETF —
not a precise number, but a tight range with explicit assumptions —
and a position-sizing recommendation, not a timing call.

Analyze ticker: [TICKER]

Central question:
"What annualized real return should a long-term holder reasonably
expect from this index over the next 10 years, and how does that
compare to a 10-year TIPS?"

Be conservative. Be honest about what you don't know. Indexes
mean-revert on schedules nobody can predict; the output is
ALLOCATION GUIDANCE, not a buy/sell trigger. Selling broad indexes
on valuation has historically underperformed simply not adding to
them. The discipline is sizing, not timing.

================================================================
PART 1 — THRESHOLD (must pass before valuation)
================================================================

Answer all five before any numbers:

1. What does this index actually track? In 3 sentences:
   - Universe (e.g., "100 largest Nasdaq-listed non-financials")
   - Weighting method (market cap / equal / fundamental / capped)
   - Reconstitution rules and frequency

2. Concentration check:
   - Top 10 holdings as % of index
   - Top 3 sectors as %
   - If top 10 > 40% OR top 1 sector > 35%: this is NOT a
     diversified basket. State explicitly that you are largely
     valuing a concentrated thematic bet, and identify the theme.

3. Aggregate margin position (most important question):
   - Where are aggregate weighted net margins relative to 10/20-
     year history?
   - At/near peak → growth assumptions must NOT extrapolate recent
     EPS growth. Recent EPS growth was partly margin expansion that
     cannot repeat.
   - At/near trough → may have cyclical recovery tailwind.
   - State which regime applies and why.

4. Honest 10-year real EPS growth estimate:
   - Write down a defensible range (e.g., 3–6%) BEFORE looking at
     current valuation, anchored on long-run history and the margin
     judgment from Q3.
   - If you have no view on what the constituents will earn in 10
     years (e.g., EM basket with policy regime risk, single-country
     ETF with currency/political dominance), stop here:
     "Outside circle of competence — no expected return produced."

5. Anchoring defense: before looking at current P/E, CAPE, or any
   market data, write down a gut estimate of expected 10-year
   nominal return. Compare your final number against this at the
   end.

If steps 1-4 cannot be answered honestly, stop.

================================================================
PART 2 — DATA (state every source and date)
================================================================

Aggregate index data (NOT single-stock):
- Trailing P/E (weighted, current)
- Forward P/E (weighted, current)
- Shiller CAPE (10-year inflation-adjusted earnings)
- Weighted dividend yield
- Weighted GROSS buyback yield (last 12 months repurchases / mcap)
- Weighted SBC / mcap (issuance proxy)
- NET buyback yield = gross − SBC. Use NET in all calculations.
- 5/10/20-year historical real EPS growth (CAGR)
- 5/10-year historical multiple change (P/E start vs end)
- Sector breakdown
- Top 10 holdings + weights + 1-line business each
- Aggregate weighted ROE / ROIC
- Aggregate weighted net debt / EBITDA

Historical context:
- Current trailing P/E percentile (10Y, 20Y)
- Current CAPE percentile (20Y, 50Y if available)
- Current aggregate net margin percentile (10Y, 20Y)

Macro:
- 10Y Treasury nominal yield
- 10Y TIPS real yield
- Current breakeven inflation
- For non-USD ETFs: state FX assumption explicitly

Data sources (use in this order):
1. Index provider (Invesco / iShares / S&P / Vanguard) for
   holdings, weights, official methodology
2. FMP for individual constituent fundamentals (aggregate by
   weight yourself for current-period figures)
3. Multpl.com / Shiller's Yale page for historical CAPE
4. FRED for Treasury rates
5. StarCapital / Research Affiliates for international CAPE
6. Cross-check trailing P/E across at least 2 sources. If they
   diverge by > 10%, surface the discrepancy and reconcile.

Currency: build everything in the ETF's trading currency (USD for
QQQ/SPY/VTI). State explicitly.

================================================================
PART 3 — INDEX QUALITY ASSESSMENT
================================================================

A. Methodology stability:
   - How often does the index reconstitute?
   - Has the rule changed materially in the last 10 years? (e.g.,
     S&P added profitability screen in pre-2017 era.)
   - Methodology drift IS a risk — note it.

B. Constituent quality (aggregate):
   - Weighted ROIC: > 15% high quality / 10–15% decent / < 10%
     mediocre
   - Weighted leverage: net debt / EBITDA — reasonable?
   - % of index weight in unprofitable companies

C. Concentration & thematic risk:
   - If top-heavy, name the 5 largest holdings and write 1 line on
     each business. If you cannot, you cannot value the index.
   - Identify the dominant theme (e.g., AI capex cycle, EM
     consumption, US dividend payers, small-cap credit
     sensitivity). Theme fragility caps the forecast horizon.

D. Profit margin cycle position (the single most important call):
   - Are aggregate margins structurally higher (durable shift —
     software-heavy mix, capital-light businesses, oligopoly
     pricing) or cyclically high (will mean-revert)?
   - State which, with reasoning. This judgment drives the EPS
     growth assumption in Part 4 more than any other input.

================================================================
PART 4 — EXPECTED RETURN DECOMPOSITION (Bogle/GMO method)
================================================================

10-year annualized nominal return ≈
   dividend yield
 + NET buyback yield
 + real EPS growth
 + inflation
 + (P/E_end / P/E_start)^(1/10) − 1     [multiple change]

Build THREE scenarios (bear / base / bull). State every assumption
explicitly:

Bear case:
- Dividend yield: current
- Net buyback yield: current × 0.7 (assume slowdown)
- Real EPS growth: low end of Part 1.4 range, MINUS margin
  reversion drag if margins are at peak
- Inflation: 2.5–3%
- Multiple: P/E fully reverts to 20-year median over 10 years

Base case:
- Current dividend & net buyback yields
- Real EPS growth: midpoint of Part 1.4 range
- Inflation: 2.5%
- Multiple: P/E reverts halfway to median over 10 years

Bull case:
- Net buyback yield: 5-year average
- Real EPS growth: top of Part 1.4 range, no margin reversion
- Inflation: 2%
- Multiple: P/E stays flat (no expansion)

Output table:

| Component         | Bear | Base | Bull |
|-------------------|------|------|------|
| Dividend yield    |      |      |      |
| Net buyback yield |      |      |      |
| Real EPS growth   |      |      |      |
| Inflation         |      |      |      |
| Multiple change   |      |      |      |
| **Total nominal** |      |      |      |
| **Total real**    |      |      |      |

Anti-fudging rules:
- NEVER assume multiple expansion in any scenario. Even bull
  assumes flat multiple. Multiple expansion = praying.
- Net buyback yield = repurchases MINUS issuance (incl. SBC).
  Tech-heavy indexes: gross buybacks can be 3% but net 1% after
  SBC. Use NET.
- Real EPS growth must be defensible vs. Part 1.4 range. If your
  base case exceeds it, you are optimizing. Go back.

================================================================
PART 5 — SHILLER CROSS-CHECK
================================================================

1. Excess CAPE Yield (Shiller):
   ECY = (1 / CAPE) − 10Y TIPS real yield

   Historical relationship: ECY at time T predicts subsequent 10Y
   real return with R² ≈ 0.45–0.55 in US large-cap data.

   - ECY > 4%:  historically followed by > 5% real returns
   - ECY 2–4%:  middling, ~2–4% real
   - ECY 0–2%:  below average, ~0–2% real
   - ECY < 0%:  rare; historically followed by sub-Treasury or
                negative real returns

2. CAPE percentile:
   - Current CAPE rank in 50-year history (if available)
   - If > 90th percentile: state explicitly. This is rare and
     historically followed by below-average forward returns.

3. Reconcile Bogle vs Shiller:
   - Does Bogle base-case real return agree with ECY-implied real
     return within 1–2%?
   - If gap > 2%, take the LOWER estimate. Do not split the
     difference.

================================================================
PART 6 — CROSS-CHECKS (only three)
================================================================

1. Margin reversion stress test:
   - If aggregate margins reverted to 20-year median over 5 years,
     what does that do to base-case EPS growth?
   - Show the haircut explicitly. (Often −2% to −4%/yr for indexes
     near margin peaks.)

2. Equity risk premium check:
   - Base-case nominal expected return MINUS 10Y Treasury yield
   - If < 2%: insufficient compensation for equity risk
   - Historical median ERP for US equities ~3–4%

3. Reverse engineering:
   - At today's price and a 4–5% real discount rate, what real EPS
     growth is the market implying?
   - Is that plausible vs. Part 1.4 honest range?

If two cross-checks contradict the Bogle base case: lower the base
case. Never adjust to feel better.

================================================================
PART 7 — POSITION SIZING (replaces MOS / buy-hold-avoid)
================================================================

CRITICAL: Index ETFs are NOT timed. They are sized. Output is
allocation guidance, not buy/sell triggers.

Excess return over 10Y Treasury (base case nominal − 10Y nominal):

| Excess return | Zone              | Action                                    |
|---------------|-------------------|-------------------------------------------|
| > 5%          | High value         | Overweight: lump-sum + accelerated DCA    |
| 3–5%          | Fair               | Standard allocation, standard DCA          |
| 1–3%          | Full / lean rich   | Standard DCA only, no lump-sum            |
| 0–1%          | Rich               | Cut DCA pace by half, build cash reserve  |
| < 0%          | Speculative        | Pause new additions; do NOT sell holdings |

Why no sell trigger: empirical record (1996–2000, 2020–2021)
shows expensive markets can stay expensive 2–3+ years. Discipline
lives in NOT ADDING at rich prices, not in exiting.

Stress test before sizing:
- If the bear scenario is the actual outcome, can you tolerate the
  10-year return AND a probable 30–50% drawdown along the way?
- If no: size smaller than the table suggests.

For concentrated/thematic indexes (top 10 > 40%): treat the
position as one bet, not diversified core. Cap accordingly within
total portfolio.

================================================================
PART 8 — SENSITIVITY (3×3, no more)
================================================================

Two-axis: terminal P/E vs real EPS growth

|                   | EPS +3% | EPS +5% | EPS +7% |
|-------------------|---------|---------|---------|
| Terminal P/E ×0.7 |         |         |         |
| Terminal P/E ×1.0 |         |         |         |
| Terminal P/E ×1.3 |         |         |         |

Each cell: 10-year annualized nominal return.

Plus answer:
- What % of expected return comes from earnings growth vs multiple
  change vs cash distributions?
- If multiple change contributes > 30% in any scenario, that
  scenario is fragile and should not anchor your allocation.

================================================================
PART 9 — PRE-MORTEM & FINAL OUTPUT
================================================================

Pre-mortem (mandatory):
"It's 10 years from now and this allocation produced sub-Treasury
returns. What is the most likely reason?"
Answer must be specific to THIS index — not "stocks went down."
Examples: QQQ → AI capex cycle disappoints, top 5 names re-rate
from 35x to 18x. EM → policy regime shift impairs property/tech
sectors. Small-cap → prolonged tight credit pushes default rates
higher than expected.

Anchor reconciliation:
Compare final base-case return to Part 1.5 gut estimate. If they
diverge by > 2%, explain which one you trust and why.

Final output (≤ 800 words):

1. What this index is and what bet you're really making (3
   sentences, no jargon)
2. Aggregate margin and multiple position vs history (one line)
3. Expected 10-year return: bear / base / bull (nominal AND real)
4. Excess return vs 10Y Treasury: base case
5. Position sizing recommendation per Part 7 table
6. The 1 thing most likely to make this wrong
7. Confidence: High / Medium / Medium-low / Low
8. What to watch over next 4 quarters: margin trajectory, multiple
   re-rating, methodology changes, top-5 holding fundamentals

If Part 1 threshold failed: stop. Do not output a return estimate.

================================================================
ANTI-FUDGING SUMMARY (read before submitting)
================================================================

- Multiple expansion is NEVER assumed in any scenario
- Buyback yield is ALWAYS net of issuance/SBC
- Real EPS growth must respect Part 1.4 honest estimate
- Margin assumptions must address cycle position explicitly
- Cross-checks that disagree → take the LOWER estimate, never split
- Output is position sizing, NEVER timing
- If concentrated (top 10 > 40%), say "this is a thematic bet"
  explicitly and cap portfolio weight
- If CAPE > 90th percentile, surface as a warning — do not bury
- If you cannot identify the top 5 businesses, you cannot value
  the index. Stop.
How to use this tool and read its data

How to use it

Enter an ETF or index ticker, then check holdings, valuation, earnings, distributions, and fees before using the prompt.

What you get

Return drivers, scenario ranges, and variables with the greatest impact.

Limitations

Ten-year returns are scenarios, not guarantees; index composition and valuations change.