Question 3.S-TP.3: Financial Ratios Based on the balance sheets and income stat...
Financial Ratios Based on the balance sheets and income statement in the previous two problems, calculate the following ratios for 2018:
Current ratio |
|
Quick ratio |
|
Cash ratio |
|
Inventory turnover |
|
Receivables turnover |
|
Days’ sales in inventory |
|
Days’ sales in receivables |
|
Total debt ratio |
|
Long-term debt ratio |
|
Times interest earned ratio |
|
Cash coverage ratio |
|
The blue check mark means that this solution has been answered and checked by an expert. This guarantees that the final answer is accurate.
Learn more on how we answer questions.
Learn more on how we answer questions.
We’ve calculated the following ratios based on the ending figures. If you don’t remember a definition, refer back to Table 3.8.
TABLE 3.8 | Common Financial Ratios |
I. Short-term solvency, or liquidity, ratios | II. Long-term solvency, or financial leverage, ratios |
Current ratio=\frac{Current assets}{Current liabilities} | Total debt ratio=\frac{Total assets − Total equity}{Total assets} |
Quick ratio=\frac{Current assets − Inventory}{Current liabilities} | Debt-equity ratio=Total debt/Total equity |
Cash ratio=\frac{Cash}{Current liabilities} | Equity multiplier=Total assets/Total equity |
Net working capital to total assets=\frac{Net working capital}{Total assets} | Long-term debt ratio=\frac{Long-term debt}{Long-term debt + Total equity} |
Interval measure=\frac{Current assets}{Average daily operating costs} | Times interest earned ratio=\frac{EBIT}{Interest} |
Cash coverage ratio=\frac{EBIT + Depreciation}{Interest} | |
III. Asset management, or turnover, ratios | IV. Profitability ratios |
Inventory turnover=\frac{Cost of goods sold}{Inventory} | Profit margin=\frac{Net income}{Sales} |
Daysʼ sales in inventory=\frac{365 days}{Inventory turnover} | Return on assets (ROA)=\frac{Net income}{Total assets} |
Receivables turnover=\frac{Sales}{Accounts receivable} | Return on equity (ROE)=\frac{Net income}{Total equity} |
Daysʼ sales in receivables=\frac{365 days}{Receivables turnover} | ROE=\frac{Net income}{Sales}\times \frac{Sales}{Assets}\times \frac{Assets^{*}}{Equity} |
NWC turnover=\frac{Sales}{NWC} | V. Market value ratios |
Fixed asset turnover=\frac{Sales}{Net fixed assets } | Price-earnings ratio=\frac{Price per share}{Earnings per share} |
Total asset turnover=\frac{Sales}{Total assets} | PEG ratio=\frac{Price-earnings ratio}{Earnings growth rate (\%)} |
Price-sales ratio=\frac{Price per share}{Sales per share} | |
Market-to-book-ratio=\frac{Market value per share}{Book value per share} | |
Tobinʼs Q ratio=\frac{Market value of assets}{Replacement cost of assets} | |
Enterprise value-EBITDA ratio=\frac{Enterprise value}{EBITDA} |
Current ratio | $853/$1,725 | = .49 times |
Quick ratio | $525/$1,725 | = .30 times |
Cash ratio | $215/$1,725 | = .12 times |
Inventory turnover | $2,816/$328 | = 8.59 times |
Receivables turnover | $4,053/$310 | = 13.07 times |
Days’ sales in inventory | 365/8.59 | = 42.51 days |
Days’ sales in receivables | 365/13.07 | = 27.92 days |
Total debt ratio | $4,033/$7,380 | = .546, or 54.6% |
Long-term debt ratio | $2,308/$5,655 | = .408, or 40.8% |
Times interest earned ratio | $687/$502 | = 1.37 times |
Cash coverage ratio | $1,237/$502 | = 2.46 times |
Related Answered Questions
Question: 3.5
Verified Answer:
If you look back at our discussion, you will see t...
Question: 3.S-TP.1
Verified Answer:
We’ve filled in the answers in the following table...
Question: 3.S-TP.2
Verified Answer:
We’ve calculated the common-size income statement ...
Question: 3.S-TP.4
Verified Answer:
The return on equity is the ratio of net income to...
Question: 3.2
Verified Answer:
The cost of goods sold is $1,344, and accounts pay...
Question: 3.4
Verified Answer:
We first need to calculate average assets and aver...
Question: 3.3
Verified Answer:
The total asset turnover here is .40 times per yea...
Question: 3.1
Verified Answer:
The first case is a trick question. What happens i...