Excel Add-In: Reported Fundamentals Data

The New Constructs Reported Fundamentals Data Excel Add-In function provides immediate access to the data points in our models for 2800+ companies. Models are updated daily. Reported Fundamentals includes data as reported by the company from their financial statements - the income statement, balance sheet, and cash flow statement.

Excel Add-In: Reported Fundamentals

Function
Function Name
=NC_AdjustedFundamentals(ticker, datapoint, fiscal_year, fiscal_quarter, fiscal_quarter_for_ttm_data)
Parameters
Name
Position
Description
Example
Ticker
1
Ticker of the security. You can use the coverage function to get full lists of options.
A
Data Point
2
Name of the data point. Click here for a full list of available data points
ROIC
Fiscal Year
3
Fiscal year of the data point. We generally cover companies back to the first digital document filed with the SEC.
2017
Fiscal Quarter
4
The fiscal quarter for quarterly data (3 month period). If Fiscal Quarter is specified, Fiscal Quarter for TTM Data must be set to 0. Options:
0 = annual data
1 = Q1 quarterly data
2 = Q2 quarterly data
3 = Q3 quarterly data
4 = Q4 quarterly data
1
Fiscal Quarter for TTM Data
5
The fiscal quarter for quarterly data (3 month period). If Fiscal Quarter for TTM Data is specified, Fiscal Quarter must be set to 0. Options:
0 = annual data
1 = TTM data ending with Q1 (indicated fiscal year Q1 + prior fiscal year Q4, Q3, & Q2)
2 = TTM data ending with Q2 (indicated fiscal year Q2 & Q1 + prior fiscal year Q4 & Q3)
3 = TTM data ending with Q3 (indicated fiscal year Q3, Q2, & Q1 + prior fiscal year Q4)
4 = TTM data ending with Q4 (indicated fiscal year Q4, Q3, Q2, & Q1).
1
Return Values
Name
Description
Example
Data Value
Value of the requested datapoint in ones.
35490000000.00000000000000000
Sample Function Call
      
A B C D E
1 =NC_ReportedFundamentals("A", "ROIC", "2017", 2, 0)
2
3
4
Sample Response Data
      
A B C D E
1 35490000000.00000000000000000
2
3
4
Available Datapoints
Category
Datapoint
Name
Description
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_CASH
Cash and Equivalents (non-operating)
Cash and cash equivalents, a current asset on the balance sheet. This data point collects cash for non-financial companies.
Balance Sheet: Current/Investment Assets
CASH_OPERATING
Cash and Equivalents (operating)
Cash and cash equivalents, a current asset on the balance sheet. This data point collects cash for financial companies or segments.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_CASH_RESTRICTED
Current Restricted Cash
Restricted cash, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_INVESTMENTS
Other Investment Securities (operating)
Investment securities, a current asset on the balance sheet for financial companies or financial segments.
Balance Sheet: Current/Investment Assets
ACCOUNTS_RECEIVABLE
Accounts Receivable
Accounts receivable, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
INVENTORY
Inventory
Inventory, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_DEFERRED_TAX
Reported Current Deferred Tax Assets
Current deferred tax assets, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_LOANS_NET
Net Loans
Net loans, a current asset on the balance sheet for finanial companies or financial segments
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_SEPARATE_ACCOUNTS
Separate Accounts
Separate accounts, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_OTHER
Other Current or Investment Assets
Other current assets on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_DEFERRED_COMPENSATION
Reported Current Deferred Compensation Assets
Current deferred compensation assets, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_DISCONTINUED_OPERATIONS
Current Discontinued Operations (non-operating)
Current assets from discontinued operations, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
ASSETS_CURRENT_LEASES_OPERATING
Reported Current Operating Lease Assets
Current operating lease assets, a current asset on the balance sheet.
Balance Sheet: Current/Investment Assets
RESERVES_PREVIOUS_INVENTORY
Previous Year's Inventory Reserve
Inventory reserve from the previous year.
Balance Sheet: Current/Investment Assets
RESERVES_PREVIOUS_LIFO
Previous Year's LIFO Reserve
Lifo reserve from the previous year.
Balance Sheet: Current/Investment Assets
RESERVES_PREVIOUS_LOAN_LOSS
Previous Year's Loan Loss Reserve
Loan loss reserve from the prior year.
Balance Sheet: Current/Investment Assets
RESERVES_INVENTORY
Inventory Reserves
Inventory reserve from the current year.
Balance Sheet: Current/Investment Assets
RESERVES_LIFO
LIFO Reserves
LIFO reserve from the current year.
Balance Sheet: Current/Investment Assets
RESERVES_LOAN_LOSS
Loan Loss Reserves
Loan loss reserve from the current year.
Balance Sheet: Current/Investment Assets
INVENTORY_LOSS_PROVISION
Inventory Loss Provision
Inventory loss provision from cash flows from operations section of the cash flow statement.
Balance Sheet: Current/Investment Assets
CHARGES_TO_OTHER_ACCOUNTS
Charges To Other Accounts
An increase (decrease) in a reserve from sources other than the provision and net write-off.
Balance Sheet: Fixed Assets
PP_AND_E_NET
Net Property
Property, plant, and equipment, net, a fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
GOODWILL_NET
Net Goodwill
Net goodwill, a long-term asset on the balance sheet.
Balance Sheet: Fixed Assets
GOODWILL_AND_INTANGIBLES_NET_OTHER
Other Intangibles
Other intangible assets, a long-term asset on the balance sheet.
Balance Sheet: Fixed Assets
CASH_RESTRICTED
Long-term Restricted Cash
Restricted cash, a long-term asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_DEFERRED_TAX
Reported Deferred Tax Assets
Fixed deferred tax assets, a fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_OPERATING_DISCONTINUED_OPERATIONS
Discontinued Operations (operating)
Fixed assets from discontinued operations, a fixed asset on the balance sheet for REITs.
Balance Sheet: Fixed Assets
ASSETS_FIXED_OPERATING_SUBSIDIARY_UNCONSOLIDATED
Unconsolidated Subsidiary Assets (operating)
Investment in unconsolidated subsidiaries that are part of operations. A fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_OREO
Other Real Estate Owned
Other Real Estate Owned (OREO) assets, a fixed asset on the balance sheet for financial companies or segments.
Balance Sheet: Fixed Assets
ASSETS_FIXED_OTHER
Other Fixed Assets
Other fixed assets on the balance sheet.
Balance Sheet: Fixed Assets
CASH_LONG_TERM
Long-Term Investments (non-operating)
Long-term investments, a long-term asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_UNCONSOLIDATED
Unconsolidated Subsidiary Assets (non-operating)
Investment in unconsolidated subsidiaries that are not part of operations. A fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_DEFERRED_COMPENSATION
Reported Deferred Compensation Assets
Fixed deferred compensation assets, a fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_DISCONTINUED_OPERATIONS
Discontinued Operations (non-operating)
Fixed assets from discontinued operations, a fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED
Total Fixed Assets
Total fixed assets from the balance sheet.
Balance Sheet: Fixed Assets
ASSETS_FIXED_LEASES_OPERATING
Reported Non-Current Operating Lease Assets
Fixed operating lease assets, a fixed asset on the balance sheet.
Balance Sheet: Fixed Assets
GOODWILL_AMORTIZATION_ACCUMULATED
Accumulated Goodwill Amortization
Accumulated goodwill amortization is the total amount of goodwill that had been amortized prior to the adoption of SFAS 142.
Balance Sheet: Fixed Assets
DEPRECIATION_AND_AMORTIZATION_ACCUMULATED
Accumulated Depreciation and Amortization
Accumulated depreciation and amortization, a data point collected from the balance sheet or notes.
Balance Sheet: Current/Investment Liabilities
ACCOUNTS_PAYABLE
Accounts Payable
Accounts payable, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_DEFERRED_TAX
Reported Current Deferred Tax Liability
Current deferred tax liability, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_RESTRUCTURING
Accrued Restructuring Charges
Current liability for restructuring charges, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_REVENUE_DEFERRED
Current Deferred Revenue
Current deferred revenue, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_SEPARATE_ACCOUNTS
Separate Accounts
Separate accounts, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_OTHER
Other NIBCL or Investment Liabilities
Other non-interest bearing current liabilities or investment liabilities, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_DEFERRED_COMPENSATION
Reported Current Deferred Compensation Liability
Current deferred compensation liability, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL_DISCONTINUED_OPERATIONS
Current Discontinued Operations (non-operating)
Current liability for discontinued operations, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
DEBT_FINANCIAL
Investment Liabilities - Debt
Short-term and long-term debt for financial companies or segments.
Balance Sheet: Current/Investment Liabilities
DEBT_SHORT_TERM
Short-Term Debt
Short-term debt, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
LIABILITIES_CURRENT
Total Current/Investment Liabilities
Total current/investment liabilities.
Balance Sheet: Current/Investment Liabilities
NIBCL_LEASES_OPERATING
Reported Current Operating Lease Liabilities
Current operating lease liabilities, a current liability on the balance sheet.
Balance Sheet: Current/Investment Liabilities
NIBCL
NIBCL (Non-Interest-Bearing Current Liabilities)
Total non-interest bearing current operating liabilities including accrued expenses and payables.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_DEBT
Long-Term Debt
Long-term debt, a long-term, liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_DEFERRED_TAX
Reported Deferred Tax Liability
Long-term deferred tax liabilities, a long-term liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_DEFERRED_COMPENSATION
Reported Deferred Compensation Liability
Long-term deferred compensation liability, a long-term liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_OPERATING_DISCONTINUED_OPERATIONS
Discontinued Operations (operating)
Long-term discontinued operations, a long-term liability on the balance sheet for REITs.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_OTHER
Other Long-term Liabilities
Other long-term liabilities, a long-term liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
INTEREST_MINORITY
Minority Interests
Minority interests, a component of shareholder's equity representing a significant but non-controlling ownership of a company's voting shares by either an investor or another company.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_DISCONTINUED_OPERATIONS
Discontinued Operations (non-operating)
Long-term discontinued operations, a long-term liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
STOCK_COMMON
Common Stock
Common stock, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
EARNINGS_RETAINED
Retained Earnings
Retained earnings, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
STOCK_TREASURY
Treasury Stock
Treasury stock, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
STOCK_PREFERRED
Preferred Capital
Total preferred stock from the Shareholder's Equity section of the balance sheet and the Mezzanine section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
OCI
Accumulated OCI (Other Comprehensive Income)
Accumulated Other Comprehensive Income, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
EQUITY_SHAREHOLDER_OTHER_DEFERRED_COMPENSATION
Deferred Compensation Shareholders' Equity
Deferred compensation shareholder's equity, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
EQUITY_SHAREHOLDER_OTHER_EQUITY
Other Shareholders' Equity
Other shareholders' equity, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
EQUITY_SHAREHOLDER_OTHER_MEZZANINE
Mezzanine Shareholders' Equity
Mezzanine shareholders' equity, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
EQUITY_SHAREHOLDER
Total Shareholders' Equity
Total shareholders' equity, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES
Total Liabilities and Shareholders' Equity
Total liabilities and shareholders' equity.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_LEASES_OPERATING
Reported Non-Current Operating Lease Liabilities
Long-term operating lease liability, a long-term liability on the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
SHARES_OUTSTANDING_PE_DATE_BS
Shares Outstanding on the PE Date (not split-adjusted)
Shares outstanding on the period end date (not split-adjusted).
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
SHARES_TREASURY
Treasury Shares (not split-adjusted)
Treasury shares (not split-adjusted).
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
STOCK_PREFERRED_EQUITY
Preferred Stock
Preferred stock, from the shareholders' equity section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
STOCK_PREFERRED_MEZZANINE
Preferred Stock - Mezzanine
Preferred stock - mezzanine, from the mezzanine section of the balance sheet.
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
SHARES_ISSUED
Shares Issued (not split-adjusted)
Shares issued (not split-adjusted).
Income Statement: Revenue
REVENUE_OTHER
Operating Revenue
Revenue, an item on the income statement.
Income Statement: Revenue
REVENUE_SUBSIDIARY_UNCONSOLIDATED
Unconsolidated Subsidiary Revenue
Unconsolidated subsidiary revenue, an item on the income statement.
Income Statement: Revenue
REVENUE
Total Operating Revenue
Total operating income, an item on the income statement.
Income Statement: Revenue
REVENUE_INCOME_INTEREST
Interest Income
Interest income for financials, an item on the income statement.
Income Statement: Cost of Goods Sold
REVENUE_COST_OTHER
Cost of Sales
Cost of sales, an expense on the income statement.
Income Statement: Cost of Goods Sold
CREDIT_LOSS_PROVISION
Credit Loss Provision
Credit loss provision, an expense on the income statement recognized by financial companies or segments.
Income Statement: Cost of Goods Sold
SALES_COST
Total Cost of Sales
Total cost of sales, an expense on the income statement.
Income Statement: Other Operating Income
INCOME_OPERATING_DISCONTINUED_OPERATIONS
Income from Discontinued Operations (operating)
Income from discontinued operations, an item on the income statement for REITs.
Income Statement: Other Operating Income
INCOME_OPERATING_SUBSIDIARY_UNCONSOLIDATED
Income from Unconsolidated Subsidiaries (operating)
Income from unconsolidated subsidiaries, an operating item on the income statement.
Income Statement: Other Operating Income
INCOME_OPERATING_SUBSIDIARY_UNCONSOLIDATED_AFTER_TAX
Income from Unconsolidated Subsidiaries After-tax (operating)
Income from unconsolidated subsidiaries after-tax, an operating item on the income statement.
Income Statement: Other Operating Income
INCOME_OPERATING_OTHER
Other Operating Income
Other operating income.
Income Statement: Other Operating Income
INCOME_OPERATING
Total Operating Income
Sum of a company's operating income derived outside of revenues.
Income Statement: Expenses/Income
EXPENSES_NON_RECURRING_WRITE_DOWN
Write-Downs (non-operating)
Write-downs, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_SGA
Selling
Selling, general, and administrative, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_NON_RECURRING_RESTRUCTURING
Restructuring Expense
Restructuring expense, an expense on the income statement.
Income Statement: Expenses/Income
RESEARCH_AND_DEVELOPMENT_EXPENSE
Research and Development Expense
Research and development expense, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_DEPRECIATION_AND_AMORTIZATION
Depreciation and Amortization
Depreciation and amortization, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_NON_RECURRING_OTHER
Other Non-Recurring Expense/(Income)
Other non-recurring expense/(income), from the income statement.
Income Statement: Expenses/Income
EXPENSES_INTEREST
Interest Expense/(Income)
Interest expense/(income), net, from the income statement for non-financial companies.
Income Statement: Expenses/Income
GOODWILL_AMORTIZATION_INCOME_STATEMENT
Goodwill Amortization
Goodwill amortization, a data point on the income statement collected prior to 2001 when companies where permitted to amortize goodwill.
Income Statement: Expenses/Income
EXPENSES_DISCONTINUED_OPERATIONS
Expenses/(Income) from Discontinued Operations
Expenses/(income) from discontinued operations, net, from the income statement.
Income Statement: Expenses/Income
EXPENSES_INTEREST_FINANCIALS
Interest Expense (operating)
Interest expense, an exense on the income statement for financial companies or financial segments.
Income Statement: Expenses/Income
EXPENSES_STOCK_COMPENSATION
Stock Compensation
Stock compensation, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_SUBSIDIARY_UNCONSOLIDATED
Losses from Unconsolidated Subsidiaries
Losses from unconsolidated subsidiaries, net, from the income statement.
Income Statement: Expenses/Income
EXPENSES_COMPENSATION
Other Compensation
Other compensation, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_FOREIGN_CURRENCY
Foreign Currency Loss/(Gain)
Foreign currency loss/(gain), net, from the income statement.
Income Statement: Expenses/Income
EXPENSES_ENERGY
Energy Operating Expense
Energy expense, an expense on the income statement for energy companies.
Income Statement: Expenses/Income
EXPENSES_OREO
Non-Operating Other Real Estate Owned Expense/(Income)
Non-operating other real estate owned expense/(income), net, a data point on the income statement.
Income Statement: Expenses/Income
EXPENSES_DISCONTINUED_OPERATIONS_REITS
Losses from Discontinued Operations (operating)
Losses from discontinued operations for REITs.
Income Statement: Expenses/Income
EXPENSES_NON_OPERATING_OTHER
Other Non-Operating Expense/(Income)
Other non-operating expense/(income), net, from the income statement.
Income Statement: Expenses/Income
EXPENSES_OPERATING_SUBSIDIARY_UNCONSOLIDATED
Losses from Unconsolidated Subsidiaries (operating)
Losses from unconsolidated subsidiaries, treated as operating if the corresponding asset is operating.
Income Statement: Expenses/Income
EXPENSES_OREO_REITS
Operating Other Real Estate Owned Expense
Other real estate owned (OREO) expense, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_OPERATING_OTHER
Other Operating Expense
Other operating expense, an expense on the income statement.
Income Statement: Expenses/Income
EXPENSES_OPERATING
Total Operating Expense
Total operating expenses disclosed on the income statement.
Income Statement: Expenses/Income
EXPENSES
Total Expenses
Total Expenses
Income Statement: Pre-Tax Income
INCOME_FROM_OPERATIONS
Reported Income from Operations
Reported income from operations, an item on the income statement.
Income Statement: Taxes
INCOME_TAX
Income Tax Provision
A line item on a company's income statement representing its estimated tax liability or benefit for the current year.
Income Statement: Taxes
INCOME_TAX_DEFERRED
Total Deferred Income Taxes
Deferred income taxes.
Income Statement: Taxes
INCOME_TAX_CURRENT
Total Current Income Taxes
Current income taxes payable.
Income Statement: Taxes
INCOME_TAX_OTHER
Income Tax Expense/(Benefit) - Other
Other income tax expense/(benefit).
Income Statement: After-Tax Charges
EXPENSES_INTEREST_MINORITY
Minority Interest Expense
Minority interest expense, net, an after-tax charge on the income statement.
Income Statement: After-Tax Charges
DIVIDENDS_PREFERRED
Preferred Dividends
Preferred dividends, an after-tax charge on the income statement.
Income Statement: After-Tax Charges
DIVIDENDS_PREFERRED_REDEEMABLE_MANDATORILY
Dividends on Redeemable Preferred Stock
Dividends on redeemable preferred stock, an after-tax charge on the income statement.
Income Statement: After-Tax Charges
CHARGE_AFTER_TAX_DISCONTINUED_OPERATIONS
Loss/(Gain) from Discontinued Operations
Loss/(gain) from discontinued operations, net, an after-tax, from the income statement.
Income Statement: After-Tax Charges
CHARGES_AFTER_TAX_OTHER
Other After-tax Charge
Other after-tax charge, net, an after-tax charge on the income statement.
Income Statement: After-Tax Charges
INCOME_TAX_DISCONTINUED_OPERATIONS
Income Tax Expense/(Benefit) - Discontinued Operations
Income tax expense/(benefit) from discontinued operations.
Income Statement: Net Income & EPS
INCOME_NET
GAAP Net Income
GAAP net income.
Income Statement: Net Income & EPS
WABSO
Basic Weighted Avg. Shares (not split-adjusted)
Basic weighted average shares (not split-adjusted).
Income Statement: Net Income & EPS
WADSO
Diluted Weighted Avg. Shares (not split-adjusted)
Diluted weighted average shares (not split-adjusted).
Income Statement: Net Income & EPS
INCOME_NET_PER_WABSO
Basic EPS (not split-adjusted)
Basic earnings per share (not split-adjusted).
Income Statement: Net Income & EPS
INCOME_NET_PER_WADSO
Diluted GAAP EPS (not split-adjusted)
Diluted earnings per share (not split-adjusted).
Cash Flow Statement: Cash From Operations
DEPRECIATION_AND_AMORTIZATION_CASH_FLOW
Depreciation and Amortization (Cash Flow)
Depreciation and amortization from cash flows from operations section of the cash flow statement.
Cash Flow Statement: Cash From Operations
GOODWILL_AMORTIZATION_CASH_FLOW
Goodwill Amortization (Cash Flow Statement)
Goodwill amortization, from cash flows from operations section of the cash flow statement, collected prior to 2001 when companies where permitted to amortize goodwill.
Cash Flow Statement: Cash From Operations
TAX_CHANGE_DEFERRED
Change in Deferred Taxes
Change in deferred taxes, from cash flows from operations section of the cash flow statement.
Cash Flow Statement: Cash From Operations
CASH_FLOW_OPERATING
Cash Flow from Operations
Total cash flow from operations.
Cash Flow Statement: Cash From Operations
STOCK_BASED_COMPENSATION_CASH_FLOW
Stock-Based Compensation
Stock-based compensation,from cash flows from operations section of the cash flow statement.
Cash Flow Statement: Cash From Investing
CAPEX
Capital Expenditures
Capital expenditures, from cash flows from investing section of the cash flow statement.
Cash Flow Statement: Cash From Investing
CAPEX_ACQUISITION
Acquisition Capital Expenditures
Acquisition expenditures, from cash flows from investing section of the cash flow statement.
Cash Flow Statement: Cash From Investing
CASH_FLOW_INVESTING
Cash Flow from Investing Activities
Total cash flow from investing activities.
Cash Flow Statement: Cash From Financing
CASH_FLOW_FINANCING
Cash Flow from Financing Activities
Total cash flow from financing activities.
Cash Flow Statement: Cash From Financing
CASH_FLOW_SHARE_REPURCHASE
Cash Paid for Share Repurchases
Total cash flow from share repurchases.
Adjustments from the Notes and MD&A: Income Statement Adjustments
EXPENSES_NON_OPERATING
Reported Net Non-Operating Expense
Total non-operating items disclosed on the income statement.
Adjustments from the Notes and MD&A: Income Statement Adjustments
CHARGE_AFTER_TAX
Net After-Tax Non-Operating Expense/(Income)
Reported after tax charges.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
GOODWILL_UNRECORDED
Unrecorded Goodwill
Unrecorded goodwill, a calculated value equal to the amount of goodwill assumed during an acquisition when the pooling of interests method is used.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
RESERVES
Total Reserves
Sum of the current ending reserve balances for LIFO, inventory, and loan loss reserves.
Other Notes + MD&A Disclosures: Other
CASH_PAID_FOR_INCOME_TAXES
Cash Paid for Income Taxes
Cash paid for income taxes, a data point disclosed on the cash flow statement or in the notes.
Other Notes + MD&A Disclosures: Other
CASH_PAID_FOR_INTEREST
Cash Paid for Interest
Cash paid for interest, a data point disclosed on the cash flow statement or in the notes.

Excel Add-In: Fundamental Data Errors

Error
Message
Error Code
DataPointNotFound
The requested datapoint was not found.
404