turnover ... sales (same thing)

roi ... income / total assets

sales margin total proft / sales income

Global Company Key	Data Date	Data Year - Fiscal	Industry Format	Level of Consolidation - Company Annual Descriptor	Population Source	Data Format	Ticker Symbol	ISO Currency Code	Assets - Total	Income Before Extraordinary Items	Sales/Turnover (Net)	Active/Inactive Status Marker	Standard Industry Classification Code
4988	20151231	2015	INDL	C	D	STD	TGNA	USD	8537.758	357.458	3050.945	A	4833
5284	20151231	2015	INDL	C	D	STD	GTN	USD	2143.161	39.301	597.356	A	4833
10726	20151231	2015	INDL	C	D	STD	TRCO	USD	9758.535	-319.918	2010.46	I	4833
13970	20151231	2015	INDL	C	D	STD	TVAGF	CAD	635.114	-55.226	589.89	A	4833
14535	20151231	2015	INDL	C	D	STD	SSP	USD	1680.86	-66.637	715.656	A	4833
17687	20151231	2015	INDL	C	D	STD	HMTV	USD	551.15	13.739	129.79	A	4833
30778	20151231	2015	INDL	C	D	STD	CETV	USD	1454.201	-101.614	605.841	A	4833
30950	20151231	2015	INDL	C	D	STD	MEG	USD	4408.352	-39.459	1304.943	I	4833
32280	20151231	2015	INDL	C	D	STD	STRZA	USD	1564.2	236.1	1700.1	I	4833
34636	20150630	2015	INDL	C	D	STD	FOXA	USD				A	4833
60800	20151231	2015	INDL	C	D	STD	SBGI	USD	5432.315	171.524	2219.136	A	4833
63669	20151231	2015	INDL	C	D	STD	5952B	USD	10126.4	-44.6	2858.4	A	4833
137943	20151231	2015	INDL	C	D	STD	EVC	USD	528.188	25.625	254.134	A	4833
140167	20151231	2015	INDL	C	D	STD	AITVF	CAD	16.018	1.863	26.03	A	4833
149177	20151231	2015	INDL	C	D	STD	NXST	USD	1835.134	77.684	896.377	A	4833
165675	20150930	2015	INDL	C	D	STD	VIAB	USD	22217	1922	13268	A	4833
180167	20151231	2015	INDL	C	D	STD	SNI	USD	6672.314	606.828	3018.227	I	4833
187406	20151231	2015	INDL	C	D	STD	AMCX	USD	4264.915	366.788	2580.935	A	4833

Industry 4833, 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 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% What is the average Turnover for your industry Answer to the nearest hundredth What is the average Return on Investment for your industry of a percent, without the % sign, example 3.45 for 3.45% Answer in percentage, to the nearest hundredth Which company (use Global Company Key) has the highest ROI in your Industry? Answer with no leading zeros using the appropriate number of digits Excel File Edit View Insert Format Tools Data Window Help melissa a Page Layout Home Insert Formulas Data Review View - A- A- Calibri (Body) 11 Wrap Text Paste Merge & Cent v fx C23 Level of Consolidation - Company Annual Descriptor Populat Source Industry Data Year- Global Compan 1 Key Data Da 20151231 Fiscal Format 4988 2015 NDL 2015 INDL 5284 20151231 3. 10726 20151231 2015 INDL 4. 2015 INDL 13970 20151231 2015 INDL 20151231 14535 17687 30778 2015 INDL 20151231 20151231 20151231 2015 INDL 2015 INDL 2015 INDL 30950 20151231 32280 10 2015 INDL 34636 60800 63669 20150630 11 2015 INDL 2015 INDL 20151231 12 20151231 13 2015 INDL 137943 140167 20151231 20151231 14 2015 INDL 2015 INDL 15 20151231 20150930 149177 16 2015 INDL 165675 17 18 2015 INDL 2015 INDL 180167 20151231 20151231 187406 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 WRDS Ready W PO x N 0 Help 0) 28% Wed Dec 11 12:30:55 AM Melissa Gamonal melissa acounting project Q- Search Sheet Insert General Wrap Text Delete .00 Conditional Format Formatting as Table Merge & Center Cell Styles Sa .00 Format Fi ISO Currency Income Before Extraordinary Sales/Turne Ticker Symbol Population Data nual Assets- Td 8537.758 (Net) Items Format Code Source 357458 39.301 STD TGNA USD USD 2143.161 STD GTN 319.918 9758535 TRCO USD STD -55.226 635.114 TVAGF CAD STD 66.637 13.739 1680 6 STD SSP USD 551.15 USD STD HMTV -101.614 -39.459 1454.201 USD STD CETV 4408.352 MEG USD STD DI 236.1 1564.2 STRZA USD STD USD FOXA STD 171524 5432.315 USD STD SBGI -446 101264 59528 USD STD Di 25.625 1863 S28.188 USD EVC STD 16.018 CAD STD ATVF 77.684 1835.134 USD STD NKST 1922 22217 6672.314 4264.915 USD VIAB STD 606828 366.788 USD SNI STD AMCX USD STD Q. Search Sheet unting project + Share Insert General Delete 24 .00 Conditional Format Cll Styles Sort & Filter .00 Format Formatting as Table Income Before Extraordinary Items Sales/Turnover Active/Inactive Status Standard Industry Classification (Net) Marker Code 357.458 3050.945 A 4833 39.301 597 356 A 4833 -319.918 2010.46 I 4833 -55.226 589.89 A 4833 66.637 715.656 A 4833 13.739 129.79 A 4833 -101.614 605 841 A 4833 -39.459 1304.9431 4833 236.1 1700.1I 4833 4833 171524 2219.136 A 4833 44.6 2858.4 A 4833 25.625 254.134 A 4833 1863 26.03 A 4833 77.684 896.377 A 13268 A 4833 1922 606.828 366.788 4833 3018.227 I 4833 2580.935 A 4333 80%