I am stuck. Can you help me find the Times Interest Earned and the Fixed Charge Coverage?
Excel File Edit View Insert Format Tools Data Window Help 77% [4 Wed 6:19 PM Q DE AutoSave ON 3 6 0 - American Airlines FY14-15-HW3 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments V AA ab v Conditional Formatting Insert v Paste B I U V V V A v E Format as Table x Delete v AY. O. Applications 207 v $ ~ % " Cell Styles Format X v Sort & Find & Ideas Sensitivity Filter Select B82 4 X V fx Roller Rides TYCOONS aSTED PLATINUND A B C G IVIons Dec. 51, 2015 Dec. 31, 2014 F H I L M N O Operating revenues: RollerCoaster 53 Mainline passenger $ 29,037 $ 30,802 Tycoon 3 Platinum 54 Regional passenger 6,475 6,322 Cargo 760 875 56 Other 4,718 4,651 X 57 Total operating revenues 40,990 42,650 58 Operating expenses: 59 Aircraft fuel and related taxes 5,226 10,592 Microsoft Excel 60 Salaries, wages and benefits 9,524 8,508 61 Regional expenses 5,983 6,516 Maintenance, materials and repairs 1,889 2,051 63 Other rent and landing fees 1,731 1,727 O 64 Aircraft rent 1,250 1,250 65 Selling expenses 1,394 1,544 66 Depreciation and amortization 1,364 1,295 Microsoft Outlook 67 Special items, net 1,051 800 68 Other 4,374 4,118 69 Total operating expenses 34,786 38,401 70 Operating income 6,204 4,249 P 71 Nonoperating income (expense): 72 Interest income 39 31 73 Interest expense, net of capitalized interest (880) 887) Note: There is no capitalized Interest in this example Microsoft 74 Interest Portion of Lease, net (747) (181) PowerPoint 75 Total nonoperating expense, net (1,588 (1,037 76 Income before reorganization items, net 4,616 3,212 77 Reorganization items, net N 78 Income (loss) before income taxes 4,616 3,212 ax provision (benefit) (2,994) 330 80 Net income (loss) $ 7,610 $ 2,882 Microsoft OneNote 81 82 Times Interest Earned 83 Fixed Charge Coverage 84 Debt Ratio 0.88 .95 W 85 Debt to Equity Ratio 7.59 86 20.39 Debt to Tangible Net Worth 60.68 -9.56 Balance Sheet and Income Stmt + Microsoft Word Ready + 100% MAY 27 itv A