Assignment
Required Part II - Module Six:The purpose of the second part of the comprehensive project is to compute financial statement ratios.Use the Library's research guide to get started on Part IIhttps://libguides.excelsior.edu.vlib.excelsior.edu/bus500A. Based on formulas given in Appendix B, compute the following ratios in Excel for two years.
1. Debt ratio
2. Gross profit margin
3. Free cash flow
4. Times interest earned
5. Accounts receivable turnover
6. Inventory turnoverB. Prepare a DuPont Analysis of ROE for two years, including computations of
1. Return on Sales
2. Asset Turnover
3. Return on Assets
4. Financial Leverage
5. Return on EquityC. Briefly evaluate the ratio trends. Indicate on your worksheet whether each ratio is:1. stronger / weaker2. quicker /slower3.