Company Analysis: Home

Need Help?
Ask Us!

Report access
issues here
.

About this guide

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.

Off campus access methods (authentication)

  • Library Login:  This method (a proxy server) is quick and easy, and requires no setup.  But a few databases will not work with it, and it is less reliable when there is heavy internet traffic or a slow connection.
  • VPN (virtual private network): The VPN requires you to download an app onto both your cell phone and your computer.  It is much more reliable during times of heavy internet traffic, and is well worth the necessary setup time. Outline of the steps required for the VPN:
    1. Find detailed VPN instructions here. Once there, click on "How do I start using GlobalProtect VPN and Duo?"
    2. Register for Duo Mobile. Two ways to do that: via an email from ITS (helpdesk@marquette.edu; you can email and ask for "the VPN registration invitation email"); or if off-campus, via Office365.
    3. Download the Duo Mobile app onto your cell phone. Allow push notifications for it.
    4. Download the GlobalProtect app onto your computer.
    5. Complete GlobalProtect setup on your computer. (See step 3 instructions under "How do I start Using GlobalProtect VPN and Duo?"

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.

Report outline

Here's an outline for the Company Analysis report that you will write:

  • Table of Contents
  • Purpose
  • Executive Summary
  • Company Overview
  • Industry Overview Information
  • Financial Analysis with Key Highlight Commentary
  • Ratio Analysis with Key Highlight Commentary
  • Industry Comparisons with Key Highlight Commentary
  • Conclusion and Recommendations

About Refinitiv Workspace

Refinitiv is the big database to use for public company financials  You must:

Create an individual account:

An individual login account is required, no way to avoid it.  Complete Refinitiv registration instructions are here

Potential problems:

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.

Company Menubar

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:

Refinitiv WS company menubar

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.

Financials Tab

The Financials tab is where you will find the annual financials for your company.  Here's a screenshot showing what to look for:

Refinitiv WS Financials tab and download

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:

  • Income Statement
  • Balance Sheet
  • Cash Flow
  • Financial Summary
  • Operating Metrics

Then click on the orange Export button, bottom right corner of the menu.  

Getting the 10-K report

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.

Refinitiv WS filings icon

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.

Item 7:

The MD&A (Management's Discussion and Analysis of Financial Condition and Results of Operations)

Item 8:

Financial Statements and Supplementary Data.  Read the following:

  1. Notes to Consolidated Financial Statements.
  2. The Auditor's report: usually you'll find this directly after the Notes. 

10-K report table of contents

Estimates Tab

On the Estimates tab, go to the Statement View and download the data there.

Refinitiv WS Estimates tab and download

Peers & Valuation Tab

On the Peers & Valuation tab, go to Sector Competitors. 

Refinitiv WS sector competitors and ratios

Things to know:

  • The Excel download icon is on the far right.
  • How are the competitor companies selected?  The default mechanism by which competitors are selected is the TRBC classification system; by default this is also at the narrowest classification level. The classification system menu is to the left. 
    • In the example above (Rockwell Automation), there are 25 companies retrieved, including Rockwell. For other companies you may find that this classification system, at this narrow level, will only retrieve a single competitor.  You may need to try a broader level of the classification system, or another classification system:  The other two classification systems to try are GICS and SIC.  
    • You can also add individual companies that you know are direct competitors. 
    • If you're wondering why they were not selected as competitors automatically, that has to do with the vagaries of the classification systems, and with how diversified (or not diversified) the companies are!