| Company: |
| Ratio | Formula for Calculation | Calculation | 2020 Ratio | 2019 Ratio | 2018 Ratio | Indsutry Average | Trend Analysis |
| 1. Short-term solvency, or liquidity, ratios |
| Current ratio | Current assets |
| | Current liabilities |
| Quick ratio | Current assets - Inventory |
| | Current liabilities |
| Cash ratio | Cash |
| | Current liabilities |
| 2. Long-term solvency, or financial leverage, ratios |
| Total debt ratio | Total assets - Total equity |
| | Total assets |
| Equity Multiplier | Total assets |
| | Total Equity |
| Cash Coverage Ratio | EBIT + Depriciation |
| | Interest |
| 3.Assets utilization, or turnover, ratios |
| Inventory Turnover | COGS |
| | Inventory |
| Receivables Turnover | Sales |
| | Accounts Receivable |
| Total Asset Turnover | Sales |
| | Total Assets |
| 4. Profability Ratios |
| Profit Margin | Net Income |
| | Sales |
| ROA | Net Income |
| | Total Assets |
| ROE | Net Income |
| | Total Equity |
| 5.Market value ratios |
| Price Earnings Ratio | Price Per Share |
| | Earnings per share |
| Price-sales ratio | Price Per Share |
| | Sales Per Share |
| Market-to-book ratio | Market value per share |
| | Book value per share |
Jacob5
RatioWorksheetTemplate.xls
