Indicate and explain the profitability and the DuPont relationship. Create DuPont Analysis (In Excel) based on the data shown below.

• Profitability explain the relationship between the ROA (Profitability) and the DuPont Analysis. How it influences the ROE?

• ROE - explain the relationship between the ROE (Profitability) and the DuPont Analysis. Analyze the trend and changes it had. Good or bad? Explain why. Summarize your financial analysis. ROE should be the last step in this paper.

2011-03 2012-03 2013-03 2014-03 2015-03 2016-03 2017-03 2018-03 2019-03 2020-03 TTM Profitability Tax Rate % 32.80 52.73 36.61 34.66 30.41 36.05 32.53 30.95 35.44 41.43 5.98 2.66 3.72 4.85 3.82 2.36 4.40 6.90 3.84 3.05 1.90 0.77 0.68 0.78 0.81 0.78 0.80 0.75 0.80 0.80 0.73 0.64 4.60 1.81 2.89 3.92 2.99 1.88 3.32 5.53 3.07 2.23 1.21 Net Margin % Asset Turnover (Average) Return on Assets % Financial Leverage (Average) Return on Equity % Return on Invested Capital % Interest Coverage 2.60 2.68 2.71 2.64 2.59 2.70 2.60 2.44 2.47 2.55 2.55 12.17 4.78 7.78 10.48 7.82 4.97 8.77 13.91 7.53 5.60 3.01 6.15 2.27 3.89 5.22 3.93 2.49 4.40 7.21 3.86 2.83 1.55 75.41 25.80 41.21 58.38 45.31 36.02 81.75 86.97 75.10 32.99 21.42 2011-03 2012-03 2013-03 2014-03 2015-03 2016-03 2017-03 2018-03 2019-03 2020-03 TTM Profitability Tax Rate % 32.80 52.73 36.61 34.66 30.41 36.05 32.53 30.95 35.44 41.43 5.98 2.66 3.72 4.85 3.82 2.36 4.40 6.90 3.84 3.05 1.90 0.77 0.68 0.78 0.81 0.78 0.80 0.75 0.80 0.80 0.73 0.64 4.60 1.81 2.89 3.92 2.99 1.88 3.32 5.53 3.07 2.23 1.21 Net Margin % Asset Turnover (Average) Return on Assets % Financial Leverage (Average) Return on Equity % Return on Invested Capital % Interest Coverage 2.60 2.68 2.71 2.64 2.59 2.70 2.60 2.44 2.47 2.55 2.55 12.17 4.78 7.78 10.48 7.82 4.97 8.77 13.91 7.53 5.60 3.01 6.15 2.27 3.89 5.22 3.93 2.49 4.40 7.21 3.86 2.83 1.55 75.41 25.80 41.21 58.38 45.31 36.02 81.75 86.97 75.10 32.99 21.42