Perform a ratio analysis of your chosen company (APPLE INC) and a key competitor in Excel. Calculate the following ratios for both companies. (Use Chapter 5 of your textbook as a resource.)

Average collection period, Net profit margin, P/E ratio, Operating Return on Assets, Quick Ratio, Current Ratio, Receivables Turnover,Total Debt to Equity Ratio, and Return on Equity, Fixed Asset Turnover ratio

Also submit a copy of the financial statements used to prepare your ratio analysis.