1.2.3 PRIVATEMETRICS.INFRA_DEBT_COMPARABLE

INFRA_DEBT_COMPARABLE (METRIC, CURRENCY, AGEINMONTHS, ENDDATE, WINDOWINYEARS, INDUSTRIALACTIVITIES, BUSINESSRISK, CORPORATESTRUCTURE, COUNTRIES, FACEVALUE, TIMETOMATURITY, TYPE)

Perform a comparable computation for private infra debt. 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. (“credit_spread”, “ytm”)

CURRENCY: Text

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

AGEINMONTHS: Number

The age of the company in month. 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”)

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

FACEVALUE: Number/ Text

Face value. Absolute value (in USD) 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”, “obs_count”, “company_count”, “p25”, “p75”, “min” and “max”)

Returns

number

Examples

CODE

=PRIVATEMETRICS.INFRA_DEBT_COMPARABLE("ytm","USD",,DATE(2022,12,31),2,"IC60","","","","","","mean")

returns

3.4%

This can also be called by referencing values from the spreadsheet