Question

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

a) 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.
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)

Answer 1

To create a data sheet for the assigned S&P 500 equities, you need to collect information from the specified companies and calculate various metrics and ratios.

Step-by-step explanation:

In order to create a data sheet for the assigned S&P 500 equities, you will need to collect information from the companies CVS Health Care Corporation, Elevance, Trane Technology PLC, Digital Realty Trust, and PPG Industries Inc. The data sheet should include the following metrics for each company: 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 (Common and Preferred) for the years 2022, 2021, 2020, and 2019.

To calculate the following formulas and ratios, you can utilize the data collected from the companies:

• Total Asset Growth
• Return on Equity (ROE)
• Return on Assets (ROA)
• Book Value
• PE Ratio
• Debt-to-Total-Equity Ratio
• Has the company undergone any share splits? If so, state the date and ratio.