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
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. (40 marks) Q2. Calculate annual sales growth, cost of sales growth and net profit growth for all retailers. Interpret the growth rates in the light of an assumed 20% annual inflation rate. Is there real growth in any of these areas? (20 marks) Q3. Calculate liquidity and leverage ratios for these retailers and interpret them by making comparisons. (20 marks) Q5. 1en us about nsks involvea in a typical nnancial market and business environment. ( 20marks) 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. ( 40 marks) Q2. Calculate annual sales growth, cost of sales growth and net profit growth for all retailers. Interpret the growth rates in the light of an assumed 20% annual inflation rate. Is there real growth in any of these areas? (20 marchs) Q3. Calculate liquidity and leverage ratios for these retailers and interpret them by making comparisons. (20 marks) Q4. There are other chain markets such as A101, Hakmar etc. Can we find their financial statements and perform the same analysis for these private companies? If the answer is yes, how? If no, why? (20 marks) Q5. Tell us about 5 risks imvolved in a typical financial market and business environment. ( 20 marks) 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. (40 marks) Q2. Calculate annual sales growth, cost of sales growth and net profit growth for all retailers. Interpret the growth rates in the light of an assumed 20% annual inflation rate. Is there real growth in any of these areas? (20 marks) Q3. Calculate liquidity and leverage ratios for these retailers and interpret them by making comparisons. (20 marks) Q5. 1en us about nsks involvea in a typical nnancial market and business environment. ( 20marks) 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. ( 40 marks) Q2. Calculate annual sales growth, cost of sales growth and net profit growth for all retailers. Interpret the growth rates in the light of an assumed 20% annual inflation rate. Is there real growth in any of these areas? (20 marchs) Q3. Calculate liquidity and leverage ratios for these retailers and interpret them by making comparisons. (20 marks) Q4. There are other chain markets such as A101, Hakmar etc. Can we find their financial statements and perform the same analysis for these private companies? If the answer is yes, how? If no, why? (20 marks) Q5. Tell us about 5 risks imvolved in a typical financial market and business environment. ( 20 marks)