1.2.2 PRIVATEMETRICS.INFRA_EQUITY_COMPARABLE

INFRA_EQUITY_COMPARABLE (METRIC, CURRENCY, AGEINMONTHS, ENDDATE, WINDOWINYEARS, INDUSTRIALACTIVITIES, BUSINESSRISK, CORPORATESTRUCTURE, COUNTRIES, SIZE, LEVERAGE, PROFITABILITY, INVESTMENT, TIMETOMATURITY, TYPE)

Perform a comparable computation for private infra equity. This involves finding datapoints which have similar TICCS classifications and factor values (the comparables dataset) and averaging the metric values

Parameters

METRIC: Text

The Metric for which the comparable has to be evaluated. (“ev2ebitda”, “irr”, “p2b”, “p2sales”, “premia”, “revenue_growth”, “wacc”)

CURRENCY: Text

The currency of monetary factor inputs such as SIZE ('USD', ‘EUR’, ‘GBP’)

AGEINMONTHS: Number

The age of the company in months. The comparable computation will keep companies within 6 months of this value. If set, ENDDATE and WINDOWINYEARS will be ignored

ENDDATE: Date

The max date of the comparable dataset

WINDOWINYEARS: Number

The window in years of the comparable dataset. In other words, the min date of the comparable dataset = ENDDATE - WINDOWINYEARS

INDUSTRIALACTIVITIES: Range(Text), Text

Comma-separated or cell range selection of industrial activity TICCS code. See here for definitions. (“IC10”, “IC20”, “IC30”, “IC40”, “IC50”, “IC60”, “IC70”, “I80”, “IC6010”, etc.. Different industrial activity levels can be combined.)

BUSINESSRISK: Text

Business risk TICCS code. See here for definitions. (“BR1”, “BR2”, “BR3”)

CORPORATESTRUCTURE: Text

Corporate structure TICCS code. See here for definitions. (“CS1”, “CS2”)

COUNTRIES: Range(Text), Text

Range of countries as three-letter ISO code. The possible values can be obtained by calling PRIVATEMETRICS.COUNTRIES()

SIZE: Number/ Text

Total assets. Absolute value (in CURRENCY) or quintile (“Q1”, “Q2”, “Q3”, “Q4”, “Q5”)

LEVERAGE: Number (Percentage)/ Text

Total senior liabilities over total assets. Percentage value or quintile (“Q1”, “Q2”, “Q3”, “Q4”, “Q5”)

PROFITABILITY: Number (Percentage)/ Text

Return on assets. Percentage value or quintile (“Q1”, “Q2”, “Q3”, “Q4”, “Q5”)

INVESTMENT: Number (Percentage)/ Text

CAPEX over total assets. Percentage value or quintile (“Q1”, “Q2”, “Q3”, “Q4”, “Q5”)

TIMETOMATURITY: Number/ Text

Years until maturity. Years or bucket (“T1”, “T2”, “T3”, “T4”, “T5”). The buckets cover the following ranges:

T1: 0-5 years, T2: 5-10 years, T3: 10-15 years, T4: 15-20 years, T5: 20+ years

TYPE: Text

To determine how to aggregate the comparables dataset. Default is “mean”. (“mean”, “median”, “datumCount”, “companyCount”,  “p25”, “p75”, “min” and “max”)
p25 and p75 are the 25th and 75th percentile respectively

Returns

number

Examples

=PRIVATEMETRICS.INFRA_EQUITY_COMPARABLE("irr", "USD", , DATE(2022,12,31), 2, "IC60","","","","","","","","","mean")

Returns

9.3%

This can also be called by referencing values from the spreadsheet