Please assist with Times Interest Earned, fixed charge coverage and Debt to Tangible net worth. Please show how to enter the formulas into the cells to get the correct answers. Here is a note from the instructor if this helps. "Two things that you need to pay attention to. First, you need to subtract the cells in the time interest earned and fixed coverage both before and after the division sign. You should not have a negative number in the cell value. Second, you need to understand what items constitute intangibles there are two on the sheet."

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 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets 3 Cash 4 Short-term investments 5 Restricted cash and short-term investments 6 Accounts receivable, net 7 Aircraft fuel, spare parts and supplies, net 8 Prepaid expenses and other 9 Total current assets | 10 Operating property and equipment 11 Flight equipment 12 Ground property and equipment 513 Equipment purchase deposits 14 Total property and equipment, at cost 15 Less accumulated depreciation and amortization 16 Total property and equipment, net 17 Other assets 18 Goodwill 19 Intangibles, net of accumulated amortization 20 Deferred tax asset 21 Other assets 22 Total other assets 23 Total assets Balance Sheet and Income Stmt + 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,240 4,091 2,249 2,477 2,103 10,920 48,415 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 25 Current liabilities 26 Current maturities of long-term debt and capital leases 27 Accounts payable 28 Accrued salaries and wages 29 Air traffic liability 30 Loyalty program liability 31 Other accrued liabilities 32 Total current liabilities 33 Noncurrent liabilities 34 Long-term debt and capital leases, net of current maturities 35 Pension and postretirement benefits 36 Deferred gains and credits, net 37 Bankruptcy settlement obligations 38 Other liabilities 39 Total noncurrent liabilities 40 Commitments and contingencies 41 Stockholders' equity 42 Common stock 43 Additional paid-in capital 44 Accumulated other comprehensive loss 45 Accumulated deficit 46 Total stockholders' equity 47 Total liabilities and stockholders' equity 18,330 7,450 667 16,043 7,562 829 325 3,041 $ 27,800 193 2,535 $ 29,175 $ 6 11,591 (4,732) (1,230) 5,635 48,415 $ 7 15,135 (4,559) (8,562) 2,021 43,225 C 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 10,592 8,508 6,516 50 Consolidated Statements of Operations - USD ($) shares in Thousands, 51 $ in Millions 52 Operating revenues: 53 Mainline passenger 54 Regional passenger 55 Cargo 56 Other 57 Total operating revenues 58 Operating expenses: 59 Aircraft fuel and related taxes 60 Salaries, wages and benefits 61 Regional expenses 62 Maintenance, materials and repairs 63 Other rent and landing fees 64 Aircraft rent 65 Selling expenses 66 Depreciation and amortization 67 Special items, net 68 Other 69 Total operating expenses 70 Operating income 71 Nonoperating income (expense): 72 Interest income Balance Sheet and Income Stmt 6,226 9,524 5,983 1,889 1,731 1,250 1,394 1,364 1,051 4,374 34,786 6,204 2,051 1,727 1,250 1,544 1,295 800 4,118 38,401 4,249 39 31 4,374 34,786 6,204 4,118 38,401 4,249 68 Other 69 Total operating expenses 70 Operating income 71 Nonoperating income (expense): 72 Interest income 73 Interest expense, net of capitalized interest 74 Interest Portion of Lease, net 75 Total nonoperating expense, net 76 Income before reorganization items, net 77 Reorganization items, net 78 Income (loss) before income taxes 79 Income tax provision (benefit) 80 Net income (loss) 39 (880) (747) (1,588) 4,616 31 (887) Note: There is no capitalized Inter (181) (1,037) 3,212 4,616 (2,994) $7,610 3,212 330 $ 2,882 Times Interest Earned Fixed Charge Coverage Debt Ratio Debt to Equity Ratio Debt to Tangible Net Worth -5.251 -2.38 0.88 7.59 12.63 Total Score 0.95 20.39 40.00% 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 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets 3 Cash 4 Short-term investments 5 Restricted cash and short-term investments 6 Accounts receivable, net 7 Aircraft fuel, spare parts and supplies, net 8 Prepaid expenses and other 9 Total current assets | 10 Operating property and equipment 11 Flight equipment 12 Ground property and equipment 513 Equipment purchase deposits 14 Total property and equipment, at cost 15 Less accumulated depreciation and amortization 16 Total property and equipment, net 17 Other assets 18 Goodwill 19 Intangibles, net of accumulated amortization 20 Deferred tax asset 21 Other assets 22 Total other assets 23 Total assets Balance Sheet and Income Stmt + 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,240 4,091 2,249 2,477 2,103 10,920 48,415 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 25 Current liabilities 26 Current maturities of long-term debt and capital leases 27 Accounts payable 28 Accrued salaries and wages 29 Air traffic liability 30 Loyalty program liability 31 Other accrued liabilities 32 Total current liabilities 33 Noncurrent liabilities 34 Long-term debt and capital leases, net of current maturities 35 Pension and postretirement benefits 36 Deferred gains and credits, net 37 Bankruptcy settlement obligations 38 Other liabilities 39 Total noncurrent liabilities 40 Commitments and contingencies 41 Stockholders' equity 42 Common stock 43 Additional paid-in capital 44 Accumulated other comprehensive loss 45 Accumulated deficit 46 Total stockholders' equity 47 Total liabilities and stockholders' equity 18,330 7,450 667 16,043 7,562 829 325 3,041 $ 27,800 193 2,535 $ 29,175 $ 6 11,591 (4,732) (1,230) 5,635 48,415 $ 7 15,135 (4,559) (8,562) 2,021 43,225 C 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 10,592 8,508 6,516 50 Consolidated Statements of Operations - USD ($) shares in Thousands, 51 $ in Millions 52 Operating revenues: 53 Mainline passenger 54 Regional passenger 55 Cargo 56 Other 57 Total operating revenues 58 Operating expenses: 59 Aircraft fuel and related taxes 60 Salaries, wages and benefits 61 Regional expenses 62 Maintenance, materials and repairs 63 Other rent and landing fees 64 Aircraft rent 65 Selling expenses 66 Depreciation and amortization 67 Special items, net 68 Other 69 Total operating expenses 70 Operating income 71 Nonoperating income (expense): 72 Interest income Balance Sheet and Income Stmt 6,226 9,524 5,983 1,889 1,731 1,250 1,394 1,364 1,051 4,374 34,786 6,204 2,051 1,727 1,250 1,544 1,295 800 4,118 38,401 4,249 39 31 4,374 34,786 6,204 4,118 38,401 4,249 68 Other 69 Total operating expenses 70 Operating income 71 Nonoperating income (expense): 72 Interest income 73 Interest expense, net of capitalized interest 74 Interest Portion of Lease, net 75 Total nonoperating expense, net 76 Income before reorganization items, net 77 Reorganization items, net 78 Income (loss) before income taxes 79 Income tax provision (benefit) 80 Net income (loss) 39 (880) (747) (1,588) 4,616 31 (887) Note: There is no capitalized Inter (181) (1,037) 3,212 4,616 (2,994) $7,610 3,212 330 $ 2,882 Times Interest Earned Fixed Charge Coverage Debt Ratio Debt to Equity Ratio Debt to Tangible Net Worth -5.251 -2.38 0.88 7.59 12.63 Total Score 0.95 20.39 40.00%