Question: PLEASE SOMEONE SOLVE THIS FOR ME. Can anyone help me, please? Using the provided files (Income statement and Balance sheet) for the business calculate and
PLEASE SOMEONE SOLVE THIS FOR ME. Can anyone help me, please? Using the provided files (Income statement and Balance sheet) for the business calculate and analyze its financial position for 2019, 2020 and 2021. Use the formulas presented below so that comparisons can be made with industry level ratios presented in the provided First Research Industry Profile, Airlines by Dunn and Bradstreet, Company Benchmark section, Large Companies (NAICS 4811 ). Round answers to 2 decimal places (note: margins should be expressed as % and then extend to 2 decimals; e.g. .0123 would be shown as 1.23%). Use the attached excel spreadsheet to present the relevant figures and calculations. Use the attached table to present the analysis for each ratio which addresses:


Instructions: Using the provided files (Income statement and Balance sheet) for the business calculate and analyze its financial position for 2019,2020 and 2021. Use the formulas presented below so that comparisons can be made with industry level ratios presented in the provided First Research Industry Profile, Airlines by Dunn and Bradstreet, Company Benchmark section, Large Companies (NAICS 4811). Round answers to 2 decimal places (note: margins should be expressed as \% and then extend to 2 decimals; e.g. . 0123 would be shown as 1.23% ). Use the attached excel spreadsheet to present the relevant figures and calculations. Use the attached table to present the analysis for each ratio which addresses: A. Financial Ratios (Industry ratio: statement line items) 1. Operating income(margin): operating income/revenue 2. Net income(margin): net income/revenue 3. Current ratio: current assets/current liabilities 4. Net worth: Total Equity/Total Assets B. Change from previous year (2020 to 2021, 2019 to 2020 and 2018 to 2019) 1. Change in Revenue 2. Change in Operating Income 3. Change in Net Income Change Formula (state as a \%):(current year - previous year) /the absolute value of the previous year Financial Analysis for Southwest Airlines Southwest Airlines Income Statement-Summary (source: Mergent on-line database) LUV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
