In: Accounting
The balance sheet for Campbell Corporation follows:
| Current assets | $ | 235,000 | |
| Long-term assets (net) | 759,000 | ||
| Total assets | $ | 994,000 | |
| Current liabilities | $ | 149,000 | |
| Long-term liabilities | 454,000 | ||
| Total liabilities | 603,000 | ||
| Common stock and retained earnings | 391,000 | ||
| Total liabilities and stockholders’ equity | $ | 994,000 | |
Required
Compute the following. (Round "Ratios" to 1 decimal place.)
  | 
||||||||||||||
The following data come from the financial records of Solomon Corporation for 2018:
| Sales | $ | 845,000 | |
| Interest expense | 4,300 | ||
| Income tax expense | 29,000 | ||
| Net income | 24,000 | ||
Required
How many times was interest earned in 2018? (Round your answer to 2 decimal places.)
Selected data from Benson Company follow:
| 
Balance Sheets As of December 31  | 
|||||||
| 2018 | 2017 | ||||||
| Accounts receivable | $ | 406,000 | $ | 380,000 | |||
| Allowance for doubtful accounts | (20,300 | ) | (15,200 | ) | |||
| Net accounts receivable | $ | 385,700 | $ | 364,800 | |||
| Inventories, lower of cost or market | $ | 484,500 | $ | 443,000 | |||
| 
Income Statement For the Years Ended December 31  | 
|||||||
| 2018 | 2017 | ||||||
| Net credit sales | $ | 2,007,000 | $ | 1,759,000 | |||
| Net cash sales | 401,000 | 300,000 | |||||
| Net sales | 2,408,000 | 2,059,000 | |||||
| Cost of goods sold | 1,608,000 | 1,432,000 | |||||
| Selling, general, and administrative expenses | 239,800 | 214,800 | |||||
| Other expenses | 40,400 | 23,600 | |||||
| Total operating expenses | $ | 1,888,200 | $ | 1,670,400 | |||
Required
Compute the accounts receivable turnover for 2018.
Compute the inventory turnover for 2018.
Compute the net margin for 2017.
(For all requirements, round your answers to 2 decimal places.)
| a. | Accounts receivable turnover | times | |
| b. | Inventory turnover | times | |
| c. | Net margin | % | |
| Campbell Corporation | ||||||
| 1 | Working Capital | Current Assets - Current Liabilities | ||||
| 235,000-149,000 | ||||||
| 86,000.00 | ||||||
| 2 | Current Ratio | Current Assets / Current Liabilities | ||||
| 235,000/149,000 | ||||||
| 1.6 | ||||||
| 3 | Debt to Assets Ratio | Total Liabilities / Total Assets | ||||
| 603,000/ 994,000 | ||||||
| 0.6 | 60.7% | |||||
| 4 | Debt to Equity Ratio | Total Liabilities / Shareholders Equity | ||||
| 603,000/ 391,000 | ||||||
| 1.5 | 154.2% | |||||
| Solomon Corporation | ||||||
| 5 | Times interest earned | Earnings before interest and taxes ÷ Interest expense | ||||
| (24,000+29,000+4,300)/4300 | ||||||
| 13.33 | ||||||
| Benson Company | ||||||
| 6 | Accounts receivable turnover | Net Credit Sales / Average Accounts Receivables | ||||
| Accounts Receivables (Opening) | 364800 | |||||
| Accounts Receivables (Closing) | 385700 | |||||
| Average Accounts Receivables (net) | 375250 | |||||
| By using the formula of receivables turnover ratio, we get – | ||||||
| Net Credit Sales | 2007000 | |||||
| Average Accounts Receivables | 375250 | |||||
| Receivables Turnover Ratio | 5 | times | ||||
| 7 | Inventory turnover | Cost of Goods Sold / Average Inventories | ||||
| Inventory (Beginning) | 443000 | |||||
| Inventory (Ending) | 484500 | |||||
| Average Inventories | 463750 | |||||
| Using the inventory turnover ratio, we get – | ||||||
| Cost of Goods Sold | 1608000 | |||||
| Average Inventories | 463750 | |||||
| Inventory Turnover | 3.47 | |||||
| 8 | net margin for 2017 | Net Profit / Net Sales * 100 | ||||
| net sales | 20,59,000.00 | |||||
| Net Profit | ||||||
| Sales | 20,59,000.00 | |||||
| Less | Total operating expenses | 16,70,400.00 | ||||
| 3,88,600.00 | ||||||
| Using the formula of net profit margin, we get – | ||||||
| Net Profit Margin | 18.87% | |||||