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. 120 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. [20 marks] Use weighted average cost (WAC) for the following: Select 5 stocks (ones assigned from question 1) and create a portfolio using the weighted average cost method. Ignore dividends or stock splits. You have a budget of $200,500 and you are buying for today's date and return. Collect and assign the following information for each equity: 

a) Equity Name, Ticker, Date, price, 10-year annualized return |5 marks] 

b) What is the allocation per each equity in terms of dollars (assign your weights)? [15 marks] 

c) Create 2 portfolios, which portfolio has a higher return ? Support your answer using details. [15 marks)