The table below display some of the key thanol ratios calculated for Marks & Spencer Group PLC during the last five years Discuss the ROE Decomposition of the company and evaluate the drivers of its performance during this period. What trends can you identify in the company's performance? What do you believe will be the effect of the current crisis on the company's financial statemente? Marks & Spencer Group PLC (MKS IN) In Millions of USD except Per Share FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Est FY 2002. EX 12 Months Ending 04/02/2016 04/01/2017 03/31/2018 03/30/2010 03/20/2000/31/2001 3/34/2002 Profit margin 3.85 1.10 0.24 0.40 023 1.22 2.56 Asset Turnover 1.27 1.27 1.35 1.27 1.07 Financial Leverage 2.51 2.54 2.59 3.02 3.08 Return on Common Equity 12.25 3 56 0.84 1.54 0.77 3.00 7.07 Effective Tax Rate 17.27 34.41 56.44 46.20 59.23 Net Interest Expense 143,4 122.3 118.6 290.0 268.6 Revenue 15,913.9 13,882.1 14,193.5 13,623.5 12,9480 12,113.1 13,168.1 Net Operating Profit after Tax (NOPAT) 734.6 222.0 191.8 205.4 106.5 Working Capital -914.9 -808.6 -713.1 - 1.156.1 -7875 Total Non-Current Assets 9,975.3 8,239.1 8,746.4 9,635.5 11.133.1 Net Debt 2,567.4 2,190.6 2.210.1 5,061.7 4,B5B.9 4,595.0 4,380.1 Net Assets 4,896.5 3,951.2 4.145.9 3,208.2 4,603.4 Total Equity 4,896.5 3,951.2 4,145.9 3,208.2 4,603.4 Total Equay Working Capital to Sales Net Fixed Asset Turnover Accounts Payable Turnover Days Days Sales Outstanding - DSO Inventory Days Cash Ratio Quick Ratio Current Ratio Total Debt to Total Equity Net Interest Coverage Cash From Operations Cash from Investing Activities Cash from Financing Activities Dividends Paid Capital Expenditures CFO to Sales CFO to Total Debt Gross Margin Operating Margin Profit Margin Source: Bloomberg -0.00 -0.00 -0.06 0.07 0.07 2.10 2.15 2 1.83 57.40 10.19 44.0 41.73 4.21 3 3.80 4.09 4.74 40.11 43.41 42.13 41.11 3433 0.13 0.20 0.12 0.10 0.14 0.18 0.25 0.18 0.23 0.22 0.69 0.73 0.72 0.02 0. 60.18 70.78 50.80 175.07 112.78 6.17 2.91 1.35 1.28 1,666.4 1.258.7 986.5 1.343.1 9055 -878.8 494,8 -427.6 -519.1 -9859 -775.2 -4892 -871.0 -768.8 40.9 .454.9 493.4 4025 -3984 -243.0 -5477 -404.0 -364.7 -285 9 319.2 10.47 9.07 6.95 9.86 7.46 0.53 0.43 0.41 0.18 0.24 39.11 38.48 37.83 36.BO 35.28 5.53 2.48 1.46 2.38 2.87 3.85 0.23 0.24 1.10 0.40 Right click to show data transparency (not supported for all values) 2470 430.3 2.98 4.70 1.22 2.56 The table below display some of the key thanol ratios calculated for Marks & Spencer Group PLC during the last five years Discuss the ROE Decomposition of the company and evaluate the drivers of its performance during this period. What trends can you identify in the company's performance? What do you believe will be the effect of the current crisis on the company's financial statemente? Marks & Spencer Group PLC (MKS IN) In Millions of USD except Per Share FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Est FY 2002. EX 12 Months Ending 04/02/2016 04/01/2017 03/31/2018 03/30/2010 03/20/2000/31/2001 3/34/2002 Profit margin 3.85 1.10 0.24 0.40 023 1.22 2.56 Asset Turnover 1.27 1.27 1.35 1.27 1.07 Financial Leverage 2.51 2.54 2.59 3.02 3.08 Return on Common Equity 12.25 3 56 0.84 1.54 0.77 3.00 7.07 Effective Tax Rate 17.27 34.41 56.44 46.20 59.23 Net Interest Expense 143,4 122.3 118.6 290.0 268.6 Revenue 15,913.9 13,882.1 14,193.5 13,623.5 12,9480 12,113.1 13,168.1 Net Operating Profit after Tax (NOPAT) 734.6 222.0 191.8 205.4 106.5 Working Capital -914.9 -808.6 -713.1 - 1.156.1 -7875 Total Non-Current Assets 9,975.3 8,239.1 8,746.4 9,635.5 11.133.1 Net Debt 2,567.4 2,190.6 2.210.1 5,061.7 4,B5B.9 4,595.0 4,380.1 Net Assets 4,896.5 3,951.2 4.145.9 3,208.2 4,603.4 Total Equity 4,896.5 3,951.2 4,145.9 3,208.2 4,603.4 Total Equay Working Capital to Sales Net Fixed Asset Turnover Accounts Payable Turnover Days Days Sales Outstanding - DSO Inventory Days Cash Ratio Quick Ratio Current Ratio Total Debt to Total Equity Net Interest Coverage Cash From Operations Cash from Investing Activities Cash from Financing Activities Dividends Paid Capital Expenditures CFO to Sales CFO to Total Debt Gross Margin Operating Margin Profit Margin Source: Bloomberg -0.00 -0.00 -0.06 0.07 0.07 2.10 2.15 2 1.83 57.40 10.19 44.0 41.73 4.21 3 3.80 4.09 4.74 40.11 43.41 42.13 41.11 3433 0.13 0.20 0.12 0.10 0.14 0.18 0.25 0.18 0.23 0.22 0.69 0.73 0.72 0.02 0. 60.18 70.78 50.80 175.07 112.78 6.17 2.91 1.35 1.28 1,666.4 1.258.7 986.5 1.343.1 9055 -878.8 494,8 -427.6 -519.1 -9859 -775.2 -4892 -871.0 -768.8 40.9 .454.9 493.4 4025 -3984 -243.0 -5477 -404.0 -364.7 -285 9 319.2 10.47 9.07 6.95 9.86 7.46 0.53 0.43 0.41 0.18 0.24 39.11 38.48 37.83 36.BO 35.28 5.53 2.48 1.46 2.38 2.87 3.85 0.23 0.24 1.10 0.40 Right click to show data transparency (not supported for all values) 2470 430.3 2.98 4.70 1.22 2.56