Time-weighted return (TWR) measures a portfolio’s compounded investment performance while neutralizing external deposits and withdrawals. Money-weighted return (MWR) measures an investor’s annualized return while accounting for the amount and timing of those cash flows. TWR is generally better for evaluating an investment strategy; MWR is often better for understanding the outcome experienced by the investor.
Two people can own the same portfolio and see the same sequence of market returns yet earn very different money-weighted results. The difference is not necessarily an accounting mistake. Instead, it reveals when each person had more capital exposed to the market.
A useful performance report should identify which return it presents, the time period covered, the treatment of fees, and whether investor contributions and withdrawals affect the result.
Time-Weighted vs Money-Weighted Return: The Key Differences
Both measures describe investment performance, but they answer different questions. A time-weighted rate of return isolates the compounded performance of the underlying portfolio. A money-weighted rate of return reflects the actual pattern of capital invested, removed, and held at the period end.
| Question | Time-weighted return (TWR) | Money-weighted return (MWR) |
|---|---|---|
| What does it measure? | Compounded portfolio growth across subperiods | Return implied by dated investor cash flows and terminal value |
| Do deposits and withdrawals affect the result? | Their distorting impact is neutralized | Yes, through their timing and size |
| Typical calculation | Geometric linking of subperiod returns | Internal rate of return (IRR) or dated-cash-flow XIRR |
| Most useful for | Comparing managers, strategies, or benchmarks | Reviewing investor experience or capital allocation |
| Required records | Portfolio values around relevant external flows | Dated contributions, withdrawals, and terminal value |
| Main limitation | May differ from the investor’s actual outcome | Can reflect investor decisions outside the manager’s control |
Neither return is inherently more accurate. Each becomes misleading when someone uses it to answer the wrong question. For example, a personal retirement account may need both a manager-comparison return and an investor-experience return.
What Is Time-Weighted Return?
Time-weighted return measures the compound growth of one unit invested in a portfolio over the evaluation period, independent of subsequent external cash movements. To calculate it precisely, analysts divide the history at appropriate valuation points, calculate a return for each subperiod, and geometrically link those returns.
The Time-Weighted Return Formula
For n consecutive subperiods, the basic formula is:
TWR = [(1 + r₁) × (1 + r₂) × … × (1 + rₙ)] − 1
Here, each r is a subperiod investment return, expressed as a decimal. A positive 20% return becomes 0.20, while a negative 10% return becomes −0.10.
For a simplified subperiod with no intervening external flows:
Subperiod return = (Ending value before any ending contribution or withdrawal ÷ Beginning value after any beginning contribution or withdrawal) − 1
The before and after distinctions are critical. An incoming deposit is new investor capital, not investment profit. Treating the contribution as market growth would inflate the result.
A Simple Two-Year Calculation
Consider a fictional portfolio with two annual investment returns: +20% in Year 1 and −10% in Year 2. The cumulative time-weighted return is:
(1.20 × 0.90) − 1 = +8%.
The two-year annualized compound rate equals:
(1.08)^(1/2) − 1 ≈ +3.92% per year.
Notice that the second year’s 10% loss is applied to the portfolio level reached after the first year’s gain. Simply adding +20% and −10% would suggest +10%, which is wrong: compound returns follow multiplication, not addition.
Why Large Cash Flows Require Special Treatment
In real portfolios, deposits can occur between monthly statement dates. The Global Investment Performance Standards (GIPS) handbook explains that an accurate TWR calculation may require a portfolio valuation when a large external cash flow occurs, followed by geometric linking of the affected subperiods. Where daily returns are not available, prescribed flow-adjusted methods can be used under consistent policies.
Therefore, a statement calculated only from January and December balances is not automatically a valid TWR. Unless the analyst separates external contributions and withdrawals, the apparent gain may be little more than added cash.
What Is Money-Weighted Return?
Money-weighted return evaluates the economic result produced by all relevant contributions, withdrawals, and the final investment value. In practice, analysts commonly compute an internal rate of return, or IRR, that makes the present value of those dated cash flows equal zero.
The calculation assigns more economic weight to periods when more money is invested. If an investor adds substantial capital just before a loss, the MWR will generally be worse than if that capital had arrived after the decline, assuming the same market-return path.
The Money-Weighted Return Formula
For annual cash flows at regular one-year intervals:
0 = CF₀ + CF₁/(1 + r) + CF₂/(1 + r)² + … + CFₙ/(1 + r)ⁿ
The unknown r is the money-weighted annual rate. Use a consistent sign convention: contributions are negative cash flows from the investor’s perspective; withdrawals and the final remaining portfolio value are positive.
For irregular dates, a dated-cash-flow calculation replaces integer year counts with the elapsed fraction of a year. A common spreadsheet expression is:
0 = Σ[CFᵢ / (1 + r)^((dateᵢ − date₀)/365)]
Software usually solves this equation numerically rather than through a simple percentage-change calculation. Also, a non-standard cash-flow pattern with repeated sign changes may yield multiple solutions or no suitable real IRR. Such cases require additional judgment rather than accepting the first spreadsheet result unquestioningly.
Worked Example: A Positive Portfolio Return but a Negative Investor Return
Now use exactly the same two-year portfolio path: +20% in Year 1, followed by −10% in Year 2. Assume zero fees, taxes, distributions leaving the account, and transaction friction. An investor starts with $10,000 and adds another $10,000 at the end of Year 1, after the first year’s growth but before the second year’s decline.
| Event | Portfolio value | Investor’s external cash flow |
|---|---|---|
| Start of Year 1 | $10,000 | −$10,000 |
| End of Year 1, after +20% | $12,000 | $0 before deposit |
| New deposit at end of Year 1 | $22,000 | −$10,000 |
| End of Year 2, after −10% | $19,800 | +$19,800 terminal value |
The investment strategy’s cumulative TWR remains +8%. The deposit does not change the subperiod returns of +20% and −10%.
Yet the investor contributed a total of $20,000 and finishes with $19,800. That is a $200 net investment loss, before any costs omitted from the example.
To find the annualized MWR, solve:
0 = −10,000 − 10,000/(1 + r) + 19,800/(1 + r)²
The solution is r ≈ −0.668% per year. Consequently, the same portfolio produces +8% cumulative time-weighted growth and a negative annual money-weighted return for this investor.
Why Both Figures Are Correct
The investor had only $10,000 exposed during the profitable first year. However, the investor had $22,000 exposed during the losing second year. The later loss was applied to a much larger capital base.
TWR ignores the capital increase when measuring the portfolio strategy. MWR includes it when measuring the investor’s financial experience. Neither number cancels the other; they describe different dimensions of the same account history.
Practical insight: A positive fund-performance figure and a negative personal return can coexist without fraud, miscalculation, or poor fund tracking. The first step is to compare investment return dates with contribution dates.
Change the Withdrawal Timing and the Result Reverses
Consider a second fictional investor using the same +20%, then −10% portfolio returns. This person starts with $10,000 but withdraws $8,000 at the end of Year 1, before the second-year decline. After the 20% rise, the account is worth $12,000. The withdrawal leaves $4,000, which becomes $3,600 after the 10% drop.
The account again has +8% cumulative TWR, or +3.92% annualized over two years. However, the investor receives $8,000 in Year 1 and $3,600 in Year 2 against an initial $10,000 contribution.
The annualized money-weighted return solves:
0 = −10,000 + 8,000/(1 + r) + 3,600/(1 + r)²
This gives r ≈ +12.11% annually. The investor’s total cash proceeds exceed initial capital by $1,600, although IRR is not the same as the simple $1,600 ÷ $10,000 profit percentage.
| Scenario using identical market returns | Two-year cumulative TWR | Annualized TWR | Annualized MWR |
|---|---|---|---|
| No external flows after initial $10,000 | +8.00% | +3.92% | +3.92% |
| Add $10,000 before the losing year | +8.00% | +3.92% | −0.67% |
| Withdraw $8,000 before the losing year | +8.00% | +3.92% | +12.11% |
The figures are original illustrative calculations, not historical investment returns. Their purpose is to isolate the effect of cash-flow timing while holding the investment return sequence constant.
When Should Investors Use Each Performance Measure?
The best method depends on the question and on who controls the relevant cash movements. In a liquid, client-managed account, investors normally decide when to contribute or withdraw. A manager should not necessarily receive credit for a client’s unusually well-timed withdrawal or blame for a deposit made just before a market selloff.
For that reason, time-weighted returns are generally helpful when comparing investment managers, fund strategies, and reference benchmarks. By contrast, the money-weighted result tells the account owner what happened to the actual capital committed along the way.
Comparing an Index Fund with a Benchmark
Suppose an equity fund intends to follow a published index. An analyst should compare aligned fund and benchmark performance using consistent total-return calculations, currency, and fee treatment. The investor’s personal cash deposits are usually not a useful measure of the fund manager’s replication quality.
The fund’s tracking error answers yet another question: how much the fund’s periodic returns vary around those of the benchmark. Tracking error should not be confused with either the investor’s IRR or the portfolio’s cumulative return.
Evaluating the Investor’s Own Capital Decisions
An account owner trying to understand retirement progress, contribution timing, or withdrawal outcomes may find money-weighted returns more intuitive. The MWR shows how the invested dollars performed given their actual dates.
Still, a strong MWR does not by itself prove skillful market timing. The result may reflect liquidity needs, employer contribution schedules, or the luck of withdrawing before a downturn. A negative MWR can similarly arise from systematic contributions before a bear market, even when the manager followed the mandate appropriately.
Private Equity and Other Illiquid Strategies
Private-market funds often draw committed investor capital over time and distribute cash as underlying investments are realized. Because these cash-flow decisions may be closely tied to the manager’s investment process, IRR can be relevant for evaluating those strategies.
However, investors should also examine how a fund values unrealized assets, whether interim returns depend on appraisals, and whether subscription lines influence the timing of capital calls. Reporting a high IRR without explaining relevant cash-flow mechanics can leave readers with an incomplete picture.
What Professional Performance Standards Actually Require
The GIPS standards provide useful context rather than a one-size-fits-all consumer formula. The GIPS Standards Handbook for Firms explains that compliant composite and pooled-fund reports generally present time-weighted returns. Under defined conditions, however, a firm may present money-weighted returns instead when it controls external cash flows and the relevant strategy is closed-end, has a fixed life or commitment, or substantially involves illiquid investments.
This is a narrow allowance, not permission to switch between the two figures whenever one looks more flattering. CFA Institute’s guidance on Standard III(D), Performance Presentation, describes a case where a reporting system calculates both rates but management wants to display whichever happens to be higher without labeling the methodology. The guidance treats that practice as inconsistent with fair, accurate, and complete performance presentation.
Another subtle point appears in official GIPS guidance: reporting a money-weighted result to a current individual client is not prohibited merely because that return could not replace TWR in the firm’s applicable GIPS composite report. Client-account reporting and standardized presentations to prospective investors serve different purposes.
Research takeaway: The useful disclosure is not just a return percentage. It includes the calculation method, scope of assets, fee treatment, observation period, and whether the result belongs to a fund composite or to an individual investor’s account.
Time-Weighted Return Formula: Handling Deposits Correctly
A basic one-period holding return is easy to calculate when an account has no deposits or withdrawals. Once significant external flows occur, the analyst must break the history into suitable subperiods or use a method that properly weights cash flows.
Imagine a portfolio worth $50,000 at the start of a month. Midmonth, before receiving a $20,000 deposit, its market value rises to $52,500. After the deposit, its value becomes $72,500. At month-end, the portfolio is worth $71,050.
The first subperiod return equals $52,500 ÷ $50,000 − 1 = +5%. The second equals $71,050 ÷ $72,500 − 1 = −2%. Link the two:
Monthly TWR = 1.05 × 0.98 − 1 = +2.9%.
By contrast, dividing $71,050 by the initial $50,000 would misleadingly suggest a 42.1% investment gain because it incorrectly counts the $20,000 deposit as earned performance.
The example assumes accurate values immediately before the deposit and at month-end. When these observations are unavailable, a Modified Dietz calculation can provide an approximation, but the analyst should identify it as such rather than pretending to have exact flow-date valuations.
Modified Dietz vs IRR: Similar Cash-Flow Inputs, Different Uses
The Modified Dietz method estimates a period return using the starting and ending portfolio values, the net external cash flows, and the proportion of the period for which each flow was present. A common form is:
Modified Dietz return = (Ending value − Beginning value − net external flows) ÷ (Beginning value + Σ[flow × time weight])
The time weight depends on when the contribution or withdrawal occurred. In this convention, deposits are positive flows into the portfolio and withdrawals are negative. This differs from the investor-perspective sign convention used for IRR calculations, so analysts must not mix the two conventions.
A Modified Dietz result is typically a flow-adjusted approximation for a measurement interval. Analysts can geometrically link appropriately calculated subperiod returns to approximate TWR. An IRR, meanwhile, directly solves for the discount rate implied by the investor’s dated cash flows and ending value.
| Method | Main input | What it produces | Main limitation |
|---|---|---|---|
| True TWR | Valuations at relevant external-flow points | Compounded cash-flow-neutral performance | Requires reliable interim valuations |
| Modified Dietz | Opening/closing values, dated or weighted flows | Flow-adjusted period return approximation | Assumes return accrual in a simplified way |
| IRR / XIRR | Dated investor contributions, withdrawals, terminal value | Money-weighted internal rate of return | Sensitive to cash-flow timing and valuation assumptions |
No formula compensates for missing or inaccurate cash-flow records. In particular, an illiquid portfolio’s appraisal values can dominate the apparent return regardless of mathematical precision.
How to Calculate Both Returns in a Spreadsheet
Spreadsheet tools make the mechanics accessible, provided the user assigns signs and dates consistently.
Calculating TWR with Subperiod Returns
Enter each valid subperiod return as a decimal in cells B2:B5. The compound TWR follows:
=PRODUCT(1+B2:B5)-1
Depending on the spreadsheet, this array-style expression may require a compatible formula implementation. A universally transparent alternative is to multiply each factor manually, such as =(1+B2)*(1+B3)*(1+B4)*(1+B5)-1.
To annualize a positive total growth factor over Y years, use (1+TWR)^(1/Y)-1. Do not annualize reported periods shorter than one year when preparing a GIPS-compliant presentation; that standard has its own reporting requirements.
Calculating MWR with IRR and XIRR
For equal annual intervals, enter −10,000, −10,000, and +19,800 in chronological order. The spreadsheet formula =IRR(C2:C4) should return approximately −0.668%.
For irregularly spaced actual dates, use =XIRR(values,dates) in software that supports that function. Enter contributions as negative numbers and withdrawals plus the ending portfolio value as positive numbers. Always double-check that the final valuation is not also counted as a separate withdrawal.
A daily-date XIRR result can differ slightly from an illustrative annual-interval IRR if the observation dates are not exactly one year apart. That is a timing effect, not necessarily an error.
Common Mistakes That Distort Investment Performance
Mistake 1: Counting Deposits as Investment Gains
If an account rises from $10,000 to $18,000 after a $7,000 contribution, the observed increase of $8,000 is not automatically an 80% return. Separate the contribution from market gains and identify when the new capital entered the portfolio.
Mistake 2: Comparing Annualized MWR with Cumulative TWR
An 8% two-year cumulative TWR and a −0.67% annualized MWR use different reporting horizons. Make the period basis explicit before comparing magnitudes. In our example, the equivalent TWR annualized over two equal years is about 3.92%.
Mistake 3: Treating a Dividend as a New Investor Deposit
A dividend that remains in the managed portfolio is investment income, not an external contribution. Similarly, a coupon from a bond remains part of portfolio performance if retained in the account. An actual distribution paid out to an investor may, however, constitute an external withdrawal for the relevant portfolio calculation.
Cash-flow timing also matters when evaluating fixed-income assets. An investor reviewing bond duration should remember that duration weights promised bond payments by present value, whereas MWR weights the investor’s own account-level contributions and distributions. These are separate financial concepts despite their shared focus on payment timing.
Mistake 4: Mixing Gross and Net Returns
Performance before investment-management fees is not directly comparable with a client return after fees, expenses, and taxes. State the treatment of transaction costs, fund expenses, advice fees, and taxes rather than assuming every published number measures the same thing.
Mistake 5: Treating Tax Trades as Free Performance Improvements
Investors sometimes sell losing holdings and buy replacements as part of tax loss harvesting. Those transactions can affect portfolio exposure, tax lots, and investor cash flows. The potential tax benefit should be assessed separately from TWR and MWR; an improved after-tax outcome does not necessarily imply improved pretax manager performance.
Mistake 6: Ignoring Changing Account Boundaries
Moving cash between two subaccounts may be external to each subaccount but internal to the consolidated portfolio. Before calculating a return, define which assets and accounts belong to the performance measurement. Otherwise, transfer entries can be counted twice or mistaken for new capital.
A Practical Performance-Reporting Checklist
Before accepting a broker statement, manager presentation, or portfolio-app result, check the following:
- Identify the metric. Is the displayed figure TWR, MWR, a simple percentage change, or something else?
- Confirm the period. Is it year-to-date, since inception, a rolling 12 months, or an annualized multiyear rate?
- Define portfolio boundaries. Determine which accounts, cash balances, and transfers the calculation includes.
- Check external flows. Verify dates and amounts of contributions and withdrawals, particularly around major market moves.
- Review fee and tax treatment. Distinguish portfolio performance before tax from personal after-tax outcomes.
- Verify benchmarks. Compare TWR with an appropriate benchmark return calculated over the same period and currency.
- Inspect unusual gaps. If MWR and TWR diverge sharply, trace which periods had the largest invested balances.
- Preserve source records. Keep periodic valuations, transaction confirmations, and distribution records for reconciliation.
Where an account has complex irregular flows or instruments without reliable market prices, a professional performance analyst may be needed to establish a defensible result.
Frequently Asked Questions
Is Time-Weighted Return Better Than Money-Weighted Return?
Neither is universally better. TWR generally offers a fairer comparison of a manager’s strategy when clients control deposits and withdrawals. MWR captures the effect of an investor’s actual contribution and withdrawal schedule. A complete account review often uses both and labels their calculation methods clearly.
Why Is My Money-Weighted Return Lower Than My Fund’s Return?
You may have added more money before weak market periods or withdrawn capital before strong ones. Fees, account-level holdings, and calculation dates can also differ. The fund’s published return typically measures the investment strategy, while your MWR reflects when your own money entered and exited.
Can Money-Weighted Return Be Negative When TWR Is Positive?
Yes. In the two-year example above, the underlying portfolio gained 8% cumulatively. However, adding $10,000 immediately before a 10% decline resulted in a $200 investment loss and approximately −0.67% annualized MWR. The different figures reflect cash-flow timing, not contradictory arithmetic.
Is Money-Weighted Return the Same as IRR?
MWR is commonly expressed as an internal rate of return calculated from investor-level cash flows. For irregular dates, a dated-cash-flow IRR such as XIRR is usually more appropriate than ordinary periodic IRR. Unusual cash-flow sequences can require care because multiple IRR solutions may exist.
Do Time-Weighted Returns Ignore Fees?
No. TWR neutralizes external cash flows; it does not inherently remove costs. It can be calculated gross or net of defined fees, subject to the relevant presentation rules. Investors should examine whether the stated return includes trading expenses, management fees, and other charges.
Can Two Investors in the Same ETF Have Different MWRs?
Yes. They can hold the same ETF but buy and sell at different times and in different quantities. Their money-weighted returns will reflect those decisions. The ETF’s portfolio or NAV-based time-weighted performance does not change merely because an individual investor changes contribution timing.
Final Perspective
Time-weighted return and money-weighted return describe complementary parts of investment performance. TWR captures how the strategy compounded, while MWR captures how an investor’s committed capital performed through time. A strong strategy can coincide with disappointing personal results when contributions and withdrawals occur at unfavorable moments.
The right approach is not to select whichever percentage looks larger. Instead, match the calculation to the question, verify the cash-flow records, disclose the period and fee treatment, and investigate material differences between the two measures. Understanding those differences makes manager comparisons fairer and personal financial decisions easier to evaluate.
This article provides general educational information and does not constitute personalized investment, tax, or financial advice.