Last updated:
Money-Weighted vs Time-Weighted Return: What the Money-Weighted Return Calculator Actually Measures
The money-weighted return calculator answers the question every individual investor really wants answered: what is the annualized return on the dollars I actually had at work in the market? It does this by solving for the single rate that discounts every dated cash flow, each deposit you made, each withdrawal you took, and the value of your portfolio today, back to a net present value of zero. In spreadsheet terms it is the XIRR function, and this page produces the same result with the same actual/365 day-count convention that Excel uses. Many brokerage statements label this figure the personal rate of return calculator would produce, since it reflects exactly what an individual account holder actually earned rather than a fund-level benchmark number.
A time-weighted return takes a different perspective. It chains together the percent return of each sub-period between cash flows, then geometrically links them, removing the effect of how much money you had invested in any given period. That is exactly the right metric for a mutual fund manager, who has no control over when investors deposit or redeem shares. But for a personal account, where you do control the timing and magnitude of every contribution, XIRR gives a far more accurate picture of your actual experience. According to the CFA Institute, this measure is the recommended performance approach when the investor controls the timing of cash flows, which is the typical situation for any DIY brokerage or retirement account such as an IRA, whose contribution and distribution rules are set out by the IRS.
When to Use XIRR: Calculating Personal Investment Performance
Use the XIRR calculator whenever your account has more than one contribution or withdrawal over the period you want to measure. That includes virtually every 401(k), IRA, taxable brokerage account, HSA, 529 plan, and crypto wallet that builds up over time. Single-purchase, buy-and-hold positions like a one-shot lump-sum mutual-fund investment can be measured with a simple CAGR calculator instead, because CAGR assumes exactly one starting balance and one ending balance. But the moment you add a second cash flow, CAGR breaks down and XIRR becomes the right tool.
The relationship between this tool and a periodic IRR calculator is also worth understanding. IRR assumes evenly spaced cash flows, annual or monthly intervals. XIRR handles any irregular calendar dating, which matches how real portfolios behave: a paycheck contribution one week, a dividend reinvestment the next, a partial sale two months later. For an account with truly identical monthly contributions, monthly IRR and XIRR will agree to several decimal places. For anything irregular, only XIRR is right, and the tool above is the simplest way to compute it without a spreadsheet.
Why XIRR Matters for Dollar Cost Averaging
Dollar cost averaging is the most common form of investing, a fixed amount contributed every month or every paycheck; and it is precisely where time-weighted return becomes most misleading. Because DCA invests progressively more total capital over time, the later years carry far more dollar-weight than the earlier ones. A time-weighted figure treats every period as equal, but XIRR correctly weights each period by the actual capital at risk. The practical implication: if the market is volatile early in your DCA program and trends up later, your money-weighted return will outpace the time-weighted figure. If the market rises first and falls last, your money-weighted return will lag. The XIRR result is the honest record of what your strategy actually earned.
The Bogleheads wiki on calculating personal returns walks through the same XIRR methodology that this tool implements, and recommends it as the default measure for long-term DIY investors. For a deeper definition of the math behind XIRR, see Investopedia's XIRR article, which covers the discounting equation and common pitfalls.
Comparing Your Money-Weighted Return to a Benchmark Index
Benchmarking your XIRR result against a published index number, say, the S&P 500's 10% annualized, is not quite apples to apples, because the index figure is time-weighted and assumes a lump-sum starting position. The correct comparison is the XIRR you would have earned by depositing the same dated cash flows into the index. To do this, build a parallel cash-flow series with the same dates and amounts, replace your ending portfolio value with what the index would have been worth on the same end date, and run the same calculation on that shadow series. The difference between your real XIRR and the shadow XIRR is the cleanest measure of your skill (or luck) versus simply buying the index.
When you compare across multiple periods or holding lengths, an annualized return calculator on the same underlying portfolio will tell you the geometric mean over a single sub-period, useful for examining one calendar year, while the money-weighted return calculator gives the full multi-year picture including every contribution. Use both together: the annualized figure isolates the most recent year, and the XIRR figure tells you the long-run dollar-weighted truth. For a complete picture of personal investing math, all of these tools live in the investing calculators section of Quant Calculators alongside CAGR, IRR, and total-return tools.
Common Mistakes When Using a Money-Weighted Return Calculator
The single most common mistake is sign confusion. Deposits, money you put in, must be entered as negative numbers because they are outflows from your bank account into the portfolio. Withdrawals and the current portfolio value must be entered as positive numbers because they represent value that would flow back to you on liquidation. If you reverse these signs, the solver will land on a number on the wrong side of zero or fail to converge entirely. A second frequent error is forgetting to include the current portfolio value as the final row; without it, the solver has no terminal cash flow and cannot find a rate.
A third pitfall is omitting reinvested distributions. If your account automatically reinvests dividends or interest, those reinvestments stay inside the portfolio and should not appear as cash flows in the calculation. They are already captured in the ending portfolio value. Only money that crossed the boundary between you and the account belongs in the cash-flow series. Finally, when your goal is to compare against a benchmark index, build a shadow XIRR series with identical dates rather than comparing to the index's published time-weighted return; the comparison is only fair when both numbers are computed by the same money-weighted method on the same dated cash flows.