please only do the inventory turnover and debt to asset ratio explain and comapre to the other years

1. Review the ratios provided. (Note that there are two inventories to consider for the company: Fuel and expendable I parts. The ratios provided ONLY take fuel into account.) Identify each of the following ratios that are provided in the spreadsheet for the year 2017, and provide an explanation of its meaning, comparable to other years: Current Ratio Asset Turnover Inventory Turnover Debt to Asset Ratio Interest Coverage Profit Margin Return on Assets Return on Equity Dec. 31, 2017 LIQUIDITY RATIOS Dec. 31, 2016 Dec. 31, 2015 Dec. 31, 2014 a Current ratio (times) Quick ratio (times) Average payment period (days) 0.27 18341 0.49 0.35 181.43 0.52 0.31 151.15 0.54 0.33 ASSET MANAGEMENT RATIOS Total asset turnover (times) Fixed asset tumover (times) Average collection period (days) Inventory turnover (times) 0.77 1.55 19.65 0.77 1.63 18.80 9.89 0.77 1.77 19.36 17.27 0.75 1.84 20.77 21.85 Fuel Only 6.26 FINANCIAL LEVERAGE RATIOS 73.90% 79.58% Total debt to total assets Equity multiplier (times) Interest coverage (times) 3.83 76.03% 4.17 17.92 83.6896 6.13 3.39 4.90 16.22 PROFITABILITY RATIOS 15.44 14.82% 8.67% Operating profit margin Net profit margin Operating return on assets Return on total assets Return on equity 11.47% 6.71% 25.72% 17.54% 11.03% 13.56% 8.53% 35.59% 19.17% 11.12% 14.68% 8.52% 41.71% 5.47% 1.63% 4.08% 1.22% 7 7.48% Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 $1,814 825 2.377 $ 2,762 487 2,064 $ 1972 1,465 2,020 $ 2,088 1.217 2.297 916 413 519 372 119 379 318 925 534 318 Consolidated Balance Sheets - USD ($) $ In Millions Current Assets: Cash and cash equivalents Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $12 and $15 at December 31, 2017 and 2016, respectively Hedge margin receivable Fuel inventory Expendable parts and supplies inventories, net of an allowance for obsolescence of 5113 and 5110 at December 31, 2017 and 2016, respectively Hedge derivatives asset Prepaid expenses and other Total current assets Property and Equipment, Net: Property and equipment, nct of accumulated depreciation and amortization of $14,097 and $12,456 at December 31, 2017 and 2016, respectively Other Assets: Goodwill Identifiable intangibles, net of accumulated amortization of $845 and 5828 at December 31, 2017 and 2016, respectively Deferred income taxes, nct Other noncurrent assets Total other assets Total assets Current Liabilities: Current maturities of long-term debt and capital lcases 1,499 7,844 1,247 7,451 1,987 796 9.056 1,078 701 9.158 26,563 24,375 23.039 21.929 9,794 4.847 9,794 4,844 9.794 4,861 9,794 4,603 035 3,309 3,064 1,733 19,435 51.261 18.885 4.956 1,428 21,039 53,134 7.595 926 22,918 54,005 53 292 2.242 Air traffic liability 1.131 4.888 4,626 1.184 4.296 2,622 3674 2.266 Fucl card obligation 3,022 3.022 1,822 1,067 1,858 1,563 4,503 2,743 3,195 2581 1,635 1306 17,526 2.572 2.924 1,648 431 1.907 2,772 1.580 18.573 15.239 2,127 16,847 Accounts payable Accrued salaries and related benefits Frequent flyer deferred revenue Other accrued liabilities Total current liabilities Noncurrent Liabilities: Long-term debt and capital leases Pension, postretirement and related benefits Frequent flyer deferred revenue Other noncurrent liabilities Total noncurrent liabilities Commitments and Contingencies Stockholders' Equity: Common stock at 50.0001 par value: 1 500,000,000 shares guthorized. 714 674,160 and 744,886,938 shares issued at December 31, 2017 and 2016, respectively Additional paid in capital Retained camnings Accumulated other comprehensive loss Treasury stock, at cost, 7A76,181 and 14.149 229 shares at December 31, 2017 and 2016, respectively 6.592 9,810 2.296 2.111 20,809 6.201 13.378 2.278 1,878 23,735 6,766 13,855 2.246 1,891 24.758 8,477 15,138 2,602 2.128 $ 28, 345 0 0 0 $0 12.053 9,636 (7.621) (158) 12,204 7,203 (7,636) (274) 12.936 5,562 (7275) (373) 12,981 3.456 (7311) Total stockholders' equity Total liabilities and stockholders' cquity (313) 13.910 S53.292 12,287 $ 51.261 10.850 $ 53,134 8.813 $ 54,005 Consolidated Statements of Operations - USD ($) $ in Millions 12 Months Ended Dec 31, 2016 Dec 31, 2017 Dec 31, 2015 Dec 31, 2014 $ 29.105 5.714 34.819 729 5,696 41 244 $ 28.105 5,672 3.7777 668 5.194 $28.898 5,884 34.782 813 5.109 40,704 $ 28,888 6.266 34.954 934 4.474 40.362 39,639 Passenger: Mainline Regional carriers Total passenger revenue Cargo Other Total operating revenue Operating Expense: Salaries and related costs Aircraft fuel and related taxes Regional carriers expensc Depreciation and amortization Contracted services Aircraft maintenance materials and outside repairs Passenger commissions and other selling expenses Landing fees and other rents Passenger service Profit sharing Aircraft rent Other Total operating expense Operating Income Non-Operating Expense: Interest expense, net Miscellaneous, net Total non-operating expense, net Income Before Income Taxes Income Tax Provision Net Income Basic Eamings Per Share (usd per share) Diluted Earnings Per Sharc (usd per share) Cash Dividends Declared Per Sharc (usd per share) 10,436 5.733 4.503 2.235 2.184 1.992 1,787 1.528 1,067 1,065 351 2.249 35,130 6,114 10.034 5,133 4.311 1.902 1.991 1,823 1.710 1,490 907 1.115 285 1.986 32,687 6,952 8.776 6544 4.241 1,835 1.848 1,848 1,672 1,493 872 1,490 250 2.033 32,902 8,120 11.668 5,237 1.771 1.749 1.828 1.700 1.442 810 1,085 233 2.513 38.156 2,206 7,802 (388) (481) (164) (650) (484) (1.134) (396) 17) (413) 5.701 (2.124) S 3577 $ 4.97 4.95 $ 1.02 1,072 72 (316) 6,636 (2.263) $4,373 $5.82 5.79 $0.68 (645) 7.157 (2.631) $4,526 $5.68 (413) S 659 $ 0.79 0.78 $0.30 5.63 $ 0.45 Total Common Stock Additional Paid-In Capital Retained Earnings Treasury Accumulated Other Comprehensive Los $310 $8813 $0 345 $ 13,621 $ 2.816 4526 (359) 4526 (359) 36 16 36 76 5 1 18 18 2 2 12.200) (779) (1.421) 10.850 (48) SO 800 12.936 5362 (7.275) $(173) 21 Consolidnted Statements of Stockholders' Equity - USD ($) shares in Millions, $ in Millions Seginning balance at Dec 31, 2014 Beginning bulance (share) Dec 31, 2014 Consolidated Statements of StockholdersEquity (Delicit) Net incom Dividenda declared Other comprehensive income (10) Shares of common stock sued and compensation expense sociated with equity awards (Treasury shares (1) withheld for payment of taxes) Shares of common stock issued and compensation expense associated with equity warda (Treasury shares withheld for payment of taxes) (shares) Stock options cxercised Stock options exercise (shits) Stock purchased and retired Stock purchased and retired (shares) Einding balance at Dec 31, 2015 Ending balance shares) Dec 31, 2015 Consolidated Statements of Stockholders Equity (Delicit) Nchincome Change in accounting principle Dividends declared Other comprehensive come lors) Shares of common stock und and compensation experienciated with equity wund (Treasury shares withheld for payment of taxes) Shares of common slockwood and compensation expense associated with equitywurde (Treasury Whares Wilheld for payment of taxes) (shares) Stock opus cerised Stock oplosser (harca) Treasury Mock,cl,contributed to che qualified clined benelicion plans Treasury Hocknet.contributed to our qualified delinead bereit pomien plan (shares) Stock purchaud reti Slock purchased and lined there Ending line at Dec 31, 2016 Ending Malance (hors) at Dec 31, 2016 Comodated Set of Stockholders'Yquity Datel) Net income Des declared Ocherche income ou Share tocmance and with equity www rury Shures 11 wheld for wyment of Shercom kund compution expected with culty and cury shares 0 w for wyments than Sosed Stockuptions and humu They were defined bereiteten plan Trento de pension plan Chares) Sakkeun 31.011 Els 1.2017 4373 95 (509) (361) ( 65 4,373 95 (509) (361) IOS $(40) 2 1 32 22 3 343 20:41 $ 119 (8) 12.601 (983) (1.618 12287 (60) SO 745 12204 7.203 17616) 5274) 1 3577 (731) 15 68 3577 (731) 15 102 $09) 1 1 28 20 3 30 15 (177 5641 (103) $11910 (13) 50 715 $12.053 59636 501400 51158)