ZorantaGuides
Profitday

Profitday › Guides

How to Calculate Portfolio Return With Deposits and Withdrawals

Start with the profit in money: profit = ending balance − starting balance − deposits + withdrawals. That figure is exact. The percentage return is where deposits and withdrawals cause trouble, because money added halfway through a period only had half the time to earn anything.

Example used on this page: an account starts the month at 10,000, you deposit 5,000 on day 15, and it ends at 16,000. The profit is 16,000 − 10,000 − 5,000 = 1,000. The return is about 8%, not 10% and not 6.7%. Here is why, and how to work it out.

Coins flowing into one jar and out of another, apart from a calendar

How to calculate portfolio return with deposits and withdrawals

There are three common methods. They give different answers because they treat the timing of the cash flows differently.

MethodFormula (one period)Example resultWhen to use it
Simple (no adjustment)profit ÷ starting balance1,000 ÷ 10,000 = 10.0%Only when nothing was added or withdrawn
Simple on total money inprofit ÷ (start + net deposits)1,000 ÷ 15,000 = 6.7%Rough check; understates when money arrives late
Modified Dietzprofit ÷ (start + weighted net deposits)1,000 ÷ 12,500 = 8.0%Monthly figures from a single balance per month
Time-weighted (TWR)link the returns between each cash flowabout 8.05%Comparing your trading with a benchmark

The 10% figure flatters you: it gives your trading credit for the 5,000 you deposited and for the gains made on it. The 6.7% figure is too harsh: it treats the 5,000 as if it had been in the account all month.

Profitday

Profitday keeps deposits and withdrawals apart from profit and loss and marks the days they happened, so the profit figure you start from is already clean. Get it on Google Play

Modified Dietz: the practical monthly method

Modified Dietz weights each deposit or withdrawal by the share of the period it was in the account.

  1. Work out the profit: end − start − deposits + withdrawals.
  2. For each cash flow, find its weight: days remaining in the period after the flow ÷ total days in the period.
  3. Multiply each deposit by its weight (withdrawals count as negative) and add them up.
  4. Return = profit ÷ (starting balance + weighted flows).

In the example, the 5,000 deposit on day 15 of a 30-day month was in the account for 15 of 30 days, a weight of 0.5. Weighted flows = 5,000 × 0.5 = 2,500. Return = 1,000 ÷ (10,000 + 2,500) = 8.0%.

With a withdrawal

Say instead you start at 10,000, withdraw 2,000 on day 10 of a 30-day month, and end at 8,600. Profit = 8,600 − 10,000 + 2,000 = 600. The withdrawal's weight is 20 ÷ 30 ≈ 0.667, so weighted flows = −2,000 × 0.667 ≈ −1,333. Return = 600 ÷ (10,000 − 1,333) = 600 ÷ 8,667 ≈ 6.9%.

Time-weighted vs money-weighted return

Time-weighted return

Time-weighted return splits the period at each deposit or withdrawal, works out the return for each piece, and multiplies them together. You need the balance just before each cash flow.

In the example, suppose the balance was 10,400 just before the deposit on day 15:

Because it ignores the size of each deposit, time-weighted return measures how well the trading did, not how well you timed adding money. That is why the investment industry uses it for reporting fund and manager performance; the CFA Institute's Global Investment Performance Standards are built around it.

Money-weighted return (IRR or XIRR)

Money-weighted return answers a different question: what did your money earn, given when you added and removed it? In a spreadsheet, list each date and cash flow (deposits negative, withdrawals positive, the ending balance positive on the last date) and use XIRR. The result is an annual rate, so it suits periods of several months or more.

Keeping records that make this easy

Every method above needs the same raw material: profit and loss recorded separately from money moved in and out, with dates. If deposits are mixed into your daily results, no formula can untangle them later.

These are general calculation methods, not investment or tax advice, and the figures are examples. Trading leveraged products can lose money quickly, and losses can exceed your deposits.
Profitday

Keep profit and cash flows apart from day one

In Profitday you log results and deposits or withdrawals as different kinds of record, and the statistics show profit and loss, deposits and withdrawals by month, year or all time.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Profitday.