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. [ 20 marks] 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) [ 20 marks] 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