Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A) Using the info given in the table below, calculate the following ratios per year: gross profit margin, account receivable turnover ratio (using account receivable

A) Using the info given in the table below, calculate the following ratios per year: gross profit margin, account receivable turnover ratio (using account receivable at the end of the year), net income profit margin, current ratio, return on equity, acid test ratio, inventory turnover ratio (using the inventories at the end of the year), fixed assets turnover ratio.

B) State the formulas for all ratios of question A. Analyze their meaning and significance. Categorize them according their use and construction.

C) Comment firms performance over the last two years using the ratios you calculated above and any other useful info that you consider important to support your rationale.

RQD: Write down in detail all calculations and processes applied during the solution.

image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{B/S} \\ \hline Assets & 2022 & 2021 & \begin{tabular}{|l|} Liabilities \& \\ Stockholders' Equity \end{tabular} & 2022 & 2021 \\ \hline Fixed assets: & & & Stockholder's equity: & & \\ \hline Property, plant and equipment & 4190,00 & 3580,00 & Common stock & 2640,00 & 1540,00 \\ \hline Less accumulated depreciation & 390,00 & 240,00 & Retained eamings & 3740,00 & 3410,00 \\ \hline Net property, plant and equipment & 3800,00 & 3340,00 & Total stockholders' equity & 6380,00 & 4950,00 \\ \hline Total fixed assets & 3800,00 & 3340,00 & Current liabilities & & \\ \hline \begin{tabular}{|l|l|} Cash and cash equivalents \\ \end{tabular} & 165,00 & 310,00 & & & \\ \hline \begin{tabular}{|c|} Accounts receivables \\ \end{tabular} & 1485,00 & 1130,00 & Notes payable & 560,00 & 510,00 \\ \hline Inventory & 2100,00 & 1220,00 & Accrued expenses & 320,00 & 270,00 \\ \hline Total current assets & 3750,00 & 2660,00 & Taxes payable & 290,00 & 270,00 \\ \hline & & & Total current liabilities & 1170,00 & 1050,00 \\ \hline & & & Total liabilities & 1170,00 & 1050,00 \\ \hline Total assets & 7550,00 & 6000,00 & \begin{tabular}{|l|} Total liabilities \& \\ stockholders' equity \end{tabular} & 7550,00 & 6000,00 \\ \hline I/S & 2022 & 2021 & & & \\ \hline Sales & 7650 & 5770 & & & \\ \hline Cost of goods & 5450 & 3900 & & & \\ \hline Gross margin & 2200 & 1870 & & & \\ \hline Selling expenses & 900 & 660 & & & \\ \hline General and administrative expenses & 1100 & 890 & & & \\ \hline Income before taxes & 200 & 320 & & & \\ \hline Income taxes & 130 & 110 & & & \\ \hline Net income & 70 & 210 & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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 Finance questions