This guide was written for Michael Browne's courses. These include:
– BUAD 6000
– EXBU 6510
– MBA 6040
Here you will find the databases and tools you need to complete your company analyses. Tools for finding:
– Financials and 10-K filings, especially using the database Refinitiv Workspace
– NAICS codes (in general)
– NAICS codes for a specific company using the database Business Insights Essentials
– Industry ratios in the database RMA e-Statement Studies
– Industry reports or profiles in the database IBISWorld, among others.
Use the links in the left margin menu to get to the tools you need.
Although the detailed instructions page refers you to Information Technology Services for help, at the Raynor Information Desk we can also help with some parts of the process. Give us a call at (414) 288-7556.
Here's an outline for the Company Analysis report that you will write:
Refinitiv is the big database to use for public company financials You must:
An individual login account is required, no way to avoid it. Complete Refinitiv registration instructions are here.
Things to know about the registration process in order to avoid delays:
– You will receive TWO separate email messages: you must open both emails and click on a link.
– The whole process can take about 15-20 minutes -- please be patient.
– Problems? Send an email to memref @ marquette.edu. We'll work on your account as quickly as possible.
For a company analysis, start by entering your company's name or ticker symbol in the top left search bar (look for the yellow arrow in the screenshot at right). By default it usually reads "Sample Layout - Market Monitoring"; just type over that.
Once your company is found, you'll get a second menubar specific to the company. Here's what that looks like:
The menubar is circled in yellow above.
The tabs you'll need to use are: Overview, Estimates, Financials, and Peers & Valuation.
By default you start on the Overview tab; the active tab is always bright blue in color. Right below the menu bar you will see the Business Summary, a basic description of the company's business, and usually just one paragraph in length. Use this for the Company Overview in your report! (See the report outline above.)
Below is more information about the information you should find on the remaining tabs.
The Financials tab is where you will find the annual financials for your company. By default, you end up in the Financial Summary. Here's a screenshot showing what to look for:
Notice that the Financials tab pictured above is bright blue. Off to the right, look for the Excel icon. Click on it to bring up a menu, and make the following selections:
Then click on the orange Export button, bottom right corner of the menu. This will give you the Standardized data.
You will still need to do this two more times, in order to get the YoY Growth and Common Size data!
By default, when you click on the Financials tab, you end up in the Financial Summary with standardized data only. To change to YoY Growth or Common Size data, you must go into the Income Statement, Balance Sheet, or Cash Flow; it doesn't really matter which one though. See the screenshot at right.
Once in one of these three parts, here's what to do:
Screenshot below shows location of View menu, Update View button, and Excel download icon.
While you're still on the Financials tab, notice that there are very small, pale blue circle icons at the tops of the columns. The letter F is inside the circle; it stands for Filings. Click on that to go directly to the filing that the data actually comes from.
The 10-K report will open in a new window. Scroll down till you see the table of contents. The sections you want to read are in Part II.
The MD&A (Management's Discussion and Analysis of Financial Condition and Results of Operations)
Financial Statements and Supplementary Data. Read the following:
On the Estimates tab, go to the Statement View and download the data there.
On the Peers & Valuation tab, go to Sector Competitors.