Question
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.
\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
Get Instant Access with AI-Powered 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