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 pl, 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) make a excel file