Current Attempt in Progress
Lendell Company has these comparative balance sheet data:
Lendell Company |
||||||
---|---|---|---|---|---|---|
2020 |
2019 |
|||||
Cash | $ 16,000 | $ 29,000 | ||||
Accounts receivable (net) | 71,000 | 59,000 | ||||
Inventory | 59,000 | 49,000 | ||||
Plant assets (net) | 205,000 | 182,000 | ||||
$351,000 | $319,000 | |||||
Accounts payable | $50,000 | $59,300 | ||||
Mortgage payable (15%) | 106,500 | 106,500 | ||||
Common stock, $10 par | 141,500 | 124,500 | ||||
Retained earnings | 53,000 | 28,700 | ||||
$351,000 | $319,000 |
Additional information for 2020:
1. | Net income was $24,000. | |
2. | Sales on account were $404,100. Sales returns and allowances amounted to $20,600. | |
3. | Cost of goods sold was $199,800. | |
4. | Net cash provided by operating activities was $45,100. | |
5. | Capital expenditures were $24,800, and cash dividends were $9,600. |
Compute the following ratios at December 31, 2020.
(Round current ratio to 2 decimal places, e.g. 1.67.
Round Accounts receivable turnover, Average collection period,
Inventory turnover and Days in inventory to 1 decimal place, e.g.
1.6.)
(a) | Current ratio | enter the Current ratio rounded to 2 decimal places | :1 | ||
---|---|---|---|---|---|
(b) | Accounts receivable turnover | enter the Accounts receivable turnover rounded to 1 decimal place | times | ||
(c) | Average collection period | enter the Average collection period rounded to 1 decimal place | days | ||
(d) | Inventory turnover | enter the Inventory turnover rounded to 1 decimal place | times | ||
(e) | Days in inventory | enter the Days in inventory rounded to 1 decimal place | days | ||
(f) | Free cash flow | $enter a dollar amount |
(a) | Current ratio | 2.92 | : 1 | =(16000+71000+59000)/50000 |
(b) | Accounts receivable turnover ratio | 5.9 | Times | =(404100-20600)/((71000+59000)/2) |
(c. ) | Average Collection period | 61.9 | Days | =((71000+59000)/2)*365/(404100-20600) |
(d) | Inventory Turnover | 3.7 | Times | =199800/((59000+49000)/2) |
(e.) | Days in Inventory | 98.6 | Days | |
(f) | Free Cash Flows | 20,300 | $ | =45100-24800 |
Get Answers For Free
Most questions answered within 1 hours.