Financial Data for Delta Air Lines, Inc | |||||
(amounts in millions, except per-share amounts) | |||||
For Year Ended December 31 | |||||
2013 | 2014 | 2015 | 2016 | 2017 | |
Current Assets | 9651 | 12465 | 9056 | 7451 | 7844 |
Total Assets | 52252 | 54121 | 53134 | 51261 | 53292 |
Common Shares Outstanding | 851.443 | 825.258 | 778.784 | 730.738 | 707.198 |
Long-Term Debt | 9795 | 8561 | 6766 | 6201 | 6592 |
Net Income (loss) before Interest and Taxes | 3802 | 2922 | 7837 | 6952 | 6114 |
Total Liabilities | 40609 | 45308 | 42284 | 38974 | 39382 |
Net Income (Loss) | 10540 | 659 | 4526 | 4373 | 3577 |
Cash Flow Provided by Operations | 4504 | 4947 | 7927 | 7205 | 5148 |
Retained Earnings (deficit) | -2081 | -3855 | 348 | 267 | 2015 |
Sales | 37773 | 40362 | 40704 | 39639 | 41244 |
Shareholers' Equity | 11643 | 8813 | 10850 | 12287 | 13910 |
Interest Expenses | 852 | 650 | 481 | 388 | 396 |
Current Liabilities | 14152 | 16879 | 17526 | 15239 | 18573 |
Market Price Per Share | 27.47 | 49.19 | 50.69 | 49.19 |
56.00 |
Compute the value of each the following risk ratios.
Current ratio (at the end of 2013-2017)
Operating cash flow to current liabilities ratio (for 2013-2017)
Liabilities to assets ratio (at the end of 2013-2017)
Long-term debt to long-term capital ratio (at the end of 2013-2017)
Operating cash flow to total liabilities ratio (for 2013-2017)
Interest coverage ratio (for 2013*2017)
Compute the value of Altman’s Z-score for Delta Air Lines for each year from 2000 to 2004.
Formula | Year | 2013 | 2014 | 2015 | 2016 | 2017 |
Current Assets/Current liabilities | Current ratio | 0.682 | 0.738 | 0.517 | 0.489 | 0.422 |
Operating CF/Current liabilities | 0.318 | 0.293 | 0.452 | 0.473 | 0.277 | |
Total liabilities/Total assets | Liabilities/Assets | 0.777 | 0.837 | 0.796 | 0.760 | 0.739 |
LT debt/(LT debt + Shareholders' equity) | LT debt/LT capital | 0.457 | 0.493 | 0.384 | 0.335 | 0.322 |
Operating CF/Total liabilities | 0.111 | 0.109 | 0.187 | 0.185 | 0.131 | |
Interest expense/Net income before interest & tax | Interest coverage ratio | 0.224 | 0.222 | 0.061 | 0.056 | 0.065 |
Altman's Z-score:
where
A = Working capital/Total assets
B = Retained earnings/Total assets
C = EBIT/Total assets
D = Market value of equity/Book value of Total liabilities
E = Sales/Total assets
Formula | Year | 2013 | 2014 | 2015 | 2016 | 2017 |
Current assets - current liabilities | Working capital | -4,501.00 | -4,414.00 | -8,470.00 | -7,788.00 | -10,729.00 |
Working capital/Total assets (A) | -0.086 | -0.082 | -0.159 | -0.152 | -0.201 | |
Retained earnings/Total assets (B) | -0.040 | -0.071 | 0.007 | 0.005 | 0.038 | |
Net income before interest & expenses/Total assets | EBIT/Total assets ('C) | 0.073 | 0.054 | 0.147 | 0.136 | 0.115 |
Share price*number of shares | Market value of equity | 23,389.14 | 40,594.44 | 39,476.56 | 35,945.00 | 39,603.09 |
Market value of equity/Book value of total liabilities (D) | 0.576 | 0.896 | 0.934 | 0.922 | 1.006 | |
Sales/Total assets ('E) | 0.723 | 0.746 | 0.766 | 0.773 | 0.774 | |
1.2A + 1.4B + 3.3C + 0.6D + 1.0E | Altman's Z-score | 1.149 | 1.264 | 1.631 | 1.599 | 1.567 |
Financial Data for Delta Air Lines, Inc (amounts in millions, except per-share amounts) For Year Ended...
Please help Using three years’ of ratios and information about Delta company, describe in a 2-3 page paper whether your company’s performance or position has improved over the three-year period or has grown worse. Your explanation should refer to the patterns in the ratios as well as to changes in the financial statement items that are part of the ratio. Your analysis will draw from the ratios, the financial statements, management’s discussion in the annual report and other sources as...
The financial statements for Delta Industries for the year ended December 31st, 2018 are as follows: Delta Industries Statement of Income For the years ended December 31, 2018 and 2017 2018 2017 Sales revenue $351,500 $310,000 Cost of goods sold 201,000 155,000 Gross margin 150,500 155,000 Operating expenses: 65,000 71,000 Operating income 85,500 84,000 Interest expense 26,000 20,000 Income before income tax 59,500 64,000 Income tax expense 19,000 22,500 Operating income $40,500 $41,500 Delta Industries Statement of Financial Position December...
Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 ($ in millions, except per share amounts) Assets December December 31, 2007 31, 2006 Vertical Common Size for 2007 Horizontal Common St $ 1,205 2,588 548 4,028 $ 748 3,041 449 3,338 409 7,985 712 9,081 Current Assets Cash and cash equivalents Short-term investments Receivables Merchandise inventories Other current assets Total current assets Property and Equipment Land and buildings Leasehold improvements Fixtures and equipment Property under capital lease Total Property and equipment...
Burch Industries Consolidated Income Statements (in thousands, except per share data) Year ended December 31, 2019 2017 2018 $3,405,211 Revenues $3,930,984 $3,003,610 Costs and expenses: Cost of goods sold Selling and administrative $2,386,993 $2,089,089 $1,850,530 922,261 761,498 30,665 Interest 25,739 664,061 27,316 (43) Other expenses (income) 1,475 2,141 Total costs and expenses $3,336,468 $2,883,393 $2,541,864 Income before income taxes $594,516 $521,818 $461,746 Income taxes 229,500 192,600 174,700 Net income $365,016 $329,218 $287,046 Burch Industries Consolidated Balance Sheets (in thousands) December...
Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 (S in millions, except per share amounts) December Assets December 31, 2007 Vertical Common Size for 2007 Horizont Common 31, 2006 $1,205 2,588 548 4,028 712 9,081 $ 748 3,041 449 3,338 409 7,985 Current Assets Cash and cash equivalents Short-term investments Receivables Merchandise inventories Other current assets Total current assets Property and Equipment Land and buildings Leasehold improvements Fixtures and equipment Property under capital lease Total Property and equipment Less accumulated...
Lowe's Companies, Inc. Consolidated Statements of Earnings (In millions, except per share and percentage data) February 1, 0 Sales February 2, 20197 Sales 2018 $ 71,309 100.00% $ 68,619 48,40167.88 46,185 22,908 32.12 22,434 0% Sales February % Sales 100.00% $ 65,017 67.31 43,343 32.69 21,674 % Sales 100.00% 66.66 33.34 Fiscal years ended on Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt...
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 in millions, except per share data Assets Current assets: Cash and cash equivalents 1,778 $ 3,595 Receivables, net 1,936 1,952 Merchandise inventories 13,925 12,748 Other current assets 890 638 Total current assets 18,529 18,933 22,375 Net property and equipment 22,075 Goodwill 2,252 2,275 Other assets 847 1,246 Total assets 44,003 44,529 Liabilities and Stockholders' Equity Current liabilities: 1,339 $ Short-term debt $ 1,559 Accounts payable Accrued salaries...
COSTCO WHOLESALE CORPORATION CONSOLIDATED BALANCE SHEETS (amounts in millions, except par value and share data) September 2, September 3, 2017 2018 $ ASSETS CURRENT ASSETS Cash and cash equivalents .... Short-term investments .... Receivables, net. Merchandise inventories ..... Other current assets ...... Total current assets .... PROPERTY AND EQUIPMENT 6.055 1,204 1,669 11.040 321 20.289 4,546 1,233 1.432 9.834 272 17,317 Land Buildings and improvements. Equipment and futures Construction in progress 6,193 16.107 7.274 1.140 30.714 (11.033) 19,681 5,690 15,127...
Use Wal-Mart's financial statements to compute the following ratios (20-31) for the year ended January 31, 2013. 20. Current ratio А. 83 В. .97 C 65 D. 50 21. Acid-test (quick) ratio A. .10 В. .15 С. 20 D. 25 22. Accounts receivable turnover A. 65.10 times B. 69.90 times C. 73.85 times D. 78.93 times 23. Inventory turnover A. 5.45 times B. 6.87 times C. 7.16 times D. 8.34 times 24. Profit margin A. 2.75% B. 3.62% C. 4.18%...