Skip to main content
Skip table of contents

2.2.2 INFRA_EQUITY_COMPARABLE

Description: Returns the composite mean and median value of the requested metric based on the TICCS and FACTORS profile, along with the corresponding datum count and company count.

Method: POST

Path: /compute-service/v2/pi-comparables/average/by/profiles

Parameters

  • metric: (string, required)
    The metric for which the comparable has to be evaluated. Possible values include: "ev2ebitda", "irr", "p2b", "p2sales", "premia", "wacc", "revenue_growth".

  • currency: (string, optional)
    The currency of monetary factor inputs such as size. Possible values include: 'USD', 'EUR', 'GBP'.

  • age: (int, optional)
    The age of the company in months. The comparable computation will keep companies within 6 months of this value. If age is set, endDate and windowInYears will be ignored.

  • startDate: (string, date format, required)
    The starting date for the comparable dataset.

  • endDate: (string, date format, required)
    The maximum date of the comparable dataset.

  • windowInYears: (int, optional)
    The window in years of the comparable dataset. The minimum date of the dataset is calculated as endDate - windowInYears.

  • ticcsProfiles: (array of objects, optional)
    Specifies profiles based on TICCS codes.

    • industrialActivities: (array of strings, optional)
      List of industrial activity TICCS codes. Possible values include: "IC10", "IC20", "IC30", etc.

    • businessModel: (string, optional)
      Business risk TICCS code. Possible values include: "BR1", "BR2", "BR3".

    • corporateStructure: (string, optional)
      Corporate structure TICCS code. Possible values include: "CS1", "CS2".

  • factorsProfiles: (array of objects, optional)
    Specifies profiles based on various financial factors.

    • factor: (string, required)
      Name of the factor. Possible values include: "countries", "size", "leverage", "profitability", "investment", "timeToMaturity".

    • countries: (array of strings, optional)
      List of country ISO codes, applicable if the factor is "countries". Values can be obtained by calling countries.

    • quintile: (int, optional)
      Quintile for factors like size, leverage, profitability, or investment. Acceptable values are: 1, 2, 3, 4, 5

    • currency: (int, optional)
      ISO currency code, applicable if the factor is "size".

    • timeToMaturityBucket: (string, optional)
      Bucket for years until maturity, applicable if the factor is "timeToMaturity". Possible values representation in years:

      • "T1": 0-5

      • "T2": 5-10

      • "T3": 10-15

      • "T4": 15-20

      • "T5": 20+

  • type: (string, optional)
    Specifies how to aggregate the comparables dataset. Default is "mean".

    • Other options include: "mean", "median", "obs_count", "company_count", "p25", "p75", "min", "max".
      Note: p25 and p75 represent the 25th and 75th percentiles, respectively.

Request Body

CODE
{
    "metric": "ev2ebitda",
    "startDate": "2022-07-31",
    "endDate": "2024-07-31",
    "age": null,
    "ticcsProfiles": [
        {
            "profile": {
                "industrialActivities": [
                    "IC10"
                ]
            }
        },
        {
            "profile": {
                "businessModel": "1"
            }
        },
        {
            "profile": {
                "corporateStructure": "1"
            }
        }
    ],
    "factorsProfiles": [
        {
            "profile": {
                "factor": "countries",
                "countries": [
                    "36",
                    "554"
                ]
            }
        },
        {
            "profile": {
                "factor": "size",
                "quintile": 1,
                "currency": 840
            }
        },
        {
            "profile": {
                "factor": "leverage",
                "quintile": 1
            }
        },
        {
            "profile": {
                "factor": "profitability",
                "quintile": 1
            }
        },
        {
            "profile": {
                "factor": "investment",
                "quintile": 1
            }
        },
        {
            "profile": {
                "factor": "timeToMaturity",
                "timeToMaturityBucket": "5-10"
            }
        }
    ]
}

 

Response

CODE
{
    "data": {
        "results": {
            "mean": 14.98952036684318,
            "q1": 5.938549664124269,
            "median": 10.619352274120464,
            "q3": 16.859396636913413,
            "datumCount": 4641,
            "companyCount": 237,
            "min": 2.315806555748836,
            "max": 91.26980837453112
        }
    }
}

JavaScript errors detected

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

If this problem persists, please contact our support.