How it works
Compute each subperiod return as end/start −1 and geometrically link the factors. Values must bracket external cash flows so no flow occurs within a subperiod.
Input definitions
- CSV: period,start value after external flow,end value before next flow
- Plain text; maximum 200,000 characters.
A worked example
- CSV: period,start value after external flow,end value before next flow
- period,start,end 1,1000,1100 2,1600,1520
Assumptions & limits
Single-currency illustration using your entered amounts and rates, not a recommendation, approval or forecast. No automatic tax rules or market data. Not annualized or a GIPS compliance claim.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Why must I split the period at deposits and withdrawals?
A subperiod price return cannot separate an external flow from investment performance. Use start values after each flow and end values before the next flow.
How does Time-weighted investment return work?
Compute each subperiod return as end/start −1 and geometrically link the factors. Values must bracket external cash flows so no flow occurs within a subperiod.
What are the limits of Time-weighted investment return?
Single-currency illustration using your entered amounts and rates, not a recommendation, approval or forecast. No automatic tax rules or market data. Not annualized or a GIPS compliance claim.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.