Please, help me solve this problem. I can't figure out how to do this
5. Analysis and interpretation of financial ratios (6 marks) > Based on the financial reports and other information, prepare an analysis that covers the past three financial years ending December 2017, 2018 and 2019, concentrating on the following aspects: Profitability (2 marks) 2019 Profitability Profitability on Shareholders' Equity * 100% Profit after Income Tax Average Total Equity 33,205,007 263,352,409 * 100% = 12.61% Retum on Assets Profit before Interest & Tax * 100% Average Total Assets 100% 11.10 = 42.891.518 386 551,320 C: in F1 Column Word Gross Profit Margin Gross Profit 100 % Sales Revenue 100 % 122 557,517 651,314,172 18.82% Net Profit Margin = Profit before Interest & Tax 100 % Sales Revenue 100 6 = 6.39% = +2.891 518- 651 314.172 + profitability Ratice 9 or shareholdere Equity Thuages about Return your -4100 16353001 188062304 182784067 2 6C17 = 8817 Return on herete G. 16104076 1001 Average Total Assets 23 41 5424 + 235.56837) 7.097 G. Gos profit margin- Guadeft ,00 10889808 63949048 X700 17.027 og Net profit imagin. Net income Net Income X700 fale 25848262 -X700 63949048 = 4:06% Geroup 2017 Return of shareholder equity 28,462 125 x100 (256 023,6680 +234,209 229) Aloo 28.462,125 2452119585 11.6. Return on assets xloo = 38, 636,983 . (380 660,322 + 364 153,690 10.37.1 Gross profit margin - 17,704 085X100 615, 789, 116. 19.11 @ Net pott margin =_38,636,983 1004 615, 789, 116 6.271 5. Analysis and interpretation of financial ratios (6 marks) > Based on the financial reports and other information, prepare an analysis that covers the past three financial years ending December 2017, 2018 and 2019, concentrating on the following aspects: Profitability (2 marks) 2019 Profitability Profitability on Shareholders' Equity * 100% Profit after Income Tax Average Total Equity 33,205,007 263,352,409 * 100% = 12.61% Retum on Assets Profit before Interest & Tax * 100% Average Total Assets 100% 11.10 = 42.891.518 386 551,320 C: in F1 Column Word Gross Profit Margin Gross Profit 100 % Sales Revenue 100 % 122 557,517 651,314,172 18.82% Net Profit Margin = Profit before Interest & Tax 100 % Sales Revenue 100 6 = 6.39% = +2.891 518- 651 314.172 + profitability Ratice 9 or shareholdere Equity Thuages about Return your -4100 16353001 188062304 182784067 2 6C17 = 8817 Return on herete G. 16104076 1001 Average Total Assets 23 41 5424 + 235.56837) 7.097 G. Gos profit margin- Guadeft ,00 10889808 63949048 X700 17.027 og Net profit imagin. Net income Net Income X700 fale 25848262 -X700 63949048 = 4:06% Geroup 2017 Return of shareholder equity 28,462 125 x100 (256 023,6680 +234,209 229) Aloo 28.462,125 2452119585 11.6. Return on assets xloo = 38, 636,983 . (380 660,322 + 364 153,690 10.37.1 Gross profit margin - 17,704 085X100 615, 789, 116. 19.11 @ Net pott margin =_38,636,983 1004 615, 789, 116 6.271
