| RATIO ANALYSIS |
| Note: Please change the column names based on your industry and your selected companies. |
| RATIOS | <INDUSTRY> | <COMPANY #1> | <COMPANY #2> | ANALYSIS |
| Profitability Ratios (%) |
| Gross Margin |
| EBITD Margin |
| Operating Margin |
| Pretax Margin |
| Effective Tax Rate |
| Financial Strength |
| Quick Ratio |
| Current Ratio |
| LT Debt to Equity |
| Total Debt to Equity |
| Interest Coverage |
| Valuation Ratios |
| P/E Ratio |
| Price to Sales (P/S) |
| Price to Book (P/B) |
| Price to Tangible Book |
| Price to Cash Flow |
| Price to Free Cash Flow |
| Management Effectiveness (%) |
| Return On Assets |
| Return On Investment |
| Return On Equity |
| Dividends |
| Dividend Yield |
| Payout Ratio |
| Efficiency |
| Revenue/Employee |
| Net Income/Employee |
| Receivable Turnover |
| Inventory Turnover |
| Asset Turnover |
| Summary |
| What is ratio analysis? Briefly explain in this space, and reference your resources: |
| Referring to your ratio analysis above, in which company would you be willing to invest, and why? |
Template.xlsx
