TWR vs XIRR: Which Return Metric Actually Reflects Your Wealth?

When reviewing fund factsheets or institutional performance reports, the headline figure is almost always Time-Weighted Return (TWR). TWR serves an essential regulatory role in institutional fund management — but for a private DIY investor who also controls when money goes in and out, relying on it alone can miss part of the picture.

Here is the mathematical explanation of how TWR and Money-Weighted Return (XIRR) work, why they diverge, and when each one is the right tool.

1. The mathematical formulas

Time-Weighted Return (TWR)

TWR measures the compound rate of growth of a single portfolio unit over a specified evaluation period, geometrically linking the returns of individual sub-periods between external cash flows:

$$R_{\text{TWR}} = \left[ \prod_{t=1}^{n} (1 + r_t) \right] - 1$$

Where each sub-period return $r_t$ is calculated as:

$$r_t = \frac{V_t - (V_{t-1} + C_t)}{V_{t-1} + C_t}$$

• $V_t$: Portfolio valuation at the end of sub-period $t$.
• $V_{t-1}$: Valuation at the start of sub-period $t$.
• $C_t$: External cash flow (deposit or withdrawal) occurring at the start of sub-period $t$.

Key Characteristic: TWR removes the impact of the size and timing of cash inflows and outflows, isolating pure asset-selection performance.

Money-Weighted Return (XIRR / MWR)

XIRR (Extended Internal Rate of Return) calculates the internal discount rate $r$ that equates the present value of all cash inflows and outflows to the current ending valuation:

$$\sum_{i=1}^{N} \frac{C_i}{(1 + r)^{\frac{d_i - d_0}{365}}} = 0$$

• $C_i$: Cash flow on date $d_i$ (deposits are negative cash flows, withdrawals and ending portfolio value are positive cash flows).
• $d_i - d_0$: Number of days between cash flow $i$ and the base date $d_0$.
• $r$: The annualised internal rate of return solved iteratively (e.g., via the Newton-Raphson method).

Key Characteristic: XIRR weights every pound by the exact number of days it was actively deployed in the market.

2. Why institutional funds use TWR: The GIPS standard

Under the Global Investment Performance Standards (GIPS) governed by the CFA Institute, professional investment managers are required to report TWR — and for good reason.

The rationale is straightforward: a fund manager controls asset allocation and security selection, but cannot control when clients deposit or withdraw money. If clients sell at market bottoms or add cash at market peaks, a money-weighted return would unfairly credit or blame the manager for decisions the manager didn't make. TWR is the correct, fair way to measure a manager's skill in isolation.

As an independent DIY investor managing your own ISA, SIPP, or GIA, your situation is different in one respect: you control both security selection and cash-flow timing. That doesn't make TWR wrong for you — it's still the right lens for "did my stock picks beat the index?" — but used on its own, it won't tell you anything about how your contribution schedule affected your actual pound outcome.

3. Worked numerical example: TWR vs XIRR divergence

Consider two investors holding the exact same index fund over a 2-month period where the market fluctuates:

• Month 1: The fund falls by 20%.
• Month 2: The fund rises by 25% (recovering to its starting level: $1.00 \times 0.80 \times 1.25 = 1.00$).

Investor A: Static Lump Sum

• Deposits £10,000 on Day 1.
• Value after Month 1: £8,000.
• Value after Month 2: £10,000.
• TWR: $0.0%$ | Ending Profit: $£0$ | XIRR: $0.0%$

Investor B: Dollar-Cost Averaging into Dips

• Starts with £1,000 on Day 1.
• Value after Month 1: £800 ($-20%$).
• Deposits an additional £9,000 right before Month 2 begins (Total base: £9,800).
• Value after Month 2: $£9,800 \times 1.25 = \mathbf{£12,250}$.
• TWR: $0.0%$ | Ending Profit: $\mathbf{+£2,250}$ | XIRR: $\mathbf{+827%}$ (Annualised)

The Diagnostic Takeaway

Both investors held the exact same security and recorded an identical TWR of 0.0% — correctly, since neither investor's stock-picking beat or lagged the index at all. But Investor B walked away with £2,250 of real cash profit because 90% of their capital was deployed to capture the 25% recovery, while Investor A's was fully deployed the whole time and captured the net-flat round trip. TWR is right about asset selection being identical; XIRR is right about the pound outcome being different. Neither metric is "wrong" here, they're just answering different questions. (Investor B's XIRR looks extreme only because the example spans two months — annualising a short, lopsided cash-flow pattern like this always produces an outsized headline rate; the £2,250 profit is the number that matters.)

4. Decision framework: When to use each metric

The two metrics aren't in competition — they answer different questions, and the most complete picture comes from looking at both together.

5. How Omnicogi implements dual-engine tracking

Omnicogi calculates both performance dimensions concurrently from your transaction ledger:

1. Daily-Weighted XIRR: Solved via bisection-assisted Newton-Raphson iteration across every deposit, dividend reinvestment, and withdrawal to provide your true personal hurdle rate.
2. Sub-Period TWR: Maintained alongside XIRR to deliver unbiased tracking against global benchmark indices.
3. Clean Cash Decomposition: Separates your net bank contributions from organic capital appreciation, isolating market gains from regular savings habit.

Disclaimer: Omnicogi is an independent software tracking application, not an FCA-regulated investment manager or financial adviser. Return metrics, mathematical models, and benchmark comparisons are provided for educational and analytical purposes only. Past performance is not indicative of future returns. Consult a qualified financial adviser for personal investment advice.