Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apple Microsoft Date (End of month) Average monthly return Average monthly return December 2021 - - January -0,015746248 -0,075360144 February -0,054036945 -0,037196923 March 0,057427911 0,03185787
| Apple | Microsoft | |
| Date (End of month) | Average monthly return | Average monthly return |
| December 2021 | - | - |
| January | -0,015746248 | -0,075360144 |
| February | -0,054036945 | -0,037196923 |
| March | 0,057427911 | 0,03185787 |
| April | -0,097111955 | -0,099875849 |
| May | -0,054479419 | -0,018075569 |
| June | -0,081474493 | -0,055298858 |
| July | 0,188701394 | 0,093086043 |
| August | -0,031230712 | -0,066652348 |
| September | -0,120986239 | -0,109265935 |
| October | 0,109589041 | -0,003315393 |
| November | -0,033052453 | 0,102211854 |
| December | -0,109234615 | -0,06431763 |
a) Calculate average monthly return and standard deviation for 11 different portfolios that combine stock 1 and stock 2 in different proportions: 0% in stock 1 + 100 % in stock 2; 10% in stock 1 + 90% in stock 2; 20% in stock 1 + 80% in stock 2; and so until the 11th portfolio includes 100% in stock 1 + 0% in stock 2.
Step by Step Solution
★★★★★
3.44 Rating (163 Votes )
There are 3 Steps involved in it
Step: 1
Answer Average monthly return has been calculated with the help of average function in excel Standar...
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
Intermediate Accounting
Authors: James D. Stice, Earl K. Stice, Fred Skousen
17th Edition
032459237X, 978-0324592375
