Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is another Data for Delta Airlines Please help solve this. calculate each ratio for each company for the last three fiscal year-ends. The ratios:
This is another Data for Delta Airlines Please help solve this. calculate each ratio for each company for the last three fiscal year-ends. The ratios: Accounts Receivable Turnover; Average Collection Period for A/R; Current Ratio; Debt to Equity Ratio; Inventory turnover; Average Inventory days outstanding; Return on Assets; Return on Equity; Return on Investment; Return on Net Operating Assets; Profit Margin; Asset Turnover
Consolidlated Balanee Sheets- Dec. 31, 2016 Dec. 31, 2015 Current Assets: Cash and cash equivalents Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $15 and $9 at December 31, 2018 and 2015, respectivey Fuel inventory Expendable parts and supplies inventories, net of an allowance for obsolescence of S110 and $114 at December 31, 2018 and 2015, 2,782 2,020 Hedge derivative asset Prepaid expenses and other Total current assets 1,987 9,056 Property and Equipment, Net: Property and equipment, net of amortization of $12,458 and $10,871 at December 31, 2018 and 2015, 24,375 23,039 Other Assets: 9,794 9,794 accumulated amortization of $828 and 5811 at December 31, 2018 and 2015, 4,844 4,881 4,956 1,428 21,039 53,134 Deferred income taxes, net Other noncurrent assets Total other assets Total assets Current Liabilities: Current maturities of long-term debt and capital leases Air traffic liability 1,733 19,435 51,281 1,563 4,503 2,743 3,195 2,581 1,835 1,308 17,528 4,828 2,572 Accrued salaries and related benefits Hedge derivative liability Frequent flyer deferred revenue Other accrued liabilities Total current liabilities 1,848 1,850 15,239 8,788 13,855 2,248 1,891 24,758 Long-term debt and capital leases Pension, postretirement and related benefits 8,201 13,378 2,278 1,878 23,735 Frequent flyer deferred revenue Other noncurrent liabilities Total noncurrent liabilities Stockholders Equity: Common stock at $0.0001 par value; 1,500,000,000 shares authorized, 744,888,938 and 799,850,875 shares issued at December 31, 2018 and 2015, respectively Additional paid-in capital Retained earnings (7,838) Treasury stock, at cost, 14,149,223 and 21,088,884 shares at December 31, 2018 and 2015, respectively Total stockholders' equity Total liabilities and stockholders (274) 10,850 551,28$53,134 Consolidlated Balanee Sheets- USD (S) Dec. 31, 2017 Dec. 31, 2016 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 2018, respectivey Fuel inventory Expendable parts and supplies inventories, net of an allowance for obsolescence of S113 and $110 at December 31, 2017 and 2018, 5 2,782 487 825 2,377 2,084 372 Prepaid expenses and other Total current assets 1,499 7,844 1,247 7,451 Property and Equipment, Net: Property and equipment, net of amortization of $14,097 and $12,456 at December 31, 2017 and 2018 28,583 24,375 Other Assets: Goodwill 9,794 Identifiable intangibles, net of accumulated amortization of $845 and 4,847 4,844 5828 at December 31, 2017 and 2018, Deferred income taxes, net Other noncurrent assets Total other assets Total assets Current Liabilities: 3,309 18,885 53,232 1,733 19,435 51,281 Current maturities of long-term debt and capital leases Ar traffic liability Accounts Accrued salaries and related benefits 2,242 4,888 4,828 2,572 2,924 1,848 payable 3,022 Frequent flyer deferred revenue Fuel card obligation Other accrued liabilities Total current liabilities 1,067 1,858 18,573 1,907 15,239 Long-term debt and capital leases Pension, postretirement and related benefits Frequent flyer deferred revenue Other noncurrent liabilities Total noncurrent liabilities ,592 ,201 13,378 2,236 2,111 20,809 2,278 1,878 23,735 Stockholders Equity: Common stock at $0.0001 par value; 1,500,000,000 shares authorized, 714,874,180 and 744,888,938 shares issued at December 31, 2017 and 2018, respectively Additional paid-in capital Retained earnings 2,053 9,838 7,903 (7,838) (274) 2,287 53,292 51,281 loss Treasury stock, at cost, 7,478,181 and 14,149,229 shares at December 31, 2017 and 2018, respectively Total stockholders equity Total liabilities and stockholders equity (158) 13,910 12 Months Ended Cash Flows- USD (S) S in Millions Dec. 31, 2017 Dec. 31, 2016 Dec. 31, 2015 5 4,373 4,528 Adjustments to reconcile net Hedge derivative contracts (1,388) postemployment payments greater Equity investment earnings Changes in certain assets and Prepaid expenses and other current Frequent flyer deferred revenue operating Flight equipment, including advance (2,223) equipment, Purchase of equity investments Purchase of short-term investments Net cash used in investing activities Cash Flows From Financing (5,388) Payments on long-term debt and (1,709) stock Cash dividends Payments on hedge derivative Proceeds from hedge derivative activities (4,280) (4 Net (Decrease) Increase in Cash and Equiv Cash and cash equivalents at end of Supplemental Disclosure of Cash reasury stock contributed to our 12 Months Ended Comprehensive Income-USD Dec. 31, 2017 Dec. 31, 2016 Dec. 31, 2015 $ in Millions Statement of Comprehensive Income [Abstract] Net Income Other comprehensive income (loss): Net change in derivative contracts Net change in pension and other benefits Net change in investments Total Other Comprehensive Income (Loss) Comprehensive Income 3,577 5 4,373 5 4,528 (27) (38) 140 15 5 3,592 (43) (380) 42 (381) 4,012 (82) 183 (45) 38 5 4,582 12 Months Ended Operations- USD (S) S in Millions Dec. 31, 2017 Dec. 31, 2016 Dec. 31, 2015 Passenger: Salaries and related costs Aircraft fuel and related taxes expens Aircraft maintenance materials and Passenger commissions and other rents (2,283) $4,3734,528 3,577 re (usd per Cash Dividends Declared Per ShareStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started