Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need someone to complete a Financial Ratio Analysis from this information below, thanks! 1. Short-term solvency, or liquidity, ratios Current facto Current ratio -
I need someone to complete a Financial Ratio Analysis from this information below, thanks!
1. Short-term solvency, or liquidity, ratios Current facto Current ratio - Quick ratio = = Current assets Current liabilities Current assets - Inventory Current liabilities Cash urrent liabilities Lasn fauo II. Long-term solvency, or financial leverage, ratios - Total assets - Total Equity Total debt ratio = Total assets Debt-equity ratio = Total debt/Total equity Equity multiplier = Total assets/Total equity Times interest earned ratio = EBIT Interest _ EBIT + Depreciation Cash coverage ratio = = Interest III. Asset utilization, or turnover, ratios - Cost of goods sold Inventory turnover = Inventory 365 days Days' sales in inventory Inventory tumover Receivables turnover = . turnover Accounts receivable 365 days Days' sales in receivables = Receivables turnover Total accot turnover Sales Total assots Sales Capital intensity = Total assets IV. Profitability ratios Profit margin = Net income Sales Return on assets (ROA) = Net Income Total assets Return on equity (Roe) = Moet nooit ROE = ROE Net income x Sales x Assets Sales Assets Equity IV. Profitability ratios Total assets Profit margin = Nee Cineame Return on assets (ROA) = Net Income Return on equity (ROE) = Net income ROE = Not income x Sales no V. Market value ratios Price per share Earnings per share - Price-earnings ratio = - Market-to-book ratio = Market value per share Book value per share Fiscal year is January- December. All values USD millions. 2016 2015 - 2014 2013 2012 Sales/Revenue 6,632 6,416 5,817 5,441 4,982 Sales Growth 3.37% 10.30% 6.91% 9.21% - Cost of Goods Sold (COGS) incl. D&A 5,070 5,070 4,831 5,048 4,789 4,412 COGS excluding D&A 4,677 4,486 4,728 4,499 4,154 Depreciation & Amortization Expense 393 345 320 290 258 Depreciation 337 288 263 258 230 Amortization of Intangibles 56 57 57 32 28 COGS Growth 4.95% - 4.30% 5.41% 8.54% Gross Income 1,562 1,585 769 652 570 Gross Income Growth -1.45% 106.11% 17.94% 14.39% SG&A Expense 259 264 231 223 204 Other SG&A 259 264 231 223 204 SGA Growth -1.89% 14.29% 3.59% 9.31% EBIT 1,321 538 429 1,303 (1) 366 1 Unusual Expense (13) 16 11 Non Operating Income/Expense 16 (118) 234 1 - Basic Shares Outstanding 327 315 295 283 282 EPS (Diluted) 2.22 1.98 1.19 0.52 0.40 - EPS (Diluted) Growth 12.60% 66.19% 130.59% 29.46% Diluted Shares Outstanding 342 345 343 343 344 EBITDA 1,696 1,666 858 719 624 EBITDA Growth 1.80% 94.17% 19.33% 15.22% - EBIT 1,303 1,321 538 429 366 Annual Report, 2016. EXHIBIT 5 Balance Sheet of JetBlue Fiscal year is January- December. All values USD millions. 2016 2015 S 2014 2013 2012 Cash & Short-Term Investments 876 708 627 731 971 433 708 341 731 627 225 Cash Only 318 1 182 Short-Term Investments 538 558 367 402 549 Cash & Short-Term Investments Growth 10.84% 23.73% 12.92% -14.23% Cash & ST Investments / Total Assets 10.24% 10.12% 9.03% 8.53% 10.34% Total Accounts Receivable 172 172 136 136 136 129 129 106 106 Accounts Receivables, Net R 172 136 136 129 106 Accounts Receivables, Gross - 177 142 142 135 113 Bad Debt/Doubtful Accounts (5) (6) (6) (6) Acounts Receivable Growth 26.47% 0.00% 5.43% 21.70% Accounts Receivable Turnover 38.56 47.18 42.18 47.00 42.77 46 Inventories 47 48 36 44 - Raw Materials 46 48 - Other Current Assets 317 310 252 377 - 227 119 Prepaid Expenses 172 135 126 Miscellaneous Current Assets 377 145 175 126 108 Total Current Assets 1,567 1,373 1,200 1,056 1,100 Net Property, Plant & Equipment 7,271 7,271 6,652 6,072 5,656 5,343 Property, Plant & Equipment Gross 9,624 8,679 7,817 7,208 6,652 Machinery & Equipment 8,091 7,250 6,440 5,959 5,506 Construction in Progress 1 561 561 561 561 561 Other Property, Plant & Equipment 972 868 816 688 585 Accumulated Depreciation 2,353 2,027 1,745 1,552 1,309 Machinery & Equipment 1,823 1,573 1,354 1,185 995 Construction in Progress 185 161 139 116 93 Other Property, Plant & Equipment 345 293 252 221 Total Investments and Advances 152 112 121 187 Other Long-Term Investments 152 112 121 187 Intangible Assets 97 93 73 129 Other Assets 400 430 373 397 311 Tangible Other Assets 400 430 373 397 311 Total Assets 9,487 8,660 7,839 7,350 7,070 Assets Total Growth 9.55% 10.47% 6.65% 3.96% ST Debt & Current Portion LT Debt 189 448 265 469 394 Current Portion of Long-Term Debt 189 448 265 469 394 Accounts Payable 242 205 208 180 846 Accounts Payable Growth 18.05% 1,792 -1.44% 1,622 15.56% 1,463 -78.72% 1,225 Other Current Liabilities 368 Accrued Payroll 1 342 302 203 171 172 Miscellaneous Current Liabilities 1,450 1,320 1,260 1,054 196 Total Current Liabilities 2,223 2,275 1,936 1,874 1,608 Current Ratio 0.70 0.60 0.62 0.56 0.68 Quick Ratio 0.68 0.58 0.60 0.54 0.66 Cash Ratio 0.44 0.39 0.37 0.33 0.45 Long-Term Debt 1,652 1,867 2,455 2,590 2,457 Long-Term Debt excl. Capitalized Leases 1,528 1,727 2,300 2,493 2,457 Non-Convertible Debt 1,528 1,727 2,300 2,493 2,457 Capitalized Lease Obligations 124 140 155 97 - Deferred Taxes 1,509 1,218 832 605 481 Deferred Taxes - Credit 1,218 832 605 481 1,509 90 Other Liabilities 90 87 147 636 Other Liabilities (excl. Deferred Income) 90 87 147 636 90 5,450 Total Liabilities 5,474 5,310 5,216 5,182 Total Liabilities / Total Assets 57.70% 4,013 62.93% 3,210 67.74% 2,529 70.97% ,134 73.30% 1,888 Common Equity (Total) 2 Common Stock Par/Carry Value 3 Additional Paid-In Capital/Capital Surplus 2,050 1,896 1,711 1,573 1,495 Retained Earnings 2,446 1,679 1,002 601 433 Other Appropriated Reserves - 13 (3) (63) (8) (35) Treasury Stock (500) (366) (125) (43) Common Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Shareholders' Equity 4,013 4,013 3,210 3,210 2,529 2,134 1,888 Total Shareholders' Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Equity 4,013 3,210 2 ,529 2,134 1,888 Liabilities & Shareholders' Equity 9,487 8,660 7 ,839 7 ,350 7,070Step 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