Lab 8-1 Part 1 Objective Questions 1.
2.
What was the Net Income value for AAPL in 2020? (Round to the nearest million dollars.) 3.
Change the values in your test formula. What is the Net Income for NKE in 2020? (Round to the nearest million dollars.) 4.
Change the values in your test formula. What is the value of [Current Assets] or AssetsCurrent for PG in 2020? (Round to the nearest million dollars.) Lab 8-1 Part 1 Analysis Questions 1.
iXBRLAnalyst in Google Sheets uses “normalized” tags for common financial statement elements. What is the purpose of “normalized” XBRL tags?
2.
Select either Apple Inc. (AAPL) or Nike (NKE), and identify three questions you might want to know about that company’s financial performance over the past three years. For example, “What is the trend of operating costs?”
3.
Form a hypothesis for each of your questions. For example, “I expect Nike’s operating costs have gone up. Lab 8-1 Part 2 Objective Questions 1.
What direction is cost of revenue trending for GE? 2.
In which of the three years analyzed is operating expense highest as a percentage of revenue for PG? 3.
If analysts expect MMM to attain a gross profit margin above 47 percent, does the company exceed the expectations in all three years analyzed? Lab 8-1 Part 2 Analysis Questions 1.
Enter the ticker for Apple Inc. (AAPL) or Nike (NKE). Look at the trends and composition of the income statement, then answer your three questions from Part 1 AQ2. 2.
How did the actual results compare with your hypothesis in Part 1 AQ3? 3.
Replace the company ticker with a competitor of your company (e.g., MSFT vs. AAPL). How do their trends compare with your initial company? 4.
How could you expand this table you built in Part 2 to include multiple competitors’ data on the same sheet for quick analysis?
