Once you have completed the Excel template, review the Excel data results and written analysis of the following ratios for 2018:

• Working Capital
• Current Ratio
• Quick Ratio
• Gross Profit %
• Net Profit %

Your analysis should explain or define what the ratio means and/or is about for these two companies. You are also welcome to compare the companies based on the ratios,

Transcribed Image Text:

Microsoft 2018 Financial Statement Microsoft Apple Cash $ Accounts Receivable $ 11,946 26,481 (From Balance Sheet) (From Balance Sheet) $ 169,662 $ 131,339 Working Capital $ 111,214 $ 14,473 Current Assets - Current Liabilites $ 58,448 $ 116,866 Inventory $ 2,662 (From Balance Sheet) Current Assets $ 169,662 $ 131,339 Current Ratio 2.90 1.12 Current Assets $ 169,662 (From Balance Sheet) Current Libilities $ 58,448 $ 116,866 Current Liabilities $ 58,448 (From Balance Sheet) Quick Assets $ 167,000 $ 127,383 Quick Ratio 2.86 1.09 Gross Profit $ 72,007 (From Income Statement) Current Liabilities $ 58,448 $ 116,866 Net Profit $ 16,571 (From Income Statement) Gross Profit $ 72,007 $ 101,839 Gross Profit % 65.2% 38.3% Revenue $ 110,360 (From Income Statement) Sales (Total Revenue) $ 110,360 $ 265,595 Net Profit $ 16,571 $ 59,531 Net Profit % 15.0% 22.4% Apple Total Revenue $ 110,360 $ 265,595 2018 Cash $ Accounts Receivable $ Financial Statement 25,913 (From Balance Sheet) 23,186 (From Balance Sheet) Inventory $ 3,956 (From Balance Sheet) Current Assets $ 131,339 (From Balance Sheet) Current Liabilities $ 116,866 (From Balance Sheet) Gross Profit $ 101,839 (From Income Statement) Net Profit $ 59,531 (From Income Statement) Revenue $ 265,595 (From Income Statement) Microsoft 2018 Financial Statement Microsoft Apple Cash $ Accounts Receivable $ 11,946 26,481 (From Balance Sheet) (From Balance Sheet) $ 169,662 $ 131,339 Working Capital $ 111,214 $ 14,473 Current Assets - Current Liabilites $ 58,448 $ 116,866 Inventory $ 2,662 (From Balance Sheet) Current Assets $ 169,662 $ 131,339 Current Ratio 2.90 1.12 Current Assets $ 169,662 (From Balance Sheet) Current Libilities $ 58,448 $ 116,866 Current Liabilities $ 58,448 (From Balance Sheet) Quick Assets $ 167,000 $ 127,383 Quick Ratio 2.86 1.09 Gross Profit $ 72,007 (From Income Statement) Current Liabilities $ 58,448 $ 116,866 Net Profit $ 16,571 (From Income Statement) Gross Profit $ 72,007 $ 101,839 Gross Profit % 65.2% 38.3% Revenue $ 110,360 (From Income Statement) Sales (Total Revenue) $ 110,360 $ 265,595 Net Profit $ 16,571 $ 59,531 Net Profit % 15.0% 22.4% Apple Total Revenue $ 110,360 $ 265,595 2018 Cash $ Accounts Receivable $ Financial Statement 25,913 (From Balance Sheet) 23,186 (From Balance Sheet) Inventory $ 3,956 (From Balance Sheet) Current Assets $ 131,339 (From Balance Sheet) Current Liabilities $ 116,866 (From Balance Sheet) Gross Profit $ 101,839 (From Income Statement) Net Profit $ 59,531 (From Income Statement) Revenue $ 265,595 (From Income Statement)

Answer rating: 100% (QA)

Analysis of Financial Ratios for Apple and Microsoft in 2018 This analysis will review the following ratios for Apple and Microsoft in 2018 Working Ca... View the full answer