Tuesday, March 19, 2013

Financial Ratios with Excel

  • Financial Ratios with Excel

    Rate of Return on Assets (ROA). Rate of Return on Common Equity (ROE). Return on Capital (ROIC). Common Earnings Leverage. Cash Flow from Operations/Total Cash Flow Ratio. Cash Flow from Investments/Total Cash Flow Ratio. Cash Flow from Financing/Total Cash Flow Ratio. Operating Cash Flow/Current Liabilities Ratio. Operating Cash Flow/Total Liabilities. Operating Cash Flow/Capital Expenditures. Working Capital/Current Liabilities Ratio. Working Capital/Long Term Liabilities Ratio. Working Capital/Total Debt Ratio. Working Capital/Current Assets Ratio. Working Capital/Total Assets Ratio. Income Tax Expense/Revenues Ratio. Total Assets Turnover Ratio. Fixed Assets Turnover. Current Ratio. Acid Test (See note for Quick Ratio). Accounts Payables Turnover. Days Accounts Payables outstanding. Accounts Receivable Turnover Ratio. Days Receivables Outstanding Ratio. Inventory Turnover. Days Inventory Outstanding. Total Debt to Equity Ratio. Total Debt Coverage ratio. Long Term Debt Ratio. Long Term Debt to Total Assets. Long Term Debt to Shareholder Equity. Total Liabilities/Total Assets. Interest Coverage Ratio. Altman's Z (Solvency) Ratio.