
Dataset Name: intrinio_fundamentals_indu_calculations
Group: fundamental
Vendor: Intrinio
Asset Class: Equity
Data Update Time(s): 7:30 AM EST
Data Update Frequency: day
Intrinio industry fundamentals calculations data
Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data - America/New York Time. |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
symbol | string | Trading Symbol or Ticker |
fundamental_id | string | fundamental_id |
company_id | string | Company identifier |
name | string | name |
cik | int | Central Index Key |
start_date | string | start_date |
end_date | string | end_date |
months | int | months |
fiscal_year | int | Fiscal year (ie 2017 2018 2019 2020 2021) |
fiscal_period | string | The company's fiscal period |
filing_date | string | Filining date with the regulator |
revenuegrowth | double | Revenue Growth |
nopatmargin | double | nopatmargin |
investedcapital | double | investedcapital |
investedcapitalturnover | double | investedcapitalturnover |
nopat | double | nopat |
investedcapitalincreasedecrease | double | investedcapitalincreasedecrease |
freecashflow | double | Free cash flow (FCF) represents the cash that a company generates after accounting for cash outflows to support operations and maintain its capital assets. |
debttoebitda | double | debt to ebitda ratio |
netnonopex | double | netnonopex |
netnonopobligations | double | netnonopobligations |
ebit | double | Earnings before interest and taxes (EBIT) is an indicator of a company's profitability. EBIT can be calculated as revenue minus expenses excluding tax and interest. EBIT is also referred to as operating earnings, operating profit, and profit before interest and taxes. |
depreciationandamortization | double | depreciation and amortization |
ebitda | double | EBITDA, or earnings before interest, taxes, depreciation, and amortization, is an alternate measure of profitability to net income. By stripping out the non-cash depreciation and amortization expense as well as taxes and debt costs dependent on the capital structure, EBITDA attempts to represent cash profit generated by the company’s operations. |
capex | double | Capital expenditures (CapEx) are funds used by a company to acquire, upgrade, and maintain physical assets such as property, plants, buildings, technology, or equipment |
dfcfnwc | double | dfcfnwc |
dfnwc | double | dfnwc |
nwc | double | nwc |
debt | double | debt |
ltdebtandcapleases | double | ltdebtandcapleases |
netdebt | double | netdebt |
totalcapital | double | totalcapital |
bookvaluepershare | double | book value per share |
tangbookvaluepershare | double | tangbookvaluepershare |
marketcap | double | marketcap |
enterprisevalue | double | enterprisevalue |
pricetobook | double | pricetobook |
pricetotangiblebook | double | pricetotangiblebook |
pricetorevenue | double | Price to Revenue ratio |
pricetoearnings | double | pricetoearnings |
dividendyield | double | The dividend yield, expressed as a percentage, is a financial ratio (dividend/price) that shows how much a company pays out in dividends each year relative to its stock price. |
earningsyield | double | earningsyield |
evtoinvestedcapital | double | evtoinvestedcapital |
evtorevenue | double | EV to Revenue ratio |
evtoebitda | double | evtoebitda |
evtoebit | double | evtoebit |
evtonopat | double | evtonopat |
evtoocf | double | evtoocf |
evtofcff | double | evtofcff |
ebitdagrowth | double | EBITDA Growth |
ebitgrowth | double | ebitgrowth |
nopatgrowth | double | nopatgrowth |
netincomegrowth | double | netincomegrowth |
epsgrowth | double | epsgrowth |
ocfgrowth | double | ocfgrowth |
fcffgrowth | double | fcffgrowth |
investedcapitalgrowth | double | investedcapitalgrowth |
revenueqoqgrowth | double | revenueqoqgrowth |
ebitdaqoqgrowth | double | ebitdaqoqgrowth |
ebitqoqgrowth | double | ebitqoqgrowth |
nopatqoqgrowth | double | nopatqoqgrowth |
epsqoqgrowth | double | epsqoqgrowth |
ocfqoqgrowth | double | ocfqoqgrowth |
fcffqoqgrowth | double | fcffqoqgrowth |
investedcapitalqoqgrowth | double | investedcapitalqoqgrowth |
grossmargin | double | grossmargin |
operatingmargin | double | operatingmargin |
ebitmargin | double | EBIT Margin is the operating earnings over operating sales. |
profitmargin | double | profitmargin |
costofrevtorevenue | double | cost of rev to revenue |
sgaextorevenue | double | sgaextorevenue |
rdextorevenue | double | rdextorevenue |
opextorevenue | double | opextorevenue |
taxburdenpct | double | taxburdenpct |
interestburdenpct | double | interestburdenpct |
efftaxrate | double | efftaxrate |
assetturnover | double | The asset turnover ratio measures the value of a company's sales or revenues relative to the value of its assets. |
arturnover | double | accounts receivable turnover |
invturnover | double | invturnover |
faturnover | double | faturnover |
apturnover | double | accounts payable turnover |
dso | double | dso |
dio | double | dio |
dpo | double | dpo |
ccc | double | CCC |
finleverage | double | finleverage |
leverageratio | double | leverageratio |
compoundleveragefactor | double | compound leverage factor |
ltdebttoequity | double | ltdebttoequity |
roic | double | roic |
nnep | double | nnep |
roicnnepspread | double | roicnnepspread |
rnnoa | double | rnnoa |
roe | double | roe |
croic | double | croic |
oroa | double | oroa |
roa | double | roa |
ebitdamargin | double | EBITDA margin is a measure of a company's operating profit as a percentage of its revenue. |
roce | double | roce |
divpayoutratio | double | The dividend payout ratio is the ratio of the total amount of dividends paid out to shareholders relative to the net income of the company. It is the percentage of earnings paid to shareholders via dividends. The amount that is not paid to shareholders is retained by the company to pay off debt or to reinvest in core operations. It is sometimes simply referred to as simply the payout ratio. |
augmentedpayoutratio | double | augmented payout ratio |
ocftocapex | double | ocftocapex |
stdebttocap | double | stdebttocap |
ltdebttocap | double | ltdebttocap |
debttototalcapital | double | debt to total capital ratio |
preferredtocap | double | preferredtocap |
noncontrolinttocap | double | noncontrolinttocap |
commontocap | double | common tocap |
debttoequity | double | debt to equity ratio |
netdebttoebitda | double | netdebttoebitda |
ltdebttoebitda | double | ltdebttoebitda |
debttonopat | double | debt to nopat |
netdebttonopat | double | netdebttonopat |
ltdebttonopat | double | ltdebttonopat |
altmanzscore | double | altmanzscore |
ebittointerestex | double | ebittointerestex |
nopattointerestex | double | nopattointerestex |
ebitlesscapextointerestex | double | ebitlesscapextointerestex |
nopatlesscapextointex | double | nopatlesscapextointex |
ocftointerestex | double | ocftointerestex |
ocflesscapextointerestex | double | ocflesscapextointerestex |
fcfftointerestex | double | fcfftointerestex |
currentratio | double | current ratio |
quickratio | double | quickratio |
dfcfnwctorev | double | dfcfnwc to rev ratio |
dfnwctorev | double | dfnwctorev |
nwctorev | double | nwctorev |
netincomeqoqgrowth | double | netincomeqoqgrowth |
noncontrollinginterestsharingratio | double | noncontrollinginterestsharingratio |
normalizednopat | double | normalizednopat |
normalizednopatmargin | double | normalizednopatmargin |
pretaxincomemargin | double | pretaxincomemargin |
adjweightedavebasicdilutedsharesos | double | adjusted weighted average basic diluted shares outstanding |
adjbasicdilutedeps | double | adjusted basic diluted earnings per share (eps) |
adjweightedavebasicsharesos | double | adjusted weighted average basic shares outstanding |
adjbasiceps | double | adjusted basic earnings per share (eps) |
adjweightedavedilutedsharesos | double | adjusted weighted average diluted shares outstanding |
adjdilutedeps | double | adjusted diluted earnings per share (eps) |
roe_simple | double | roe_simple |