HUMAN VIEW PERSPECTIVE
December 30, 2018
DISCUSSION FORM
January 3, 2019

Learning Team Assignment

Review the industry ratios for the company using the Dun & Bradstreet® Key Business Ratios.

Provide a 75-100 word summary Comparing the ratios for the company you selected with the appropriate industry ratios including profitability, solvency, and efficiency ratios shown on the Dun & Bradstreet® report.  Valencia

Company selected: Exxon Mobile Corporation

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% % %

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET A GOOD DISCOUNT 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

Manage Orders