← AI 投资小工具

研究 Prompt

ETF Expected Return

拆解指数或 ETF 未来十年的可能回报。

填入必要信息后即可使用
查看完整提示词 13,738 字符
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.
使用说明与数据边界

如何使用

输入 ETF 或指数代码,核对成分、估值、盈利、分红和费用后运行 Prompt。

会得到什么

收益来源拆分、情景回报范围及影响回报的核心变量。

使用边界

十年回报是情景估算,不保证实际收益;指数成分和估值会变化。