What this calculator does
Enter ten figures from a company's income statement and balance sheet and this calculator gives the standard financial ratios: profit margins, liquidity (current and quick ratios), leverage (debt-to-equity and debt ratio), returns (ROA and ROE), times interest earned and asset turnover.
How to use it
- From the income statement, enter revenue, cost of goods sold, operating income (EBIT), interest expense and net income. Use a minus sign for a loss.
- From the balance sheet, enter current assets, inventory, current liabilities, total assets and total liabilities.
- Every ratio updates as you type. A ratio that would divide by zero is left out.
How to calculate financial ratios
- Gross margin = (revenue − cost of goods sold) ÷ revenue
- Operating margin = operating income ÷ revenue; net profit margin = net income ÷ revenue
- Current ratio = current assets ÷ current liabilities; quick ratio = (current assets − inventory) ÷ current liabilities
- Shareholders' equity = total assets − total liabilities; debt-to-equity = total liabilities ÷ equity; debt ratio = total liabilities ÷ total assets
- ROA = net income ÷ total assets; ROE = net income ÷ equity
- Times interest earned = operating income ÷ interest expense; asset turnover = revenue ÷ total assets
Examples
Example 1: A small manufacturer. With $1.2 million of sales and $90,000 of net income, the net profit margin is 7.5%. Current assets of $400,000 against $250,000 of current liabilities give a current ratio of 1.6, and 1 once inventory is taken out. Equity is $400,000, so ROE is 22.5%, and EBIT covers interest 6 times.
Example 2: The default figures. $500,000 of revenue and $300,000 of cost of goods sold is a 40% gross margin. $350,000 of liabilities on $250,000 of equity is a debt-to-equity of 1.4.
Tips
- Compare within an industry. A grocer's 2% net margin and a software firm's 25% can both be healthy.
- Use figures from the same period. Income-statement figures cover a year or quarter; balance-sheet figures are a single date, often the end of that period.
- For a fuller look at profit, try the EBITDA calculator; for the cost of the money a company uses, the WACC calculator.