STEP FOUR: Using the information on your August financial statements calculate the following ratios for your company using an Excel spreadsheet:
1. Gross Profit Percentage
2. Accounts Receivable Turnover Ratio
3. Day’s Sales in Receivables
4. Debt Ratio
5. Debt to Equity Ratio
6. Profit Margin Ratio
7. Rate of Return on Total Assets
8. Asset Turnover Ratio
Show the information in your spreadsheet in three columns:
Ratio Name Formula/Amounts Ratio Value
1. Gross Profit Percentage
2. Accounts Receivable Turnover Ratio
3. Day’s Sales in Receivables
4. Debt Ratio
5. Debt to Equity Ratio
6. Profit Margin Ratio
7. Rate of Return on Total Assets
8. Asset Turnover Ratio