Date	S&P500	Walmart	Target
1-Apr-16	2,065.30	59.84	68.20
1-May-16	2,096.95	63.34	59.00
1-Jun-16	2,098.86	65.83	60.35
1-Jul-16	2,173.60	65.78	65.12
1-Aug-16	2,170.95	64.40	60.67
1-Sep-16	2,168.27	65.46	59.84
1-Oct-16	2,126.15	63.55	59.89
1-Nov-16	2,198.81	63.93	67.30
1-Dec-16	2,238.83	62.74	63.47
1-Jan-17	2,278.87	61.01	56.66
1-Feb-17	2,363.64	64.84	51.64
1-Mar-17	2,362.72	65.89	48.94
1-Apr-17	2,384.20	69.23	49.53
1-May-17	2,411.80	72.38	48.91
1-Jun-17	2,423.41	70.16	46.88
1-Jul-17	2,470.30	74.15	50.80
1-Aug-17	2,471.65	72.37	48.88
1-Sep-17	2,519.36	72.89	53.50
1-Oct-17	2,575.26	81.45	53.52
1-Nov-17	2,647.58	90.70	54.30
1-Dec-17	2,673.61	92.12	59.77
1-Jan-18	2,823.81	99.97	68.90
1-Feb-18	2,713.83	84.41	69.07
1-Mar-18	2,640.87	83.44	64.12
1-Apr-18	2,648.05	83.45	67.05
1-May-18	2,705.27	77.87	67.32
1-Jun-18	2,718.37	81.31	70.90
1-Jul-18	2,816.29	84.71	75.15
1-Aug-18	2,901.52	91.00	81.50
1-Sep-18	2,913.98	89.67	82.81
1-Oct-18	2,711.74	95.75	78.51
1-Nov-18	2,760.17	93.24	66.61
1-Dec-18	2,506.85	88.94	62.56
1-Jan-19	2,704.10	92.00	69.10
1-Feb-19	2,784.49	95.04	68.76
1-Mar-19	2,834.40	93.63	76.64
1-Apr-19	2,945.83	99.26	73.93
1-May-19	2,752.06	97.91	76.82
1-Jun-19	2,941.76	107.21	83.45
1-Jul-19	2,980.38	107.11	83.25
1-Aug-19	2,926.46	110.87	103.14
1-Sep-19	2,976.74	115.73	103.80
1-Oct-19	3,037.56	114.34	103.80
1-Nov-19	3,140.98	116.13	121.38
1-Dec-19	3,230.78	115.88	125.22
1-Jan-20	3,225.52	112.14	108.16
1-Feb-20	2,954.22	105.47	100.60
1-Mar-20	2,584.59	111.29	91.32
1-Apr-20	2,912.43	119.58	107.79
1-May-20	3,044.31	122.05	120.16
1-Jun-20	3,100.29	118.36	118.43
1-Jul-20	3,271.12	127.87	124.30
1-Aug-20	3,500.31	137.21	149.31
1-Sep-20	3,363.00	138.82	156.22
1-Oct-20	3,269.96	137.67	151.05
1-Nov-20	3,621.63	151.60	178.16
1-Dec-20	3,756.07	143.03	175.90
1-Jan-21	3,714.24	139.91	180.53
1-Feb-21	3,811.15	129.38	182.79
1-Mar-21	3,943.34	131.82	188.04

I have provided you monthly price data from April 2016 to March 2021 (5 years of data) on closing prices for the S&P500 index, Walmart Stock (WMT) and Target Stock (TGT).

A. Compute the monthly return for the S&P500, WMT and TGT (no need to report the entire table). Recall that return is the price change divided by the starting price.

B. Report and compute the monthly average return for each asset and the standard deviation of returns and the correlation between each asset return, using Excel.

Discuss your findings in 10 lines

Which asset has the highest monthly return?

Which asset has the highest standard deviation?

What is the total risk, systematic component of risk and unsystematic component of risk of each asset?

Explain in less than 5 lines the reasons for your findings.