Search the site

What are you looking for?

Enter a broker, tool or topic.

Risk & capital

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

Reviewed

Two dark teal ribbon paths on pale travertine platforms, with a small amber block added along one path and a pale blue glass divider.
Use the deposits-only return ledger

The essentials

  1. Account value is a stock of money; monetary profit excludes your contributions. Neither is automatically a percentage return.

  2. TWR links returns between external cash flows. MWR reflects the size and timing of the investor’s cash flows.

  3. The ledger supports 2–24 equal periods and deposits only. Missing intermediate valuations can leave MWR calculable while TWR remains unavailable.

  4. 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

Try it yourself

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.

Load an example, then apply

Each row: period; value BEFORE deposit; deposit AFTER valuation. Keep periods 1–24 in order, one per row. Leave an unknown intermediate value blank; enter 0 for no deposit. The final value is required and its deposit must be 0.

Use positive known values, up to 1,000,000,000 USD per amount, at most two decimal places. A decimal point or comma is accepted; do not use grouping separators. Zero account values are outside this positive-capital model. Maximum 16,000 characters.

The optional machine header is period;value_before;contribution. Its identifiers stay unchanged in every language. Initial value and period length are entered separately.

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.

Account values and external deposits
PeriodOpening value, USDValue before deposit, USDDeposit after valuation, USDValue after deposit, USDReturn for this period
1100200120320100%
23201600160-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.

Intervals linked for TWR
From boundaryTo boundaryOpening value, USDValue before deposit, USDInterval return
01100200100%
12320160-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.

Sources & further reading

Risk & capital
Calmar ratioUse an appropriate return series before relating annual growth to maximum drawdown.Trading journal templateKeep trade records distinct from account funding and valuation records.Equity-curve simulatorExplore hypothetical trade sequences rather than reconstructing cash-flow returns.
All guides