
Input (manually or by copy and paste) actual data (I.e. revenue and expenses) and this template automatically calculates the following financial ratios:
Liquidity:
1 Current Ratio
2. Quick Ratio (acid test)
Asset Management:
3. Average collection period
4. Inventory turnover
5. Fixed-asset turnover
6. Total asset turnover
Financial Leverage Management:
7. Debt ratio
8. Debt-to-equity
9. Times interest earned
10. Times fixed charges earned
Profitability:
11. Gross profit margin
12. Net profit margin
13. Return on investment
14. Return on stockholders' equity
Market-Based:
15. Price-to-earnings ratio
16. Market-to-book ratio
Divident Policy
17. Payout ratio
18. Dividend yield
To download this spreadsheet template now, simply click the "Add to cart" button below.
|