Financial ratio pack
Enter P&L and balance sheet figures to get liquidity, leverage, coverage, turnover and DuPont ratios.
Result
Made-up example loaded. Replace it with your figures.
Enter figures, or load the made-up example, to see results.
Keep this result
Here it is. The file is built on this page from your figures.
Download my result (CSV)Formulas used
Current ratio = current assets / current liabilities
Quick ratio = (current assets - inventory) / current liabilities
Debt to equity = total debt / net worth
Interest cover = EBIT / interest
Debtor days = receivables / sales x 365
Inventory days = inventory / cost of goods sold x 365
Creditor days = payables / cost of goods sold x 365
DuPont ROE = net margin x asset turnover x assets / net worth
Worked example, made-up numbers
Current assets 180 and current liabilities 120 give a current ratio of 1.50. Receivables 80 on sales of 500 give about 58 debtor days.
Assumptions
- Year-end balances, not averages.
- Definitions of debt and net worth vary. Use your institution's.
- Use the same unit for every amount.