Question
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
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 | 340,000 | |||||
Prepaid expenses | 9,000 | |||||
Total current assets | 540,000 | |||||
Property and equipment, net | 880,000 | |||||
Total assets | $ | 1,420,000 | ||||
Liabilities and Stockholders' Equity | ||||||
Liabilities: | ||||||
Current liabilities | $ | 230,000 | ||||
Bonds payable, 10% | 350,000 | |||||
Total liabilities | 580,000 | |||||
Stockholders equity: | ||||||
Common stock, $5 par value | $ | 120,000 | ||||
Retained earnings | 720,000 | |||||
Total stockholders equity | 840,000 | |||||
Total liabilities and stockholders equity | $ | 1,420,000 | ||||
Castile Products, Inc. Income Statement For the Year Ended December 31 | |||
Sales | $ | 2,400,000 | |
Cost of goods sold | 1,552,500 | ||
Gross margin | 847,500 | ||
Selling and administrative expenses | 650,000 | ||
Net operating income | 197,500 | ||
Interest expense | 35,000 | ||
Net income before taxes | 162,500 | ||
Income taxes (30%) | 48,750 | ||
Net income | $ | 113,750 | |
Account balances at the beginning of the year were: accounts receivable, $150,000; and inventory, $350,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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started