Beyond “Don’t Use” – How (Not) to Calculate Money-Weighted Returns in Excel
If cost was of no matter, then asset managers would all own (fill in the blank with your favorite accounting system). For emerging asset management firms, cost does matter. When managing a start-up commingled fund, an investment firm only needs to calculate a single return stream to comply with best practices in the GIPS® standards. It’s hard to justify a six-figure expense when Microsoft Excel is free, never mind the pitfalls.