Finance education, free and open.An independent learning project
THEFINANCE ARCHIVES
Finance foundationsEquitiesFixed incomeDerivativesEconomicsFinancial statementsPortfolio management
Home / Portfolio management / Money-Weighted Return (MWR) and What Your Dollars Earned
Portfolio management

Money-Weighted Return (MWR) and What Your Dollars Earned

In this chapter

Intermediate

Imagine a fund has a great year while you have very little invested, then falls after you add most of your savings. A return that gives both years the same place in a linked investment record can look better than your own experience. Money-weighted return (MWR) measures the rate earned on the money you actually had invested. The size and date of each payment matter.

The usual calculation finds the internal rate of return (IRR) of your account’s dated cash flows. It asks what constant compound rate would reconcile every deposit, withdrawal and the value left in the account.

Put the investor’s cash flows on a timeline

Use the investor’s point of view. A deposit into the account is money you pay, so write it as negative. A withdrawal or cash distribution you receive is positive. If you already owned the account at the start of the reporting window, treat its opening value as an investment made on the opening date. Count its ending value as a positive receipt on the closing date, even if you keep holding the account. This makes the number a return through that date.

A dividend left inside the account belongs in the account value. If it is paid out to you, count the payout on its date. If you take a final distribution and also own investments after that, include the distribution and the remaining value. If the account is fully sold and the final proceeds already appear as a withdrawal, there is no separate balance left to count.

\[ \operatorname{NPV}(r)=\sum_{i=0}^{n}\frac{C_i}{(1+r)^{t_i}}=0 \]

\(C_i\) is the signed investor cash flow, \(t_i\) is the elapsed time in years from the starting date, \(n\) indexes the last entry, and \(r\) is the effective annual rate that solves the equation for \(r>-1\). \(\operatorname{NPV}(r)\) is the net present value of the schedule at a trial rate. It is measured in USD here. In a daily calculation with Actual/365 Fixed, divide elapsed calendar days by 365. The first two examples use annual anniversaries with one full year between rows. For irregular dates, use a dated IRR solver, such as XIRR with its 365-day basis, and check that the unrounded rate makes the equation close to zero.

Worked case 1. Solve the rate and check it in dollars

You make two deposits and still own the portfolio at the final valuation. This case and the next use nominal USD values, all investment income reinvested, with no fees, taxes or other cash flows. Deposits shown at a year boundary occur after the old year’s return and before the new year’s return.

Investor dateElapsed yearsEventSigned investor cash flow (USD)
1 January 20210Opening deposit−$2,000.00
1 January 20221Additional deposit−$1,000.00
1 January 20232Remaining account value+$3,520.00

Try 10% per year. The first deposit grows for two years and the second deposit for one.

\[ V_{\mathrm{end}}=\$2{,}000.00(1.10)^2+\$1{,}000.00(1.10)=\$3{,}520.00 \]

The result matches the final balance, so MWR is 10.00% per year. The schedule earns $520.00 over the two years. Dividing that gain by the $3,000.00 total paid in would give 17.33%, a dollar-gain calculation that ignores the different investment durations. You can also discount both later entries back to the starting date and check that their signed present values plus the initial deposit total zero.

Worked case 2. Two return rankings from the same investor schedule

Start each of two hypothetical investments with $1,000.00 on 1 January 2021. Add $3,000.00 to each on 1 January 2022 and value both on 1 January 2023. Assume each deposit follows the same strategy as the capital already in that investment.

InvestmentYear-one returnValue before deposit (USD)Value after deposit (USD)Year-two returnEnding value (USD)
A+20.00%$1,200.00$4,200.00−5.00%$3,990.00
B−5.00%$950.00$3,950.00+15.00%$4,542.50

For the strategy comparison, link \(1.20(0.95)\) for A and \(0.95(1.15)\) for B. Their two-year time-weighted returns are 14.00% and 9.25%, respectively. Expressed per year using the square root of each growth factor, they are 6.77% for A and 4.52% for B.

For the investor comparison, the signed schedule is −$1,000.00 at year zero, −$3,000.00 at year one and the positive ending value at year two. Find the rate that makes $1,000.00 invested for two years plus $3,000.00 invested for one year grow to the ending value. Writing \(x=1+r\), solve \(1000x^2+3000x=3990\) for A and \(1000x^2+3000x=4542.50\) for B, taking the positive growth factor each time. The annual MWR is −0.20% for A and +10.62% for B. Most of the money was there for A’s losing year and B’s winning year. The dates and amounts of the deposits are identical across A and B. It is the placement of the large balance along each return path that flips the ranking.

Worked case 3. Check a withdrawal on an irregular date

On 1 January 2025 you invest $3,000.00. You withdraw $600.00 on 1 April and the account is worth $2,500.00 on 1 January 2026. Keep the same USD, fee, tax and income assumptions. The withdrawal happens at the 1 April valuation after returns through that date. The opening deposit is negative, and the withdrawal and closing value are positive.

The withdrawal falls 90 days after the opening date. Its discount exponent is \(90/365\), while the closing value has an exponent of one.

\[ \operatorname{NPV}(r)=-3000+\frac{600}{(1+r)^{90/365}}+\frac{2500}{1+r}=0 \]

At a 0% trial rate, the signed values add to +$100.00. At 4.00%, the present values add to about −$1.93. The rate between them that brings the total to zero is 3.92% effective annually. The $600.00 came back before year-end. Treating both receipts as a single $3,100.00 payment on the final date would give 3.33% and erase the timing difference.

Read the result with the schedule

A different client can hold the same fund and earn a different MWR. A comparison across managers may tell you more about investment decisions when managers control the timing of capital calls and distributions. When clients control the transfers, check the cash-flow schedules before attributing a difference to the manager. The path dependence of wealth explains why the order of returns matters to an account with changing capital.

If cash flows switch signs several times, there can be several rates that solve the equation, or no usable rate. A spreadsheet result alone does not establish uniqueness. Check the schedule, the date convention and the root. With one series of contributions followed by a positive ending receipt and no earlier withdrawals, there is one positive growth factor when the initial investment and terminal proceeds are positive.

Practice questions

Choose one answer per question. Use the lesson’s conventions unless the question specifies a change. Round only the final result.

1. Calculate a one-year MWR

On 1 January 2025 you invest $4,000.00. On 1 January 2026 the account is worth $4,320.00 before you collect it. There are no other cash flows. What is MWR?

Question 1 choices

A is correct

  • A. Divide the $4,320.00 receipt by the $4,000.00 outlay, then subtract one.
  • B. This is the growth factor expressed as a percentage. The return is the growth above the original capital.
  • C. That divides the $320.00 gain by the final balance.

2. Value the final date

An investor receives a $200.00 withdrawal on the final date and still holds $3,100.00 in the account after the withdrawal. What enters the investor’s cash-flow schedule on that date?

Question 2 choices

B is correct

  • A. This subtracts the withdrawal even though it is a receipt from the investor’s viewpoint.
  • B. Add the $200.00 receipt and the $3,100.00 remaining value, counted once each.
  • C. The remaining balance is only one of the two amounts the investor gets credit for.

3. Solve with two deposits

On three successive annual anniversaries the signed investor flows are −$3,000.00, −$1,000.00 and +$4,730.00. What constant annual rate reconciles them?

Question 3 choices

A is correct

  • A. At 10%, the two deposits compound to $3,630.00 and $1,100.00, a total of $4,730.00.
  • B. This compounds the whole $4,000.00 for two years, giving the second deposit an extra year.
  • C. This divides the $730.00 gain by all capital paid in and ignores each deposit’s duration.

4. Choose the annual time exponent

A payout occurs 182 calendar days after the opening date. The solver uses Actual/365 Fixed. What exponent applies to that payout’s discount factor?

Question 4 choices

C is correct

  • A. An exponent of one would apply after a full 365 days.
  • B. The reciprocal converts a period rate into an annual rate in other calculations. It does not express the elapsed years here.
  • C. The dated equation expresses the elapsed 182 days as a fraction of the stated year.

5. Compare clients

Two clients hold the same fund. One adds a large deposit immediately before a losing quarter and the other makes no transfer. Which statement follows?

Question 5 choices

B is correct

  • A. With the same investment return path, the transfer by itself leaves TWR unchanged.
  • B. The loss applies to different amounts of capital for the two clients.
  • C. Client flows can make the cash-flow-weighted experience diverge from the linked strategy return.

6. Question the solver output

A series has several contributions interspersed with large distributions. What should you check after a solver returns an MWR?

Question 6 choices

C is correct

  • A. Moving cash-flow dates can change the root.
  • B. A simple return average ignores the dollar schedule.
  • C. Repeated sign changes can permit multiple solutions. Check the actual dated equation.

Find a finance concept

Press Enter to see all matching chapters.