Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedThis 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 Share

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Night Audit Shenanigans With Winston No Longer Working At The Hotel Luna Is Dealing Without Days Off

Authors: Kentucky Elayne NightHawk

1st Edition

B0BYLVMSV7, 979-8361945702

More Books

Students also viewed these Accounting questions

Question

Discuss how staffi ng needs are determined.

Answered: 1 week ago

Question

13. Identify the refusal of the return in Dances with Wolves.

Answered: 1 week ago