Skip to content
QuantCalc Tools
Directory

Cagr Irr Drawdown Compounding

TWRR (CAGR) vs MWRR (XIRR): Irregular Cashflow Timing Divergence Math

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.

By Elena Rostova, FRM, CQFReview not recorded · Updated
TWRR (CAGR) vs MWRR (XIRR): Irregular Cashflow Timing Divergence Math — QuantCalc Tools 2026 quantitative & supervisory data card
QuantCalc Tools (CAGR vs IRR, Volatility Drag, Sharpe/Sortino & Drawdown Recovery): GIPS sub-period geometric linking vs dollar-weighted NPV discounting and flow timing.Source: QuantCalc Tools Institutional Research DeskLicense: CC-BY-4.0

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 and anchor your performance reporting in the CAGR, IRR & Drawdown Hub.

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

Under CFA Institute Global Investment Performance Standards (GIPS), whenever an external cashflow $CFk$ enters or exits a portfolio on date $dk$, the accounting engine must strike an exact pre-flow portfolio market value $Vk^{-}$ so that sub-period return $Rk$ reflects strictly market appreciation prior to the capital injection. Conversely, XIRR treats the starting balance $V0$, all intermediate external flows $CFk$ (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 or model from the articleNot independently verified
GIPS Exact Sub-Period Time-Weighted Return (TWRR -> Annualized CAGR):
  • Sub-period return k : 1 + Rk = Vk(pre-flow) / [ V{k-1}(pre-flow) + CF{k-1} ]
  • Annualized TWRR CAGR: CAGR = [ Product{k=1..M} (1 + Rk) ]^(365 / (dM - d0)) - 1
  • Money-Weighted Return (Exact Calendar-Day XIRR):
  • Solve for XIRR: -V0 + Sum{k=1..M-1} [ -CFk / (1 + XIRR)^((dk - d0)/365) ] + VM / (1 + XIRR)^((dM - d0)/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% -> V1(pre-flow) = $1,800,000 (R1 = +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 V2 = $7,000,000 (R2 = -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.0x^2 - 8.2x - 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
Side-by-side comparison of GIPS sub-period geometric linking for TWRR versus dollar-weighted NPV discounting for XIRRVerified Exhibit

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):

  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:

Quantitative Distribution · Vulnerable Manipulation / Distortion Vector
Vulnerable Manipulation / Distortion Vector
01Modified Dietz TWRRDistorts by $80…02Modified IRR (MIRR)Eliminates unre…
Attribution MetricCashflow Control AssumptionValuation Frequency RequiredVulnerable Manipulation / Distortion Vector
Exact Daily TWRR (CAGR)Client controls inflows/outflowsDaily NAV strike on every external flowMasks dollar wealth loss when AUM surges right before a crash
Modified Dietz TWRRClient controls flows (small flows)Monthly NAV + day-weighted cashflowsDistorts by $80\text{--}250\text{ bps}$ if $>15\%$ flow hits mid-crash
Exact Calendar XIRRManager/Investor controls timingOnly initial, external flows & final NAVPE subscription credit lines delay $d_0$ to juice annualized XIRR
Modified IRR (MIRR)Explicit financing & reinvestment ratesCashflow dates + external WACC/reinvestEliminates 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
Comparison of TWRR CAGR versus Investor XIRR across contrarian rebalancing, buy-and-hold zero flow, pro-cyclical chasing, and subscription-line PE gamingVerified Exhibit

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

Sophisticated allocators and wealth platforms (broker lookup) 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). When custody systems lack daily pre-flow valuations on private holdings, approximate TWRR via Simple vs Modified Dietz sub-period cashflow weighting, and check decumulation sequence sensitivity in sequence-of-returns withdrawal ruin math alongside our 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.

Publication record

Published
13 November 2026
Updated
14 November 2026
Author
Elena Rostova, FRM, CQF
Review
Review not recorded
Automated fact check
Passed in the stored pipeline record
Source URLs
4 recorded

AI assistance recorded: anthropic/claude-opus-4.6. This field does not establish human review or source verification.

Academic & Institutional Attribution

Cite This Research & Embed Live Data Card

Open Attribution License (CC BY 4.0)

Standard academic & institutional research paper citation format.

Elena Rostova, FRM, CQF. (2026, November 14). 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
Explore Cagr Irr Drawdown Compounding Hub (20) →

QuantCalc Tools Data, Benchmarks & Contributor Records

TWRR CAGR vs MWRR XIRR Cashflow Divergence Formula Guide | QuantCalc Tools