Calculating Ratios for Firms with Negative Equity Using Data Analytics Access the Excel file of Compustat data available at the MBC website and use data visualization software such as Power BI or Tableau, to answer the requirements.

Required

a. In the Excel file, define return on assets, return on equity, market capitalization, and return on market value of equity for all firms in the dataset (use year-end balances in the denominators for all of the ratios). For ROE, define Net income attributable to common as Net income minus Noncontrolling interest I/S.

b. Use a line chart to depict the median ROA, ROE, and return on market value for all GIC sectors in 2019. Explain the relative magnitude of the three lines.

c. Use a Scatterplot diagram of firms in 2019. Display Net income on the horizontal (X) axis and Eq-uity Attributable to Company Shareholders on the vertical (Y) axis. Set filters to display firms with Net income between $(4,000) million and $4,000 million and Equity between $(10,000) million and $10,000 million. Identify Boeing on the scatterplot.

d. Refer to the scatterplot from part c. Display the firms in the scatterplot that have a negative ROE. What distinction would analysts make between negative ROE for Apache Corporation (105%) ver-sus HCA Healthcare (102%)? How would analysts interpret the 7.4% ROE of for Boeing (shown in the part c scatterplot)?