• Two competitors:American Airlines,United Airlines
• The fifth tab in your Financial Statement Analysis Template must be labeled Competitor Income Statements
  • Include the latest Income statement for the company selected for the Excel project along with two or three major competitors.
• The sixth tab in your Financial Statement Analysis Template must be labeled Competitor Balance Sheets
  • Include the latest Balance Sheet for the company selected for the Excel project along with two or three major competitors.
• The Seventh tab in your Financial Statement Analysis Template must be labeled Competitor and Industry Ratio Comparison
  • IncludetheratiosforthelatestyearforthecompanyselectedfortheExcelprojectalongwiththeratiosfortwoorthreemajorcompetitorsandtheindustryaverages.
    • Liquidity Ratios
    • Current Ratio
    • Quick Ratio
    • Leverage Ratios
    • Debt to Total Assets Ratio
    • Debt Equity Ratio
    • Long-Term Debt to Equity
    • Times Interest Earned Ratio
    • Activity Ratios
    • Inventory Turnover
    • Fixed Assets Turnover
    • Total Assets Turnover
    • Accounts Receivable Turnover
    • Average Collection Period
    • Profitability Ratios
    • Gross Profit Margin
    • Operating Profit Margin
    • Net Profit Margin
    • Return on Total Assets (ROA)
    • Return on Stockholders Equity (ROE)
    • Earnings Per Share (EPS)
    • Price Earnings Ratio

Company name Tinker symbol Industy Services Major competitors DELTA AIR LINES, INC. DAL Major Airline Air transportation American Airlines,United Airlines,Alaska Airlines, JetBlue Airways and Southwest Airlines DELTA AIR LINES, INC. Consolidated income statements (in millions, except per share data) Operating Revenue: Passenger: Mainline Regional carriers Total passenger revenue Cargo Other Total operating revenue Year Ended December 31, 2015 2014 2013 $ 28,898 $ 28,688 $ 26,534 5,884 6,266 6,408 34,782 34,954 32,942 813 934 937 5,109 4,474 3,894 40,704 40,362 37,773 Operating Expense: Salaries and related costs 8,776 Aircraft fuel and related taxes 6,544 Regional carriers expense 4,241 Aircraft maintenance materials and outsid 1,848 Contracted services 1,848 Depreciation and amortization 1,835 Passenger commissions and other selling 1,672 Landing fees and other rents 1,493 Profit sharing 1,490 Passenger service 872 Aircraft rent 250 Restructuring and other 35 Other 1,998 Total operating expense 32,902 Operating Income Non-Operating Expense: Interest expense, net Miscellaneous, net Total non-operating expense, net Income Before Income Taxes Income Tax (Provision) Benefit 8,120 11,668 5,237 1,828 1,749 1,771 1,700 1,442 1,085 810 233 716 1,797 38,156 7,720 9,397 5,669 1,852 1,665 1,658 1,603 1,410 506 762 209 402 1,520 34,373 7,802 2,206 3,400 (481) (164) (645) (650) (484) (1,134) (852) (21) (873) 7,157 1,072 2,527 (2,631) (413) 8,013 Net Income $ 4,526 $ 659 $ 10,540 Basic Earnings Per Share Diluted Earnings Per Share Cash Dividends Declared Per Share $ $ $ 0.79 $ 12.41 0.78 $ 12.29 0.30 $ 0.12 5.68 $ 5.63 $ 0.45 $ DELTA AIR LINES, INC. Consolidated Balance Sheets (in millions, except share data) ASSETS Current Assets: Cash and cash equivalents Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $9 and $11 at December 31, 2015 and 2014, respectively Hedge margin receivable Fuel inventory Expendable parts and supplies inventories, net of an allowance for obsolescence of $114 and $127 at December 31, 2015 and 2014, respectively Hedge derivatives asset Prepaid expenses and other Total current assets Property and Equipment, Net: Property and equipment, net of accumulated depreciation and amortization of $10,871 and $9,340 at December 31, 2015 and 2014, respectively Other Assets: Goodwill Identifiable intangibles, net of accumulated amortization of $811 and $793 at December 31, 2015 and 2014, respectively Deferred income taxes, net Other noncurrent assets Total other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Current maturities of long-term debt and capital leases Air traffic liability Accounts payable Accrued salaries and related benefits Hedge derivatives liability Frequent flyer deferred revenue Other accrued liabilities Total current liabilities December 31, 2015 2014 2013 $1,972 1,465 $2,088 1,217 $2,844 959 2,020 119 379 2,297 925 534 1,609 3 706 318 1,987 796 9,056 318 1,078 701 9,158 357 585 1,736 852 9,651 23,039 21,929 21,854 9,794 9,794 9,794 4,861 4,603 4,658 4,956 7,595 4,992 1,428 926 1,303 21,039 22,918 20,747 $53,134 $54,005 $52,252 $1,563 4,503 2,743 3,195 2,581 1,635 1,306 17,526 $1,184 4,296 2,622 2,266 2,772 1,580 2,127 16,847 $1,547 4,122 2,300 1,926 146 1,861 2,250 14,152 Noncurrent Liabilities: Long-term debt and capital leases Pension, postretirement and related benefits Frequent flyer deferred revenue Other noncurrent liabilities Total noncurrent liabilities 6,766 13,855 2,246 1,891 24,758 8,477 15,138 2,602 2,128 28,345 9,795 12,392 2,559 1,711 26,457 Commitments and Contingencies Stockholders' Equity: Common stock at $0.0001 par value; 1,500,000,000 shares authorized, 799,850,675 and 845,048,310 shares issued at December 31, 2015 and 2014, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 21,066,684 and 19,790,077 shares at December 31, 2015 and 2014, respectively Total stockholders' equity Total liabilities and stockholders' equity 10,875 7,623 -7,275 12,981 3,456 -7,311 13,982 3,049 -5,130 -373 -313 -258 10,850 8,813 11,643 $53,134 $54,005 $52,252 2012 (Those amount of 2012 which are required to calculate average amount of 2013) 1,693 20,713 44,550 - -2,131 Formula used to calculate Ratios 1 Current Ratio = Current Assets / Current Liabilities 2 Quick Ratio = Liquid Assets / Current Liabilities 3 Debt to Total Assets Ratio = Total Liabilities / Total Assets 4 Debt Equity Ratio = Total Liabilities / Total Equity 5 Long Term Debt to Equity = Long term debt / Total Equity 6 Times Interest Earned Ratio = EBIT / Interest Expenses 7 Inventory Turnover = Cost of Goods sold / Average Inventory 8 Fixed Assets Turnover = Revenue / Average Fixed Assets 9 Total Assets Turnover = Revenue / Average total assets 10 Accounts Receivable Turnover = Revenue / Average receivables 11 Average collection period = 365 / Account Receivable Turnover 12 Gross Profit Margin = Gross Profit / Revenue 13 Operating Profit Margin = Operating Profit / Revenue 14 Net Profit Margin = Net Profit / Revenue 15 Return on Total Assets = Net Profit / Average Total Assets 16 Return on Stcokholders' Equity = Net Profit / Average Stockholders' equity 17 Earnings Per Share = Net Income / Total shares outstanding 18 Price Earnings Ratio = Market Price per share / Earnings per share S. No. 2015 2014 2013 1 Name of Ratio Liquidity Ratio Current Ratio 0.52 0.54 0.06 2 Quick Ratio = 0.31 0.33 0.38 3 Leverage Ratio Debt to Total Assets Ratio = 0.80 0.84 0.78 4 Debt Equity Ratio = 3.90 5.13 3.49 5 Long Term Debt to Equity = 2.28 3.22 2.27 6 Times Interest Earned Ratio = 16.22 3.39 3.99 7 Activity Ratio Inventory Turnover = 8 Fixed Assets Turnover = 1.81 1.84 1.77 9 Total Assets Turnover = 0.76 0.76 0.78 10 Accounts Receivable Turnover = 18.86 20.67 22.88 11 Average collection period = 19.36 17.66 15.95 12 Profitability Ratio Gross Profit Margin = 13 Operating Profit Margin = 19.17% 5.47% 9.00% 14 Net Profit Margin = 11.12% 1.63% 27.90% 15 Return on Total Assets = 8.45% 1.24% 21.78% 16 Return on Stcokholders' Equity = 17 Earnings Per Share = 18 Price Earnings Ratio = N.A. N.A. N.A. N.A. 46.04% $ Company belongs to service sector so th N.A. Company belongs to service sector so th N.A. 6.44% 221.61% 5.68 $ 0.79 $ 12.41 8.92 62.27 2.21 Closing Price of Stock: belongs to service sector so there is no cost of goods sold and inventory. belongs to service sector so there is no cost of goods sold and gross profit margin cannot be calculated. ice of Stock: Dec 31 2015 Dec 31 2014 Dec 31 2013 $50.69 $49.19 $27.47