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.
| Method | Formula (one period) | Example result | When to use it |
|---|---|---|---|
| Simple (no adjustment) | profit ÷ starting balance | 1,000 ÷ 10,000 = 10.0% | Only when nothing was added or withdrawn |
| Simple on total money in | profit ÷ (start + net deposits) | 1,000 ÷ 15,000 = 6.7% | Rough check; understates when money arrives late |
| Modified Dietz | profit ÷ (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 flow | about 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 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.
- Work out the profit: end − start − deposits + withdrawals.
- For each cash flow, find its weight: days remaining in the period after the flow ÷ total days in the period.
- Multiply each deposit by its weight (withdrawals count as negative) and add them up.
- 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:
- Days 1–15: 10,400 ÷ 10,000 − 1 = 4.0%
- Days 15–30: the account starts at 10,400 + 5,000 = 15,400 and ends at 16,000, so 16,000 ÷ 15,400 − 1 ≈ 3.9%
- Linked: (1.040 × 1.039) − 1 ≈ 8.05%
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.
- Record each deposit and withdrawal with its date, as its own entry, not as part of a day's result.
- Note the balance at the start of each month.
- Use Modified Dietz for a monthly figure, and time-weighted return if you want to compare against an index.
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 PlayiPhone version coming soon
More guides
- PnL Calendar: How to Read Your Trading Month Day by DayA PnL calendar shows each day's profit or loss in a monthly grid. How to set one up, what to count on each day, and the patterns worth checking at month end.
- Daily Profit and Loss Tracker: A Simple Spreadsheet LayoutSet up a daily profit and loss tracker in Excel or Google Sheets: the columns you need, per-trade or one total per day, formulas for running totals, and common mistakes.
- Trading Win Rate Formula: By Trade or By Day?Win rate = winning trades ÷ total trades × 100. How counting by day differs from counting by trade, how to treat break-even results, and what win rate leaves out.
- Reselling Profit Tracker: Work Out Real Profit Per FlipHow to track reselling profit: the costs to subtract from each sale, profit margin vs ROI, a simple tracker layout, and how to see your profit by day and by month.
Published by Zoranta, the developer of Profitday.