Date MSFT adj close WMT adj close SPY adj close Stock Return Analysis 8 Questions 3 29 21 233 339355 134 571823 390 639404 3 30 21 229 976761 133 656128 389 603027 3 31 21 233 865067 133 744736 391 182251 4 1 21 240 391907 133 537933 395 406647 1) Calculate the average return of MSFT, WMT, and SPY using the given data 4 5 21 247 057617 137 289474 401 08194 4 6 21 245 857391 137 949188 400 845093 4 7 21 247 88089 137 653793 401 30896 4 8 21 251 203857 137 56517 403 213898 4 9 21 253 782822 137 634079 406 145325 4 12 21 253 842346 137 653793 406 293365 4 13 21 256 401459 137 230392 407 497498 4 14 21 253 524918 137 181168 406 105835 4 15 21 257 403351 138 008255 410 468414 4 16 21 258 633331 138 45134 411 840393 4 19 21 256 649475 137 56517 409 817017 2) Calculate the return standard deviations of MSFT, WMT, and SPY using the given data 4 20 21 256 173401 138 628586 406 816498 4 21 21 258 474609 139 032288 410 665833 4 22 21 255 092178 137 525787 406 915222 4 23 21 259 040009 137 752258 411 327118 4 26 21 259 436768 135 792816 412 185822 4 27 21 259 853363 136 2556 412 096985 4 28 21 252 50325 135 773117 411 978577 4 29 21 250 469818 137 486404 414 604004 4 30 21 250 142471 137 762115 411 879852 5 3 21 249 825073 139 938171 412 768188 5 4 21 245 787949 138 559662 410 22168 3) Create a portfolio that invests 60 in MSFT and 40 in WMT What is the average return and return standard deviation of this portfolio 5 5 21 244 478607 138 441528 410 350006 5 6 21 247 71228 139 430008 413 626892 5 7 21 250 420227 138 589783 416 637238 5 10 21 245 182892 139 202667 412 511536 5 11 21 244 24054 137 94725 408 829987 5 12 21 237 068985 134 378693 400 144318 5 13 21 241 066406 136 652298 404 951019 5 14 21 246 14505 137 917587 411 169189 5 17 21 243 19902 137 294815 410 122955

The Answer is in the image, click to view ...

Question: Date MSFT_adj_close WMT_adj_close SPY_adj_close Stock Return Analysis - 8 Questions 3/29/21 233.339355 134.571823 390.639404 3/30/21 229.976761 133.656128 389.603027 3/31/21 233.865067 133.744736 391.182251 4/1/21 240.391907 133.537933

Date	MSFT_adj_close	WMT_adj_close	SPY_adj_close	Stock Return Analysis - 8 Questions
3/29/21	233.339355	134.571823	390.639404
3/30/21	229.976761	133.656128	389.603027
3/31/21	233.865067	133.744736	391.182251
4/1/21	240.391907	133.537933	395.406647	1)	Calculate the average return of MSFT, WMT, and SPY using the given data.
4/5/21	247.057617	137.289474	401.08194
4/6/21	245.857391	137.949188	400.845093
4/7/21	247.88089	137.653793	401.30896
4/8/21	251.203857	137.56517	403.213898
4/9/21	253.782822	137.634079	406.145325
4/12/21	253.842346	137.653793	406.293365
4/13/21	256.401459	137.230392	407.497498
4/14/21	253.524918	137.181168	406.105835
4/15/21	257.403351	138.008255	410.468414
4/16/21	258.633331	138.45134	411.840393
4/19/21	256.649475	137.56517	409.817017	2)	Calculate the return standard deviations of MSFT, WMT, and SPY using the given data.
4/20/21	256.173401	138.628586	406.816498
4/21/21	258.474609	139.032288	410.665833
4/22/21	255.092178	137.525787	406.915222
4/23/21	259.040009	137.752258	411.327118
4/26/21	259.436768	135.792816	412.185822
4/27/21	259.853363	136.2556	412.096985
4/28/21	252.50325	135.773117	411.978577
4/29/21	250.469818	137.486404	414.604004
4/30/21	250.142471	137.762115	411.879852
5/3/21	249.825073	139.938171	412.768188
5/4/21	245.787949	138.559662	410.22168	3)	Create a portfolio that invests 60% in MSFT and 40% in WMT. What is the average return and return standard deviation of this portfolio?
5/5/21	244.478607	138.441528	410.350006
5/6/21	247.71228	139.430008	413.626892
5/7/21	250.420227	138.589783	416.637238
5/10/21	245.182892	139.202667	412.511536
5/11/21	244.24054	137.94725	408.829987
5/12/21	237.068985	134.378693	400.144318
5/13/21	241.066406	136.652298	404.951019
5/14/21	246.14505	137.917587	411.169189
5/17/21	243.19902	137.294815	410.122955

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!

Date MSFT_adj_close WMT_adj_close SPY_adj_close Stock Return Analysis - 8 Questions 3/29/21 233.339355 134.571823 390.639404 3/30/21 229.976761 133.656128 389.603027 3/31/21 233.865067 133.744736...

Please follow the instructions carefully. Write all your code in a Code cell, and your explanations in a Markdown cell. Make sure that your code compiles correctly either by selecting a given cell...

The Dukes leased land from Lillian Whatley. Toward the end of their lease, they sent Ms. Whatley a new contract, renewing the lease for three years and giving themselves the option to buy the land at...

In 2005, Hurricane Katrina caused massive destruction to the U.S. Gulf Coast. Tens of thousands of people lost their homes and possessions. Even those who werent directly affected by the destruction...

=+d. Households decide to hold more money to use for holiday shopping.

The net income reported on the income statement of Styx Co. was $3,200,000. There were 250,000 shares of $5 par common stock and 250,000 shares of $1 preferred stock outstanding throughout the...

All else equal, a decrease in an assets discount rate (e.g., its expected rate of return) leads to ______________ in its value. a. An increase b. A decrease c. No change d. Not enough information to...

A uniform electric field E is created between two parallel, charged plates as shown in figure (29-W9). An electron enters the field symmetrically between the plates with a speed v.. The length of...

Analyze and explain how you think big banks are (or are not) ripping off pension funds. Support your response with evidence and examples.

5. The following diagram shows the cumulative frequency curve for the heights, & cm, of 60 plants that have heights less than or equal to h cm. ulative frequency curve of plants (i) Use the curve to...

Lopp True or False: Compound interest is interest that is paid on the initial principal only. Group of answer choices True False

(LO 7-4) Analysis: How does Data Analytics help facilitate the use of the Balanced Scorecard and tracking KPIs? Does it make the data more timely? Are you able to access more information easier or...

(LO 7-3) Analysis: From Exhibit 7-8, choose 10 employee performance KPIs to answer the following three questions. This URL...

(LO 7-3) Of the list of KPIs shown below, indicate which would be considered to be financial performance KPIs, and which would not be. 1. Market Share 2. Net Income (Net Profit) 3. Cash Conversion...