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

1. Collect information from the company CVS health care corporation, elevance, trane technology plc,digital realty trust and PPG industies inc. (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]
2. 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. [20