Untitled document

pdf

School

Humber College *

*We aren’t endorsed by this school

Course

2010

Subject

Accounting

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by BailiffMusicParrot37

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

Lab 8-1 Part 2 Analysis Questions AQ1. 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. Net Income , The Revenue , SG&A expenses of Apple increased from 2014 to 2015 and then decreased in 2016 AQ2. How did the actual results compare with your hypothesis in Part 1 AQ3? The actual results are mainly in line with my hypothesis AQ3. Replace the company ticker with a competitor of your company (e.g., MSFT vs. AAPL). How do their trends compare with your initial company? Microsoft revenue has increased throughout 2018 - 2020 , for the same period Apple saw a dip in 2019 . Apple and Microsoft 's operating expenses have increased in 2018 - 2020 but Apple only presents around 11 % - 14 % of its Revenue, while Microsoft operating expense is around 31 % to 33 % of its Revenue . Net income of Microsoft has increased throughout 2018 - 2020 , though in the case of Apple , a drastic dip can be witnessed in 2019 primarily due to COVID . AQ4. How could you expand this table you built in Part 2 to include multiple competitors’ data on the same sheet for quick analysis? input the competitors ' tickers in cells and perform data analysis in similar steps as I did for Apple and Microsoft, which means that I create common size income statements over a three - year period for both Apple and Microsoft , then perform vertical analyses for these 2 companies as below. Lab 8-2 Analysis Questions (LO 8-1) AQ1. Look at the different companies’ ratios. Which ones stand out to you as being atypical? One company that stands out is Apple. Apple has a higher gross margin, meaning that their costs are lower relative to their revenue. Additionally, Apple has a higher operating margin, meaning that their operating costs are lower relative to their revenue. Finally, Apple has a higher net margin, meaning that their net income is higher relative to their revenue. AQ2. Look at the values that return a 0. Is it likely that the 0 represents the company’s actual standing? What else might explain the 0 value? 0 doesn't represents company's actual standing but it represents the start of a new period not past. It doesn't include past. And stands for how much equity and debt your company

converted to profit. Zero-primarily based budgeting is a method that has you allocate all your cash to charges for needs and wants, in addition to short- and lengthy-time period savings and debt payments. The goal is that your profits minus your prices equals zero with the aid of the give up of the month. 0-based budgeting (ZBB) is a budgeting method wherein all expenses have to be justified for a new period or 12 months beginning from 0, as opposed to beginning with the preceding budget and adjusting it as wanted. Beginning from scratch is also a great alternative if you're on a confined finances. You can shape your new enterprise to fit your available capital, together with by way of operating from home or part-time, as opposed to assembly the monetary necessities of buying a franchise or a going commercial enterprise. Lab 8-2 Objective Questions (LO 8-1) OQ1. Which company’s ratios match Column A? KO OQ2. Which company’s ratios match Column B? MMM OQ3. Which company’s ratios match Column C? V OQ4. Which company’s ratios matchv Column D? AMZN OQ5. Which company’s ratios match Column E? BA OQ6. Which company’s ratios match Column F? ACN OQ7. Which company’s ratios match Column G? WMT OQ8. Which company’s ratios match Column H? MDLZ OQ9. Which company’s ratios match Column I? CSCO OQ10. Which company’s ratios match Column J? MRK