Thursday, October 7, 2010

Financial Ratios with Excel


Windex 2008 calculates all major financial ratios in Excel from balance sheet, income statement and cash flow templates provided:
  • 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.