Untitled document

.pdf

School

Humber College *

*We aren’t endorsed by this school

Course

2010

Subject

Accounting

Date

Apr 3, 2024

Type

pdf

Pages

5

Uploaded by BailiffMusicParrot37

Report
Chapter 8 Labs Name: - N01442610 Nghi Dung Dao Professor: Hatem Shashaa Course name: Data Analytics for Accountants - ACCT-3504 Due date: Mar 24/ 2024
Lab 8-1 Part 1 Objective Questions OQ1. What was the Net Income value for AAPL in 2020?(Round to the nearest million dollars.) 57411 OQ2. Change the values in your test formula. What is the Net Income for NKE in 2020? (Round to the nearest million dollars.) 2539 OQ3. 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.) 27987 Million Dollars Lab 8-1 Part 1 Analysis Questions AQ1. iXBRLAnalyst in Google Sheets uses “normalized” tags for common financial statement elements. What is the purpose of “normalized” XBRL tags? The purpose of "normalized" XBRL tags in iXBRLAnalyst in Google Sheets is to provide a standardized format for common financial statement elements that can be consistently applied across different companies and industries. Normalized XBRL tags are a standardized set of tags that have been defined by the XBRL consortium to represent specific financial concepts such as revenue, expenses, assets, and liabilities. These tags are designed to be used across different companies and industries to ensure consistency in financial reporting and analysis.
AQ2. 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?” Is the company's Selling and administrative costs going up or down? Did the company's income increase year over year? Is the company’s revenue increasing as comparably as income? AQ3. Form a hypothesis for each of your questions. For example, “I expect Nike’s operating costs have gone up. I expect that the companies ' administrative costs are the same or less than in prior years I expect that the companies income increased year over year I expect that the revenue grew comparable or less than the income Lab 8-1 Part 2 Objective Questions OQ1. What direction is cost of revenue trending for GE? 60421 OQ2. In which of the three years analyzed is operating expense highest as a percentage of revenue for PG? 2019 OQ3. If analysts expect MMM to attain a gross profit margin above 47 percent, does the company exceed the expectations in all three years analyzed? exceed the expectations in all three years analyzed.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help