Time-Weighted vs Money-Weighted Return: Key Differences Explained

When measuring investment returns, the method you use can dramatically change the result — even for the same portfolio with the same ending balance. Time-Weighted Return (TWR) and Money-Weighted Return (MWR) answer fundamentally different questions: TWR measures how well the investments performed, while MWR measures how well you did as an investor, including your cash flow timing decisions. Understanding the difference is essential for portfolio evaluation, manager selection, and personal financial planning.

What is Time-Weighted Return?

Time-Weighted Return (TWR) is a method that measures investment performance by eliminating the impact of cash flows. It breaks the total holding period into sub-periods between each cash flow (deposit or withdrawal), calculates the return for each sub-period independently, then geometrically links those returns together.

TWR is the industry standard for mutual funds, pension funds, and institutional investors. It’s used by performance measurement systems worldwide and is typically required by the Global Investment Performance Standards (GIPS) for most public-market composites. When combined with risk metrics like the Sharpe ratio and Jensen’s alpha, TWR provides a complete picture of risk-adjusted manager skill.

What is Money-Weighted Return (IRR)?

Money-Weighted Return (MWR), also called Internal Rate of Return (IRR), measures the actual return experienced by the investor, fully accounting for the timing and size of cash flows. MWR solves for the discount rate that makes the present value of all cash flows (deposits and withdrawals) equal to the ending portfolio value.

MWR is widely used in private equity, real estate investing, personal financial planning, and capital budgeting. It tells you whether your cash flow timing decisions helped or hurt your overall returns. Since MWR is an annualized return metric, it’s directly comparable to other investment opportunities when evaluating personal portfolio outcomes.

Time-Weighted Return vs Money-Weighted Return: Key Differences

TWR and MWR are not “better” or “worse” — they answer different questions. TWR asks: “How well did the investments perform?” MWR asks: “How well did I do as an investor, including my cash flow timing decisions?” The same portfolio can produce dramatically different results depending on which method you use.

The Time-Weighted Return Formula

TWR is calculated by geometrically linking the returns of each sub-period between cash flows. Here are the two key formulas:

The key insight is that TWR breaks the measurement period at each cash flow, creating clean sub-periods. Each sub-period’s return is calculated independently, then geometrically linked. This neutralizes the timing effect — whether a $10,000 deposit happened in Period 1 or Period 2 doesn’t affect the TWR, because each period is measured separately. By geometrically linking these sub-period returns, TWR isolates the portfolio’s actual investment performance from the investor’s deposit and withdrawal decisions.

Note on cash flow sign conventions: In TWR calculations, deposits are treated as positive (they increase portfolio value) and withdrawals as negative. This differs from IRR/MWR convention where deposits are negative (cash out of pocket) and withdrawals are positive (cash back to you). Both conventions are correct for their respective methods.

The Money-Weighted Return Formula

MWR is found by solving for the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero:

Sign convention: Initial investment and deposits are negative (cash outflows), while withdrawals and the ending value are positive (cash inflows). This equation has no algebraic solution and must be solved iteratively using trial and error, a financial calculator, or Excel.

In practice, portfolio accounting systems may use Modified Dietz approximations for faster daily return calculations, then reconcile to precise XIRR periodically. For most individual investors, Excel’s XIRR with actual transaction dates is the gold standard for calculating MWR.

TWR vs MWR: A Real Example

Let’s see how TWR and MWR diverge for the same portfolio with a single mid-period cash flow:

Start (t=0)          Year 1 End (t=1)         Year 2 End (t=2)
$100,000      →      $110,000                  $35,000
                     Withdraw $60,000 ←
    

TWR vs MWR: When to Use Each

Choosing between TWR and MWR depends on what question you’re trying to answer. Here’s when to use each method:

TWR and MWR answer different questions, and neither is inherently “better.” The key decision: Are you evaluating someone else’s skill (use TWR) or your own results including timing decisions (use MWR)? Note that GIPS typically requires TWR for public-market manager composites, but allows MWR in specific cases where managers control external cash flows (e.g., certain private equity or closed-end structures).

How to Calculate TWR and MWR

Here are the practical steps for calculating each method:

Time-Weighted Return

1. Identify all cash flow dates — Note every deposit and withdrawal with exact dates
2. Split the period into sub-periods — Create a sub-period between each cash flow
3. Calculate each sub-period return — Use: (Ending – Beginning – Cash Flow) / (Beginning + Cash Flow)
4. Geometrically link the returns — Multiply: (1 + R₁) × (1 + R₂) × … – 1
5. Annualize if needed — Use: [(1 + TWR)^1/years] – 1

Money-Weighted Return

1. List all cash flows with dates — Deposits are negative, withdrawals are positive
2. Include beginning value — Add as negative cash flow at t=0
3. Include ending value — Add as positive cash flow at final date
4. Use Excel’s XIRR() function — Or use a financial calculator’s IRR function
5. Result is annualized — No further annualization needed

Common Mistakes When Using TWR and MWR

Here are the most frequent errors investors and analysts make when calculating and interpreting these return metrics:

1. Using MWR to evaluate fund managers: This penalizes or rewards managers for cash flows they don’t control. If clients deposit money before a crash, the manager looks bad even if they made excellent investment decisions. Always use TWR for comparing manager skill (this is why GIPS typically requires TWR for most public-market composites).
2. Using TWR for personal performance: If you’re evaluating your own portfolio and you control when deposits happen, TWR won’t tell you how well you timed the market. MWR is more relevant for assessing your personal investment experience including your timing decisions.
3. Ignoring the difference entirely: Many investors calculate simple return [(ending – beginning) / beginning] and don’t account for mid-period cash flows at all. This is neither TWR nor MWR and can be wildly misleading when you have large deposits or withdrawals during the period.
4. Arithmetic averaging instead of geometric linking for TWR: TWR requires multiplying (1+R₁)×(1+R₂)×… and subtracting 1, not adding R₁+R₂+…/n. Arithmetic averaging overstates returns when volatility is high and produces mathematically incorrect results.
5. Comparing TWR to MWR directly: They measure different things. TWR = -5% and MWR = +2% doesn’t mean one calculation is “wrong” — it means you withdrew money at a fortunate time. Never compare them as if one represents the “true” return.
6. Using inconsistent dates or frequencies in MWR: XIRR requires actual transaction dates. Using approximate monthly intervals instead of precise dates can materially change the IRR result, especially for short holding periods or large cash flows.
7. Ignoring possible multiple IRR solutions: With non-conventional cash flow patterns (alternating signs, multiple direction changes), there may be multiple IRR values or no real solution. Always sanity-check IRR results against expected market returns.
8. Mixing net-of-fee and gross-of-fee returns: When comparing TWR vs MWR or across managers, ensure you’re using consistent fee treatment. Comparing gross TWR (before fees) to net MWR (after fees) is an apples-to-oranges comparison.
9. Forgetting to annualize: TWR and MWR for multi-year periods should be expressed as annualized rates for comparability with other investments. A 20% total return over 5 years is only 3.7% annualized — a crucial distinction when evaluating performance.

Limitations of TWR and MWR

Time-Weighted Return Limitations

• Ignores investment size: A fund with $1 billion gets the same TWR as one with $1 million, even though managing scale is significantly harder and may constrain available strategies.
• Ignores cash flow impact: Large redemptions forcing liquidations at inopportune times aren’t reflected in TWR, even though they materially hurt remaining investors.
• Computationally intensive: Requires portfolio valuation at every cash flow date, which is impractical for daily-traded accounts with frequent transactions.

Money-Weighted Return Limitations

• Mixes skill and luck: Can’t separate manager investment skill from cash flow timing luck, making it impossible to isolate what’s repeatable.
• Unfair for external managers: Penalizes managers for client behavior they don’t control (panic selling at bottoms, greed buying at tops).
• Not comparable across portfolios: Two managers can have vastly different MWRs purely due to different client cash flow patterns, not investment skill.
• Sensitive to timing: A single large cash flow at an unlucky time can dominate the entire return calculation and misrepresent the overall experience.

The limitation that matters most depends on your use case. For comparing fund managers, TWR’s complexity is worth it for fairness and comparability. For personal portfolios with infrequent cash flows, MWR’s simplicity and relevance to your actual experience make it the better choice. Regardless of which method you use, combining it with risk metrics like the Sharpe ratio, Treynor ratio, and standard deviation gives a more complete picture of risk-adjusted performance.