Create a data sheet using your assigned S&P500 equities and calculate the following metrics :

a) Collect information ( Equity Name, ticker, Year, CUSIP, price, Profit, preferred dividend, common shareholders equity, net income , total shareholders equity, Total assets , number of shares outstanding, short-term debt, long term debt, other fixed liabilities , dividend payment annual(common and preferred) for years 2022, 2021, 2020, 2019.

b) Calculate the following formulas and ratios; (Total asset growth, ROE, ROA, Book value, PE ratio, Debt-to-total-equity ratio, has the company undergone any share splits; if so state the date and ratio)

c) Compare and contrast each company . Explain which equity is the best investment based on the information you have analyzed. Use a detailed analysis with evidence to support your answer.