Two investors. Same fund. Same time period. Completely different returns, and both are correct.
This is not a paradox. It is the fundamental reality of portfolio performance measurement, and it is exactly why the CFP curriculum distinguishes between the Time-Weighted Rate of Return (TWRR) and the Money-Weighted Rate of Return (MWRR). Each measure answers a different question. Using the wrong one in the wrong context leads to either unfair evaluation of a fund manager or a misleading picture of what an investor actually earned.
For CFP exam candidates in India, TWRR and MWRR are among the most frequently tested concepts in Investment Planning (Module 4). Questions are often scenario-based — asking which measure to use, how to calculate it, or why the two measures diverge. This guide covers both measures end-to-end: conceptual understanding, step-by-step formulas, Indian worked examples, XIRR, GIPS context, and every exam-relevant distinction.
1. Why Two Return Measures Exist
The need for two separate return measures comes from a single root problem: cash flows.
When an investor adds money to a portfolio or withdraws from it, the portfolio’s absolute performance changes. But was this change caused by the fund manager’s skill — or by the investor’s decision about when to invest or withdraw? These are two completely different questions requiring two different measurement tools.
TWRR asks: “How well did my investments perform, regardless of when I added or withdrew money?” MWRR asks: “How well did I do, based on the timing of my contributions and withdrawals?”
Understanding this distinction is the entire conceptual framework behind both measures. Everything else — formula, application, interpretation — flows from this single insight.
2. What Is Time-Weighted Rate of Return (TWRR)?
The Time-Weighted Rate of Return (TWRR) measures the compound growth rate of an investment portfolio over a specified period, completely eliminating the impact of investor cash flows (contributions and withdrawals).
TWRR measures the compound growth rate of an investment over a specified period, irrespective of the timing and amount of cash flows. It is often used to assess the performance of investment managers or compare different portfolios. It eliminates the impact of cash flows by assuming that the portfolio’s value is reset to its beginning value at each cash flow.
The logic of TWRR is straightforward: a portfolio manager cannot control when investors choose to add or withdraw money. They can only control investment decisions — what to buy, sell, and hold. TWRR isolates exactly those decisions by neutralising the effect of cash flow timing.
This is why TWRR is the standard for evaluating fund manager performance and for benchmarking a portfolio against an index.
3. TWRR — Step-by-Step Formula
Step 1: Divide the total evaluation period into sub-periods. Each sub-period ends (and a new one begins) at every significant cash flow event — a contribution or withdrawal.
Step 2: Calculate the Holding Period Return (HPR) for each sub-period:
HPR = (Ending Value − Beginning Value − Cash Flow) / (Beginning Value + Cash Flow)Or more precisely, value the portfolio immediately before each cash flow:
HPRₙ = (V_end − V_begin) / V_beginStep 3: Geometrically link the sub-period HPRs:
TWRR = [(1 + HPR₁) × (1 + HPR₂) × ... × (1 + HPRₙ)]^(1/n) − 1Where n = number of years in the evaluation period (for annualisation).
Key rule: When calculating TWRR, value the portfolio immediately before any significant cash inflow or outflow of funds, dividing the evaluation period into sub-periods based on dates of significant additions or withdrawals of funds. Then compute the holding period return on the portfolio for each period.
4. What Is Money-Weighted Rate of Return (MWRR)?
The Money-Weighted Rate of Return (MWRR) is the Internal Rate of Return (IRR) of all cash flows associated with a portfolio — including the initial investment, all intermediate contributions and withdrawals, and the final ending value. It reflects the actual return experienced by a specific investor, taking into account the timing and size of their personal cash flows.
The money-weighted rate of return (MWRR) considers all cash flows, such as withdrawals or contributions. If an investment spans multiple periods, MWRR gives more importance to the fund’s performance when the account is at its largest. This can be a problem for fund managers because it might make their performance seem worse due to factors they can’t control.
MWRR is investor-specific. Two investors in the same fund over the same period will report different MWRRs if they contributed or withdrew money at different times — even though they were invested in the identical portfolio.
5. MWRR — Step-by-Step Formula
MWRR is the rate r that solves the following equation:
V₀ = CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ + Vₙ/(1+r)ⁿOr equivalently (IRR formulation):
Σ [CFₜ / (1 + MWRR)ᵗ] = 0Where:
- V₀ = Initial portfolio value (treated as a cash outflow — money going in)
- CFₜ = Cash flow at time t (contributions are negative/outflows; withdrawals are positive/inflows)
- Vₙ = Ending portfolio value (treated as a cash inflow — money coming back)
- t = Time period (in years or fractions)
The MWRR sets the present value of the initial value of your investments equal to the present value of all future cash flows such as cash deposits and withdrawals, security purchases and sales, and dividends.
The MWRR calculation is considerably more complex than the TWRR calculation. Performing the MWRR calculation requires a financial calculator or software, although MWRR calculators are available online.
In practice, MWRR is solved using the XIRR function in Excel or a financial calculator’s IRR function.
6. Worked Examples
Example 1 — Demonstrating TWRR
Deepak invests ₹1,00,000 in an equity fund on January 1, 2025. On July 1, 2025 (mid-year), he adds ₹50,000 more. On December 31, 2025, the portfolio value is ₹1,80,000.
Portfolio values:
- January 1, 2025: ₹1,00,000 (initial investment)
- July 1, 2025 (just before contribution): ₹1,12,000
- July 1, 2025 (just after contribution): ₹1,62,000 (₹1,12,000 + ₹50,000)
- December 31, 2025: ₹1,80,000
Sub-period HPRs:
HPR₁ (Jan–Jun) = (1,12,000 − 1,00,000) / 1,00,000 = 12%
HPR₂ (Jul–Dec) = (1,80,000 − 1,62,000) / 1,62,000 = 11.11%TWRR (annual):
TWRR = [(1.12) × (1.1111)]^(1/1) − 1
= 1.2444 − 1
= 24.44%The TWRR of 24.44% reflects the fund’s investment performance — independent of how much money Deepak added or when.
Example 2 — Calculating MWRR for the Same Investor
Using Deepak’s same data:
Cash flows (from investor’s perspective):
- t = 0 (Jan 1): −₹1,00,000 (outflow)
- t = 0.5 (Jul 1): −₹50,000 (outflow)
- t = 1 (Dec 31): +₹1,80,000 (inflow — ending value)
Find MWRR (r) that solves:
0 = −1,00,000 + (−50,000)/(1+r)^0.5 + 1,80,000/(1+r)^1Solving iteratively (or using XIRR):
MWRR ≈ 19.7%
Interpretation: Deepak’s TWRR was 24.44% but his personal MWRR was only 19.7%. Why? Because he added ₹50,000 mid-year, and the fund performed less strongly in the second half than the first. His personal experience was diluted by the timing of his additional investment. The fund manager performed at 24.44% — but Deepak personally earned 19.7%.
Example 3 — When MWRR Exceeds TWRR (Lucky Timing)
Priya invests ₹1,00,000 in the same fund on January 1, 2025 but adds ₹50,000 on July 1 before the fund’s stronger second-half performance.
Portfolio values:
- Jan 1: ₹1,00,000
- Jul 1 (before addition): ₹95,000 (fund fell 5% in H1)
- Jul 1 (after addition): ₹1,45,000
- Dec 31: ₹1,95,000 (fund rose 34.5% in H2)
Sub-period HPRs:
HPR₁ = (95,000 − 1,00,000) / 1,00,000 = −5%
HPR₂ = (1,95,000 − 1,45,000) / 1,45,000 = 34.5%TWRR:
TWRR = [(0.95) × (1.345)] − 1 = 27.8%Priya’s MWRR (solved via XIRR) ≈ 34%
Priya’s MWRR exceeds TWRR because she invested more money just before the fund’s strongest period — her personal cash flow timing worked in her favour.
It is entirely possible for a portfolio to show a 5% TWRR and a 7% MWRR simply because the investor contributed new funds at an opportune time. That does not mean the investments underperformed or outperformed — it just means the timing of money going in and out impacted personal performance.
7. When TWRR and MWRR Diverge — and Why
The main difference between them is that the time-weighted return (TWRR) eliminates the effect of cash flows in and out of the portfolio, whereas the money-weighted rate of return (MWRR) includes the effect of cash flows. If you calculate the return for a one-year period where no cash flows occur, the money-weighted and time-weighted return will be the same.
TWRR and MWRR are equal only when there are no interim cash flows. The moment an investor contributes or withdraws, the two measures diverge. The direction of divergence depends on the timing:
| Scenario | MWRR vs TWRR |
|---|---|
| Large contribution before strong performance | MWRR > TWRR |
| Large contribution before weak performance | MWRR < TWRR |
| Large withdrawal before strong performance | MWRR < TWRR |
| Large withdrawal before weak performance | MWRR > TWRR |
| No cash flows during period | MWRR = TWRR |
If funds are added to a portfolio when the portfolio is performing well, the money-weighted rate of return will be inflated. If funds are added when the portfolio is performing poorly, the money-weighted rate of return will be depressed.
This is precisely why MWRR cannot be used to evaluate a fund manager — the manager had no control over when Deepak or Priya chose to invest. Penalising the manager for Deepak’s poor timing or rewarding them for Priya’s lucky timing would be completely unfair.
8. XIRR — The Practical Tool for MWRR
For most real-world MWRR calculations — especially those involving SIPs, irregular contributions, or multiple cash flows at non-uniform intervals — solving the IRR equation manually is impractical. The standard solution is XIRR in Microsoft Excel or Google Sheets.
Many firms use Excel to calculate money-weighted returns using the XIRR function. The XIRR function calculates an annualised internal rate of return — an IRR is a method that can be used to calculate an MWR.
XIRR Formula in Excel:
=XIRR(values, dates, [guess])- Values: All cash flows (negative for outflows/investments, positive for inflows/redemptions)
- Dates: Corresponding date for each cash flow
- Guess: Optional starting estimate (usually left blank)
Example for SIP: A 12-month SIP of ₹10,000/month started April 2024. At redemption in April 2025, the portfolio value is ₹1,38,000.
In Excel: Enter −10,000 for each of 12 monthly dates, then +1,38,000 on the redemption date. XIRR gives the annualised MWRR.
XIRR is the standard tool AMFI-compliant platforms in India use to display SIP returns — this is why fund fact sheets show “SIP Returns (XIRR)” as a separate metric from point-to-point CAGR.
9. TWRR, MWRR, and SIP Returns in India
In India’s mutual fund ecosystem, both measures serve distinct purposes:
Point-to-Point Return (CAGR): This is the TWRR of a lump-sum investment. It reflects the fund’s compound growth independent of any cash flows. SEBI mandates this for all standard-period performance disclosures (1Y, 3Y, 5Y, since inception).
SIP Return (XIRR): Since a SIP involves regular monthly cash flows at different NAVs, point-to-point CAGR cannot capture the investor’s actual experience. XIRR (the practical MWRR) is used instead, accounting for each monthly investment’s contribution and the timing of redemption.
This is a critical distinction for CFP professionals advising clients. When a client asks “how has my SIP done?”, the correct answer uses XIRR — not the fund’s 5-year CAGR. The fund’s CAGR reflects the manager’s performance; the client’s XIRR reflects the client’s personal experience based on their investment pattern.
TWRR removes the effects of cash flows and focuses solely on the investment’s performance. It is useful for comparing the performance of fund managers because it is not affected by the timing and amount of withdrawals or contributions. MWRR takes into account the specific timing and size of cash flows, making it ideal for individual investors.
10. GIPS Standards and TWRR — The Global Framework
The Global Investment Performance Standards (GIPS®), developed and administered by CFA Institute, are the globally accepted framework for calculating and presenting investment performance.
Over 1,600 organisations claim compliance with the GIPS standards, which have been adopted by organisations from 54 markets around the world. All of the top 25 asset managers globally claim compliance with the GIPS standards for all or part of their business.
One of the key requirements under GIPS is the use of Time-Weighted Rate of Return (TWRR) for performance reporting. This is because TWRR eliminates the factors — namely cash flows — which are typically outside the control of portfolio managers. By neutralising these factors, TWRR allows for a more accurate assessment of a manager’s investment skill and enables fair comparisons across portfolio managers and strategies.
For CFP candidates: understanding GIPS is tested under the professional ethics and investment planning domains. The fundamental principle — that TWRR is the standard for manager evaluation because it removes investor-controlled variables — is a recurring concept in CFP and CFA exam questions.
11. TWRR vs MWRR — Which Is Better?
Neither measure is universally “better.” They are tools designed for specific purposes, and the right choice depends entirely on what question you are trying to answer.
TWRR is the CFA Institute’s preferred method of performance measurement as it is the most comparable and least distorted calculation measure. If your investment manager has discretion of when to add and withdraw money, or you wish to see the implications of your cash flow timing whether due to circumstance or emotional or cognitive behavioural finance biases, then a MWRR will be a good measure of performance. Rather than choose one of the two, both can be used to assess your account’s performance.
For a financial planner advising a client, both are useful simultaneously:
- TWRR tells the planner whether the fund selected has performed well versus its benchmark — evaluating the fund selection decision.
- MWRR tells the planner whether the client’s investment behaviour (timing, amounts) has added or subtracted value — evaluating the investor’s decision-making.
A large gap between TWRR and MWRR for the same client portfolio is itself diagnostic — it reveals whether the investor’s cash flow timing is helping or hurting their wealth creation.
12. Comparison Table — TWRR vs MWRR
| Parameter | TWRR | MWRR |
|---|---|---|
| Full form | Time-Weighted Rate of Return | Money-Weighted Rate of Return |
| Also known as | Geometric mean return | IRR / Dollar-Weighted Return |
| Effect of cash flows | Eliminated | Included |
| Investor-specific? | No — same for all investors in same fund | Yes — unique to each investor |
| Calculation method | Geometric linking of sub-period HPRs | IRR of all cash flows |
| Practical tool | Manual calculation / performance systems | XIRR in Excel or financial calculator |
| Best used for | Evaluating fund manager performance | Evaluating investor’s personal return |
| GIPS requirement | Yes — required for composite reporting | Permitted for certain private funds |
| Sensitivity to large cash flows | None — neutralised by design | High — heavily influenced by timing |
| SEBI/AMFI use in India | CAGR (lump-sum returns) | XIRR (SIP returns) |
| Equal when? | Only when there are zero interim cash flows | Same as TWRR in that case |
13. Common Mistakes and Misconceptions
Mistake: Using MWRR to evaluate a fund manager’s skill.
Correct: MWRR is influenced by the investor’s cash flow timing, which the manager cannot control. A poor MWRR may reflect unlucky investor timing, not poor fund management. Always use TWRR for manager evaluation.
Mistake: Assuming TWRR and MWRR always give similar results.
Correct: When cash flows are large relative to portfolio size, and the market is volatile, TWRR and MWRR can diverge significantly — sometimes by several percentage points.
Mistake: Using fund CAGR to tell a SIP investor “this is your return.”
Correct: A fund’s 5-year CAGR is a TWRR measure for a lump-sum investor. For a SIP investor, the correct measure is XIRR, which reflects the actual timing and amounts of all monthly investments.
Mistake: Thinking a higher MWRR always means the investor made good decisions.
Correct: A higher MWRR than TWRR may simply mean the investor happened to invest more money before a market upswing — timing luck, not skill.
Mistake: Forgetting to value the portfolio immediately before each cash flow when calculating TWRR.
Correct: TWRR requires a portfolio valuation at every cash flow date. Without this, the sub-period HPRs cannot be correctly isolated, and the geometric linking will be inaccurate.
14. Key Exam Points
- TWRR eliminates the effect of cash flows — used to evaluate fund manager performance.
- MWRR = IRR of all cash flows — reflects the individual investor’s actual return experience.
- TWRR = MWRR only when there are no interim cash flows during the evaluation period.
- GIPS requires the use of TWRR for performance reporting, as it eliminates factors outside the control of portfolio managers.
- TWRR formula: [(1+HPR₁) × (1+HPR₂) × … × (1+HPRₙ)]^(1/n) − 1
- MWRR formula: IRR of all cash flows — solved using XIRR in Excel or financial calculator.
- In India, CAGR = TWRR for lump-sum mutual fund return reporting (SEBI mandate for ≥1 year).
- In India, XIRR = MWRR for SIP return reporting — shown separately in fund fact sheets.
- Large contribution before strong performance → MWRR > TWRR.
- Large contribution before weak performance → MWRR < TWRR.
- When calculating XIRR for periods of less than one year, the annualised return generated must be de-annualised.
- GIPS standards have been adopted by organisations from 54 markets globally; all top 25 asset managers worldwide claim compliance.
15. FAQs
What is the difference between TWRR and MWRR?
TWRR measures the compound growth rate of a portfolio by eliminating the effect of investor cash flows — it reflects pure investment performance. MWRR is the IRR of all cash flows and reflects the actual return experienced by the specific investor, accounting for the timing and size of contributions and withdrawals.
Why does GIPS require TWRR for performance reporting?
Because TWRR removes the impact of cash flows that are outside the fund manager’s control. This enables fair, standardised comparisons of investment performance across different fund managers and strategies, which is the core objective of GIPS.
When are TWRR and MWRR equal?
When there are no interim cash flows — no contributions or withdrawals — during the evaluation period. In that case, both measures produce the same result since there are no cash flow timing effects to differentiate them.
What is XIRR and how does it relate to MWRR? XIRR is Excel’s Extended Internal Rate of Return function. It calculates the annualised IRR for a series of cash flows occurring at irregular dates. In practice, XIRR is the standard computational tool for MWRR — particularly for SIP portfolios in India, where cash flows occur monthly on different NAV dates.
Can MWRR be higher than TWRR? Yes. If an investor made a large contribution just before a period of strong fund performance, their MWRR will exceed the fund’s TWRR. This does not mean the fund performed better than reported — it means the investor’s timing of contributions positively affected their personal return.
How is SIP return calculated in mutual funds? SIP returns in India are calculated using XIRR — the practical equivalent of MWRR. Each monthly SIP instalment is treated as a cash outflow, and the redemption value is treated as a cash inflow. XIRR finds the annualised rate that makes the present value of all cash flows equal to zero, giving the investor their personalised return figure.
16. CFP Exam Quick Recap
- TWRR = eliminates cash flow impact → evaluates fund manager skill → required by GIPS
- MWRR = IRR of all cash flows → evaluates investor’s personal return → investor-specific
- TWRR Formula: [(1+HPR₁)(1+HPR₂)…(1+HPRₙ)]^(1/n) − 1
- MWRR Formula: Solve IRR where Σ[CFₜ/(1+r)ᵗ] = 0 → use XIRR in Excel
- TWRR = MWRR only when zero interim cash flows exist
- India: CAGR = TWRR (lump-sum) | XIRR = MWRR (SIP) — both shown in fund fact sheets
- GIPS (54 markets, 1,600+ organisations) mandates TWRR for composite performance reporting
- Contribution before strong returns → MWRR > TWRR | before weak returns → MWRR < TWRR