Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello! Picture 1 and 2 were given information, I completed picture 3 and I need help completing picture number 4, ratios. Thanks! Picture 1: Picture

Hello! Picture 1 and 2 were given information, I completed picture 3 and I need help completing picture number 4, "ratios". Thanks!
Picture 1:
image text in transcribed
Picture 2:
image text in transcribed
Picture 3:
image text in transcribed
Picture 4 (the one I need help with):
image text in transcribed
Exhibit 3 INCOME STATEMENT (millions of $) Sales Cost of Goods Sold Gross Profit Selling and Administration Depreciation Operating Profit Interest Earnings Before Taxes Taxes Net Income 2000 287.14 209.69 77.45 57.34 7.53 12.58 9.41 3.17 1.01 2.16 2001 299.45 210.45 89.00 60.06 13.54 15.40 12.53 2.87 0.92 1.95 2002 725.45 506.91 218.54 104.14 21.54 92.86 35.51 57.35 18.35 39.00 2003 2004 793.34 814.55 559.53 595.34 233.81 219.21 125.53 136.57 20.89 21.22 87.39 61.42 24.67 17.96 62.72 43.46 20.07 13.91 42.65 29.55 2005 856.00 629.43 226.57 160.23 26.54 39.80 13.01 26.79 8.57 18.22 Exhibit 4 BALANCE SHEET (millions of $) Cash A/R Inventory Total Current Assets Land, Plant and Equipment net Other Assets Total Assets 2000 2001 10.76 20.56 45.01 48.54 17.12 79.66 72.89 148.76 54.32 162.28 2.47 5.39 129.68 316.43 53.77 90.73 2.88 18.09 56.65 108.82 52.82 185.45 20.21 22.16 129.68 316.43 2002 25.78 84.89 82.69 193.36 184.18 8.38 385.92 112.15 18.77 130.92 193.84 61.16 385.92 2003 2004 38.55 34.21 85.39 95.32 79.3 53.88 203.24 183.41 178.01 182.74 8.829.49 390.07 375.64 109.96 129.04 14.32 8.56 124.28 137.6 161.98 104.68 103.81 133.36 390.07 375.64 2005 29.75 99.23 75.33 204.31 211.48 11.65 427.44 189.84 6.22 196.06 79.8 151.58 427.44 A/P Current Portion of LT Debt Total Current Liabilities Long-term Debt Shareholders' Equity Total Liabilities and Equities OG Exhibit 5- Industry Averages 1.25 0.27 Liquidity Current Ratio Cash Ratio Asset Management Inventory Turnover in Days A/R Turnover in Days A/P Turnover in Days Cash Conversion Cycle Fixed Assets Turnover Total Asset Turnover Long-term Debt Paying Ability Debt Ratio Times Interest Earned Profitability Gross Margin Operating Profit Margin Net Profit Margin ROA ROE 44.12 32.45 60.23 16.35 3.72 2.05 0.54 9.33 32.00% 14.00% 8.50% 17.46 38.25 COMMON SIZE (VERTICAL) INCOME STATEMENT (millions of $) Sales Cost of Goods Sold Gross Profit Selling and Administration Depreciation Operating Profit Interest Earnings Before Taxes Taxes Net Income 2000 2001 100.00 100 73.03 78.28 26.97 29.72 19.97 20.06 2.62 4.52 4.38 5.14 3.28 4.18 1.10 0.96 0.35 0.31 0.75 0.65 2002 100 68.88 30.12 14.36 2.97 12.8 4.89 7.91 2.53 5.38 2003 100 70.53 29.47 15.82 2.63 11.02 3.11 7.91 2.53 5.38 2004 100 73.09 26.91 16.77 2.61 7.54 2.2 5.34 1.71 3.63 2005 100 73.53 26.47 18.72 3.1 4.65 1.52 3.13 2.13 Exhibit 4 BALANCE SHEET (millions of $) Cash AR Inventory Total Current Assets Land, Plant and Equipment net Other Assets Total Assets A/P Current Portion of LT Debt Total Current Liabilities Long-term Debt Shareholders' Equity Total liabilities and Fauities 2000 2001 8.30 6.49 34.71 15.34 13.20 25.17 56.21 47.01 41.89 51.28 1.90 1.7 100.00 100 41.46 28.67 2.22 5.71 43.68 34.39 40.73 58.61 15.58 7 100.00 100 2002 6.68 21.99 21.24 50.1 47.72 2.17 100 29.06 4.86 33.39 50.22 15.85 2003 9.88 21.89 20.33 52.1 45.63 2.26 100 28.19 3.67 31.86 41.53 26.61 100 2004 9.11 25.38 14 34 48.83 48.64 2.53 100 34.35 2.28 36.63 27.86 35.5 100 2005 6.96 23.21 17.62 47.8 49.48 2.73 100 44.14 1.46 45.87 18.67 35.46 100 100 2002 2003 2004 2005 Ind. Av. 1.5 0.2 1.631.33 0.31 0.25 1.041.36 0.15 0.22 NA CALIFORNIA CHOPPERS RATIO TABLE 2000 2001 Liquidity Current Ratio 1.291.37 Cash Ratio 0.19 0.19 Asset Management Inventory Turnover in Days NA 83.93 A/R Turnover in Days 57.01 A/P Turnover in Days NA 125.31 Cash Conversion Cycle NA 15.63 Fixed Assets Turnover NA 2.67 Total Asset Turnover NA 1.34 Long-term Debt Paying Debt Ratio 0.93 Times Interest Earned 1.34 1.23 Profitability Gross Margin 26.97% 29.72% Operating Profit Margin 4.38% 5.14% Net Profit Margin 0.75% 0.65% ROA na 4.69% ROE na 9.21% 30.12% 12.80% 5.38% 29.47% 11.02% 5.38% 26.91% 7.54% 3.63% 26.47% 4.65% 2.13% 26.27% 7.58% 2.98%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions