In: Accounting
Exercise 15-8 Selected Financial Ratios [LO15-2, LO15-3, LO15-4]
The financial statements for Castile Products, Inc., are given below:
Castile Products, Inc. Balance Sheet December 31 |
||||||
Assets | ||||||
Current assets: | ||||||
Cash | $ | 21,000 | ||||
Accounts receivable, net | 170,000 | |||||
Merchandise inventory | 380,000 | |||||
Prepaid expenses | 6,000 | |||||
Total current assets | 577,000 | |||||
Property and equipment, net | 840,000 | |||||
Total assets | $ | 1,417,000 | ||||
Liabilities and Stockholders' Equity | ||||||
Liabilities: | ||||||
Current liabilities | $ | 260,000 | ||||
Bonds payable, 11% | 330,000 | |||||
Total liabilities | 590,000 | |||||
Stockholders’ equity: | ||||||
Common stock, $10 par value | $ | 190,000 | ||||
Retained earnings | 637,000 | |||||
Total stockholders’ equity | 827,000 | |||||
Total liabilities and stockholders’ equity | $ | 1,417,000 | ||||
Castile Products, Inc. Income Statement For the Year Ended December 31 |
|||
Sales | $ | 3,150,000 | |
Cost of goods sold | 1,332,000 | ||
Gross margin | 1,818,000 | ||
Selling and administrative expenses | 560,000 | ||
Net operating income | 1,258,000 | ||
Interest expense | 36,300 | ||
Net income before taxes | 1,221,700 | ||
Income taxes (30%) | 366,510 | ||
Net income | $ | 855,190 | |
Account balances at the beginning of the year were: accounts receivable, $180,000; and inventory, $360,000. All sales were on account.
Required:
Compute the following financial data and ratios:
1. Working capital.
2. Current ratio. (Round your answer to 1 decimal place.)
3. Acid-test ratio. (Round your answer to 2 decimal places.)
4. Debt-to-equity ratio. (Round your answer to 2 decimal places.)
5. Times interest earned ratio. (Round your answer to 2 decimal places.)
6. Average collection period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)
7. Average sale period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)
8. Operating cycle. (Round your intermediate calculations and final answer to 1 decimal place.)