Can you help me find the Times Interest Earned and the Fixed Charge Coverage?
Excel File Edit View Insert Format Tools Data Window Help $ 79% [4. Wed 6:22 PM Q DE AutoSave ON 1 8 6 - 5 7 3Delta Airlines FY14-15-HW3(1) - Saved Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Commen A A ab Wrap Text Insert v paste BI U V V V A v Merge & Center $ ~ % " x Delete Conditional Format Cell Sort & Find & Formatting as Table Styles Format v XV Ideas Sensitivity Filter Select B8 C86 X V fx A B 49 Passenger: C F G H K L M N O P 52 50 Mainline $ 28,898 $ 28,688 53 51 Regional carriers 5 ,884 6,266 54 52 Total passenger revenue 34,782 $4,954 55 53 Cargo 813 934 56 54 Other 5 ,109 4,474 57 55 Total operating revenue 40,704 40,362 58 56 Operating Expense: 59 57 Salaries and related costs 8,776 8,120 60 58 Aircraft fuel and related taxes 6,544 11,668 61 59 Regional carriers expense 4,241 5,237 62 60 Aircraft maintenance materials and outside repairs 1,848 1 ,828 63 61 Contracted services 1,848 1,749 64 62 Depreciation and amortization 1,835 1,771 65 63 Passenger commissions and other selling expenses 1,672 1,700 66 64 Landing fees and other rents 1,493 1,442 67 65 Profit sharing 1,490 1,085 68 66 Passenger service 872 310 69 67 Aircraft rent 250 233 70 68 Restructuring and other 35 71 71 69 Other 1,998 1,797 72 70 Total operating expense 32,902 73 71 Operating Income 7,802 2,206 74 72 Non-Operating Expense: Note: There is no capitalized Interest in this example 75 73 Interest expense, net (481 ) (650 76 74 Interest Portion of Lease, net (164) (484) 77 75 Total non-operating expense, net (645) (1,134) 78 76 Income Before Income Taxes 7,15 1,072 79 77 Income Tax (Provision) Benefit (2,631) (413) 80 78 Net Income $ 4,526 $ 659 81 79 82 80 83 81 Times Interest Earned 84 82 Fixed Charge Coverage 85 83 Debt Ratio 0.80 0.84 86 84 Debt to Equity Ratio 3.90 5.13 or nahtto Tammibla Mlat Walnuth Balance Sheet Horizontal Ready + 100 9 MAY 27 3 ... 2 4