Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. Please answer this in excel format Qument liabilities MASH Ine. Stakement of lncome for the year ended December 31, Coat of qoods sold Groes
. Please answer this in excel format
Qument liabilities MASH Ine. Stakement of lncome for the year ended December 31, Coat of qoods sold Groes margin \begin{tabular}{|r|r|} \hline 2022 & 2021 \\ \hline$1,500,000 & \\ \hline 900,000 & $1,390,000 \\ \hline 600,000 & 764,800 \\ \hline & 625,500 \\ \hline \end{tabular} Operating expenses Advertising and promotion Bark charpes Depreciation (nobe 1) Ingurance Interest otice Pepairs and maintenance Telecommunications Ublities Qperating income Oher income (expenses) \begin{tabular}{|l} \hline Net ind \\ \hline Incomse \\ \hline Net inc \\ \hline Nobe 1 \\ \hline \end{tabular} Logs on sale of equipmont or the $70,000 depreciation expense, $50,000 relates to the bullding and $20,000 relates to the equipment. Regulred: a) Calculate EACH of the following ratios for 2022 AND briefly explain what the matio means: i. Quick matio ii. Inwentory bumover a). 1. Calculate the gross margin percentape for both 2022 and 2021 . ii. Is it improving or declining? iii. Provide CNE explanation as to why that may be the case. Qument liabilities MASH Ine. Stakement of lncome for the year ended December 31, Coat of qoods sold Groes margin \begin{tabular}{|r|r|} \hline 2022 & 2021 \\ \hline$1,500,000 & \\ \hline 900,000 & $1,390,000 \\ \hline 600,000 & 764,800 \\ \hline & 625,500 \\ \hline \end{tabular} Operating expenses Advertising and promotion Bark charpes Depreciation (nobe 1) Ingurance Interest otice Pepairs and maintenance Telecommunications Ublities Qperating income Oher income (expenses) \begin{tabular}{|l} \hline Net ind \\ \hline Incomse \\ \hline Net inc \\ \hline Nobe 1 \\ \hline \end{tabular} Logs on sale of equipmont or the $70,000 depreciation expense, $50,000 relates to the bullding and $20,000 relates to the equipment. Regulred: a) Calculate EACH of the following ratios for 2022 AND briefly explain what the matio means: i. Quick matio ii. Inwentory bumover a). 1. Calculate the gross margin percentape for both 2022 and 2021 . ii. Is it improving or declining? iii. Provide CNE explanation as to why that may be the caseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started