Problem 1 (3 points)

Financial Information for Apple Computer can be found on Yahoo.com/finance (Symbol: AAPL). You will find information under financials for the balance sheet and income statement for three years. Using Excel, calculate the following ratios for the fiscal year ending 2016 and the common size statements. Please comment on any significant trends positive or negative.

Current, Quick, Inventory Turnover, DSO, Fixed Asset Turnover, Total Assets Turnover, Total debt to total assets, TIE, Operating Margin, Profit Margin, ROA, and ROE.

Please present your work neatly. If I cannot follow your work, I will discount it.