Find the Financial Ratios

FINANCIAL RATIOS ***Use averages 2001 2002 Industry 2005 Average 2003 2004 1.25 0.27 44.12 ***Average Inventory 32.45 ***Average A/R 60.23 *** Average A/P 16.35 3.72 ***Average Net Fixed Assets (PPE) 2.05 ***Average Total Assets 2000 Liquidity 3 Current ratio g Cash ratio 10 11 Activity/Efficiency 12 Inventory days 13 A/R days 14 A/P days 15 Cash conversion cycle 16 Fixed assets turnover 17 Asset tumover 18 19 Leverage/Coverage 20 Debt ratio 21 Times interest earned 22 23 Profitability 24 Gross profit margin 25 Operating profit margin 26 Net profit margin 27 ROA 28 ROE 29 30 Decompose ROE using Dupont Identity 31 Profit Margn 32 Asset Turnover 33 Equity Multipler 0.54 9.33 32.00% 14.00% 8.50% 17.46% *** Average Total Assets 38.25% *** Average Total Equity 34 INCOME STATEMENT (millions of $) 3 4 5 6 Sales 7 COGS 8 Gross Profit 9 Selling and Administration 10 Depreciation 11 Operating Profit 12 Interest 13 Earnings Before Taxes 14 Taxes 15 Net Income 16 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 793.34 559.53 233.81 125.53 20.89 87.39 24.67 62.72 20.07 42.65 2004 814.55 595.34 219.21 136.57 21.22 61.42 17.96 43.46 13.91 29.55 2005 856.00 629.43 226.57 160.23 26.54 39.80 13.01 26.79 8.57 18.22 BALANCE SHEET (millions of $) 2002 25.78 84.89 2 3 4 5 6 Cash 7 AR 8 Inventory 9 Total Current Assets 10 Land, Plant and Equipment net 71 Other Assets 12 Total Assets 13 14 AP 15 Current Portion of LT Debt 16 Total Curent Liabilities 17 Long-Term Debt 18 Shareholders' Equity 19 Total Liabilities and Equities 20 2000 10.76 45.01 17.12. 72.89 54.32 2.47 129.68 2001 20.56 48.54 79.66 148.76 162.28 5.39 316.43 82.69 193.36 184.18 8.38 385.92 2003 38.55 85.39 79.30 203.24 178.01 8.82 390.07 2004 32.21 95.32 53.88 183.41 182.74 9.49 375.64 2005 29.75 99.23 75.33 204.31 211.48 11.65 427.44 53.77 2.88 56.65 52.86 20.21 129.68 90.73 18.09 108.82 185.45 22.16 316.43 112.15 18.77 130.92 193.84 61.16 385.92 109.96 14.32 124.28 161.98 103.81 390.07 129.04 8.56 137.60 104.68 133.36 375.64 189.84 6.22 196.06 79.80 151.58 427.44