Quarterly Data Field Definitions |
|
Quarterly Data Field Definitions |
|
Fundamental Data Provided by Morningstar, Inc.
© 2009 Morningstar, Inc. All Rights Reserved. The information contained herein: (1) is proprietary to Morningstar; (2) may not be copied or distributed; and (3) is not warranted to be accurate, complete or timely. Neither Morningstar nor its content providers are responsible for any damages or losses arising from any use of this information. Past performance is no guarantee of future results.
The name of the company as given on the latest annual report. Maximum of 30 characters.
Year and month of the fiscal quarter end. Format is yyyy/mm.
Number of the fiscal quarter (1 through 4).
The company’s ticker symbol on the primary exchange where the security is traded.
The primary U.S. exchange that the security trades on. Reported as an abbreviation.
Abbreviation NYSE AMEX NASDAQ CM NASDAQ GM NASDAQ GS NASDAQ OTC |
Exchange New York Stock Exchange American Stock Exchange NASDAQ Capital Market NASDAQ Global Market NASDAQ Global Select NASDAQ OTC Bulletin Board |
The company’s primary Standard Industrial Classification System (SIC) code.
The company’s primary North American Industry Classification System (NAICS) code.
The state or province where the company’s headquarters are located. Reported as a two letter postal code.
The region where the company’s headquarters are located, as defined by the United States Census Bureau. See Definitions of Geographic Areas.
The division where the company’s headquarters are located, as defined by the United States Census Bureau. See Definitions of Geographic Areas.
Other geographic area, in addition to the United States Census Bureau’s regions and divisions, where the company’s headquarters are located. See Definitions of Geographic Areas.
The name of the company as given on the latest annual report. Maximum of 100 characters.
Brief summary of the company’s business. Maximum of 50 characters.
Description of the company’s business. Maximum of 256 characters.
Cash on hand. Typical accounts include:
•Cash
•Bullion (except for gold and silver making companies)
Amounts owed to the company, net of any provision for bad debts. Typical accounts include:
•Accounts receivable
•Notes receivable
•Trade receivables
•Accrued receivables
•Unbilled costs and estimated earnings on contracts in progress
•Amount due from unconsolidated subsidiaries
•Money due from sales of debentures
•Unbilled shipments
•Amounts due from officers and employees (when listed as a current asset)
•Commercial paper listed by subsidiaries to parent company
•Store property covered by investors commitments to purchase
Merchandise bought for resale, or supplies and raw materials purchased for use in revenue producing operations.
Plug value calculated using the following formula:
= Total Current Assets - Cash & Equivalents - Receivables - Inventories
Total assets convertible into cash within a relatively short period of time, usually one year.
Original purchase price of the fixed assets.
Accumulated Depreciation is the accumulated amount of wear and tear or obsolescence charged against the fixed assets of a company. Accumulated Depletion is a reserve set up to compensate for the reduction in value of a natural resource as it is exhausted or depleted.
Assets that are of a relatively permanent nature and are not intended for resale, such as property, plant and equipment. Stated as cost minus accumulated depreciation and amortization.
Assets that are neither physical nor financial in nature but have value to the company, net of accumulated amortization. Typical accounts include:
•Goodwill
•Patents
•Trademarks
•Copyrights
•Licenses
•Franchises
•Excess of cost over net tangible assets required
•Intangible assets
Plug value calculated using the following formula:
= Total Non-Current Assets - Net Fixed Assets - Intangibles
Total amount of long-term assets, including Net Fixed Assets, Intangibles, and any other non-current assets.
Total amount of current and non-current assets.
Amounts owed to suppliers for goods or services purchased on credit that must be paid within 12 months. Typical accounts include:
•Accounts payable
•Trade notes payable
Borrowings, both principal and interest, that must be paid in the near future (usually one year). Typical accounts include:
•Current portion of long-term debt
•Port of long-term debt payable within one year
•Current bank notes payable
•Current notes payable (non-trade)
•Short-term debt
•Current commercial paper owed
•Interim debt
Plug value calculated using the following formula:
= Total Current Liabilities - Accounts Payable - Short-Term Debt
Total liabilities that must be repaid with a relatively short period of time, usually one year.
Borrowings due more than one year after the date of the balance sheet. Typical accounts include:
•Long-term debt
•Long-term obligations
•Non-current notes payable
•Bonds, debentures, mortgages, etc.
•Term obligations
•Current maturities intended to be refinanced
•Convertible subordinated debentures
•Unsecured term notes
•Mortgages payable
•First mortgage bonds
•Mortgage notes and contracts payable
•Installment notes
•Long term leases (an alternative to ownership and bond financing)
Plug value calculated using the following formula:
= Total Non-Current Liabilities - Long-Term Debt
Total amount of long-term liabilities, including Long-Term Debt and any other non-current liabilities.
Total amount of current and non-current liabilities.
Shareholders equity attributed to preferred stock.
Shareholders equity attributed to common stock. Generally consists of the following items:
•Common stock (all issues) at par value.
•Capital surplus or additional paid-in capital.
•Retained earnings or earned surplus (net of foreign exchange gains and losses).
Preferred Stock plus Common Stock.
Total Liabilities plus Total Equity.
Net sales and any other revenues from the main operations of the business, or those amounts labeled as operating revenues. Does not include dividends, interest income or nonoperating income and is reported after any adjustments. For financial institutions, Operating Revenue equals interest income plus non-interest income.
Total of all revenues as reported by the company. Amount is a subtotal and does not figure into the balancing of the income statement.
For most non-financial companies, especially those in the tobacco, liquor, and firearm industries, Adjustments to Revenue typically includes taxes, particularly excise taxes, which the company collects on behalf of the government. For financial institutions, Adjustments to Revenue includes all expenses other than interest expense and income taxes.
Expenses directly associated with the production of goods or services, such as material and overhead, excluding depreciation, depletion, amortization, and selling, general and administrative expenses. Typical accounts include:
•Cost of goods sold
•Materials and production expenses
•Gas purchased
•Fuel and power purchased
•Exploration and well drilling expense
•Mining expenses
•Oil and gas property abandonments, includes dry holes if not specified
•Other operating expenses for utilities and railroad maintenance
When the depreciation figures on the Income Statement and Cash Flow Statement differ, Cost of Goods Sold is adjusted as follows:
Cost of Goods Sold |
+ Depreciation from Income Statement |
- Depreciation from Cash Flow Statement |
= Adjusted Cost of Goods Sold |
Plug value calculated using the following formula:
= Operating Profit - Adjustments to Revenue - Cost of Goods Sold - Operating Profit
Operating Revenue less Adjustments to Revenue less Cost of Goods Sold less any other relevant expenses or adjustments not otherwise accounted for.
Costs of research aimed at discovering new facts, natural laws, or phenomena without regard to the immediate commercial application to which the results may be applied. Also includes costs of research toward more specific goals, such as product improvement or the improvement of production processes and techniques. Development costs are associated with turning research results into commercial applications. Typical accounts include:
•Research & Development expense
•Engineering & Development expense
•In-process R&D
All salaries, indirect production, marketing and general corporation expenses, including advertising. Typical accounts include:
•All provisions for doubtful accounts/losses
•Commissions
•Contributions to pension plans
•Corporate expenses
•Delivery
•Distribution
•Dry holes (oil and gas companies), if specified
•Employee benefits
•Employee profit sharing
•Marketing maintenance, except for utilities and railroads
•Payroll
•Rent
•Selling, general, administrative
•Storage and delivery
•Advertising, including any line items beginning with “advertising”
Plug value calculated using the following formula:
= Operating Profit - Research & Development - Selling, General & Administrative - EBITDA
Earnings Before Interest, Taxes, Depreciation & Amortization. Operating Profit less Research & Development less Selling, General & Administrative less any other relevant expenses or adjustments not otherwise accounted for.
Depreciation represents the reduction in the value of fixed assets due to wear, age, or obsolescence. Amortization applies to leased property, intangibles, and goodwill. Also includes depletion.
Please Note: The amount reported here is taken from the company’s Cash Flow Statement.
Plug value calculated using the following formula:
= EBITDA - Depreciation & Amortization - Operating Income
EBITDA less Depreciation & Amortization less any other relevant expenses or adjustments not otherwise accounted for.
Income generated from interest-bearing deposits or accounts. Earnings from stock ownership in other companies; can be a loss or gain. Any income or expense which does not readily fit into any previously defined categories; a residual account into which miscellaneous non-operating revenues and expenses are netted. Typical accounts include:
•Other income
•Other expenses
•Royalty income, except for royalty companies
•Interest income
•Dividend income
•Gain or loss from joint venture
•Idle plan expenses
•Equity in earnings of unconsolidated subsidiaries
•Foreign exchange adjustments
•Allowance for funds used during construction
•Miscellaneous income or expense
•Liquidation, vacancy, and store closing costs
•Allowance for borrowed funds used instead of netting out interest
•Settlement of contracts
•Gain or loss on sale of properties if such transactions are a normal part of doing business
Earnings or losses that are either infrequent or unusual.
Plug value calculated using the following formula:
= Operating Income + Other Income (Loss) + Special Income (Loss) - EBIT
Earnings Before Interest and Taxes. Income after depreciation, adjusted for interest income, other income, net of any special income or charges, but before subtracting interest expense and taxes.
Fixed interest expenses net of capitalized interest. Also includes dividends on preferred stock of unconsolidated subsidiaries, if any.
Earnings Before Taxes. EBIT less interest expense, but before subtracting income taxes.
Taxes on income, net of any investment tax credits.
Plug value calculated using the following formula:
= Pretax Income - Income Taxes - Net Income from Continuing Operations
Income before preferred dividends, extraordinary gains and losses, income from cumulative effects of accounting change, non-recurring items, income from tax loss carryforward, and other gains and losses.
Income from operations sold or discontinued during the accounting period. Does not include extraordinary gains and losses.
Income from total operations, continuing and discontinued, after taxes and minority interest and before extraordinary gains and losses.
Plug value calculated using the following formula:
= Total Net Income - Net Income from Total Operations
Net Income from Total Operations plus all other income or charges (extraordinary, accounting changes, tax loss carryforward, and other gains and losses).
Sum of the last four quarters of Operating Revenue.
Sum of the last four quarters of Total Revenues.
Sum of the last four quarters of Adjustments to Revenue.
Sum of the last four quarters of Cost of Goods Sold.
Plug value calculated using the following formula:
= TTM Operating Profit Adjustment |
Sum of the last four quarters of Operating Profit.
Sum of the last four quarters of Research & Development.
Sum of the last four quarters of Selling, General & Administrative.
Plug value calculated using the following formula:
= TTM EBITDA Adjustment |
Sum of the last four quarters of EBITDA.
Sum of the last four quarters of Depreciation & Amortization.
Plug value calculated using the following formula:
= TTM EBITDA - TTM Depreciation & Amortization - TTM Operating Income
Sum of the last four quarters of Operating Income.
Sum of the last four quarters of Other Income (Loss).
Sum of the last four quarters of Special Income (Loss).
Plug value calculated using the following formula:
= TTM Operating Income + TTM Other Income (Loss) + TTM Special Income (Loss) - TTM EBIT
Sum of the last four quarters of EBIT.
Sum of the last four quarters of Interest Expense.
Sum of the last four quarters of Pretax Income.
Sum of the last four quarters of Income Taxes.
Plug value calculated using the following formula:
= TTM Pretax Income - TTM Income Taxes - TTM Net Income from Continuing Operations
Sum of the last four quarters of Net Income from Continuing Operations.
Sum of the last four quarters of Net Income from Discontinued Operations.
Sum of the last four quarters of Net Income from Total Operations.
Plug value calculated using the following formula:
= TTM Total Net Income - TTM Net Income from Total Operations
Sum of the last four quarters of Total Net Income.
Last four quarters of Net Income from Total Operations minus preferred dividends plus Depreciation & Amortization.
Year-to-date cash from ongoing business operations.
Year-to-date cash from operations sold or discontinued.
Year-to-date cash from all operations, continuing and discontinued.
Year-to-date net cash from sales and investments in property, plant, and equipment.
Growth in Operating Revenue since the same quarter of the previous fiscal year.
Growth in Operating Revenue since the same quarter three fiscal years ago.
Growth in Operating Revenue since the same quarter five fiscal years ago.
Growth in Total Revenues since the same quarter of the previous fiscal year.
Growth in Total Revenues since the same quarter three fiscal years ago.
Growth in Total Revenues since the same quarter five fiscal years ago.
Growth in Operating Profit since the same quarter of the previous fiscal year.
Growth in Operating Profit since the same quarter three fiscal years ago.
Growth in Operating Profit since the same quarter five fiscal years ago.
Growth in EBITDA since the same quarter of the previous fiscal year.
Growth in EBITDA since the same quarter three fiscal years ago.
Growth in EBITDA since the same quarter five fiscal years ago.
Growth in EBIT since the same quarter of the previous fiscal year.
Growth in EBIT since the same quarter three fiscal years ago.
Growth in EBIT since the same quarter five fiscal years ago.
Growth in Operating Income since the same quarter of the previous fiscal year.
Growth in Operating Income since the same quarter three fiscal years ago.
Growth in Operating Income since the same quarter five fiscal years ago.
Growth in Total Net Income since the same quarter of the previous fiscal year.
Growth in Total Net Income since the same quarter three fiscal years ago.
Growth in Total Net Income since the same quarter five fiscal years ago.
Growth in Cash from Continuing Operations since the same quarter of the previous fiscal year.
Growth in Cash from Continuing Operations over since the same quarter three fiscal years ago.
Growth in Cash from Continuing Operations over since the same quarter five fiscal years ago.
Growth in Cash from Operations since the same quarter of the previous fiscal year.
Growth in Cash from Operations since the same quarter three fiscal years ago.
Growth in Cash from Operations since the same quarter five fiscal years ago.
Growth in Capital Investment since the same quarter of the previous fiscal year.
Growth in Capital Investment since the same quarter three fiscal years ago.
Growth in Capital Investment since the same quarter five fiscal years ago.
Growth in TTM Operating Revenue since the same four quarters one year ago.
Growth in TTM Operating Revenue since the same four quarters three years ago.
Growth in TTM Operating Revenue since the same four quarters five years ago.
Growth in TTM Total Revenues since the same four quarters one year ago.
Growth in TTM Total Revenues since the same four quarters three years ago.
Growth in TTM Total Revenues since the same four quarters five years ago.
Growth in TTM Operating Profit since the same four quarters one year ago.
Growth in TTM Operating Profit since the same four quarters three years ago.
Growth in TTM Operating Profit since the same four quarters five years ago.
Growth in TTM EBITDA since the same four quarters one year ago.
Growth in TTM EBITDA since the same four quarters three years ago.
Growth in TTM EBITDA since the same four quarters five years ago.
Growth in TTM EBIT since the same four quarters one year ago.
Growth in TTM EBIT since the same four quarters three years ago.
Growth in TTM EBIT since the same four quarters five years ago.
Growth in TTM Operating Income since the same four quarters one year ago.
Growth in TTM Operating Income since the same four quarters three years ago.
Growth in TTM Operating Income since the same four quarters five years ago.
Growth in TTM Total Net Income since the same four quarters one year ago.
Growth in TTM Total Net Income since the same four quarters three years ago.
Growth in TTM Total Net Income since the same four quarters five years ago.
Trailing twelve month earnings from total operations, excluding extraordinary items, divided by common stock equity, expressed as a percentage:
= (TTM Net Income from Total Operations / Common Stock) x 100
Average Return on Equity over the last five years.
Trailing twelve month earnings from total operations, excluding extraordinary items, divided by total assets, expressed as a percentage:
= (TTM Net Income from Total Operations / Total Assets) x 100
Average Return on Assets over the last five years.
Trailing twelve month revenue divided by average total assets:
= TTM Operating Revenue / ((Previous Year Total Assets + Current Year Total Assets ) / 2)
Average Asset Turnover over the last five years.
Trailing twelve month cost of goods sold divided by average inventories:
= TTM Cost of Goods Sold / ((Previous Year Inventories + Current Year Inventories) / 2)
Average Inventory Turnover over the last five years.
Operating revenue minus cost of goods sold, divided by operating revenue, on a trailing twelve month basis, expressed as a percentage:
= ((TTM Operating Revenue - TTM Cost of Goods Sold) / TTM Operating Revenue) x 100
Average Gross Profit Margin over the last five years.
Pretax income divided by operating revenue, on a trailing twelve month basis, expressed as a percentage:
= (TTM Pretax Income / TTM Operating Revenue) x 100
Average Pre-Tax Profit Margin over the last five years.
Income from operations divided by operating revenue, on a trailing twelve month basis, expressed as a percentage.
= (TTM Net Income from Total Operations / TTM Operating Revenue) x 100
Average Net Profit Margin over the last five years.
Fiscal quarter closing price divided by trailing twelve month earnings per share from total operations (not including extraordinary items).
Average Price / TTM Earnings over the last five years.
Growth in Price / Earnings since the same quarter of the previous fiscal year:
= (Current PE – PE One Year Ago) / PE One Year Ago
Average P / E Growth over the last five years.
Closing share price on the last trading day of the fiscal year divided by trailing twelve month revenue per share.
Average Price / Revenue over the last five years.
Closing share price on the last trading day of the fiscal year divided by trailing twelve month cash flow per share.
Average Price / TTM Cash Flow over the last five years.
Closing share price on the last trading day of the fiscal year divided by the book value per share.
Average Price / Equity over the last five years.
Short-term debt plus long-term debt divided by common equity.
Average Debt / Equity over the last five years.