Ins and Outs of EINs

There is no shortage of symbols or numbers that can be used to identify companies, which makes trying to match company lists from different sources challenging. The more commonly used company identifiers include ticker symbols, CUSIPs, CIKs and ISINs, as well as proprietary numbers like D-U-N-S Numbers or BvD identification numbers. One of the less commonly used company identifiers is the Employer Identification Number (EIN), also known as the Federal Tax Identification Number. It is used by the Internal Revenue Service (IRS) to identify entities that need to file business tax returns. It is a nine digit number, either expressed as a single string (050155090) or with the first two digits, a dash/hyphen and the final seven digits (e.g. 05-0155090). EINs are not as readily available in directory and company databases as other identifiers. Where can you find EINs for company matching when you need them?

Individual EINs for a specific company are available from a company’s SEC filings; see Lippincott’s Business FAQ Where do I find SEC (Securities & Exchange Commission) filings? for details about locating these filings. On the front page of a filing, the EIN is listed as the IRS Employer Identification No.

aapl8-kb

It is also listed in the filing submission text files with the label IRS Number. You can find EINs for private companies if they have filed with the SEC. See for example the IRS Number from the complete submission text file from a Form D filed by Uber in 2015.

uberformdb

Corporate Affiliations, a directory database from LexisNexis providing corporate structure information, includes EINs in its records for public companies and some private companies. One caveat about Corporate Affiliations and the other resources mentioned below is that they often only list EINs for public companies, even though private companies are also required to obtain and use EINs. To find EINs in Corporate Affiliations, search for a company of interest and view its record. The EIN will appear toward the top of the record as FEIN.

hasbrocorpaffiliationsb

Note that Corporate Affiliations is misleading with regard to the exportability of EINs. While FEIN appears to be available as an exportable field, it is not populated in the export results; a FEIN column will display, but it will be blank. Another LexisNexis option is to use the FEIN search in Lexis.com. Lexis.com is available to current Wharton students, faculty and staff at Lippincott; please contact us at lippinco@wharton.upenn.edu to set up an appointment.

Mergent Online includes the EIN in the header information at the top of  the company record, labeled IRS Number.

mergentalleghenytechnologies21b

mergentcompanyanalysislisb

These can be exported for 500 records at a time via the Company Analyst List option that appears on the results page after running a search.

After adding companies to the analysis list, click the My Mergent Tools button and select Company Analysis List. From the My Mergent Tools page, select Company Comparison Report. EIN appears as IRS Number in the Select Data Items area.

mergent-selectdataitems

EINs for nonprofit organizations can be found in their IRS 990 filings, officially titled Return of Organization Exempt from Income Tax.

990filingexampleb

 

 

 

 

 

 

 

See the 990s, Financials & Regulations tab of our Nonprofit Sector research guide for information about tools for locating 990s.  They appear At a Glance section of each foundation record in the Foundation Directory Online.

PewFoundationCenter.jpg

The National Directory of Nonprofit Organizations includes the EIN in organization records, and also provides it as a field in exported lists.

Lippincott Library Seminar Room – Open for Business

OFB-Open-Sign-Red-White

Lippincott’s new seminar room and information desk are open for business! Please join us on Tuesday, September 22 in room 242 from 2:30-3:30 for an informal open house to check out the new space. The seminar room and desk area are the first things you will see upon walking through our main entrance on the second floor of the Van Pelt Dietrich Library Center.

LippincottInfoDesk

The Lippincott Library Seminar Room (room 242) will function as a space for classes, workshops and meetings. It seats up to 28 people with a flexible and configurable seating arrangement, ranging from seminar-style seating to small group clusters for collaborative work. Several glass whiteboards allow for an ample amount of writable surface.

Lippincott242

The seminar room includes a full high-definition projection system with ceiling embedded speakers for audio playback. It has a permanently installed Windows PC as well as two sets of laptop inputs supporting both HDMI and VGA connections to the video projector. Wireless presentations are possible through the use of Mersive Solstice software installed on the resident PC. The room supports video and audio conferencing and has a microphone array permanently installed in the ceiling and a high-definition pan/tilt/zoom camera installed next to the projection screen in the front. Skype and Bluejeans are both installed on the resident PC. USB inputs connected to the resident PC are available in the front and back of the room and allow for the connection of auxiliary peripherals to the system such as cameras and visualizers.

We welcome single-use and recurring reservations for classes and academic support activities. To book the room, please see our reservation form. Contact us at  lippinco@wharton.upenn.edu with questions.

We look forward to seeing you at the Open House on Tuesday, September 22 from 2:30-3:30 in Room 242!!

Lippincott Library Seminar Room Construction

If you have visited Lippincott Library in the past few weeks, you have undoubtedly noticed some major changes. As you enter the library, you will immediately encounter the “great wall of Lippincott” – a large barrier that has been constructed around what was once our reference and reserve services desk.

LippincottEntrancewWall

Thanks to the generosity of the Snyder family, we are building a 28-seat seminar room this summer. The new room will be located just inside Lippincott’s main entrance. It will have a flexible furniture configuration, allowing it to be used seminar-style, lecture-style or to be set up for smaller groups. This project also gives us the opportunity to completely restructure our service desk and build a new staff work room which uses space more efficiently. An interior “behind the wall” shot is below.

LippincottInteriorCavern

Since we do not have a service desk during the construction period, we are operating a service room out of Room 248 (Class of 1955 Consultation Room). We will continue to provide reserve services from this room, as well as on-call access to reference librarians.

Construction will continue over the summer, but we anticipate the room and new service desk will be open and ready for business at the start of the Fall 2015 semester. We will be posting updates on its progress.

Exploring EMIS Intelligence

EMIS Intelligence, formerly ISI Emerging Markets, has traditionally been a great resource for exploring emerging markets. Produced by Euromoney Institutional Investor, it aggregates news, reports, statistics and company information from a wide range of providers. While the focus remains primarily on emerging markets, their recent redesign allows researchers to more easily examine world or global markets, as well as giving them the ability to find information on developed markets. While one still has the option to drill into a specific country, choosing a specific country is no longer required, making it easier to search across multiple countries and regions of interest.

Login

The EMIS Intelligence Search page can be somewhat overwhelming because there are so many options to limit and refine your search. This example shows looking for material on armored vehicles, and limiting the results to research reports using the Publication Type filter.

Search1.

Once you have run the search, you can also use the Filter options on the left-hand side of the results page to further limit by country, language and more.  In the example below, two filters,  Country and Publication were used to narrow search results..

UsingFilters

 

 

 

 

 

 

 

 

ReportsTab

Alternatively, you can use the Reports tab to explore the reports that are available. When you select the Reports tab, you will note that Analysis/Research, Ratings Analysis, News Analysis, and Analytical Commentary are automatically checked under the Publication Types list in the Filter By column.

PubsSearch

Use the Publications Tab to find reports by a specific provider. For example, to find EIU (Economist Intelligence Unit) Industry Reports covering the automotive, energy, healthcare, consumer goods, financial services and telecom sectors, select EIU Industry Reports from the publications list.

These reports cover both developing and developed markets, and include tables that are exportable to Excel, as shown in this example of telecom data from Austria.

excel

 

Extra! Extra! Wharton Printing in the Library

Print

At long last, the Lippincott Library has a Wharton printer. The new machine is located next to pinwheel 6. This printer allows students to use their Wharton print accounts to print documents, rather than PennCash. Students using the Wharton machines will have the option to select “Wharton Black and White” from the print queue, and can then release their print job at the printer using their PennCard.