Money-Weighted Return Calculator

Understanding Your Personal Investment Return

While portfolio performance metrics often focus on what investments earned, the money-weighted return (MWR) answers a more personal question: what return did you actually achieve given when you invested and withdrew money? This metric, also known as the Internal Rate of Return (IRR) or XIRR when using exact dates, accounts for the timing and magnitude of every cash flow to reveal your true investment experience.

MWR finds the single discount rate that makes the present value of all cash flows equal to zero. This rate represents the return you personally earned, considering not just investment performance but also the fortunate or unfortunate timing of your capital movements. An investor who added money before strong gains and withdrew before losses would show MWR exceeding the underlying investment's return; one with opposite timing would show MWR below it.

The calculator uses the XIRR method, which handles cash flows on exact dates rather than assuming equal periods. This precision matters because investment timing rarely follows neat intervals, and even small date variations can meaningfully affect return calculations when dealing with significant capital movements.

The Mathematics Behind MWR

MWR calculation solves for the rate r in the equation: Σ[CFi / (1 + r)^ti] = 0, where CFi represents each cash flow and ti represents the time in years from the first cash flow to that particular flow. Negative values indicate money invested (deposits), while positive values indicate money received (withdrawals or ending value).

The calculator uses the Newton-Raphson iterative method to solve this equation since no closed-form algebraic solution exists. Starting from an initial guess, the algorithm repeatedly refines the estimate until the NPV converges close enough to zero that further iteration produces negligible change.

Consider an investment where you deposited $10,000 on January 1, 2023, added $2,000 on April 1, withdrew $500 on July 1, deposited another $3,000 on October 1, and the portfolio was worth $16,500 on January 1, 2024. The MWR calculation finds the rate that equates all these cash flows in present value terms. For this example, the MWR would be approximately 6.8% annually.

MWR Versus Time-Weighted Return

The distinction between MWR and Time-Weighted Return (TWR) reflects different evaluation purposes. TWR measures what a single dollar would have earned if invested throughout the period, eliminating cash flow effects. MWR measures what you actually earned given your specific cash flow pattern.

When MWR exceeds TWR, your timing helped your returns. You invested more before gains and less before losses, or withdrew before losses and held through gains. When MWR falls below TWR, your timing hurt your returns. The difference quantifies how much value your timing decisions added or subtracted.

Fund managers are properly evaluated using TWR because they cannot control investor deposits and withdrawals. Your personal investment experience, however, includes your timing decisions, making MWR the relevant measure for understanding your actual wealth accumulation. Both metrics have value, but they answer different questions.

Cash Flow Conventions

Proper MWR calculation requires consistent cash flow sign conventions. Negative amounts represent money leaving your pocket and entering the investment, including initial deposits, additional contributions, dividend reinvestments, and any other capital additions. Positive amounts represent money returning to you, including withdrawals, distributions received, and the final portfolio value.

The final portfolio value must be entered as a positive cash flow on the ending date, representing what you would receive if you liquidated the entire position. This is true even if you did not actually withdraw the money; it represents the terminal value available to you.

Be careful with dividends and interest. If reinvested, they do not need separate entries since they are already reflected in the portfolio value. If distributed to you (paid out rather than reinvested), enter them as positive cash flows on their receipt dates. Mixing treatment causes calculation errors.

IRR Versus XIRR

Standard IRR assumes equal time periods between cash flows, suitable for analyzing regular monthly or annual investments. XIRR (Extended Internal Rate of Return) uses actual calendar dates, providing accurate calculations regardless of cash flow timing irregularity.

The calculator uses XIRR methodology, making it appropriate for real-world scenarios where investments happen whenever capital becomes available, withdrawals occur when needed, and market timing attempts create irregular patterns. This precision particularly matters when large cash flows occur at non-standard intervals.

For portfolios with only annual cash flows at consistent intervals, IRR and XIRR produce identical results. The difference emerges when cash flows occur at irregular intervals, where XIRR correctly accounts for the exact time periods involved in compounding calculations.

Interpreting Your Results

Positive MWR indicates your investment grew; negative MWR indicates it shrank. Beyond this basic interpretation, comparing MWR to TWR or benchmark returns reveals your timing impact.

If your MWR significantly exceeds a buy-and-hold strategy's return, your active trading or tactical allocation added value through superior timing. If it falls significantly below, your timing subtracted value, and a simpler strategy would have served you better. This comparison provides honest feedback about whether active management is helping or hurting.

Context matters for interpretation. MWR during a strong bull market should be compared against market returns for that period. Achieving 8% MWR while the market returned 15% represents underperformance despite the positive absolute return. Conversely, losing only 5% when markets fell 20% represents significant outperformance despite the negative return.

Limitations and Edge Cases

MWR assumes all returns can be reinvested at the calculated rate, which may not hold in practice. If your MWR is 15%, the calculation implicitly assumes withdrawn funds could earn 15% elsewhere, which may be unrealistic.

Some cash flow patterns produce multiple mathematical solutions (multiple IRRs) or no real solution at all. This typically occurs with unconventional patterns like large withdrawals followed by large deposits, creating sign changes in the present value function. The calculator handles most reasonable scenarios but may report errors for unusual patterns.

MWR is highly sensitive to large cash flows near calculation dates. A $100,000 deposit one day before measuring creates nearly infinite annualized return on that deposit if the ending value reflects any gain at all. Use measurement periods appropriately matched to your actual investment horizon.

Practical Applications

Evaluating your investment advisor's impact requires comparing your MWR to what you would have achieved with a passive approach. If your advisor's recommendations led you to invest before gains and avoid losses, your MWR will exceed index returns. If their timing advice was counterproductive, it will lag.

For retirement planning, MWR on your total portfolio reveals the actual growth rate of your wealth including all contributions, withdrawals, and rebalancing activities. This rate, not hypothetical return assumptions, reflects your real accumulation trajectory.

Comparing MWR across different accounts reveals where your timing has been most and least effective. If your taxable account MWR significantly exceeds your IRA MWR despite holding similar investments, your trading activity in the taxable account is adding value. If the reverse is true, your active management is subtracting value.

Tax-aware investors use MWR to evaluate whether tax-loss harvesting, asset location strategies, and other sophisticated techniques actually improve after-tax returns. The technique may reduce reported taxable gains while inadvertently hurting MWR through poor timing of buy and sell decisions.

Improving Your MWR

Since MWR reflects timing impact, improving it requires better timing decisions or eliminating timing decisions altogether. Dollar-cost averaging removes timing decisions by investing fixed amounts at regular intervals, causing MWR to converge toward TWR over time.

Avoid emotional reactions to market movements. Panic selling during downturns and euphoric buying during rallies systematically creates poor timing, causing MWR to lag TWR. A disciplined approach that maintains target allocations regardless of market conditions typically improves long-term MWR.

If you are adding new capital, consider spreading it over several months rather than investing lump sums that might coincide with market peaks. Similarly, when withdrawing for large expenses, plan ahead to avoid forced sales at inopportune times. These practices reduce timing risk and help MWR approach what the underlying investments actually returned.

---

Money-weighted return reveals the investment return you actually experienced, accounting for every deposit, withdrawal, and the timing of each. Unlike metrics that ignore cash flow effects, MWR honestly reflects how much your wealth grew given your specific investment behavior. Calculate your MWR to understand your true investment performance and to evaluate whether your timing decisions are helping or hurting your long-term results.