Answer the following Questions based on the information given in the table.

Q1. Perform profitability analysis by calculating ROS and ROE. Calculate gross profit margin, operating margin and net profit margin for ROS. Interpret your findings. Are these retailers profitable enough to justify the accusations directed at them? Is their profitability increasing over time? Which retailer is the most profitable and which one is the least profitable? Compare them.

Hello, I have the final answers in numbers, but I need a detailed answer (what is the equation used, why and the method of calculation to get the final answer) If you use the Exel program, I hope that there is an explanation for the answer and not just numbers

Financial Information for 3 Supermarket Chains Financial Information for 3 Supermarket Chains