I have posted the assignment excel and word documents required to do this assignment which consist of the following :
1. Word document that has youtube video tutorial.
2. Excel pivot table assignment word document.
3. Excel sheet with practice data.
4. Excel sheet with Dupont Data – which is the data that has to be used for this assignment.
5. Pivot table assignment answer sheet word document – this is the document where the answers are to be typed in.
BA 325: Excel PivotTable Assignment
In this assignment, you will learn the basics of data analytics and use an analytics approach to explore and evaluate a data set. Having the skills to work with data isn’t just valuable, it’s a necessity in many business jobs. Analytical skills will become increasingly important in the future, and the PSU School of Business believes that every student should have opportunities to learn data analytics.
At its core, data analytics is about solving problems. In BA Financial and Managerial Accounting, you learned about DuPont analysis and how it can be used to evaluate the performance of companies. In this assignment, we’ll expand the DuPont analysis and apply it to a set of real companies in a variety of industries. Our goals are to learn more about data analytics and Excel. We’ll be using an assignment adapted from a case developed by Ernst and Young, one of the world’s largest accounting firms.
Practice assignment and DuPont assignment
The PivotTable assignment includes two smaller assignments: The Practice assignment and the DuPont assignment. For this assignment, we’ll be focusing on PivotTables. PivotTables are among the most valuable tools used by business analysts to explore, understand, format and present data. By the end of this assignment, you’ll be proficient in using this tool.
You’ll use the Practice assignment to learn or refresh analytical skills in Excel and learn or refresh PivotTable skills. The Practice assignment has guided instructions at each point. Additionally, there are screenshots and answers below all the questions. This should allow you to check your work and make sure you understand before moving on. While you go through the Practice assignment you will be required to take 4 screen clippings that you will paste in the ‘PivotTable Assignment Answer Sheet.’
After you complete the Practice assignment, you will begin the DuPont assignment. As you work through the DuPont assignment, you will be prompted with questions. You will answer these questions in the ‘PivotTable Assignment Answer Sheet.’ Like the Practice assignment, the DuPont assignment has a ‘Check Figure’ section below questions 1-20. In the ‘Check Figure’ section, there are some answers that you can compare to your PivotTables. If you get the same answers as the ‘Check Figure’ answer, it is likely that your other answers will be correct. While you go through the DuPont assignment, you will be required to take 7 screen clippings that you will paste in the ‘PivotTable Assignment Answer Sheet.’
Once you have completed both the Practice assignment and the DuPont assignment, and completely filled out the ‘PivotTable Assignment Answer Sheet,’ you can upload your ‘PivotTable Assignment Answer Sheet’ Word document to the Assignments folder in D2L.
Requirements
1. Practice assignment: Follow the instructions for the Practice Assignment. Take the required 4 screen clippings and paste them in the designated locations in the ‘PivotTable Assignment Answer Sheet.’
2. DuPont assignment: Follow the instructions for the DuPont Assignment. Take the required 7 screen clippings and paste them in the designated locations in the ‘PivotTable Assignment Answer Sheet.’
3. Upload your completed ‘PivotTable Assignment Answer Sheet’ to the Assignments folder in D2L. Name your file:
BA 325 First name Last name
(use your actual name).
Data Sets
Download the following files from the PivotTable Assignment in D2L:
·
Pivot Table Assignment Answer Sheet – Student Template x
· Practice Data.xlsx
· DuPont Data.xlsx
In the Excel spreadsheets, you will find financial statement data for approximately 30 companies for each of six different industry groups (total sample size of almost 180 companies). The sheets contain financial statement information for fiscal years 2013-2015, inclusive. These companies are all publicly traded on the NASDAQ stock exchange and range in size from some of the largest to the smallest in their respective industry groupings.
In any data analysis you should ensure you have an established Data Dictionary before you begin. A Data Dictionary is a brief explanation of every field in your starting data set.
Data Dictionary: Practice Data
·
Ticker:
The code used to identify each company on the NASDAQ stock exchange. Each company has their own unique ticker symbol.
·
Name:
The name of the company for each line of data.
·
Industry:
One of six industry groupings as defined by Nasdaq.com. Industries included in the sample are capital goods, consumer services, finance, public utilities, technology, and transportation.
·
Year:
The fiscal year being reported on the financial statements. For example, a year of 2015 refers to the balance sheet of the company as of the last day of their fiscal year in 2015 (usually December 31st) and the income statement for all transactions that occurred during that fiscal year.
·
Total Assets:
The total assets of a company at the end of the fiscal year. This number appears on the balance sheet.
·
Total Debt:
The total debt of a company at the end of the fiscal year. This number appears on the balance sheet and can also be called total liabilities.
·
Net Revenues:
The top line number on the income statement. This represents total revenues (less a few items that you can ignore for this case) earned by the company in the fiscal year. This is also referred to as total sales.
·
Cost of Goods Sold (COGS):
The costs a company incurred to produce its products or services. This number appears on the income statement.
Data Dictionary: DuPont Data
·
Ticker:
The code used to identify each company on the NASDAQ stock exchange. Each company has their own unique ticker symbol.
·
Name:
The name of the company for each line of data.
·
Industry:
One of six industry groupings as defined by Nasdaq.com. Industries included in the sample are capital goods, consumer services, finance, public utilities, technology, and transportation.
·
Year:
The fiscal year being reported on the financial statements. For example, a year of 2015 refers to the balance sheet of the company as of the last day of their fiscal year in 2015 (usually December 31st) and the income statement for all transactions that occurred during that fiscal year.
·
Total Assets:
The total assets of a company at the end of the fiscal year. This number appears on the balance sheet.
·
Total Shareholder Equity:
The total shareholder equity of a company at the end of the fiscal year. This number appears on the balance sheet and can also be called stockholder’s equity.
·
Net Revenues:
The top line number on the income statement. This represents total revenues (less a few items that you can ignore for this case) earned by the company in the fiscal year. This is also referred to as total sales.
·
Net Income:
The bottom line number on the income statement. This is the final net income number of the company for the fiscal year.
Tools
There are three additional tools that you will use to accomplish these assignments:
Screen Clipping
There are a few ways to take a screen clipping of your Excel file and paste it into your Word document:
1. To do this from within your Word document:
· Select Insert
· Screenshot
· Screen Clipping
· Then click and drag your cursor to highlight the area you want to clip.
2. Alternatively select the Snipping Tool app from your Windows menu:
· Select New
· Click and drag to highlight the area you want to clip
· Select Copy
· Then move to your Word document and select Ctrl+V to paste the clip.
Data Cleaning
It is very rare that you will be given data that can be immediately analyzed/used. The process of removing/addressing the errors in your core data is called Data Cleaning, and is a big part of a data analyst’s job.
One of the situations that you may have to fix when you are Cleaning Data is function errors. Depending on the calculations you are doing with your data, cells that have 0’s in them may cause errors in your calculated formulas.
· Return to your original data sheet.
· To find the errors:
· Press F5
· Click the Special button
· Select the radio button for Formulas
· Make sure Errors is the only box checked
· Click OK
· Highlight the cells in red and then press the Delete key to remove those formulas.
Note: DO NOT DELETE THE CORE DATA! When you have an error in a calculation/function, only delete the calculation itself. If you delete the core data you may cause other calculations/functions to change, causing much greater problems.
Sort & Filter
Sort & Filter can be a fast way to explore your data. It is best used as a manual way of checking if something is present/missing, or organizing your data by a specific criteria. Both are used for slightly different purposes, but are most powerful when used together.
· To enable Sorting or Filtering:
· Go to the Home tab on the Ribbon.
· Got to the Editing menu.
· Click the Sort & Filter button.
· Click the Filter button.
· This will add Filters to your columns.
· Sort: The basic Excel Sort allows you to organize data based on some criteria, usually alphabetically (A-Z or Z-A) or numerically (lowest to highest or highest to lowest). This is best used when you want to have your data organized in a specific order.
· To execute Sorting (after you have added the Filters to your columns):
· Click the dropdown on the column you want to Sort.
· The Sort area is identified with the Red 1 in the screen clipping below.
· If your column data are numerical it can be Sorted lowest to highest or highest to lowest. If your column data are text it can be Sorted A-Z or Z-A.
· Once you Sort, it reorganize all your data based on the Sort you applied to the given column.
· Filter: The basic Excel Filter allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. This is best used when you are looking for only a specific portion of your data. There are two main types of Filters you will make use of in Excel, a Simple Filter, and a Custom Filter.
· To execute a Simple Filer (after you have added the Filters to your columns):
· Click the dropdown on the column you want to Filter.
· The Simple Filter area is identified with the Red 2 in the screen clipping below.
· Any of the boxes you uncheck will not be shown.
· A Simple Filter is best when you want to Filter out everything except a few options from one column.
· To execute a Custom Filer (after you have added the Filters to your columns):
· Click the dropdown on the column you want to Filter.
· The Custom Filter area is identified with the Red 3 in the screen clipping below.
· You can create a customized Filter based on the type of data in your column (either numerical or text), and then apply specific criteria that only show data that meet your criteria.
· A Custom Filter is best when you want your Filter to leave only a small, specific group of records.
Note: You can also use Sort & Filter when you are cleaning your data. The method listed in the Data Cleaning above is great when you have functions with errors. Sometimes your functions won’t have a mathematical error, but with not make sense due to the core data containing an outlier. In this case it is often easier to use Sort & Filter to find the problematic value, and delete it.
PRACTICE ASSIGNMENT
Open the Excel file called Practice Data.xlsx. We’ll use this data to practice analytical skills that we’ll then apply to the DuPont data.
The first step in any analytics assignment is to adopt an analytics mindset.
· Think about what you already know about the context and what questions you would like to answer as you analyze the data.
· Explore the spreadsheet and look at the data.
· You’ll notice that the file contains financial performance data (stated in millions of dollars) from companies over a three-year period.
· Do you recognize any of these companies?
· These companies come from 6 industries.
· Consider what you know about these industries.
We’ll use the data to calculate the following ratios:
·
Debt to Asset ratio:
This represents the amount of the assets that is financed through borrowing. This is a measure of leverage. Higher debt is typically associated with higher risk. The calculation for this ratio is Total Debt divided by Total Assets.
·
Gross Margin ratio:
Gross Margin is Net Revenues less Cost of Goods Sold (COGS). The Gross Margin ratio is the relationship between Gross Margin and Net Revenues. It is a measure of profitability and can be thought of as the company’s profit margin. The Gross Margin ratio is Gross Margin divided by Net Revenues.
Before you begin performing calculations, consider what you expect to see. Which industries would you expect to have the largest and smallest revenues and assets? Which would you expect to have the highest and lowest debt to asset and gross margin ratios?
As you work through the instructions below, think about what you can learn from the data, and after completing the assignment, do some additional exploring on your own. Also take your time to understand the analytical capabilities you’re using in Excel and think how they can be used in business. The tools you learn, and practice here, will be helpful in many classes in your business program.
Requirements
Work through the instructions below. As you work, you’ll be asked to:
· Follow the steps to perform the required analysis.
· Paste 4 screen clippings into the PivotTable Assignment Answer Sheet.
The Practice Assignment is to get you comfortable with PivotTables and help you apply some of the Excel features you have been learning in this class. You’ll likely be using a lot of unfamiliar features of Excel, so be prepared to struggle a little. If you are already experienced with PivotTables, the Practice Assignment will be a nice refresher. Answers are provided so that you can check your work. Have fun!
1) Move through the data set.
· Use Ctrl + the arrow keys to move quickly around the Practice data.
· This will have you jump to the end of the row/column.
· These are the same companies in the DuPont data file.
Question 1: How many Rows of company data (don’t count headings) are in the file?
516
2) Examine the numbers.
· All the numbers are stated in millions, so the Total Assets of American Airlines in 2013 was over $40 billion– $42,300,000,000.
· For this assignment, we’ll state numbers in millions, so we’ll write this number as $42,300M.
· Note: The formatting is not arbitrary. There are a few different numerical formats you will use with different types of calculations, so be mindful of which one you should be using.
Question 2: How much were Apple’s assets in 2015?
$290,500M
3) Calculate the Debt to Assets ratio.
· In cell I1(Column I, Row 1), type Debt to Assets.
· In cell I2, type =F2/E2 and hit return. Your answer should be 0.486997636, which means the company’s debts are about half the size of total assets.
· Format that cell as a percentage by selecting Home and clicking on the % icon in the Number menu.
· Copy that cell to show the Debt to Asset ratio for all rows in your spreadsheet by moving your cursor to the bottom right corner of the cell until you see a + and then double-clicking.
· (If you don’t see the +, go to File, Options, Advanced, and check the box next to Automatically Flash Fill).
Question 3: What was the Debt to Assets ratio for Apple Inc. in 2013?
8%
4) Calculate the Gross Margin ratio.
· In cell J1, type Gross Margin %. In cell J2, type =(G2-H2)/G2 and hit return.
· Your answer should be approximately 0.28, which means that the company keeps about 28% of every dollar of sales to cover other expenses and profits.
· Format the cell as a percentage and copy the formula for the remaining rows.
Question 4: What was Arrow Financial’s Gross Margin ratio for 2015?
100%
5) Create a PivotTable.
· Move your cursor to cell A1.
· Select Insert from the menu and click the PivotTable icon.
· Note: When you are creating a PivotTable you have a few options other than the default settings. You can specify a specific worksheet your PivotTable will go. You can also create your PivotTable from the Recommended PivotTables option. This will look at relationships in your particular dataset and give you some initial ideas for your PivotTable setup.
· Accept the default settings for the Table/Range and New Worksheet by clicking OK.
· On the left of your screen, you’ll see the area where your PivotTable will be built.
· To the right of your screen, you will see all the fields (columns) listed, along with four areas of the PivotTable.
· If you click outside the PivotTable, the fields area will disappear. It will reappear when you click on the table.
Question 5: What is the last Field in the list of PivotTable Fields?
Gross Margin %
6) Build your PivotTable.
· Add values and rows to the table.
· Note: There are four areas that you will place the fields you are making use of in your PivotTable (see image below). Each of the areas has a specific purpose, and facilitates different actions in the PivotTable:
· Filters: Placing a specific field in the Filter area will make it easier for you to filter your PivotTable by the different categories within the field (meaning, if you placed Industry in the Filter area, it would allow you to filter your data by any of the different categories within Industry). It will place the Filter above the PivotTable itself, allowing you to more rapidly navigate and see trends.
· Columns: Placing a specific field in the Columns area will create individual columns for each of the different categories within the field (meaning, if you placed Industry in the Columns area, it will show a sub-column for each of the different categories within Industry). If you have multiple fields in your Column area you can move them up/down to create a specific hierarchy. It is worth playing around with the order of your fields to best showcase your findings.
· Rows: Placing a specific field in the Rows area will create individual rows for each of the different categories within the field (meaning, if you placed Industry in the Rows area, it will show a row for each of the different categories within Industry). If you have multiple fields in your Rows area you can move them up/down to create a specific hierarchy. It is worth playing around with the order of your fields to best showcase your findings.
· Values: Placing a specific field in the Values area will add a basic mathematical calculation (Sum, Count, Average, etc.) to that specific field. The Excel default calculation is Sum for numerical data and Count for non-numerical data. Any calculation that is created by placing a field in the Values area will show as a column on your PivotTable. If you have multiple fields in your Values area you can move them up/down to create a specific hierarchy. It is worth playing around with the order of your fields to best showcase your findings. Also, if you have multiple fields in your Values area it will actually create a field called Values in the Columns area. You can also use this field with your other fields in the Columns area to customize your PivotTable further.
· First, click the Net Revenues field.
· You’ll see Sum of Net Revenues in the Values area.
· Next click on Year, and you may see it appear in the columns and values areas.
· Unclick Year and drag Year to the Rows area.
· Your Pivot Fields area should look like this:
Question 6: What number shows for Sum of Net Revenues in 2015?
4188205.199
7) Format the numbers in the PivotTable.
· Click on the Field labeled Sum of Net Revenues in the Values area.
· Select Value Field Settings and click the Number Format button in the lower left of the pop-up menu.
· Select Number, change the decimal places to 0, and click the box to show commas.
· Click OK, and OK again.
· Double click on the tab labeled Sheet 1 and change it to Sales by Year.
· When there are multiple worksheet tabs in a spreadsheet file, you can use Ctrl + Page Down or Page Up to quickly navigate through them.
Question 7: Now what number shows for Sum of Net Revenues in 2015?
4,188,205
Practice Assignment Screen Clipping 1
· Take a screen clipping of your PivotTable from Question 7 and paste below ‘Practice Assignment Screen Clipping 1’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
· Your screen clipping should look like the one from Question 7.
8) Sort data in a PivotTable.
· Return to your Practice Data tab.
· Create a new PivotTable with Net Revenues in the Values area, Year in the Columns area, and Name in the Rows area.
· You’ll see each company in its own row, with Net Revenues for each of the three years next to it.
· You will also see a Grand Total column. That column is created when you have at least one field in the Columns area and at least one field in the Values area.
· Click the down arrow next to Sum of Net Revenues in the Values area.
· Select Value Field Settings and click the Number Format button in the lower left of the pop-up menu.
· Select Number, change the decimal places to 0, and click the box to show commas.
· Click OK, and OK again.
· Can you find the companies with the highest Net Revenues for all three years?
· To make it easier, right click a number in the Grand Total column, select Sort, and sort from Largest to Smallest.
Question 8: Which Company had the highest Total Net Revenues?
Wall-Mart Stores Inc.
9) Change PivotTable calculations.
· Let’s change the Grand Total to an average of the three years.
· To do this we must change the calculation used in the Values area. This will update BOTH the calculation used in each column, AND the calculation used in the Grand Total column.
· Click the down arrow next to Sum of Net Revenues in the Values area.
· Select Value Field Settings and choose Average.
· Change the name of the sheet to Company Ave Sales by Year.
Question 9: What was the Average Net Revenues for Wall Mart?
477,067M
10) Count records.
· Return to your Practice Data tab.
· Create a new PivotTable with Net Revenues in the Values area, Year in the Columns area, and Name in the Rows area.
· Now change the Value Field Setting for Sum of Net Revenues to Count.
· You should see a table full of 1’s with 3’s for most Grand Totals.
· If you scroll to the bottom of the chart, you can see that you had Revenue information for 172 companies in 2013.
· Now drag Name out of the rows area and drag Industry in to see the number of Revenue records for each industry.
· Your PivotTable should look like the one below.
· Notice that there are 516 total values.
· Change the name of this worksheet tab to Industry Count.
Question 10: For how many Technology Companies do you have Revenue info?
30
11) Make a PivotChart.
· Return to the Practice Data tab and create a new PivotTable with Industry in the Rows, Years in the Columns, and Total Assets in the Values.
· Change the Value Field Setting for Sum of Total Assets to Average and change the format to Number with commas and 0 decimals.
· The Average of Total Assets for Capital Goods companies over the three-year period should be 41,097M.
· Click Insert, Charts, PivotChart from the menu and click OK to accept the Clustered Column format.
· Drag the corners of the chart to resize it so that you can see both the table and chart.
· Note: The true power of the PivotChart is how it is linked to the PivotTable it is created from. Any adjustment you make to either PivotChart or PivotTable will update the other one. This means any filter/sort action, or any larger modification, will affect both.
Question 11: Which Industry has Companies with the most Assets?
Finance
12) Filter the PivotTable and PivotChart and add a Slicer.
· In the chart, click on the drop-down arrow next to Industry and click the box next to Finance to unselect it, then click OK.
· Notice how the PivotTable and chart changed when you removed Finance.
· All the dropdown menus work like this, and it is a valuable analytical feature.
· Some users find slicers to be more intuitive way to filter their data.
· Note: Slicers are a visual way to filter your data. They are functionally the same as placing your field of interest in the Filters area, except instead of having a drop-down above the PivotTable, you will have a clickable interface for your filtering.
· Click on Insert Slicer from the PivotTable Analyze tab on the Ribbon and select Industry.
· Move and resize your slicer as desired.
· Notice that Finance is not selected.
· Click on the Finance button in the slicer.
· Hold Ctrl and click the cursor to select and deselect industries.
· Select all industries except Finance.
· Save this tab as Assets by Industry.
Question 12: Without Finance selected, in which Industry and Year have the highest Average of Total Assets?
Public Utilities 2015
Practice Assignment Screen Clipping 2
· Take a screen clipping of your PivotTable, PivotChart, and Slicer from Question 12 and paste below ‘Practice Assignment Screen Clipping 2’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
· Your screen clipping should look something like the image from Question 12.
13) Use Conditional Formatting.
· Now return to the Practice data sheet and create a new PivotTable with Debt to Assets in the Values area, Industry in the Rows area, and Years in the Columns area.
· Change Sum of Debt to Assets to an Average, and format it as a Percentage with 0 decimal places.
· In which Year did this group of companies have the largest Debt to Asset ratio?
· In which Industry was the Debt to Asset ratio the highest?
· The lowest?
· Highlight cells B5 through D10 and select Home, Conditional Formatting. Move your cursor to Color Scales and pick the first option, the Green-Yellow-Red Color Scale.
· Note: Conditional Formatting can be a great visual indicator to show trends when you have a lot of numerical data. Often times it can be hard for your audience to process a huge PivotTable, and this can make it easier to have quick takeaways. Be mindful to not over do it! Be thoughtful about what you are trying to showcase, and choose a color scheme that will make only the truly important things stand out!
· You’ll see the highest numbers highlighted in green and the lowest highlighted in red as shown below.
· Name the tab Debt to Assets.
Question 13: In which Industry and Year was Debt to Assets highest?
Public Utilities 2013
14) Explore data behind a number in the PivotTable.
· Notice that the 2013 Public Utilities ratio of 281% appears to be an outlier.
· Move your cursor to that cell (B8) and double-click.
· You’ll see all the underlying data for Public Utilities.
· Click on the drop-down menu next to the Debt to Assets heading and sort from Largest to Smallest.
· You can see that Sunworks Inc. is an outlier because the company’s Total Assets in 2013 were so small.
· Note: This view has all the numbers formatted in the General number format. This makes the value for Sunworks that much more significant. This is a ratio that should be formatted as a percentage. This means that the 69.92 is actually 6992%!
· Flag the value as an outlier by highlighting the cell in red:
· Right clicking on the cell
· Clicking the bucket icon (Fill Color)
· Changing the Fill Color to Red
· We’ll remove this data point in the next step.
· Name the tab Outlier.
Question 14: What was Sunworks’ Debt to Assets ratio in 2013?
69.91525424
15) Filter and modify data; refresh the PivotTable.
· Return to the Practice Data tab.
· Optional: Since we’ll be changing data in this tab (which is your original data), you may wish to make a duplicate. I always recommend this as a safety precaution so you don’t permanently change your data source.
· To do this, hold down the Ctrl key while you Click on the tab and drag it to a new sheet (the circle with the plus sign.). If you make a copy name it Original Practice Data to make it easy for you to remember the changes.
· We are now going to use Sort & Filter to clean our data (explained in greater detail in the Tools section on pages 3-4).
· From the Practice Data tab, click in the table and select Data, Filter.
· This will add drop-down menus to your field headings.
· Find the 2013 Debt to Assets ratio for Sunworks by sorting the Debt to Assets column from Largest to Smallest.
· Sunworks’ 2013 Debt to Assets ratio should be the first row. Highlight the cell with the Debt to Assets value in Red, and then delete it.
· Note: It is important that you delete the calculated value found in the Debt to Assets ratio, and not the Total Assets value (which was the actual outlier causing our calculation to be weird). If you delete the Total Assets value that will change other calculations in other PivotTables, and that can lead to come major confusion.
· Now return to your Debt to Assets PivotTable and select Data, Refresh All.
· Now the numbers are more in line with the other industries.
Question 15: Now what is the 3-year Average Debt to Assets ratio for Public Utilities?
34%
16) Use the PivotTable function to explore data.
· Think about which industries and companies you would expect to have the lowest and highest Gross Margin ratio. Why do you think that?
· Return to your Practice Data tab.
· Create a PivotTable with Industry in the Rows and Gross Margin % in the Values.
· Change the Value Field Settings for Sum of Gross Margin % to Average and change the format to Percentage with 0 decimal places.
· Check your results vs your initial expectations. Were you correct? Why or why not?
Question 16: Which Industry has the highest Gross Margin %?
Finance
17) Expand and collapse rows.
· Now add Name below Industry in the Rows area.
· Click on the Gross Margin ratio for any company and then right click and sort from Largest to Smallest.
· Notice that the data are sorted within the Industry categories.
· Collapse the Capital Goods Industry category by clicking on the small minus box to the left of Capital Goods.
· Collapse Consumer Services, Finance, Public Utilities, and Transportation as well.
· Rename the tab as Average Gross Margin %.
Question 17: Which Technology Company has the highest Average Gross Margin %?
18) Add a calculated field to a PivotTable.
· While PivotTables are a great way of consolidating large data sets, and quickly showing trends and relationships, their built in calculations can be limiting at times (the basic ones found by placing a field in the Values area). When you want to do a specific calculation that is not found in the Values area you will need to create a Calculated Field.
· Return to the Practice Data tab and create a new PivotTable with Industry in the Rows, Years in the Columns, and Total Assets in the Values.
· Change the Value Field Setting for Sum of Total Assets to Average and change the format to Number with commas and 0 decimals.
· Now, drag another copy of Total Assets to the value area below Average of Total Assets.
· Click on the second Total Assets Field and open the Value Field Settings menu and follow these instructions:
· Choose Average from the Summarize fields by tab
· Change the Custom Name to Change in Total Assets (M)
· Click on the Show Values As tab
· Click on the Show Values as dropdown menu (the default is No Calculation) and select % Difference From.
· In the Base field area, select Year
· In the Base item area, select (previous)
· Click OK to create the table.
· Columns B, D, and F show the Average of Total Assets for the given years.
· Columns C, E, and G show the percentage change in Average Total Assets from the previous year. Column C is blank because our data set does not have a year before 2013. Column E shows the percentage change in Average Total Assets from 2013 to 2014. Column G shows the percentage change in Average Total Assets from 2014 to 2015.
· Note: Because of the calculations we are making, columns C, H and I are unnecessary/don’t make sense. Column C is blank because there is not a previous year from 2013, so the calculation can’t happen. Columns H and I don’t make sense because a Grand Total can’t be calculated from a previous year. To avoid confusion, we will hide the three unnecessary columns.
· Highlight column C by clicking on the letter C.
· Right click and select Hide. Repeat for H and I.
· Rename the tab Year over Year Assets.
Question 18: What was the Average Change in the value of Total Assets between 2014 and 2015 for the Transportation Industry?
-1.49%
Practice Assignment Screen Clipping 3
· Take a screen clipping that shows all the worksheet tabs in your file.
· To see more tabs, you can drag the three vertical dots to the right of the tabs further to the right.
· Alternatively, you can right click on one of the arrows to the left of the first tab and a list of your worksheets will appear.
· Paste your screen clipping below ‘Practice Assignment Screen Clipping 3’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
19) Create a Dashboard!
· When you are looking at the trends/relationship in a data set you will often create multiple PivotTables/PivotCharts (In this assignment alone you made 7). It can often be helpful for your audience to see how multiple of your relationships change over time. The best way to show this is in a Dashboard.
· Note: There are a few different ways you can create a Dashboard out of PivotTables in Excel. Normally, I would take some of the PivotTables we already built and place them in a new worksheet (I would copy them and paste them into the new worksheet, and then build the Dashboard). In this case, we are going to build them from scratch. This is to show the full process of doing this, and because some of the PivotTables we will use in the Dashboard are modifications of ones made previously.
· Return to the Practice Data tab and create a new PivotTable in a New Worksheet with Industry in the Rows, Years in the Columns, and Total Assets in the Values.
· Change the Value Field Setting for Sum of Total Assets to Average and change the format to Number with commas and 0 decimals.
· Create a Clustered Column PivotChart and place it’s upper left corner in cell G3.
· Click the Format tab in the Ribbon and change the height to 3.6 and the width to 6.0.
· Rename the tab Dashboard.
· Note: These next steps are where we change our process slightly.
· Now return to the Practice data sheet and create a new PivotTable in an Existing Worksheet.
· Click the arrow to the right of the Location box.
· Click the Dashboard tab.
· Click cell A22.
· Hit Enter.
· You now have a second PivotTable within the same worksheet. In this new PivotTable, place Debt to Assets in the Values area, Industry in the Rows area, and Years in the Columns area.
· Change Sum of Debt to Assets to an Average, and format it as a Percentage with 0 decimal places.
· Create a Clustered Column PivotChart and place it’s upper left corner in cell G2.
· Click the Format tab in the Ribbon and change the height to 3.6 and the width to 6.0.
· Now return to the Practice data sheet and create a new PivotTable in an Existing Worksheet.
· Click the arrow to the right of the Location box.
· Click the Dashboard tab.
· Click cell A41.
· Hit Enter.
· You now have a second PivotTable within the same worksheet. In this new PivotTable, place Gross Margin % in the Values area, Industry in the Rows area, and Years in the Columns area.
· Change Sum of Gross Margin % to an Average, and format it as a Percentage with 0 decimal places.
· Create a Clustered Column PivotChart and place it’s upper left corner in cell G2.
· Click the Format tab in the Ribbon and change the height to 3.6 and the width to 6.0.
· You now have all the PivotCharts you will need for your Dashboard, so you can hide the PivotTables. Depending on how you wanted to organize your Dashboard, you might keep some/all of the PivotTables. For simplicity, we will use only the PivotCharts here.
· Highlight columns A through E, and hide them.
· Now move the upper left of the Average of Debt to Assets PivotChart to cell Q3.
· Next, move the upper left of the Average of Gross Margin % PivotChart to cell Q22.
· We now have all the PivotCharts in one location, but to create an actual Dashboard we need to create a way to filter them all simultaneously. To do this we will create some Slicers, and then link the Slicers to all three PivotCharts.
· Click the Average of Total Assets PivotChart.
· Click the PivotChart Analyze tab and click Insert Slicer.
· Select both Industry and Year to insert Slicers for both fields.
· Place the Industry Slicer in cell G22, and the Year Slicer in cell L22.
· To link the Slicers to all the PivotCharts, first select the Industry Slicer, right click the Slicer and select Report Connections.
· Here you will have a list of all the PivotTables that exist in the entire Excel file.
· Notice that all the PivotTables simply have a number in their name. This is because we didn’t create names for the specific PivotTables (there wasn’t a reason to do so at the time).
· Notice that the Sheet tells us where the given PivotTables are found.
· Select all three PivotTables that are found in the Dashboard Sheet.
· You have now connected the Industry Slicer to all three Dashboard PivotTables (and their PivotCharts since the PivotTables and PivotCharts are already linked).
· Follow the same process to link the Year Slicer to all the PivotCharts.
· Change both Slicers to Multi-select to allow you to see how all three PivotCharts respond when you filter out different things.
· Remove Finance. What standout out now that it is gone?
· Play around with your new Dashboard by selecting/de-selecting things you think might be interesting. What do you find?
Question 19: When Finance is removed what Industry and Year have the highest Average of Total Assets? Average of Debt to Assets? Average of Gross Margin %?
Public Utilities 2015, Public Utilities 2015, and Technology 2014 (respectively).
Practice Assignment Screen Clipping 4
· Take a screen clipping of your PivotTable, PivotChart, and Slicer from Question 19 and paste below ‘Practice Assignment Screen Clipping 4’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
· Your screen clipping should look something like the image from Question 19.
DUPONT ASSIGNMENT
History and model
The DuPont Method has an interesting history. E. I. du Pont de Nemours and Company, or more frequently called DuPont, is the oldest stock in the current Dow Jones Industrial Index. Started in July 1802, the company originally focused on producing gunpowder. Today, the company makes chemicals which are in everything from food ingredients and dietary supplements to pharmaceuticals and fabrics. In addition to developing chemicals, the company has been a pioneer with respect to management accounting systems. The company developed the original accounting ratio of return on equity (ROE) and then in 1912, Donaldson Brown decomposed ROE into additional ratios.
In a slightly simplified version of DuPont analysis, the following formula is used:
Return on Investment
=
Profit Margin
X
Investment Turnover
Net Operating Income
=
Net Operating Income
X
Sales Revenue
Average Invested Assets
Net Revenues
Average Invested Assets
For this assignment we will use the expanded DuPont Method, which is the following formula:
Return on Equity
=
Profit Margin
X
Asset Turnover
X
Financial Leverage
Net Income
=
Net Income
X
Net Revenues
X
Total Assets
Total Shareholder’s Equity
Net Revenues
Total Assets
Total Shareholder’s Equity
There are two main differences between the expanded model and the simplified model. First, the simplified model uses Return on Investment, or Return on Assets as our Return on Investment measure. In the expanded model, we’ll use Return on Equity. Second, we’ll add a calculation for Financial Leverage. Leverage is a measure of the amount of assets we’re able to control with our equity investment. If a company had no debt, Financial Leverage would equal 1. The more debt a company has, the higher this ratio will be. Leverage is a measure of risk. If a company has high Financial Leverage, returns to shareholder equity investments can be very large. Shareholders can make a lot of money if the company is profitable and lose a lot if it is unprofitable. We’ll also use the term Asset Turnover for the turnover measure. It’s more typical to use average invested assets to calculate this number, but we’re just using a single value for assets for simplicity.
Open the Excel file called DuPont Data.xlsx. You’ll use the DuPont data to demonstrate the analytical skills that you have. You will make use of all the ratios found in the expanded DuPont Method.
The ratios can be understood as follows:
·
Return on Equity
: This represents the amount of Net Income that is generated for each dollar of shareholder’s equity. It can be interpreted as the amount of Net Income generated for each dollar of value that a shareholder owns of the company. This number can be either negative or positive.
·
Profit Margin: This represents the amount of Net Income that is generated for each dollar of Net Revenue. It can be interpreted as the percentage of each dollar of revenue that the company retains as earnings. Since Net Income can be negative, this ratio can be either negative or positive.
·
Asset Turnover:
This represents the amount of Net Revenue that is generated for each dollar of Assets the company owns. This is often interpreted as the efficiency of the company—how much Revenue it can generate given the Assets it owns. Except in very unusual circumstances, this ratio is positive.
·
Financial Leverage: This represents the amount of Assets that are financed by shareholders, as opposed to debt holders. Except in very unusual circumstances, this ratio is positive.
Before you begin performing calculations, consider what you expect to see. Which industries would you expect to have the largest and smallest Return on Equity and Profit Margin? Which would you expect to have the highest and lowest Asset Turnover and Financial Leverage?
Requirements:
Work through the instructions below. As you work, you’ll be asked to:
· Follow the steps to perform the required analysis.
· Answer questions, many of which require PivotTables. You will save your answers to these questions in the ‘PivotTable Assignment Answer Sheet’.
· Paste 7 screen clippings into the ‘PivotTable Assignment Answer Sheet.’
The first thing you need to do is calculate the four DuPont ratios:
· In column I calculate Return on Equity. Format the cells as a percentage with 2 decimals.
· In column J calculate Profit Margin. Format the cells as a percentage with 2 decimals.
· In column K calculate Asset Turnover. Format the cells as a number with 2 decimals.
· In column L calculate Financial Leverage. Format the cells as a number with 2 decimals.
Many of the instructions in the DuPont assignment are very similar to those found in the Practice assignment. If you get stuck, you should use the Practice assignment as a resource to help you get un-stuck. Questions 10-30 have a ‘Check Figure’ section below each question. In the ‘Check Figure’ section, there are some answers that you can compare to your work. If you get the same answers as the ‘Check Figure’ answer, it is likely that your answers to the actual question will be correct. Remember to fill out your answers in the ‘PivotTable Assignment Answer Sheet.’ Have fun!
1) How much was American Airlines’ Net Revenues in 2013?
Check Figure:
Apple’s 2015 Net Revenues were 231,300M
2) What was the Return on Equity for Apple in 2015?
Check Figure:
American Airlines’ 2013 Return on Equity was 66.67%
3) Which company had the highest Net Income and in which year? What was the value?
Check Figure:
JP Morgan Chase had the fourth highest Net Income in 2015 with 23,900M.
4) Which company had the lowest Net Income and in which year? What was the value?
Check Figure:
American Airlines had the third lowest Net Income in 2013 with -1,800M.
5) How many unique companies in your sample had Net Losses exceeding one billion dollars? Which companies, and what years?
Check Figure:
There were 4 unique companies that had Net Losses between 100M and 150M dollars. They were:
·
Eagle Bulk Shipping in 2015
·
Navios Maritime Holdings in 2013 and 2015
·
Groupon in 2015
·
Teekay Corporation in 2013
6) What was the Sum of the Net Income for all companies in the sample for 2015?
·
When creating your PivotTable change the number format to Number with commas and 0 decimals.
Check Figure:
The Sum of Net Income for 2014 was 412,384M
7) Which company had the highest total Net Income over the three-year period? What was the value?
· When creating your PivotTable change the number format to Number with commas and 0 decimals.
Check Figure:
The company with the fourth highest total Net Income was Microsoft with 56,200M
8) Which company had the lowest total Net Income over the three-year period? What was the value?
· When creating your PivotTable change the number format to Number with commas and 0 decimals.
Check Figure:
The company with the third lowest total Net Income was Paragon Shipping with -332M
9) Which Industry had the highest Average Profit Margin over the three-year period? What was the value?
· When creating your PivotTable change the number format to Percentage with 2 decimals.
· When you create this PivotTable, you’ll find errors.
· Follow the instructions for Data Cleaning (explained in greater detail in the Tools section on page 3).
· Note: Remember that you want to delete the formulas in the cells that are getting the errors. Do not delete the base data or you will cause issues with your later answers.
· Refresh your PivotTable data to answer the question.
Check Figure:
Capital Goods had the third highest with 4.02%
10) In which year was the Average Profit Margin the highest for the entire sample? What was the value?
· When creating your PivotTable change the number format to Percentage with 2 decimals.
Check Figure:
The year the Average Profit Margin was the lowest for the entire sample was 2014 at -0.23%
11) For how many companies do you have Profit Margin data in 2013?
Check Figure:
There were 154 companies with Profit Margin ratio data in 2014
12) For what Industry do you have the most Profit Margin data in the sample? What was the value? For that Industry, what year was the highest? What was the value?
Check Figure:
The Industry with the least Profit Margin ratio data was Public Utilities with 71. The year it was highest was 2014 with 25.
DuPont Assignment Screen Clipping 1
· Take a screen clipping of your PivotTable from Q12 and paste below ‘DuPont Assignment Screen Clipping 1’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
13) Which Industry has the highest Average Asset Turnover over the three-year period? What was the value?
· When creating your PivotTable change the number format to Number with 2 decimals.
Check Figure:
The Industry with the lowest Asset Turnover was Finance with 0.13
DuPont Assignment Screen Clipping 2
· Create a PivotChart from the PivotTable in Q14.
· Create a Slicer for the Industry field and revise the chart by unselecting Consumer Services.
· Take a screen clipping of your PivotTable from Q14 and the PivotChart and Slicer you just created and paste below ‘DuPont Assignment Screen Clipping 2’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
14) Which of the remaining Industries has the highest Average Asset Turnover in 2014? What was the value?
· When creating your PivotTable change the number format to Number with 2 decimals.
Check Figure:
The remaining Industry with the third highest Average Asset Turnover in 2014 was Transportation with 0.67
DuPont Assignment Screen Clipping 3
· Create a PivotTable that shows Average Financial Leverage by Industry and Year.
· Use your cursor to highlight the data (don’t include Row or Column totals) and use Color Scale Conditional Formatting to highlight the high and low values as we did with the practice data.
· Take a screen clipping of the PivotTable you just created and paste below ‘DuPont Assignment Screen Clipping 3’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
15) Which Industry has the highest Average Financial Leverage over the three-year period? What was the value?
· When creating your PivotTable change the number format to Number with 2 decimals.
Check Figure:
The Industry with the second lowest Average Financial Leverage was Transportation with 2.35
16) Which Industry has the lowest Average Financial Leverage that does not include negative numbers in any year? What was the value?
· When creating your PivotTable change the number format to Number with 2 decimals.
Check Figure:
The Industry with the second lowest Average Financial Leverage that does not include negative numbers in any year was Capital Goods with 3.02
17) What is the Average Financial Leverage for the Transportation Industry in 2013? Note: The answer is odd. You will have to use Data Cleaning to resolve the issue.
· When creating your PivotTable change the number format to Number with 2 decimals.
· Transportation has a large negative value for Average Financial Leverage ratio in 2013 because three companies had negative Shareholder’s Equity in those years (which is unusual).
· Use Sort & Filter to clean your data (explained in greater detail in the Tools section on pages 3-4). Be sure to find and delete all the negative Financial Leverage ratios (but save the rest of the data).
· Now what is the Average Financial Leverage for Transportation companies in 2013?
Check Figure:
After the adjustments, the Average Financial Leverage for Technology companies in 2013 is 3.78
18) Which Industry has the highest Average Return on Equity over the three-year period, and which company is the highest within that Industry? What are the values?
· When creating your PivotTable change the number format to Percentage with 2 decimals.
Check Figure:
The Industry that has the second highest Average Return on Equity is Consumer Services with 23.73%, and the company that is highest within that Industry is Caesars Entertainment Corporation with 249.11%
DuPont Assignment Screen Clipping 4
· Take a screen clipping of the PivotTable from Q19 and paste below ‘DuPont Assignment Screen Clipping 4’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
19) Which two companies in the Public Utilities Industry have the highest Average Return on Equity during the period? What are the values?
· When creating your PivotTable change the number format to Percentage with 2 decimals.
Check Figure:
The two Public Utilities companies that have the lowest Average Return on Equity are Ocean Power Technologies with
-38.60% and American DG Energy with -42.75%
DuPont Assignment Screen Clipping 5
· Create a PivotTable that shows the Return on Equity by Industry and Year.
· When creating your PivotTable change the number format to Percentage with 2 decimals.
· Now add a Field that calculates the Percentage Change in Return on Equity between 2013 and 2014 and between 2014 and 2015.
· Hide unnecessary columns.
· Take a screen clipping of the PivotTable you just created and paste below ‘DuPont Assignment Screen Clipping 5’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
20) Which Industry had the largest decrease in Average Return on Equity between 2013 and 2014? What was the value?
Check Figure:
The Industry that had the second largest decrease in Average Return on Equity between 2013 and 2014 was Public Utilities with -53.70%
21) Which Industry had the largest increase in Average Return on Equity between 2014 and 2015? What was the value?
Check Figure:
The Industry that had the second largest increase in Average Return on Equity between 2014 and 2015 was Transportation with 136.34%
DuPont Assignment Screen Clippings 6
· Create a Dashboard that uses three of the PivotTable tables explored above.
· When creating your Dashboard make sure all your PivotTables have the correct number formats (consistent to what was used above).
· Follow the process used in the Practice Assignment to build a Dashboard.
· Decide on which PivotTables you think show interesting relationships/trends.
· Create a new version of each PivotTable in a new worksheet.
· Create a PivotChart for each PivotTable (for this type of process Column or Bar charts are probably best).
· Hide the PivotTables.
· Organize the PivotCharts in the best way to show the relationships/trends.
· Create Slicers for the fields involved in the relationships/trends.
· Link the Slicers to all the PivotTables in the Dashboard (and therefore the PivotCharts as well).
· Take a screen clipping of the Dashboard you just created and paste below ‘DuPont Assignment Screen Clipping 6’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
DuPont Assignment Screen Clippings 7
· Take a screen clipping of the Dashboard from Screen Clipping 6 showing the most interesting relationship you found and paste below ‘DuPont Assignment Screen Clipping 7’ in your ‘PivotTable Assignment Answer Sheet’ Word document.
22) Bonus Question 1: How many Industries were in your sample?
23) Bonus Question 2: PivotTables are a useful analytical tool for all business professionals; True or False?
24) Bonus Question 3: Which relationship displayed in the DuPont assignment was most interesting to you? Why?
Yuthas and Finn 2020 13
Based on data from Ernst & Young: Analytics mindset case study DuPont @2016
>Practice Data
icker
OGS (M)
2, 0
, 00
, 00
, 0
, 00
, 0
, 00
, 0
,000
, 3
,000
, 0
, 0
,800
, ,200
, 0
W
6 41 6 35 40 Technology 2013 4
9 25 8 3 26 5 Public Utilities 2013 36 8 6 9 7 21 9 7 2013 1 17 9 1 20 9 inance
2013 8
2014 1
8
Transportation 2013 36 5 2013 ,500
,400
,300
,000
,700
,000
,700
Finance 2013 92 – 0 – 0 Capital Goods 2013 – 0 3
11 6
7
10 Transportation 2013 1,000 0
Capital Goods 2013 – 0 0
8
– 0 Capital Goods 2013 43 – 0 0 – 0 0 0 – 0 Public Utilities 2013 4 53 14 11 33 39 Capital Goods 2013 ,600
,300
,400
Finance 2013 ,000
,800
– 0 ,800 – 0 – 0 Consumer Services 2013 8
1
Consumer Services 2013 – 0 58 101 4
Public Utilities 2013 Public Utilities 2013 1,200 318 1,200 Finance 2013 423 – 0 28 – 0 22 34 – 0 Finance 2013 – 0 ,000
4,800
– 0 – 0 Finance 2013 76 30 – 0 83 28 – 0 Consumer Services 2013 – 0 – 0 920 – 0 K
Finance 2013 22 8 – 0 20 12 – 0 20 14 – 0 Finance 2013 87 – 0 – 0 – 0 Public Utilities 2013 ,800
,500
,300
Consumer Services 2013 68,800 74,500 Transportation 2013 2,700 Technology 2013 57 1 30 16 Transportation 2013 28,700 5,200 9,900 Consumer Services 2013 19 – 0 86 82 Consumer Services 2013 Technology 2013 2 1 5 3 Transportation 2013 6,000 3,400 6,000 3,200 5,200 2,700 Finance 2013 4,700 101 – 0 – 0 193 – 0 K
Finance 2013 1,000 53 37 – 0 36 – 0 Technology 2013 16,200 Transportation 2013 7,500 7,900 7,000 Technology 2013 5 37 5 45 5 50 Technology 2013 – 0 65 – 0 586 74 – 0 608 82 Finance 2013 410 27 21 – 0 31 20 – 0 20 21 – 0 Consumer Services 2013 8,600 4,500 4,500 4,700 2,000 Transportation 2013 29,200 9,800 Transportation 2013 54 32 149 66 27 148 71 39 DoCoMo Inc. ADR
Technology 2013 Technology 2013 17 35 14 9 Capital Goods 2013 8,200 19,900 8,500 8,700 Consumer Services 2013 14,600 17,400 S
Transportation 2013 1,500 5,600 2,200 436 Technology 2013 17 6 18 7 Public Utilities 2013 ,800
,700
14,300 Public Utilities 2013 5,300 1,700 1,200 2,700 2,100 3,700 2,900 Transportation 2013 1,700 1,200 192 104 120 Public Utilities 2013 17,300 Transportation 2013 46 39 31 54 41 31 Consumer Services 2013 11 – 0 36 28 Capital Goods 2013 ,000
,000
,200
,900
Technology 2013 476 7,900 944 17,900 Finance 2013 2,600 300 – 0 – 0 – 0 Transportation 2013 33,000 33,600 Capital Goods 2013 2 1,400 1,100 40 1,400 1,100 12 1,600 1,200 Consumer Services 2013 154 65 81 58 Technology 2013 69 40 62 43 Capital Goods 2013 24,900 24,500 24,900 Transportation 2013 85 29 13 84 26 14 Public Utilities 2013 26 12 34 20 Finance 2013 3,100 – 0 640 – 0 – 0 Capital Goods 2013 ,300
46,900 Technology 2013 ,900
5,200 5,200 20,700 5,200 Finance 2013 39 – 0 19 3 Technology 2013 2,000 – 0 2,600 1,000 Capital Goods 2013 2,700 2,500 2,400 2,200 Public Utilities 2013 9,800 3
2,400 1,300 2,600 1,400 2,500 1,300 Consumer Services 2013 74,800 48,800 54,100 Capital Goods 2013 8,800 39,100 8,600 12,100 Finance 2013 – 0 – 0 – 0 Capital Goods 2013 4 10 2 2 Technology 2013 ,200
39,800 39,900 Technology 2013 18 – 0 7 2 Public Utilities 2013 701 117 Consumer Services 2013 1,300 436 462 Technology 2013 55,900 23,500 55,400 Public Utilities 2013 13 3 21 16 Consumer Services 2013 94 12 2 2 Consumer Services 2013 32 – 0 28 14 Technology 2013 100 677 283 1,100 Consumer Services 2013 24 – 0 49 43 Finance 2013 2,400,000 ,500
– 0 ,900
– 0 – 0 Capital Goods 2013 2 300 41 21 385 Capital Goods 2013 36,200 6,200 45,400 Consumer Services 2013 16 7 2 0 Consumer Services 2013 33,100 Technology 2013 29 0 47 24 Transportation 2013 13,400 13,100 12,000 Finance 2013 – 0 – 0 – 0 Consumer Services 2013 36,600 14,100 9,600 9,200 25,400 8,400 Consumer Services 2013 17 0 107 87 Capital Goods 2013 43 9 36 22 Consumer Services 2013 39 11 127 Technology 2013 ,400
77,700 22,600 Transportation 2013 – 0 1 1 – 0 53 24 47 36 26 Public Utilities 2013 7,800 8,400 8,200 Finance 2013 2,700 103 – 0 100 – 0 110 – 0 Public Utilities 2013 6,200 1,600 1,800 2,100 1,100 Public Utilities 2013 42,600 22,700 6,400 23,600 7,400 24,500 Transportation 2013 2,900 512 481 Capital Goods 2013 – 0 – 0 – 0 Transportation 2013 11,200 7,100 7,100 Public Utilities 2013 43,300 ,200
,000
41,100 37,100 47,900 Transportation 2013 1,300 131 315 120 Public Utilities 2013 3,000 Public Utilities 2013 25 0 4 3 Capital Goods 2013 – 0 583 318 398 Technology 2013 6,600 6,600 6,800 Transportation 2013 3,600 – 0 872 617 Public Utilities 2013 132 129 79 37 Transportation 2013 51 – 0 112 89 Consumer Services 2013 571 608 403 Technology 2013 378 2 77 34 – 0 109 49 – 0 62 Technology 2013 – 0 143 – 0 590 170 – 0 197 Consumer Services 2013 – 0 1,800 1,100 – 0 1,800 1,100 – 0 1,800 1,100 Transportation 2013 420 180 56 29 55 40 Transportation 2013 109 – 0 33 19 Transportation 2015 142 83 33 18 Finance 2013 28 – 0 5 4 Technology 2013 – 0 42 51 – 0 46 62 Capital Goods 2013 29 – 0 37 21 Consumer Services 2013 1,700 759 43 218 59 69 Capital Goods 2013 1,300 245 55 13 305 Finance 2013 38,100 – 0 38,600 – 0 – 0 Technology 2013 108 8 130 56 23 172 71 82 86 Transportation 2013 1,100 187 52 Consumer Services 2013 11,500 1,300 14,900 2,300 19,100 13,700 Technology 2013 49 14 79 73 109 – 0 325 Finance 2013 28 – 0 16 2 Transportation 2013 8 – 0 17 15 Public Utilities 2013 2,900 Consumer Services 2013 23,600 5,200 1,100 20,900 4,900 5,300 Technology 2013 3 0 1 0 Consumer Services 2013 1,300 25 43 Public Utilities 2013 4,100 1,200 1,200 1,100 349 Public Utilities 2013 0 3 10 7 Capital Goods 2013 30 3 30 23 Public Utilities 2013 74,800 Capital Goods 2013 148 0 48 0 165 60 Technology 2013 720 32 1,700 1,200 Finance 2013 33,100 – 0 – 0 30,200 – 0 Public Utilities 2013 72,700 Capital Goods 2013 12 3 8 7 Finance 2013 1 – 0 0 0 Transportation 2013 11,600 6,700 1,800 2,000 Public Utilities 2014 4,100 4,300 3,500 4,800 3,600 2,800 Capital Goods 2013 ,400
Capital Goods 2013 13,100 6,500 7,400 12,600 7,500 Technology 2013 5,900 6,600 Public Utilities 2013 11,900 9,200 4,000 8,300 3,300 5,100 1,700 Capital Goods 2013 15 1 11 11 Transportation 2013 22,000 11,900 12,400 21,800 10,800 Transportation 2013 36,200 Finance 2013 47,700 – 0 – 0 20,600 – 0 Capital Goods 2013 20,200 43,300 19,800 45,400 20,400 38,500 Public Utilities 2013 93,600 Finance 2013 38,500 – 0 35,600 – 0 30,200 – 0 Finance 2013 62 15 – 0 Technology 2013 1,300 172 544 192 Finance 2013 – 0 – 0 – 0 Capital Goods 2013 12 2 1 0 Capital Goods 2013 908 350 1,000 1,100 Consumer Services 2013 54,100 Finance 2013 400 584 – 0 – 0 – 0 Finance 2013 5 0 3 1 – 0 210 16 Public Utilities 2013 72 10 122 76 >DuPont Data
icker
2, 0
00)
, 00)
1
4
,800
00
0
0
,000
, 0
0, 0
,000
,800
3
, ,500
0,500
,400
,400
Y
Technology 4
3 1 41 6 2013 11 8 inance
2013 )
7 2015 50 20 Transportation 2013 36 28 3
2 2 30 3 2013 1)
,700
,000
6
Finance 2013 92 23 4
25 2013 7
39 6
35 7
3
33 Transportation 2013 0
8
30 9
41 Capital Goods 2013 364 10 5
14 3 Public Utilities 2013 53 1 22 Capital Goods 2013 ,400
6,300 Finance 2013 ,000
,700
97,800 ,200
Consumer Services 2013 8
1
16 Consumer Services 2013 21 349 27 2
Public Utilities 2013 1,200 1,200 Finance 2013 3
55 28 3 67 34 3 68 29 2 Finance 2013 ,300
13,400 ,000
,900
Finance 2013 8
57 30 1 52 30 55 28 0 Consumer Services 2013 61 920 53 59 K
Finance 2013 256 23 8 (1) 35 12 0 38 14 5 Finance 2013 87 26 33 47 Public Utilities 2013 ,000
,100
Consumer Services 2013 ,600
74,500 8,200 Transportation 2013 2,700 Technology 2013 57 45 30 Transportation 2013 2,500 2,900 9,900 2,800 Consumer Services 2013 30,300 10,800 ,200
2,000 ,600
2,100 Transportation 2013 6,700 6,000 4,800 6,000 1,300 3,500 5,200 Finance 2013 4,700 172 41 193 46 K
Finance 2013 1,000 187 37 7 40 9 Technology 2013 7,900 9,000 Transportation 2013 10,500 1,900 1,900 2,000 Technology 2013 (6) Technology 2013 53 586 64 4
608 26 Finance 2013 38 21 2 40 21 4 Consumer Services 2013 8,600 Transportation 2013 10,500 8,800 4,500 Transportation 2013 317 165 54 256 66 3 71 DoCoMo Inc. ADR
Technology 2013 6,000 4,600 Capital Goods 2013 2,700 2,600 2,600 Consumer Services 2013 ,200
45,000 8,400 Public Utilities 2013 ,800
41,300 2,700 1,900 ,200
23,400 2,900 Public Utilities 2013 2,200 1,700 2,900 3,700 50 Transportation 2013 1,700 7
104 )
Public Utilities 2013 2,600 2,800 2,500 Transportation 2014 41 (18) 38 (14) Consumer Services 2013 11 6 36 2 Capital Goods 2013 7,200 3,200 ,900
Technology 2013 7,900 1,500 2,900 17,900 3,700 Finance 2013 2,600 23 26 Transportation 2013 1,600 2,100 1,000 Capital Goods 2013 1,400 27 1,400 23 1,600 49 Consumer Services 2013 78 (4) 57 (1) Capital Goods 2013 2,400 2,500 10,700 3,000 Transportation 2013 60 29 6 63 26 3 Public Utilities 2013 26 10 34 (4) Finance 2013 3,100 1,100 640 5
Capital Goods 2013 5,300 3,900 9,700 Technology 2013 59,700 12,200 Finance 2013 39 37 19 (0) Technology 2013 2,000 2,600 3,200 3,100 Capital Goods 2013 2,700 )
2,500 2,300 Public Utilities 2013 9,800 3,500 2,400 3,700 2,500 Consumer Services 2013 4,500 5,400 6,300 Capital Goods 2013 45,400 3,900 17,700 4,200 4,800 Finance 2013 16,200 13,500 Technology 2013 12,000 14,300 Technology 2013 18 15 7 (2) Public Utilities 2013 (32) 14 51 Consumer Services 2013 1,300 6 21 3
Technology 2013 52,700 9,600 55,900 55,900 11,700 55,400 11,400 Public Utilities 2013 13 6 21 0 Consumer Services 2013 94 81 6 Consumer Services 2013 32 26 28 1 Technology 2013 154 33 31 1,100 56 Consumer Services 2013 24 21 49 3 Finance 2013 2,400,000 17,400 23,900 Capital Goods 2013 200 398 19 213 22 46 Capital Goods 2013 4,900 45,400 3,000 3,100 3,600 Consumer Services 2013 16 9 2 1 Consumer Services 2013 1,900 2,300 2,700 Technology 2013 29 20 47 (3) Transportation 2013 7,300 17,700 6,800 1,100 7,400 2,200 Finance 2013 2,000 Consumer Services 2013 5,600 4,800 7,100 4,500 Consumer Services 2013 17 10 107 3 Capital Goods 2013 43 18 36 (0) Consumer Services 2013 39 17 0 1 1 Technology 2013 ,400
77,700 21,900 12,200 Transportation 2013 245 243 1 (0) 53 7 36 (11) Public Utilities 2013 1,700 19,900 2,500 2,800 Finance 2013 2,700 103 19 110 20 Public Utilities 2013 6,200 2,200 1,800 )
Public Utilities 2013 15,500 3,600 19,900 4,000 17,800 24,500 3,200 Transportation 2013 2,900 1,100 )
(134) Capital Goods 2013 41 27 41 Transportation 2013 11,200 1,900 11,600 2,000 Public Utilities 2013 ,200
6,300 ,800
5,800 72,400 4,700 Transportation 2013 1,300 41 315 98 Public Utilities 2013 3,000 61 59 54 Public Utilities 2014 38 29 2 (11) Capital Goods 2013 40 35 57 Technology 2013 10,900 11,000 9,900 Transportation 2013 3,600 Public Utilities 2014 74 5 71 8 Transportation 2013 51 30 112 5 3 Consumer Services 2013 204 71 608 90 32 Technology 2013 378 10 77 (2) 91 109 (7) (14) Technology 2013 38 590 33 36 Consumer Services 2013 621 1,800 63 1,800 53 1,800 57 Transportation 2013 420 56 222 55 34 Transportation 2013 109 77 33 1 Transportation 2015 142 55 33 4 Finance 2014 61 7 13 4 Technology 2013 42 46 Capital Goods 2013 29 25 37 4 Consumer Services 2013 1,700 9 65 Capital Goods 2013 1,300 165 55 (1) 305 Finance 2013 38,100 8,200 38,600 8,200 47,500 8,000 Technology 2013 108 75 130 (9) 103 172 (11) 125 222 Transportation 2013 1,100 187 83 127 Consumer Services 2013 11,500 4,500 8 Technology 2013 49 79 (28) (21) 325 21 Finance 2013 28 25 16 (6) Transportation 2013 8 7 17 (2) Public Utilities 2013 2,900 752 82 97 105 Consumer Services 2013 5,800 5,200 1,200 5,100 4,900 1,300 4,500 5,300 1,600 Consumer Services 2013 1,300 (0) (4) 224 (30) Public Utilities 2013 4,100 1,200 1,200 Public Utilities 2013 0 (3) – 0 (4) Capital Goods 2013 30 24 30 1 Public Utilities 2013 86,400 6,200 13,300 Capital Goods 2013 148 108 18 129 165 20 157 20 Technology 2013 1,700 45 Finance 2013 33,100 6,400 7,100 6,400 Public Utilities 2013 6,100 4,000 12,000 3,000 Capital Goods 2014 11 4 16 0 Finance 2013 1 1 – 0 (0) Transportation 2013 11,600 1,100 1,800 2,500 82 Public Utilities 2014 13,900 5,400 4,300 139 4,300 3,600 Capital Goods 2013 11,600 18,200 19,800 Capital Goods 2013 13,100 1,300 16,900 1,900 17,000 2,000 Technology 2013 6,300 33,100 8,700 9,700 Public Utilities 2013 11,900 6,200 9,200 Capital Goods 2013 15 11 11 (2) Transportation 2013 21,200 4,400 5,200 20,700 4,800 Transportation 2013 36,200 6,500 4,400 4,800 Finance 2013 41,100 5,800 5,800 46,100 20,600 5,900 Capital Goods 2013 31,900 5,700 31,200 6,200 27,400 4,300 Public Utilities 2013 11,500 12,300 9,600 16,400 17,900 Finance 2013 6,800 42,400 6,900 30,200 6,300 Finance 2013 60 15 2 Technology 2013 1,300 Finance 2013 21,900 Capital Goods 2013 908 299 1,000 20 1,100 7 Consumer Services 2013 17,000 76,300 16,000 16,400 Finance 2013 104 107 Finance 2014 64 36 32 (5) 44 Public Utilities 2013 72 38 122 4
BA 325 Pivot Table Assignment Answer Sheet
Name:
Before you do anything fill out your name on the assignment and save your file as The table has all of the questions from the DuPont Assignment. Fill in your answers to the questions in the corresponding cell in the Answer column. Below the table there is a spot for the Screen Clippings from both the Practice Assignment, and the DuPont Assignment. After you have filled out all of the answers and Screen Clippings submit the file to the Assignments folder in D2L.
Q Number
Question
Answer
Q1
How much was American Airlines’ Net Revenues in 2013?
Q2
What was the Return on Equity for Apple in 2015?
Q3
Which company had the highest Net Income and in which year? What was the value?
Q4
Which company had the lowest Net Income and in which year? What was the value?
Q5
How many unique companies in your sample had Net Losses exceeding one billion dollars? Which companies, and what years?
Q6
What was the Sum of the Net Income for all companies in the sample for 2015?
Q7
Which company had the highest total Net Income over the three year period? What was the value?
Q8
Which company had the lowest total Net Income over the three year period? What was the value?
Q9
Which industry had the highest Average Profit Margin over the three year period? What was the value?
Q10
In which year was the Average Profit Margin the highest for the entire sample? What was the value?
Q11
For how many companies do you have Profit Margin ratio data in 2013?
Q12
For what Industry do you have the most Profit Margin ratio data in the sample? What was the value? For that Industry what year was the highest? What was the value?
Q13
Which Industry has the highest Average Asset Turnover over the three year period? What was the value?
Q14
Which of the remaining Industries has the highest Asset Turnover in 2014? What was the value?
Q15
Which Industry has the highest Average Financial Leverage over the three year period? What was the value?
Q16
Which Industry has the lowest Average Financial Leverage that does not include negative numbers in any year? What was the value?
Q17
What is the Average Financial Leverage for the Transportation Industry in 2013? Note: The answer is odd. You will have to use Data Cleaning to resolve the issue.
Q18
Which Industry has the highest Average Return on Equity over the three year period and which company is the highest within that Industry? What are the values?
Q19
Which two companies in the Public Utilities Industry have the highest Average Return on Equity during the period? What are the values?
Q20
Which Industry had the largest decrease in Average Return on Equity between 2013 and 2014? What was the value?
Q21
Which Industry had the largest increase in Average Return on Equity between 2014 and 2015? What was the value?
Q22
Bonus Question 1: How many industries were in your sample?
Q23
Bonus Question 2: Pivot Tables are a useful analytical tool for all business professionals, True or False?
Q24
Bonus Question 3: Which relationship displayed in the DuPont assignment was most interesting to you? Why? Screen Clipping 1: Screen Clipping 2: Screen Clipping 3: Screen Clipping 4: Screen Clipping 1: Screen Clipping 5: Screen Clipping 6: Screen Clipping 7: Yuthas and Finn 2018 6 Based on data from Ernst & Young Analytics mindset case study DuPont @2016
2
T
Name
Industry
Year
Total Assets (M)
Total Debt (M)
Net Revenues (M)
C
AAL
American Airlines Group Inc.
Transportation
2
0
1
3
4
30
20
6
26
7
1
9
10
AAL American Airlines Group Inc. Transportation
20
14
43
8
1
8,200
42
70
29
5
AAL American Airlines Group Inc. Transportation
20
15
48
40
20,700
41
25
400
AAPL
Apple Inc.
Technology
201
20
7,000
17
170
90
100
50
AAPL Apple Inc. Technology
2014
2
31
35
300
1
83
104
60
AAPL Apple Inc. Technology
2015
290,500
6
4,500
23
1,300
13
1,000
A
CP
Active Power Inc
Public Utilities
2013
38
62
ACPW Active Power Inc Public Utilities 2014
36
49
ACPW Active Power Inc Public Utilities 2015 31 6
57
ACY
Aerocentury Corp.
16
78
28
ACY Aerocentury Corp. Technology 2014
205
1
33
ACY Aerocentury Corp. Technology 2015
18
108
ADGE
American DG Energy Inc.
22
ADGE American DG Energy Inc. Public Utilities 2014 40
21
ADGE American DG Energy Inc. Public Utilities 2015
34
AEHR
Aehr Test Systems
Capital Goods
11
AEHR Aehr Test Systems Capital Goods 2014
12
AEHR Aehr Test Systems Capital Goods 2015 15 4 10 6
AHH
Armada Hoffler Properties Inc.
F
435
27
141
98
AHH Armada Hoffler Properties Inc.
Finance
59
359
1
69
121
AHH Armada Hoffler Properties Inc. Finance 2015
690
37
2
53
1
92
AIRT
Air T Inc.
– 0
103
87
AIRT Air T Inc. Transportation 2014 37 – 0
101
85
AIRT Air T Inc. Transportation 2015
44
112
95
AMZN
Amazon.com Inc.
Consumer Services
4
1,400
6,900
74
51
AMZN Amazon.com Inc. Consumer Services 2014
56
16,100
89
59,100
AMZN Amazon.com Inc. Consumer Services 2015
67
17,600
107
66
AROW
Arrow Financial Corporation
2,200
105
AROW Arrow Financial Corporation Finance 2014 2,200 90 95 – 0
AROW Arrow Financial Corporation Finance 2015
2,500
180
99
ASTE
Astec Industries Inc.
749
93
705
ASTE Astec Industries Inc. Capital Goods 2014
806
9
76
73
ASTE Astec Industries Inc. Capital Goods 2015
77
983
741
ATSG
Air Transport Services Group Inc.
385
58
423
ATSG Air Transport Services Group Inc. Transportation 2014 1,000
344
590
410
ATSG Air Transport Services Group Inc. Transportation 2015 1,000
318
6
19
421
AVAV
AeroVironment Inc.
3
64
24
137
AVAV AeroVironment Inc. Capital Goods 2014 385 – 0
2
52
149
AVAV AeroVironment Inc. Capital Goods 2015
39
259
1
47
AXDX
Accelerate Diagnostics Inc.
AXDX Accelerate Diagnostics Inc. Capital Goods 2014 70 0 0 – 0
AXDX Accelerate Diagnostics Inc. Capital Goods 2015
139
AZUR
Azure Midstream Partners LP
174
AZUR Azure Midstream Partners LP Public Utilities 2014
1
72
75
AZUR Azure Midstream Partners LP Public Utilities 2015
567
2
32
81
BA
Boeing Co.
9
2,700
9,800
86
71
BA Boeing Co. Capital Goods 2014
9
9,200
9,029
90,800
7
4,800
BA Boeing Co. Capital Goods 2015
94
9,900
96,100
80,300
BAC
Bank of America Corp. Corporation
2,100
493
9
7,800
BAC Bank of America Corp. Corporation Finance 2014 2,100,000
475,500
97
BAC Bank of America Corp. Corporation Finance 2015
2,200,000
4
39,100
92,100
BEL
Belmond Ltd.
1,900
640
594
2
68
BEL Belmond Ltd. Consumer Services 2014
1,700
61
586
263
BEL Belmond Ltd. Consumer Services 2015
1,500
583
55
244
BJRI
BJ’s Restaurants Inc.
611
775
4
65
BJRI BJ’s Restaurants Inc. Consumer Services 2014
647
8
46
512
BJRI BJ’s Restaurants Inc. Consumer Services 2015
6
82
920
54
BT
BT Group PLC
3
7,700
1
5,200
2
8,800
1
4,100
BT BT Group PLC Public Utilities 2014
41,500
16,300
29,200
1
4,000
BT BT Group PLC Public Utilities 2015
40,400
14,500
2
8,700
1
3,200
BWP
Boardwalk Pipeline Partners L.P.
7,900
3,400
1,200
282
BWP Boardwalk Pipeline Partners L.P. Public Utilities 2014 8,200
3,700
BWP Boardwalk Pipeline Partners L.P. Public Utilities 2015
8,300
3,
501
309
BYBK
Bay Bancorp Inc.
BYBK Bay Bancorp Inc. Finance 2014
483
BYBK Bay Bancorp Inc. Finance 2015 493 52 29 – 0
C
Citigroup Inc.
1,900,000
48
3,600
93,200
C Citigroup Inc. Finance 2014
1,800
45
94,000
C Citigroup Inc. Finance 2015
1,700,000
3
68,800
87,900
CARV
Carver Bancorp Inc.
638
CARV Carver Bancorp Inc. Finance 2014 640 70 30 – 0
CARV Carver Bancorp Inc. Finance 2015
676
CATO
Cato Corporation
533
944
582
CATO Cato Corporation Consumer Services 2014
597
571
CATO Cato Corporation Consumer Services 2015
608
987
601
C
FB
Central Federal Corporation
256
CFBK Central Federal Corporation Finance 2014
316
CFBK Central Federal Corporation Finance 2015
351
CFNL
Cardinal Financial Corporation
2,900
482
CFNL Cardinal Financial Corporation Finance 2014 3,400
458
165
CFNL Cardinal Financial Corporation Finance 2015 4,000 551
187
CHL
China Mobile Ltd.
192
835
102
2
2,800
CHL China Mobile Ltd. Public Utilities 2014
20
9,000
816
104,100
2
5,300
CHL China Mobile Ltd. Public Utilities 2015
2
19,900
1,869
106
32,800
CMCSA
Comcast Corp.
158,800
47,900
6
4,700
11,400
CMCSA Comcast Corp. Consumer Services 2014
159,300
48,200
20,900
CMCSA Comcast Corp. Consumer Services 2015
16
6,600
5
2,600
22,600
CMRE
Costamare Inc.
1,907
414
123
CMRE Costamare Inc. Transportation 2014 2,700
1,807
4
84
128
CMRE Costamare Inc. Transportation 2015 2,600
1,600
490
124
CNET
ChinaNet Online Holdings Inc.
CNET ChinaNet Online Holdings Inc. Technology 2014 47 1 39 31
CNET ChinaNet Online Holdings Inc. Technology 2015 36 – 0 32 23
CNI
Canadian National Railway Company
7,361
10,300
5,000
CNI Canadian National Railway Company Transportation 2014
27,800
7,270
11,000
CNI Canadian National Railway Company Transportation 2015
2
6,700
7,500
4,200
COSI
Cosi Inc.
COSI Cosi Inc. Consumer Services 2014 33 7 78 77
COSI Cosi Inc. Consumer Services 2015 41 11 90 89
COST
Costco Wholesale Corp.
30,300
5,204
105,200
91,000
COST Costco Wholesale Corp. Consumer Services 2014
3
3,000
5,307
1
12,600
9
7,400
COST Costco Wholesale Corp. Consumer Services 2015
33,400
6,500
1
1
6,200
99,900
COYN
COPsync Inc.
COYN COPsync Inc. Technology 2014 2 2 6 3
COYN COPsync Inc. Technology 2015 10 1 6 4
CP
Canadian Pacific Railway Ltd.
1
6,000
4,578
CP Canadian Pacific Railway Ltd. Transportation 2014
14,600
5,016
CP Canadian Pacific Railway Ltd. Transportation 2015
1
4,300
6,422
CPF
Central Pacific Financial Corp.
194
CPF Central Pacific Financial Corp. Finance 2014
4,900
131
193
CPF Central Pacific Financial Corp. Finance 2015
5,100
162
C
SB
Clifton Bancorp Inc.
CSBK Clifton Bancorp Inc. Finance 2014 1,300
143
CSBK Clifton Bancorp Inc. Finance 2015 1,200 108 40 – 0
CSCO
Cisco Systems Inc.
101,200
4
8,600
2
3,100
CSCO Cisco Systems Inc. Technology 2014
105,100
20,
908
4
7,100
17,400
CSCO Cisco Systems Inc. Technology 2015
11
3,500
25,400
49,200
17,300
CSX
CSX Corporation
31,800
9,533
1
2,000
CSX CSX Corporation Transportation 2014
33,100
9,728
12,700
CSX CSX Corporation Transportation 2015
35,000
10,
720
11,800
CUDA
Barracuda Networks Inc.
280
199
CUDA Barracuda Networks Inc. Technology 2014
350
234
CUDA Barracuda Networks Inc. Technology 2015
389
277
CVLT
CommVault Systems Inc.
605
496
CVLT CommVault Systems Inc. Technology 2014
755
CVLT CommVault Systems Inc. Technology 2015
714
CZFC
Citizens First Corporation
CZFC Citizens First Corporation Finance 2014
413
CZFC Citizens First Corporation Finance 2015
433
CZR
Caesars Entertainment Corporation
24,700
21,097
CZR Caesars Entertainment Corporation Consumer Services 2014
23,500
23,200
8,500
CZR Caesars Entertainment Corporation Consumer Services 2015
12,200
6,987
DAL
Delta Air Lines Inc.
59,400
11,300
37,600
DAL Delta Air Lines Inc. Transportation 2014
54,100
40,200
30,200
DAL Delta Air Lines Inc. Transportation 2015
53,100
8,400
40,500
26,600
DCIX
Diana Containerships Inc.
317
148
DCIX Diana Containerships Inc. Transportation 2014
409
DCIX Diana Containerships Inc. Transportation 2015
436
DCM
NTT
76,900
2,
698
54,000
21,400
DCM NTT DoCoMo Inc. ADR Technology 2014
72,900
2,308
4
4,400
18,400
DCM NTT DoCoMo Inc. ADR Technology 2015
5
9,600
1,928
39,800
18,300
DDAY
DraftDay Fantasy Sports Inc.
DDAY DraftDay Fantasy Sports Inc. Technology 2014 201 15 18 2
DDAY DraftDay Fantasy Sports Inc. Technology 2015 70 24 26 10
DHR
Danaher Corporation
34,700
3,
462
19,100
DHR Danaher Corporation Capital Goods 2014
37,000
3,472
DHR Danaher Corporation Capital Goods 2015 48,200
12,845
20,600
DIS
Walt Disney Co.
81,200
45,000
3
3,300
DIS Walt Disney Co. Consumer Services 2014
84,200
14,900
48,800
2
6,400
DIS Walt Disney Co. Consumer Services 2015
88,200
52,000
28,300
D
RY
DryShips Inc.
10,100
5,600
713
DRYS DryShips Inc. Transportation 2014
10,400
961
DRYS DryShips Inc. Transportation 2015
476
218
973
DTRM
Determine Inc.
DTRM Determine Inc. Technology 2014 22 7 16 8
DTRM Determine Inc. Technology 2015 37 10 21 11
DUK
Duke Energy Corporation
114
4
1,100
24,500
14,300
DUK Duke Energy Corporation Public Utilities 2014
120
42,500
23,900
DUK Duke Energy Corporation Public Utilities 2015
121,200
43,200
23,400
13,100
DYN
Dynegy Inc.
2,013
DYN Dynegy Inc. Public Utilities 2014
11,200
7,131
DYN Dynegy Inc. Public Utilities 2015
11,500
7,
283
EGLE
Eagle Bulk Shipping Inc.
111
EGLE Eagle Bulk Shipping Inc. Transportation 2014
914
220
154
117
EGLE Eagle Bulk Shipping Inc. Transportation 2015
787
242
EPD
Enterprise Products Partners L.P.
40,100
47,700
42,900
EPD Enterprise Products Partners L.P. Public Utilities 2014 47,100 21,400 47,900
43,100
EPD Enterprise Products Partners L.P. Public Utilities 2015
49,000
22,700
2
6,800
22,000
ESEA
Euroseas Ltd.
157
ESEA Euroseas Ltd. Transportation 2014
191
ESEA Euroseas Ltd. Transportation 2015 172 41 38 29
EVI
EnviroStar Inc.
EVI EnviroStar Inc. Consumer Services 2014 14 – 0 34 26
EVI EnviroStar Inc. Consumer Services 2015 9 – 0 31 23
F
Ford Motor Company
202
114,700
1
46,900
115
F Ford Motor Company Capital Goods 2014
208,500
119
144,100
1
12,100
F Ford Motor Company Capital Goods 2015
2
24,900
132
149,600
115,500
FB
Facebook Inc.
17,900
747
FB Facebook Inc. Technology 2014 40,200
233
12,500
FB Facebook Inc. Technology 2015
49,400
315
922
FCBC
First Community Bancshares Inc.
140
FCBC First Community Bancshares Inc. Finance 2014 2,600
230
134
FCBC First Community Bancshares Inc. Finance 2015 2,500
219
127
FDX
FedEx Corporation
33,600
2,951
44,300
FDX FedEx Corporation Transportation 2014 33,100
4,
701
45,600
FDX FedEx Corporation Transportation 2015
37,100
7,219
47,500
36,300
FIX
Comfort Systems USA Inc.
602
FIX Comfort Systems USA Inc. Capital Goods 2014
666
FIX Comfort Systems USA Inc. Capital Goods 2015
692
FLL
Full House Resorts Inc.
145
FLL Full House Resorts Inc. Consumer Services 2014 141 68 121 67
FLL Full House Resorts Inc. Consumer Services 2015 143 74
125
FSNN
Fusion Telecommunications International Inc.
FSNN Fusion Telecommunications International Inc. Technology 2014 74 46 92 50
FSNN Fusion Telecommunications International Inc. Technology 2015 106 77 102 57
GD
General Dynamis Corporation
35,400
3,901
31,200
GD General Dynamis Corporation Capital Goods 2014 35,400 3,901
30,900
GD General Dynamis Corporation Capital Goods 2015
32,000
3,401
31,500
GLBS
Globus Maritime Limited
156
GLBS Globus Maritime Limited Transportation 2014
152
GLBS Globus Maritime Limited Transportation 2015 115 78 13 13
G
LOW
Glowpoint Inc.
GLOW Glowpoint Inc. Public Utilities 2014 23 11 32 18
GLOW Glowpoint Inc. Public Utilities 2015 21 11 26 15
GLRE
Greenlight Capital Reinsurance Ltd.
GLRE Greenlight Capital Reinsurance Ltd. Finance 2014 3,000 – 0 690 – 0
GLRE Greenlight Capital Reinsurance Ltd. Finance 2015 2,700 – 0
427
GM
General Motors Company
166,300
36,200
1
55,400
130
GM General Motors Company Capital Goods 2014
1
77,700
1
5
5,900
134,900
GM General Motors Company Capital Goods 2015
194,500
63,100
15
2,400
118,200
GOOGL
Alphabet Inc.
110
59,700
21,900
GOOGL Alphabet Inc. Technology 2014
131,100
65,800
GOOGL Alphabet Inc. Technology 2015
147,500
73,600
23,100
GROW
US Global Investors Inc.
GROW US Global Investors Inc. Finance 2014 38 – 0 13 2
GROW US Global Investors Inc. Finance 2015 31 – 0 9 2
GRPN
Groupon Inc.
GRPN Groupon Inc. Technology 2014 2,200 38 3,200 1,500
GRPN Groupon Inc. Technology 2015 1,800 58 3,100 1,700
GSI
General Steel Holdings Inc.
1,995
GSI General Steel Holdings Inc. Capital Goods 2014 2,600
1,733
2,300
GXP
Great Plains Energy Inc.
3,
79
GXP Great Plains Energy Inc. Public Utilities 2014
10,500
4,048
GXP Great Plains Energy Inc. Public Utilities 2015 12,100
4,110
HD
Home Depot Inc.
41,100
10,800
HD Home Depot Inc. Consumer Services 2014 40,500
14,733
78,800
51,300
HD Home Depot Inc. Consumer Services 2015
39,900
17,228
83,200
HON
Honeywell International Inc.
45,400
25,000
HON Honeywell International Inc. Capital Goods 2014
45,500
40,300
25,600
HON Honeywell International Inc. Capital Goods 2015
49,300
38,600
23,600
HSBC
HSBC Holdings PLC
2,700,000
2
93,600
94,900
HSBC HSBC Holdings PLC Finance 2014
2,600,000
237,400
91,600
HSBC HSBC Holdings PLC Finance 2015
2,400,000
209,600
87,600
HTGM
HTG Molecular Diagnostics Inc.
HTGM HTG Molecular Diagnostics Inc. Capital Goods 2014 9 20 3 3
HTGM HTG Molecular Diagnostics Inc. Capital Goods 2015 39 20 4 3
IBM
International Business Machines Corp.
126
99,800
47,300
IBM International Business Machines Corp. Technology 2014
117,500
40,800
92,800
42,600
IBM International Business Machines Corp. Technology 2015
110,500
81,700
38,100
IDN
Intelligchekc Mobilisa Inc.
IDN Intelligchekc Mobilisa Inc. Technology 2014 16 – 0 7 2
IDN Intelligchekc Mobilisa Inc. Technology 2015 19 – 0 7 3
INFN
Infinera Corporation
109
544
301
INFN Infinera Corporation Public Utilities 2014
818
668
354
INFN Infinera Corporation Public Utilities 2015 1,200 125
887
448
INN
Summit Hotel Properties Inc.
299
198
INN Summit Hotel Properties Inc. Consumer Services 2014 1,500
627
402
262
INN Summit Hotel Properties Inc. Consumer Services 2015 1,600
677
296
INTC
Intel Corp.
92,400
13,
481
52,700
13,400
INTC Intel Corp. Technology 2014
92,000
13,700
12,000
INTC Intel Corp. Technology 2015
103,100
11,900
INVT
Inventergy Global Inc.
INVT Inventergy Global Inc. Public Utilities 2014 38 8 1 1
INVT Inventergy Global Inc. Public Utilities 2015 19 9 5 1
IOT
Income Opportunity Realty Investors Inc.
IOT Income Opportunity Realty Investors Inc. Consumer Services 2014 93 10 1 1
IOT Income Opportunity Realty Investors Inc. Consumer Services 2015 84 – 0 1 1
ISIG
Insignia Systems Inc.
ISIG Insignia Systems Inc. Consumer Services 2014 31 – 0 26 13
ISIG Insignia Systems Inc. Consumer Services 2015 32 – 0 28 14
JBT
John Bean Technologies Corporation
621
934
JBT John Bean Technologies Corporation Technology 2014 698
178
986
699
JBT John Bean Technologies Corporation Technology 2015
876
761
JCTCF
Jewett-Cameron Trading Company Ltd.
JCTCF Jewett-Cameron Trading Company Ltd. Consumer Services 2014 20 – 0 42 37
JCTCF Jewett-Cameron Trading Company Ltd. Consumer Services 2015 20 – 0 42 37
JPM
JP Morgan Chase & Co.
584
106,900
JPM JP Morgan Chase & Co. Finance 2014 2,600,000
617
97,500
JPM JP Morgan Chase & Co. Finance 2015 2,400,000
519,900
98,000
LDL
Lydall Inc.
275
398
LDL Lydall Inc. Capital Goods 2014
362
536
403
LDL Lydall Inc. Capital Goods 2015
358
525
LMT
Lockheed Martin Corp.
39,200
LMT Lockheed Martin Corp. Capital Goods 2014 37,100 6,200 45,600
38,400
LMT Lockheed Martin Corp. Capital Goods 2015
49,100
15,256
46,100
38,900
LOAN
Manhattan Bridge Capital Inc.
LOAN Manhattan Bridge Capital Inc. Consumer Services 2014 24 10 3 0
LOAN Manhattan Bridge Capital Inc. Consumer Services 2015 32 13 4
(0)
LOW
Lowe’s Companies
32,700
9,047
50,500
LOW Lowe’s Companies Consumer Services 2014 32,700
10,535
53,400
34,800
LOW Lowe’s Companies Consumer Services 2015 31,800
11,352
56,200
36,600
LTRX
Lantronix Inc.
LTRX Lantronix Inc. Technology 2014 31 0 45 22
LTRX Lantronix Inc. Technology 2015 29 1 43 22
LUV
Southwest Airlines Co.
19,300
2,829
17,700
LUV Southwest Airlines Co. Transportation 2014
20,200
2,658
18,600
LUV Southwest Airlines Co. Transportation 2015
23,300
3,137
19,800
LYG
Lloyds Banking Group PLC
1,400,000
227,800
83,000
LYG Lloyds Banking Group PLC Finance 2014
1,300,000
186,500
64,700
LYG Lloyds Banking Group PLC Finance 2015
1,200,000
189,800
46,800
MCD
McDonald’s Corp.
28,100
MCD McDonald’s Corp. Consumer Services 2014
34,300
15,000
27,400
MCD McDonald’s Corp. Consumer Services 2015
37,900
24,100
MHH
Mastech Holdings Inc.
MHH Mastech Holdings Inc. Consumer Services 2014 20 – 0 114 93
MHH Mastech Holdings Inc. Consumer Services 2015 39 13 124 100
MICT
Micronet Enertec Technologies Inc.
MICT Micronet Enertec Technologies Inc. Capital Goods 2014 45 14 34 24
MICT Micronet Enertec Technologies Inc. Capital Goods 2015 40 14 24 16
MOC
Command Security Corporation
150
MOC Command Security Corporation Consumer Services 2014 41 12 157 132
MOC Command Security Corporation Consumer Services 2015 37 6 139 117
MSFT
Microsoft Corp.
142
15,600
16,500
MSFT Microsoft Corp. Technology 2014
172,400
86,700
21,700
MSFT Microsoft Corp. Technology 2015
176,200
35,300
93,000
27,100
NAO
Nordic American Offshore Ltd.
245
NAO Nordic American Offshore Ltd. Transportation 2014
322
NAO Nordic American Offshore Ltd. Transportation 2015
337
NEE
NextEra Energy Inc.
69,300
28,500
14,400
NEE NextEra Energy Inc. Public Utilities 2014
74,900
29,100
16,400
NEE NextEra Energy Inc. Public Utilities 2015
82,500
29,700
15,800
NFBK
Northfield Bancorp Inc.
470
NFBK Northfield Bancorp Inc. Finance 2014 3,000
779
NFBK Northfield Bancorp Inc. Finance 2015 3,200
558
NFG
National Fuel Gas Company
902
NFG National Fuel Gas Company Public Utilities 2014 6,700
1,
686
NFG National Fuel Gas Company Public Utilities 2015 6,700 2,100 1,600
825
NGG
National Grid PLC
86,400
NGG National Grid PLC Public Utilities 2014
90,300
43,300
NGG National Grid PLC Public Utilities 2015
85,600
38,500
7,200
NM
Navios Maritime Holdings Inc.
1,521
349
NM Navios Maritime Holdings Inc. Transportation 2014 3,200
1,626
569
381
NM Navios Maritime Holdings Inc. Transportation 2015 3,000
1,620
363
NPK
National Presto Industries Inc.
394
420
332
NPK National Presto Industries Inc. Capital Goods 2014
378
412
325
NPK National Presto Industries Inc. Capital Goods 2015
397
428
328
NSC
Norfolk Southern Corporation
32,900
9,545
NSC Norfolk Southern Corporation Transportation 2014
33,200
9,302
11,600
NSC Norfolk Southern Corporation Transportation 2015 34,300 10,400 10,500 6,600
NTT
Nippon Telegraph and Telephone Corporation
209,100
129
55,200
NTT Nippon Telegraph and Telephone Corporation Public Utilities 2014
197
108,800
48,700
NTT Nippon Telegraph and Telephone Corporation Public Utilities 2015
1
72,700
100,600
NVGS
Navigator Holdings Ltd.
576
238
122
NVGS Navigator Holdings Ltd. Transportation 2014 1,400
543
305
NVGS Navigator Holdings Ltd. Transportation 2015 1,600
630
NWN
Northwest Natural Gas Company
930
759
515
NWN Northwest Natural Gas Company Public Utilities 2014 3,100
896
754
494
NWN Northwest Natural Gas Company Public Utilities 2015 3,100
872
724
429
OPTT
Ocean Power Technologies Inc.
OPTT Ocean Power Technologies Inc. Public Utilities 2014 38 0 2 1
OPTT Ocean Power Technologies Inc. Public Utilities 2015 19 0 4 4
ORBK
Orbotech Ltd.
637
440
239
ORBK Orbotech Ltd. Capital Goods 2014 1,000
297
ORBK Orbotech Ltd. Capital Goods 2015 1,000 238
753
ORCL
Oracle Corp.
81,800
18,500
37,200
ORCL Oracle Corp. Technology 2014 90,300
24,200
38,300
ORCL Oracle Corp. Technology 2015
110,900
42,000
38,200
OSGB
Overseas Shipholding Group Inc.
925
725
OSGB Overseas Shipholding Group Inc. Transportation 2014 3,400
1,712
OSGB Overseas Shipholding Group Inc. Transportation 2015 3,300
1,363
965
450
OTEL
Otelco Inc.
OTEL Otelco Inc. Public Utilities 2014 122 112 74 36
OTEL Otelco Inc. Public Utilities 2015 119 100 71 33
PATI
Patriot Transportation Holding Inc.
PATI Patriot Transportation Holding Inc. Transportation 2014 61 8 129 104
PATI Patriot Transportation Holding Inc. Transportation 2015 60 1 123 95
PCH
Potlatch Corporation
697
323
382
PCH Potlatch Corporation Consumer Services 2014 1,100
629
PCH Potlatch Corporation Consumer Services 2015 1,000
634
577
432
PCTY
Paylocity Holding Corporation
PCTY Paylocity Holding Corporation Technology 2014
528
PCTY Paylocity Holding Corporation Technology 2015
721
153
PEGA
Pegasystems Inc.
534
509
PEGA Pegasystems Inc. Technology 2014
588
PEGA Pegasystems Inc. Technology 2015
641
683
PLCE
Children’s Place Inc.
923
PLCE Children’s Place Inc. Consumer Services 2014
991
PLCE Children’s Place Inc. Consumer Services 2015
959
PRGN
Paragon Shipping Inc.
PRGN Paragon Shipping Inc. Transportation 2014
461
231
PRGN Paragon Shipping Inc. Transportation 2015 107 97 34 30
PWX
Providence and Worcester Railroad Company
PWX Providence and Worcester Railroad Company Transportation 2014 112 – 0 34 20
PWX Providence and Worcester Railroad Company Transportation 2015 114 1 36 21
PXS
Pyxis Tankers Inc.
PYDS
Payment Data Systems Inc.
PYDS Payment Data Systems Inc. Finance 2014 61 – 0 13 9
PYDS Payment Data Systems Inc. Finance 2015 68 – 0 14 9
RBCN
Rubicon Technology Inc.
203
RBCN Rubicon Technology Inc. Technology 2014
195
RBCN Rubicon Technology Inc. Technology 2015 119 2 24 36
RFIL
RF Industries Ltd.
RFIL RF Industries Ltd. Capital Goods 2014 29 – 0 23 13
RFIL RF Industries Ltd. Capital Goods 2015 32 – 0 33 22
RPT
Ramco-Gershenson Properties Trust
168
RPT Ramco-Gershenson Properties Trust Consumer Services 2014 1,900
924
RPT Ramco-Gershenson Properties Trust Consumer Services 2015 2,100
1,036
246
RUN
SunRun Inc.
RUN SunRun Inc. Capital Goods 2014 1,900 432 199 126
RUN SunRun Inc. Capital Goods 2015 3,000
719
213
RY
Royal Bank of Canada
825,400
124,100
RY Royal Bank of Canada Finance 2014
834,200
124,900
RY Royal Bank of Canada Finance 2015
821,000
1
21,800
35,100
SAAS
inContact Inc.
SAAS inContact Inc. Technology 2014
169
SAAS inContact Inc. Technology 2015
254
222
SB
Safe Bulkers Inc.
508
SB Safe Bulkers Inc. Transportation 2014 1,200 470 154 70
SB Safe Bulkers Inc. Transportation 2015 1,300 647 127 73
SBUX
Starbucks Corp.
11,100
SBUX Starbucks Corp. Consumer Services 2014 10,800 2,000 16,400 11,900
SBUX Starbucks Corp. Consumer Services 2015
12,400
SEDG
SolarEdge Technologies Inc.
SEDG SolarEdge Technologies Inc. Technology 2014 75 21
133
SEDG SolarEdge Technologies Inc. Technology 2015
306
241
SIEB
Siebert Financial Corporation
SIEB Siebert Financial Corporation Finance 2014 21 – 0 14 1
SIEB Siebert Financial Corporation Finance 2015 18 – 0 10 1
SINO
Sino-Global Shipping America Ltd.
SINO Sino-Global Shipping America Ltd. Transportation 2014 6 – 0 12 8
SINO Sino-Global Shipping America Ltd. Transportation 2015 12 – 0 11 6
SJI
South Jersey Industries Inc.
1,076
752
587
SJI South Jersey Industries Inc. Public Utilities 2014 3,300
1,275
911
675
SJI South Jersey Industries Inc. Public Utilities 2015 3,500
1,461
956
706
SPG
Simon Property Group Inc.
33,300
SPG Simon Property Group Inc. Consumer Services 2014
29,500
783
SPG Simon Property Group Inc. Consumer Services 2015
30,700
22,500
797
STAF
Staffing 360 Solutions Inc.
STAF Staffing 360 Solutions Inc. Technology 2014 44 19 46 44
STAF Staffing 360 Solutions Inc. Technology 2015 42 20 129 123
STAG
Stag Industrial Inc.
556
135
STAG Stag Industrial Inc. Consumer Services 2014 1,600 686 178 34
STAG Stag Industrial Inc. Consumer Services 2015 1,900 987
224
STR
Questar Corporation
1,577
453
STR Questar Corporation Public Utilities 2014 4,200
1,673
355
STR Questar Corporation Public Utilities 2015 4,400
1,709
SUNW
Sunworks Inc.
SUNW Sunworks Inc. Public Utilities 2014 7 2 20 15
SUNW Sunworks Inc. Public Utilities 2015 35 4 54 37
SVT
Servotronics Inc.
SVT Servotronics Inc. Capital Goods 2014 35 5 32 25
SVT Servotronics Inc. Capital Goods 2015 34 4 37 28
T
AT&T Inc.
277,800
128,800
51,500
T AT&T Inc. Public Utilities 2014
292,800
82,100
132,400
60,600
T AT&T Inc. Public Utilities 2015
402,700
126,100
146,800
67,000
TASR
Taser International Inc.
138
TASR Taser International Inc. Capital Goods 2014
185
TASR Taser International Inc. Capital Goods 2015 230 0 198 68
TBI
TrueBlue Inc.
TBI TrueBlue Inc. Technology 2014 1,100 202 2,200 1,600
TBI TrueBlue Inc. Technology 2015 1,300 246 2,700 2,100
TD
Toronto-Dominion Bank
827,100
107,600
TD Toronto-Dominion Bank Finance 2014
837,900
93,400
33,500
TD Toronto-Dominion Bank Finance 2015
844,100
96,700
TEF
Telefonica S.A.
163,800
79,500
75,900
45,300
TEF Telefonica S.A. Public Utilities 2014
148,000
67,900
66,600
41,400
TEF Telefonica S.A. Public Utilities 2015
133,600
52,100
35,600
TIK
Tel-Instrument Electronics Corp.
TIK Tel-Instrument Electronics Corp. Capital Goods 2014 11 2 16 9
TIK Tel-Instrument Electronics Corp. Capital Goods 2015 10 1 18 13
TIL
Till Capital Ltd.
TIL Till Capital Ltd. Finance 2014 53 0 10 3
TK
Teekay Corporation
918
TK Teekay Corporation Transportation 2014 11,900
6,759
937
TK Teekay Corporation Transportation 2015 13,100 7,400 2,500
960
TLN
Talen Energy Corporation
13,900
TLN Talen Energy Corporation Public Utilities 2015
12,800
TM
Toyota Motor Corp. ADR
377,400
150,300
266,100
210
TM Toyota Motor Corp. ADR Capital Goods 2014
402,400
158,500
256,500
195,400
TM Toyota Motor Corp. ADR Capital Goods 2015
398,000
158,200
248,000
185,800
TMO
Thermo Fisher Scientific Inc.
31,900
10,488
TMO Thermo Fisher Scientific Inc. Capital Goods 2014 42,900 14,600
16,900
TMO Thermo Fisher Scientific Inc. Capital Goods 2015
40,900
17,000
TSM
Taiwan Semiconductor Manufacturing Co. Ltd. ADR
42,400
7,625
20,100
TSM Taiwan Semiconductor Manufacturing Co. Ltd. ADR Technology 2014 47,300 7,900
25,100
TSM Taiwan Semiconductor Manufacturing Co. Ltd. ADR Technology 2015 50,500 7,700 26,600 7,200
TSU
TIM Participacoes S/A
2,114
TSU TIM Participacoes S/A Public Utilities 2014
12,300
2,684
TSU TIM Participacoes S/A Public Utilities 2015 9,000
2,398
UAMY
United States Antimony Corporation
UAMY United States Antimony Corporation Capital Goods 2014 17 1 11 11
UAMY United States Antimony Corporation Capital Goods 2015 18 2 13 13
UNP
Union Pacific Corp.
49,700
9,605
UNP Union Pacific Corp. Transportation 2014 52,700
11,462
24,000
UNP Union Pacific Corp. Transportation 2015
54,600
14,194
UPS
United Parcel Service Inc.
10,848
55,500
42,200
UPS United Parcel Service Inc. Transportation 2014
35,500
10,823
58,300
45,700
UPS United Parcel Service Inc. Transportation 2015 38,300 14,300
58,100
43,000
USB
U.S. Bancorp
367,700
20,000
USB U.S. Bancorp Finance 2014
406,200
62,200
20,400
USB U.S. Bancorp Finance 2015
425,700
60,000
UTX
United Technologies Corporation
90,600
62,700
UTX United Technologies Corporation Capital Goods 2014
91,300
65,200
UTX United Technologies Corporation Capital Goods 2015
87,500
56,300
VZ
Verizon Communications Inc.
274,100
120,600
44,900
VZ Verizon Communications Inc. Public Utilities 2014
232,700
113,200
127,100
49,900
VZ Verizon Communications Inc. Public Utilities 2015
244,600
110,200
131,600
52,600
WBK
Westpac Banking Corporation
652,100
151,700
WBK Westpac Banking Corporation Finance 2014
675,300
159,000
WBK Westpac Banking Corporation Finance 2015
571,000
136,300
WBKC
Wolverine Bancorp Inc.
298
WBKC Wolverine Bancorp Inc. Finance 2014 337 50 16 – 0
WEB
Web.com Group Inc.
563
492
WEB Web.com Group Inc. Technology 2014 1,200
507
WEB Web.com Group Inc. Technology 2015 1,200 423 544
188
WFC
Wells Fargo & Co.
1,500,000
206,900
89,500
WFC Wells Fargo & Co. Finance 2014 1,700,000
247,400
90,200
WFC Wells Fargo & Co. Finance 2015
1,800,000
297,000
90,700
WGBS
WaferGen Bio-systems Inc.
WGBS WaferGen Bio-systems Inc. Capital Goods 2014 21 2 6 2
WGBS WaferGen Bio-systems Inc. Capital Goods 2015 23 3 7 2
WMS
Advanced Drainage Systems Inc.
763
WMS Advanced Drainage Systems Inc. Capital Goods 2014
938
454
812
WMS Advanced Drainage Systems Inc. Capital Goods 2015 1,000 461 1,200 918
WMT
Wall-Mart Stores Inc.
203,100
469,200
344,000
WMT Wall-Mart Stores Inc. Consumer Services 2014
204,800
56,700
476,300
349,200
WMT Wall-Mart Stores Inc. Consumer Services 2015
203,700
50,400
485,700
355,900
WRLD
World Acceptance Corporation
831
WRLD World Acceptance Corporation Finance 2014
868
506
618
WRLD World Acceptance Corporation Finance 2015 887 501
610
YRD
Yirendai Ltd.
YRD Yirendai Ltd. Finance 2014 64 – 0 32 4
YRD Yirendai Ltd. Finance 2015
338
ZHNE
Zhone Technologies Inc.
ZHNE Zhone Technologies Inc. Public Utilities 2014 66 10 121 78
ZHNE Zhone Technologies Inc. Public Utilities 2015 57 5 101 61
2
T
Name
Industry
Year
Total Assets (M)
Total Shareholder Equity (M)
Net Revenues (M)
Net Income (M)
AAL
American Airlines Group Inc.
Transportation
2
0
1
3
4
30
(2,
7
2
6
700
(1,
8
AAL American Airlines Group Inc. Transportation
20
43
2,000
4
2,700
2,
9
AAL American Airlines Group Inc. Transportation
20
1
5
48,
40
5,
60
41
7,600
AAPL
Apple Inc.
Technology
20
13
207,000
1
23
50
17
90
37
AAPL Apple Inc. Technology
20
14
2
31
11
1,500
18
200
39
AAPL Apple Inc. Technology
20
15
29
1
19
23
1,300
53
A
C
Aerocentury Corp.
2013
16
49
28
ACY Aerocentury Corp. Technology
2014
205
35
25
(11)
ACY Aerocentury Corp. Technology
2015
83
26
ADGE
American DG Energy Inc.
Public Utilities
36
(5)
ADGE American DG Energy Inc. Public Utilities 2014 40 15 9
(6)
AHH
Armada Hoffler Properties Inc.
F
435
(
47
141
AHH Armada Hoffler Properties Inc.
Finance
690
253
AIRT
Air T Inc.
10
AIRT Air T Inc. Transportation 2014 37
27
101
AIRT Air T Inc. Transportation 2015
44
1
12
AMZN
Amazon.com Inc.
Consumer Services
4
1,400
9,700
7
4,500
2
74
AMZN Amazon.com Inc. Consumer Services 2014
5
6,300
10,700
8
9,000
(
24
AMZN Amazon.com Inc. Consumer Services 2015
67
1
3,400
107
59
AROW
Arrow Financial Corporation
2,200
1
92
22
AROW Arrow Financial Corporation Finance 2014 2,200 201
95
AROW Arrow Financial Corporation Finance 2015
2,500
21
99
ASTE
Astec Industries Inc.
Capital Goods
749
57
9
33
ASTE Astec Industries Inc. Capital Goods 2014
806
595
97
ASTE Astec Industries Inc. Capital Goods 2015
77
608
98
ATSG
Air Transport Services Group Inc.
1,000
369
58
(20)
ATSG Air Transport Services Group Inc. Transportation 2014 1,000
34
590
ATSG Air Transport Services Group Inc. Transportation 2015 1,000
3
64
61
AVAV
AeroVironment Inc.
315
240
AVAV AeroVironment Inc. Capital Goods 2014
38
343
2
52
AVAV AeroVironment Inc. Capital Goods 2015
398
349
259
AZUR
Azure Midstream Partners LP
174
160
AZUR Azure Midstream Partners LP Public Utilities 2014
1
72
1
54
75
BA
Boeing Co.
92,700
1
4,900
86,600
4,600
BA Boeing Co. Capital Goods 2014
9
9,200
8,700
90,800
5,400
BA Boeing Co. Capital Goods 2015
94
9
6,
100
5,200
BAC
Bank of America Corp. Corporation
2,100
2
32
97,800
11,400
BAC Bank of America Corp. Corporation Finance 2014 2,100,000
24
3,500
4,800
BAC Bank of America Corp. Corporation Finance 2015
2,200,000
2
56
92,100
1
5,900
BEL
Belmond Ltd.
1,900
908
594
(32)
BEL Belmond Ltd. Consumer Services 2014
1,700
761
586
(2)
BEL Belmond Ltd. Consumer Services 2015 1,500
65
55
BJRI
BJ’s Restaurants Inc.
611
401
775
BJRI BJ’s Restaurants Inc. Consumer Services 2014
647
8
46
BJRI BJ’s Restaurants Inc. Consumer Services 2015
68
317
920
45
BWP
Boardwalk Pipeline Partners L.P.
7,900
3,900
1,200
222
BWP Boardwalk Pipeline Partners L.P. Public Utilities 2014
8,200
4,000
229
BWP Boardwalk Pipeline Partners L.P. Public Utilities 2015
8,300
4,200
218
BYBK
Bay Bancorp Inc.
42
BYBK Bay Bancorp Inc. Finance 2014
483
BYBK Bay Bancorp Inc. Finance 2015
4
93
C
Citigroup Inc.
1,900,000
204
9
3,200
C Citigroup Inc. Finance 2014
1,800
2
10,500
94,000
7,200
C Citigroup Inc. Finance 2015
1,700,000
2
21,900
87
17,000
CARV
Carver Bancorp Inc.
63
CARV Carver Bancorp Inc. Finance 2014
640
(1)
CARV Carver Bancorp Inc. Finance 2015
676
CATO
Cato Corporation
533
345
944
CATO Cato Corporation Consumer Services 2014
597
3
91
CATO Cato Corporation Consumer Services 2015 608
380
987
C
FB
Central Federal Corporation
CFBK Central Federal Corporation Finance 2014
316
CFBK Central Federal Corporation Finance 2015
3
51
CFNL
Cardinal Financial Corporation
2,900
321
CFNL Cardinal Financial Corporation Finance 2014 3,400
377
165
CFNL Cardinal Financial Corporation Finance 2015 4,000
413
187
CHL
China Mobile Ltd.
19
2,800
1
30,300
102,500
1
9,800
CHL China Mobile Ltd. Public Utilities 2014
209
1
38,100
104
17,700
CHL China Mobile Ltd. Public Utilities 2015
21
9,900
1
41,300
106,300
1
7,300
CMCSA
Comcast Corp.
15
8,800
50,700
6
4,700
6,800
CMCSA Comcast Corp. Consumer Services 2014
15
9,300
52,700
68,800
8,400
CMCSA Comcast Corp. Consumer Services 2015
1
66
5
2,300
CMRE
Costamare Inc.
657
414
103
CMRE Costamare Inc. Transportation 2014 2,700
803
4
84
115
CMRE Costamare Inc. Transportation 2015
2,600
964
490
144
CNET
ChinaNet Online Holdings Inc.
(0)
CNET ChinaNet Online Holdings Inc. Technology 2014 47 36 39
(14)
CNET ChinaNet Online Holdings Inc. Technology 2015 36 27 32
(9)
CNI
Canadian National Railway Company
28,700
12,200
10,300
CNI Canadian National Railway Company Transportation 2014
27,800
1
1,600
11,000
CNI Canadian National Railway Company Transportation 2015
2
6,700
10,800
COST
Costco Wholesale Corp.
105
COST Costco Wholesale Corp. Consumer Services 2014
3
3,000
12,300
112
COST Costco Wholesale Corp. Consumer Services 2015
33,400
10,600
1
1
6,200
2,400
CP
Canadian Pacific Railway Ltd.
1
6,000
849
CP Canadian Pacific Railway Ltd. Transportation 2014
14,600
CP Canadian Pacific Railway Ltd. Transportation 2015
1
4,300
1,100
CPF
Central Pacific Financial Corp.
660
194
CPF Central Pacific Financial Corp. Finance 2014 4,900
568
193
CPF Central Pacific Financial Corp. Finance 2015
5,100
495
C
SB
Clifton Bancorp Inc.
CSBK Clifton Bancorp Inc. Finance 2014 1,300 194 36 7
CSBK Clifton Bancorp Inc. Finance 2015 1,200
368
CSCO
Cisco Systems Inc.
101,200
59,100
4
8,600
10,000
CSCO Cisco Systems Inc. Technology 2014
105,100
56,700
4
7,100
CSCO Cisco Systems Inc. Technology 2015
1
13,500
59,700
49,200
CSX
CSX Corporation
31,800
12,000
CSX CSX Corporation Transportation 2014
3
3,100
11,200
12,700
CSX CSX Corporation Transportation 2015
35,000
11,700
11,800
CUDA
Barracuda Networks Inc.
280
(21)
199
(7)
CUDA Barracuda Networks Inc. Technology 2014
350
234
(4)
CUDA Barracuda Networks Inc. Technology 2015
389
(39)
277
(68)
CVLT
CommVault Systems Inc.
605
354
496
CVLT CommVault Systems Inc. Technology 2014
755
463
CVLT CommVault Systems Inc. Technology 2015
71
407
CZFC
Citizens First Corporation
410
CZFC Citizens First Corporation Finance 2014 413 38 20 3
CZFC Citizens First Corporation Finance 2015
433
CZR
Caesars Entertainment Corporation
24,700
(3,100)
(2,900)
CZR Caesars Entertainment Corporation Consumer Services 2014
23,500
(5,000)
8,500
(2,800)
CZR Caesars Entertainment Corporation Consumer Services 2015 12,200 987 4,700 5,900
DAL
Delta Air Lines Inc.
59,400
11,600
37,600
DAL Delta Air Lines Inc. Transportation 2014
5
4,100
40,200
659
DAL Delta Air Lines Inc. Transportation 2015
53,100
10,900
40,500
DCIX
Diana Containerships Inc.
(57)
DCIX Diana Containerships Inc. Transportation 2014
409
DCIX Diana Containerships Inc. Transportation 2015
436
239
(18)
DCM
NTT
7
6,900
57,700
54,000
DCM NTT DoCoMo Inc. ADR Technology 2014
72,900
54,800
4
4,400
DCM NTT DoCoMo Inc. ADR Technology 2015
5
9,600
44,900
39,800
3,700
DHR
Danaher Corporation
34,700
22,400
19,100
DHR Danaher Corporation Capital Goods 2014
37,000
23,400
19,900
DHR Danaher Corporation Capital Goods 2015
48,200
23,700
20,600
DIS
Walt Disney Co.
81
45,400
45,000
6,100
DIS Walt Disney Co. Consumer Services 2014
84,200
48,800
7,500
DIS Walt Disney Co. Consumer Services 2015
88,200
44,500
52,000
DUK
Duke Energy Corporation
114
24,500
DUK Duke Energy Corporation Public Utilities 2014
1
20,700
40,900
23,900
DUK Duke Energy Corporation Public Utilities 2015
121
39,700
DYN
Dynegy Inc.
5,300
(356)
DYN Dynegy Inc. Public Utilities 2014 11,200 3,000 2,700
(273)
DYN Dynegy Inc. Public Utilities 2015
11,500
EGLE
Eagle Bulk Shipping Inc.
531
192
(71)
EGLE Eagle Bulk Shipping Inc. Transportation 2015
78
518
(
148
EPD
Enterprise Products Partners L.P.
40,100
15,200
47,700
EPD Enterprise Products Partners L.P. Public Utilities 2014 47,100
18,100
47,900
EPD Enterprise Products Partners L.P. Public Utilities 2015
49,000
20,300
26,800
ESEA
Euroseas Ltd.
191
131
ESEA Euroseas Ltd. Transportation 2015 172
127
EVI
EnviroStar Inc.
EVI EnviroStar Inc. Consumer Services 2014 14 5 34 2
EVI EnviroStar Inc. Consumer Services 2015 9 5 31 2
F
Ford Motor Company
202,000
2
6,400
1
46,900
F Ford Motor Company Capital Goods 2014
208,500
24,800
144,100
F Ford Motor Company Capital Goods 2015
224
28,600
149,600
7,400
FB
Facebook Inc.
17,900
15,500
FB Facebook Inc. Technology 2014 40,200
36,100
12,500
FB Facebook Inc. Technology 2015
49,400
44,200
FCBC
First Community Bancshares Inc.
329
140
FCBC First Community Bancshares Inc. Finance 2014 2,600 351
134
FCBC First Community Bancshares Inc. Finance 2015 2,500 343 127 25
FDX
FedEx Corporation
3
3,600
17,400
44,300
FDX FedEx Corporation Transportation 2014
33,100
15,300
4
5,600
FDX FedEx Corporation Transportation 2015
37,100
15,000
47,500
FIX
Comfort Systems USA Inc.
602
296
FIX Comfort Systems USA Inc. Capital Goods 2014
666
306
FIX Comfort Systems USA Inc. Capital Goods 2015
692
347
FLL
Full House Resorts Inc.
154
145
FLL Full House Resorts Inc. Consumer Services 2014 141 58 121 (21)
FLL Full House Resorts Inc. Consumer Services 2015
143
125
GD
General Dynamis Corporation
35,400
14,500
31,200
GD General Dynamis Corporation Capital Goods 2014 35,400 11,800
30,900
GD General Dynamis Corporation Capital Goods 2015
32,000
31,500
GLBS
Globus Maritime Limited
156
GLBS Globus Maritime Limited Transportation 2014
152
G
LOW
Glowpoint Inc.
GLOW Glowpoint Inc. Public Utilities 2014 23 8 32
(3)
GLOW Glowpoint Inc. Public Utilities 2015 21 6 26 (2)
GLRE
Greenlight Capital Reinsurance Ltd.
226
GLRE Greenlight Capital Reinsurance Ltd. Finance 2014 3,000 1,200 690
110
GLRE Greenlight Capital Reinsurance Ltd. Finance 2015 2,700
82
427
(326)
GM
General Motors Company
166,300
42,600
1
55,400
GM General Motors Company Capital Goods 2014
1
77,700
35,500
1
55,900
GM General Motors Company Capital Goods 2015
194,500
39,900
152,400
GOOGL
Alphabet Inc.
110,900
87,300
GOOGL Alphabet Inc. Technology 2014
131,100
104,500
6
5,800
13,700
GOOGL Alphabet Inc. Technology 2015
147,500
120,300
73,600
16,300
GROW
US Global Investors Inc.
GROW US Global Investors Inc. Finance 2014 38 35 13 (1)
GROW US Global Investors Inc. Finance 2015 31 29 9 (4)
GRPN
Groupon Inc.
714
(95)
GRPN Groupon Inc. Technology 2014 2,200
763
(73)
GRPN Groupon Inc. Technology 2015 1,800
469
(134)
GSI
General Steel Holdings Inc.
(
305
(33)
GSI General Steel Holdings Inc. Capital Goods 2014 2,600
(345)
(49)
GXP
Great Plains Energy Inc.
250
GXP Great Plains Energy Inc. Public Utilities 2014 10,500 3,600 2,600
243
GXP Great Plains Energy Inc. Public Utilities 2015
12,100
213
HD
Home Depot Inc.
41,100
17,800
74,800
HD Home Depot Inc. Consumer Services 2014 40,500 12,500
78,800
HD Home Depot Inc. Consumer Services 2015 39,900 9,300
83,200
HON
Honeywell International Inc.
17,500
39,100
HON Honeywell International Inc. Capital Goods 2014
45,500
40,300
HON Honeywell International Inc. Capital Goods 2015
49,300
18,300
38,600
HSBC
HSBC Holdings PLC
2,700,000
176,000
94,900
HSBC HSBC Holdings PLC Finance 2014
2,600,000
177,400
91,600
13,600
HSBC HSBC Holdings PLC Finance 2015
2,400,000
17
3,300
87,600
IBM
International Business Machines Corp.
126,200
22,800
99,800
1
6,500
IBM International Business Machines Corp. Technology 2014
117,500
11,900
92,800
IBM International Business Machines Corp. Technology 2015
110,500
81,700
13,300
IDN
Intelligchekc Mobilisa Inc.
IDN Intelligchekc Mobilisa Inc. Technology 2015 19 16 7 (5)
INFN
Infinera Corporation
701
418
544
INFN Infinera Corporation Public Utilities 2014
818
482
668
INFN Infinera Corporation Public Utilities 2015 1,200
7
62
887
INN
Summit Hotel Properties Inc.
810
299
INN Summit Hotel Properties Inc. Consumer Services 2014 1,500
780
402
INN Summit Hotel Properties Inc. Consumer Services 2015 1,600
85
462
124
INTC
Intel Corp.
92,400
58,300
INTC Intel Corp. Technology 2014
92,000
INTC Intel Corp. Technology 2015
103,100
61,100
INVT
Inventergy Global Inc.
IOT
Income Opportunity Realty Investors Inc.
– 0
IOT Income Opportunity Realty Investors Inc. Consumer Services 2014 93 83 – 0 2
IOT Income Opportunity Realty Investors Inc. Consumer Services 2015 84 84 – 0 2
ISIG
Insignia Systems Inc.
ISIG Insignia Systems Inc. Consumer Services 2014 31 25 26 0
ISIG Insignia Systems Inc. Consumer Services 2015 32 25 28 2
JBT
John Bean Technologies Corporation
621
934
JBT John Bean Technologies Corporation Technology 2014
698
119
986
JBT John Bean Technologies Corporation Technology 2015
876
130
JCTCF
Jewett-Cameron Trading Company Ltd.
JCTCF Jewett-Cameron Trading Company Ltd. Consumer Services 2014 20 18 42 2
JCTCF Jewett-Cameron Trading Company Ltd. Consumer Services 2015 20 18 42 2
JPM
JP Morgan Chase & Co.
211,200
106,900
JPM JP Morgan Chase & Co. Finance 2014 2,600,000
232,100
97,500
21,200
JPM JP Morgan Chase & Co. Finance 2015 2,400,000
247,600
9
8,000
LDL
Lydall Inc.
275
LDL Lydall Inc. Capital Goods 2014
362
536
LDL Lydall Inc. Capital Goods 2015
358
245
525
LMT
Lockheed Martin Corp.
36,200
LMT Lockheed Martin Corp. Capital Goods 2014 37,100 3,400 45,600 3,600
LMT Lockheed Martin Corp. Capital Goods 2015
49,100
46,100
LOAN
Manhattan Bridge Capital Inc.
LOAN Manhattan Bridge Capital Inc. Consumer Services 2014 24 14 3 2
LOAN Manhattan Bridge Capital Inc. Consumer Services 2015 32 18 4 2
LOW
Lowe’s Companies
32,700
13,900
50,500
LOW Lowe’s Companies Consumer Services 2014 32,700 11,900
53,400
LOW Lowe’s Companies Consumer Services 2015 31,800 10,000
56,200
LTRX
Lantronix Inc.
LTRX Lantronix Inc. Technology 2014 31 20 45 (1)
LTRX Lantronix Inc. Technology 2015 29 19 43 (3)
LUV
Southwest Airlines Co.
19,300
757
LUV Southwest Airlines Co. Transportation 2014
20,200
18,600
LUV Southwest Airlines Co. Transportation 2015
23,300
19,800
LYG
Lloyds Banking Group PLC
1,400,000
64,600
83,000
(1,300)
LYG Lloyds Banking Group PLC Finance 2014
1,300,000
67,600
64,700
LYG Lloyds Banking Group PLC Finance 2015
1,200,000
60,800
46,800
833
MCD
McDonald’s Corp.
36,600
16,000
28,100
MCD McDonald’s Corp. Consumer Services 2014
34,300
12,900
27,400
MCD McDonald’s Corp. Consumer Services 2015
37,900
25,400
MHH
Mastech Holdings Inc.
MHH Mastech Holdings Inc. Consumer Services 2014 20 13 114 3
MHH Mastech Holdings Inc. Consumer Services 2015 39 16 124 3
MICT
Micronet Enertec Technologies Inc.
MICT Micronet Enertec Technologies Inc. Capital Goods 2014 45 14 34 (2)
MICT Micronet Enertec Technologies Inc. Capital Goods 2015 40 11 24 (3)
MOC
Command Security Corporation
150
MOC Command Security Corporation Consumer Services 2014 41 19
157
MOC Command Security Corporation Consumer Services 2015 37 21
139
MSFT
Microsoft Corp.
142
78,900
MSFT Microsoft Corp. Technology 2014
1
72,400
89,800
86,700
22,100
MSFT Microsoft Corp. Technology 2015
176,200
80,100
93,000
NAO
Nordic American Offshore Ltd.
NAO Nordic American Offshore Ltd. Transportation 2014
322
319
NAO Nordic American Offshore Ltd. Transportation 2015
337
281
NEE
NextEra Energy Inc.
69,300
18,000
14,400
NEE NextEra Energy Inc. Public Utilities 2014
74,900
16,400
NEE NextEra Energy Inc. Public Utilities 2015
82,500
22,600
15,800
NFBK
Northfield Bancorp Inc.
716
NFBK Northfield Bancorp Inc. Finance 2014 3,000 594 100 20
NFBK Northfield Bancorp Inc. Finance 2015 3,200
560
NFG
National Fuel Gas Company
260
NFG National Fuel Gas Company Public Utilities 2014 6,700 2,400 2,100 299
NFG National Fuel Gas Company Public Utilities 2015 6,700 2,000 1,600
(3
79
NGG
National Grid PLC
86,400
22,700
NGG National Grid PLC Public Utilities 2014
90,300
23,600
NGG National Grid PLC Public Utilities 2015
85,600
NM
Navios Maritime Holdings Inc.
512
(
109
NM Navios Maritime Holdings Inc. Transportation 2014 3,200 1,200
569
(56)
NM Navios Maritime Holdings Inc. Transportation 2015 3,000
989
481
NPK
National Presto Industries Inc.
394
333
420
NPK National Presto Industries Inc. Capital Goods 2014
378
325
412
NPK National Presto Industries Inc. Capital Goods 2015
397
339
428
NSC
Norfolk Southern Corporation
32,900
11,300
NSC Norfolk Southern Corporation Transportation 2014
33,200
12,400
NSC Norfolk Southern Corporation Transportation 2015 34,300 12,200 10,500 1,600
NTT
Nippon Telegraph and Telephone Corporation
209,100
88,500
129
NTT Nippon Telegraph and Telephone Corporation Public Utilities 2014
197,000
82,600
108
NTT Nippon Telegraph and Telephone Corporation Public Utilities 2015
172,700
100,600
NVGS
Navigator Holdings Ltd.
721
238
NVGS Navigator Holdings Ltd. Transportation 2014 1,400 806 305 85
NVGS Navigator Holdings Ltd. Transportation 2015 1,600
910
NWN
Northwest Natural Gas Company
752
759
NWN Northwest Natural Gas Company Public Utilities 2014 3,100
767
754
NWN Northwest Natural Gas Company Public Utilities 2015 3,100
781
724
OPTT
Ocean Power Technologies Inc.
ORBK
Orbotech Ltd.
637
467
440
ORBK Orbotech Ltd. Capital Goods 2014 1,000
498
583
ORBK Orbotech Ltd. Capital Goods 2015 1,000 569
753
ORCL
Oracle Corp.
81,800
44,600
37,200
ORCL Oracle Corp. Technology 2014 90,300 46,900
38,300
ORCL Oracle Corp. Technology 2015 110,900
48,700
38,200
OSGB
Overseas Shipholding Group Inc.
(60)
925
(638)
OSGB Overseas Shipholding Group Inc. Transportation 2014 3,400 1,300
872
(152)
OSGB Overseas Shipholding Group Inc. Transportation 2015 3,300 1,600
965
284
OTEL
Otelco Inc.
122
(24)
OTEL Otelco Inc. Public Utilities 2015 119
(16)
PATI
Patriot Transportation Holding Inc.
PATI Patriot Transportation Holding Inc. Transportation 2014 61 33 129 3
PATI Patriot Transportation Holding Inc. Transportation 2015 60 37
123
PCH
Potlatch Corporation
697
571
PCH Potlatch Corporation Consumer Services 2014 1,100
225
PCH Potlatch Corporation Consumer Services 2015 1,000 204
577
PCTY
Paylocity Holding Corporation
PCTY Paylocity Holding Corporation Technology 2014
528
PCTY Paylocity Holding Corporation Technology 2015 721 108
153
PEGA
Pegasystems Inc.
534
272
509
PEGA Pegasystems Inc. Technology 2014
588
295
PEGA Pegasystems Inc. Technology 2015
641
323
683
PLCE
Children’s Place Inc.
923
PLCE Children’s Place Inc. Consumer Services 2014
991
617
PLCE Children’s Place Inc. Consumer Services 2015
959
589
PRGN
Paragon Shipping Inc.
233
(17)
PRGN Paragon Shipping Inc. Transportation 2014
461
(51)
PRGN Paragon Shipping Inc. Transportation 2015 107
(45)
(264)
PWX
Providence and Worcester Railroad Company
PWX Providence and Worcester Railroad Company Transportation 2014 112 79 34 3
PWX Providence and Worcester Railroad Company Transportation 2015 114 81 36 2
PXS
Pyxis Tankers Inc.
PYDS
Payment Data Systems Inc.
PYDS Payment Data Systems Inc. Finance 2015 68 9 14 1
RBCN
Rubicon Technology Inc.
203
196
(30)
RBCN Rubicon Technology Inc. Technology 2014
195
189
(44)
RFIL
RF Industries Ltd.
RFIL RF Industries Ltd. Capital Goods 2014 29 26 23 1
RFIL RF Industries Ltd. Capital Goods 2015 32 26 33 1
RPT
Ramco-Gershenson Properties Trust
770
168
RPT Ramco-Gershenson Properties Trust Consumer Services 2014 1,900 872 218 (3)
RPT Ramco-Gershenson Properties Trust Consumer Services 2015 2,100
884
246
RUN
SunRun Inc.
RUN SunRun Inc. Capital Goods 2014 1,900 325 199 (71)
RUN SunRun Inc. Capital Goods 2015 3,000
554
(28)
RY
Royal Bank of Canada
825,400
46,500
RY Royal Bank of Canada Finance 2014
834,200
46,700
RY Royal Bank of Canada Finance 2015
821,000
35,100
SAAS
inContact Inc.
SAAS inContact Inc. Technology 2014
169
SAAS inContact Inc. Technology 2015
254
(23)
SB
Safe Bulkers Inc.
578
SB Safe Bulkers Inc. Transportation 2014 1,200 700 154 15
SB Safe Bulkers Inc. Transportation 2015 1,300
634
(48)
SBUX
Starbucks Corp.
14,900
SBUX Starbucks Corp. Consumer Services 2014 10,800 5,300 16,400 2,100
SBUX Starbucks Corp. Consumer Services 2015 12,400 5,800 19,100 2,800
SEDG
SolarEdge Technologies Inc.
(10)
SEDG SolarEdge Technologies Inc. Technology 2014 75
(19)
133
SEDG SolarEdge Technologies Inc. Technology 2015 306
167
SIEB
Siebert Financial Corporation
SIEB Siebert Financial Corporation Finance 2014 21 19 14 (7)
SIEB Siebert Financial Corporation Finance 2015 18 16 10 (3)
SINO
Sino-Global Shipping America Ltd.
SINO Sino-Global Shipping America Ltd. Transportation 2014 6 9 12 2
SINO Sino-Global Shipping America Ltd. Transportation 2015 12 15 11 1
SJI
South Jersey Industries Inc.
827
SJI South Jersey Industries Inc. Public Utilities 2014 3,300
932
911
SJI South Jersey Industries Inc. Public Utilities 2015 3,500 1,000
956
SPG
Simon Property Group Inc.
33,300
SPG Simon Property Group Inc. Consumer Services 2014
29,500
SPG Simon Property Group Inc. Consumer Services 2015
30,700
STAG
Stag Industrial Inc.
603
135
STAG Stag Industrial Inc. Consumer Services 2014 1,600
864
178
STAG Stag Industrial Inc. Consumer Services 2015 1,900
820
STR
Questar Corporation
161
STR Questar Corporation Public Utilities 2014 4,200 1,200 1,200
227
STR Questar Corporation Public Utilities 2015 4,400 1,300 1,100 209
SUNW
Sunworks Inc.
SUNW Sunworks Inc. Public Utilities 2015 35 24 54 1
SVT
Servotronics Inc.
SVT Servotronics Inc. Capital Goods 2014 35 21 32 (3)
SVT Servotronics Inc. Capital Goods 2015 34 25 37 5
T
AT&T Inc.
277,800
91,000
128,800
18,200
T AT&T Inc. Public Utilities 2014
292,800
132,400
T AT&T Inc. Public Utilities 2015
402,700
122,700
146,800
TASR
Taser International Inc.
138
TASR Taser International Inc. Capital Goods 2014
185
TASR Taser International Inc. Capital Goods 2015
230
198
TBI
TrueBlue Inc.
720
393
TBI TrueBlue Inc. Technology 2014 1,100 469 2,200 66
TBI TrueBlue Inc. Technology 2015 1,300 536 2,700 71
TD
Toronto-Dominion Bank
827,100
48,400
TD Toronto-Dominion Bank Finance 2014
837,900
48,500
33,500
TD Toronto-Dominion Bank Finance 2015
844,100
50,000
30,200
TEF
Telefonica S.A.
163,800
29,200
75,900
TEF Telefonica S.A. Public Utilities 2014
148,000
25,600
66,600
TEF Telefonica S.A. Public Utilities 2015
133,600
52,100
TIK
Tel-Instrument Electronics Corp.
TIK Tel-Instrument Electronics Corp. Capital Goods 2015 10 4 18 (0)
TIL
Till Capital Ltd.
TIL Till Capital Ltd. Finance 2014 53 40 10 (6)
TK
Teekay Corporation
(115)
TK Teekay Corporation Transportation 2014 11,900 1,100 2,000
(55)
TK Teekay Corporation Transportation 2015
13,100
919
TLN
Talen Energy Corporation
TLN Talen Energy Corporation Public Utilities 2015
12,800
(341)
TM
Toyota Motor Corp. ADR
377,400
129,200
266,100
TM Toyota Motor Corp. ADR Capital Goods 2014
402,400
140,500
256,500
TM Toyota Motor Corp. ADR Capital Goods 2015
398,000
140,000
248,000
TMO
Thermo Fisher Scientific Inc.
31,900
16,900
TMO Thermo Fisher Scientific Inc. Capital Goods 2014
42,900
20,500
TMO Thermo Fisher Scientific Inc. Capital Goods 2015 40,900
21,400
TSM
Taiwan Semiconductor Manufacturing Co. Ltd. ADR
42,400
28,400
20,100
TSM Taiwan Semiconductor Manufacturing Co. Ltd. ADR Technology 2014
47,300
25,100
TSM Taiwan Semiconductor Manufacturing Co. Ltd. ADR Technology 2015 50,500 37,200
26,600
TSU
TIM Participacoes S/A
695
TSU TIM Participacoes S/A Public Utilities 2014 12,300 5,800 8,300 657
TSU TIM Participacoes S/A Public Utilities 2015 9,000 4,300 5,100
620
UAMY
United States Antimony Corporation
UAMY United States Antimony Corporation Capital Goods 2014 17 13 11 (2)
UAMY United States Antimony Corporation Capital Goods 2015 18 13 13 (1)
UNP
Union Pacific Corp.
49,700
22,000
UNP Union Pacific Corp. Transportation 2014 52,700 21,200
24,000
UNP Union Pacific Corp. Transportation 2015
54,600
21,800
UPS
United Parcel Service Inc.
55,500
UPS United Parcel Service Inc. Transportation 2014 35,500 2,100 58,300 3,000
UPS United Parcel Service Inc. Transportation 2015 38,300 2,500
58,100
USB
U.S. Bancorp
367,700
20,000
USB U.S. Bancorp Finance 2014
406,200
43,500
20,400
USB U.S. Bancorp Finance 2015
42
5,700
UTX
United Technologies Corporation
90,600
62,700
UTX United Technologies Corporation Capital Goods 2014
91,300
65,200
UTX United Technologies Corporation Capital Goods 2015
87,500
56,300
VZ
Verizon Communications Inc.
274,100
38,800
120,600
VZ Verizon Communications Inc. Public Utilities 2014
232,700
127,100
VZ Verizon Communications Inc. Public Utilities 2015
244,600
131,600
WBK
Westpac Banking Corporation
652,100
43,600
38,500
WBK Westpac Banking Corporation Finance 2014
675,300
35,600
WBK Westpac Banking Corporation Finance 2015
571,000
37,300
WBKC
Wolverine Bancorp Inc.
298
WBKC Wolverine Bancorp Inc. Finance 2014 337 62 16 3
WEB
Web.com Group Inc.
170
492
(66)
WEB Web.com Group Inc. Technology 2014 1,200 174 544
(13)
WEB Web.com Group Inc. Technology 2015 1,200 238 544 90
WFC
Wells Fargo & Co.
1,500,000
170,100
89,500
WFC Wells Fargo & Co. Finance 2014 1,700,000
184,400
90,200
23,100
WFC Wells Fargo & Co. Finance 2015
1,800,000
193,000
90,700
22,900
WMS
Advanced Drainage Systems Inc.
WMS Advanced Drainage Systems Inc. Capital Goods 2014
938
223
WMS Advanced Drainage Systems Inc. Capital Goods 2015 1,000 298 1,200 (2)
WMT
Wall-Mart Stores Inc.
203,100
76,300
469,200
WMT Wall-Mart Stores Inc. Consumer Services 2014
204,800
476,300
WMT Wall-Mart Stores Inc. Consumer Services 2015
203,700
81,400
485,700
WRLD
World Acceptance Corporation
831
366
584
WRLD World Acceptance Corporation Finance 2014
868
307
618
WRLD World Acceptance Corporation Finance 2015 887 316
610
111
YRD
Yirendai Ltd.
YRD Yirendai Ltd. Finance 2015
338
151
210
ZHNE
Zhone Technologies Inc.
ZHNE Zhone Technologies Inc. Public Utilities 2014 66 34 121 (4)
ZHNE Zhone Technologies Inc. Public Utilities 2015 57 34 101 (2)
BA325 Firstname Lastname
(use your actual name).
Screen Clippings:
Practice Assignment
DuPont Assignment
Screen Clipping 2:
Screen Clipping 3:
Screen Clipping 4: