Question: Using the attached consolidated balance sheet, I've figured out the answers to the ratios below for 2015. However, i'm having trouble entering the formula into

Using the attached consolidated balance sheet, I've figured out the answers to the ratios below for 2015. However, i'm having trouble entering the formula into excel. Can you please show me how to enter the formulas into excel?

Times Interest Earned = 6.25

Fixed Charge Coverage = 3.84

Debt Ratio = 0.88

Debt to Equity Ratio = 7.59

Debt to Tangible Net Worth = -60.68

Using the attached consolidated balance sheet, I've figured out the answers to

Consolidated Balance Sheets - USD ($) $ in MillionsCurrent assetsCashShort-term investmentsRestricted cash and short-term investmentsAccounts receivable, netAircraft fuel, spare parts and supplies, netPrepaid expenses and otherTotal current assetsOperating property and equipmentFlight equipmentGround property and equipmentEquipment purchase depositsTotal property and equipment, at costLess accumulated depreciation and amortizationTotal property and equipment, netOther assetsGoodwillIntangibles, net of accumulated amortizationDeferred tax assetOther assetsTotal other assetsTotal assetsCurrent liabilitiesCurrent maturities of long-term debt and capital leasesAccounts payableAccrued salaries and wagesAir traffic liabilityLoyalty program liabilityOther accrued liabilitiesTotal current liabilitiesNoncurrent liabilitiesLong-term debt and capital leases, net of current maturitiesPension and postretirement benefitsDeferred gains and credits, netBankruptcy settlement obligationsOther liabilitiesTotal noncurrent liabilitiesCommitments and contingenciesStockholders' equityCommon stockAdditional paid-in capitalAccumulated other comprehensive loss Dec. 31, 2015 Dec. 31, 2014 $ 3905,8646951,4258637489,985 $ 9946,3097741,7711,00489811,750 33,1856,4021,06740,654(13,144)27,510 28,2135,9001,23035,343(12,259)23,084 4,0912,2492,4772,10310,92048,415 4,0912,24002,0608,39143,225 2,2311,5631,2053,7472,5252,33413,605 1,6771,3771,1944,2522,8072,09713,404 18,3307,4506671932,535$ 29,175 16,0437,5628293253,041$ 27,800 $611,591(4,732) $715,135(4,559) Accumulated deficitTotal stockholders' equityTotal liabilities and stockholders' equityAmerican Airlines, Inc. [Member] (1,230)5,63548,415 Consolidated Statements of Operations - USD ($) shares in Thousands, $ inMillionsOperating revenues:Mainline passengerRegional passengerCargoOtherTotal operating revenuesOperating expenses:Aircraft fuel and related taxesSalaries, wages and benefitsRegional expensesMaintenance, materials and repairsOther rent and landing feesAircraft rentSelling expensesDepreciation and amortizationSpecial items, netOtherTotal operating expensesOperating incomeNonoperating income (expense):Interest incomeInterest expense, net of capitalized interestInterest Portion of Lease, netTotal nonoperating expense, netIncome before reorganization items, netReorganization items, netIncome (loss) before income taxesIncome tax provision (benefit)Net income (loss) (8,562)2,02143,225 12 Months EndedDec. 31, 2015Dec. 31, 2014$ 29,0376,4757604,71840,990 $ 30,8026,3228754,65142,650 6,2269,5245,9831,8891,7311,2501,3941,3641,0514,37434,7866,204 10,5928,5086,5162,0511,7271,2501,5441,2958004,11838,4014,249 39(880)(747)(1,588)4,616 31(887)(181)(1,037)3,212 4,616(2,994)$ 7,610 3,212330$ 2,882 Times Interest EarnedFixed Charge CoverageDebt RatioDebt to Equity RatioDebt to Tangible Net WorthTotal Score 0.00% Note: There is no capitalized Interest in this example 00000 00000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!