What Is the Money-Weighted Rate of Return (MWRR)?

Table of Contents

What Is the Money-Weighted Rate of Return (MWRR)?

Let me explain what the money-weighted rate of return (MWRR) is. It's a way to evaluate your investment's performance by taking into account the timing and size of cash flows, like dividends and withdrawals. You can think of MWRR as synonymous with the internal rate of return (IRR), and it gives you a comprehensive view that includes how your own behavior as an investor affects the performance. This is different from the time-weighted rate of return (TWRR), which strips out the effects of cash flows, so MWRR really shows you how your actions influence your returns.

Key Takeaways on MWRR

The money-weighted rate of return looks at investment performance by including the size and timing of cash flows, which gives you a more personalized reflection of your returns. It's the same as the internal rate of return and stands apart from the time-weighted rate of return because it factors in your behavior through inflows and outflows of cash. Calculating MWRR can get complicated, so you'll usually need spreadsheet software that has functions like IRR to make it easier. This metric is especially useful if you're an investor who wants to see how your own contributions and withdrawals affect your overall investment returns. Keep in mind, though, that unlike TWRR, MWRR doesn't remove the distorting effects of cash flow variations, so it's not the best for comparing different investment managers' performances.

Understanding the Mechanics of Money-Weighted Rate of Return

There are plenty of ways to measure returns on assets, so you need to know which method is being used when you're reviewing performance. The MWRR incorporates the size and timing of cash flows, making it an effective way to measure your portfolio's returns. It aligns the initial value of your investment with future cash flows, including things like dividends, withdrawals, deposits, and proceeds from sales. Essentially, MWRR helps you figure out the rate of return required to start from your initial investment, accounting for all cash flow changes over the period, right up to the sale proceeds.

Calculating the Money-Weighted Rate of Return

The formula for MWRR is based on equating the present value of outflows to the present value of inflows, like this: PVO = PVI = CF0 + CF1 / (1 + IRR) + CF2 / (1 + IRR)^2 + CF3 / (1 + IRR)^3 + ... + CFn / (1 + IRR)^n, where PVO is PV Outflows, PVI is PV Inflows, CF0 is the initial cash outlay or investment, CF1 through CFn are the cash flows, N is each period, and IRR is the initial rate of return. This can be tricky to solve manually because it often involves trial and error, so I recommend using a spreadsheet or calculator to estimate it.

Steps to Calculate MWRR With a Spreadsheet

Purchase one share of stock for $50, receiving a $2 annual dividend.
Record two dividend payments for two years.
In the third year, sell the share for $65.
Input these cash flows into a spreadsheet (initial purchase, dividends, final sale).
Use the spreadsheet's IRR function, omitting the rate guess, to determine the MWRR.

Analyzing Cash Flows in Money-Weighted Rate of Return

MWRR functions like the IRR—it's the discount rate where the net present value equals zero, meaning the present value of inflows matches outflows. That's why identifying cash flows in and out of your portfolio is crucial, including sales of assets. Outflows might include the cost of investments you purchase, reinvested dividends or interest, and withdrawals. Inflows could be proceeds from investments sold, dividends or interest received, and contributions.

Comparing Money-Weighted and Time-Weighted Rates of Return

You'll often see MWRR compared to the time-weighted rate of return (TWRR), but they differ significantly. TWRR measures the compound growth rate in a portfolio and is used to compare investment managers by removing distortions from money inflows and outflows. Figuring out earnings can be tough because deposits and withdrawals skew the returns—you can't just subtract the starting balance from the ending one, as the end balance includes both investment returns and any cash movements. TWRR breaks the portfolio return into intervals based on cash additions or subtractions. In contrast, MWRR accounts for your behavior through inflows and outflows without separating those intervals, so cash movements can directly impact it. If there are no cash flows, both methods should give similar results.

Recognizing the Limitations of Money-Weighted Rate of Return

MWRR takes into account all cash flows, including withdrawals, and in long-term investments, it emphasizes performance when the fund is at its largest—that's the 'money-weighted' part. This can unfairly penalize fund managers for cash flows they don't control. For instance, if you add a large sum right before performance improves, it's viewed positively because the bigger portfolio gains more in dollar terms. But if you withdraw before a surge, it's negative, as the smaller fund benefits less. The advantages of MWRR include letting you check if your investment generates a consistent return like an interest rate; if not, your return rate drops. When deciding between money-weighted or time-weighted, use MWRR to see how your changes affect your investment—it eliminates comparison usefulness but shows your decisions' impact. TWRR shows performance without your changes, allowing comparisons. Neither is better; they serve different purposes and can be used together.

The Bottom Line

In summary, the money-weighted rate of return measures your investment performance by including the size and timing of cash flows, giving you a full picture of how your activities—like contributions, withdrawals, and reinvested dividends—affect returns. Unlike TWRR, it reflects the impact of inflows and outflows, making it perfect if you want to evaluate how your financial decisions influence portfolio growth. Use MWRR to understand these effects on your investments.