CaseStudyweek5.xlsx

,

Sheet1

Case study 4: Store container corporation Store container corporation key ratios 200X-200Z
Store container corporation balance sheet (millions of dollars) Ratio 200X 200Y 200Z Industry
December 31, 200X 200Y 200Z Liquidity
Assets       CA/CL 1.97× 1.94× 2.61× 1.80×
Cash and equivalent $8,290 $3,880 $15,400 Cash + receivables/CL 0.80× 0.80× 1.27× 0.90×
Receivables 123,860 127,950 243,140 Receivables/working capital 78.00% 83.00% 74.00% 69.00%
Inventories 152,660 148,350 238,210 Inventory/working capital 96.00% 96.00% 73.00% 72.00%
Other current 38,440 40,000 33,710 Debt
 Total current 323,250 320,180 530,460 TL/equity 241.07% 242.80% 270.17% 129.10%
Net property, plant, and equipment 657,660 642,560 924,360 CL/equity 55.69% 56.03% 52.75% 50.90%
Other assets 25,750 47,580 68,780 EBIT/interest 1.93× 1.02× 1.70× 5.76×
 Total assets $1,006,660 $1,010,320 $1,523,600 Profitability
Liabilities and stockholders’ equity Net income/sales 2.71% 0.31% 1.74% 2.50%
Notes payable $62,200 $57,630 $7,330 Sales/total assets 1.24× 1.22× 1.33× 1.68×
Accounts payable 53,000 57,970 105,250 Total assets/equity 3.41× 3.43× 3.95× 3.26×
Income taxes payable 3,740 4,120 5,880 Net income/equity 11.40% 1.28% 9.18% 13.70%
Other current 45,440 45,410 84,950 Causal
 Total current 164,380 165,130 203,410 Fixed assets/equity 222.82% 218.01% 239.71% 110.00%
Long-term debt 491,330 501,250 768,490 Collection period 36.33 days 38.00 days 43.67 days 38.90 days
Deferred taxes 55,800 49,210 69,900 Sales/inventory 8.15× 8.29× 8.53× 12.30×
 Total long-term debt 547,130 550,460 838,390 Sales/equity 4.22× 4.17× 5.27× 2.63×
 Total liabilities 711,510 715,590 1,041,800 Net income/sales 2.71% 0.30% 1.74% 5.20%
Common stock 147,390 152,170 222,360 Miscellaneous assets/equity 8.72% 16.14% 17.83% 7.95%
Retained earnings 147,760 142,560 163,250
 Total common equity 295,150 294,730 385,610
Preferred stock – – 96,190
 Total liabilities & equity $1,006,660 $1,010,320 $1,523,600
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

Is this the question you were looking for? Place your Order Here

/0 Comments/by