5 Steps: Money-Weighted Return vs CAGR Side-by-Side

When Your Portfolio Shows Two Different Numbers: A Real Estate Syndicator's Dilemma

You've been tracking a mixed-asset portfolio for three years. You put in $50,000 initially, added another $30,000 eighteen months later, pulled out $12,000 in distributions last quarter, and now your brokerage statement says your position is worth $89,000. You fire up your favorite ROI calculator, plug in the numbers, and get one figure. Then you try a different calculator using CAGR, and the result is off by nearly four percentage points. Which one is telling you the truth?

Neither is lying. They're answering different questions. And if you're managing investments with irregular cash flows—capital calls, distributions, mid-period additions—the metric you choose fundamentally changes how you evaluate your performance.

The Problem: Why Standard Return Calculations Break Down

Most ROI calculators default to one of two approaches: Compound Annual Growth Rate (CAGR) or money-weighted return (also called internal rate of return, or IRR). The problem isn't mathematical accuracy. Both formulas are precise. The problem is context mismatch.

CAGR assumes a single initial investment that compounds undisturbed until the end of the measurement period. It answers: "What constant annual growth rate takes my starting value to my ending value?"

Money-weighted return accounts for every cash movement—when it happened, how much moved, and in which direction. It answers: "What return did I actually earn given the specific timing and size of every dollar I put in or took out?"

When your cash flows are irregular, these two questions produce wildly different answers. Using the wrong one doesn't just give you a slightly off number. It can lead you to repeat underperforming strategies or abandon approaches that are actually working.

Step 1: Identify Whether Your Investment Has Irregular Cash Flows

Before choosing a metric, audit your cash flow pattern. Pull your transaction history and look for any of the following:

- Multiple contributions at different time points - Mid-period withdrawals or distributions - Capital calls that require additional funding - Reinvested dividends treated as new capital - Any transaction that breaks the "one deposit, one withdrawal" pattern

If you made a single lump-sum investment and held it untouched, CAGR and money-weighted return will produce identical results. Skip ahead. But if you see any of the patterns above, you're in irregular territory, and the next steps matter.

Step 2: Calculate CAGR to Establish the "Naive" Benchmark

CAGR is straightforward. It ignores interim cash flows entirely and looks only at your starting and ending values plus the time elapsed.

The formula:

CAGR = (Ending Value / Beginning Value)^(1 / Years) - 1

Using the portfolio from the opening scenario: you started with $50,000, your current position is worth $89,000, and three years have passed. Your net invested capital is $68,000 ($50,000 + $30,000 - $12,000), but CAGR doesn't care about that nuance if you're using total portfolio value.

If you treat $50,000 as the starting point and $89,000 as the ending point over three years:

CAGR = (89,000 / 50,000)^(1/3) - 1 = (1.78)^0.333 - 1 ≈ 21.2%

That number looks impressive. But it's misleading because it completely ignores the $30,000 you added midway and the $12,000 you withdrew. It treats the portfolio as if it grew organically from day one with no interruptions.

The Cause: Why CAGR Distorts Returns When Cash Flows Are Irregular

Here's where most investors get tripped up. CAGR is a time-weighted concept at its core—it measures the growth of a dollar, not the growth of your actual invested capital under real-world conditions.

When you add money mid-period, CAGR doesn't weight that capital by how long it's actually been deployed. If you injected $30,000 in month 18 of a 36-month period, that money had only half the time to compound. But CAGR's start-to-end calculation treats the full ending value as if it grew from the original $50,000 over the entire span.

This creates two distortion types:

Distortion A: The Late-Inflation Illusion

If you add capital late in a period when markets are rising, CAGR overstates your performance. The new money contributes to the ending value but had minimal time to actually generate returns. The growth gets attributed to the full period, inflating the annualized rate.

Distortion B: The Withdrawal Penalty

Pull money out before the end of your measurement window, and CAGR understates your performance. The ending value is lower than it would have been if you'd left everything in place, but the formula doesn't credit you for the fact that you successfully extracted gains.

Neither distortion reflects your actual investment skill. They're artifacts of a formula designed for a simpler scenario than the one you're managing.

The Solution: A Step-by-Step Framework for Choosing the Right Metric

As someone who's spent years comparing these two approaches across hundreds of portfolio scenarios, I've developed a decision framework. Here's how to work through it.

Step 3: Map Every Cash Flow with Exact Dates

List every transaction with three data points: date, amount, and direction (inflow or outflow). Treat the initial investment as a negative cash flow (money leaving your pocket) and the current portfolio value as a positive terminal value.

Your cash flow schedule for the example portfolio:

| Date | Cash Flow | |------|-----------| | Month 0 | -$50,000 | | Month 18 | -$30,000 | | Month 30 | +$12,000 | | Month 36 | +$89,000 (current value) |

This precision matters. Money-weighted return is exquisitely sensitive to timing. A $30,000 deposit in month 6 versus month 18 changes your calculated return significantly.

Step 4: Calculate Money-Weighted Return (IRR)

Money-weighted return uses the IRR formula, which finds the discount rate that sets the net present value of all cash flows to zero. Most modern ROI calculators have this built in, but understanding what's happening under the hood helps you interpret the result.

Using the cash flows above and solving for the rate that makes NPV = 0:

0 = -50,000 + (-30,000 / (1+r)^1.5) + (12,000 / (1+r)^2.5) + (89,000 / (1+r)^3)

Solving this iteratively (which is what your calculator does internally) yields approximately 14.8%.

Compare that to the 21.2% CAGR figure. That's a 6.4 percentage point gap—enough to completely change how you feel about this investment and whether you'd repeat the strategy.

The money-weighted return is lower because it correctly accounts for the fact that $30,000 of your capital had only 18 months to work, and you withdrew $12,000 that stopped compounding entirely.

Step 5: Apply the Decision Rule

Here's the framework I use across every irregular cash flow scenario:

Use money-weighted return when: - You actively decided when to add or withdraw capital - Your timing decisions are part of the investment strategy - You're evaluating your personal investment performance - Cash flows are irregular in size and timing

Use CAGR when: - You're benchmarking against an index or fund that reports CAGR - Cash flows were outside your control (forced capital calls, mandatory distributions) - You need to compare this investment to others on a standardized basis - The investment had essentially one entry and one exit point

Step 6: Report Both Numbers for Full Transparency

The most honest approach for irregular cash flow investments is reporting both metrics with context. State the CAGR as the "time-weighted benchmark" and the money-weighted return as the "investor experience return." The gap between them reveals how much your timing decisions helped or hurt.

A large positive gap (CAGR > money-weighted return) suggests you added capital at unfavorable times. A negative gap suggests your timing added value.

Practical Takeaway for Your ROI Calculator Workflow

Next time you're evaluating an investment with irregular cash flows, run both calculations before drawing conclusions. Plug your cash flow series into a money-weighted return calculator, then separately compute CAGR using only your initial capital and final value. The difference between the two numbers tells a story that neither metric tells alone.

For the portfolio we walked through: CAGR of 21.2% suggests the underlying assets performed well. Money-weighted return of 14.8% tells you that your personal experience of that performance was more modest because of when and how much capital was deployed. Both are true. Both are useful. Using only one gives you half the picture.

The investors who consistently make better decisions aren't the ones with the highest returns on paper. They're the ones who understand which number they're looking at, what it measures, and what it leaves out.