How TWJCalc Simplifies Time-Weighted Returns for Investors

TWJCalc Guide: Step-by-Step Portfolio Performance Analysis

What TWJCalc is

TWJCalc is a tool for computing time-weighted returns (TWR) and related portfolio performance metrics, designed to remove the distortion caused by external cash flows so you can evaluate manager skill or strategy performance accurately.

Key features

• Time-Weighted Return (TWR): Calculates sub-period returns between cash flows and chains them to produce the portfolio TWR.
• Cash-flow handling: Detects and correctly accounts for deposits and withdrawals, including intraday flows if provided.
• Compounding options: Supports geometric chaining (standard TWR) and arithmetic returns for reporting flexibility.
• Reporting outputs: Period returns (daily/weekly/monthly), cumulative return, annualized return, and drawdown statistics.
• Data import/export: Accepts trade and cash-flow CSVs and exports reports to CSV or PDF.

Step-by-step workflow

1. Prepare data: Create a CSV with date-stamped portfolio values and separate CSV for cash flows (date, amount, type).
2. Import files: Load portfolio value series and cash-flow file into TWJCalc.
3. Set assumptions: Choose valuation frequency (e.g., daily), compounding method, and treatment of intraday flows.
4. Run calculation: TWJCalc segments periods at each cash flow, computes sub-period returns, and chains them to get TWR.
5. Review outputs: Examine period returns, cumulative/annualized returns, and drawdown table.
6. Export report: Save results as PDF or CSV for compliance or client reporting.

Common applications

• Performance attribution and manager evaluation
• Compliance reporting requiring TWR (e.g., GIPS-like disclosures)
• Comparing strategies where client cash flows vary

Accuracy tips

• Use end-of-day valuations when possible.
• Record cash flows with timestamps if intraday flows occur.
• Reconcile input data to custodian statements before running calculations.

Limitations

• TWR isolates manager performance but ignores the investor’s actual dollar experience (use money-weighted return for that).
• Accuracy depends on valuation quality and correct cash-flow timing.

Quick example

• Portfolio value ⁄₁: \(100,000</li> <li>Deposit 3/1: \)10,000
• Portfolio value ⁄₃₁: $115,000
  Compute return for 1/1–3/1, then 3/1–3/31, chain sub-period returns to get the TWR for Jan–Mar.