Please see attached page, the report data of my chosen company and the instruction. I also need to see how you calculated them. Thanks.

SIC: Line of Business: Asset Range: Industry Quartiles Statement Sampling Solvency Quick Ratio Current Ratio Current Liabilities / Net Worth (%) Current Liabilities / Inventory (%) Total Liabilities / Net Worth (%) Fixed Assets / Net Worth (%) Efficiency Collection Period (days) Sales / Inventory (times) Assets / Sales (%) Sales / Net Working Capital (times) Accounts Payable / Sales (%) Profitability Return on Sales (%) Return on Assets (%) Return on Net Worth (%) 3711 Motor vehicles and car bodies All Asset Ranges within SIC Group 2010 2011 2012 2013 2014 Samples: 22 Samples: 20 Samples: 23 Samples: 24 Samples: 20 Upper 1.20 Median Lower 0.80 0.60 Upper 1.00 Median Lower 0.70 0.50 Upper 0.90 Median Lower 0.70 0.40 Upper 1.00 Median Lower 0.50 0.30 Upper 1.00 Median Lower 0.40 0.30 2.80 1.50 1.30 2.80 1.50 1.20 2.20 1.60 1.00 1.90 1.30 0.50 1.90 1.40 1.00 20.70 69.50 168.90 33.80 98.90 194.60 39.80 76.30 172.20 37.80 65.50 159.30 36.70 85.50 209.90 78.80 178.40 230.20 76.40 148.00 351.10 78.40 113.40 366.90 116.80 198.60 378.80 94.40 136.50 288.10 41.00 145.50 264.50 37.10 207.60 241.10 63.00 166.90 285.20 57.30 155.50 262.30 71.80 170.10 322.50 19.80 33.80 53.60 24.30 37.90 59.80 16.10 38.00 77.20 17.20 30.60 53.50 18.80 33.60 81.50 Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower 20.60 35.10 46.20 13.00 23.00 44.90 8.80 32.50 43.80 11.00 25.00 40.90 11.30 27.40 44.20 11.60 6.30 4.00 8.50 6.40 4.10 9.00 6.60 3.50 10.00 6.10 4.80 7.90 5.60 2.60 41.10 54.10 152.60 50.50 63.60 87.00 47.30 67.30 81.10 50.80 69.10 96.50 46.30 70.30 133.20 10.10 4.90 3.50 9.20 6.30 4.30 8.30 6.40 4.40 12.00 6.80 4.50 11.90 6.20 4.40 4.00 7.40 17.50 5.10 10.10 16.80 4.40 7.90 62.20 6.20 10.10 16.60 5.10 6.80 17.30 Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower Upper Median Lower 4.90 2.80 0.10 6.20 2.40 0.20 3.40 1.10 -2.50 5.00 1.70 -2.70 5.90 0.90 -7.30 15.30 3.80 0.00 7.40 2.70 0.20 6.50 1.60 -3.40 11.60 0.50 -6.70 9.00 0.60 -6.40 28.90 9.30 2.30 44.60 10.80 0.40 16.10 4.90 -2.80 19.00 15.10 0.80 24.90 9.80 -4.90 2013 100.0 100.0 2014 100.0 100.0 Median - Median Variance Solvency Quick Ratio Current Ratio Current Liabilities / Net Current Worth (%) Liabilities / Total Liabilities Inventory (%) / Net Worth (%) Fixed Assets / Net Worth (%) Efficiency Collection Period (days) Sales / Inventory (times) Median 2011 0.80 12.5 1.50 0.0 2010 2012 12.5 -6.7 Median 2010 0.70 -12.5 1.50 0.0 2011 2012 0.0 -6.7 2013 100.0 100.0 2014 100.0 100.0 Median 2010 0.70 -12.5 1.60 6.7 2012 2011 0.0 6.7 2013 100.0 100.0 2014 100.0 100.0 69.50 -29.4 -6.8 69.5 69.5 98.90 29.4 22.6 98.9 98.9 76.30 6.8 -22.6 76.3 76.3 - 178.40 30.4 65 178.4 178.4 148.00 -30.4 34.6 148 148 113.40 -65 -34.6 113.4 113.4 - 145.50 -62.1 -21.4 145.5 145.5 207.60 62.1 40.7 207.6 207.6 166.90 21.4 -40.7 166.9 166.9 - 33.80 -4.1 -4.2 33.8 33.8 37.90 4.1 -0.1 37.9 37.9 38.00 4.2 0.1 38 38 - Median 2011 2012 2013 2014 Median 2010 2012 2013 2014 Median 2010 2011 2013 2014 Median 35.10 -34.5 -7.4 -100.0 -100.0 23.00 34.5 41.3 -100.0 -100.0 32.50 7.4 -41.3 -100.0 -100.0 - 6.30 -1.6 -4.8 100.0 100.0 6.40 1.6 -3.1 100.0 100.0 6.60 4.8 3.1 100.0 100.0 - 1/2 Assets / Sales (%) Sales / Net Working Capital (times) Accounts Payable / Sales (%) Profitability Return on Sales (%) Return on Assets (%) Return on Net Worth (%) 54.10 -9.5 -13.2 54.1 54.1 63.60 9.5 -3.7 63.6 63.6 67.30 13.2 3.7 67.3 67.3 - 4.90 -28.6 -30.6 100.0 100.0 6.30 28.6 -1.6 100.0 100.0 6.40 30.6 1.6 100.0 100.0 - 7.40 -2.7 -0.5 7.4 7.4 10.10 2.7 2.2 10.1 10.1 7.90 0.5 -2.2 7.9 7.9 - Median 2011 2012 2013 2014 Median 2010 2012 2013 2014 Median 2010 2011 2013 2014 Median 2.80 0.4 1.7 2.8 2.8 2.40 -0.4 1.3 2.4 2.4 1.10 -1.7 -1.3 1.1 1.1 - 3.80 1.1 2.2 3.8 3.8 2.70 -1.1 1.1 2.7 2.7 1.60 -2.2 -1.1 1.6 1.6 - 9.30 -1.5 4.4 9.3 9.3 10.80 1.5 5.9 10.8 10.8 4.90 -4.4 -5.9 4.9 4.9 - Norms Data Cash Accounts Receivable Notes Receivable Other Current Total Current Fixed Assets Other Current Assets Total Assets Accounts Payable Bank Loan Notes Payable Other Current Total Current Other Long Term Deferred Credits Net Worth Total Liabilities & Net Worth Net Sales Gross Profit Net Profit After Tax Working Capital 2010 1837761 2873324 58342 816782 10005586 2479519 2100298 14585403 1735663 12.60% 19.70% 0.40% 5.60% 68.60% 17.00% 14.40% 100.00% 11.90% 0.00% 962637 6.60% 4346450 29.80% 7044750 48.30% -1400199 -9.60% 14585 0.10% 8926267 61.20% 14585403 100.00% 28048852 100.00% 6395138 22.80% 560977 2.00% 2960836 0.00% 2011 4410959 5854546 681694 1644086 24500875 8741720 6857036 40099631 5132753 320797 1042590 9904609 16400749 2927273 240598 20531011 40099631 74121314 14305414 2742489 8100126 11.00% 14.60% 1.70% 4.10% 61.10% 21.80% 17.10% 100.00% 12.80% 0.80% 2.60% 24.70% 40.90% 7.30% 0.60% 51.20% 100.00% 100.00% 19.30% 3.70% 0.00% 2012 1824201 2231255 15076 1311616 9965266 3377034 1733745 15076045 2638308 12.10% 14.80% 0.10% 8.70% 66.10% 22.40% 11.50% 100.00% 17.50% 0.00% 422129 2.80% 3934848 26.10% 6995285 46.40% 3075513 20.40% 45228 0.30% 4960019 32.90% 15076045 100.00% 23704473 100.00% 6092050 25.70% 948179 4.00% 2969981 0.00% 2/2 2013 4435280 4435280 44801 3494462 26432475 10752193 7616137 44800805 22534805 9.90% 9.90% 0.10% 7.80% 59.00% 24.00% 17.00% 100.00% 50.30% 0.00% 537610 1.20% 37274269 83.20% 60346684 134.70% 12230620 27.30% 179203 0.40% -27955702 -62.40% 44800805 100.00% 66568804 100.00% 7189431 10.80% -1930495 -2.90% -33914209 0.00% 2014 7196514 6839662 59475 3865898 33484609 12073491 13917226 59475326 123292351 713704 2497964 186811998 313316017 37231554 356852 -291429097 59475326 86071384 14632135 344286 -279831408 12.10% 11.50% 0.10% 6.50% 56.30% 20.30% 23.40% 100.00% 207.30% 1.20% 4.20% 314.10% 526.80% 62.60% 0.60% -490.00% 100.00% 100.00% 17.00% 0.40% 0.00% Find a publicly-traded company using a financial information website. Some example companies include the following: General Motors Company: SIC Code:SIC-3711 (please see other attachment) Watch the Industry Averages and Financial Ratios video and use the industry classification from the financial services website to locate the company's SIC code on the U.S. Department of Labor's website. Find the industry ratios for the company using the Dun & Bradstreet Key Business Ratios. Locate the Dunn & Bradstreet Database by accessing the University of Phoenix Library and then locating Library Resources. Click on Alphabetical List of Resources and find Dunn and Bradstreet. Click on the link and search for your selected company. If your company's SIC code does not appear in the dropdown menu, choose another company. Assume the inventory ratio is based on a traditional inventory system, but globalized markets and the supply chain make it critical to adopt lean principles to create a more efficient system. Calculate the 14 ratios (show your calculations) for the company using the two most recent annual financial statements found on the financial information website you used earlier. Be careful not to use quarterly information, and include ratios for both years. Note. You can access a downloadable Ratio Guide PDF by clicking the Help Guide link in the upperright of the Dun & Bradstreet Key Business Ratios window. Compare the ratios for the company you selected with the appropriate industry ratios including profitability, solvency, and efficiency ratios shown on the Dun & Bradstreet report. Write a 350-word response about how the company you selected performed compared with the industry