Download the historical prices for Apple, Microsoft, and the stock market (choose an index of your preference) for the past 10 years.

1. Calculate returns for the two stocks and the index. If the return data you have is monthly returns, average the monthly returns to get yearly returns. Make a chart to display your summary data, as well as a graph that lays out the three different returns.
2. Calculate Beta for Apple and Microsoft, using a characteristic line. Display the data points on a graph and display the characteristic line.
3. Using CAPM, calculate the Expected Return for Apple and Microsoft. Get the relevant market related data, such as the risk-free rate and market return, and describe which rate you are using from the financial markets.
4. Imagine you are supposed to create a portfolio using Apple and Microsoft, using $1,000,000. How much do you need to invest in each stock, so that your portfolio risk is:
   1. equal to market risk.
   2. equal to 1.5 times the market risk.
   3. equal to twice the market risk.
   4. the lowest possible risk with the two stocks you have.
5. Display your calculations using a table to show $ amounts invested in each stock, your total portfolio value, portfolio weights, your final calculation for portfolio beta, and the expected portfolio return using CAPM input you collected for Part (3).

MICROSOFT			APPLE
Date	Open		Date	Open
10/1/10	$24.77		10/1/10	$10.22
11/1/10	$26.88		11/1/10	$10.79
12/1/10	$25.57		12/1/10	$11.26
1/1/11	$28.05		1/1/11	$11.63
2/1/11	$27.80		2/1/11	$12.19
3/1/11	$26.60		3/1/11	$12.70
4/1/11	$25.53		4/1/11	$12.54
5/1/11	$25.94		5/1/11	$12.49
6/1/11	$24.99		6/1/11	$12.46
7/1/11	$25.93		7/1/11	$12.00
8/1/11	$27.51		8/1/11	$14.21
9/1/11	$26.46		9/1/11	$13.78
10/1/11	$24.72		10/1/11	$13.58
11/1/11	$26.19		11/1/11	$14.19
12/1/11	$25.56		12/1/11	$13.66
1/1/12	$26.55		1/1/12	$14.62
2/1/12	$29.79		2/1/12	$16.37
3/1/12	$31.93		3/1/12	$19.58
4/1/12	$32.22		4/1/12	$21.49
5/1/12	$32.05		5/1/12	$20.89
6/1/12	$28.76		6/1/12	$20.33
7/1/12	$30.62		7/1/12	$20.88
8/1/12	$29.59		8/1/12	$22.00
9/1/12	$30.45		9/1/12	$23.78
10/1/12	$29.81		10/1/12	$23.97
11/1/12	$28.84		11/1/12	$21.37
12/1/12	$26.78		12/1/12	$21.20
1/1/13	$27.25		1/1/13	$19.78
2/1/13	$27.67		2/1/13	$16.40
3/1/13	$27.72		3/1/13	$15.64
4/1/13	$28.64		4/1/13	$15.78
5/1/13	$32.93		5/1/13	$15.87
6/1/13	$34.92		6/1/13	$16.10
7/1/13	$34.75		7/1/13	$14.38
8/1/13	$32.06		8/1/13	$16.28
9/1/13	$31.75		9/1/13	$17.61
10/1/13	$33.35		10/1/13	$17.09
11/1/13	$35.67		11/1/13	$18.72
12/1/13	$38.09		12/1/13	$19.93
1/1/14	$37.35		1/1/14	$19.85
2/1/14	$37.74		2/1/14	$17.95
3/1/14	$37.92		3/1/14	$18.69
4/1/14	$41.15		4/1/14	$19.21
5/1/14	$40.24		5/1/14	$21.14
6/1/14	$40.95		6/1/14	$22.64
7/1/14	$41.86		7/1/14	$23.38
8/1/14	$43.21		8/1/14	$23.73
9/1/14	$45.43		9/1/14	$25.76
10/1/14	$46.27		10/1/14	$25.15
11/1/14	$46.89		11/1/14	$27.06
12/1/14	$47.88		12/1/14	$29.70
1/1/15	$46.66		1/1/15	$27.85
2/1/15	$40.59		2/1/15	$29.51
3/1/15	$43.67		3/1/15	$32.31
4/1/15	$40.60		4/1/15	$31.21
5/1/15	$48.58		5/1/15	$31.53
6/1/15	$47.06		6/1/15	$32.57
7/1/15	$44.46		7/1/15	$31.73
8/1/15	$46.98		8/1/15	$30.38
9/1/15	$42.17		9/1/15	$27.54
10/1/15	$44.75		10/1/15	$27.27
11/1/15	$52.85		11/1/15	$30.20
12/1/15	$54.41		12/1/15	$29.69
1/1/16	$54.32		1/1/16	$25.65
2/1/16	$54.88		2/1/16	$24.12
3/1/16	$50.97		3/1/16	$24.41
4/1/16	$55.05		4/1/16	$27.20
5/1/16	$50.00		5/1/16	$23.49
6/1/16	$52.44		6/1/16	$24.75
7/1/16	$51.13		7/1/16	$23.87
8/1/16	$56.60		8/1/16	$26.10
9/1/16	$57.01		9/1/16	$26.54
10/1/16	$57.41		10/1/16	$28.18
11/1/16	$59.97		11/1/16	$28.37
12/1/16	$60.11		12/1/16	$27.59
1/1/17	$62.79		1/1/17	$28.95
2/1/17	$64.36		2/1/17	$31.76
3/1/17	$64.13		3/1/17	$34.47
4/1/17	$65.81		4/1/17	$35.93
5/1/17	$68.68		5/1/17	$36.28
6/1/17	$70.24		6/1/17	$38.29
7/1/17	$69.33		7/1/17	$36.22
8/1/17	$73.10		8/1/17	$37.28
9/1/17	$74.71		9/1/17	$41.20
10/1/17	$74.71		10/1/17	$38.56
11/1/17	$83.68		11/1/17	$42.47
12/1/17	$83.60		12/1/17	$42.49
1/1/18	$86.13		1/1/18	$42.54
2/1/18	$94.79		2/1/18	$41.79
3/1/18	$93.99		3/1/18	$44.63
4/1/18	$90.47		4/1/18	$41.66
5/1/18	$93.21		5/1/18	$41.60
6/1/18	$99.28		6/1/18	$47.00
7/1/18	$98.10		7/1/18	$45.96
8/1/18	$106.03		8/1/18	$49.78
9/1/18	$110.85		9/1/18	$57.10
10/1/18	$114.75		10/1/18	$56.99
11/1/18	$107.05		11/1/18	$54.76
12/1/18	$113.00		12/1/18	$46.12
1/1/19	$99.55		1/1/19	$38.72
2/1/19	$103.78		2/1/19	$41.74
3/1/19	$112.89		3/1/19	$43.57
4/1/19	$118.95		4/1/19	$47.91
5/1/19	$130.53		5/1/19	$52.47
6/1/19	$123.85		6/1/19	$43.90
7/1/19	$136.63		7/1/19	$50.79
8/1/19	$137.00		8/1/19	$53.47
9/1/19	$136.61		9/1/19	$51.61
10/1/19	$139.66		10/1/19	$56.27
11/1/19	$144.26		11/1/19	$62.38
12/1/19	$151.81		12/1/19	$66.82
1/1/20	$158.78		1/1/20	$74.06
2/1/20	$170.43		2/1/20	$76.07
3/1/20	$165.31		3/1/20	$70.57
4/1/20	$153.00		4/1/20	$61.63
5/1/20	$175.80		5/1/20	$71.56
6/1/20	$182.54		6/1/20	$79.44
7/1/20	$203.14		7/1/20	$91.28
8/1/20	$211.52		8/1/20	$108.20
9/1/20	$225.51		9/1/20	$132.76