A bi-weekly challenge from Andre Mirabelli & Opturo

How should a performance modeler address the following? What criteria should be used to decide between different methods of iteration, including the seeding procedure, for the calculation of IRR? This is especially relevant if it turns out that different iteration procedures give significantly different resulting IRR values a non-negligible portion of the time. For example, would it be better for an iteration procedure to provide an IRR that tends to create results that come close to the modified Dietz return for a portfolio over a period, or for it to provide an IRR that tends to create results that are smaller in absolute magnitude? For instance, if the modified Dietz return for the period is 8%, is an iteration procedure that gives an IRR result of 12% better or worse that an iteration procedure that gives an IRR return of 3%? The 12% is closer, arithmetically, to 8% than is 3%, but the 3% has a smaller absolute value than does 8%. This is also true for the geometric measure of difference since the absolute value of the geometric difference between 8% and 12%, [abs(1.08/1.12)-1 = 3.6%], is smaller than the absolute value of the geometric difference between 3% and 12%, [abs(1.03/1.12)-1 = 8.0%], but the absolute value of the geometric difference between 8% and 0%, [abs(1.08/1.00)-1 = 8.0%], is larger than the absolute value of the geometric difference between 3% and 0%, [abs(1.03/1.00)-1 = 3.0%]. When the modified Dietz result is 8%, which is the better iteration procedure, one that produces 12% or one that produces 3%? And is this the correct way to decide between iteration procedures?

A bi-weekly challenge from Andre Mirabelli & Opturo

Related news

Tired of Spreadsheet Chaos?

Ever wondered how to go from a high-level data insight to the root cause—without getting lost in spreadsheets? With Drilldown / Rollup Analysis in the SAYS Platform™, it's possible. Whether you're looking at performance attribution, operational risk, or compliance metrics, this feature lets you seamlessly move between summary and granular views of your data. One…
Read more

A bi-weekly challenge from Andre Mirabelli & Opturo

What if I invested by first doing an allocation among countries and then an allocation among sectors within countries, could I evaluate my sector allocation using a single-allocation Brinson model?See the paper and Excel example in Opturo's newsroom.

Opturo Develops Verification Extract to Assist GIPS® Verifiers.

Opturo’s Verification Extract is a straightforward export of information needed to prepare for GIPS® verification. The zip file exported contains the below files which contain statistics and information at both the account level and composite level. The verification extract is run for a selected time period and a selection of composites. It can be run…
Read more