Excel Add-In Now supports PME Calculations

 

We continue to quickly add capabilities to the Burgiss Excel Add-In.

Given the episodic nature of cash flow and valuation activity, traditional absolute measures, such as the IRR, TWRR and multiples of various kinds, provide a sound footing to evaluate private capital investments. With this release, we include standard relative measures that helps deepen your analysis by providing comparisons to traditional investment approaches. Collectively known as public-market-equivalent measures, they are generally abbreviated PME. These include the:

  • IRR, Spread and Valuation using the Long-Nickels Index Comparison Method (ICM)

  • Kaplan-Schoar Public Market Equivalent ratio (KS PME)

  • Gredil-Griffiths-Stucke Direct Alpha method (Direct Alpha)

All of these functions work on individual or groups of investments and support point-to-point calculations. All also support an optional premium to be applied to the index, and a Roll-Forward option to proxy missing valuations.

Notably, these PME measures can use the default indexes associated with investments or, more flexibly, can use other indexes by simply passing its IndexID as part of the function for on-the-fly analysis.

Access to these functions is available to all Private i Platform clients who have licensed the Advanced Analytics module

 
james kocis