The Performance Of The Apple Company
Purpose of Assignment
Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports, and use that data to calculate a company's financial ratios and their comparison to industry or competitor standards.
Assignment Steps
Resources: Tutorial help on Excel and Word functions can be found on the Microsoft Office website. There are also additional tutorials via the web that offer support for office products.
Obtain Apples the most current SEC Form 10-K (annual financial report) from the company's website (Do not use the Annual Report that is sent to shareholders):
Calculate +(show equation used for calculations)+ and analyze the following ratios for your selected company for the last two years from the SEC Form 10-K:
(part 1) on a separate page ...
Current Ratio-
Inventory Turnover-
Debt Ratio-
Time Interest Earned-
Gross Profit Margin-
Equity Multiplier-
Return on Assets-
Net Profit Margin-
Return on Equity (Use three ratio DuPont method)-
Part 2
Compare and contrast your Apple's ratios to MICROSOFT and DELL standard ratios obtained from Yahoo Finance, Morningstar, MotleyFool, Macroaxis or any other Internet sources, and provide a detailed answer and analysis as to why Apple's ratios are different than MICROSOFT and DELL standards.
Prepare your analysis in a minimum of 875 words in Microsoft Word. The use of Microsoft Word tables is encouraged.
Cite the source of MICROSOFT and Dell ratio information.
Format your assignment consistent with APA guidelines.
Click the Assignment Files tab to submit your assignment.
This is one of my last assignments for this class, please do the best job you can. Thank you very much.
Ratio | Formulae | 2017 | 2016 | Deviation | |
1. | Current Ratio | Current assets/current liabilities | 128645000/100814000 127.60% | 106869000/79006000 135.27% | -7.67 |
2 | Debt Ratio | Total Debts/Total Assets | 241272000/375319000 64.28% | 193437000/321686000 60.13% | 4.15 |
3. | Return on Assets | Net income/Total Assets | 48351000/375319000 12.88% | 45687000/321686000 14.20% | -1.32 |
4 | Gross Profit Margin | Gross Profit/Total Revenue | 88186000/229234000 38.46% | 84263000/215639000 39.07% | 0.61 |
5 | Net Profit margin | Net Income/Total Sales | 48351000/229234000 21.09% | 45687000/215639000 21.19% | -0.1 |
6 | Equity Multiplier | Total Assets/Total Equity. | 375319000/134047000 2.800 | 321686000/128249000 2.508 | 0.292 |
7 | Time Interest Earned | Company Earnings(Before interest and taxes)/Total Interest Earned | 64089000/0 ∞ | 61372000/0 ∞ | ∞ |
8 | Return on Equity | 3 Ratio DuPont Method (Net Profit Margin)(Asset Turn over) (Equity Multiplier) | 0.2109×0.128×2.800 0.0756=7.56% | 0.2119×0.1420×2.508 0.0755=7.55% | 0.01 |
9. | Inventory Turn over | Cost of Goods Sold/Average Inventory. | 141048000/3493500 40.37 times. | 131376000/2240500 58.64 times. | -18.27 |
👀 Other Visitors are Viewing These APA Essay Samples:
-
Globalized Professionals: The Rise Of GAAP
2 pages/≈550 words | No Sources | APA | Business & Marketing | Coursework |
-
Strategic Management SWOT: Strengths and Weaknesses
2 pages/≈550 words | No Sources | APA | Business & Marketing | Coursework |
-
System Recommendation Enterprise Resource Planning (ERP)
3 pages/≈825 words | 2 Sources | APA | Business & Marketing | Coursework |