Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 00000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started