Question: 10 Year Historical Data 10 Year Historical Data 10 Year Historical Data Apple (AAPL) Microsoft(MSFT) S&P 500 Date Adj Close Month Return Date Adj Close

 
10 Year Historical Data 10 Year Historical Data 10 Year Historical Data
Apple (AAPL) Microsoft(MSFT) S&P 500
Date Adj Close Month Return Date Adj Close Month Return Date Adj Close Month Return
1/1/2010 $23.94 1 43.40% 1/1/2010 $22.25 1 0.49% 1/1/2010 $1,073.87 1 16.50%
1/1/2011 $42.30 1 25.67% 1/1/2011 $22.36 1 8.51% 1/1/2011 $1,286.12 1 2.00%
1/1/2012 $56.91 1 0.66% 1/1/2012 $24.44 1 -4.62% 1/1/2012 $1,312.41 1 12.40%
1/1/2013 $57.29 1 11.24% 1/1/2013 $23.36 1 29.60% 1/1/2013 $1,498.11 1 15.96%
1/1/2014 $64.55 1 40.22% 1/1/2014 $33.18 1 8.82% 1/1/2014 $1,782.59 1 10.65%
1/1/2015 $107.97 1 -18.35% 1/1/2015 $36.39 1 28.62% 1/1/2015 $1,994.99 1 -2.82%
1/1/2016 $91.23 1 21.53% 1/1/2016 $50.98 1 17.05% 1/1/2016 $1,940.24 1 14.86%
1/1/2017 $116.27 1 28.67% 1/1/2017 $61.46 1 33.45% 1/1/2017 $2,278.87 1 19.30%
1/1/2018 $163.00 1 0.89% 1/1/2018 $92.35 1 10.57% 1/1/2018 $2,823.81 1 -4.43%
1/1/2019 $164.47 1 0.00% 1/1/2019 $103.26 1 0.00% 1/1/2019 $2,704.10 1 0.00%
Average $88.79 15.39% Average $47.00 13.25% Average $1,869.51 8.44%
StandardDeviation 48.6772943 19.83% StandardDeviation 29.884596 13.47% StandardDeviation 598.59031 8.86%
Correlation ? Correlation ? Correlation 1
Beta(b) ? Beta(b) ? Beta(b) 1

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:

  • equal to market risk.
  • equal to half the market risk.
  • the lowest possible risk with the two stocks you have.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!