I need to complete this worksheet ratio analysis and I am lost. The industry ratios totals I have I do not think are correct. Those total came from the transportation schedule sheet, and the company ratio comes from 2017 company date.

I need help checking the industry ratio totals and figuring out the company ratios see attached sheet

Company Data Sales Cost of Goods Sold Profit before Interest and Taxes Profit After Taxes Inventory Current Assets Fixed Assets SALLLLL185391 20--17 20--16 (Current year) (Previous year) 21,01120,425 16431 6132 14,740 14203 3,488 2244 420 1 337 4815 4498 18 539 17,044 25110 23286 6905 1 6844 3320 | 2821 141680 14845 10430 1 8441 Total Assets Current Liabilities Long Term Debt Total Debt Total Shareholder Equity Case Name South West Industry Name Case Case Year Data Source Type of Ratio Ratio Name Calculation Industry Ratios Company Ratios Profitability Ratios 068 Gross Profit Margin Operating Profit Margin Net Profit Margin Sales-cogs/sales ni-093112 EBIT/salesini Net Income/Sales Laul Net income/Assets 19.a 14.6 5.7 Return on Assets Return on Equity Net Income/Equity Liquidity Ratios Current Ratio C Assets/C Liabilities Quick Ratio CA-Inventory/C1905 09012 Leverage Ratios Debt to Assets Debt to Equity Debt/Assets 1980 Debt/Equity 0902 LT Debt/Equity LT Debt to equity Activity Ratios Inventory Turnover Total Asset Turnover COGS/inventory Sao Sales/Assets. 5110 Sales/Fixed Assets lau1214539 3.07 1,4 1531 .84 1,14 2 Fixed Asset Turnover TRANSPORTATION-Scheduled Passenger Air Transportation omparative Historical Data 1033 Current Data Sorted by Sales Type of Statement Din TAR SANT DIMM 121671-9/30/17) 1.3MM 3.5MM STORM 137 1/31/1 10-MM MM A OVER 100.0 2017 NUMBER OF STATEMENTS ASSETS Cast & Foumistents Trade Rece ny AROC 3D To Coment 510 The Resiste Intantes As Other Non- 100.0 T00.0 Tot LIABILITIES 105 Notes Payotte Short Term 3.7 Car MLTD TEN Trare Payabhr Income Taxes Payable 12.0 NI Other Current 103429 Total Current 43,7 Long Term Dto! Desemed Taxes 7.4 82 All the Non-Current Net Worth 100.0 Total Lisbe & Net Worth INCOME DATA 1000 100.0 Seles ON Gross Prom Operating peries 2109 Operating profil All Other Expanse Prott Solare Tees RATIOS 38.3 323 1000 SE37623 TOLD 100.0 33 Current Quick 2 191. 2 4 103.8 Sales Receivables 33 11.1 40 0.1 Cost of Swedentory Cost of Sales Payables 145. 91 Sales/Working Capital -11.7 105 EDITderest Net Prolit + Dip, Dep.. Amort/Cur. Mart/TAO PAR Fixed Worth - 15.0 DotWorth Prolit Before Taxes/Twigible Not Worth 323 -22.6 14.0 39. 99 47.0 17.813 181 4.2 7.5 14.5 129 6657 -1.4 11.5 10.0 28 Pro Before Taas/rola Asses Sales/Mel Fred Assets A SIESE RAZINIZANTES 1.0 Sarelles 13 2.2 24 14 Sales/Total Assets 667 % Depr. Den.Amort/Stles 16.7 8.0 7,0 2. 2.0 ORONY 51296M *1521M 2001038M 1866596M Officers, Directors' Owners' Core Sales Hot Sales ($) Total Ace (5) Mesthousand MM. 5 million 589M BS3M 10373M 5 478M 17054M 23043M 51047M 41821M 21171M 110 Current Data Sorted by Sales Type of Statement D TED WAL 21/18 1211-1730) almM1-IMIA ISMN 2010 troum 05. 13.9 10.2 10 420 2.5 44 30.6 51.6 100.0 12.8 100.0 100.0 8.3 2.7 1,5 10.5 3.7 RONE 13.4 126 49 NUMBER OF STATEMENTS ASSETS Cash & E nts Tete Decora Inwory A O r Current To Ourent The Assen Intanobinet Anton una Told LIABILITIES Notes Payat -Short Term Cur Mat LTD Trore Puyables Incond Tax Proble NI Other Current Total Current Long-Torm Debt Delen Taxes All Othly Non-Current Net Worth Total the Net Worth INCOME DATA por Sales Goproti Opening Expenses Operating profil All Other Expa thol Prolit Before Tayes RATIOS 29.3 43.7 38.3 7.0 7.4 3.2 100.0 100.0 100.0 1000 100.03 100,0 91.1 9.1 00.3 4.9 4.0 16 4.0 7.7 3.1 2012 Cikrent 1.4 20 Oukk 39.2 2 4 103.8 191. 2 22.1 11.1 Sales Recerrables 10.3 2 40 33 3.1 Consol Sales/Inventory Cost of Sale Payables 10.0 1020 3 3.22 Sales/Working Capital 199 6.7 10.5 1910 35 3 37404 EET interest Net Prolit + Depr., Dep. Amort/Cur. Malin SI 22 4 -15.0 3 8.9 Fred Worth DetWorth Profil Botore Toxes/Tangible Net Worth 4.2 A22 .22.6 14.0 39.9 47.0 42. DO 3178 39 7.9 14.5 12.9 23 X6S /67 -1.4 27.9 11.5 10.0 4232 28 1.4 % Prot Before Taas/Total Assets Sales/Mel Fred Assets 22 399 14 Sales/Total Assets 2.1 Depr., Deo. Amort/Sales 16.7 20 5.0 SE3013115562 8.0 2.3 RARO 3010765 5.1 1995839M 2 261296M 2861038M 1886695M 1871521M 1868596M 4.5 CG Otficers', Directors Owners' Comp/Sales Het Sales (5) Total Asia (5) $thousand "MM = 5 million 509M 103731 WA 2018 M Company Data Sales Cost of Goods Sold Profit before Interest and Taxes Profit After Taxes Inventory Current Assets Fixed Assets SALLLLL185391 20--17 20--16 (Current year) (Previous year) 21,01120,425 16431 6132 14,740 14203 3,488 2244 420 1 337 4815 4498 18 539 17,044 25110 23286 6905 1 6844 3320 | 2821 141680 14845 10430 1 8441 Total Assets Current Liabilities Long Term Debt Total Debt Total Shareholder Equity Case Name South West Industry Name Case Case Year Data Source Type of Ratio Ratio Name Calculation Industry Ratios Company Ratios Profitability Ratios 068 Gross Profit Margin Operating Profit Margin Net Profit Margin Sales-cogs/sales ni-093112 EBIT/salesini Net Income/Sales Laul Net income/Assets 19.a 14.6 5.7 Return on Assets Return on Equity Net Income/Equity Liquidity Ratios Current Ratio C Assets/C Liabilities Quick Ratio CA-Inventory/C1905 09012 Leverage Ratios Debt to Assets Debt to Equity Debt/Assets 1980 Debt/Equity 0902 LT Debt/Equity LT Debt to equity Activity Ratios Inventory Turnover Total Asset Turnover COGS/inventory Sao Sales/Assets. 5110 Sales/Fixed Assets lau1214539 3.07 1,4 1531 .84 1,14 2 Fixed Asset Turnover TRANSPORTATION-Scheduled Passenger Air Transportation omparative Historical Data 1033 Current Data Sorted by Sales Type of Statement Din TAR SANT DIMM 121671-9/30/17) 1.3MM 3.5MM STORM 137 1/31/1 10-MM MM A OVER 100.0 2017 NUMBER OF STATEMENTS ASSETS Cast & Foumistents Trade Rece ny AROC 3D To Coment 510 The Resiste Intantes As Other Non- 100.0 T00.0 Tot LIABILITIES 105 Notes Payotte Short Term 3.7 Car MLTD TEN Trare Payabhr Income Taxes Payable 12.0 NI Other Current 103429 Total Current 43,7 Long Term Dto! Desemed Taxes 7.4 82 All the Non-Current Net Worth 100.0 Total Lisbe & Net Worth INCOME DATA 1000 100.0 Seles ON Gross Prom Operating peries 2109 Operating profil All Other Expanse Prott Solare Tees RATIOS 38.3 323 1000 SE37623 TOLD 100.0 33 Current Quick 2 191. 2 4 103.8 Sales Receivables 33 11.1 40 0.1 Cost of Swedentory Cost of Sales Payables 145. 91 Sales/Working Capital -11.7 105 EDITderest Net Prolit + Dip, Dep.. Amort/Cur. Mart/TAO PAR Fixed Worth - 15.0 DotWorth Prolit Before Taxes/Twigible Not Worth 323 -22.6 14.0 39. 99 47.0 17.813 181 4.2 7.5 14.5 129 6657 -1.4 11.5 10.0 28 Pro Before Taas/rola Asses Sales/Mel Fred Assets A SIESE RAZINIZANTES 1.0 Sarelles 13 2.2 24 14 Sales/Total Assets 667 % Depr. Den.Amort/Stles 16.7 8.0 7,0 2. 2.0 ORONY 51296M *1521M 2001038M 1866596M Officers, Directors' Owners' Core Sales Hot Sales ($) Total Ace (5) Mesthousand MM. 5 million 589M BS3M 10373M 5 478M 17054M 23043M 51047M 41821M 21171M 110 Current Data Sorted by Sales Type of Statement D TED WAL 21/18 1211-1730) almM1-IMIA ISMN 2010 troum 05. 13.9 10.2 10 420 2.5 44 30.6 51.6 100.0 12.8 100.0 100.0 8.3 2.7 1,5 10.5 3.7 RONE 13.4 126 49 NUMBER OF STATEMENTS ASSETS Cash & E nts Tete Decora Inwory A O r Current To Ourent The Assen Intanobinet Anton una Told LIABILITIES Notes Payat -Short Term Cur Mat LTD Trore Puyables Incond Tax Proble NI Other Current Total Current Long-Torm Debt Delen Taxes All Othly Non-Current Net Worth Total the Net Worth INCOME DATA por Sales Goproti Opening Expenses Operating profil All Other Expa thol Prolit Before Tayes RATIOS 29.3 43.7 38.3 7.0 7.4 3.2 100.0 100.0 100.0 1000 100.03 100,0 91.1 9.1 00.3 4.9 4.0 16 4.0 7.7 3.1 2012 Cikrent 1.4 20 Oukk 39.2 2 4 103.8 191. 2 22.1 11.1 Sales Recerrables 10.3 2 40 33 3.1 Consol Sales/Inventory Cost of Sale Payables 10.0 1020 3 3.22 Sales/Working Capital 199 6.7 10.5 1910 35 3 37404 EET interest Net Prolit + Depr., Dep. Amort/Cur. Malin SI 22 4 -15.0 3 8.9 Fred Worth DetWorth Profil Botore Toxes/Tangible Net Worth 4.2 A22 .22.6 14.0 39.9 47.0 42. DO 3178 39 7.9 14.5 12.9 23 X6S /67 -1.4 27.9 11.5 10.0 4232 28 1.4 % Prot Before Taas/Total Assets Sales/Mel Fred Assets 22 399 14 Sales/Total Assets 2.1 Depr., Deo. Amort/Sales 16.7 20 5.0 SE3013115562 8.0 2.3 RARO 3010765 5.1 1995839M 2 261296M 2861038M 1886695M 1871521M 1868596M 4.5 CG Otficers', Directors Owners' Comp/Sales Het Sales (5) Total Asia (5) $thousand "MM = 5 million 509M 103731 WA 2018 M