P4-3S.Compute Z-Scores and Prepare Data Visualization from Data Set Access the Module 4 data set using MyBusinessCourse site to answer the requirements.

Required

a. Compute Z-Scores for all S&P retailers for all years in the data set. Retailers have 3-digit NAICS codes from 443 to 454 inclusive. Estimate EBIT as: Pretax income+ Interest and related expenses.

b. Use a data visualization package such as Power BI or Tableau to display the Z-Score for fi scal 2018 for all firms. Which firm has the lowest Z-Score in 2018? The highest?

c. Are any of the firms in the data set at risk for bankruptcy in 2018?

d. Compare the calculated Z-Score for Home Depot for fiscal year ended February 2019 to the Z-Score reported in Exhibit 4.10. What explains the difference?