In the excel file, you will solve for this under what is listed as Data Analysis

1. Calculate the fundamental liquidity, financial leverage, asset utilization, and profitability ratios for fiscal 2021 and 2020. HINT: You will need additional years of data to calculate all of the ratios for the specified years. 1.2. Calculate the additional returns and reinvestment ratios, the additional growth calculations, and the additional fixed assets ratios for 2021 and 2020. 1.3. Calculate the components of the basic and extended DuPont ratio analyses. 2. Utilize one or more of the sources listed below to obtain industry data to compare to the specified company. 2.1. Mergent 2.2. eStatement Studies 2.3. Other sources which are documented and appropriate 3. Present the raw data and calculated ratios in a table utilizing the example posted in D2L. 4. Prepare and present the DuPont and extended DuPont analyses in a manner similar to the example posted in D2L. 5. Prepare a written analysis of the ratios. 5.1. Discuss the most important reasons behind the changes in the fundamental ratios and evaluate the levels and trends in the fundamental ratios. Calculating percentage changes in underlying accounts may be helpful. 5.2. Discuss the most important reasons behind the changes in the additional ratios as appropriate and evaluate the levels and trends in the additional ratios as appropriate. Calculating percentage changes in underlying accounts may be helpful. 5.3. Incorporate the effects of the observed changes and levels of other ratios as appropriate when analyzing each ratio. In other words, do not analyze ratios exclusively in isolation from each other. Rather, analyze the full picture created by the ratios. Page 1 of 2

GFIN 563 Wiley Ratio Analysis Assignment Spring 2023 5.4. Discuss whether the specified companys financial condition is improving or deteriorating and how that has been determined. 5.5. Discuss the implications of the DuPont analysis. 5.6. Evaluate the companys performance and financial position relative to the industry throughout your written analysis as relevant. 5.7. Provide a final paragraph summary of the overall financial health of the specified company as demonstrated by the ratios