Question: Only need current year info for: current assets, current liabilities, inventory, total debt, total assets, total stockholders' equity, profits before interest and taxes, total interest

Only need current year info for: current assets, current liabilities, inventory, total debt, total assets, total stockholders' equity, profits before interest and taxes, total interest expense, sales, inventory of finished goods, fixed assets, total assets, accounts receivable, total credit sales, cost of goods sold or cost of sales, EBIT, net income, and other operating expenses.

Only need current year info for: current assets,Only need current year info for: current assets,Only need current year info for: current assets,Only need current year info for: current assets,Only need current year info for: current assets,Only need current year info for: current assets,Only need current year info for: current assets,
Instructions: Fill in the cells with $ (yellow highlighted) and the ratios will automatically calculate Financial Ratios Analysis Current Year Previous Year Previous Year Liquidity Ratios extent to which a firm can meet short-term obligations - Curent Ratio: Current Assets/Current Liabilitys -gangrally one wants an upward trend extent to which a firm can meet short-term obligations we Quick Ration: Current assets minus inventorycurrent liabilities selling inventory - generally one wants an upward trent S Current Assets $ Current Liabilitys 5 Inventory Leverage Ratios ' of total funds provided by creditors - generally one wants a Debt Jo-Total Assets Ratio: Total Debt/Total Assets downward trend "% of total funds provided by creditors wa. by owners - Debt in Equity Ratios: Total Debt/Total Stockholders' Equity generally one wants a downward trend extent to which earnings can decline we firm being unable to Times Interest Earned Ratio: Profits before interest & taxes/Total Interes pay interest . generally one wants and upward trend 5 Total Debt S Total Assets 5 Total Stockholders' Equity $ Profits before Interest and taxes 5 Total Interest Expense Activity Ratios whather firm holds extensive imentory and is selling it slower Inventory Turnover. Sales/Inventory of Finished Goods than industry - generally one wants and upward trend Sales productivity and plan and equipment utilization - Fixed Assets Turnover. Sales/Fixed Assets generally one want to see an upward trend whather firm is generating sufficient vol. of busin, for size of Total Assets Tumower: Sales/Total Assets -asset investment . generally one wants an upward trend average time it takes for firm to collect on credit sales - Average Collection Period: Accounts Receivable/(Total credit sales/365 c - generally one wants a downward trend S Inventory of Finished Goods 5 Fixed Assets S Total Assets 5 Accounts Receivable S Total Credit Sales (uless othewise indicated, same as sales)Profitability Ration total margin available to cover operating expenses and yield a [Gross Profit Margin: Sales minus cost of good sold/Sales Iprofit - generally one wants an upward trend profitability who concom for taxes and interest - generally Operating Profit Margin: Earnings before interest and taxes (EBIT)/Sales . one wants and upward trend after-tax profits per dollar of sales - generally one wants an Not Proft Margin: Net Income/Sales upward trend after-tax profits par dollar of assets (ROD) - generally one Return on Total Assets (BOA): Net income/Total Assets wants and upward trend after-tax profits per dollar of stockholders" investment in the Beturn on Stockholders Equity (ROE): Net Income/ Total Stockholders' . firm . generally one wants and upward trend Sales Revenue (already entered above - no need to re-enter data) $ Cost of goods sold or cost of sales 5 EBIT (Earnings Before Interest and Taxes) $ Net Income (Earnings After Interest and Taxes] Total Assets (already entered above . no need to re-enter data) Total Stockholders' Equity (already entered above - no need to re-enter) 5 Other Operating Expenses Revenue Expanse annual percentage growth rate in sales - generally one wants Sales Revenue (percentage change) . an upward trend annual percentage growth rate in cost of sales - generally Cost of Sales (percentage change) - one wants a downward trend annual percentage growth rate in operating profit - generally Operating Profit_(percentage change) - one wants an upward trend annual percentage growth rate in net income . generally one Net Income (percentage change) - wants an upward trendEXHIBIT 10 JetBlue Cash Flows (in millions) Years Ended December 31 2021 2020 2019 CASH FLOWS FROM OPERATING ACTIVITIES Net (loss) income $ (182) $(1,354) $ 569 Adjustments to reconcile net (loss) income to net cash provided by operating activities: Deferred income taxes (88) (329) 139 Impairment of long-lived assets 273 Depreciation and amortization 540 535 525 Stock-based compensation 28 28 31 Losses on sale-leaseback transactions 106 Losses on debt extinguishments 50 9 Unrealized (gains) losses on investments (49) (21) Changes in certain operating assets and liabilities: Decrease (increase) in receivables (46) 144 (3) Decrease in inventories, prepaid and other 138 52 188 Increase in air traffic liability 447 66 118 Increase (decrease) in accounts payable and other accrued liabilities 806 1255 (91) Other, net (2) 40 16 Net cash provided by (used in) operating activities 1,642 683) 1,449 CASH FLOWS FROM INVESTING ACTIVITIES Capital expenditures (907) (715) (932 Pre-delivery deposits for flight equipment (88) (76) (224 Purchase of held-to-maturity investments (37) 1374 Proceeds from the maturities of held-to-maturity investments 21 534 Purchase of available-for-sale securities (1,577) (1,962) (1,000 Proceeds from the sale of available-for-sale securities 1,910 1,174 880 Proceeds from sale-leaseback transactions 209 Other, net (5) Net cash (used in) investing activities 704) (1,349) (1,129) CASH FLOWS FROM FINANCING ACTIVITIES Proceeds from issuance of long-term debt 1,010 2.541 981 Proceeds from short-term borrowings 981 Proceeds from sale-leaseback transactions 354 Proceeds from issuance of common stock 46 619 51 Proceeds from issuance of stock warrants 14 28 Repayment of long-term debt and finance lease obligations (1,892) 372) (323 Repayment of short-term borrowings (1,000 Acquisition of treasury stock (8) (167) (542) Other, net Net cash provided by (used in) financing activities (830) 2,983 165 INCREASE IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH 108 951 485 Cash, cash equivalents and restricted cash at beginning of period 1,969 1,018 533 Cash, cash equivalents and restricted cash at end of period $ 2,077 $ 1,969 $ 1.018 SUPPLEMENTAL CASH FLOW INFORMATION Cash payments for interest $ 180 $ 139 562 Cash payments for income taxes (net of refunds) 5 (52) NON-CASH TRANSACTIONS Operating lease assets obtained in exchange for operating lease liabilities $ 46 $ 144 $ 7 (1) Reconciliation of cash, cash equivalents and restricted cash reported within the consolidated balance sheets: Cash and cash equivalents $ 2,018 $ 1,918 $ 959 Restricted cash 59 51 59 Total cash, cash equivalents and restricted cash $ 2,077 $ 1,969 $ 1,018EXHIBIT 3 JetBlue Statement of Operations 2019-2021 in millions except per share data) Years Ended December 31, 2021 2020 2019 OPERATING REVENUES Passenger $5,609 $ 2,733 $7,786 Other 428 224 308 Total operating revenues 6,037 2,957 8,094 OPERATING EXPENSES Aircraft fuel and related taxes 1,436 631 1,847 Salaries, wages and benefits 2,358 2,032 2,320 Landing fees and other rents 628 358 474 Depreciation and amortization 540 535 525 Aircraft rent 99 85 99 Sales and marketing 183 110 290 Maintenance, materials and repairs 626 441 619 Other operating expenses 1,080 762 1,106 Special items (833) (283) 14 Total operating expenses 6,117 4,671 7,294 OPERATING (LOSS) INCOME (80) (1,714) 800 OTHER INCOME (EXPENSE) Interest expense (192) (179) (79) Interest income 17 23 32 Gain on equity investments, net 44 15 Other (52) (23) Total other expense (183) (179) (32) (LOSS) INCOME BEFORE INCOME TAXES (263) (1,893) 768 Income tax (benefit) expense (81) (539) 199 NET (LOSS) INCOME $ (182) $(1,354) $ 569 (LOSS) EARNINGS PER COMMON SHARE Basic $ (0.57) $ (4.88) $ 1.92EXHIBIT 7 JetBlue Operating Revenues by Geographic Region (in millions) 2021 2020 2019 $3,869 $1,890 $5,633 Domestic 2,150 1,067 2,461 Caribbean & Latin America 18 Atlantic $6,037 $2,957 $8,094 TotalEXHIBIT 8 JetBlue Operating Expense Per Available Seat Mile (ASM) Excluding Fuel (in millions; per ASM data in cents) Non-GAAP Financial Measure Reconciliation of Operating Expense per ASM, Excluding Fuel 2021 2020 2019 2018 2017 (in millions; per ASM data in cents) $ per ASM $ per ASM $ per ASM $ per ASM $ per ASM Total operating expenses $6,117 11.30 $4,671 14.29 $7,294 11.43 $7,392 12.34 $6,039 10.78 Less: Aircraft fuel and related taxes 1,436 2.65 631 1.93 1,847 2.89 1,899 3.17 1,363 2.43 Other non-airline expenses 43 0.08 35 0.10 46 0.08 44 0.07 35 0.06 Special items (833) (1.54) (283) (0.86) 14 0.02 435 0.73 Operating expenses, excluding fuel $5,471 10.11 $4,288 13.12 $5,387 8.44 $5,014 8.37 $4,641 8.29EXHIBIT 2 JetBlue Statement of Operations 2014-2018 (in millions except per share data) (in millions except per share data) 2018 2017 2016 2015(1) 20141) Statements of Operations Data Operating revenues $ 7,658 $ 7,012 $ 6,584 $ 6,416 $ 5,817 Operating expenses: Aircraft fuel and related taxes 1,899 1,363 1,074 1,348 1,912 Salaries, wages and benefits 2,044 1,887 1,698 1,540 1,294 Landing fees and other rents 420 397 357 342 321 Depreciation and amortization 491 446 393 345 320 Aircraft rent 103 100 110 122 124 Sales and marketing 294 271 263 264 231 Maintenance, materials and repairs 625 622 563 490 418 Other operating expenses 1,059 933 866 749 682 Special items(2) 435 Total operating expenses 7,370 6,019 5,324 5,200 5,302 Operating income 288 993 1,260 1,216 515 Other income (expense)(3) 69 (79 (96) (119) 108 Income before income taxes 219 914 1,164 1,097 623 Income tax expense (benefit)(4(5) 31 211) 437 420 222 NET INCOME $ 188 $1,125 $ 727 $ 677 $ 401 Earnings per common share: Basic $ 0.60 $ 3.42 $ 2.23 $ 2.15 $ 1.36 Dilutedd(21(4)(5) $ 0.60 $ 3.41 $ 2.13 $ 1.98 $ 1.19 Other Financial Data: Operating margin 3.8% 14.2% 19.1% 19.0% 8.9% Pre-tax margin(21(3) 2.9% 13.0% 17.7% 17.1% 10.7% Net cash provided by operating activities $ 1,217 $ 1,396 $ 1,632 $ 1,598 $ 912 Net cash used in investing activities (1,156) (979) (1,046) (1,134) (379) Net cash provided by (used in) financing activities 113 (553 (472) (487) (417)

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!