Learning Team Assignment
Biowizard90
standard_industrial_classification_sic_description.pdf
SIC: 2911
SIC Description: Petroleum refining
Asset Range: All Asset Ranges within SIC Group
2009 2010 2011
Solvency Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower
Quick Ratio 0.9 0.6 0.2 1.3 0.7 0.4 1.2 0.8 0.3
Current Ratio 1.9 1.4 0.4 2.7 1.5 1.1 2.3 1.6 0.9
Current Liabilities / Net Worth (%) 28.8 53 129.5 27.4 50.8 81.8 42.6 58.9 92.4
Current Liabilities / Inventory (%) 160.9 254.8 595.7 151.2 313 482.7 142.3 241 435.3
Total Liabilities / Net Worth (%) 77.9 129.5 262.1 55 98.1 170 65.8 98.5 239.8
Fixed Assets / Net Worth (%) 85.8 124.9 175 47.1 109.4 152.4 55.8 121.4 153.1
Efficiency Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower
Collection Period (days) 10.6 23.4 35.8 12.8 25.9 34.2 12.8 26.1 46.7
Sales / Inventory (times) 20.7 13.5 5.7 29.4 16.6 7.5 23.1 14.2 5
Assets / Sales (%) 51.1 68.5 773.5 32 49.7 109.1 21.2 55.4 137.3
Sales / Net Working Capital (times) 21.9 11.9 7.4 21.7 10.3 5.8 24.9 9.1 6.1
Accounts Payable / Sales (%) 3.5 10.7 71.4 4.3 7.4 11.1 3.7 7.9 16.6
Profitability Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower
Return on Sales (%) 3.2 -0.6 -8.3 6 1.4 0.1 7.5 2 0.1
Return on Assets (%) 4.4 -1.8 -27.8 10.4 2.2 -5.8 12.1 2.5 -11.5
Return on Net Worth (%) 11.5 0 -25.4 17.1 7.5 1 28.7 12.7 0
Median Variance 2009 2010 2011
Solvency Median 2010 2011 Median 2009 2011 Median 2009 2010 Median 2009 2010 2011 Median 2009 2010 2011
Quick Ratio 0.6 -16.7 -33.3 100 100 0.7 16.7 -14.3 100 100 0.8 33.3 14.3 100 100 -100 -100 -100 0 -100 -100 -100 0
Current Ratio 1.4 -7.1 -14.3 100 100 1.5 7.1 -6.7 100 100 1.6 14.3 6.7 100 100 -100 -100 -100 0 -100 -100 -100 0
Current Liabilities / Net Worth (%) 53 2.2 -5.9 53 53 50.8 -2.2 -8.1 50.8 50.8 58.9 5.9 8.1 58.9 58.9 -53 -50.8 -58.9 0 -53 -50.8 -58.9 0
Current Liabilities / Inventory (%) 254.8 -58.2 13.8 254.8 254.8 313 58.2 72 313 313 241 -13.8 -72 241 241 -254.8 -313 -241 0 -254.8 -313 -241 0
Total Liabilities / Net Worth (%) 129.5 31.4 31 129.5 129.5 98.1 -31.4 -0.4 98.1 98.1 98.5 -31 0.4 98.5 98.5 -129.5 -98.1 -98.5 0 -129.5 -98.1 -98.5 0
Fixed Assets / Net Worth (%) 124.9 15.5 3.5 124.9 124.9 109.4 -15.5 -12 109.4 109.4 121.4 -3.5 12 121.4 121.4 -124.9 -109.4 -121.4 0 -124.9 -109.4 -121.4 0
Efficiency Median 2010 2011 Median 2009 2011 Median 2009 2010 Median 2009 2010 2011 Median 2009 2010 2011
Collection Period (days) 23.4 10.7 11.5 -100 -100 25.9 -10.7 0.8 -100 -100 26.1 -11.5 -0.8 -100 -100 100 100 100 0 100 100 100 0
Sales / Inventory (times) 13.5 -23 -5.2 100 100 16.6 23 14.5 100 100 14.2 5.2 -14.5 100 100 -100 -100 -100 0 -100 -100 -100 0
Assets / Sales (%) 68.5 18.8 13.1 68.5 68.5 49.7 -18.8 -5.7 49.7 49.7 55.4 -13.1 5.7 55.4 55.4 -68.5 -49.7 -55.4 0 -68.5 -49.7 -55.4 0
Sales / Net Working Capital (times) 11.9 13.4 23.5 100 100 10.3 -13.4 11.7 100 100 9.1 -23.5 -11.7 100 100 -100 -100 -100 0 -100 -100 -100 0
Accounts Payable / Sales (%) 10.7 3.3 2.8 10.7 10.7 7.4 -3.3 -0.5 7.4 7.4 7.9 -2.8 0.5 7.9 7.9 -10.7 -7.4 -7.9 0 -10.7 -7.4 -7.9 0
Profitability Median 2010 2011 Median 2009 2011 Median 2009 2010 Median 2009 2010 2011 Median 2009 2010 2011
Return on Sales (%) -0.6 -2 -2.6 -0.6 -0.6 1.4 2 -0.6 1.4 1.4 2 2.6 0.6 2 2 0.6 -1.4 -2 0 0.6 -1.4 -2 0
Return on Assets (%) -1.8 -4 -4.3 -1.8 -1.8 2.2 4 -0.3 2.2 2.2 2.5 4.3 0.3 2.5 2.5 1.8 -2.2 -2.5 0 1.8 -2.2 -2.5 0
Return on Net Worth (%) 0 -7.5 -12.7 0 0 7.5 7.5 -5.2 7.5 7.5 12.7 12.7 5.2 12.7 12.7 0 -7.5 -12.7 0 0 -7.5 -12.7 0
Industry Norms Data
2009 2010 2011
Cash 16821004 10.80% 32007226 12.70% 60555875 12.50% % %
Accounts Receivable 16042253 10.30% 34023429 13.50% 62493663 12.90% % %
Notes Receivable 311500 0.20% 1008102 0.40% 968894 0.20% % %
SIC: 2911
SIC Description: Petroleum refining
Asset Range: All Asset Ranges within SIC Group
2009 2010 2011
Solvency Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower
Other Current 7787501 5.00% 23942412 9.50% 35849078 7.40% % %
Total Current 53889511 34.60% 112403328 44.60% 210734445 43.50% % %
Fixed Assets 74292766 47.70% 92241296 36.60% 191841012 39.60% % %
Other Current Assets 27567756 17.70% 47380776 18.80% 81871543 16.90% % %
Total Assets 155750033 100.00% 252025400 100.00% 484447000 100.00% % %
Accounts Payable 152479282 97.90% 51665207 20.50% 202498846 41.80% % %
Notes Payable 141576780 141576780% 9828991 9828991% 865706789 865706789% % %
Other Current 33486257 21.50% 70063061 27.80% 506731562 104.60% % %
Total Current 327542319 210.30% 131557259 52.20% 574937197 325.10% % %
Other Long Term 41429509 26.60% 69054959 27.40% 129347349 26.70% % %
Deferred Credits 0 0.00% 0 0.00% 0 0.00% % %
Net Worth -213221795 -136.90% 51413182 20.40% -219837546 -251.80% % %
Total Liabilities & Net Worth 155750033 100.00% 252025400 100.00% 484447000 100.00% % %
Net Sales 227372311 100.00% 507093360 100.00% 874453069 100.00% % %
Gross Profit 36152197 15.90% 73528537 14.50% 139038038 15.90% % %
Net Profit After Tax -3865329 -1.70% 23326295 4.60% 34103670 3.90% % %
Working Capital -273652808 0.00% -19153931 0.00% -364202752 0.00% % %
