| | | | | | MICROSOFT | | FORD |
| | Liquidity ratios | Current ratio | Current Assets/Current Liabilities= | 114,246/45,625 | 2.5 | 155,052/63,612 | 2.437 |
| | | Quick ratio | Total cash equivalent & short term investments /Current Liabilities= | 85,709/45,625 | 1.88 | 31,150/63,612 | 0.489 |
| | Activity Ratios | Inventory Turnover | COG/Average Inventory = | 26,934/2,303.5 | 11.69 | 123,516/7,787 | 15.86 |
| | | Receivables Turnover | Net credit sales/Average Accounts receivables = | No Credit sales | | No Credit sales |
| | | Days Sales Outstanding | Receivable/Net credit sales/360 = | No Credit sales | | No Credit sales |
| | | Fixed Asset Turnover | Revenue/Average Fixed assets = | 86,833/11,501 | 7.55 | 144,077/205,353 | 0.7 |
| | | Total Asset Turnover | Revenue/Average total assets = | 86,833/172,382 | 0.5 | 144,077/13,553.5 | 10.63 |
| | Profitability Ratios | Gross Profit Margin | Gross margin/Revenue= | 59,899/86,833 | 0.69 | 20,561/144,077 | 0.14 |
| | | Operating Profit Margin | Operating Profit Margin/Revenue= | 27,759/86,833 | 0.32 | 3,440/144,077 | 0.024 |
| | | Net Profit Margin | Net income/Revenue= | 22,074/86,833 | 0.254 | 3,187/144,077 | 0.022 |
| | | Return on Assets | Net income/Total assets= | 22,074/172,382 | 0.128 | 3,187/183,353 | 0.017 |
| | | Return on Equity | Net income/Equity = | 22,074/89,784 | 0.245 | 3,187/24,832 | 0.128 |
| | Leverage Ratios | Debt/Net Worth | Total debt/Equity = | 82,600/89,784 | 0.92 | 208,527/24,832 | 8.3975 |
| | | Debt Ratio | Total debts/Total assets = | 82,600/172,382 | 0.479 | 208,527/183,353 | 1.137 |
| | Coverage Ratios | Times-Interest-Earned | EBIT/Interest charges = | No interest | 0 | 3440/797 | 4.3 |
marons2
msimmons_ford__microsoft.xlsx
