1 In this session, we will construct an MS-Excel version of the DuPont System for analyzing financial ratios using company's financial statements. Lecture note 4 that is posted in Content explains how the DuPont system works. It also has information on other financial ratios. Please study and review it first. By using this methodology, you will learn how to improve ROE; The DuPont equation, which is determined by algebraic relationships between various ratios and balance sheet data, allows you to easily see the impact of changes in these values on ROE, etc. You will work on an MS-Excel file and automate the calculation of ROE using the DuPont equation. The MS- Excel file is uploaded in this discussion as well as in Content. 1. Calculate the 2019 total assets turnover. 2. Calculate the 2019 profit margin and the return on equity (ROE). 3. Use the DuPont equation to provide a summary and overview of the company's financial condition as projected for 2019. 4. How would the company management use the DuPont equation to improve the company performance? 1 In this session, we will construct an MS-Excel version of the DuPont System for analyzing financial ratios using company's financial statements. Lecture note 4 that is posted in Content explains how the DuPont system works. It also has information on other financial ratios. Please study and review it first. By using this methodology, you will learn how to improve ROE; The DuPont equation, which is determined by algebraic relationships between various ratios and balance sheet data, allows you to easily see the impact of changes in these values on ROE, etc. You will work on an MS-Excel file and automate the calculation of ROE using the DuPont equation. The MS- Excel file is uploaded in this discussion as well as in Content. 1. Calculate the 2019 total assets turnover. 2. Calculate the 2019 profit margin and the return on equity (ROE). 3. Use the DuPont equation to provide a summary and overview of the company's financial condition as projected for 2019. 4. How would the company management use the DuPont equation to improve the company performance