Answer To: Assignment 1 Due Monday, February 15 at 7:00pm Please submit on D2L/Dropbox This is a group project....
Nitish Lath answered on Mar 27 2021
IS Vertical
Financial Statements
DELTA AIR LINES, INC.
Consolidated Statements of Operations
Year Ended December 31, Vertical Analysis
(in millions, except per share data) 2020 2019 2018 2017 2016 2020 2019 2018 2017 2016
Operating Revenue:
Passenger $ 12,883 $ 42,277 $ 39,755 34,819 33,777 75% 90% 89% 84% 85%
Cargo 608 753 865 729 668 4% 2% 2% 2% 2%
Other 3,604 3,977 3,818 5,696 5,194 21% 8% 9% 14% 13%
Total operating revenue 17,095 47,007 44,438 41,244 39,639 100% 100% 100% 100% 100%
Operating Expense:
Salaries and related costs 8,754 11,225 10,743 10,436 10,034 51% 24% 24% 25% 25%
Aircraft fuel and related taxes 3,176 8,519 9,020 5,733 5,133 19% 18% 20% 14% 13%
Regional carriers expense, excluding fuel 2,479 3,584 3,438 4,503 4,311 15% 8% 8% 11% 11%
Depreciation and amortization 2,312 2,581 2,329 2,235 1,902 14% 5% 5% 5% 5%
Ancillary businesses and refinery 1,785 1,245 1,695 10% 3% 4% 0% 0%
Contracted services 1,778 2,641 2,175 2,184 1,991 10% 6% 5% 5% 5%
Landing fees and other rents 1,518 1,762 1,662 1,528 1,490 9% 4% 4% 4% 4%
Aircraft maintenance materials and outside repairs 822 1,751 1,575 1,992 1,823 5% 4% 4% 5% 5%
Passenger commissions and other selling expenses 582 1,993 1,941 1,787 1,710 3% 4% 4% 4% 4%
Passenger service 523 1,251 1,178 1,067 907 3% 3% 3% 3% 2%
Aircraft rent 399 423 394 351 285 2% 1% 1% 1% 1%
Restructuring charges 8,219 - 0 - 0 48% 0% 0% 0% 0%
Government grant recognition (3,946) - 0 - 0 -23% 0% 0% 0% 0%
Profit sharing - 0 1,643 1,301 1,065 1,115 0% 3% 3% 3% 3%
Other 1,163 1,771 1,723 2,249 1,986 7% 4% 4% 5% 5%
Total operating expense 29,564 40,389 39,174 35,130 32,687 173% 86% 88% 85% 82%
Operating (Loss)/Income (12,469) 6,618 5,264 6,114 6,952 -73% 14% 12% 15% 18%
Non-Operating Expense:
Interest expense, net (929) (301) (311) (396) (388) -5% -1% -1% -1% -1%
Impairments and equity method losses (2,432) (62) (60) -14% -0% -0% 0% 0%
Gain/(loss) on investments, net (105) 119 38 -1% 0% 0% 0% 0%
Miscellaneous, net 348 (176) 220 (17) 72 2% -0% 0% -0% 0%
Total non-operating expense, net (3,118) (420) (113) (413) (316) -18% -1% -0% -1% -1%
(Loss)/Income Before Income Taxes (15,587) 6,198 5,151 5,701 6,636 -91% 13% 12% 14% 17%
Income Tax Benefit/(Provision) 3,202 (1,431) (1,216) (2,124) (2,263) 19% -3% -3% -5% -6%
Net (Loss)/Income $ (12,385) $ 4,767 $ 3,935 $ 3,577 $ 4,373 -72% 10% 9% 9% 11%
IS Horizontal
Financial Statements
DELTA AIR LINES, INC.
Consolidated Statements of Operations
Year Ended December 31, Horizontal Analaysis
(in millions, except per share data) 2020 2019 2018 2017 2016 2015 2020 2019 2018 2017 2016
Operating Revenue:
Passenger $ 12,883 $ 42,277 $ 39,755 34,819 33,777 34,782 -70% 6% 14% 3% -3%
Cargo 608 753 865 729 668 813 -19% -13% 19% 9% -18%
Other 3,604 3,977 3,818 5,696 5,194 5,109 -9% 4% -33% 10% 2%
Total operating revenue 17,095 47,007 44,438 41,244 39,639 40,704 -64% 6% 8% 4% -3%
Operating Expense:
Salaries and related costs 8,754 11,225 10,743 10,436 10,034 8,776 -22% 4% 3% 4% 14%
Aircraft fuel and related taxes 3,176 8,519 9,020 5,733 5,133 6,544 -63% -6% 57% 12% -22%
Regional carriers expense, excluding fuel 2,479 3,584 3,438 4,503 4,311 4,241 -31% 4% -24% 4% 2%
Depreciation and amortization 2,312 2,581 2,329 2,235 1,902 1,835 -10% 11% 4% 18% 4%
Ancillary businesses and refinery 1,785 1,245 1,695 43% -27%
Contracted services 1,778 2,641 2,175 2,184 1,991 1,848 -33% 21% -0% 10% 8%
Landing fees and other...