Industry 2060, Delete any companies with missing data for AT, SALE, IB

Using Your industry (from question title), please answer these questions using Fiscal year 2015 data, use Total Assets (AT) for average investment, Income Before Extraordinary Items (IB) for income, and Sales/Turnover (Net) (SALE) for Sales Revenue

A) What is the average Sales Margin for your industry? ____________ Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45%, 0.45 for 0.45%

B) What is the average Turnover for your industry? ________ Answer to the nearest hundredth

C) What is the average Return on Investment for your industry? _____ Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45%

D) Which company (use Global Company Key) has the highest ROI in your Industry? _________ Answer with no leading zeros using the appropriate number of digits

DATA (From Excell) :

AutoSave Off Hy 11221b4e5f39b646 (1) - Excel Search Gillman, Gabriella GG File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments NT Calibri v 11 AI ab Wrap Text General 48 O 5 II AutoSum Fill M X Cut LO Copy Format Painter v Paste Insert Delete Format A Z Sort & Find & Filter Select ES E Merge & Center . Sensitivity $ %) , -20 Conditional Format as Cell Formatting Table Styles Analyze Data Clear Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity 122 X fix A B C D E F G . J L M N - - Global Company Industry 1 Key Data Da Data Year - Fis Format 2 5597 20151231 2015 INDL 3 8336 20151231 2015 INDL 4 10609 20151231 2015 INDL 5 11976 20160229 2015 INDL 6 24755 20150630 2015 INDL 7 27576 20151231 2015 INDL 8 100135 20160331 2015 INDL 9 130638 20150930 2015 INDL 10 154984 20150630 2015 INDL 11 160196 20151231 2015 INDL 12 186275 20151231 2015 INDL 13 RENOWN- Level of Consolidation - Company Annual Descriptor C C C C C C C C C C C Population Source D D D D D D D D Data Ticker Format Symbol STD HSY STD PARF STD TR STD RMCF STD JBSS STD SMPL STD TATYY STD RSGUF STD 5168B STD PLAG STD AGRO Assets - Income Before Extraordinary Sales/Turnover Active/Inactive Status Total Items (Net) Marker 5344.371 512.951 7386.626 A 24.583 0.513 23.734 A 908.983 66.089 540.112 A 30.316 4.426 40.457 A 431.935 29.305 887.245 A ISO Currency Company Name Code HERSHEY CO USD PARADISE INC USD TOOTSIE ROLL INDUSTRIE: USD ROCKY MOUNTAIN CHOC F.USD SANFILIPPO JOHN B&SON USD SIMPLY GOOD FOODS COM USD TATE & LYLE PLC USD ROGERS SUGAR INC CAD CHASE GENERAL CORP USD PLANET GREEN HOLDINGS USD ADECOAGRO SA USD Standard Industry Classification Code 2060 2060 2060 2060 2060 2060 2060 2060 2060 2060 2060 3672.907 551.929 1.258 309.538 1370.705 174.01 24.033 0.141 3.99 17.133 3386.726 A 541.545 A 3.224 A 215.315 A 674.314 A D D AutoSave Off Hy 11221b4e5f39b646 (1) - Excel Search Gillman, Gabriella GG File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments NT Calibri v 11 AI ab Wrap Text General 48 O 5 II AutoSum Fill M X Cut LO Copy Format Painter v Paste Insert Delete Format A Z Sort & Find & Filter Select ES E Merge & Center . Sensitivity $ %) , -20 Conditional Format as Cell Formatting Table Styles Analyze Data Clear Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity 122 X fix A B C D E F G . J L M N - - Global Company Industry 1 Key Data Da Data Year - Fis Format 2 5597 20151231 2015 INDL 3 8336 20151231 2015 INDL 4 10609 20151231 2015 INDL 5 11976 20160229 2015 INDL 6 24755 20150630 2015 INDL 7 27576 20151231 2015 INDL 8 100135 20160331 2015 INDL 9 130638 20150930 2015 INDL 10 154984 20150630 2015 INDL 11 160196 20151231 2015 INDL 12 186275 20151231 2015 INDL 13 RENOWN- Level of Consolidation - Company Annual Descriptor C C C C C C C C C C C Population Source D D D D D D D D Data Ticker Format Symbol STD HSY STD PARF STD TR STD RMCF STD JBSS STD SMPL STD TATYY STD RSGUF STD 5168B STD PLAG STD AGRO Assets - Income Before Extraordinary Sales/Turnover Active/Inactive Status Total Items (Net) Marker 5344.371 512.951 7386.626 A 24.583 0.513 23.734 A 908.983 66.089 540.112 A 30.316 4.426 40.457 A 431.935 29.305 887.245 A ISO Currency Company Name Code HERSHEY CO USD PARADISE INC USD TOOTSIE ROLL INDUSTRIE: USD ROCKY MOUNTAIN CHOC F.USD SANFILIPPO JOHN B&SON USD SIMPLY GOOD FOODS COM USD TATE & LYLE PLC USD ROGERS SUGAR INC CAD CHASE GENERAL CORP USD PLANET GREEN HOLDINGS USD ADECOAGRO SA USD Standard Industry Classification Code 2060 2060 2060 2060 2060 2060 2060 2060 2060 2060 2060 3672.907 551.929 1.258 309.538 1370.705 174.01 24.033 0.141 3.99 17.133 3386.726 A 541.545 A 3.224 A 215.315 A 674.314 A D D