Corporate Finance Excel
AliceRanwodds
Mar2021template.xlsxProb. 1
| in M$ | in % | YoY Growth | |||||||||
| 2017 | 2018 | 2019 | 2017 | 2018 | 2019 | 2018 | 2019 | ||||
| Total Operating Revenues | Answer part d below: | ||||||||||
| Operating Expenses: | |||||||||||
| Aircraft fuel | |||||||||||
| Salaries, wages and benefits | |||||||||||
| Landing fees and other rent | |||||||||||
| Depreciation/amortization | |||||||||||
| Aircraft rent | |||||||||||
| All other expenses | |||||||||||
| Total Operating Expenses | |||||||||||
| Operating Income | |||||||||||
| Total other income/expense | |||||||||||
| Income before taxes | |||||||||||
| Income tax expense | |||||||||||
| Net Income | |||||||||||
| Actual tax rate |
Prob. 2
| YoY growth rate | ||||||
| 2018 | 2019 | 2019 | ||||
| Average yield | ||||||
| Expense per available seat mile (CASM) | ||||||
| Revenue passenger miles (millions) | ||||||
| Average fuel cost per gallon | Answer part e below: | |||||
Prob. 3
| in M$ | in % | in M$ | in % | |||||||||
| 2018 | 2019 | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 | |||||
| Cash and short-term investments | 1,108 | Air traffic liability | 292 | |||||||||
| Accounts receivable, net | 48 | Accounts payable | 39 | |||||||||
| Aircraft maintenance deposits, net | 107 | Current maturities of debt/leases | 164 | |||||||||
| Other current assets | 83 | Other current liabilities | 340 | |||||||||
| Total Current Assets | 1,345 | Total Current Liabilities | 835 | |||||||||
| Property & Equipment, net | 3,116 | LTD and lease obligations, less current | 2,025 | |||||||||
| Deferred heavy maintenance, net | 249 | Deferred income taxes | 355 | |||||||||
| All other assets | 455 | Deferred gains | 23 | |||||||||
| Total Assets | 5,165 | Stockholder's equity | 1,929 | |||||||||
| Total Liab. and equity | 5,165 | |||||||||||
| Working capital | ||||||||||||
| Current ratio | ||||||||||||
| Quick ratio | ||||||||||||
| Total debt ratio | Answer part c in the box below | |||||||||||
| ROA | ||||||||||||
| ROE | ||||||||||||
| p/e ratio today | ||||||||||||
Prob. 4
| Put your text answer in the yellow box. |
Prob. 5
| A |
| B |
| C |
| D |
| E |
v. MAR 2021
| No content - Intentionally left blank |
