Rules of Play

The balance sheet items may not balance perfectly (they may be out ~$1) due to rounding error.

USE EXCEL to calculate the solutions and do the math calculators may throw off your rounding.

You will be asked to submit the sheet you used to solve the homework. If you dont submit an excel sheet that has the problem

set in it, it will not be graded.

If you use Google Sheets - download the file as an Excel attachment and submit that. Do not submit a Google Sheet - they can

be changed after submission which creates grading transparency problems.

Submit percentages as the percentage followed by two decimals. A number that appears as .04567 in Excel should be

submitted as 4.57%.

Responses will be marked correct if they are within 5% of the answer I calculated in Excel

1. What is company 1's Operating Profit Margin 2023

2. What is company 1's Net Profit Margin 2022

3. What is company 3's Debt to Assets Ratio 2022

4. What is company 2's Operating Profit Margin 2023

5. What is company 2's Return on Equity (ROE) 2022

6. What is company 1's Quick Ratio 2023

7. What is company 1's Return on Equity (ROE) 2022

8. What is company 3's Debt to Equity Ratio 2023

9. What is company 3's Current Ratio 2023

10. What is company 2's Inventory turnover 2023

***please help with excel formulas***

\begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Company 1} & \multicolumn{2}{|c|}{ Company 2} & \multicolumn{2}{|c|}{ Company 3} \\ \hline & 2022 & 2023 & 2022 & 2023 & 2022 & 2023 \\ \hline Revenue & 5674 & 5965 & 176896 & 144045 & 179083 & 264906 \\ \hline coss & 3442 & 3618 & 144924 & 118010 & 144249 & 213378 \\ \hline Gross Profit & 2232 & 2346 & 31972 & 26034 & 34834 & 51527 \\ \hline EBITDA & 1470 & 1363 & 7962 & 5956 & 15990 & 50104 \\ \hline Taxes & 510 & 792 & 6522 & 1362 & 4309 & 48720 \\ \hline Net Income. & 960 & 571 & 1440 & 4593 & 11681 & 1383 \\ \hline Total Assets & 5255 & 5524 & 275936 & 224692 & 244587 & 361802 \\ \hline Equity & 3084 & 3652 & 13442 & 42330 & 89999 & 176402 \\ \hline Current Assets & 3145 & 3211 & 62923 & 51408 & 91387 & 351809 \\ \hline Current Liahalities & 873 & 507 & 53604 & 12264 & 85373 & 83014 \\ \hline Inventory & 221 & 1866 & 10271 & 11761 & 13799 & 342091 \\ \hline Long-Term Debt & 1298 & 1364 & 208890 & 170097 & 69215 & 102385 \\ \hline \end{tabular}