Assignment: Introductions, Financial Statements & Ratios
This problem set uses Alaska Air Group, Inc. as the basis for ALL questions. To start, go to the airline's investor relations page and get its latest annual report (10-K).
A. Using the firm's selected financial data:
a. Make a table showing the income statement (in million $). Note that any expenses that do not have their own specific line listed should be grouped under "All other expenses". The net income lines must tie using formulas.
b. Use the table created to create a common size income statement (as a % of operating revenues for that year).
c. Show year-on-year (YoY, in %) growth
d. What happened to the profit margins?
e. What are the actual tax rates?
B. Using the operating stats, what is the YoY growth rate for:
a. Yield?
b. Operating expense per available seat mile (CASM)? c. Revenue passenger miles (RPMs)?
c. Fuel price ($/gallon)?
d. Considering the above, what factors, other than the pandemic, do you think are
C. Using the firm's balance sheets, show:
a. Balance sheets as shown (in million $); show only net property & equipment lines.
b. Common size balance sheets.
c. Are there any outliers in the balance sheets that you think merit mentioning?
d. For these years, what is the net working capital position? Current ratio? Quick ratio? Total debt ratio? Return on assets (ROA)? Return on equity (ROE)? What is the latest p/e ratio (use Yahoo Finance)?
D. Using the Statement of Cash Flows, which items stand out to you and why?
E. Go to the carrier snapshot section in the Bureau of Transportation Statistics of the U.S. Department of Transportation.
a. What are the top three markets by share?
b. What happened to passenger yields?
c. What happened to costs per ASM?
d. What do you think this means for the bottom line?
e. What are the top three city pairs?
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.