Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

Note:
All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog

3/10/2011

Datastream - company accounts database

The Datastream menu shows three large databases: static request, time series and company accounts.
The latter enables the user to select particular parts from the balance sheet, thus saving time selecting data types from the data type menu.




This item highlights those very data types and so illustrates the specific parts of the balance sheet. Unfortunately this blog does not permit adding Excell documents.

BALANCE SHEET INCOME STATEMENT

WC01001 NET SALES OR REVENUES
WC01051 COST OF GOODS SOLD (EXCL DEPRECIATION)
WC01151 DEPRECIATION, DEPLETION AND AMORTIZATION
WC01100 GROSS INCOME
WC01101 SELLING, GENERAL & ADMINISTRATIVE EXPENSES
WC01249 OPERATING EXPENSES - TOTAL
WC01250 OPERATING INCOME
WC01253 EXTRAORDINARY CREDIT - PRETAX
WC01254 EXTRAORDINARY CHARGE - PRETAX
WC01266 NON-OPERATING INTEREST INCOME
WC18191 EARNINGS BEFORE INTEREST AND TAXES (EBIT)
WC01251 INTEREST EXPENSE ON DEBT
WC01255 INTEREST CAPITALIZED
WC01401 PRETAX INCOME
WC01451 INCOME TAXES
WC01501 MINORITY INTEREST
WC01551 NET INCOME BEFORE EXTRA ITEMS/PREFERRED DIVIDENDS
WC01601 EXTRA ITEMS & GAIN/LOSS SALE OF ASSETS
WC01651 NET INCOME BEFORE PREFERRED DIVIDENDS
WC01701 PREFERRED DIVIDEND REQUIREMENTS
WC01751 NET INCOME AVAILABLE TO COMMON
WC01001F NET SALES OR REVENUES
WC01266F NON-OPERATING INTEREST INCOME

DATA YPE BALANCE SHEET ASSETS

WC05350 DATE OF FISCAL YEAR END
WC02001 CASH & SHORT TERM INVESTMENTS
WC02003 CASH
WC02051 RECEIVABLES(NET)
WC02101 INVENTORIES - TOTAL
WC02201 CURRENT ASSETS - TOTAL
WC02250 OTHER INVESTMENTS
WC02501 PROPERTY, PLANT AND EQUIPMENT - NET
WC02649 TOTAL INTANGIBLE OTHER ASSETS - NET
WC02999 TOTAL ASSETS
WC02250F OTHER INVESTMENTS
WC02999F TOTAL ASSETS
WC01266 NON-OPERATING INTEREST INCOME
WC01251 INTEREST EXPENSE ON DEBT
WC01266 NON-OPERATING INTEREST INCOME
WC01255 INTEREST CAPITALIZED
WC01201 RESEARCH & DEVELOPMENT
WC01084 SALARIES AND BENEFITS EXPENSES
WC01253 EXTRAORDINARY CREDIT - PRETAX
WC01254 EXTRAORDINARY CHARGE - PRETAX
WC01401 PRETAX INCOME
WC01451 INCOME TAXES
WC01401 PRETAX INCOME
WC01451 INCOME TAXES
WC01501 MINORITY INTEREST
WC01601 EXTRA ITEMS & GAIN/LOSS SALE OF ASSETS
WC01701 PREFERRED DIVIDEND REQUIREMENTS
WC01551 NET INCOME BEFORE EXTRA ITEMS/PREFERRED DIVIDENDS
WC01701 PREFERRED DIVIDEND REQUIREMENTS
WC18192 DIVIDENDS PROVIDED FOR OR PAID - COMMON
WC18191 EARNINGS BEFORE INTEREST AND TAXES (EBIT)
WC18198 EBIT & DEPRECIATION
WC01706 NET INCOME USED TO CALCULATE BASIC EARNINGS PER SHARE
WC01705 NET INCOME USED TO CALCULATE DILUTED EARNINGS PER SHARE
WC01751 NET INCOME AVAILABLE TO COMMON
WC07011 EMPLOYEES
WC01001F NET SALES OR REVENUES
WC01266F NON-OPERATING INTEREST INCOME
WC01266F NON-OPERATING INTEREST INCOME
WC07011F EMPLOYEES

DATA TYPE BALANCE SHEET LIABILITIES

WC03040 ACCOUNTS PAYABLE
WC03051 SHORT TERM DEBT & CURRENT PORTION OF LONG TERM DEBT
WC03101 CURRENT LIABILITIES - TOTAL
WC03251 LONG TERM DEBT
WC03263 DEFERRED TAXES
WC03351 TOTAL LIABILITIES
WC03426 MINORITY INTEREST
WC03451 PREFERRED STOCK
WC03501 COMMON EQUITY
WC03480 COMMON STOCK
WC03999 TOTAL LIABILITIES & SHAREHOLDERS' EQUITY
WC03263F DEFERRED TAXES
WC03480F COMMON STOCK
WC03101 CURRENT LIABILITIES - TOTAL
WC03151 WORKING CAPITAL
WC03251 LONG TERM DEBT
WC03255 TOTAL DEBT
WC03255 TOTAL DEBT
WC02001 CASH & SHORT TERM INVESTMENTS
WC03263 DEFERRED TAXES
WC03426 MINORITY INTEREST
WC03480 COMMON STOCK
WC03501 COMMON EQUITY
WC03480 COMMON STOCK
WC03501 COMMON EQUITY
WC03451 PREFERRED STOCK
WC03998 TOTAL CAPITAL
WC02999F TOTAL ASSETS
WC03263F DEFERRED TAXES
WC03480F COMMON STOCK
WC03480F COMMON STOCK

DATA TYPE CASH FLOW KEY ITEMS


WC06026 NATION
WC05350 DATE OF FISCAL YEAR END
WC04201 FUNDS FROM OPERATIONS
WC04860 NET CASH FLOW - OPERATING ACTIVITIES
WC04050 AMORTIZATION OF INTANGIBLE ASSETS
WC04601 CAPITAL EXPENDITURES (ADDITIONS TO FIXED ASSETS)
WC04870 NET CASH FLOW - INVESTING
WC05376 COMMON DIVIDENDS (CASH)
WC04551 CASH DIVIDENDS PAID - TOTAL
WC04251 NET PROCEEDS FROM SALE/ISSUE OF COMMON & PREFERRED
WC04890 NET CASH FLOW - FINANCING
WC04890 NET CASH FLOW - FINANCING
WC04870 NET CASH FLOW - INVESTING
WC04860 NET CASH FLOW - OPERATING ACTIVITIES
WC04851 INCREASE/DECREASE IN CASH AND SHORT TERM INVESTMENTS

DATA TYPE KEY ACCOUNTS RATIOS

WC06026 NATION
WC05350 DATE OF FISCAL YEAR END
WC08301 RETURN ON EQUITY - TOTAL (%)
WC08376 RETURN ON INVESTED CAPITAL
WC08316 OPERATING PROFIT MARGIN
WC08321 PRETAX MARGIN
WC08366 NET MARGIN
WC08311 CASH FLOW/SALES
WC01401 PRETAX INCOME
WC01251 INTEREST EXPENSE ON DEBT
WC08126 INVENTORIES - DAYS HELD
WC08131 ACCOUNTS RECEIVABLES DAYS
WC03040 ACCOUNTS PAYABLE
WC01001 NET SALES OR REVENUES
WC01250 OPERATING INCOME
WC01151 DEPRECIATION, DEPLETION AND AMORTIZATION
WC08221 TOTAL DEBT % TOTAL CAPITAL & SHORT TERM DEBT
WC08106 CURRENT RATIO
WC08101 QUICK RATIO
WC08231 TOTAL DEBT % COMMON EQUITY
WC01001F NET SALES OR REVENUES

The list is based on output from Microsoft Corp.
A Dutch company like Koninklijke Ahold provides significantly less data types.

No comments:

Post a Comment