How to calculate Time Interest Earned, Fixed Charge Coverage, Debt Ratio, Debt to Equity Ratio and Debt to Tangible New worth based on the excel information provided.

Consolidated Balance Sheets - USD ($) $ in Millions Current assets Cash Short-term investments Restricted cash and short-term investments Accounts receivable, net Aircraft fuel, spare parts and supplies, net Prepaid expenses and other Total current assets Operating property and equipment Flight equipment Ground property and equipment Equipment purchase deposits Total property and equipment, at cost Less accumulated depreciation and amortization Total property and equipment, net Other assets Goodwill Intangibles, net of accumulated amortization Deferred tax asset Other assets Total other assets Total assets Current liabilities Current maturities of long-term debt and capital leases Accounts payable Accrued salaries and wages Air traffic liability Loyalty program liability Other accrued liabilities Total current liabilities Noncurrent liabilities Long-term debt and capital leases, net of current maturities Pension and postretirement benefits Deferred gains and credits, net Bankruptcy settlement obligations Other liabilities Total noncurrent liabilities Commitments and contingencies Stockholders' equity Common stock Additional paid-in capital Dec. 31, 2015 Dec. 31, 2014 $ 390 5,864 695 1,425 863 748 9,985 $ 994 6,309 774 1,771 1,004 898 11,750 33,185 6,402 1,067 40,654 (13,144) 27,510 28,213 5,900 1,230 35,343 (12,259) 23,084 4,091 2,249 2,477 2,103 10,920 48,415 4,091 2,240 0 2,060 8,391 43,225 2,231 1,563 1,205 3,747 2,525 2,334 13,605 1,677 1,377 1,194 4,252 2,807 2,097 13,404 18,330 7,450 667 193 2,535 $ 29,175 16,043 7,562 829 325 3,041 $ 27,800 $6 11,591 $7 15,135 Accumulated other comprehensive loss Accumulated deficit Total stockholders' equity Total liabilities and stockholders' equity American Airlines, Inc. [Member] (4,732) (1,230) 5,635 48,415 Consolidated Statements of Operations - USD ($) shares in Thousands, $ in Millions Operating revenues: Mainline passenger Regional passenger Cargo Other Total operating revenues Operating expenses: Aircraft fuel and related taxes Salaries, wages and benefits Regional expenses Maintenance, materials and repairs Other rent and landing fees Aircraft rent Selling expenses Depreciation and amortization Special items, net Other Total operating expenses Operating income Nonoperating income (expense): Interest income Interest expense, net of capitalized interest Interest Portion of Lease, net Total nonoperating expense, net Income before reorganization items, net Reorganization items, net Income (loss) before income taxes Income tax provision (benefit) Net income (loss) Times Interest Earned Fixed Charge Coverage Debt Ratio Debt to Equity Ratio Debt to Tangible Net Worth (4,559) (8,562) 2,021 43,225 12 Months Ended Dec. 31, 2015 Dec. 31, 2014 $ 29,037 6,475 760 4,718 40,990 $ 30,802 6,322 875 4,651 42,650 6,226 9,524 5,983 1,889 1,731 1,250 1,394 1,364 1,051 4,374 34,786 6,204 10,592 8,508 6,516 2,051 1,727 1,250 1,544 1,295 800 4,118 38,401 4,249 39 (880) (747) (1,588) 4,616 31 (887) (181) (1,037) 3,212 4,616 (2,994) $ 7,610 3,212 330 $ 2,882 Total Score 0.00% Note: There is no capitalized Interest in this example 0 0 0 0 0 0 0 0 0 0