What happened to the profit margins? Explain. A B C D E F G H I J

What happened to the profit margins? Explain. 

Transcribed Image Text:

A B C D E F G H I J K 1 in Million $ in % YoY Growth 2 2020 2021 2022 2020 2021 2022 2021 2022 3 Total Operating Revenues 9,048 15,790 23,814 100% 100% 100% 75% 51% 5 Operating Expenses: 6 Salaries, wages and benefits 5,844 4,783 9,376 65% 30% 39% -18% 96% 7 Aircraft fuel 1,849 3,310 5,975 20% 21% 25% 79% 81% 8 Maintenance and repair 750 854 852 8% 5% 4% 14% 0% 9 Depreciation and amortization 1,255 1,272 1,351 14% 8% 6% 1% 6% 10 Landing fees and airport rent 1,240 1,456 1,508 14% 9% 6% 17% 4% 11 All other expenses 1,926 2,394 3,735 21% 15% 16% 24% 56% 12 Total Operating Expenses 13 12,864 14,069 22,797 142% 89% 96% 9% 62% 14 Operating Income (3,816) 1,721 1,017 -42% 11% 4% -145% -41% 15 Total other income/(expense) (440) 396 289 -5% 3% 1% -190% -27% 16 (Loss)/Income before taxes (4,256) 1,325 728 -47% 8% 3% -131% -45% 17 Income tax/(benefit) expense (1,182) 348 189 -13% 2% 1% -129% -46% 18 Net (Loss) Income (3,074) 977 539 -34% 6% 2% -132% -45% 19 Actual tax rate 28% 26% 26% 20 EPS (5.44) 1.61 0.87 A B C D E F G H I J K 1 in Million $ in % YoY Growth 2 2020 2021 2022 2020 2021 2022 2021 2022 3 Total Operating Revenues 9,048 15,790 23,814 100% 100% 100% 75% 51% 5 Operating Expenses: 6 Salaries, wages and benefits 5,844 4,783 9,376 65% 30% 39% -18% 96% 7 Aircraft fuel 1,849 3,310 5,975 20% 21% 25% 79% 81% 8 Maintenance and repair 750 854 852 8% 5% 4% 14% 0% 9 Depreciation and amortization 1,255 1,272 1,351 14% 8% 6% 1% 6% 10 Landing fees and airport rent 1,240 1,456 1,508 14% 9% 6% 17% 4% 11 All other expenses 1,926 2,394 3,735 21% 15% 16% 24% 56% 12 Total Operating Expenses 13 12,864 14,069 22,797 142% 89% 96% 9% 62% 14 Operating Income (3,816) 1,721 1,017 -42% 11% 4% -145% -41% 15 Total other income/(expense) (440) 396 289 -5% 3% 1% -190% -27% 16 (Loss)/Income before taxes (4,256) 1,325 728 -47% 8% 3% -131% -45% 17 Income tax/(benefit) expense (1,182) 348 189 -13% 2% 1% -129% -46% 18 Net (Loss) Income (3,074) 977 539 -34% 6% 2% -132% -45% 19 Actual tax rate 28% 26% 26% 20 EPS (5.44) 1.61 0.87

Answer rating: 100% (QA)

The profit margins for the company in the spreadsheet have declined significantly over the past thre... View the full answer