Ration Analysis on Jet Blue
Do a ratio analysis on the financial data presented. The six ratios you are required to calculate follow below. For each ratio, you must show the formula you are using AND the numbers youve plugged in for each calculation AND your result. Again, crunching the numbers is fine, but once those calculations are done, then the most important part is interpreting the results. You should list notes/observations as to the results of each ratio in each year. Do you see any trends that are a concern? Saying increased or decreased is not enough.
Here are the 6 ratios you MUST calculate for at least two years (you must round results to exactly 2 decimal places):
* Working Capital (in dollars this is not a ratio, but this calculation is important to your study).
* Current Ratio
* Debt to Assets ratio
* Debt to Equity ratio
* Return on Investment (a.k.a. Return on Assets) IMPORTANT: here I want you to use "Total Assets" in place of Average Total Assets
* Net Margin
JetBlue Airways Corporation Consolidated Balance Sheets ASSETS CURRENT ASSETs Cash and cash Investment socuritios 538 Recevablos loss allowanoe (2017-$1:2016-s5) 245 47 Inventories, less allowance (2017-$14; 2016-$12) Prepaid exponses and othor 1403 7,868 8.091 Total current assets PROPERTY AND EQUIPMENT 8.980 Flight equipmont 204 .184 Total hight equipment and predolivory dleponits, grons Less accumulated depreciation Total flight equipment and predelivery deposits, net Other property and equipment Less accumulated depreciation ,050 1,041 6,268 972 345 627 Total othor property and equipmont, net Assets conatructed for others Less accumulated depreciation 636 561 561 376 Total assets constructed for others, net 8,049 7.271 Total property and equipmont, net OTHER ASSETS Investment securities Restricted cash Other 62 56 468 526 S 9,781 649 Total other assets TOTAL ASSETS PART I ITEM B Financial Statements and Supplementary Data JetBlue Airways Corporation Consolidated Balance Sheets December 31 n miovns, except per share datal LIABILITIES AND STOCKHOLDERS' EQUITY CURRENT LIABILITIES ts payable 378 Air traffic lablity Accrued salaries, wages and benelits Other accrued iabilties 215 1.120 313 293 321 Current maturities of long terdebt and capital los Total current liabilities LONG-TERM DEBT AND CAPITAL LEASE OBLIGATIONS CONSTRUCTION OBLIGATION 2,395 1,003 2,214 1,195 457 441 DEFERRED TAXES AND OTHER LIABILITIES 033 75 Deferred income taxes 1,354 Other 1.108 1,444 Total deferred taxes and other labilitios COMMITMENTS AND CONTINGENCIES (Notes 10&11) STOCKHOLDERS' EQUITY Preferred stock, $0.01 par value: 25 shares authorized none issued Common stock, $0.01 par value; 900 shares authorized, 418 and 414 shares issued and 321 and 337 shares outstanding at 2017 and 2016, respectively Treasury stock, at cost: 97 and 77 shares at 2017 and 2016, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive income (800) 2.127 3,503 (500) 2,050 2.446 4,834 9,781 stockholders S 9.323 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY JetBlue Airways Corporation onsolidated Statements of Operations a milions.except per share amounts Years Ended December 31 2017 OPERATING REVENUES Passenger Other $ 5,893 S 6,013 619 6.632 6.288 Total oporating revenues .015 6,416 OPERATING EXPENSES ircraft fuel and relatod taxes Saleries, wages and benofits Landing fees and other rents Depreciation and Aircraft rent Sales and marketing Maintenance, materials and repairs Other operating expenses 1,348 1.540 342 345 1,074 1,887 397 1.698 357 393 122 259 583 267 490 5,200 1.216 5,320 Total operating expenses OPERATING INCOME OTHER INCOME (EXPENSE 1,000 (128) (95) 10 nterest expense Capitalized interest terest income and other (119) (96) 457 $ 759 Total other income (expensel INCOME BEFORE INCOME TAXES 021 420 677 S 1,147 S NET INCOME $ 3,492.32 S 2.22 $ 2.15 1,98 EARNINGS PER COMMON SHARE Basic Diuted etBlue Airways Corporation Consolidated Statements of Cash Flows Years Ended 2017 miions) CASH FLOWS FROM OPERATING ACTIVITIES Net income Adustments to reconcile net income to net cash provided by operating s 1.1 759 S 677 Deterred income taxes 1313 377 337 58 zation 5T Stock-based Collsteral returned for derivative instruments 52 in certain operating assets and labilites: Increase) decrease in receivables (21) increasel in inventories, prepaid and other 15 80 64 67 Increase in air traffic lability 53 Increase in accounts payable and other accrued liabilities Other, net 1,632 Net cash provided by operating activilies CASH FLOWS FROM INVESTING ACTIVITIES 837 (104) Capital expenditures Predelivery deposits for fight equipment 1.074) (128) 850) (161) 276) Purchaso of held-to-maturity invostments 244 Procoeds from the maturities of held-to-maturity investments 242 Purchase of availablo-for-salo socurition 517 Proceeds from the sale of available-for-sale securities Other net 1,134) (1.045) Net cash used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES Procoeds from Issuance of common stock Repayment of 47 (194) 368) (134) 241) Long-torm debt and capital lease oblgations Acquistion of treasury stock Other, net (472) 115 318 S 433 (23) 341 Net cash used in financing activities INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS Cash and cash equivalents at beginning of period (130) 433 S 303 JetBlue Airways Corporation Consolidated Statements of Stockholders' Equity Accumulated Common Common Treasury TreasuryPaid-In Retained Comprehensive Shares Stock Shares Stock Total $2,529 Earnin Income (Loss 59 S (125) 1,711 $ 1,002 S (63) Balance at December 31, 2014 Net income Other comprehensive income Vesting of restricted stock unts Exercise of stock options Stock compensation expense Stock issued under Crewmember stock purchase plan Shares repurchased under 2012 share repurchase plan Convertble debt redemption 60 (14) (14) 59 20 20 10 227) 15 70 S(366) $ 1,896 1,679 $ 3 $3.210 Balance at December 31, 2015 Cumulative Effect for the adoption of ASU 2016-09 Net income Other comprehensive income Vesting of restricted stock units Exercise of stock options Stock compensation expense Stock issued under Crewmember stock purchase plarn Shares repurchased under 2016 share repurchase plan Convertble debt Balance at December 31, 2016 Net income Other comprehensive loss Vesting of restricted stock units Exercise of stock options Stock compensation expense Stock issued under Crewmember stock purchase plarn Shares repurchased under 2016 share repurchase plan (14) (14) 10 10 35 35 (120) (120) 18 414 $ 2.446 1,147 77 S (500) 2,050 $4,013 1,147 (13) (10) 13 (13) (10) 19 41 ..i T-Mobile Wi-Fi 10:37 AM Not Secure- investor.jetblue.com PART TEM 8 Financial Statements and Supplementary Data JetBlue Airways Corporation Consolidated Balance Sheets ASSETS CURRENT ASSETS Fligit equiment 1 T-Mobile Wi-Fi D-+ 10:37 AM Not Secure- investor.jetblue.com @ 47%@ ETBLUE ARWAYS CORPORATION-2017 PART 8 Financial Statements and JetBlue Airways Corporation Consolidated Balance Sheets LIABILITIES AND STOCKHOLDERS EQUITY CURRENT LIABILITIES 378 215 242 LONG-TERM DEST AND LEASE OBLIGATIONS DEFERRED TAXES AND OTHER LIANLITES COMMITMENTS AND CONTINGENCIES (Notes 10&11) STOCKHOLDERS EQUITY 4 shares issued and 32 2,127 ..i T-Mobile Wi-Fi 10:37 AM Not Secure- investor.jetblue.com PART ITEM 8 Financial tatements and Supplementary Data JetBlue Airways Corporation Consolidated Statements of Operations 6013 015 OTHER INCOME (EXPENS 21 T-Mobile Wi-Fi 10:37 AM Not Secure- investor.jetblue.com 46 of 82 PART ITEM 8 Fnancial Statements and Supplementary Daa JetBlue Airways Corporation Consolidated Statements of Cash Flows INVESTING ACTIVITIES Proceeds from T-Mobile Wi-Fi 10:37 AM Not Secure- investor.jetblue.com PARTI. ITEM 8 Financial Stunements and JetBlue Airways Corporation Consolidated Statements of Stockholders' Equity Additional Common Oommon Treasury Theas n Paiddn Retaied Carprehensive vesting of 54) undr 2012 of ASU 2016-00 (120 ding of restriced sock units harn repurchaed under 201