返回提示词目录第 1545 页

计算投资的真实年度回报

根据现金流和估值数据计算货币加权、时间加权及通胀后的年化回报,并说明各指标差异。

完整提示词

<context>
Most people cannot say what their investments returned, and the common shortcuts mislead. "Current value minus what I put in" ignores when the money went in: 10,000 of gain on money invested ten years ago is a very different result from the same gain on money added last year. Two standard measures answer different questions. **Money-weighted return** (internal rate of return, IRR or XIRR in a spreadsheet) is the investor's personal return, affected by the timing of contributions. **Time-weighted return** strips out cash flow timing and measures how the investments themselves did, which is what funds and benchmarks report. Returns over more than a year should be annualised (a 50% gain over five years is about 8.4% a year, not 10%). After inflation, the real return is roughly the nominal return minus inflation, precisely (1 + nominal) / (1 + inflation) - 1.

<cash_flows>
{{cash_flows}}
</cash_flows>
{{#inflation_and_benchmark}}Inflation and benchmark: {{inflation_and_benchmark}}{{/inflation_and_benchmark}}
</context>

<task>
1. The simple picture: total put in, total taken out, current value, gain in money. Explain why this alone is not a return.
2. Your personal return: calculate the money-weighted annual return (IRR) from the dated cash flows, showing the cash flow table and the method; give the spreadsheet formula (XIRR) they can use to check it. If you approximate, say so and give the approximation's range.
3. The investments' return: if values are given at the dates of cash flows or year ends, compute the time-weighted return by chaining sub-period returns and annualise it. If not, explain what values are needed.
4. After inflation: convert to a real annual return if inflation is given, otherwise explain how.
5. Against a benchmark: compare the time-weighted figure with the benchmark if given, and explain why money-weighted should not be compared directly with a fund or index return.
6. Common mistakes: not annualising, ignoring withdrawals, counting dividends twice, comparing personal return with an index, leaving out fees.
7. Questions to check: whether the values are after all fees, and whether dividends were reinvested.
</task>

<constraints>
{{> guardrails/professional-limits}}
- Show the arithmetic; for IRR, state the result to one decimal place and the method used. Do not present an approximate figure as exact.
- Do not judge whether the result is good enough or suggest changes to holdings.
- Use only the figures given.
{{> output/uncertainty}}
</constraints>

<output_format>
## The simple picture
Short table.

## Your personal return
Cash flow table, method, the annual figure and the XIRR formula.

## The investments' return
Sub-period table and the annualised figure, or what is needed.

## After inflation
Calculation.

## Against a benchmark
Short paragraph.

## Common mistakes
Bullets.

## Questions to check
Bullets.
</output_format>

可替换内容

  • {{cash_flows}}
  • {{#inflation_and_benchmark}}
  • {{inflation_and_benchmark}}
  • {{/inflation_and_benchmark}}
  • {{> guardrails/professional-limits}}
  • {{> output/uncertainty}}

分类与标签

财务理财、投资回报、年化收益、XIRR计算、基准比较

前往 AI 图片创作