Standard & Poor’s Compustat User’s Guide

[Pages:1011]Standard & Poor's

Compustat?

User's Guide

Copyright ? 2003 The McGraw-Hill Companies, Inc. All rights reserved. Compustat is a registered trademark of The McGraw-Hill Companies, Inc. Thomson I/B/E/S is a registered trademark of Thomson Financial The product described in this document is furnished under a license agreement. The information contained in this document is intended solely for the use of clients of Standard & Poor's and may not be photocopied or distributed to third parties unless authorized under the license agreement. Information contained in this document is subject to change without notice. Standard & Poor's assumes no responsibility or liability for any errors or omissions or for results obtained from use of such information.

7400 S. Alton Court Centennial, Colorado 80112-2394 Customer Support U.S. and Canada 800.523.4534 Mexico 01.800.288.2872; then dial 800.523.4534 International 44.20.7826.8580

August 2003

Standard & Poor's Compustat North America User's Guide

Introduction

i

What is Standard & Poor's Compustat? North America data?

1

Industrial Files

2

Merged Industrial Research File

3

Industrial BackData File

3

Canadian File

4

Compustat Business Information File

4

Business Descriptions File

6

Daily Fundamentals

6

Daily Prices

6

Index Fundamentals

6

Pre-2001 S&P Classifications (Economic & Industry Sector File)

6

Name & Address File

7

Perm Number/CUSIP Cross Reference File

7

Trends & Projections

7

Value/Growth File

7

Compustat Prices, Dividends and Earnings (PDE) File

7

Compustat Prices, Dividends and Earnings (PDE) Research File

8

Compustat Bank

8

Compustat Utility

8

Sources of Data

9

Compustat Documentation

10

What's in this Guide?

10

Customer Support

11

Important Telephone Numbers

11

Ordering Compustat Products

12

Production Schedule

12

Subscription Agreement

13

Understanding the Compustat North America Database

i

In this chapter...

1

Data Retrieval Techniques

1

Screening for Financial Criteria

1

Selecting Companies

1

Selecting Individual Companies

1

Selection by Specific Groups

2

Terminology

3

Accessing Annual Data

6

Calendar Year Data

6

New Data Years

6

Accessing Quarterly Data

6

New Data Quarters

6

Fiscal Quarters

6

Calendar Quarters

7

8/2003

Table of Contents

i

Historical and Restated Annual Data

Restated Quarterly Data

Specific Uses for Compustat North America

Specific Uses for the Compustat Prices, Dividends and Earnings (PDE) File

Specific Uses for the Compustat Business Information File Segment Classifications

Compustat Business Information Files Segment NAICS File NAICS Reference File Codes Reference File of SIC Codes

Database Comparability

Annual Compustat to Compustat Utility and Compustat Bank

Quarterly Compustat to Compustat Utility and Compustat Bank

Financial Formulas

In this chapter...

Formulas Used in Financial Calculations Statements of Changes in Financial Position (Total $) Cash Flow ($ millions) Statements of Changes in Financial Position ($ per Share) Capital Expenditures Cash Flow Equity in Earnings per Share Income Statement (Total $) Cash Flow ($ millions) Preferred Dividend Coverage Pretax Income Available for Interest Tax Rate Income Statement ($ per Share) Cash Flow Depreciation and Amortization Discontinued Operations Earnings per Share (Diluted) Earnings per Share (Basic) Equity in Earnings Extraordinary Items Extraordinary Items and Discontinued Operations Interest Expense Labor and Related Costs Nonoperating Income (Expense) Operating Income After Depreciation Operating Income Before Depreciation Operating Income Before Depreciation (Restated) Pension Expense Pretax Income Research and Development Expense Sales (Net) Operating Margins (Item) as a % of sales Cash Flow Margin

ii

Compustat North America User's Guide

8

9

12

13

14 14 16 19 20 20

20

21

44

i

1

1 1 1 2 2 2 3 3 3 3 3 3 3 3 4 4 4 4 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 8

8/2003

Net Profit Margin (After-tax Profit Margin)

8

Operating Profit Margin After Depreciation

8

Operating Profit Margin Before Depreciation

8

Pretax Profit Margin

9

Balance Sheet (Total $ Millions)

9

Gross Assets

9

Invested Capital (Total)

9

Net Operating Assets

9

Stockholders' Equity (Net Worth)

9

Total Debt

10

Total Earning Assets

10

Working Capital

10

Balance Sheet ($ per Share)

10

Capital Expenditures

10

Common Equity ? Tangible

10

Common Equity ? Liquidating Value

10

Common Equity ? Total

10

Gross Assets

11

Invested Capital

11

Net Operating Assets

11

Property, Plant, and Equipment ? Total (Net)

12

Total Net Assets

12

Working Capital

12

Retained Earnings Statement (Total $)

13

Retained Earnings

13

Turnover Ratios

13

Accounts Receivable Turnover

13

(Item) as a % of Sales

13

Inventory Turnover

14

Number of Days' Sales

14

Sales per $ Cash and Short-Term Investments

14

Sales per $ Common Equity

14

Sales per $ Gross Assets

15

Sales per $ Inventory

15

Sales per $ Invested Capital

15

Sales per $ Net Assets

15

Sales per $ Property, Plant, and Equipment

15

Sales per $ Receivable ? Current

16

Sales per $ Stockholders' Equity

16

Rates of Return

16

After-tax Return

16

Pretax Return

20

Sales per $ Working Capital

20

Working Capital as a % of Sales

20

Capitalization Ratios

21

Invested Capital

21

Criteria of Financial Soundness

23

(Item) as a % of Average Long-Term Debt

23

(Item) as a % of Average Total Debt

23

(Item) as a % of Current Assets

24

(Item) as a % of Intangibles

24

(Item) as a % of Total Assets

24

(Item) as a % of Total Debt

25

(Item) as a % of Total Liabilities

25

(Item) as a % of Total Liabilities and Stockholders' Equity

26

8/2003

Table of Contents

iii

Capital Expenditure Coverage

26

Current Ratio

26

Debt/Equity Ratios

26

Interest Coverage

27

Quick Ratio (Acid Test)

27

Management Decision Statistics

28

(Item) as a % of Cash Flow

28

(Item) as a % of Income Before Extraordinary Items ? Adjusted for Common Stock

Equivalents

28

(Item) as a % of Property, Plant, and Equipment ? Total (Gross)

29

(Item) as a % of Property, Plant, and Equipment ? Total (Net)

29

Price and Market Data

29

Price ? High ? Adjusted

29

Price ? Low ? Adjusted

30

Price ? Close ? Adjusted

30

Common Shares Outstanding ? Adjusted

31

Common Shares Traded ? Adjusted

31

Common Shares Used to Calculate Earnings per Share (Basic) ? Adjusted

31

Common Shares Used to Calculate Earnings per Share ? 12 Months Moving ? Adjusted 31

Market Return

31

Market to Book (Fiscal Year End/Quarter End)

32

Treasury Stock ? Number of Common Shares

32

Market Value Statistics

33

Income Before Extraordinary Items Adjusted for Common Stock Equivalents per $100 of

Market Value

33

Income Before Extraordinary Items per $100 of Market Value

33

Market Value of Common Stock

33

Pretax Income per $100 of Market Value

33

Sales per $100 of Market Value

34

Price Ratios

34

Price ? Earnings Ratio

34

Dividend Payout Ratio

34

Dividend Yield

34

Formulas Used in Compustat Prices, Dividends and Earnings (PDE) Financial Calculations 35

Company Data

35

Index Data

36

Financial Statements

i

In this chapter...

1

General Classification of Annual Data

2

Balance Sheet

4

Assets

4

Liabilities and Net Worth

5

Supplementary Balance Sheet Items

6

Supplementary Schedules V and VI - Property, Plant, and Equipment Components

7

Supplementary Schedules V and VI - Property, Plant, and Equipment Components

8

Debt

8

Supplementary Real Estate investment Trust (REIT) Items

8

Income Statement

9

Basic Income Statement

9

Earnings per Share and Common Shares Used

10

Supplementary Income Statement Items

10

iv

Compustat North America User's Guide

8/2003

Annual Special Items Effect on Net Income and EPS

11

Real Estate Investment Trust

11

Statement of Cash Flows or Changes in Financial Position

12

Statement of Cash Flows

13

Working Capital Statement

14

Cash Statement by Source and Use of Funds

15

Cash Statement by Activity

16

Net Liquid Funds/Net Funds Statement Classified by Source and Use of Funds

17

Restated Data

18

Balance Sheet ? Restated

18

Income Statement ? Restated

18

Earnings per Share and Common Shares Used ? Restated

18

Supplementary Items ? Restated

19

Additional Information

19

Capital Stock and Stock Plans

19

Common Stock Market Data

19

Company Classifications and Ratings

20

Index Identifiers

20

S&P Debt Ratings

20

Fortune 500

20

Company Statistics

20

Financial Statement Clarification

20

Lease Obligations and Rental Expense

20

Pension Items

21

Defined Benefit Plan ? After SFAS #132

21

Defined Benefit Plan ? Before SFAS #87

21

Defined Benefit Plan ? After SFAS #87

21

Pension Costs

22

Postretirement Healthcare and Other Benefits

22

Bank and Savings and Loan Items

22

General Classification of Quarterly Data

23

Balance Sheet

24

Assets

24

Liabilities and Net Worth

24

Supplementary Balance Sheet Items

25

Supplementary Real Estate investment Trust (REIT) Items

25

Income Statement

25

Basic Income Statement

25

Earnings per Share and Common Shares Used

26

Special Items Effect on Net Income and EPS

26

Supplementary Income Statement Items

27

Real Estate Investment Trust

28

Statement of Cash Flows or Changes in Financial Position

28

Statement of Cash Flows

29

Working Capital Statement

30

Cash Statement by Source and Use of Funds

31

Cash Statement by Activity

32

Net Liquid Funds/Net Funds Statement Classified by Source and Use of Funds

33

Additional Information

34

Common Stock Market Data

34

8/2003

Table of Contents

v

Financial Statement Clarification

34

Bank and Savings and Loan Items

34

Data Definitions

i

In this chapter...

1

Restated Annual Data Definitions

1

Footnote Codes

1

Compustat North America Data Definitions

2

Accounting Changes ? Cumulative Effect

2

Annual & Quarterly footnote codes

2

Accounts Payable

3

Annual & Quarterly footnote code

4

Accounts Payable and Accrued Liabilities ? Increase (Decrease) (Statement of Cash Flows) 4

Accounts Receivable ? Decrease (Increase) (Statement of Cash Flows)

5

Accrued Expense

6

Accumulated Depreciation of Real Estate Property

7

Accumulated Other Comprehensive Income (Loss)

7

Acquisition/Merger After-Tax

8

Acquisition/Merger Basic EPS Effect

8

Acquisition/Merger Diluted EPS Effect

9

Acquisition/Merger Pretax

9

Acquisitions ? Income Contribution

10

Acquisitions ? Sales Contribution

10

Annual footnote codes

11

Acquisitions (Statement of Cash Flows)

11

Active/Inactive Flag

12

Codes

12

Adjustment Factor (Cumulative) by Ex-Date

12

Adjustment Factor (Cumulative) by Payable Date

17

Adjustment Factor (Raw) by Ex-Date

17

ADR Ratio

18

Advertising Expense

19

Amortization of Intangibles

19

Annualized Dividend Rate

19

Assets ? Other

20

Assets ? Other ? Excluding Discontinued Operations

23

Assets ? Total (Restated)

24

Assets ? Total/Liabilities and Stockholders' Equity ? Total

24

Annual & Quarterly footnote codes

25

Quarterly only footnote codes

25

Assets and Liabilities ? Other (Net Change) (Statement of Cash Flows)

25

Auditor/Auditor's Opinion

26

Book Value per Share

28

Calendar Year

30

Canadian Index Code

30

Canadian Index Code ? Current

30

Capital Expenditures (Compustat Business Information Files)

31

Capital Expenditures (Restated)

31

Capital Expenditures (Statement of Cash Flows)

31

Annual & Quarterly footnote code

32

Capital Surplus

33

Annual & Quarterly footnote code

34

vi

Compustat North America User's Guide

8/2003

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download