Ratio analysis
Sponsored Links
This Template calculates all major financial ratios in Excel. This template makes ration analysis a very easy task
Calculates these financial ratios 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.
Excel ratio analysis template
Zip file download or select CD edition shipping.
(US $139.95)
Secure Processing
30 Day Money Back Guarantee


