Create a data sheet using your assigned S&P$500$ equities and calculate the following metrics :Broadcom Inc. AVGO Information Technology

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 $2023,2022,2021,2020.$