Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I think I have all the data requested. Please help solve this. calculate each ratio for each company for the last three fiscal year-ends. The

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I think I have all the data requested. 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

Consolidated Statement of Cash Flows - USD (S) S in Millions 12 Months Ended Dec. 31, 2016 Dec. 31, 2015 Dec. 31, 2014 CASH FLOWS FROM OPERATING ACTIVITIE S: Net income Adjustments to reconcile net income to cash provided by (used in) operating 3 2,244 5 2.181 5 1.136 Depreciation and amortization Impairment of lntangi ble Assets, Indefinite-lived (Excluding Goodwill Unrealized Gain (Loss) on Derivatives Increase (Decrease) in Deferred Income Taxes Changes in certain assets and liabilities Accounts and other receivables Other assets Accounts payable and accrued iabilities Air traffic liability Cash collateral received from(provided 1.221 1.015 938 113 (109) (200) 279 455 501 (50) (119) 226 125 (88) 103 54 142 328 (233) 26 570) Other, net Net cash provided by operating activites Net cash used in investing activities Capital expenditures Assets constructed for others Purchases of short-term investments Proceeds from sale of short-termn nvestments Other. net Net cash used in investing activities Net cash used in financing activities Proceeds from issuance of long-term debt Proceeds from Employee stock plans (165) 4,293 482) 3.238 2.902 (2,033) (109) (2,383) 2.263 0 (80) (3,080) 3.185 (102) (1,988) 1,913 500 300 Proceeds from termiination of interest rate Payments of long-term debt and capital ease obligations Payments of convertible debt Payments of cash dividends Repayment of construction obligation Repurchase of common stock Other. net Net cash used in financing actvities NET CHANGE IN CASH AND CASH EQUMALENTS CASH AND CASH EQUIVALENTS AT BEGINNING OF PERIOD CASH AND CASH EQUIVALENTS AT END OF PERIOD CASH PAYMENTS FOR: Interest, net of amount capitalized Income taxes SUPPLEMENTAL DISCLOSURE OF NONCASH TRANSACTIONS Flight equipment acquired through the assumption of debt Flight equipment under capital leases Assets constructed for others 561) (139) 955) 1,248 (523) (180) C10) (1,750) (23) 1.024 301 1.282 1 .924 (73) 1.355 1,.282 902 155 153 S 33 307 5 192 Consolidated Statement of Income - 12 Months Ended USD (S) $ in Millions Dec. 31, 2016 Dec. 31, 2015 Dec. 31, 2014 OPERATING REVENUES: Passenger Freight Special revenue adjustment S 18,594 S18,299 S17,658 1,660 20,425 1,170 19,820 18,605 Total operating revenues OPERATING EXPENSES: Salaries, wages, and benefits Fuel and oil Maintenance materials and repairs Aircraft rentals Landing fees and other rentals 6,798 3,647 1,045 5.434 5,293 3,616 1,211 1,221 1,111 1,015 938 Acquisition and integration Other operating expenses Total operating expenses OPERATING INCOME OTHER EXPENSES (INCOME): Interest Expense Interest Costs Capitalized Adjustment Interest income Other (gains) losses, net Total other expenses (income) INCOME BEFORE INCOME TAXES PROVISION FOR INCOME TAXES NET INCOME NET INCOME PER SHARE, BASIC (in dollars per share) NET INCOME PER SHARE, DILUTED (in dollars per share) Cash dividends declared per common share (in dollars per share) 2,514 16,665 3,760 15,704 4,116 16,380 2,225 (47) (24) (31) (23) 1,816 3.547 1,303 S 2,244 S 3.58 3,479 1,298 $2,181 S 3.30 1,136 S 1.65 1.64 $ 0.3750 S0.2850 0.2200 3.55 3.27 Consolidated Balance Sheet - USD (S) Dec. 31, 2015 Dec. 31, 2014 5 in Millions Current aesete Cash and cash equivalents Short-temm investments S 1,583 S 1,282 1,706 365 342 232 3,927 Accounts and other receivables 474 Inventories of parts and supplies, at cost Prepaid expenses and other current assets 188 4.024 Total current assets Property and equipment, at cost: Flight equipment 19,462 3,219 1,089 915 24,685 9.084 15,601 970 18,473 2,853 566 621 22.513 8.221 14.292 970 534 19,723 Ground property and equipment Deposits on flight equipment purchase contracts Assets constructed for others Property and equipment, at cost Less allowance for depreciation and ammortization Property and equipment, net Goodwill Other assets Total assets 21,312 Currcnt liabilitics: Accounts payable Accrued liabilities 1,188 2,591 2,990 637 7.406 2,541 2,490 757 760 1,203 2,897 258 5,923 2,434 2,782 554 1,255 Air traffic liability Current maturities of long-term debt Total current liabilitiee Long-term debt less current maturities Deferred income taxes Construction obligation Other noncurrent liabilities Stockholders' equity: Common stock, S1.00 par walue 2.000,000.000 shares authorized 807,611,634 shares issued in 2015 and 2014 808 808 Capital in excess of par value 1,374 1,315 9.409 (1,051) (3, 182) ,353 7.416 738) (2,026) Accumulated Other Comprehensive Income (Loss)., Net of Tax Treasury stock, at cost 160,010,017 and 132,017,550 shares in 2015 and 2014 res Total stockholders' equity Total liabilities and stockholders' equity S 21,312 S 19.723 Consolidated Balance Sheet USD (S) Dec. 31, 2016 Dec. 31, 2015 $ in Millions Current assets: Cash and cash equivalents Short-term investments S 1,680 1,625 546 337 S 1,583 1,468 474 Accounts and other receivables Inventories of parts and supplies, at cost Prepaid expenses and other current assets 188 4,498 4,024 Total current assets Property and equipment, at cost: Flight equipment Ground property and equipment 20,275 3,779 1,190 1.220 26,464 9,420 17,044 970 3,219 1.089 915 24,685 9,084 15,601 9TO Deposits on flight equipment purchase contracts Assets constructed for others Property and equipment, atcost Less al lowance for depreciation and amortization Property and equipment, net Goodwill Other assets Total assets Current llablllties: 23.286 21,312 1,178 1,985 3.115 566 6,844 2,821 3,374 1,078 728 Accounts payable Accrued liabilities 1,188 2,591 Air traffic liability 637 7,406 2,541 2,490 757 760 Current maturities of long-tem debt Total current liabilities Long-term debt less current maturities Deferred income taxes Construction obligation Other noncurrent liabilities Stockholdders' equity: Common stock, S1.00 par value 2.000,000,000 shares authorized 807.611.634 shares issued in 2016 and 2015 808 808 Capital in excess of par value Retained earnings 1,374 9,409 (1,051) 11,418 Accumulated Other Comprehensive Income (Loss), Net of Tax (323) Treasury stock, at cost 192,450,855 and 160,010,017 shares in 2016 and 2015 re (4,872) (3,182) 8,441 7,358 Total stockholders' equity Total liabilities and stockholders' equity S 23,286 S 21,312

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

Step: 3

blur-text-image

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

Auditing and Assurance services an integrated approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

16th edition

978-0134075754, 134075757, 134065824, 978-0134065823

More Books

Students also viewed these Accounting questions

Question

=+d. Is there another print vehicle you would suggest?

Answered: 1 week ago