Merged Fundamental Columns

Description

Some of the available columns in the SME Direkt Level 1 package and the FactSet package are equivalent. The actual result columns should be the same, while the estimate values may vary between the two services.

If you have access to both packages, some companies with have actual result and estimate values from both services. To reduce the number of columns, you can choose to use so-called Merged fundamental columns instead of the specific FactSet and SME Direkt columns.

A Merged column will display values from SME Direkt when available, otherwise it will display values from FactSet.

Data content included per company as merged columns are:

•Net Sales

•EBITDA

•EBIT

•Net Profit

•EPS (Earnings per share)

•DPS (Dividends per share)

•P/E (Price / Earnings)

•Yield Percent

•Last year’s reported result

•Next year’s estimated numbers (median)

This means that the key figures that are specific to SME Direkt are:

•Gross Profit

•EBITA

•Pretax Result

•Recommendations

And the key figures that are specific to FactSet are:

•CFPS (Cash-flow per share)

•P/CF (Price / Cash-flow)

•Recommendations

TIP: Even if you have only access to one of the services at this point, using the merged columns will ensure that you'll see the values from the new service should you order it in the future.

Requirements

•Subscription to an SME Direkt and/or FactSet package

How to access

•As columns in the Market and Composite windows

•As DDE or RTD links

Merged columns

All the Merged columns are prefixed with Merged in the Select Columns dialog.

In the column captions the Merged fields are not prefixed - this is to distinguish them from the corresponding SME Direkt Level 1 and FactSet fundamental fields.

Double-clicking a fundamental column value will open the the Details page for that symbol.

List of Merged columns

The following is a sorted list of all available Merged columns.

•Actual DPS (Dividend Per Share)

•Actual EBIT (Earnings before interest and taxes)

•Actual EBITDA (Earnings before interest, taxes, depreciation and amortization)

•Actual EPS (Earnings Per Share)

•Actual Net Profit

•Actual Net Sales

•Actual P/E (Price/Earnings Ratio)

•Actual Yield% (100 * DPS / Last)

•Change in DPS (Dividend Per Share)

•Change in EBIT (Earnings before interest and taxes)

•Change in EBITDA (Earnings before interest, taxes, depreciation and amortization)

•Change in EPS (Earnings Per Share)

•Change in Net Profit

•Change in Net Sales

•Change in P/E (Price/Earnings Ratio)

•Change in Yield% (100 * DPS / Last)

•Estimated DPS (Dividend Per Share)

•Estimated EBIT (Earnings before interest and taxes)

•Estimated EBITDA (Earnings before interest, taxes, depreciation and amortization)

•Estimated EPS (Earnings Per Share)

•Estimated Net Profit

•Estimated Net Sales

•Estimated P/E (Price/Earnings Ratio)

•Estimated Yield% (100 * DPS / Last)

•Percentage change in DPS (Dividend Per Share)

•Percentage change in EBIT (Earnings before interest and taxes)

•Percentage change in EBITDA (Earnings before interest, taxes, depreciation and amortization)

•Percentage change in EPS (Earnings Per Share)

•Percentage change in Net Profit

•Percentage change in Net Sales

•Percentage change in P/E (Price/Earnings Ratio)

•Percentage change in Yield% (100 * DPS / Last)