80.2K

Verified Solution

Link Copied!

Sumner Corporation BALANCE SHEET (S millions) 202

Calculate all of the provided profitability, turnover-control, and leverage/liquidity ratios for the four years indicated. Your reponses should be carried out to one decimal place. Credit for your work will be based upon the use of Excel formulas and correct answers. Identify and describe two trends you discern for each of the three categories of ratios. b. Comments Sumner Corporation BALANCE SHEET (S millions) INCOME STATEMENT ( $ millions, except per share) \begin{tabular}{|l|r|r|r|r|} \hline Sales & 2020 & 2021 & 2022 & 2023 \\ \hline Cost of Goods Sold & 37,100 & 38,500 & 35,350 & 36,900 \\ \hline Gross Profit & 21,400 & 21,800 & 21,643 & 25,052 \\ \hline Selling, General, \& Administrative & 15,700 & 16,700 & 13,707 & 11,848 \\ \hline Operating Profit & 5,137 & 5,189 & 1,875 & 1,416 \\ \hline Interest Expense & 59 & 54 & 49 & 89 \\ \hline Other Expense & 5,274 & 5,069 & 1,904 & 1,188 \\ \hline Pretax Income & 646 & 2,392 & 772 & 348 \\ \hline Provision for Taxes & 4,628 & 2,677 & 1,132 & 840 \\ \hline Net Income & 2.82 & 1.67 & 0.72 & 0.54 \\ \hline EPS & & & & \\ \hline \end{tabular} Calculate all of the provided profitability, turnover-control, and leverage/liquidity ratios for the four years indicated. Your reponses should be carried out to one decimal place. Credit for your work will be based upon the use of Excel formulas and correct answers. Identify and describe two trends you discern for each of the three categories of ratios. b. Comments Sumner Corporation BALANCE SHEET (S millions) INCOME STATEMENT ( $ millions, except per share) \begin{tabular}{|l|r|r|r|r|} \hline Sales & 2020 & 2021 & 2022 & 2023 \\ \hline Cost of Goods Sold & 37,100 & 38,500 & 35,350 & 36,900 \\ \hline Gross Profit & 21,400 & 21,800 & 21,643 & 25,052 \\ \hline Selling, General, \& Administrative & 15,700 & 16,700 & 13,707 & 11,848 \\ \hline Operating Profit & 5,137 & 5,189 & 1,875 & 1,416 \\ \hline Interest Expense & 59 & 54 & 49 & 89 \\ \hline Other Expense & 5,274 & 5,069 & 1,904 & 1,188 \\ \hline Pretax Income & 646 & 2,392 & 772 & 348 \\ \hline Provision for Taxes & 4,628 & 2,677 & 1,132 & 840 \\ \hline Net Income & 2.82 & 1.67 & 0.72 & 0.54 \\ \hline EPS & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer