Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FYEAR Fiscal year FYR_M Month where fiscal year ended CONM Company Name COGS Cost of good sold EBIT Earning before interest and tax NI Net
FYEAR | Fiscal year |
FYR_M | Month where fiscal year ended |
CONM | Company Name |
COGS | Cost of good sold |
EBIT | Earning before interest and tax |
NI | Net Income |
REVT | Revenue Total |
Question 1 | Sort the data on Fyear (smallest to largest) and then Company name (A to Z) |
What is the COGS of the 3rd record? | Using 2 numbers after decimal place |
Question 2 | What is the name of the company with the highest average Net Income? |
Copy the first 3 letter of the name and put it in Sakai. | |
For example if name is "ALPHARMA INC -CL A", simply put ALP | |
Question 3 | What is the name of the company with the highest average Net Profit Margin? |
Copy the first 3 letter of the name and put it in Sakai. | |
For example if name is "ALPHARMA INC -CL A", simply put ALP | |
Question 4 | Create a table reporting the total Net Income for each company |
Sort this table on Name from Z to A | |
What is the total Net Income of the 3rd record? | |
Question 5 | How many years included in this data file? |
Question 6 | How many record are there for "BAXTER INTERNATIONAL INC"? |
Question 7 | Create a table reporting the average Operating Profit Margin for each firm |
Sort this table based on the Operating Profit Margin. | |
What is the company with the 3rd largest margin | |
Copy the first 3 letter of the name and put it in Sakai. | |
For example if name is "ALPHARMA INC -CL A", simply put ALP | |
Question 8 | How many cell has Net Income greater than 0? |
Question 9 | Create a table reporting the Average Net Income for each year. |
How many year with average net income of larger than 50 | |
Question 10 | |
Which company has the highest average revenue growth | |
Input the average growth of this company in Sakai. | |
If growth is 24%, simply put 24. Don?t include the % sign. | |
Using 2 numbers after decimal place | |
Hint: you have to sort first. | |
then you have to use IF to make sure you work on cell of the same company. |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started