Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

25th edition

978-1285069609, 1285069609, 978-1133607601

More Books

Students also viewed these Accounting questions

Question

c. What type of degree does it offer?

Answered: 1 week ago