Corporate Finance assignment Excel
AliceRanwodds
MGMT332_Excel_Template_1.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 parts d and e below: | |||||
Prob. 3
| in M$ | in % | in M$ | in % | |||||||||
| 2018 | 2019 | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 | |||||
| Cash and short-term investments | Air traffic liability | |||||||||||
| Accounts receivable, net | Accounts payable | |||||||||||
| Aircraft maintenance deposits, net | Current maturities of debt/leases | |||||||||||
| Other current assets | Other current liabilities | |||||||||||
| Total Current Assets | Total Current Liabilities | |||||||||||
| Property & Equipment, net | LTD and lease obligations, less current | |||||||||||
| Operating lease right of use | Deferred income taxes | |||||||||||
| Deferred heavy maintenance, net | Deferred gains | |||||||||||
| All other assets | Stockholder's equity | |||||||||||
| Total Assets | Total Liab. and equity | |||||||||||
| Working capital | ||||||||||||
| Current ratio | ||||||||||||
| Quick ratio | Answer part c in the box below | |||||||||||
| Total debt ratio | ||||||||||||
| 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 |
