Submitted by: Submitted by cynshinhwa
Views: 838
Words: 580
Pages: 3
Category: Business and Industry
Date Submitted: 10/02/2011 03:23 PM
I.Exhibits
CALIFORNIA CHOPPERS RATIO TABLE
2001 2002 2003 2004 2005 Ind.Av.
Liquidity
Current Ratio 1.37 1.48 1.64 1.33 1.04 1.25
Cash Ratio 0.19 0.20 0.31 0.25 0.15 0.27
Asset Management
Inventory Turnover in Days 138.26 59.54 51.70 33.03 43.66 44.12
A/R Turnover in Days 59.16 42.69 39.28 42.69 42.30 32.45
A/P Turnover in Days 157.33 80.75 71.71 79.18 109.94 60.23
Cash Conversion Cycle 40.09 21.48 19.27 -3.46 -23.98 16.35
Fixed Assets Turnover 1.85 3.94 4.46 4.46 4.05 3.72
Total Asset Turnover 0.95 1.88 2.03 2.17 2.00 2.05
Long-term Debt Paying Ability
Debt Ratio 0.93 0.84 0.73 0.64 0.65 0.54
Times Interest Earned 1.23 2.62 3.54 3.42 3.06 9.33
Profitability
Gross Margin 30% 30% 29% 27% 26% 32.00%
Operating Profit Margin 5% 13% 11% 8% 5% 14.00%
Net Profit Margin 0.65% 5% 5% 4% 2% 8.50%
ROA 3.3% 16% 15% 11% 6% 17.46%
ROE 9% 63% 41% 22% 12% 38.25%
ANALYSIS OF ROE— 5-WAY
EBIT/Sales EBT/EBIT NI/EBT Tatal Asset Turnover Debt Ratio ROE
2001 0.0514 0.19 0.679 0.95 0.93 0.09
2002 0.128 0.618 0.68 1.88 0.84 0.63
2003 0.1102 0.718 0.68 2.03 0.73 0.41
2004 0.075 0.708 0.68 2.17 0.64 0.22
2005 0.046 0.673 0.68 2.00 0.65 0.12
According to the formulas given by the case we can calculate the data, take year 2001 as example:
Current ratio=current assets/current liabilities=148.76/108.82=1.37
Cash ratio=(cash+marketable securities)/current liabilities=20.56/108.82=0.19
Inventory turnover=cost of goods sold/average inventories=210.45/79.66=2.64
Inventory turnover in days=365/inventory turnover=365/2.64=138.26
A/R turnover=net credit sales/average accounts receivable=299.45/48.54-6.17
A/R turnover in days=365/A/R turnover=365/6.17=59.16
A/P turnover=cost of goods sold/average accounts payable=210.45/90.13=2.32
A/P turnover in days=365/A/P turnover=365/2.32=157.33
Cash conversion cycle=inventory turnover in days-A/P turnover in days+A/R turnover in days=138.26-157.33+59.16=40.09...