Excel Add-In: Adjusted Fundamentals Data

The New Constructs Adjusted Fundamentals Data Excel Add-In function provides immediate access to the data points in our models for 2800+ companies. Models are updated daily. Adjusted Fundamentals includes all of the reported data, plus data from the management discussion & analysis (MD&A) and the footnotes to the financial statements, and most importantly, our adjusted, economic financial statements along with the metrics used in our models. Every as-reported data point available in the Reported Fundamentals function is also available using the Adjusted Fundamentals function for convenience.

Excel Add-In: Adjusted 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 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_AdjustedFundamentals("A", "ROIC", "2017", 2, 0)
2
3
4
Sample Response Data
      
A B C D E
1 35490000000.00000000000000000
2
3
4
Sample Helper Use
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_UNADJUSTED
Total Current/Investment Assets (unadjusted)
Total Current/Investment Assets (unadjusted) as reported 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: Current/Investment Assets
ASSETS_INVESTMENT
Total Cash and Investments
The total of all non-operating cash and investments.
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_UNADJUSTED
Total Assets (unadjusted)
Reported total assets as shown in the filing.
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
OCI_ADJUSTED
Accumulated OCI (Other Comprehensive Income), Including Quarterly Estimates
Estimate of Accumulated Other Comprehensive Income, from the shareholders' equity section of the balance sheet. Primarily for IFRS companies that don't report OCI in their quarterly filings.
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
Shares Outstanding on PE Date
Shares outstanding as of the latest PE date.
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
LIABILITIES_NON_CURRENT_LONG_TERM
Long-term Operating Liabilities
Long-term Operating Liabilities
Balance Sheet: Long-Term Liabilities and Shareholders' Equity
LIABILITIES_NON_CURRENT_AND_INTEREST_MINORITY_TOTAL
Total Long-term Liabilities and Minority Interest
Total Long-term Liabilities and Minority Interest
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: Revenue
REVENUE_INTEREST_EXPENSE
Interest Expense
Interest expense for financials, an expense on the income statement.
Income Statement: Revenue
REVENUE_CAGR
Total Operating Revenue CAGR
Total revenue compound annual growth rate.
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: Gross Profit
PROFIT_GROSS
Gross Profit
Gross Profit
Income Statement: Gross Profit
PROFIT_GROSS_PER_REVENUE
Gross Margin
Gross Profit Margin
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_OPERATING_ADJUSTED
Adjusted Total Operating Expenses
Adjusted Total Operating Expenses
Income Statement: Expenses/Income
EXPENSES_NON_OPERATING_ADJUSTED
Total Net Non-Operating Expense/(Income)
Total non-operating items. This includes non-operating items explicitly disclosed on the income statement and non-operating items buried in operating expenses.
Income Statement: Expenses/Income
EXPENSES
Total Expenses
Total Expenses
Income Statement: Pre-Tax Income
INCOME_NET_PRE_TAX
Pre-Tax Income
Pre-tax income.
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_RATE
Effective Income Tax Rate
Income taxes adjusted for after-tax unconsolidated subsidiary income included in the calculation of Net Income.
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
INCOME_NET_YOY_DELTA
Net Income Change
The change in Net Income year over year.
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).
Income Statement: Net Income & EPS
WADSO_SPLIT_ADJUSTED
Diluted Weighted Avg. Shares
Diluted weighted average shares outstanding adjusted for splits.
Income Statement: Net Income & EPS
INCOME_NET_PER_WADSO_SPLIT_ADJUSTED
Diluted GAAP EPS
Diluted earnings per share.
Income Statement: Net Income & EPS
INCOME_NET_PER_WADSO_SPLIT_ADJUSTED_YOY_DELTA_PERCENT
Diluted GAAP EPS Growth
Percent growth in Diluted earnings per share year over year.
Income Statement: Net Income & EPS
WABSO_SPLIT_ADJUSTED
Basic Weighted Avg. Shares
Basic weighted average shares outstanding adjusted for splits.
Income Statement: Net Income & EPS
INCOME_NET_PER_WABSO_SPLIT_ADJUSTED
Basic EPS
Basic earnings per share.
Income Statement: Net Income & EPS
FFO
Funds from Operations (FFO)
Funds from operations, a non-GAAP performance metric specific to REITs.
Income Statement: Net Income & EPS
INCOME_NET_PER_WABSO_SPLIT_ADJUSTED_YOY_DELTA_PERCENT
Basic EPS Growth
Year over year change in Net Income per Weighted Average Basic Share Outstanding.
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
EBITDA
EBITDA/EBTDA
Operating earnings before interest, taxes, depreciation and amortization.
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_PRE_TAX_HIDDEN_TOTAL
Total Net Non-Operating Expense Hidden in Operating Earnings
Aggregate value of all non-operating expenses hidden within operating earnings. This value is deducted in deriving NOPAT.
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
RESERVES_YOY_DELTA
Change in Total Reserves
Change in ending reserve blances for LIFO, inventory, and loan loss reserves net of any charges to other accounts.
Adjustments from the Notes and MD&A: Income Statement Adjustments
GOODWILL_AMORTIZATION_ADJUSTED
Goodwill Amortization
Goodwill Amortization
Adjustments from the Notes and MD&A: Income Statement Adjustments
LEASES_OPERATING_OBLIGATION_INTEREST_IMPLIED
Interest for PV of Operating Leases
Pre-tax implied interest of operating leases.
Adjustments from the Notes and MD&A: Income Statement Adjustments
NON_OPERATING_TAXES
Non-Operating Tax Adjustment
Tax effect of non-operating expenses.
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: Income Statement Adjustments
INCOME_NON_OPERATING_ADJUSTED_AFTER_TAX
Total Adjusted Non-Operating Income After Tax
Total Adjusted Non-Operating Income After Tax
Adjustments from the Notes and MD&A: Income Statement Adjustments
INCOME_NET_ADJUSTED_FOR_EXPENSES_CAPITALIZED
GAAP Net Income after Capitalized Items
Adjustment to GAAP Net Income for the implied interest expense associated with off-balance sheet debt.
Adjustments from the Notes and MD&A: Income Statement Adjustments
CASH_TAX_RATE
Cash Tax Rate
The effective operating tax rate.
Adjustments from the Notes and MD&A: Income Statement Adjustments
COMMON_INCOME_AVAILABLE_ADJUSTED
Adjusted Net Income
GAAP Net Income after Capitalized Items adjusted for the increase in equity equivalents.
Adjustments from the Notes and MD&A: Income Statement Adjustments
CASH_OPERATING_TAXES
Cash Operating Taxes
The estimated cash taxes attributable to the operations of the business.
Adjustments from the Notes and MD&A: Income Statement Adjustments
ESO_EXPENSE
ESO Expense (Employee Stock Options)
Total expense for ESOs during the period.
Adjustments from the Notes and MD&A: Income Statement Hidden Items - Detail
NET_PERIODIC_BENEFIT_COST_NON_RECURRING_IN_OPERATING
Non-Recurring Net Periodic Benefit Costs Hidden in Operating Items
Components of net periodic benefit costs that are non-operating and non-recurring such as settlements and curtailments. This data point identifies non-operating income or expenses that are buried in operating line items on the income statement.
Adjustments from the Notes and MD&A: Income Statement Hidden Items - Detail
WRITE_DOWNS_AFTER_TAX_TOTAL
Asset Write-Offs After Tax
Total of all write-downs after tax.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
ASSETS_NET
Reported Net Assets
Net assets as shown in the filing.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
EXCESS_CASH
Excess Cash
The amount of cash on hand over and above what is needed in the current year to fund the operations of the business for the foreseeable future.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
ASSETS_CURRENT_ADJUSTED
Total Current Assets (adjusted)
A component of our Net Working Capital calculation.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
ASSETS_FIXED_ADJUSTED
Total Adjusted Fixed Assets
A component of Invested Capital, this represents all fixed operating assets plus/minus adjustments made to Invested Capital.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
CAPITAL_WORKING_NET
Net Working Capital/Net Investment Assets
Net Working Capital starts with operating current assets and subtracts NIBCLs. The metric is further adjusted by removing other non-operating items that are hidden in operating items.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
CASH_REQUIRED
Required Cash
The amount of cash the company needs in the current year to fund the operations of the business for the foreseeable future.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
CASH_REQUIRED_PER_SALES
Required Cash as % of Revenue
Value used to calculate Required Cash.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
DEBT_FINANCING
Total Debt
Total Debt
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
EQUITY_EQUIVALENCE_INCREASE
Increase in Equity Equivalents
Increase in Equity Equivalents
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
EQUITY_EQUIVALENTS
Total Equity Equivalents
Total Equity Equivalents
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
GOODWILL_AMORTIZATION_ADJUSTED_ACCUMULATED
Accumulated Goodwill Amortization
Accumulated Goodwill Amortization
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
GOODWILL_UNRECORDED_ACCUMULATED
Accumulated Unrecorded Goodwill
Total amount of unrecorded goodwill collected from the current year and all other previous years.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
LEASES_OPERATING_OBLIGATION_NET_PRESENT_VALUE
Off-Balance-Sheet Operating Leases
Net Present Value of Operating Lease Payments included in continuing operations.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
PENSION_FUNDED_STATUS_LIMITED
Over Funded Pensions
Overfunded status of a pension plan (if the pension plan is an unfunded liability this value will be 0).
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.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
SHARES_OUTSTANDING_LATEST
Shares Outstanding on the Latest Practicable Date (not split-adjusted)
Shares oustanding on the latest practicable date (not split-adjusted).
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
SHARES_OUTSTANDING_SPLIT_ADJUSTED
Shares Outstanding
Latest updated outstanding common shares value after accounting for split-adjustments.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments
WRITE_DOWNS_AFTER_TAX_TOTAL_ACCUMULATED
Accumulated Asset Write-Downs After-Tax
Total of all write-downs after tax from the current year plus all write-downs from prior years.
Adjustments from the Notes and MD&A: Total Non-Operating Expense Hidden in Operating Earnings - Detail
EXPENSES_NON_OPERATING_PRE_TAX_IN_OPERATING_TOTAL
Net Non-Operating Expense Hidden in Operating Earnings
Total pre-tax value of all Non-Operating Expense Hidden in Operating Earnings.
Adjustments from the Notes and MD&A: Total Non-Operating Expense Hidden in Operating Earnings - Detail
WRITE_DOWNS_PRE_TAX_IN_OPERATING_TOTAL
Asset Write-Downs Hidden in Operating Earnings
Pre-tax total of all write-downs that are not explicitly broken out on the income statement.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
EXPENSES_PRE_TAX_HIDDEN_TOTAL_PER_REVENUE
Total Net Non-Operating Expense Hidden in Operating Earnings as % of Revenue
Hidden non-operating expenses compared to total revenues.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
EXPENSES_NON_OPERATING_PER_REVENUE
Reported Net Non-Operating Expense as % of Revenue
Total non-operating items disclosed on the income statement compared to total revenues
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
RESERVES_YOY_DELTA_PER_REVENUE
Change in Total Reserves as % of Revenue
Measures the magnitude of the change in total reserves compared to total revenue.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
GOODWILL_AMORTIZATION_ADJUSTED_PER_REVENUE
Goodwill Amortization as % of Revenue
Measures the magnitude of goodwill amortization compared to total revenue.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
ESO_EXPENSE_TOTAL_PER_REVENUE
ESO Expense as % of Revenue
Measures the magnitude of ESO expense compared to total revenue.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
LEASES_OPERATING_OBLIGATION_INTEREST_IMPLIED_PER_REVENUE
Implied Interest for PV of Operating Leases as % of Revenue
Implied interest of PV of operating leases compared to total revenue.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
NON_OPERATING_TAXES_PER_REVENUE
Non-Operating Tax Adjustment as % of Revenue
Measures the magnitude of non-operating taxes compared to total revenue.
Adjustments from the Notes and MD&A: Income Statement Adjustments as a Percent of Revenue
CHARGE_AFTER_TAX_PER_REVENUE
Net After-Tax Non-Operating Expense/(Income) as % of Revenue
Measures the magnitude of net after-tax non-operating expense/income compared to total revenue.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
RESERVES_PERCENT_IMPACT
Total Reserves as % of Reported Net Assets
Total Reserves as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
LEASES_OPERATING_OBLIGATION_NET_PRESENT_VALUE_PERCENT_IMPACT
Off-Balance-Sheet Operating Leases as % of Reported Net Assets
Off-Balance-Sheet Operating Leases as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
GOODWILL_UNRECORDED_ACCUMULATED_PERCENT_IMPACT
Accumulated Unrecorded Goodwill as % of Reported Net Assets
Accumulated Unrecorded Goodwill as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
GOODWILL_AMORTIZATION_ADJUSTED_ACCUMULATED_PERCENT_IMPACT
Accumulated Goodwill Amortization as % of Reported Net Assets
Accumulated Goodwill Amortization as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
WRITE_DOWNS_AFTER_TAX_TOTAL_ACCUMULATED_PERCENT_IMPACT
Accumulated Asset Write-Downs After-Tax as % of Reported Net Assets
Accumulated Asset Write-Downs After-Tax as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Balance Sheet Adjustments as a Percent of Net Assets
OCI_PERCENT_IMPACT
Accumulated OCI as % of Reported Net Assets
OCI as a Percent of Reported Net Assets.
Adjustments from the Notes and MD&A: Total Non-Operating Expense Hidden in Operating Earnings - Detail as a Percent of Revenue
EXPENSES_NON_OPERATING_PRE_TAX_IN_OPERATING_TOTAL_PER_REVENUE
Net Non-Operating Expense Hidden in Operating Earnings as % of Revenue
Non-operating expense hidden in Operating Earnings compared to total revenue.
Adjustments from the Notes and MD&A: Total Non-Operating Expense Hidden in Operating Earnings - Detail as a Percent of Revenue
WRITE_DOWNS_PRE_TAX_IN_OPERATING_TOTAL_PER_REVENUE
Asset Write-Downs Hidden in Operating Earnings as % of Revenue
Asset write-downs hidden in operating earnings compared to total revenue.
Adjustments from the Notes and MD&A: Total Non-Operating Expense Hidden in Operating Earnings - Detail as a Percent of Revenue
NET_PERIODIC_BENEFIT_COST_NON_RECURRING_IN_OPERATING_PER_REVENUE
Non-Recurring Net Periodic Benefit Costs Hidden in Operating Earnings as % of Revenue
Measures the magnitude of non-recurring hidden net periodic benefit costs compared to total revenue.
Adjustments from the Notes and MD&A: Capital Charge Detail by Adjustment (WACC * Item = Capital Charge)
CAPITAL_CHARGE_PLUG
Mid-Year Acquisition Capital Charge Adjustment
The value of the adjustment made to Invested Capital for Acquisitions with Dates.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_6
Acquired Invested Capital
Total Acquired Invested Capital from the sixth acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_NO_DATE
Total Acquired Invested Capital from Acquisitions without Dates
Total Acquired Invested Capital any of the acquisitions collected where an acquisition date is NOT given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_1
Acquired Invested Capital
Total Acquired Invested Capital from the first acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_2
Acquired Invested Capital
Total Acquired Invested Capital from the second acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_3
Acquired Invested Capital
Total Acquired Invested Capital from the third acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_4
Acquired Invested Capital
Total Acquired Invested Capital from the fourth acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Acquisition Data
ACQUIRED_CAPITAL_INVESTED_5
Acquired Invested Capital
Total Acquired Invested Capital from the fifth acquisition collected where an acquisition date is given.
Other Notes + MD&A Disclosures: Employee Data
EMPLOYEE_COUNT
Total Employee Count (Values in Ones)
Total employee count.
Other Notes + MD&A Disclosures: ESO Data
VESTING_PERIOD
Vesting Period
The number of years before a company's options vest.
Other Notes + MD&A Disclosures: ESO Data
VOLATILITY
Stock Price Volatility
The expected volatility the company used to value their options.
Other Notes + MD&A Disclosures: ESO Data
DIVIDENDS_YIELD
Dividend Yield
The expected dividend percentage yield the company used to value their options.
Other Notes + MD&A Disclosures: ESO Data
ESO_RISK_FREE_RATE
Risk-Free Rate (ESO)
The risk-free interest rate the company used to value their options.
Other Notes + MD&A Disclosures: ESO Data
ESO_GRANT_EX_PRICE_WAVG
ESO Grant Price (not split-adjusted)
The weighted average exercise price of options granted during the year.
Other Notes + MD&A Disclosures: ESO Data
ESO_GRANT_EXPECTED_LIFE
ESO - Expected Life of Options Granted
The expected life of all options granted during the year.
Other Notes + MD&A Disclosures: ESO Data
ESO_EXPENSE_TOTAL_AFTER_TAX
ESO Expense After Tax
Employee stock option expense after tax.
Other Notes + MD&A Disclosures: ESO Data
ESO_SPLIT_ADJUSTED
Cumulative ESOs Outstanding At End of Fiscal Year
The cumulative total number of ESOs outstanding at the end of the period.
Other Notes + MD&A Disclosures: ESO Data
ESO_ANNUAL_CANCEL_SPLIT_ADJUSTED
ESOs Cancelled During Fiscal Year
The total amount of ESOs cancelled during the period.
Other Notes + MD&A Disclosures: ESO Data
ESO_CHURN_RATE
Option Churn Rate
The total number of ESOs cancelled per total number of ESOs outstanding.
Other Notes + MD&A Disclosures: ESO Data
ESO_GRANTED_SPLIT_ADJUSTED
ESOs Granted During Fiscal Year
The cumulative total number of ESOs outstanding at the end of the period split adjusted.
Other Notes + MD&A Disclosures: Operating Lease Data
LEASES_OPERATING_OBLIGATION_DISCONTINUED_NET_PRESENT_VALUE
Discontinued Off-Balance-Sheet Operating Leases
Net Present Value of Operating Lease Payments included in Discontinued Operations.
Other Notes + MD&A Disclosures: Pension Data
PENSION_FUNDED_STATUS
Parsed Net Funded Status
Reported Net Funded Status, a pension data point taken from the notes.
Other Notes + MD&A Disclosures: Pension Data
SERVICE_COST
Service Cost
Service cost, a pension data point taken from the notes.
Other Notes + MD&A Disclosures: Pension Data
NET_PERIODIC_BENEFIT_COST_NON_RECURRING_IN_NON_OPERATING
Non-Recurring Net Periodic Benefit Costs in Non-Operating Items
Components of net periodic benefit costs that are non-operating and non-recurring such as settlements and curtailments. This data point identifies non-operating income or expenses that are already buried or explicitly included in non-operating line items.
Other Notes + MD&A Disclosures: Pension Data
NET_PERIODIC_BENEFIT_COST
Net Periodic Benefit Cost
Net periodic benefit cost, a data point collected from the notes that is the total of all components of net periodic benefit cost for pensions.
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.
Metrics & Ratings: Market Values
EQUITY_MARKET_VALUE
Market Value of Basic Equity
Market Value of Firm's Equity as determined by the stock price and shares outstanding. Market Cap.
Metrics & Ratings: Market Values
ENTERPRISE_VALUE
Enterprise Value
Represents the total value of the company. Enterprise value takes into effect all assets and liabilities that constitute the value of the company. Simply, it is the amount of money needed to purchase the entire company and pay off all debtors and other stakeholders.
Metrics & Ratings: Market Values
BOOK_VALUE_ECONOMIC
Economic Book Value (EBV)
Economic book value measures the no-growth value of the company based on the current Net Operating Profit After Tax (NOPAT) of the business.
Metrics & Ratings: Market Values
QUANTITY_YEARS_DIVIDEND_PAYMENT_GROWTH_PAST_10_YEARS
Dividend Increases Within Last Decade
Dividend Increases in the Last Decade equals the number of years, within the past ten, that the recurring dividend payment has increased from the prior year. Unlike Consecutive Years of Dividend Increases, this metric only looks at the number of years a company increased its dividend, even if not in succession.
Metrics & Ratings: Market Values
CONSECUTIVE_YEARS_DIVIDEND_PAYMENT_GROWTH
Consecutive Years of Dividend Increases
The number of consecutive years that a company has increased its recurring dividend payment
Metrics & Ratings: Market Values
AVERAGE_DAILY_DOLLAR_VOLUME
Average Daily Dollar Volume (Trailing 30 days)
Trailing 30-day average daily dollar volume.
Metrics & Ratings: Market Values
DAYS_TO_TRADE
Days to Trade ($40mm position, 10% Average Daily Dollar Volume)
The number of days it would take to either acquire or divest a $300 million position in the stock with a maximum daily trade of 255 of the average daily volume for the stock.
Metrics & Ratings: Market Values
AVERAGE_DAILY_DOLLAR_VOLUME_1_YEAR
Average Daily Dollar Volume (Trailing 1 Year)
Average daily dollar volume of trades over the trailing year.
Metrics & Ratings: Market Values
DAYS_TO_TRADE_300M
Days to Trade ($300mm position, 25% Average Daily Dollar Volume)
Number of days to trade a $300mm position while trading a maximum of 25% of the average dollar volume each day.
Metrics & Ratings: Return on Invested Capital
ROIC
ROIC (Return On Invested Capital)
ROIC (Return On Invested Capital)
Metrics & Ratings: Return on Invested Capital
ASSETS_FIXED_ADJUSTED_TURNS
Fixed Adjusted Asset Turns
Measures relationship between fixed assets and sales generated from these assets
Metrics & Ratings: Return on Invested Capital
CAPITAL_INCREMENTAL_RETURN
Incremental Return on Invested Capital
Incremental change in NOPAT divided by the incremental change in Invested Capital.
Metrics & Ratings: Return on Invested Capital
CAPITAL_WORKING_NET_TURNS
Net Working Capital Turns/Net Investment Asset Turns
Measures the relationship between money used to fund operations and sales generated from operations.
Metrics & Ratings: Return on Invested Capital
ROIC_YOY_DELTA
Change in ROIC
Change in ROIC
Metrics & Ratings: NOPAT
NOPAT
NOPAT (Net Operating Profit After Tax)
NOPAT (Net Operating Profit After Tax)
Metrics & Ratings: NOPAT
NOPAT_PER_REVENUE
NOPAT Margin
NOPAT (Net Operating Profit After Tax) relative to Total Revenue.
Metrics & Ratings: NOPAT
NOPAT_YOY_DELTA
Change in NOPAT
Year over year change in NOPAT (Net Operating Profit After Tax).
Metrics & Ratings: NOPAT
NOPAT_YOY_DELTA_PERCENT
NOPAT Growth
NOPAT Growth
Metrics & Ratings: NOPAT
NOPBT
NOPBT (Net Operating Profit Before Tax)
NOPBT (Net Operating Profit Before Tax)
Metrics & Ratings: NOPAT
EBIT
EBIT/EBT
Operating earnings before interest and taxes.
Metrics & Ratings: NOPAT
EBITA
EBITA/EBTA
Operating earnings before interest, taxes, and amortization.
Metrics & Ratings: NOPAT
NOPAT_PER_WABSO_SPLIT_ADJUSTED_YOY_DELTA_PERCENT
Unlevered NOPAT Per Share Growth
Unlevered NOPAT Per Share Growth
Metrics & Ratings: NOPAT
NOPAT_PER_WABSO_SPLIT_ADJUSTED
Unlevered NOPAT Per Share
Unlevered NOPAT Per Share
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED
Invested Capital
Invested capital is the value of the money invested in a business over its lifetime.
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED_ADJUSTED
Average Invested Capital
Average Invested Capital over the year, adjusted for acquisitions. The denominator of our ROIC calculation.
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED_ADJUSTED_TURNS
Average Invested Capital Turns
Measures relationship between total capital invested in the firm and sales generated from that investment.
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED_YOY_DELTA
Change in Invested Capital
The difference between invested capital at the end of the current fiscal year and invested capital at the end of the previous fiscal year.
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED_YOY_DELTA_PERCENT
Invested Capital Growth
The percent difference between invested capital at the end of the current fiscal year and invested capital at the end of the previous fiscal year.
Metrics & Ratings: Invested Capital
CAPITAL_INVESTED_YOY_DELTA_PER_REVENUE_YOY_DELTA
Invested Capital Delta as % of Revenue Delta
Year over year change in Invested Capital as a percent of the year over change in Total Revenue.
Metrics & Ratings: Return on Invested Capital Averages
NOPAT_AVG_2
NOPAT 2-Year Average
2-Year Average NOPAT
Metrics & Ratings: Return on Invested Capital Averages
CAPITAL_INVESTED_ADJUSTED_AVG_2
Invested Capital 2-Year Average
2-Year Average of Average Invested Capital
Metrics & Ratings: Return on Invested Capital Averages
ROIC_AVG_2
ROIC 2-Year Average
2-Year Average ROIC
Metrics & Ratings: Return on Invested Capital Averages
NOPAT_AVG_3
NOPAT 3-Year Average
3-year Average NOPAT
Metrics & Ratings: Return on Invested Capital Averages
CAPITAL_INVESTED_ADJUSTED_AVG_3
Invested Capital 3-Year Average
3-Year Average of Average Invested Capital.
Metrics & Ratings: Return on Invested Capital Averages
ROIC_AVG_3
ROIC 3-Year Average
3-year Average ROIC
Metrics & Ratings: Return on Invested Capital Averages
NOPAT_AVG_4
NOPAT 4-Year Average
4-Year Average NOPAT
Metrics & Ratings: Return on Invested Capital Averages
CAPITAL_INVESTED_ADJUSTED_AVG_4
Invested Capital 4-Year Average
4-Year Average of Average Invested Capital
Metrics & Ratings: Return on Invested Capital Averages
ROIC_AVG_4
ROIC 4-Year Average
4-Year Average ROIC
Metrics & Ratings: Return on Invested Capital Averages
NOPAT_AVG_5
NOPAT 5-Year Average
5-Year Average NOPAT
Metrics & Ratings: Return on Invested Capital Averages
CAPITAL_INVESTED_ADJUSTED_AVG_5
Invested Capital 5-Year Average
5-Year Average of Average Invested Capital
Metrics & Ratings: Return on Invested Capital Averages
ROIC_AVG_5
ROIC 5-Year Average
5-Year Average ROIC
Metrics & Ratings: GAAP-Based Return on Invested Capital (ROIC)
NOPAT_GAAP
GAAP-Based NOPAT
NOPAT calculated based only on reported GAAP data from the financial statements. GAAP-Based NOPAT is what is generally provided by other data providers. This is compared to New Constructs' NOPAT, which is based on critical information from the MD&A and footnotes.
Metrics & Ratings: GAAP-Based Return on Invested Capital (ROIC)
CAPITAL_INVESTED_GAAP
GAAP-Based Invested Capital
Invested Capital calculated based only on reported GAAP data from the financial statements. GAAP-Based Invested Capital is what is generally provided by other data providers. This is compared to New Constructs' Invested Capital, which is based on critical information from the MD&A and footnotes.
Metrics & Ratings: GAAP-Based Return on Invested Capital (ROIC)
CAPITAL_INVESTED_ADJUSTED_GAAP
Average GAAP-Based Invested Capital
Average Invested Capital calculated based only on reported GAAP data from the financial statements. GAAP-Based Average Invested Capital is what is generally provided by other data providers. This is compared to New Constructs' Average Invested Capital, which is based on critical information from the MD&A and footnotes.
Metrics & Ratings: GAAP-Based Return on Invested Capital (ROIC)
ROIC_GAAP
GAAP-Based ROIC
Return on Invested Capital calculated based only on reported GAAP data from the financial statements. GAAP-Based NOPAT and Average Invested Capital is what is generally provided by other data providers. This is compared to New Constructs' NOPAT and Average Invested Capital, which are based on critical information from the MD&A and footnotes.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
NOPAT_GROSS
Gross NOPAT (Net Operating Profit After Tax)
Gross NOPAT is calculated like our regular NOPAT calculation but with depreciation and amortization expense added back.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
CAPITAL_INVESTED_GROSS
Gross Invested Capital
Gross Invested Capital is calculated like our regular Invested Capital calculation, but also includes accumulated depreciation and amortization. We use Average Gross Invested Capital as the denominator in our ROGIC calculation.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
CAPITAL_INVESTED_GROSS_ADJUSTED
Average Gross Invested Capital
Average Gross Invested Capital is calculated like our regular Average Invested Capital calculation, but also includes accumulated depreciation and amortization. We use Average Gross Invested Capital as the denominator in our ROGIC calculation.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
ROGIC
Return on Gross Invested Capital (ROGIC)
Return on Gross Invested Capital. Gross NOPAT divided by Average Gross Invested Capital. Gross NOPAT is calculated like our regular NOPAT calculation but with depreciation and amortization expense added back. Gross Invested Capital is calculated like our regular Invested Capital calculation, but also includes accumulated depreciation and amortization.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
ROGIC_YOY_DELTA
Change in ROGIC
Year over year change in Return on Gross Invested Capital.
Metrics & Ratings: Return on Gross Invested Capital (ROGIC)
CAPITAL_INCREMENTAL_RETURN_GROSS
Incremental Return on Gross Invested Capital
Incremental change in Gross NOPAT divided by the incremental change in Gross Invested Capital.
Metrics & Ratings: DCF Forecast Drivers
REVENUE_YOY_DELTA_PERCENT
Total Operating Revenue Growth
Revenue growth rate.
Metrics & Ratings: DCF Forecast Drivers
NOPBT_PER_REVENUE
NOPBT Margin
NOPBT Margin
Metrics & Ratings: DCF Forecast Drivers
CAPITAL_WORKING_NET_YOY_DELTA_PER_REVENUE_YOY_DELTA
Net Working Capital Delta as % of Revenue Delta/Net Investment Assets Delta as % of Revenue Delta
Year over year change in Net Working Capital as a percent of the year over year change in Total Operating Revenue
Metrics & Ratings: DCF Forecast Drivers
ASSETS_FIXED_ADJUSTED_YOY_DELTA_PER_REVENUE_YOY_DELTA
Fixed Adjusted Assets Delta as % of Revenue Delta
Year over year change in Total Adjusted Fixed Assets as a percent of the year over year change in Total Revenue.
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW
FCF (Free Cash Flow)
Equals NOPAT less incremental change in working capital less incremental change in fixed assets.
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW_YOY_DELTA
FCF (Free Cash Flow) Delta
Year over year change in a company's FCF (Free Cash Flow).
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW_YOY_DELTA_PERCENT
FCF (Free Cash Flow) Growth
Year over year percent change in a company's FCF (Free Cash Flow).
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW_YIELD
FCF Yield
Compares free cash flow to overall value.
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW_PER_CAPITAL_INVESTED
FCF as % of Invested Capital
Dollars of free cash flow generated for each dollar of invested capital.
Metrics & Ratings: Free Cash Flow
FREE_CASH_FLOW_PER_REVENUE
FCF as % of Total Revenue
Dollars of free cash flow generated for each dollar of revenue.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT
Economic Earnings
Represents the true cash flows available to equity investors.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_YOY_DELTA
Change in Economic Earnings
Measures the change in Economic Earnings year over year.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_PER_WABSO_SPLIT_ADJUSTED
Economic Earnings per Share
Economic Earnings per Basic Weighted Avg. Shares.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_PER_WABSO_SPLIT_ADJUSTED_YOY_DELTA_PERCENT
Economic Earnings per Share Growth
Measures the percent change in Economic Earnings per Basic Weighted Avg. Shares year over year.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_MARGIN
Economic Earnings Margin (ROIC - WACC)
The difference between a company's ROIC (Return On Invested Capital) and WACC (Weighted Average Cost of Capital).
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_PER_EQUITY_MARKET_VALUE
Economic Earnings per Market Value of Equity
Measures Economic Earnings relative to the Market Value of Basic Equity.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_YOY_DELTA_PER_EQUITY_MARKET_VALUE
Economic Earnings Delta per Market Value of Equity
Measures the change in Economic Earnings year over year divided by the Market Value of Basic Equity.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_MARGIN_AVG
Average Economic Earnings Margin
Average of Economic Earnings Margin (ROIC - WACC).
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_PER_WADSO_SPLIT_ADJUSTED
Economic Earnings per Diluted Share
Economic Earnings per Diluted Weighted Avg. Shares.
Metrics & Ratings: Economic Earnings
CAPITAL_INVESTED_ADJUSTED_TIMES_WACC
Capital Charge for Average Invested Capital
Invested Capital multiplied by the Weighted Average Cost of Capital.
Metrics & Ratings: Economic Earnings
ECONOMIC_PROFIT_PER_REVENUE_OPERATING
Economic Earnings as % of Revenue
Economic profit expressed as a percentage of total revenue
Metrics & Ratings: Price to Economic Book Value (PEBV)
STOCK_PRICE_SPLIT_ADJUSTED_PER_BOOK_VALUE_ECONOMIC_PER_SHARES_OUTSTANDING_SPLIT_ADJUSTED
PEBV (Price to Economic Book Value) per Share
Ratio of closing stock price to economic book value per share.
Metrics & Ratings: Price to Economic Book Value (PEBV)
BOOK_VALUE_ECONOMIC_PER_SHARES_OUTSTANDING_SPLIT_ADJUSTED
Economic Book Value (EBV) Per Share
Economic Book Value (EBV) per share.
Metrics & Ratings: Price to Economic Book Value (PEBV)
STOCK_PRICE_SPLIT_ADJUSTED
Stock Price (closing)
Closing stock price of a company's outstanding shares for a particular date.
Metrics & Ratings: Price to Economic Book Value (PEBV)
PVGO_PER_STOCK_PRICE_SPLIT_ADJUSTED
PVGO as % of Stock Price
% of PVGO implied by the current stock price.
Metrics & Ratings: Price to Economic Book Value (PEBV)
EQUITY_SHAREHOLDER_PER_SHARES_OUTSTANDING_SPLIT_ADJUSTED
Accounting Book Value per Share
Total Shareholders' Equity per Shares Outstanding.
Metrics & Ratings: Price to Economic Book Value (PEBV)
EQUITY_MARKET_VALUE_PER_EQUITY_SHAREHOLDER
Price to Accounting Book Value per Share
Market Value attributed to one common equity share of the firm.
Metrics & Ratings: Price to Economic Book Value (PEBV)
ENTERPRISE_VALUE_PER_CAPITAL_INVESTED
Enterprise Value Per Invested Capital
Enterprise Value compared to Invested Capital.
Metrics & Ratings: Price to Economic Book Value (PEBV)
ENTERPRISE_VALUE_PER_EBITDA
Enterprise Value Per EBITDA/Enterprise Value Per EBTDA
Enterprise Value compared to EBITDA.
Metrics & Ratings: Price to Economic Book Value (PEBV)
ENTERPRISE_VALUE_PER_REVENUE
Enterprise Value To Revenue
Enterprise Value compared to total revenues.
Metrics & Ratings: Price to Economic Book Value (PEBV)
STOCK_PRICE_SPLIT_ADJUSTED_PER_NOPAT_PER_SHARES_OUTSTANDING_SPLIT_ADJUSTED
Price to Unlevered NOPAT per Share
Ratio of closing stock price to NOPAT per share.
Metrics & Ratings: Price to Economic Book Value (PEBV)
PRICE_PER_EARNINGS
P/E (Price/Earnings Multiple)
P/E multiple.
Metrics & Ratings: Price to Economic Book Value (PEBV)
EQUITY_RETURN
Return on Equity
An accounting metric, no adjustments are made to this data point.
Metrics & Ratings: Price to Economic Book Value (PEBV)
DEBT_NET_OF_CASH_PER_EBITDA
Debt net of cash per EBITDA
Debt net of cash per EBITDA
Metrics & Ratings: Price to Economic Book Value (PEBV)
ROIC_PER_WACC
ROIC / WACC
ROIC divided by WACC.
Metrics & Ratings: Economic Book Value Components
ASSETS_DISCONTINUED_NET
Net Assets from Discontinued Operations
Net Assets from Discontinued Operations
Metrics & Ratings: Economic Book Value Components
DEFERRED_TAX_NET_ADJUSTED
Net Deferred Tax Liability
Net Deferred Tax Liability
Metrics & Ratings: Economic Book Value Components
ASSETS_DEFERRED_COMPENSATION_NET
Net Deferred Compensation Assets
Net Deferred Compensation Assets
Metrics & Ratings: Economic Book Value Components
ASSETS_FIXED_UNCONSOLIDATED_ADJUSTED
Fair Value of Unconsolidated Subsidiary Assets (non-operating)
Fair Value of Unconsolidated Subsidiary Assets (non-operating)
Metrics & Ratings: Economic Book Value Components
DEBT_ADJUSTED
Fair Value of Total Debt
Short-Term Debt and Long-Term Debt adjusted to fair value.
Metrics & Ratings: Economic Book Value Components
STOCK_PREFERRED_ADJUSTED
Fair Value of Preferred Capital
Dollar value of the preferred capital adjusted for fair value of preferred stock.
Metrics & Ratings: Economic Book Value Components
INTEREST_MINORITY_ADJUSTED
Fair Value of Minority Interests
Carrying value of minority interests adjusted to fair value.
Metrics & Ratings: Economic Book Value Components
PENSION_FUNDED_STATUS_ADJUSTED
Pensions Net Funded Status
Funded status of pension plans.
Metrics & Ratings: Economic Book Value Components
BOOK_VALUE_ECONOMIC_PER_EQUITY_MARKET_VALUE
EBV-to-Price Ratio
The EBV-to-Price Ratio measures the relationship between the no-growth value of the stock and the market’s expectations for future profits.
Metrics & Ratings: Economic Book Value Components
SHARES_OUTSTANDING
Shares Outstanding (not split-adjusted)
Latest updated outstanding common shares value.
Metrics & Ratings: Economic Book Value Components
ESO_TRANCHE_VALUE_AFTER_TAX
Value of Outstanding ESO After-Tax
The after-tax fair market value of ESOs net of assumed options cancelled.
Metrics & Ratings: Cash Conversion Ratios
DAYS_REVENUE_OUTSTANDING
Days Revenue Outstanding
Measures the number of days that a company takes to collect revenue after a sale is made.
Metrics & Ratings: Cash Conversion Ratios
DAYS_IN_INVENTORY
Days in Inventory
Measures the number of days that a company takes to turn its inventory into sales.
Metrics & Ratings: Cash Conversion Ratios
DAYS_IN_ACCOUNTS_PAYABLE
Days in Accounts Payable
Measures the number of days that a company takes to pay its suppliers.
Metrics & Ratings: Cash Conversion Ratios
DAYS_IN_REVENUE_DEFERRED
Days in Deferred Revenue
Measures the number of days that a company takes to recognize deferred revenue.
Metrics & Ratings: Cash Conversion Ratios
CASH_CONVERSION_CYCLE
Cash Conversion Cycle
Measures the amount of time between a company spending cash and receiving cash per each sale, output, unit of operation, etc.
Metrics & Ratings: Cash Conversion Ratios
INVENTORY_TURNOVER
Inventory Turnover
Inventory Turnover
Metrics & Ratings: DCF Metrics
CORPORATE_VALUE
Corporate Value
The calculated present value of future free cash flows from the business entity's core operations.
Metrics & Ratings: DCF Metrics
SHAREHOLDER_VALUE
Shareholder Value
The value of the firm available to common shareholders.
Metrics & Ratings: DCF Metrics
SHAREHOLDER_VALUE_PER_SHARES_OUTSTANDING_SPLIT_ADJUSTED
Shareholder Value per Share
Shareholder Value per Shares Outstanding.
Metrics & Ratings: DCF Metrics
GAP
GAP (Growth Appreciation Period)
Growth Appreciation Period or “GAP” is the length of time a company can be expected to earn high returns before competition forces returns to decrease to an average rate. In other words, GAP is the period a company’s ROIC will be higher than the average return on capital.
Metrics & Ratings: DCF Metrics
FREE_CASH_FLOW_PRESENT_VALUE
FCF Present Value
Present value of FCF (Free Cash Flow).
Metrics & Ratings: DCF Metrics
FREE_CASH_FLOW_PRESENT_VALUE_ACCUMULATED
FCF Cumulative Present Value
Accumulated present value of FCF (Free Cash Flow).
Metrics & Ratings: Ratings
RATING_GAP
Rating: GAP (Growth Appreciation Period)
Our GAP (Growth Appreciation Period) rating is based on the number of years of future profit growth required to justify the current valuation of the stock. We assign ratings as follows: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on.
Metrics & Ratings: Ratings
RATING_INCOME_NET_ECONOMIC_PROFIT
Rating: Economic vs Reported EPS
Our Economic vs Reported EPS rating compares reported accounting income to the economic earnings of the company. We assign ratings as follows: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on.
Metrics & Ratings: Ratings
RATING_OVERALL
Rating: Overall Risk/Reward Rating
We assign an overall rating to every stock under coverage: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on. The overall rating is based on 5 component metrics that are also assigned a rating between 1 and 5: Economic vs Reported EPS, ROIC (Return on Invested Capital), FCF Yield, Price-to-Economic Book Value, and GAP (Growth Appreciation Period).
Metrics & Ratings: Ratings
RATING_ROIC
Rating: ROIC (Return on Invested Capital)
Our Return on Invested Capital (ROIC) rating is based on the aggregate cash on cash returns of the company. We assign ratings as follows: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on.
Metrics & Ratings: Ratings
RATING_PRICE_TO_EBV_RATIO
Rating: Price-to-EBV Ratio
Our Price-to-Economic Book Value rating is based on the growth expectations embedded in the stock price. We assign ratings as follows: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on.
Metrics & Ratings: Ratings
RATING_FCF_YIELD
Rating: FCF Yield
Our Free Cash Flow Yield rating is based on the true cash yield of the company. We assign ratings as follows: Most Attractive (best rating), Attractive, Neutral, Dangerous, Very Dangerous (worst rating), 1 being Most Attractive, 2 being Attractive, and so on.
Metrics & Ratings: WACC
BETA
Adjusted Beta
Beta
Metrics & Ratings: WACC
BETA_CURRENT
Beta Adjusted
Current Beta
Metrics & Ratings: WACC
DEBT_AFTER_TAX_COST_WEIGHTED
Weighted Cost of Debt After Tax
A component of WACC (Weighted Average Cost of Capital).
Metrics & Ratings: WACC
DEBT_COST
Cost of Debt
Cost of debt before tax.
Metrics & Ratings: WACC
DEBT_COST_AFTER_TAX
Cost of Debt After Tax
Cost of debt after tax.
Metrics & Ratings: WACC
DEBT_PER_CAPITAL_ADJUSTED
Debt Per Total Adjusted Capital
A measure of a company's financial leverage.
Metrics & Ratings: WACC
CAPITAL_EQUITY_COST_ADJUSTED_WEIGHTED
Weighted Cost of Equity Capital
A component of WACC (Weighted Average Cost of Capital).
Metrics & Ratings: WACC
EQUITY_RISK_PREMIUM
Equity Risk Premium
A component of the Cost of Equity.
Metrics & Ratings: WACC
RISK_FREE_RATE
Risk-Free Rate
Current risk-free rate for the 30-year U.S. treasury bond.
Metrics & Ratings: WACC
CAPITAL_MARKET_ADJUSTED
Total Adjusted Capital
Market Value of the Firm calculated from the fair value of a firm's debt, current stock price, and current shares outstanding.
Metrics & Ratings: WACC
CAPITAL_PREFERRED_COST
Cost of Preferred Capital
The cost of preferred capital.
Metrics & Ratings: WACC
WACC
WACC (Weighted Average Cost of Capital)
WACC (Weighted Average Cost of Capital)
Metrics & Ratings: WACC
WACC_MOST_RECENT_PE_DATE
WACC (Weighted Average Cost of Capital)
Weighted-Average Cost of Capital (WACC) on the period end date of the most recent filing.
Metrics & Ratings: WACC
EQUITY_PER_CAPITAL_ADJUSTED
Equity Per Total Adjusted Capital
Market value of basic equity compared to Adjusted Capital.
Metrics & Ratings: WACC
EQUITY_COST
Cost of Equity
The return a firm theoretically pays to its shareholders, to compensate for the risk they undertake by investing their capital.

Excel Add-In: Fundamental Data Errors

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