Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed. 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 case

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago