Money-weighted vs time-weighted rate of return
KnownMemorizeMoney-weighted vs time-weighted rate of return
| Money-weighted | Time-weighted | |
|---|---|---|
| What it is | internal rate of return of the net flows | sub-period returns chained |
| Size and timing of flows matter? | Yes | No |
| Use to judge | the investor's own result; a manager who controls the flows (private equity) | a manager who does not control the flows |
| Global Investment Performance Standards | allowed only if the manager controls flows AND the fund is closed-end, fixed-life, committed-capital or illiquid | required otherwise |
| Sub-annual | annualize: | chain all sub-periods in the year |
Memory hook Money-weighted = my timing. Time-weighted = the manager.
Know it cold Money added before a strong period → money-weighted above time-weighted. Before a weak period → below. No flows → equal.
Key terms
- money-weighted rate of return Memorize
- dollar-weighted rate of return Know the idea
- time-weighted rate of return Memorize
- internal rate of return Use it
- external cash flows Use it
- Global Investment Performance Standards (GIPS) Use it
- daily valuation Know the idea
- No Memorize time-weighted rate of return
- Yes Memorize and the fund has one of four features
- Closed-end money-weighted allowed
- Fixed life money-weighted allowed
- Committed capital called on demand money-weighted allowed
- Significant illiquid holdings money-weighted allowed
-
Formulas
Quick example
Flows of −80 at t = 0, −100 at t = 1 and +216 at t = 2. The internal rate of return of those flows, and so the money-weighted rate of return, is 13.30% a year.
- CF2NDCLR WORK open the cash flow worksheet and clear it
- 80+|-ENTER↓ CF0 = −80
- 100+|-ENTER↓ C01 = −100, and F01 stays at 1
- ↓216ENTER C02 = 216
- IRRCPT 13.30
CF cash flow worksheet · 2ND second function (the shifted label above a key) · CLR WORK clear the worksheet · +|- change sign · ENTER enter (on the HP, puts the number on the stack) · IRR internal rate of return · CPT compute
- fCLEAR REG clear the cash flow registers
- 80CHSgCF0 the first flow
- 100CHSgCFj t = 1
- 216gCFj t = 2
- fIRR 13.30
f gold shift key · CLEAR REG clear all registers · CHS change sign · g blue shift key · CF0 cash flow at time zero · CFj cash flow j · IRR internal rate of return
Quick example
Quarterly returns of 5%, −5%, 5% and 4% between cash flows. 1.05 × 0.95 × 1.05 × 1.04 − 1 = 8.93% for the year.
- 1.05×0.95×1.05×1.04−1= 0.0893
- 1.05ENTER0.95×1.05×1.04×1− 0.0893
ENTER enter (on the HP, puts the number on the stack)
Quick example
Year 1: 80 to 100 (+25%). Year 2: 100 to 108 (+8%). (1.25 × 1.08)^(1/2) − 1 = 16.19% a year.
- 1.25×1.08= year 1 × year 2 growth, 1.35
- √x−1= two years, so the square root: 0.1619
√x square root
- 1.25ENTER1.08× 1.35
- g√x1− 0.1619
ENTER enter (on the HP, puts the number on the stack) · g blue shift key · √x square root
Quick example
A quarterly internal rate of return of 2.0371% annualizes to 1.020371⁴ − 1 = 8.40%, not 4 × 2.0371% = 8.15%.
- 1.020371y^x4−1= 0.0840
y^x power
- 1.020371ENTER4y^x1− 0.0840
ENTER enter (on the HP, puts the number on the stack) · y^x power