Time-Weighted Return Calculator
Free time-weighted return calculator: isolate pure investment performance from deposit timing across multiple sub-periods with geometric linking.
Like this tool? Help keep portfolios.tools free forever.
How It Works
Time Weighted Return eliminates distorting effects of external cash flows like deposits and withdrawals. When you add money before a rally, simple return overstates skill. When you add before a drawdown, simple return understates it. TWR breaks the measurement period into sub periods at each cash flow event and computes holding period return for each slice independently. Fund managers report TWR to GIPS standards because it isolates investment skill from client cash flow timing. Enter each sub period between deposits or withdrawals with start value, end value, and cash flow amount. Dividends reinvested inside the portfolio are usually already reflected in end values. Match sub period boundaries to statement dates for clean reconciliation. Add one row per month if you dollar cost average so each contribution becomes its own sub period boundary rather than lumping flows into quarterly buckets.
The calculator computes holding period return for each sub period, then geometrically links them by multiplying one plus HPR for each slice and subtracting one. Annualized TWR scales the cumulative result across total years in the data. Comparison to simple return shows how much deposit and withdrawal timing affected raw numbers. Positive delta means deposits preceded gains. Negative delta means you added money before losses. Use this when evaluating lump sum versus staggered entry strategies or when comparing your timing luck to fund published returns on prospectuses. Cumulative TWR column helps audit each sub period contribution to total performance when one quarter looks anomalous. Total invested label sums deposits for reference but does not enter the TWR formula directly because TWR weights each sub period equally regardless of flow size once HPR is computed.
Use the calculator to evaluate lump sum versus staggered entry strategies or to compare your timing luck against fund published returns on prospectuses. Cumulative TWR column helps audit each sub period contribution to total performance when one quarter looks anomalous. Total invested label sums deposits for reference but does not enter the TWR formula directly because TWR weights each sub period equally regardless of flow size once HPR is computed.
Use Time-Weighted Return Calculator whenever inputs change: after market moves, new contributions, or revised personal assumptions. Bookmark the page for quick reruns without installing software.
Step by step
- Open Time-Weighted Return Calculator and enter your current inputs.
- Review calculated outputs and summary tables.
- Adjust assumptions and compare scenarios side by side.
Worked example
Time Weighted Return eliminates distorting effects of external cash flows like deposits and withdrawals. Enter the sample inputs described in How it works to reproduce the scenario step by step.
Adjust one input at a time to see sensitivity. Time-Weighted Return Calculator updates instantly so you can stress test optimistic and conservative assumptions before acting.
When to use this calculator
Reach for Time-Weighted Return Calculator when calculate time-weighted return across multiple cash flow periods: isolate pure investment performance from deposit timing.. It suits quick what if analysis before trades, allocation changes, or plan updates.
Pair with related tools when the decision spans taxes, liquidity, or multi year projections beyond what one formula captures.
Common mistakes
Copying outputs without checking input units or stale market prices is a frequent error with Time-Weighted Return Calculator. Confirm tickers, percentages, and dates before acting.
Running a single baseline scenario ignores tail risks. Stress test with conservative inputs and compare against related tools listed below when the decision is material.
The Formula
HPR_i = (EndValue_i - StartValue_i - CashFlow_i) / (StartValue_i + CashFlow_i)
TWR = Π(1 + HPR_i) - 1
Annualized_TWR = (1 + TWR)^(1 / TotalYears) - 1
Simple_Return = (FinalValue - TotalInvested) / TotalInvested
Delta = TWR - Simple_Return
Geometric linking compounds sub period returns independently. Cash flows excluded from return numerator to isolate pure performance. Sub periods should be contiguous with no gaps. Align dates with account statements for audit accuracy. Annualized TWR requires total years greater than zero. Empty sub period list shows empty state until data entered.
Limitations and assumptions
Geometric linking compounds sub period returns independently. Cash flows excluded from return numerator to isolate pure performance. Sub periods should be contiguous with no gaps. Align dates with account statements for audit accuracy. Annualized TWR requires total years greater than zero. Empty sub period list shows empty state until data entered. Time-Weighted Return Calculator does not replace personalized advice. Fees, slippage, account specific rules, and behavioral constraints may change real world outcomes.
Key terms
- What is Time-Weighted Return
- TWR measures portfolio compound growth rate while eliminating effect of external cash flows.
- Why does TWR differ from simple return
- Simple return divides total gain by total invested without weighting when money arrived.
- Model assumption
- Each sub period runs from one cash flow event to the next.
Compare alternatives
Pair with Money Weighted Return for personal IRR, Sharpe Sortino Ratio for risk adjusted performance, and Maximum Drawdown for tail risk context on portfolios. Use those calculators when time-weighted return calculator alone does not capture the full decision.
Internal links on portfolios.tools help you chain calculators: run Time-Weighted Return Calculator first, then validate edge cases with a specialized tool from the related section below.
FAQ
What is Time-Weighted Return?
TWR measures portfolio compound growth rate while eliminating effect of external cash flows. It is the standard for evaluating investment manager performance because it isolates skill from contribution timing. Mutual fund prospectuses use TWR so investors who joined mid year see comparable figures regardless of their personal deposit dates. TWR answers how the underlying investments performed. Money Weighted Return answers what you personally earned given when you added money. Pension consultants and institutional allocators mandate TWR when comparing manager track records across different client flow patterns. Retail investors use TWR to judge whether to stay with an advisor or fund after stripping out luck from deposit timing.
Why does TWR differ from simple return?
Simple return divides total gain by total invested without weighting when money arrived. Large deposit right before a gain inflates simple return. TWR removes timing bias by computing returns for each sub period between cash flows independently, then linking geometrically. Dollar weighted return reflects personal experience. TWR reflects manager or strategy performance. Wide divergence between them signals contribution timing materially affected personal outcomes versus market path. Document delta when explaining performance to a spouse or advisor who only sees account balance change. Large positive delta sometimes reflects lucky lump sum timing rather than skill.
How is TWR calculated?
Each sub period runs from one cash flow event to the next. Holding period return equals end value minus start value minus cash flow, divided by start value plus cash flow. Cash flow sign convention: positive means deposit inflow, negative means withdrawal outflow. Geometric linking multiplies one plus each sub period HPR and subtracts one for cumulative TWR. Example: start ten thousand, deposit five thousand mid period, end sixteen thousand. HPR isolates return on capital actually invested during that slice. Verify cash flow timing at period end versus beginning if your custodian uses different convention. Annualized TWR raises one plus cumulative TWR to one over total years minus one when horizon exceeds one year.
Can I use negative cash flows for withdrawals?
Yes. Use negative values for withdrawals including living expense draws. Positive cash flow means money deposited. TWR adjusts for both so neither distorts pure investment performance. Withdrawals for retirement spending should appear as negative flows at the withdrawal date. Align sub period dates with brokerage statement periods for audit accuracy when reconciling to official reports. Internal transfers between your own accounts should net to zero across combined TWR if measured on household level. RMD withdrawals from IRAs should appear as negative flows on the withdrawal date in retirement tracking.
When would TWR equal simple return?
TWR and simple return are identical when no intermediate cash flows occur between start and end. Any deposit or withdrawal creates potential divergence. The magnitude depends on flow size relative to portfolio value and whether flows preceded gains or losses. Zero delta in this calculator confirms no timing effect or perfectly offsetting flows across sub periods. Dollar cost averaging programs often show modest negative delta when steady deposits buy through volatile markets. Lump sum investors who deploy before bull markets may show large positive delta versus TWR on the same underlying holdings.
How do I use this time-weighted return calculator on phone or tablet?
Yes. Time-Weighted Return Calculator runs entirely in your mobile browser with the same formulas as desktop. Optional localStorage may remember inputs on your device when enabled in browser settings.
Where is my data stored when I use Time-Weighted Return Calculator?
Nowhere on our servers. Calculations execute locally in your browser. Optional localStorage saves form fields on your device only and never transmits portfolio numbers over the network.
Should I rely on Time-Weighted Return Calculator for tax or legal decisions?
No. Time-Weighted Return Calculator provides educational math only. Tax law, account rules, and personal circumstances vary. Consult a qualified tax or legal professional before transactions with material consequences.
Related Tools
Pair with Money Weighted Return for personal IRR, Sharpe Sortino Ratio for risk adjusted performance, and Maximum Drawdown for tail risk context on portfolios.tools when interpreting manager skill versus personal experience across multiple accounts and tax wrappers.