Dutch companies in LexisNexis

Many Dutch organisations are registered at the Dutch chamber of commerce (Kamer van Koophandel). When a company is registered there it gets a unique company number called the KVK number. This number can be used to quickly search and get company reports from LexisNexis. The KVK number is made up of the main number of 8 digits and 1 or more Sub numbers if the company is located and active in more locations. The sub number is always four digits long.

Example:
The head office of the company Rabobank Nederland has the number 30046259 with the sub number 0000. Each additional location where the company is active has a different sub number: 001, 002, 003 etc. Be aware, however, that a daughter or affiliated company may also have it's own specific 8 digit KVK number!

The Dutch company reports in LexisNexis include the KVK number and this makes it possible to look up specific companies at specific locations. The number in a report is in a specific field and it looks like HANDELSREG: 30046259-0000.

By doing a simple search on the complete KVK number 30046259-0000 I get just one report on the main company Rabobank Nederland (Also called: Coöperatieve Centrale Raiffeisen Boerenleenbank BA).

By limiting the search to just the first 8 digits I may even get additional reports on daughter companies as well as reports on current managers and directors and possibly also reports on Merger and Acquisition activities. A good small example of this is a search on the company Koninklijke Brill NV using KVK number 28000012.

Author information: LinkedIn

10:25 AM - 26 August 2010

LexisNexis Company Information Sources

The Company module of LexisNexis currently offers company reports from 191 Company information sources. Most of these information sources are grouped roughly by region or country. These "groupings" can be selected when you do a search. Below you find two

excel lists that list them:

• List of all Company information Sources
  
• List of sources and in which groups you can find them.

The amount of information in each source varies. For brief descriptions of the content you can use the Source locator. This is a specific website that allows you to look up the information sources from (it seems) all modules of LexisNexis.

When you have entered the database you can also call up detailed information on the content of Company information sources (including a sample record) using the blue icon which is available at the search screen:

The blue icon is also available in each report and this allows you to call up information on the Company Report source.

Author information: LinkedIn

07:01 PM - 6 April 2010

Doing searches in LexisNexis source Edgar online

In the past I mentioned that EDGAR Online was also available in LexisNexis (with information going back to 1993/1994 !). The source grouping where it can be found has undergone a name change. The location for finding EDGAR Online through LexisNexis (Academic) is now:

English group names:

Main Group: Company Information - incl. D&B, M&A, bankruptcy
Subgroup: All Company Information (excluding Investext)

Dutch group names:
Groep: Bedrijfsinformatie - incl. D&B, F&O, Faillissementen, etc.
Subgroep: Bedrijfsinformatie (excl Investext en D&B)

In another post I mentioned that it was possible to do a search in this database using the name of the company or it's CIK number in combination with the name "Edgar Online" and the name of a SEC Filing form. An example of a specific search would look as follows:

"Edgar Online" W/10 KELLOGG AND "FORM TYPE: 10-K"

A search using the CIK number of the Kellog Company would look like:

"Edgar Online" W/10 0000055067 AND "FORM TYPE: 10-K"

Using a CIK number to search for information does not work nearly as well as a search using (part of) the actual company name. LexisNexis does not handle zero's very well if these appear in front of a string. These zero's will be automatically deleted and LexisNexis will search instead for the number 55067 instead of a string of characters like 0000055067. Placing the CIK number between quotation marks unfortunately does not work. The best way to search for company information in Edgar online (through LexisNexis) is therefore using the name of a company.

Author information: LinkedIn

12:48 PM - 17 March 2010

LexisNexis source: EDGAR Online

The EDGAR Online database (Electronic Data Gathering Analysis and Retrieval) contains the filings of companies to the Security and Exchange Commission in America. Specific filings are necessary for specific corporate changes or reports. The companies that deposit filings are US companies as well as foreign companies or multinationals that are required by US Law to do so.

Examples of filing forms and their codes are:

• S-1: This filing is a pre-effective registration statement submitted when acompany decides to go public. Commonly referred to as an "IPO" (Initial PublicOffering) filing.
• S-8: This filing is required when securities are to be offered to employees pursuant to employee benefit plans.
• N-1A: Registration statement for Mutual Funds.
• DEF 14A: Provides official notification to designated classes of shareholders of matters to be brought to a vote at a shareholders meeting. This form is commonly refered to as a "Proxy".
• 10-Q: A quarterly report which provides a continuing view of a company's financial position during the year. The filing is due 45 days after each of the first three fiscal quarters. No filing is due for the fourth quarter.
• 10-K: An annual report which provides a comprehensive overview of the company for the past year.
• 20-F: Annual and transition report of foreign private issuers filed pursuant to sections 13 or 15 (d) of the Securities Exchange Act.

A comprehensive list of the filing types covered by Edgar Online can be found at the website of EDGAR Online: filing list.

EDGAR online is available in LexisNexis (covering 1994 to now) through the SUBGroup: All Company information (Excl. D&B) [= Bedrijfsinformatie (Excl Investext en D&B)].
A limited version of EDGAR online is freely available through the EDGAR onlne website.

Author information: LinkedIn

04:04 PM - 5 April 2009

LexisNexis and executive compensation information

These days, when the Credit crunch is all over the news, there is also talk of executives receiving salaries and bonuses that are excessive. Newspapers also report on negative results due to exceedingly large compensations which sometimes caused executives to take actions that were good in the short term for themselves or the shareholders but may have worsened company stability and performance in the long run. With all the increased attention on executive compensation there is also a lot of interest in sources that offer information on this.

There are few sources that have information on executive compensation. Two of these sources I mentioned earlier in this blog: Compustat ExecuComp and Hoover's Company Records. LexisNexis also sometimes has some limited information in some of the company sources.

Two particular sources offer much more than brief information on executives of US companies:

• EDGAR Online
  This report source contains full-text company reports from the US Securities and Exchange Commission from 1994 to now and is updated daily. Edgar is available through the SUBGroup: All Company information (Excl. D&B) [= Bedrijfsinformatie (Excl Investext en D&B)]
  
• U.S. Executive Compensation Database
  CoreData's U.S. Executive Compensation database provides executive compensation and auditor fees, as reported in the Annual Meeting Proxy Statements or Form 10-K, filed with the U.S. Securities and Exchange Commission. The source offers information that goes back 5 years and it is updated weekly. This source is available through SUBGroup: US Company Reports of the section US Company Reports [= Bedrijfsinformatie - V.S. ondernemingen]

If you want to look for reports on executive compensation in both sources you can use either the company names or CIK identification codes in combination with the string "DEF 14A". If you use this string literally between quotes you will get these specific reports. For Edgar Online reports in the SUBgroup All Company information (Excl. D&B) you need to add the name of this source between quotes as well: "Edgar Online".

For EDGAR Online a search in the SUBGroup on the company Adobe Systems INc would look like:

- Example 1: "Edgar Online" AND "DEF 14A" AND 0000796343

- Example 2: "Edgar Online" AND "DEF 14A" AND "Adobe Systems"

For U.S. Executive Compensation Database a search in the SUBGroup on the company Adobe Systems INc would look like:
- Example 1: "DEF 14A" AND 0000796343
- Example 2: "DEF 14A" AND "Adobe Systems"

Author information: LinkedIn

12:05 AM - 27 February 2009