PLS HELP ASAP I WILL THUMBS UP.
I CHOSE INVENTORY TURNOVER
You will answer the following questions for each ratio selected.
1. Using the data provided, write out the formula and result for the three most recent years for your selected company. Include the name of the company. Don't verbally discuss the ratio calculation.
2. Did the ratio increase/decrease/stay the same over the last three years? Explain the meaning.
3. What was the cause of that change? (Be specific! Not just that the numbers changed. Which component? Why? Dig into the finanical statements provided)
Consolidated Statements of Ca Consolidated Balance Sheets \begin{tabular}{|c|c|c|c|c|c|} \hline Ratios & Consolidated Balance Sheets & \multicolumn{4}{|c|}{ Consolidated Statements of Oper } \\ \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ Coavelidated Statements of Operations - USD (5) 5 in Mtillioas }} & \multicolumn{3}{|c|}{12 Momths Ended } & \multirow[b]{2}{*}{ Dec. 31. 2019} \\ \hline & & Dex. 31.2022 & Dec. 31.2021 & Dec. 31.2020 & \\ \hline \multicolumn{6}{|l|}{ Pauknger! } \\ \hline Total passenger & emac & 40,218 & 22,519 & 12,883 & 42.277 \\ \hline Carpo & & 1,050 & 1,032 & 608 & 753 \\ \hline Other & & 9,314 & 6,448 & 3,604 & 3977 \\ \hline Total eperatine & enue : & 50,52 & 29,899 & 17,095 & 47,007 \\ \hline \multicolumn{6}{|c|}{ Operatine Eypense: } \\ \hline Salaries isof rel & custs & 11,902 & 9.728 & 8.754 & 11.225 \\ \hline Aircraft foel an & lated taxes & 11,42 & 5,633 & 3,176 & 5519 \\ \hline Rezional carrie & epense & 2,051 & 5,193 & 2,49 & 3,54 \\ \hline Depreciation an & mortiralson & 2,107 & 1.995 & 2,312 & 2.581 \\ \hline Contracted int & & 3,345 & 2.420 & 1,778 & 2.641 \\ \hline A ircraft mainho & ce materials and onaside repairs & 1,02 & 1,401 & K22 & 1.751 \\ \hline Vewenger com & ions and other selling expenses & 1,891 & 953 & 582 & 1.993 \\ \hline Landing fres an & ther rents & 2,x & 2,019 & 1.518 & 1.762 \\ \hline Paxwenger sen & & 1.453 & 756 & $23 & 1.251 \\ \hline Profit sharing & & 563 & 168 & 0 & 1.643 \\ \hline Aircralt rent & & 505 & 430 & 590 & 423 \\ \hline Restructuring \& & & .124 & .19 & 8,219 & 0 \\ \hline Covernment g! & mogenition & 0 & 4,512 & 3,946 & 0 \\ \hline Oever & & 7,5mo & 1,405 & 2,9k & 3.016 \\ \hline Total epermine & anse & 46,021 & 28,013 & 20,564 & 4039 \\ \hline Cporating lnso & & 3.061 & 1,06 & 12,469 & \\ \hline \multicolumn{6}{|c|}{ Nee-Operating E.ypees: } \\ \hline Intervas expens & & 1,020 & 1,279 & -920 & .301 \\ \hline lespairmens an & juity method losses & 20 & -337 & 2,432 & -62 \\ \hline Threalined fain & as on investmente, net & -783 & 56 & -105 & 119 \\ \hline Miscellanequs, & & 85 & 72 & 348 & -176 \\ \hline Total mon-opore & expense, net & 1,747 & 1,468 & 3,118 & -420 \\ \hline Incoune Before & ane Taxes & 1,914 & 398 & 15,5k7 & 6,198 \\ \hline Income Tax Pro & & -596 & -118 & 3,202 & 1,431 \\ \hline Net Income & & 51.318 & 5250 & 5(12.385) & 54,767 \\ \hline Baic Earnings & Slare (USS per share) & $2.07 & 50.44 & 5(19.49) & 57.32 \\ \hline Dilused Eaming & er Share (USS per share) & 2.06 & 0.44 & (19.49) & 7,30 \\ \hline Cath Dividend & clared Per Share (USS per share) & 50.00 & 5000 & 50,40 & 5151 \\ \hline \end{tabular} Consolidated Statements of Ca Consolidated Balance Sheets \begin{tabular}{|c|c|c|c|c|c|} \hline Ratios & Consolidated Balance Sheets & \multicolumn{4}{|c|}{ Consolidated Statements of Oper } \\ \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ Coavelidated Statements of Operations - USD (5) 5 in Mtillioas }} & \multicolumn{3}{|c|}{12 Momths Ended } & \multirow[b]{2}{*}{ Dec. 31. 2019} \\ \hline & & Dex. 31.2022 & Dec. 31.2021 & Dec. 31.2020 & \\ \hline \multicolumn{6}{|l|}{ Pauknger! } \\ \hline Total passenger & emac & 40,218 & 22,519 & 12,883 & 42.277 \\ \hline Carpo & & 1,050 & 1,032 & 608 & 753 \\ \hline Other & & 9,314 & 6,448 & 3,604 & 3977 \\ \hline Total eperatine & enue : & 50,52 & 29,899 & 17,095 & 47,007 \\ \hline \multicolumn{6}{|c|}{ Operatine Eypense: } \\ \hline Salaries isof rel & custs & 11,902 & 9.728 & 8.754 & 11.225 \\ \hline Aircraft foel an & lated taxes & 11,42 & 5,633 & 3,176 & 5519 \\ \hline Rezional carrie & epense & 2,051 & 5,193 & 2,49 & 3,54 \\ \hline Depreciation an & mortiralson & 2,107 & 1.995 & 2,312 & 2.581 \\ \hline Contracted int & & 3,345 & 2.420 & 1,778 & 2.641 \\ \hline A ircraft mainho & ce materials and onaside repairs & 1,02 & 1,401 & K22 & 1.751 \\ \hline Vewenger com & ions and other selling expenses & 1,891 & 953 & 582 & 1.993 \\ \hline Landing fres an & ther rents & 2,x & 2,019 & 1.518 & 1.762 \\ \hline Paxwenger sen & & 1.453 & 756 & $23 & 1.251 \\ \hline Profit sharing & & 563 & 168 & 0 & 1.643 \\ \hline Aircralt rent & & 505 & 430 & 590 & 423 \\ \hline Restructuring \& & & .124 & .19 & 8,219 & 0 \\ \hline Covernment g! & mogenition & 0 & 4,512 & 3,946 & 0 \\ \hline Oever & & 7,5mo & 1,405 & 2,9k & 3.016 \\ \hline Total epermine & anse & 46,021 & 28,013 & 20,564 & 4039 \\ \hline Cporating lnso & & 3.061 & 1,06 & 12,469 & \\ \hline \multicolumn{6}{|c|}{ Nee-Operating E.ypees: } \\ \hline Intervas expens & & 1,020 & 1,279 & -920 & .301 \\ \hline lespairmens an & juity method losses & 20 & -337 & 2,432 & -62 \\ \hline Threalined fain & as on investmente, net & -783 & 56 & -105 & 119 \\ \hline Miscellanequs, & & 85 & 72 & 348 & -176 \\ \hline Total mon-opore & expense, net & 1,747 & 1,468 & 3,118 & -420 \\ \hline Incoune Before & ane Taxes & 1,914 & 398 & 15,5k7 & 6,198 \\ \hline Income Tax Pro & & -596 & -118 & 3,202 & 1,431 \\ \hline Net Income & & 51.318 & 5250 & 5(12.385) & 54,767 \\ \hline Baic Earnings & Slare (USS per share) & $2.07 & 50.44 & 5(19.49) & 57.32 \\ \hline Dilused Eaming & er Share (USS per share) & 2.06 & 0.44 & (19.49) & 7,30 \\ \hline Cath Dividend & clared Per Share (USS per share) & 50.00 & 5000 & 50,40 & 5151 \\ \hline \end{tabular}