Question
AAPL WMT FB 1/1/2015 26.59675 73.16325 75.91 4635.24 2/1/2015 29.16199 72.25925 78.97 4963.53 3/1/2015 28.35861 70.81284 82.22 4900.88 4/1/2015 28.5227 67.60051 78.77 4941.42 5/1/2015 29.69186
AAPL | WMT | FB | ||
1/1/2015 | 26.59675 | 73.16325 | 75.91 | 4635.24 |
2/1/2015 | 29.16199 | 72.25925 | 78.97 | 4963.53 |
3/1/2015 | 28.35861 | 70.81284 | 82.22 | 4900.88 |
4/1/2015 | 28.5227 | 67.60051 | 78.77 | 4941.42 |
5/1/2015 | 29.69186 | 64.32658 | 79.19 | 5070.03 |
6/1/2015 | 28.70592 | 61.82145 | 85.77 | 4986.87 |
1/7/2015 | 27.76073 | 62.73661 | 94.01 | 5128.28 |
8/1/2015 | 25.80627 | 56.41763 | 89.43 | 4776.51 |
9/1/2015 | 25.35753 | 56.89939 | 89.9 | 4620.16 |
10/1/2015 | 27.47258 | 50.23012 | 101.97 | 5053.75 |
11/1/2015 | 27.1967 | 51.63418 | 104.24 | 5108.67 |
2015/12/1 | 24.30244 | 53.79292 | 104.66 | 5007.41 |
1/1/2016 | 22.47387 | 58.72101 | 112.21 | 4613.95 |
2/1/2016 | 22.3238 | 58.70332 | 106.92 | 4557.95 |
3/1/2016 | 25.30017 | 60.60584 | 114.1 | 4869.85 |
4/1/2016 | 21.76014 | 59.61038 | 117.58 | 4775.36 |
5/1/2016 | 23.18079 | 63.09586 | 118.81 | 4948.05 |
6/1/2016 | 22.32702 | 65.56928 | 114.28 | 4842.67 |
7/1/2016 | 24.33785 | 65.52438 | 123.94 | 5162.13 |
8/1/2016 | 24.77926 | 64.15049 | 126.12 | 5213.22 |
9/1/2016 | 26.54543 | 65.20445 | 128.27 | 5312 |
10/1/2016 | 26.66048 | 63.30581 | 130.99 | 5189.14 |
11/1/2016 | 25.95136 | 63.67648 | 118.42 | 5323.68 |
12/1/2016 | 27.33548 | 62.49211 | 115.05 | 5383.12 |
1/1/2017 | 28.64066 | 60.77219 | 130.32 | 5614.79 |
2/1/2017 | 32.33197 | 64.58753 | 135.54 | 5825.44 |
3/1/2017 | 34.0532 | 65.6347 | 142.05 | 5911.74 |
4/1/2017 | 34.05083 | 68.96086 | 150.25 | 6047.61 |
5/1/2017 | 36.21027 | 72.09795 | 151.46 | 6198.52 |
6/1/2017 | 34.27944 | 69.88405 | 150.98 | 6140.42 |
Q1; you are working in investment company , Ahmed come to you and ask to advise him about investing his wealth, he wants to invest in next firms in the table. in doing so, you are required to compute;
- monthly returns ( for individual asset and Portfolio) , risk, ( for individual asset and Portfolio).
- beta , standard deviation , variance, covariance ( between assets and between assets and market index) correlation between individual assets and between assets and market index.
- he believes that weights for individuals assets inside portfolio like that; AAPL 40% WMT 35% FB 25%. after that explain to him your calculation as report.
- Show your steps in your calculation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started