detailed answer with full valies and all.

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