90.2K

Verified Solution

Link Copied!

Submit a Ratio analysis for the years 2019, 2020, and 2021 based off of the data

Horizontal Analysis of Income Statement \begin{tabular}{|r|r|r|r|r|} \hline 2018 & 2019 & 2020 & 2021 & 2022 \\ \hline 38.46408 & 102.7581 & 85.92898 & 68.50537 \\ \hline-11.9601 & -14.6179 & -23.8372 & -29.7342 \\ \hline-8.02876 & -7.13002 & 8.02876 & 34.27202 \\ \hline 3.21558 & 10.88768 & 28.75906 & 62.20109 \\ \hline 246.1059 & 218.6916 & 308.7227 & 366.9782 \\ \hline 15.75238 & 38.59727 & 45.42363 & 61.15136 \\ \hline 6.142981 & 10.8023 & 19.36385 & 25.22738 \\ \hline 19.18605 & 230.3488 & 293.1395 & 370.9302 \\ \hline 11.19275 & 36.0662 & -3.82562 & 57.15405 \\ \hline 3.933434 & 26.11907 & 44.86073 & 58.83243 \\ \hline-60.7214 & 20.40748 & 36.60655 & 46.32599 \\ \hline 4.068117 & 31.78808 & 58.08893 & 80.7947 \\ \hline 1801.111 & 1956.667 & 2168.889 & 2315.556 \\ \hline-62.4145 & -96.751 & -72.6744 & -97.5034 \\ \hline-80.9639 & -81.2851 & -77.1034 & -71.8323 \\ \hline \end{tabular} Total Current Liabilities Other Liabilities Long Term Debt Excluding Current Position \begin{tabular}{|l|l|l|l} -21.0113 & 15.83166 & 3.160166 & -0.04625 \\ \hline \end{tabular} 5 Long Term Operating Lease 26 Other Long Term Liabilities 27 Total Liabilities \begin{tabular}{|c|r|r|r|} \hline-89.0717 & -85.4664 & -81.8612 & -80.8097 \\ \hline 7.534172 & 32.90655 & 48.55556 & 56.95531 \\ \hline \end{tabular} 28 Equity 29. Preferred Stocks - Authorized 30 Preferred Stocks - Issued and Outstanding 31 Common Share - Authorized 32 Shares Issued and Outstanding \begin{tabular}{ll|r|r|r|c|} \hline 33 & & & & & \\ & & & \\ 34 & Additional Paid in Capital & 5.076142 & 9.677419 & 15.13018 & 12.7231 \\ \hline 35 & Accumulated Other Comprehensive Loss & 19.76647 & 8.173478 & -5.17098 & 52.54376 \\ 36 & Retained Earning & 30.06213 & 63.17992 & 47.91429 & 97.60365 \\ 37 & Total Cost to Stockholder Equity & 19.09524 & 42.87054 & 37.22947 & 61.27822 \\ 38 & Non-Controlling Interest & 12.17105 & 38.48684 & 69.07895 & -98.3553 \\ 39 & Total Equiy & 18.9346 & 42.75357 & -15.4697 & 57.5746 \end{tabular} Horizontal Financial Statement Vertical Financial Statement Ratio Analysis Financial Statement Liquidity and Solvency Ratios CurrentRatioQuickRatioDebtEquityRatioFinancialLeverage2020130.640.642.9720211.0020.520.653.28 Profitability Ratios \begin{tabular}{llrr|} \hline & 2020 & 2021 \\ \hline 12 & Operating Profit & 3.26% & 3.42% \\ 13 & Net Profit Ratio & 2.43% & 2.59% \\ 14 & Return to Equity & 21.70% & 28.09% \\ 15 & ROCE & 17.70% & 22.49% \end{tabular} Liquidity Ratio Solvency Ratio Efficiency Ratios Profitability Ratios Horizontal Analysis of Income Statement \begin{tabular}{|r|r|r|r|r|} \hline 2018 & 2019 & 2020 & 2021 & 2022 \\ \hline 38.46408 & 102.7581 & 85.92898 & 68.50537 \\ \hline-11.9601 & -14.6179 & -23.8372 & -29.7342 \\ \hline-8.02876 & -7.13002 & 8.02876 & 34.27202 \\ \hline 3.21558 & 10.88768 & 28.75906 & 62.20109 \\ \hline 246.1059 & 218.6916 & 308.7227 & 366.9782 \\ \hline 15.75238 & 38.59727 & 45.42363 & 61.15136 \\ \hline 6.142981 & 10.8023 & 19.36385 & 25.22738 \\ \hline 19.18605 & 230.3488 & 293.1395 & 370.9302 \\ \hline 11.19275 & 36.0662 & -3.82562 & 57.15405 \\ \hline 3.933434 & 26.11907 & 44.86073 & 58.83243 \\ \hline-60.7214 & 20.40748 & 36.60655 & 46.32599 \\ \hline 4.068117 & 31.78808 & 58.08893 & 80.7947 \\ \hline 1801.111 & 1956.667 & 2168.889 & 2315.556 \\ \hline-62.4145 & -96.751 & -72.6744 & -97.5034 \\ \hline-80.9639 & -81.2851 & -77.1034 & -71.8323 \\ \hline \end{tabular} Total Current Liabilities Other Liabilities Long Term Debt Excluding Current Position \begin{tabular}{|l|l|l|l} -21.0113 & 15.83166 & 3.160166 & -0.04625 \\ \hline \end{tabular} 5 Long Term Operating Lease 26 Other Long Term Liabilities 27 Total Liabilities \begin{tabular}{|c|r|r|r|} \hline-89.0717 & -85.4664 & -81.8612 & -80.8097 \\ \hline 7.534172 & 32.90655 & 48.55556 & 56.95531 \\ \hline \end{tabular} 28 Equity 29. Preferred Stocks - Authorized 30 Preferred Stocks - Issued and Outstanding 31 Common Share - Authorized 32 Shares Issued and Outstanding \begin{tabular}{ll|r|r|r|c|} \hline 33 & & & & & \\ & & & \\ 34 & Additional Paid in Capital & 5.076142 & 9.677419 & 15.13018 & 12.7231 \\ \hline 35 & Accumulated Other Comprehensive Loss & 19.76647 & 8.173478 & -5.17098 & 52.54376 \\ 36 & Retained Earning & 30.06213 & 63.17992 & 47.91429 & 97.60365 \\ 37 & Total Cost to Stockholder Equity & 19.09524 & 42.87054 & 37.22947 & 61.27822 \\ 38 & Non-Controlling Interest & 12.17105 & 38.48684 & 69.07895 & -98.3553 \\ 39 & Total Equiy & 18.9346 & 42.75357 & -15.4697 & 57.5746 \end{tabular} Horizontal Financial Statement Vertical Financial Statement Ratio Analysis Financial Statement Liquidity and Solvency Ratios CurrentRatioQuickRatioDebtEquityRatioFinancialLeverage2020130.640.642.9720211.0020.520.653.28 Profitability Ratios \begin{tabular}{llrr|} \hline & 2020 & 2021 \\ \hline 12 & Operating Profit & 3.26% & 3.42% \\ 13 & Net Profit Ratio & 2.43% & 2.59% \\ 14 & Return to Equity & 21.70% & 28.09% \\ 15 & ROCE & 17.70% & 22.49% \end{tabular} Liquidity Ratio Solvency Ratio Efficiency Ratios Profitability Ratios

Answer & Explanation Solved by verified expert

See Answer