
Dataset Name: intrinio_fundamentals_fin_calculations
Group: fundamental
Vendor: Intrinio
Asset Class: Equity
Data Update Time(s): 7:30 AM EST
Data Update Frequency: day
Intrinio financial 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 | double | 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 |
ebitdamargin | double | EBITDA margin is a measure of a company's operating profit as a percentage of its revenue. |
investedcapital | double | investedcapital |
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. |
ebitdagrowth | double | EBITDA Growth |
ebitgrowth | double | ebitgrowth |
nopatgrowth | double | nopatgrowth |
netincomegrowth | double | netincomegrowth |
epsgrowth | double | epsgrowth |
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 |
debt | double | debt |
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 |
ltdebtandcapleases | double | ltdebtandcapleases |
netdebt | double | netdebt |
totalcapital | double | totalcapital |
bookvaluepershare | double | book value per share |
tangbookvaluepershare | double | tangbookvaluepershare |
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. |
marketcap | double | marketcap |
enterprisevalue | double | enterprisevalue |
pricetobook | double | pricetobook |
pricetotangiblebook | double | pricetotangiblebook |
evtoebitda | double | evtoebitda |
evtoebit | double | evtoebit |
evtonopat | double | evtonopat |
evtoocf | double | evtoocf |
evtofcff | double | evtofcff |
revenuegrowth | double | Revenue Growth |
nopat | double | nopat |
normalizednopat | double | normalizednopat |
netnonopex | double | netnonopex |
ocfgrowth | double | ocfgrowth |
fcffgrowth | double | fcffgrowth |
investedcapitalgrowth | double | investedcapitalgrowth |
revenueqoqgrowth | double | revenueqoqgrowth |
ebitdaqoqgrowth | double | ebitdaqoqgrowth |
ebitqoqgrowth | double | ebitqoqgrowth |
nopatqoqgrowth | double | nopatqoqgrowth |
netincomeqoqgrowth | double | netincomeqoqgrowth |
epsqoqgrowth | double | epsqoqgrowth |
ocfqoqgrowth | double | ocfqoqgrowth |
fcffqoqgrowth | double | fcffqoqgrowth |
investedcapitalqoqgrowth | double | investedcapitalqoqgrowth |
nopatmargin | double | nopatmargin |
normalizednopatmargin | double | normalizednopatmargin |
ebitmargin | double | EBIT Margin is the operating earnings over operating sales. |
pretaxincomemargin | double | pretaxincomemargin |
profitmargin | double | profitmargin |
sgaextorevenue | double | sgaextorevenue |
opextorevenue | double | opextorevenue |
taxburdenpct | double | taxburdenpct |
interestburdenpct | double | interestburdenpct |
efftaxrate | double | efftaxrate |
investedcapitalturnover | double | investedcapitalturnover |
assetturnover | double | The asset turnover ratio measures the value of a company's sales or revenues relative to the value of its assets. |
faturnover | double | faturnover |
finleverage | double | finleverage |
leverageratio | double | leverageratio |
compoundleveragefactor | double | compound leverage factor |
ltdebttoequity | double | ltdebttoequity |
debttoequity | double | debt to equity ratio |
roic | double | roic |
nnep | double | nnep |
roicnnepspread | double | roicnnepspread |
rnnoa | double | rnnoa |
roe | double | roe |
croic | double | croic |
oroa | double | oroa |
roa | double | roa |
noncontrollinginterestsharingratio | double | noncontrollinginterestsharingratio |
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 |
debttoebitda | double | debt to ebitda ratio |
netdebttoebitda | double | netdebttoebitda |
ltdebttoebitda | double | ltdebttoebitda |
debttonopat | double | debt to nopat |
netdebttonopat | double | netdebttonopat |
ltdebttonopat | double | ltdebttonopat |
ebittointerestex | double | ebittointerestex |
nopattointerestex | double | nopattointerestex |
ebitlesscapextointerestex | double | ebitlesscapextointerestex |
nopatlesscapextointex | double | nopatlesscapextointex |
ocftointerestex | double | ocftointerestex |
ocflesscapextointerestex | double | ocflesscapextointerestex |
fcfftointerestex | double | fcfftointerestex |
adjbasicdilutedeps | double | adjusted basic diluted earnings per share (eps) |
adjweightedavebasicdilutedsharesos | double | adjusted weighted average basic diluted shares outstanding |
adjdilutedeps | double | adjusted diluted earnings per share (eps) |
adjweightedavedilutedsharesos | double | adjusted weighted average diluted shares outstanding |
adjbasiceps | double | adjusted basic earnings per share (eps) |
adjweightedavebasicsharesos | double | adjusted weighted average basic shares outstanding |
roe_simple | double | roe_simple |