Why CAGR Fails: Money-Weighted Return Fixes Irregular Spend

The Spreadsheet That Refuses to Add Up

You launched a campaign in March, poured $15,000 into ads in the first week, paused for six weeks while creative was refreshed, then dropped another $8,000 in May and $22,000 into a Q4 holiday push. Revenue trickled in unevenly across all of it. Now your CFO wants a single ROI number by Friday, and every formula you try tells a different story.

CAGR says 34%. Your gut says that's wrong. Your gut is right.

Here's the core problem: most ROI calculators and spreadsheet templates assume you invest a lump sum on day one and let it ride. Marketing doesn't work that way. You spend in bursts, pause, reallocate, and spend again. When cash flows are irregular, the tool you use to measure return matters more than the return itself.

The Problem: Why CAGR Breaks Under Real Campaign Conditions

CAGR, or Compound Annual Growth Rate, is elegant in its simplicity. It takes a starting value, an ending value, and a time period, then calculates the steady annual growth rate that would get you from one to the other. The formula is clean:

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

But that formula carries a buried assumption: the beginning value stays invested the entire time. It doesn't account for money added or withdrawn mid-period. For a stock you buy once and hold, that's fine. For a marketing campaign where you spend $15,000 in March, nothing in April, $8,000 in May, and $22,000 in October, CAGR treats all $45,000 as if it was deployed on day one.

What That Distortion Looks Like in Practice

Let's say your total spend across the year was $45,000 and total attributed revenue was $72,000. A naive CAGR calculation might frame this as a 60% return annualized. But the $22,000 you spent in October only had two months to generate return, while the $15,000 from March had ten. Treating them identically inflates your perceived performance and sets false expectations for next year's budget conversation.

Worse, if you front-load spend and back-load revenue, CAGR can make a mediocre campaign look stellar — or make a strong campaign look weak if the timing is reversed. The metric becomes a mirror of your cash flow schedule, not your actual marketing effectiveness.

The Cause: A Fundamental Mismatch Between Assumptions and Reality

The reason CAGR fails here isn't a limitation of the formula itself. It's a category error. CAGR was designed for single-deposit, single-withdrawal scenarios. Marketing campaigns are multi-deposit, multi-withdrawal scenarios with timing that directly affects outcomes.

When you spend $15,000 in March and it generates $25,000 in revenue by June, that capital had a real, measurable return over a specific window. When you spend $22,000 in October and it generates $20,000 by December, that's a different return over a different window. CAGR smears these together into a single number that reflects neither accurately.

Money-weighted return solves this by asking a different question: What single rate of return, applied to each cash flow at the exact time it occurred, would reconcile all inflows and outflows to the final value? It's essentially the internal rate of return (IRR) applied to your campaign economics.

Why Finance Teams Already Think This Way

If you've ever sat in a budget review where the finance team seemed to speak a different language, this is part of why. Finance professionals evaluate capital allocation using money-weighted methods because they need to account for the time value of money. When you ask for next year's budget, they're implicitly asking: "Given when you spent and when you earned, what was the actual return on each dollar at the time it was deployed?"

Using CAGR for irregular spend doesn't just give you a wrong number. It gives you a number that's indefensible in that conversation.

The Solution: Calculating Money-Weighted Return for Campaign Spend

Here's the workable outcome: by the end of this section, you'll be able to produce a single, defensible return figure for any campaign with irregular spend, regardless of timing.

Step 1: Map Every Cash Flow With Its Date

List every instance of campaign spend and every instance of revenue, each paired with the date it occurred. Not the month — the actual date, or at least the week. Precision matters because money-weighted return is time-sensitive.

Example cash flow schedule:

• March 5: −$15,000 (ad spend)
• March 28: +$4,200 (revenue)
• May 12: −$8,000 (ad spend)
• May 30: +$3,100 (revenue)
• October 3: −$22,000 (ad spend)
• November 15: +$28,000 (revenue)
• December 20: +$36,700 (revenue)

Negative values are outflows (spend). Positive values are inflows (revenue).

Step 2: Calculate IRR Using a Spreadsheet or ROI Calculator

In Google Sheets or Excel, the function is XIRR, which handles irregular dates. You'll need two columns: dates and cash flow values. The formula:

=XIRR(cashflow_range, date_range)

Using the example above, XIRR returns approximately 47.2%.

Compare that to the naive CAGR approach, which would have told you something closer to 34% or 60% depending on how you framed the inputs. The money-weighted return sits between those extremes because it respects the actual timing of each dollar.

Step 3: Validate Against Your CAGR Figure

You don't discard CAGR entirely. You use it as a sanity check. If your money-weighted return and your CAGR are wildly different, that gap tells you something specific: your spend timing is significantly distorting your perceived performance.

A large positive gap (MWR much higher than CAGR) typically means your later spend was more efficient — you got more return from dollars deployed later in the cycle. A negative gap means your early spend was carrying the campaign and later injections were dragging down efficiency.

That diagnostic alone is worth the switch. It tells you not just what return you achieved, but when your marketing dollars were actually working.

Step 4: Standardize the Process

Once you've run this calculation manually a few times, build it into your regular reporting workflow. Most modern ROI calculators now support money-weighted return or IRR calculations for irregular cash flows. If yours doesn't, a simple spreadsheet template with XIRR will do the job.

The goal is consistency: every campaign, every quarter, measured the same way. When your CFO asks for the ROI number, you hand them a figure that accounts for every dollar at the moment it was deployed. No caveats. No footnotes about timing. Just a defensible, evidence-led answer.

Which Number Should You Report?

Report both — but lead with money-weighted return for any campaign with irregular spend. Use CAGR only when spend was genuinely front-loaded as a single lump sum and revenue flowed continuously afterward. That scenario is rare in modern marketing, where budget is deployed in waves tied to product launches, seasonality, and creative refreshes.

The distinction matters because the decision you're informing is not abstract. It's about where to allocate the next dollar, which channel to scale, and which campaign to sunset. If your return figure is distorted by timing assumptions that don't match reality, every downstream decision inherits that distortion. You might double down on a campaign that looked profitable only because CAGR pretended October spend had twelve months to work. Or you might kill a campaign that was actually performing well but had its returns smeared across a misleading average.

Common Scenarios Where CAGR Misleads Most

Not every campaign suffers equally from CAGR's blind spot. The distortion scales with how irregular your cash flows actually are. Here are the patterns where the gap between CAGR and money-weighted return is widest — and most dangerous:

Seasonal Campaigns With Concentrated Spend

If you spend heavily in Q4 for holiday retail and revenue lands in November and December, CAGR treats your October and November spend as if it was deployed in January. That makes a six-week sprint look like a ten-month sustained effort. Your money-weighted return will be dramatically higher than your CAGR in this scenario, because the capital was deployed close to the revenue event and had less time to compound — yet still produced strong results. Reporting the CAGR figure understates what actually happened and makes it harder to justify repeating the strategy.

Phased Product Launches

When a launch involves a teaser spend in month one, a major push in month three, and retargeting in month five, the cash flows are inherently irregular. CAGR collapses these phases into a single lump and produces a number that doesn't correspond to any real investment decision you made. Money-weighted return, by contrast, tells you whether the timing of each phase was justified by the return it generated in its actual window.

Campaigns With Mid-Cycle Budget Reallocation

If you started with $10,000 per month, saw weak performance in month two, and shifted $25,000 into a different creative in month three, your spend pattern is jagged. CAGR doesn't know that happened. It sees total spend and total revenue and produces a smooth rate that obscures the reallocation decision entirely. Money-weighted return captures the shift because each cash flow is dated and evaluated on its own timeline.

What to Watch For When Switching Metrics

Moving from CAGR to money-weighted return isn't just a formula change. It's a reporting change, and it comes with a few practical considerations worth addressing before you present the new number to stakeholders.

Expect Resistance to Lower-Looking Numbers

In many cases, money-weighted return will be lower than the CAGR you've been reporting. That's not because performance got worse — it's because the old number was inflated. If your team has been quoting 60% annualized returns based on CAGR and the money-weighted figure comes in at 47%, that drop will raise eyebrows. Be prepared to explain why the new number is more accurate, not why performance declined. Frame it as upgrading from an estimate to a measurement.

Handle Negative or Undefined IRR Carefully

If a campaign lost money overall — total spend exceeded total revenue — the IRR may be negative or, in edge cases, undefined. This isn't a flaw in the method; it's an honest signal. A negative money-weighted return means the campaign destroyed value, full stop. CAGR can sometimes mask this by producing a positive rate if the time period is short enough and the loss is modest. Money-weighted return doesn't offer that escape hatch, which is exactly why it's more trustworthy.

Be Consistent Across Comparisons

The biggest mistake teams make after adopting money-weighted return is mixing metrics in side-by-side comparisons. If Campaign A is reported with CAGR and Campaign B with money-weighted return, you're not comparing performance — you're comparing methodologies. Pick one standard for campaigns with irregular spend and apply it universally. Use CAGR only for the narrow case where a single lump sum was deployed upfront and revenue flowed continuously.

The Bottom Line

CAGR is not broken. It's being asked to do a job it was never designed for. When you're evaluating a single investment held over time with no intermediate cash flows, it remains the right tool. But marketing campaigns in the real world don't look like that. They have waves of spend, staggered revenue, mid-cycle shifts, and timing patterns that directly determine whether each dollar was well deployed.

Money-weighted return respects that reality. It evaluates each cash flow at the moment it occurred, reconciles them to a single rate, and produces a number you can defend in any budget conversation — including the ones where finance is asking the hard questions. The switch takes a few minutes of setup, a spreadsheet function that already exists, and a willingness to report a number that might look different from what you're used to.

The payoff is reporting that actually reflects what happened. Not a smoothed average that flatters or penalizes based on when you happened to spend. When your ROI metric mirrors your cash flow reality instead of ignoring it, every decision that flows from that metric gets sharper. That's the entire point of measuring return in the first place — not to produce a number, but to produce a number you can act on with confidence.