MGMT 332 Texas A&M International Financial Statements and Ratios Spreadsheet
Question Description
Directions: Go to the investor relations page of United Airlines to get its 2019annual report.
1. Using the firm’s selected financial data: a. Make a table showing the income statement (in M$)b. Use the table created to create a common size income statement (% of operatingrevenues)c. Show year-on-year (YoY) growthd. What happened to the profit margins?e. What are the actual tax rates?
2. Using the operating stats, what is the YoY growth rate for:a. Yield per passenger mile?b. Operating expense per available seat mile (ASM)?c. Revenue passenger miles?d. Average fuel cost per gallon?e. Considering the above, what factors do you think are affecting margins the most?Be specific.
3. Using the firm’s balance sheets, show:a. Balance sheets as shown (in M$); show only the net property and equipmentlines.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? Quickratio? Total debt ratio? Return on assets (ROA)? Return on equity (ROE)?What is the p/e ratio for 2018?
4. Using the Statement of Cash Flows, which operating activity items stand out to youand why?
5. Go to the Bureau of Transportation Statistics (United States Department ofTransportation).Select United and answer the following questions: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?
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."