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