Question 6.CS.4: Store container corporation
Store container corporation
Store container corporation balance sheet (millions of dollars) |
|||
December 31, | 200X | 200Y | 200Z |
Assets | |||
Cash and equivalent | $8,290 | $3,880 | $15,400 |
Receivables | 123,860 | 127,950 | 243,140 |
Inventories | 152,660 | 148,350 | 238,210 |
Other current | 38,440 | 40,000 | 33,710 |
Total current | 323,250 | 320,180 | 530,460 |
Net property, plant, and equipment | 657,660 | 642,560 | 924,360 |
Other assets | 25,750 | 47,580 | 68,780 |
Total assets | $1,006,660 | $1,010,320 | $1,523,600 |
Liabilities and stockholders’ equity | |||
Notes payable | $62,200 | $57,630 | $7,330 |
Accounts payable | 53,000 | 57,970 | 105,250 |
Income taxes payable | 3,740 | 4,120 | 5,880 |
Other current | 45,440 | 45,410 | 84,950 |
Total current | 164,380 | 165,130 | 203,410 |
Long-term debt | 491,330 | 501,250 | 768,490 |
Deferred taxes | 55,800 | 49,210 | 69,900 |
Total long-term debt | 547,130 | 550,460 | 838,390 |
Total liabilities | 711,510 | 715,590 | 1,041,800 |
Common stock | 147,390 | 152,170 | 222,360 |
Retained earnings | 147,760 | 142,560 | 163,250 |
Total common equity | 295,150 | 295,150 | 385,610 |
Preferred stock | – | – | 96,190 |
Total liabilities & equity | $1,006,660 | $1,010,320 | $1,523,600 |
Store container income statement (millions of dollars) (continued) |
|||
Sales | 200X | 200Y | 200Z |
Net sales | $1,244,390 | $1,229,150 | $2,032,320 |
Other income | 7,110 | 4,600 | 10,850 |
Total | 1,251,500 | 1,233,750 | 2,043,170 |
Costs and expenses | |||
Cost of sales | 925,870 | 944,150 | 1,564,610 |
Selling and administrative expenses | 147,640 | 156,990 | 241,180 |
Depreciation and amortization | 63,380 | 67,810 | 92,310 |
Interest expense | 59,280 | 63,310 | 85,340 |
Total | 1,196,170 | 1,232,260 | 1,983,440 |
Income (loss) before taxes | 55,330 | 1,490 | 59,730 |
Provision (credit) for income taxes | 21,670 | (2,290) | (24,320) |
Net income | $33,660 | $3,780 | $35,410 |
Store container corporation key ratios 200X-200Z |
||||
Ratio | 200X | 200Y | 200Z | Industry |
Liquidity | ||||
CA/CL | 1.97× | 1.94× | 2.61× | 1.80× |
Cash + receivables/CL | 0.80× | 0.80× | 1.27× | 0.90× |
Receivables/working capital | 78.0% | 83.0% | 74.0% | 69.0% |
Inventory/working capital | 96.0% | 96.0% | 73.0% | 72.0% |
Debt | ||||
TL/equity | 241.07% | 242.80% | 270.17% | 129.10% |
CL/equity | 55.69% | 56.03% | 52.75% | 50.90% |
EBIT/interest | 1.93× | 1.02× | 1.70× | 5.76× |
Profitability | ||||
Net income/sales | 2.71% | 0.31% | 1.74% | 2.50% |
Sales/total assets | 1.24× | 1.22× | 1.33× | 1.68× |
Total assets/equity | 3.41× | 3.43× | 3.95× | 3.26× |
Net income/equity | 11.400% | 1.280% | 9.180% | 13.700% |
Causal | ||||
Fixed assets/equity | 222.82% | 218.01% | 239.71% | 110.00% |
Collection period | 36.33 days | 38.00 days | 43.67 days | 38.90 days |
Sales/inventory | 8.15× | 8.29× | 8.53× | 12.30× |
Sales/equity | 4.22× | 4.17× | 5.27× | 2.63× |
Net income/sales | 2.71% | 0.30% | 1.74% | 5.20% |
Miscellaneous assets/equity | 8.72% | 16.14% | 17.83% | 7.95% |
The blue check mark means that this solution has been answered and checked by an expert. This guarantees that the final answer is accurate.
Learn more on how we answer questions.
Learn more on how we answer questions.
Liquidity looks sound, except that receivables/working capital is a little high.
Debt is well beyond the industry norms and is rising as measured by total liabilities to equity. Current debt is only slightly above average, but times interest earned is below average.
Profitability is below average.
Causes
- Excessive fixed assets without equity financing
- Excessive receivables
- Excessive inventory
- Overtrading
- Inadequate cost control low profit margin during sales growth
- Excessive miscellaneous assets
Related Answered Questions
Question: 6.KC.5
Verified Answer:
a. Incorrect. This is not correct because sales gr...
Question: 6.KC.4
Verified Answer:
a. Correct. The company’s debt to equity ratio is ...
Question: 6.KC.3
Verified Answer:
a. Correct. Best Buy is an overtrader, so answer a...
Question: 6.KC.2
Verified Answer:
a. Correct. The ratios of receivable and inventory...
Question: 6.KC.1
Verified Answer:
a. Incorrect. This answer cannot be correct becaus...
Question: 6.CS.1
Verified Answer:
Four of the six causal ratios are out of normal bo...
Question: 6.DC.1
Verified Answer:
Overall, this is an example of a company with a la...
Question: 6.CS.2
Verified Answer:
Liquidity – The company’s quantity of liquidity, a...
Question: 6.DC.2
Verified Answer:
This company is in the apparel business with facto...