• Please use your seven companies in the previous "Financial Ratios(assignment 1)" to list the stock prices of Feb 1 and May 1, 2023. Use above info to compute stock holding period return for individual stock (1%, listing the computation. Dividends must count).
• Collect Beta coefficient for each stock and explain the risk (high, low or close to the average) (1% Compute your portfolio investments in these seven stocks and the risk and returns. (Note: equally weighted and price weighted)(1%)

PLEASE SHOW ALL WORK

FEBRUARY

Company Name	Apple inc.	Microsoft Corp	Alphabet inc.	Amazon	Johnson & Johnson	Procter & gamble	Walmart
Current ratio	1.37	2.53	3.32	1.08	1.84	0.70	0.79
Debt/ Equity ratio	1.37	0.66	0.05	1.05	0.49	0.68	0.75
Asset turnover	1.46	0.86	0.60	1.60	0.46	0.52	2.34
Profit margin	0.24	0.38	0.24	0.38	0.24	0.21	0.4
Price to earning	30.05	34.57	28.14	82.46	27.02	25.02	31.21
Market to Book	20.67	15.12	7.92	19.19	6.13	8.19	5.27
Closing stock price	$177.89	$305.53	$2,820.90	$3,244.87	$147.02	$147.02	$127.28

MAY

Company Name	Apple inc.	Microsoft Corp	Alphabet inc.	Amazon	Johnson & Johnson	Procter & gamble	Walmart
Current ratio	0.94	1.91	2.35	0.95	1.07	0.59	0.82
Debt/ Equity ratio	1.76	0.2476	0.04	2.01	0.75	0.81	0.82
Asset turnover	1.12	0.14	0.77	0.27	0.51	0.17	2.51
Profit margin	44.26%	40.98%	24.92%	0.82%	28.29%	16.93%	1.10%
Price to earning	29.72	34.07	27.36	144.09	15.58	26.57	23.48
Market to Book	44.41	12.10	6.01	7.84	5.81	8.11	5.16
Closing stock price	$169.59	$305.56	122.76	118.31	158.91	$153.17	151.59