A bi-weekly challenge from Andre Mirabelli & Opturo

How does an attribution modeler address the following challenge?
If a Fund achieves 50% one year and 0% the next, and its Benchmark achieves 0% the first year and -50% the next, then the active return each year is 50%. Is the annualized active return 50%? Or is the annualized active return the annualized Fund return minus the annualized Benchmark return:{[(1+ 0.5)(1+ 0)]^(1/2) – 1} – {[(1+ 0)(1- 0.5)]^(1/2) – 1} = 51.7%?.

A bi-weekly challenge from Andre Mirabelli & Opturo

Related news

A bi-weekly challenge from Andre Mirabelli & Opturo

If you use “Purchases in the Basis Dietz”, how do you approach the following scenario?The cash in a portfolio starts the day with a small gain and then the portfolio uses all of the starting cash and half of that small cash gain (“sells cash”) to purchase a non-cash instrument. Thus, nothing ever goes short.…

Opturo’s Proprietary IRR Engine Excel Examples

Download the Excel spreadsheet that illustrates the issues with Excel's XIRR.
Read more

Opturo Launches Enterprise Data Governance Platform

Opturo launches Enterprise Data Governance, a Bolt-On platform to define policies and rules in real-time across the entire enterprise to securely access and protect sensitive data
Read more