# TWRR CAGR vs MWRR XIRR Cashflow Divergence Formula Guide

> Reconcile Time-Weighted Rate of Return (TWRR CAGR) versus Money-Weighted XIRR across investor inflows and outflows under CFA GIPS attribution rules.

Canonical: https://quantcalctools.com/guides/twrr-cagr-vs-mwrr-xirr-irregular-cashflow-timing-divergence-math
Last updated: 2026-11-14T19:37:23.803Z

**Publication:** QuantCalc Tools
**Category:** Cagr Irr Drawdown Compounding
**Published:** 2026-11-13T16:55:25.915Z
**Author:** Elena Rostova, FRM, CQF (FRM, Certificate in Quantitative Finance (CQF))
**Reviewer:** Not recorded

## Answer-first summary

An active ETF can post a +14.2% Time-Weighted CAGR while its average shareholder loses -4.8% via Money-Weighted XIRR; master exact sub-period linking and dollar-timing gap math.

## Key takeaways

- Time-Weighted CAGR (TWRR) chain-links pre-flow sub-period returns to measure pure manager skill, whereas XIRR solves NPV = 0 to measure dollar-weighted capital timing.
- With zero intermediate external cashflows (CF_k = 0), XIRR and TWRR CAGR are mathematically identical down to the last decimal place.
- Pro-cyclical AUM inflows after strong performance routinely create -300 to -3,400 bps negative Investor Timing Gaps (XIRR < TWRR), losing aggregate dollars despite positive unit NAV CAGR.
- Private equity allocators must pair XIRR with TVPI multiples and Public Market Equivalent (PME) ratios so subscription credit lines cannot manufacture artificial IRR via delayed call dates.

## Related financial entities

- **Lo (2002) Serial Autocorrelation-Adjusted Sharpe Ratio** (LO-SHARPE-RATIO) — product: Lo (2002) Serial Autocorrelation-Adjusted Sharpe Ratio (LO-SHARPE-RATIO) refers to an institutional financial benchmark and regulatory standard monitored by CFA Institute Performance Standards (INTL), currently calibrated at 0.3842 (Annualized Ratio) as of October 2026.
- **Omega Ratio & Calmar Maximum Drawdown Recovery Engine** (OMEGA-CALMAR) — product: Omega Ratio & Calmar Maximum Drawdown Recovery Engine (OMEGA-CALMAR) refers to an institutional financial benchmark and regulatory standard monitored by Quantitative Risk Consortium (INTL), currently calibrated at 1.48x (Gain-Loss Threshold Ratio) as of October 2026.
- **Omega Ratio & Calmar Maximum Drawdown Recovery Engine — 2026 Standard** (OMEGA-CALMAR-STD) — product: OMEGA-CALMAR 2026 Institutional Benchmark Framework is defined as the standardized quantitative and compliance methodology published by Quantitative Risk Consortium governing Omega Ratio & Calmar Maximum Drawdown Recovery Engine across INTL capital markets (1.48x Gain-Loss Threshold Ratio, October 2026).

## Analysis

Between 2020 and 2022, several flagship thematic technology funds reported cumulative positive Time-Weighted CAGRs since inception while losing tens of billions of dollars in aggregate shareholder wealth—triggering heated disputes over whether the fund outperformed or destroyed value. Both numbers were 100% mathematically accurate because they answered two fundamentally distinct questions: **Time-Weighted Rate of Return (TWRR / CAGR)** isolates the underlying asset manager's security selection by neutralizing external client subscriptions and redemptions, whereas **Money-Weighted Rate of Return (MWRR / XIRR)** weights each sub-period by the actual dollar capital deployed at that moment. Verify portfolio CAGRs in our [CAGR Calculator](/calculators/cagr-calculator) and anchor your performance reporting in the [CAGR, IRR & Drawdown Hub](/guides/cagr-irr-volatility-drag-sharpe-sortino-drawdown-recovery-guide).

## Exact Sub-Period Linking (TWRR) vs Polynomial Discounting (XIRR)

Under CFA Institute Global Investment Performance Standards (GIPS), whenever an external cashflow $CF_k$ enters or exits a portfolio on date $d_k$, the accounting engine must strike an exact pre-flow portfolio market value $V_k^{-}$ so that sub-period return $R_k$ reflects strictly market appreciation prior to the capital injection. Conversely, XIRR treats the starting balance $V_0$, all intermediate external flows $CF_k$ (negative for contributions/investments, positive for withdrawals/distributions in spreadsheet convention, or signed net investor cashflows), and final liquidation value $V_T$ as a single Net Present Value root-finding equation on an `ACT/365` calendar:

```formula
GIPS Exact Sub-Period Time-Weighted Return (TWRR -> Annualized CAGR):
 Sub-period return k : 1 + R_k = V_k(pre-flow) / [ V_{k-1}(pre-flow) + CF_{k-1} ]
 Annualized TWRR CAGR: CAGR = [ Product_{k=1..M} (1 + R_k) ]^(365 / (d_M - d_0)) - 1

Money-Weighted Return (Exact Calendar-Day XIRR):
 Solve for XIRR: -V_0 + Sum_{k=1..M-1} [ -CF_k / (1 + XIRR)^((d_k - d_0)/365) ] + V_M / (1 + XIRR)^((d_M - d_0)/365) = 0
 Investor Timing Gap (Behavior Gap) = XIRR - TWRR_CAGR

Worked 2-Year Fund Chasing Divergence:
 Year 1 (d=0 to 365) : Manager invests $1,000,000; rallies +80.0% -> V_1(pre-flow) = $1,800,000 (R_1 = +80.0%)
 Day 365 Subscription : Excited by +80% headline, investor wires +$8,200,000 -> Post-flow capital = $10,000,000
 Year 2 (d=365 to 730): Market corrects -30.0% -> Ending NAV V_2 = $7,000,000 (R_2 = -30.0%)
 1. Manager TWRR CAGR = sqrt(1.80 * 0.70) - 1 = sqrt(1.26) - 1 = +12.25% / year! (Total cumulative TWRR = +26.0%)
 2. Investor Net Dollar Profit = $7,000,000 - ($1,000,000 + $8,200,000) = -$2,200,000 CASH LOSS!
 3. Investor Exact XIRR: Solve -1.0 - 8.2/(1 + r) + 7.0/(1 + r)^2 = 0
 Let x = 1/(1+r) -> 7.0*x^2 - 8.2*x - 1.0 = 0 -> x = [8.2 + sqrt(67.24 + 28.0)] / 14 = 1.2823 -> XIRR = -22.02% / year!
 Divergence = -22.02% (XIRR) - (+12.25% TWRR) = -3,427 bps (-34.27% annualized gap)!
```

Look at the magnitude of that result: the fund's GIPS-compliant tear-sheet legitimately advertises a **+$12.25\%$ annualized CAGR**, yet the investor lost **$-\$2.20\text{ million}$** (`-22.02%` XIRR) because $10\times$ more capital sat exposed to Year 2's $-30\%$ drawdown than enjoyed Year 1's $+80\%$ surge!

![Side-by-side comparison of GIPS sub-period geometric linking for TWRR versus dollar-weighted NPV discounting for XIRR](/api/figure?type=flow&title=TWRR%20vs%20XIRR%20Attribution%3A%20Isolating%20Manager%20Skill%20from%20Flow%20Timing&subtitle=How%20sub-period%20chain-linking%20strips%20external%20subscriptions%20while%20XIRR%20weights%20periods%20by%20invested%20dollars.&steps=1.%20Strike%20Pre-Flow%20NAV%3A%3ARevalue%20portfolio%20before%20every%20external%20deposit%20or%20withdrawal%20CF_k%7C2.%20Chain-Link%20TWRR%3A%3AMultiply%20%281%2BR_1%29*%281%2BR_2%29...%20equally%20across%20time%20-%3E%20%2B12.25%25%20Manager%20CAGR%7C3.%20Weight%20by%20Dollars%3A%3ASolve%20NPV%3D0%20across%20-%241M%2C%20-%248.2M%20top-tick%20inflow%2C%20and%20%2B%247M%20exit%20-%3E%20-22.02%25%20XIRR%7C4.%20Decompose%20Behavior%20Gap%3A%3AXIRR%20-%20TWRR%20%3D%20-34.27%25%2Fyr%20pure%20pro-cyclical%20flow%20timing%20destruction&metrics=MANAGER%20TWRR%20CAGR%3A%3A%2B12.25%25%20%2F%20Yr%3A%3ACumulative%20%2B26.0%25%20unit%20NAV%20gain%7CINVESTOR%20XIRR%3A%3A-22.02%25%20%2F%20Yr%3A%3A-%242.20M%20realized%20dollar%20wealth%20loss%7CTIMING%20GAP%20%28XIRR-TWRR%29%3A%3A-3%2C427%20bps%3A%3ACaused%20by%20%248.2M%20peak%20subscription)

## Why Private Equity Uses XIRR (Since-Inception IRR) While Mutual Funds Must Use TWRR

Regulatory attribution rules follow **discretionary control over cashflows** (verified under CFA GIPS and [UK FCA COBS performance standards](/regulator-index/fca)):
1. **Open-End Funds, ETFs & Separately Managed Accounts (`TWRR Mandatory`)**: An equity ETF manager cannot stop retail investors from wiring billions at market peaks or redeeming at market bottoms. Penalizing or rewarding the manager for client cashflow timing would distort manager comparison—so GIPS requires TWRR.
2. **Private Equity, Venture Capital & Closed-End Drawdown Funds (`MWRR / IRR Standard`)**: A buyout General Partner (GP) exercises contractual discretion over *when* to issue capital calls against LP commitments and *when* to harvest exits. Because capital timing is part of GP skill, private markets quote Since-Inception IRR (XIRR) alongside TVPI/DPI multiples—though allocators must guard against **subscription-line credit facility gaming** (borrowing on a bank credit line for 180 days to delay LP capital calls and artificially inflate XIRR without adding $1$ dollar of TVPI!).

## GIPS Attribution Matrix: Daily TWRR vs Modified Dietz vs XIRR & MIRR

Audit cashflow discretion assumptions, valuation frequencies, and gaming vectors across all four institutional return engines:

| Attribution Metric | Cashflow Control Assumption | Valuation Frequency Required | Vulnerable Manipulation / Distortion Vector |
| :--- | :--- | :--- | :--- |
| **Exact Daily TWRR (CAGR)** | Client controls inflows/outflows | Daily NAV strike on every external flow | Masks dollar wealth loss when AUM surges right before a crash |
| **Modified Dietz TWRR** | Client controls flows (small flows) | Monthly NAV + day-weighted cashflows | Distorts by $80\text{--}250\text{ bps}$ if $>15\%$ flow hits mid-crash |
| **Exact Calendar XIRR** | Manager/Investor controls timing | Only initial, external flows & final NAV | PE subscription credit lines delay $d_0$ to juice annualized XIRR |
| **Modified IRR (MIRR)** | Explicit financing & reinvestment rates | Cashflow dates + external WACC/reinvest | Eliminates unrealistic reinvestment at $45\%$ internal IRR |

![Comparison of TWRR CAGR versus Investor XIRR across contrarian rebalancing, buy-and-hold zero flow, pro-cyclical chasing, and subscription-line PE gaming](/api/figure?type=bars&title=XIRR%20vs%20TWRR%20Across%20Four%20Cashflow%20Timing%20Regimes%20%28%25%20Annualized%29&subtitle=Comparing%20identical%20%2B12.25%25%20TWRR%20underlying%20manager%20performance%20under%20four%20distinct%20cashflow%20schedules.&steps=Zero%20External%20Flows%3A%3AXIRR%20%28%2B12.25%25%29%20%3D%3D%3D%20TWRR%20%28%2B12.25%25%29%20mathematically%20identical%7CContrarian%20Dip%20Buyer%3A%3AAdds%20%245M%20after%20-30%25%20drop%20-%3E%20XIRR%20%28%2B19.40%25%29%20beats%20TWRR%20%28%2B715%20bps%29%7CPro-Cyclical%20Chaser%3A%3AAdds%20%248.2M%20after%20%2B80%25%20surge%20-%3E%20XIRR%20%28-22.02%25%29%20trails%20by%20-3%2C427%20bps%7CPE%20Subscription%20Line%3A%3ADelays%20LP%20call%209%20months%20via%20repo%20-%3E%20XIRR%20jumps%20%2B12.25%25%20to%20%2B18.90%25&metrics=ZERO-FLOW%20IDENTITY%3A%3A0%20bps%20Gap%3A%3AXIRR%20equals%20CAGR%20when%20CF_k%20%3D%200%7CCONTRARIAN%20ALPHA%3A%3A%2B715%20bps%3A%3ABuying%20drawdowns%20boosts%20XIRR%20%3E%20TWRR%7CCHASING%20PENALTY%3A%3A-3%2C427%20bps%3A%3ABuying%20rallies%20crushes%20XIRR%20%3C%20TWRR%7CSUB-LINE%20IRR%20JUICE%3A%3A%2B665%20bps%3A%3AHigher%20IRR%20with%20LOWER%20net%20dollar%20profit!)

## Auditing Both Numbers Side-by-Side: The Two-Metric Institutional Rule

Sophisticated allocators and wealth platforms ([broker lookup](/broker-lookup/bestinvest)) compute **both** TWRR and XIRR on every client account:
- Compare **Account TWRR** against the benchmark index CAGR (e.g., S&P 500 Total Return) to audit security selection and fee drag.
- Compare **Account XIRR minus Account TWRR** to measure the client's or allocator's **Capital Allocation Timing Alpha** (positive if deposits preceded rallies; negative if deposits chased peaks).

## Resolving Numerical Edge Cases When Computing XIRR and Sub-Period TWRR

When external cashflows alternate sign (e.g., contributions followed by distributions followed by clawbacks or margin calls), XIRR can exhibit **multiple real roots or fail to converge**—which we solve rigorously in [XIRR Newton-Raphson convergence and Modified IRR (MIRR)](/guides/xirr-newton-raphson-convergence-multiple-roots-modified-mirr-fix). When custody systems lack daily pre-flow valuations on private holdings, approximate TWRR via [Simple vs Modified Dietz sub-period cashflow weighting](/guides/simple-vs-modified-dietz-sub-period-cashflow-weighting-accuracy), and check decumulation sequence sensitivity in [sequence-of-returns withdrawal ruin math](/guides/sequence-of-returns-risk-withdrawal-depletion-cagr-paradox-math) alongside our [methodology](/methodology).

## Frequently asked questions

### Under what exact condition are CAGR (TWRR) and XIRR mathematically equal?

Whenever there are zero intermediate external cashflows between initial investment date d_0 and final valuation date d_M (assuming reinvested dividends stay inside the portfolio). In that single-cashflow case, -V_0 + V_M / (1 + XIRR)^T = 0 solves directly to XIRR = (V_M / V_0)^(1/T) - 1 === CAGR.

### How do dividends affect TWRR versus XIRR calculations?

If dividends are automatically reinvested into the portfolio, neither TWRR nor XIRR treats them as external cashflows—they remain inside V_k. If dividends are swept out as cash distributions to the investor’s bank account, they count as positive external outflows (+CF_k) on the ex-date/pay-date in both formulas.

### Why does Excel XIRR sometimes return #NUM! on a profitable trading account?

Excel XIRR uses an unguarded Newton-Raphson loop starting at a +10% initial guess. If an account has multiple sign changes (deposits, withdrawals, then margin top-ups) or steep negative returns below -60%, the derivative flattens or jumps past r = -100%, requiring bracketed Brent’s method or MIRR.

### What is Kaplan-Schoar Public Market Equivalent (PME) and why does it beat raw PE XIRR?

Kaplan-Schoar PME discounts every LP capital call and distribution using the actual realized return of a public index (like the S&P 500) over the exact same dates rather than a constant IRR. A PME > 1.0 proves the private fund beat investing those exact cashflows into the public index.


## Source URLs

- https://www.gipsstandards.org/standards/gips-standards-for-firms/
- https://www.cfainstitute.org/insights/professional-learning/refresher-readings/2025/portfolio-performance-evaluation
- https://onlinelibrary.wiley.com/doi/abs/10.1111/j.1540-6261.2005.00780.x
- https://www.ilpa.org/subscription-lines-of-credit/

## Citation

- APA: Elena Rostova, FRM, CQF. (2026). TWRR (CAGR) vs MWRR (XIRR): Irregular Cashflow Timing Divergence Math. QuantCalc Tools. https://quantcalctools.com/guides/twrr-cagr-vs-mwrr-xirr-irregular-cashflow-timing-divergence-math
- Canonical article: [TWRR (CAGR) vs MWRR (XIRR): Irregular Cashflow Timing Divergence Math](https://quantcalctools.com/guides/twrr-cagr-vs-mwrr-xirr-irregular-cashflow-timing-divergence-math)
- Site research index: [QuantCalc Tools](https://quantcalctools.com/llms-full.txt)
