Comparing Data Sources

As of 4/21/99 (Subject to change)

Legend (See notes below chart for definitions):

Orig=Original

Rstd=Restated

Stdz=Standardized

Nmlz=Normalized

AsRp=As Reported

Bas=Basic

Dil=Diluted



Manually Entered Data

Electronic Data



Company Reports

Value Line
(Hard copy reports)

S&P Reports
"Tearsheets" Electronic Data**

S&P Compustat
(NAIC DataFiles)

MarketGuide (SSG data files on the AAII Stock Investor PRO
CD-ROM)

Adjustment to Data

Orig
may be Rstd
AsRp

Orig
Nmlz

Orig
generally AsRp

Orig
Stdz

Rstd
AsRp

Sales

Can be Rstd
AsRp

Orig

Orig
generally AsRp

Orig
Stdz

Rstd
AsRp

Bank Revenue

User must sum Net Interest Income + Non-Interest Income and deduct Loan Loss Provision

User must sum Net Interest Income + Non-Interest Income and deduct Loan Loss Provision

User must sum Net Interest Income + Tax Equiv. Adj. + Non-Interest Income and deduct Loan Loss Provision

GROSS Interest Income + Fees and Commissions. Loan Loss Provision not deducted.

Net Interest Income + Non-Interest Income less Loan Loss Provision

Pretax Profit

Can be Rstd
AsRp

Not reported by Value Line. Can be derived using Net Profit and Tax Rate.

Orig
generally AsRp

Orig
Stdz

Rstd
AsRp

EPS

AsRp
Stdz
Bas

Orig
Nmlz

generally Dil

Orig
Bas
until 1996
Dil after 1996

Orig
Bas
for full history

Rstd
Dil

Book Value

Equity section of Balance sheet.

Uses common equity less Liquidating value of redeemable Pfd Stock. Includes value of intangibles.

Uses common equity less Liquidating value of Pfd Stock. Excludes value of intangibles.

Uses total equity including Pfd. Includes value of intangibles.

Uses common equity. Includes value of intangibles

Dividends

Gives various dividend information. 5 & 10 yr. summaries show Fiscal div DECL'D date

Qtrly div PAID­exdate Annual div DECL'D ­ date

Usually is Annl div - exdate but can also be Annl div DECL'D-date

Annl div - exdate
Qtrly div - exdate

Annl div DECL'D - date

Fiscal Year Label

Shows Balance Sheet date; Does not set data year

Data year set by fiscal yr date:
FY ending during Jan-Apr. uses prior calendar year to assign data year. FY ends during May-Dec uses current calendar year to assign data year

Data year set as the year in which the fiscal year ends (current calendar year assigned) NOTE: Prices will come from prior calendar year, depending on FY ending month.

Data year can be set as FY or calendar year

Data year set by FY date: FY ending during Jan - May uses prior calendar year to assign data year. FY ending during June-Dec.; uses current calendar year to assign data year.

Prices

Contains 2 years of quarterly highs and lows (Matches to fiscal year, not calendar year)

Uses calendar year high and low prices.

Uses calendar year prices; but based on fiscal year-end month. FY-Jan. thru May; uses prior calendar yr hi & low. FY=June thru Dec; uses curr calendar yr hi & low.

The user can select to use either Fiscal Year or Calendar Year prices during installation of the Datafiles.

Uses Fiscal Year prices.

Comments

"Old" Annual and Quarterly reports (whether paper or electronic) cannot be revised by the company to reflect stock splits after the date of the report.





Notes:

Original. Data is the original numbers picked up by the data source; not changed with later reports.

Restated. Data from prior years are restated from what was originally reported to show the effect of significant events such as an acquisition or divestiture.

As Reported. Data is shown as the company shows on their financial statements.

Normalized. Company reported data might have been modified to remove the effect of pretax, non-recurring items. (Shown net of taxes.)

Standardized. Company reported data might have been assigned to more generic categories to remove the effect of differing accounting practices followed by companies, especially within the same industry. This often includes data that had been footnoted. Most often applied to income and expense items.

Basic. EPS calculated as simple Net Income Available to Common Shareholders divided by the weighted average number of common shares outstanding. Basic EPS replaces "Primary EPS", which included effects of some common stock equivalents. Primary EPS is shown prior to Dec. 15, 1997

Diluted. Diluted EPS: Calculated as net income available for common shareholders plus adjustments for Common Stock Equivalents and other potentially dilutive securities, divided by the weighted average of common shares plus the weighted average of Common Stock Equivalents and other potentially dilutive securities. Diluted EPS replaces Fully Diluted EPS prior to Dec. 15, 1997. They both represent the maximum dilution however they are calculated somewhat differently due to changes in definitions. Companies are no longer exempt from reporting dilution based on the "3% materiality" rule and must report all dilution.


** Data may be imported electronically when converted by a utility program such as The SSG MAKER or The SSG Processor.


© Copyright 1999 by Inve$tWare Corporation. All rights reserved. Reproduction of this information is permitted only with the express approval of Inve$tWare Corporation.

HOME

      Investor's Toolkit  Demos Ordering Information

     FreeWare Zone  Investor Resources