Pivot table excel assignment

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?