TWR vs MWR: Calculate Account Returns with Deposits
Separate money gained or lost from investment returns. Build a cash-flow ledger, calculate time-weighted and money-weighted returns, and identify the missing valuation that prevents a valid TWR.
Author · Editor
- Author
- Mykola Zavarov
- Editor
- Andriy Bondarenko
Reviewed

The essentials
Account value is a stock of money; monetary profit excludes your contributions. Neither is automatically a percentage return.
TWR links returns between external cash flows. MWR reflects the size and timing of the investor’s cash flows.
The ledger supports 2–24 equal periods and deposits only. Missing intermediate valuations can leave MWR calculable while TWR remains unavailable.
Compare returns over the same period and cost basis. A calculation explains a record; it does not establish future performance.
Start with the ledger, not the account balance
An account starts with 100 USD and finishes with 160 USD. Has it earned 60%? Not if the owner added another 120 USD along the way. The ending value is real, but dividing it by the initial value treats the contribution as investment growth. Before choosing a return measure, separate money transferred into the account from changes in the value of the investments.
Use one valuation currency throughout. Account value here means the value of the whole account, including cash and open investments on a consistent valuation basis. A cash balance that excludes open positions is not a substitute. Record whether each value is measured immediately before or after a contribution; mixing these observations changes the calculation.
Quantity | Question answered |
|---|---|
Ending account value | How much is the account worth at the end? |
Monetary profit or loss | How much remains after subtracting the initial capital and later deposits? |
Time-weighted return (TWR) | How did one unit of capital grow through the return intervals, removing the size of external flows? |
Money-weighted return (MWR) | What constant periodic rate reconciles this investor’s contributions with the ending value? |
Scroll sideways to compare all columns ↔
For this deposits-only ledger, monetary P/L = final value − initial capital − later contributions. In a broader record, withdrawals also belong in the reconciliation. They are not supported by the calculator below. Keep a separate cash-flow record alongside a trading journal: a trade list alone may omit funding events and whole-account valuations.
One ledger: 0% TWR, −20% annual MWR and a 60 USD loss
The following amounts are fictional and illustrate the accounting. The intervals are exactly one year each. The contribution at the end of year one occurs immediately after the 200 USD valuation, with no market change between that valuation and the deposit.
Moment | Value before the contribution, USD | Contribution, USD | Value after the contribution, USD |
|---|---|---|---|
Start | — | 100 | 100 |
End of year 1 | 200 | 120 | 320 |
End of year 2 | 160 | 0 | 160 |
Scroll sideways to compare all columns ↔
Year one returns 200 / 100 − 1 = +100%. Year two starts with 320 USD and returns 160 / 320 − 1 = −50%. Linking the factors gives (1 + 100%) × (1 − 50%) − 1 = 0% over two years. Its annualized equivalent is also 0%. Adding +100% and −50% would incorrectly report +50%.
The investor’s cash flows are −100, −120 and +160 USD. At an annual rate of −20%, their present values sum to zero: −100 − 120 / 0.8 + 160 / 0.8² = −100 − 150 + 250 = 0. The regular-period MWR is therefore −20% per year. The money result is 160 − 100 − 120 = −60 USD.
There is no contradiction. More money was invested during the losing interval. TWR removes the size of the deposit; MWR incorporates it. Neither 0% TWR nor −20% annual MWR says that the investor lost exactly that percentage of all money ever contributed.
Calculate TWR from values on both sides of each flow
For each interval, divide the ending value before the next contribution by the starting value after the previous contribution. Subtract one for that interval’s return. Then multiply all the growth factors and subtract one: TWR = ∏(1 + rᵢ) − 1. The product preserves compounding instead of averaging the percentages.
An exact flow-adjusted calculation needs a valuation at every external flow boundary. The GIPS Standards Handbook explains valuation and geometric linking for time-weighted returns. This small educational ledger uses those arithmetic ideas; it does not assess or certify GIPS compliance.
Here the first denominator is the initial capital. Every later denominator is the previous pre-contribution value plus that contribution. In the example, the second denominator is 200 + 120 = 320, not 200 and not the total 220 USD contributed since inception. Each known value and each denominator must be positive in this calculator.
A total return and an annualized return are different labels. With n equal periods and m periods per year, the annualized TWR equivalent is (1 + total TWR)^(m / n) − 1. For monthly data, m = 12; quarterly data use 4; annual data use 1. Annualizing a short sample is a mathematical comparison, not an observed full-year return or a forecast.
Calculate MWR as an IRR for equal periods
Use the investor’s perspective for signs: putting money into the account is negative, receiving its terminal value is positive. With initial capital I, contributions Cᵢ after intermediate periods and final value V after n periods, solve −I − Σ[Cᵢ / (1 + r)ⁱ] + V / (1 + r)ⁿ = 0. The result r is the return per selected period, not automatically per year. The final valuation is treated as a hypothetical terminal inflow for this equation; the money does not actually have to be withdrawn.
With positive initial and final values and nonnegative intermediate contributions, there is one solution with r greater than −100%. Written as I(1 + r)ⁿ + Σ[Cᵢ(1 + r)^(n − i)] = V, the left side increases strictly as the positive growth factor increases. That is why the calculator deliberately restricts the cash-flow pattern.
For m equal periods per year, annualized MWR = (1 + r)^m − 1. A monthly IRR of 1% corresponds to about 12.6825% annualized, not 12%. For a matching n-period comparison, (1 + r)ⁿ − 1 is a compounded equivalent rate; it is not monetary P/L divided by total deposits.
Withdrawals followed by later deposits can change the cash-flow signs more than once. Such records may have multiple IRRs or no admissible IRR. A spreadsheet returning one number does not establish uniqueness. This deposits-only calculator rejects withdrawals rather than selecting an arbitrary root.
A missing valuation is not a zero
Remove the 200 USD valuation at the end of year one while retaining the deposit of 120 USD and the final value of 160 USD. MWR still uses exactly the cash flows −100, −120, +160 and remains −20% per year. The missing valuation is not part of its equation.
TWR is no longer determined by those cash flows. If the missing valuation had been 100 USD instead of 200 USD, the post-deposit value would have been 220 USD. TWR would be (100 / 100) × (160 / 220) − 1 = −27.272727…% over two years. Both records have the same deposits and final value. They have different TWRs.
Retrieve a valuation from the same accounting basis immediately before the flow, or leave TWR unavailable. Do not enter zero, interpolate a smooth account path or infer the value from the total contributed. If no contribution occurred at a missing boundary, adjacent intervals can be combined for total TWR. The ledger does this, while leaving the individual period returns unavailable wherever their endpoints are unknown. It does not fill in the missing values.
Use the deposits-only return ledger
TWR / MWR account-return ledger
Calculate returns for 2–24 equal periods with deposits at period ends. All amounts are in USD; no currency conversion. Withdrawals and irregular dates are outside this calculator.
The initial figures are a fictional two-year example, not trading performance.
Calculated returns and reconciliation
2 equal periods; 1 periods per year; duration 2 years.
- TWR over the whole interval
- 0%
- Annual equivalent: 0%
- MWR (IRR) per input period
- -20%
- Annual equivalent: -20%
- Monetary profit / loss, USD
- -60
Final value 160 − initial value 100 − later deposits 120 = -60 USD.
Annual equivalents compound the stated period rate; they are not a forecast. With less than one year of data, they are a mathematical rescaling, not an observed annual return.
Opening value is the previous value after its deposit. A blank input remains unknown. Return for a row = value before deposit / opening value − 1.
| Period | Opening value, USD | Value before deposit, USD | Deposit after valuation, USD | Value after deposit, USD | Return for this period |
|---|---|---|---|---|---|
| 1 | 100 | 200 | 120 | 320 | 100% |
| 2 | 320 | 160 | 0 | 160 | -50% |
The table scrolls horizontally. Focus it and use the arrow keys to inspect every column.
Intervals linked for TWR
A deposit starts the next interval after its valuation. Boundaries without a deposit can be combined, even if their intermediate value is unknown. This does not invent the missing individual period returns.
| From boundary | To boundary | Opening value, USD | Value before deposit, USD | Interval return |
|---|---|---|---|---|
| 0 | 1 | 100 | 200 | 100% |
| 1 | 2 | 320 | 160 | -50% |
Displayed returns are rounded for reading. Calculations and CSV exports use the unrounded model values. CSV rates are decimal fractions, not percentages.
This component keeps your entries in page memory. It does not send them to a server or write them to persistent browser storage. This statement does not cover sitewide analytics.
Choose annual, quarterly or monthly equal periods, enter the initial capital, then enter 2–24 period-end rows. Amounts are in USD without currency conversion. All known account values must be positive; deposits can be zero. Each amount accepts up to two decimal places and at most 1,000,000,000 USD. Zero account value, a withdrawal or an irregular date sequence is outside this version’s model.
- Enter each account value before the contribution made at that boundary. Enter that contribution in the same row. The last row is the final valuation and must have a zero contribution.
- Leave an unknown intermediate value blank. Keep the contribution even when the valuation is unknown. A blank contribution is not a confirmed zero.
- Use the presets to reproduce the worked example, remove contributions or examine the missing-valuation case. Editing an input hides previous calculated results and their CSV until you apply the new inputs.
- For CSV input use the columns period;value_before;contribution, sequential periods 1 to n, and no dates or thousands separators. Decimal points or decimal commas are accepted; semicolons separate columns.
The results reconcile total deposits, final value and monetary P/L, then show MWR and the TWR chain when available. Per-period, whole-sample and annualized labels remain separate. A numerical limit produces an explanation instead of an infinite percentage or a fabricated zero. Keep the exported assumptions together with the figures.
The component keeps entries in memory; it does not submit those entries to a server or store them persistently. That statement concerns this form, not the site’s separate analytics. The reference result and static input/protocol downloads remain readable without JavaScript; interactive recalculation requires JavaScript.
Reconcile the result in a spreadsheet
For the two-year example, place the following values in a single column. Keep every period, including a zero when there is no contribution. The Microsoft IRR documentation specifies regular intervals and notes that blank cells are ignored; deleting a zero period or leaving it blank can change the timing represented by the range.
Cell | Investor cash flow, USD |
|---|---|
A1 | −100 |
A2 | −120 |
A3 | 160 |
Scroll sideways to compare all columns ↔
- Evaluate =IRR(A1:A3). With the displayed yearly intervals, the expected result is −20% per year. Format the result as a percentage; do not type −20 where the formula expects −0.20.
- For a separate TWR check, enter the two growth factors 200/100 and 160/(200+120). Their product minus one is 0%. Do not apply IRR to account values 100, 200 and 160 as if they were investor cash flows.
- Verify monetary P/L independently: =160-100-120 gives −60 USD. Check that the contribution has been counted once and that the final value has not been entered as another deposit.
For genuinely irregular dates, use a dated cash-flow method rather than relabeling rows as months. Microsoft XIRR discounts using actual dates on a 365-day year. Its rate is annualized, and its date convention is not identical to an equal-month IRR. Localized spreadsheet function names and argument separators may differ; match the function’s documented meaning, not just the English spelling.
Make the data comparable before comparing the percentages
Fees, commissions and financing charges are not the owner’s deposits. If the account valuations already include those costs, deducting them again would double count them. If you want a different cost basis, reconstruct a consistent complete series and label it. Do not mix a gross opening valuation with a net closing valuation while describing the result as one uniform basis.
Transfers between accounts are external flows for either account considered separately, but may be internal to a combined portfolio. Define the perimeter before recording them. Converting different valuation dates at one convenient exchange rate would introduce another assumption; this USD-only component performs no conversion.
The output prepares cash-flow-adjusted return data. It does not calculate Calmar, maximum drawdown, volatility or the quality of a trading strategy. The equity-curve simulator answers a different question about hypothetical sequences of trades. A positive TWR alongside a negative money result explains capital timing; it is not an instruction about when to deposit.
Before saving a comparison, retain the period frequency, number of periods, currency, flow timing, valuation basis and any missing observations. Compare like periods and like cost treatments. Two matching percentages cannot confirm that two source histories are equally complete or that either history will repeat.
Questions that change the calculation
Which return is correct if TWR and MWR disagree?
They answer different questions. First reconcile the money ledger, then compare period labels and conventions. In the worked example both calculations are correct: total two-year TWR is 0%, annual MWR is −20%, and monetary P/L is −60 USD.
Can I calculate TWR from deposits and the final balance alone?
Generally not when there are intermediate flows. The 100 USD versus 200 USD missing-valuation example proves that the same flows and ending value can produce different TWRs. Recover the valuation; do not estimate it invisibly.
Why must zero-flow periods remain in the IRR range?
IRR places successive cash flows at successive equal intervals. Removing a zero entry moves later flows earlier. A blank spreadsheet cell may be ignored, so enter an explicit zero when the absence of a flow is known.
Does an account with no later deposits have equal TWR and MWR?
With complete positive valuations, total TWR equals final value divided by initial capital minus one. MWR compounded across the same number of periods gives that same total rate. Compare that total with a total, or compare both annualized equivalents.
Why are zero final value and withdrawals rejected?
They fall outside the bounded model used to guarantee a positive growth factor and a unique regular-period IRR. A zero final value can represent complete loss; it must not be confused with an unknown value or forced into this solver. More general cash-flow records need a separately checked method.
Is annualized return a forecast or a performance certification?
No. Annualization expresses a historical sample at an equivalent annual compounding rate. It does not create observations for the rest of the year, predict future returns or certify GIPS compliance.