Question
Case 2 (3 Marks) Selected information from the comparative financial statements of the Hamdan Company for the years ended December 31, 2020 and 2019 appear
Case 2 (3 Marks) Selected information from the comparative financial statements of the Hamdan Company for the years ended December 31, 2020 and 2019 appear below:
2020 | 2019 | |
Cash | 40,000 | 25,000 |
Accounts receivable (net) | 340,000 | 450,000 |
Inventory | 280,000 | 320,000 |
Prepaid insurance | 12,000 | 15,000 |
Total Current Assets | 672,000 | 810,000 |
Non-Current Assets | 280,000 | 360,000 |
Total assets | 952,000 | 1,170,000 |
Accounts payable | 100,000 | 250,000 |
Wages payable | 50,000 | 140,000 |
Total Current liabilities | 150,000 | 390,000 |
Binds payable | 400,000 | 400,000 |
Total Liabilities | 550,000 | 790,000 |
Stockholders Equity | ||
Equity (Common stock) | 300,000 | 300,000 |
Retained earnings | 102,000 | 80,000 |
Total Stockholders Equity | 402,000 | 380,000 |
Total Liabilities and Stockholders Equity | 952,000 | 1,170,000 |
Selected Income Statement information | ||
Sales Net | 880,000 | 940,000 |
Cost of goods sold | 690,000 | 720,000 |
Net income | 42,000 | 55,000 |
Required:
Compute the following ratios for 2020 and 2019. Show your calculations.
Ratio | Formula | Ratio 2020 | Ratio 2019 |
1. Current ratio | Current Assets / Current liabilities |
|
|
2. Quick ratio | Current assets inventory / current liabilities |
|
|
3. Accounts receivable turnover | Sales / Average A/R |
|
|
4. Days sales outstanding | 365 / A/R turnover |
|
|
5. Inventory turnover | CGS / Average Inventory |
|
|
6. Days inventory on hand | 365 / Inventory turnover |
|
|
7. Debt to equity | Total Liabilities / Total equity |
|
|
8. Debt to total assets | Total Liabilities / Total assets |
|
|
9. Profit margin ratio | Net income / sales |
|
|
10. Return on total assets | Net income / total assets |
|
|
Formulas and calculations
Answer
| 2020 | 2019 |
Current Assets / Current liabilities |
|
|
Current assets inventory / current liabilities |
|
|
Sales / Average A/R |
|
|
365 / A/R turnover |
|
|
CGS / Average Inventory |
|
|
365 / Inventory turnover |
|
|
Total Liabilities / Total equity |
|
|
Total Liabilities / Total assets |
|
|
Net income / sales |
|
|
Net income / total assets |
|
|
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