Use jetBlue as the basis for ALL questions. Go to its investor relations page and get its latest annual report (10-K). Use the template provided. 1. Using its financial data: a. Show the income statement (in million $). Expenses without their own specific line listed should go under "All other expenses" Show all your formulas b. Create a common size income statement (% of revenues for that year) c. Show year-on-year (YoY) growth in % d. What happened to profit margins? e. What were the actual tax rates? 2. Using the operating statistics, what are the values and YoY growth rates for a. Yield b. Operating expense per available seat mile (ASM) c. Revenue passenger miles (in millions) d. Fuel price (S/gallon) e. What factors, other than the pandemic, affected margins the most? Be specific 3. Using the firm's balance sheets, show. a. Balance sheet items (in million $) b. Common size balance sheets c. Are there any outliers that merit mentioning? d. Working capital current ratio, quick ratio, total debt ratio return on assets (ROA), return on equity (ROE) and the latest ple ratio 4. Using the Statement of Cash Flows, which items stand out and why? 5. Use the carrier snapshot section in the Bureau of Transportation Statistics (BTS) of the US Department of Transportation to show a. Top three airports by share b. Passenger yields and their changes over time c. Costs per ASM and their changes over time d. Using b and what happened to the bottom line? e. Top three city pairs 11 MI N in Millions 2018 2019 in 2019 2020 2018 2020 Yo Y Growth (95) 2019 2020 Answer part d below! 3 Total Operating Revenues 1 5 Salaries, wies and benefits 6 Aircraft fuel and related taxes 7 Maintenance, materials and repairs 8 Landing fees and other rents 9 Depreciation/amortization 10 All other expenses 11 Total Operating Expenses 12 13 Operating Income 14 Total non operating inconi (expense) 15 Income before taxes 16 Income tax expense benefit 17 18 Net Income 19 Actual tax rate 20 B D E H G YoY growth (6) 2019 2020 2018 2019 2020 2 3 Yield 4 Expense per available seat milo 5 6 Revenue passenger miles (RPM in millions) 7 8 Fuel price (S'gallon) Answer parte in the box below: 10 12 13 144 15 16 12 G H M N B D in Millions 2019 2020 E in 2019 in Millions 2019 in % 2019 2020 2020 A 1 2 3 Cash and securities 4 Accounts receivable et s Inventory and supplies, net 6 Prepaid 7 Total Current Assets 8 Property & Equipment, et 9 Operating lease assets 10 All other assets 11 Total Assets 12 13 Working capital 14 Current ratio 15 Quick ratio 16 Total debt ratio 17 RON 15 RON 19 perto today (Yahoo Finance) 20 21 Air traffic liability Cuties of LID Payables All other current abilities Total Current Liabilities Long term debt and lease obligations Longlom operating lases, set of current Deferrals Stockholder's equity Total Liab, and equity Avner parte in the box B H J K D E F G Enter your text answer in the box below. 2 3 4 5 6 7 8 9 10 11 12 13 A B D F K L 3 4 5 6 B 8 9 10 11 12 13 14 D 15 16 17 18 19 20 E Prob. 1 ProtoPro Prab. 5 NOV 2011 READY Use jetBlue as the basis for ALL questions. Go to its investor relations page and get its latest annual report (10-K). Use the template provided. 1. Using its financial data: a. Show the income statement (in million $). Expenses without their own specific line listed should go under "All other expenses" Show all your formulas b. Create a common size income statement (% of revenues for that year) c. Show year-on-year (YoY) growth in % d. What happened to profit margins? e. What were the actual tax rates? 2. Using the operating statistics, what are the values and YoY growth rates for a. Yield b. Operating expense per available seat mile (ASM) c. Revenue passenger miles (in millions) d. Fuel price (S/gallon) e. What factors, other than the pandemic, affected margins the most? Be specific 3. Using the firm's balance sheets, show. a. Balance sheet items (in million $) b. Common size balance sheets c. Are there any outliers that merit mentioning? d. Working capital current ratio, quick ratio, total debt ratio return on assets (ROA), return on equity (ROE) and the latest ple ratio 4. Using the Statement of Cash Flows, which items stand out and why? 5. Use the carrier snapshot section in the Bureau of Transportation Statistics (BTS) of the US Department of Transportation to show a. Top three airports by share b. Passenger yields and their changes over time c. Costs per ASM and their changes over time d. Using b and what happened to the bottom line? e. Top three city pairs 11 MI N in Millions 2018 2019 in 2019 2020 2018 2020 Yo Y Growth (95) 2019 2020 Answer part d below! 3 Total Operating Revenues 1 5 Salaries, wies and benefits 6 Aircraft fuel and related taxes 7 Maintenance, materials and repairs 8 Landing fees and other rents 9 Depreciation/amortization 10 All other expenses 11 Total Operating Expenses 12 13 Operating Income 14 Total non operating inconi (expense) 15 Income before taxes 16 Income tax expense benefit 17 18 Net Income 19 Actual tax rate 20 B D E H G YoY growth (6) 2019 2020 2018 2019 2020 2 3 Yield 4 Expense per available seat milo 5 6 Revenue passenger miles (RPM in millions) 7 8 Fuel price (S'gallon) Answer parte in the box below: 10 12 13 144 15 16 12 G H M N B D in Millions 2019 2020 E in 2019 in Millions 2019 in % 2019 2020 2020 A 1 2 3 Cash and securities 4 Accounts receivable et s Inventory and supplies, net 6 Prepaid 7 Total Current Assets 8 Property & Equipment, et 9 Operating lease assets 10 All other assets 11 Total Assets 12 13 Working capital 14 Current ratio 15 Quick ratio 16 Total debt ratio 17 RON 15 RON 19 perto today (Yahoo Finance) 20 21 Air traffic liability Cuties of LID Payables All other current abilities Total Current Liabilities Long term debt and lease obligations Longlom operating lases, set of current Deferrals Stockholder's equity Total Liab, and equity Avner parte in the box B H J K D E F G Enter your text answer in the box below. 2 3 4 5 6 7 8 9 10 11 12 13 A B D F K L 3 4 5 6 B 8 9 10 11 12 13 14 D 15 16 17 18 19 20 E Prob. 1 ProtoPro Prab. 5 NOV 2011 READY