Skip to main content
Skip table of contents

1.2.2 PRIVATEMETRICS.INFRA_EQUITY_COMPARABLE

INFRA_EQUITY_COMPARABLE (METRIC, CURRENCY, 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’)

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”)

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 millions (in CURRENCY) or quintile (“Q1”, “Q2”, “Q3”, “Q4”, “Q5”)

LEVERAGE: Number/ Text

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

PROFITABILITY: Number/ Text

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

INVESTMENT: Number/ 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”)

Returns

number

Examples

CODE
=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

image-20240527-063217.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.