# The zip file contains separate files for the balance sheet, income statement, and cash flow statement for nearly 500 firms listed in the S&P 500. # Please review the data thoroughly before proceeding. # Determine how many tickers have an average four-year Return on Equity (ROE) less than 0 and at the same time have an average four-year Debt Ratio greater than 0.7. # You need to calculate the ROE and Debt Ratio for FY1, FY2, FY3, and FY4, then compute their averages. # ROE = net income/stockholders equity # Debt Ratio = Total Liabilities Net Minority Interest/Total Assets