Quick Cross Border Value Bridge

Quickly measure the market vs. manager IRR, with a handful of market multiple, addressable market, and FX data points.

The first cross border value bridge case study used the Derivative Model to measure how various market forces drive returns, and then combined them to estimate a Market vs. Manager-driven Return. The Logarithmic Model can usually provide comparable measurements more easily, with much less data.

 

 

Consider an institutional Limited Partner based in the US. They invest in a private equity Fund manager based in Europe. The Fund makes a portfolio investment that is based in Spain.

The GP’s Fund Equity Value (FEqV) of EUR can be converted to the LP’s Home Equity Value (HEqV) of USD using foreign exchange rates available on many finance websites, such as Yahoo! Finance. An investment banking publication suggests that prevailing market valuation multiples contracted from 8.40x at entry to 8.00x at exit. Further, economic data suggests that the company’s addressable market increases by 14.5% over the hold.

 

Using the Logarithmic Model, this is all that is need to calculate a Market vs. Manager-driven Return. While results will be nearly identical to what is calculated by the Derivative Model, this approach requires 70% less data.

Market vs. Manager-driven Multiple of Invested Capital

In the Derivative Model, the fundamental unit of value creation is a currency, where value drivers are combined with addition. In the Logarithmic Model, the fundamental unit of value creation is the equity return multiplier, where value drivers are combined with multiplication. Thus, the market-driven return is the product of applicable market drivers which, in this example, include foreign exchange rates, market multiples, and addressable market changes.

    \[ \chi_{MARKET} = \chi_{FX} \cdot \chi_{MME} \cdot \chi_{AMG} \]

    \[ = \frac{FX_2}{FX_1} \cdot \frac{MM_2}{MM_1} \cdot \left( 1+\beta \right) = \frac{0.9986}{1.1524} \cdot \frac{8.00x}{8.40x} \cdot \left( 1+ 14.5 \% \right) \]

    \[ = 0.867x \cdot 0.952x \cdot 1.145x = 0.945x \]

In the Logarithmic Model, the total return in the LP’s base currency of USD can be expressed as the product of this Market-driven Return and a Manager-driven Return, where:

    \[ \frac{HEqV_2}{HEqV_1} = \chi_{MARKET} \cdot \chi_{MANAGER} \]

Rearranging this formula provides a Manager-driven return multiple that is fully adjusted for broader-market forces, where:

    \[ \chi_{MANAGER} = \frac{HEqV_2 / HEqV_1}{\chi_{MARKET}} = \frac{HEqV_2 / HEqV_1}{\chi_{FX} \cdot \chi_{MME} \cdot \chi_{AMG}} \]

    \[ = \frac{2.455x}{0.867x \cdot 0.952x \cdot 1.145x} = \frac{2.455x}{0.945x} = 2.599x \]

The Logarithmic Model results in this case study are virtually identical to the Derivative Model results in the prior case study.

 

Module 07 demonstrates how these equity return multipliers can be converted back and forth among the various measurements of value creation.

 

Market vs. Manager-driven IRR

A Manager-driven IRR measurement is much like a Public Market Equivalence (PME) measurement. It is a time-dependent, relative return measurement that deducts the impact of broader market forces from the GP’s return.

Unlike PME, the Manager-driven IRR does not require time series cash flow data, and it is not distorted by a private equity deal having leverage levels different from companies in an index. Further, the market deductions in a Manager-driven IRR measurement are far more flexible, and can be highly customized, as in the current example.

Value creation IRR measurements require a deal’s effective holding period (Δt’), which is determined from a deal’s Gross MOIC and Gross IRR in the Fund’s base currency (EUR). In this case, the effective hold is 3.731 years, where:

    \[ \Delta t' = \frac{\ln{\left( FEqV_2 / FEqV_1 \right) }}{ \ln{\left( 1 + Gross\,IRR \right) } } = \frac{\ln{\left( 2.833x \right)}}{\ln{\left( 1+32.20 \% \right)}} = 3.731 \, years \]

Value Creation IRR is equal to the equity return multipliers raised to the power of the reciprocal of this effective hold, minus 1.

    \[ IRR_{HOME} = \left( \frac{HEqV_2}{HEqV_1} \right)^{1/\Delta t'}-1 = \left( 2.455x \right)^{1/3.731} -1 = +27.2 \% \]

    \[ IRR_{MARKET} = \left( \chi_{MARKET} \right)^{1/\Delta t'}-1 = \left( 0.945x \right)^{1/3.731} -1 = -1.5 \% \]

    \[ IRR_{MANAGER} = \left( \chi_{MANAGER} \right)^{1/\Delta t'}-1 = \left( 2.599x \right)^{1/3.731} -1 = +29.2 \% \]

The Logarithmic Model results in this case study are virtually identical to the Derivative Model results in the prior case study.

 

Relative (%) Market vs. Manager-driven Value Creation

Relative (%) value creation represents each value driver’s relative share of total value creation in the LP’s home currency of USD. It is equal to the natural logarithm of the equity return multiplier, divided by the natural logarithm of the multiple of invested capital in the home currency.

    \[ \upsilon_{HOME} = \frac{\ln{\left( HEqV_2 / HEqV_1 \right)}}{\ln{\left( HEqV_2 / HEqV_1 \right)}} = \frac{\ln{ \left( 2.455x \right) }}{\ln{ \left( 2.455x \right) }} = 100.0 \% \]

    \[ \upsilon_{MARKET} = \frac{\ln{\left( \chi_{MARKET} \right)}}{\ln{\left( HEqV_2 / HEqV_1 \right)}} = \frac{\ln{ \left( 0.945x \right) }}{\ln{ \left( 2.455x \right) }} = -6.3 \% \]

    \[ \upsilon_{MANAGER} = \frac{\ln{\left( \chi_{MANAGER} \right)}}{\ln{\left( HEqV_2 / HEqV_1 \right)}} = \frac{\ln{\left( 2.599x \right)}}{\ln{ \left( 2.455x \right) }} = +106.3 \% \]

The Logarithmic Model results in this case study are virtually identical to the Derivative Model results in the prior case study.

 

Absolute ($) Market vs. Manager-driven Value Creation

Absolute ($) value creation represents each value driver’s total value creation in the LP’s home currency of USD. It is equal to the product of the total change of capital in the home currency and relative (%) value creation.

    \[ V_{HOME} = \Delta HEqV \cdot \upsilon_{HOME} = \$80.5 \cdot 100.0 \% = +\$ 80.5 \]

    \[ V_{MARKET} = \Delta HEqV \cdot \upsilon_{MARKET} = \$80.5 \cdot \left(-6.3 \% \right) = -\$ 5.1 \]

    \[ V_{MANAGER} = \Delta HEqV \cdot \upsilon_{MANAGER} = \$80.5 \cdot 106.3 \% = +\$ 85.6 \]

The Logarithmic Model results in this case study are virtually identical to the Derivative Model results in the prior case study.

 

Resources

ValueBridge.net Modules

Additional Resources

See the PME versus Value Creation, Market Valuation Multiples, and Addressable Market and Market Share videos and related content at AUXILIA Mathematica.

Please log in access additional content. Not a subscriber? Sign-up today!.

Tags: , ,