Please only do the following:
Ratio Analysis
Using Excel, (1) calculate the following financial ratios for the last three years (2021, 2022, and 2023) and
(2) discuss and interpret the ratios in each category:
Profitability:
Profit Margin
Return On Assets (ROA)
Return On Equity (ROE)
Return on Capital Employed
Gross Margin Ratio
Efficiency:
Asset Turnover
Receivables Turnover
Inventory Turnover
Average Collection Period
Average Days in Inventory
Discuss any potential weak performance and risk based on your calculations of the ratios for the two companies.
Are there any factors that could be erroneously influencing the results of the ratios you have calculated?