| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
Date and time the record was last modified |
|
companyId |
long(-2147483648,2147483647)* |
|
Unique S&P Capital IQ company identifier |
|
currencyFactor |
decimal{34,19} |
|
Factor used for currency conversion, expressed as a ratio. [Magnitude: x] |
|
currencyId |
long(-32768,32768) |
|
Code for currency |
|
currencyIso |
string(3) |
|
International Organization for Standardization (ISO) 4217 code for the currency. |
| link |
financialInstance |
FinancialInstance |
|
Unique identifier for the current financial instance of the company for which financials are available. |
|
financialInstanceId |
long(-2147483648,2147483647) |
|
Numeric identifier for the financial instance of the company for which financials are available. Retained for development and integration purposes alongside the financialInstance reference field. |
|
mcEBTExUnusualExer |
decimal{34,8} |
|
Diluted market capitalization - exercisable shares, expressed as a multiple of LTM earnings before tax (EBT) excluding unusual items. The value is based on the latest available price. [Magnitude: x] |
|
mcEBTExUnusualOut |
decimal{34,8} |
|
Diluted market capitalization - outstanding shares, expressed as a multiple of LTM EBT excluding unusual items. The value is based on the latest available price. [Magnitude: x] |
|
mcEBTExclUnusual |
decimal{34,8} |
|
Market capitalization expressed as a multiple of LTM EBT excluding non-recurring items. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
mcLeveredFCF |
decimal{34,8} |
|
Market capitalization expressed as a multiple of LTM levered free cash flow. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
mcLeveredFCFExer |
decimal{34,8} |
|
Diluted market capitalization - exercisable shares, expressed as a multiple of LTM levered free cash flow. The value is based on the latest available price. [Magnitude: x] |
|
mcLeveredFCFOut |
decimal{34,8} |
|
Diluted market capitalization - outstanding shares, expressed as a multiple of LTM levered free cash flow. The value is based on the latest available price. [Magnitude: x] |
|
mcTotRev |
decimal{34,8} |
|
Market capitalization expressed as a multiple of LTM total revenue. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
mcTotRevExer |
decimal{34,8} |
|
Diluted market capitalization - exercisable shares, expressed as a multiple of LTM total revenue. The value is based on the latest available price. [Magnitude: x] |
|
mcTotRevOut |
decimal{34,8} |
|
Diluted market capitalization - outstanding shares, expressed as a multiple of LTM total revenue. The value is based on the latest available price. [Magnitude: x] |
|
pBV |
decimal{34,8} |
|
Stock price expressed as a multiple of LTM book value per share. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
pDilutedEPSBeforeExtra |
decimal{34,8} |
|
Stock price expressed as a multiple of LTM diluted earnings per share (EPS) before extraordinary items. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
pNormalizedEps |
decimal{34,8} |
|
Stock price expressed as a multiple of LTM normalized diluted earnings per share. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
pTangBV |
decimal{34,8} |
|
Stock price expressed as a multiple of LTM tangible book value per share. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
| link |
periodType |
ExcelPeriodConstant |
|
Period type reference. |
|
periodTypeId |
long(0,255)* |
|
Unique identifier for the type of period. |
|
pricingDate |
date* |
|
Date on which the pricing data was recorded. |
|
tevEBIT |
decimal{34,8} |
|
Total enterprise value expressed as a multiple of LTM earnings before interest and taxes (EBIT), including equity income from affiliates. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITDA |
decimal{34,8} |
|
Total enterprise value expressed as a multiple of LTM earnings before interest, taxes, depreciation, and amortization (EBITDA), including equity income from affiliates. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITDAExclOperLease |
decimal{34,8} |
|
Total enterprise value excluding operating leases, expressed as a multiple of LTM EBITDA including equity income from affiliates and excluding operating lease adjustment. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITDAExer |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, expressed as a multiple of LTM EBITDA. The value is based on the latest available price. [Magnitude: x] |
|
tevEBITDAExerExclOperLease |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, excluding operating leases, expressed as a multiple of LTM EBITDA including equity income from affiliates and excluding operating lease adjustment. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITDAOut |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, expressed as a multiple of LTM EBITDA. The value is based on the latest available price. [Magnitude: x] |
|
tevEBITDAoutExclOperLease |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, excluding operating leases, expressed as a multiple of LTM EBITDA including equity income from affiliates and excluding operating lease adjustment. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITExclOperLease |
decimal{34,8} |
|
Total enterprise value excluding operating leases, expressed as a multiple of earnings before interest and taxes (EBIT) including equity income from affiliates. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITExer |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, expressed as a multiple of LTM EBIT. The value is based on the latest available price. [Magnitude: x] |
|
tevEBITExerExclOperLeases |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, excluding operating leases, expressed as a multiple of LTM EBIT. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevEBITOut |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, expressed as a multiple of LTM EBIT. The value is based on the latest available price. [Magnitude: x] |
|
tevEBITOutExclOperLease |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, excluding operating leases, expressed as a multiple of LTM EBIT including equity income from affiliates. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevTotRev |
decimal{34,8} |
|
Total enterprise value expressed as a multiple of LTM total revenue. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevTotRevExclOperLease |
decimal{34,8} |
|
Total enterprise value excluding operating leases, expressed as a multiple of LTM total revenue. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevTotRevExer |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, expressed as a multiple of LTM total revenue. The value is based on the latest available price. [Magnitude: x] |
|
tevTotRevExerExclOperLease |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, excluding operating leases, expressed as a multiple of LTM total revenue. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevTotRevOut |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, expressed as a multiple of LTM total revenue. The value is based on the latest available price. [Magnitude: x] |
|
tevTotRevOutExclOperLease |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, excluding operating leases, expressed as a multiple of LTM total revenue. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevUnleveredFCF |
decimal{34,8} |
|
Total enterprise value expressed as a multiple of LTM unlevered free cash flow. The value is based on the closing stock price on the applicable pricing date. [Magnitude: x] |
|
tevUnleveredFCFExer |
decimal{34,8} |
|
Diluted total enterprise value - exercisable shares, expressed as a multiple of LTM unlevered free cash flow. The value is based on the latest available price. [Magnitude: x] |
|
tevUnleveredFCFOut |
decimal{34,8} |
|
Diluted total enterprise value - outstanding shares, expressed as a multiple of LTM unlevered free cash flow. The value is based on the latest available price. [Magnitude: x] |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |