Thomson ONE‘s full features are available only with the outdated Internet Explorer (IE) browser. This makes staying up-to-date on the latest browser workarounds critical to accessing this collection of company information, SEC filings, and analyst reports. Continue reading for details regarding this year’s Chromium-based update to Microsoft Edge.Continue reading
Need macroeconomic data for more than 128 countries? CEIC offers metrics including GDP, CPI, Forex rates, imports, exports, retail sales, and investment as well as premium data for Brazil, Russia, India, and China, letting you match up and download data from multiple sources for further research.
Let’s say you need to compare India’s and Russia’s gross domestic product (GDP) and quarterly imports from China from 1990 through 2015.Continue reading
Thomson ONE only works with full functionality in Internet Explorer (IE), and within that, it only works properly in versions IE8 and below. For those of you familiar with this resource, this isn’t anything you haven’t heard before. Compatibility issues continue with Thomson ONE in the latest iteration of the Windows browser, Microsoft Edge. As has been the case before, there is a work around which you can find detailed below.
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.
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.
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.
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 firstname.lastname@example.org to set up an appointment.
Mergent Online includes the EIN in the header information at the top of the company record, labeled IRS Number.
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.
EINs for nonprofit organizations can be found in their IRS 990 filings, officially titled Return of Organization Exempt from Income Tax.
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.
The National Directory of Nonprofit Organizations includes the EIN in organization records, and also provides it as a field in exported lists.
Congratulations to the Class of 2016!!!
“Why can’t I get access to the Library’s databases?” is the perennial question of the recent Penn graduate.
Unfortunately, the library’s subscription databases are only available to current students, faculty, and staff members of the University of Pennsylvania. Once the school switches a student’s status from student to alumni – usually mid-August – access to the Library’s electronic resources ends. Below is a summary of the Penn Libraries resources that you can access as an alumni, both remotely and on-campus. We also have a few tips for finding business resources at your local public library or on the Web.
Alumni Services provides information on visiting the Library, Library Events and E-resources that are accessible remotely using your PennKey information.
Alumni also have access to some business databases on campus as shown in this list: Alumni Business Database Access on Campus.
Other options for Alumni include the local public library. Many public libraries provide access to selected databases for members. Check your library to find out what is available to you. New York City’s Science Industry and Business Library, (SIBL) rivals many college libraries. The Free Library of Philadelphia also has a large collection of business resources.
There are also many useful freely available web resources. Here are a few tips on locating and finding reliable information. First, check our Library Research Guides. Many guides include web sites carefully vetted by subject Librarians.
Use Google filters. For instance, when you are researching topics such as foreign trade or exporting, limit your search to government sites. To search for trade regulations in Brazil, use this search:
TRADE REGULATIONS BRAZIL SITE:.GOV
You will retrieve resources about trade with Brazil from U.S. government sites only.
To search for information from associations or organizations use the filter SITE:.ORG. Many organizations such as the World Bank provide free information. One great resource from the World Bank is the annual “Doing Business In“ survey of the ease of doing business in countries across the Globe. The World Bank also provides detailed information on each country including business regulations and historical macroeconomic data.
Google Scholar contains many scholarly publications from around the world. Many are accessible via the web. This can also be used as a way to build a bibliography that can be used at the local library.
Large consulting companies often provide free reports. PricewaterhouseCoopers provides industry overviews and research and insights. Real estate firms such as CBRE provide quarterly international market research reports.
An easy way to access government data is through American Factfinder. Select your topic of interest such as demographics, economics or housing.
FRED, the Federal Reserve Bank, St. Louis, is another depository of economic statistics and research. This covers a range of countries as well as the United States.
The Thomas Register is the largest directory of suppliers in the the U.S. Many companies include brochures.
The Pew Research Center is a nonpartisan fact tank providing information about the issues, attitudes and trends shaping America.
Edgar provides free access to company filings with the Securities and Exchange Commission (SEC). It also includes information about the usage for various filings.
This is a sampling of sites that are available on the web. Good luck going forward!!
For more detailed information about the Library’s business databases available to alums, please look at our blog post Library Database Access for Penn Alumni.
Companies make acquisitions for two primary reasons: (1) to fill a strategic gap (products, resources (people), or capabilities) or (2) enable the company to enter a new market with a new revenue stream. Researching a company’s M&A activity provides insight into the corporate strategy. When researching a specific deal, we are often looking for deal financials and deal valuation. It’s also important to research the strategies behind the deal. We often want information on business drivers, overall strategy, execution plan, implementation, etc.
Let’s take a well-known deal as an example, eBay’s acquisition of Paypal. In 2002, eBay, the largest online auction platform bought, PayPal, a web-based payment service, for $1.5B. The deal was a perfect match – Paypal drove eBay’s revenues while eBay supported the growth of PayPal’s active user base. A decade later, it is evident that both businesses fueled each others growth. So how does one research a specific deal?
Start with Thomson One for deal information including deal financials, news, filings, and research.
Go to Screening & Analysis => Deals & League Tables => M&A => Advanced Search. Continue reading