Opturo’s Proprietary IRR Engine Excel Examples
Download the Excel spreadsheet that illustrates the issues with Excel’s XIRR.
Opturo’s Proprietary IRR Engine Excel Examples
Related news
Reliably Actionable Investment Analysis Of Yourself
Opturo provides the best of breed analysis of the impact of each of the actual decisions that created investment results.
Read moreA 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…
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.…


