calculate (1) the monthly average return (2) the standard deviation of the monthly returns (3)annualize the monthly average return, (4) annualize the standard deviation of the monthly returns Security PFE US Equity Security BLMN US Equity Security AAPL US Equity Start Date 1 30 15 0 00 Start Date 1 30 15 0 00 Start Date 1 30 15 0 00 End Date 12 31 19 0 00 End Date 12 31 19 0 00 End Date 12 31 19 0 00 Period M Period M Period M Currency USD Currency USD Currency USD Date PX LAST PX VOLUME Date PX LAST PX VOLUME Date PX LAST PX VOLUME 12 31 19 37 1406 368888975 12 31 19 22 07 21610734 12 31 19 73 413 2395485460 11 29 19 36 515 423563709 11 29 19 24 05 19802761 11 29 19 66 813 1795689012 10 31 19 36 3728 387150329 10 31 19 19 81 20892949 10 31 19 62 19 2490606800 9 30 19 34 0598 421993608 9 30 19 18 93 30530847 9 30 19 55 993 2189633952 8 30 19 33 6996 605791456 8 30 19 18 04 42550180 8 30 19 52 185 2734062984 7 31 19 36 8183 560640386 7 31 19 17 03 32309420 7 31 19 53 26 1895828484 6 28 19 41 0652 437561440 6 28 19 18 91 32401279 6 28 19 49 48 2060875072 5 31 19 39 3588 524540458 5 31 19 19 31 56513325 5 31 19 43 768 2957826292 4 30 19 38 4962 461323305 4 30 19 19 99 25297047 4 30 19 50 168 2024471248 3 29 19 40 2594 525812964 3 29 19 20 45 29200963 3 29 19 47 488 2603925536 2 28 19 41 0936 427805576 2 28 19 20 68 31225172 2 28 19 43 288 1890162892 1 31 19 40 2404 599583699 1 31 19 18 43 26716275 1 31 19 41 61 3312396716 12 31 18 41 378 536813715 12 31 18 17 89 24692501 12 31 18 39 435 3595668028 11 30 18 43 8237 481866439 11 30 18 19 55 22305744 11 30 18 44 645 3845287788 10 31 18 40 8187 573683274 10 31 18 19 95 27694249 10 31 18 54 715 3158992272 9 28 18 41 7761 350654034 9 28 18 19 79 25250995 9 28 18 56 435 2715888160 8 31 18 39 3588 474885890 8 31 18 19 3 28209495 8 31 18 56 908 2801275348 7 31 18 37 8516 401469004 7 31 18 19 34 33033500 7 31 18 47 573 1575390904 6 29 18 34 3916 434975835 6 29 18 20 1 34195635 6 29 18 46 278 2110497460 5 31 18 34 0598 485553527 5 31 18 21 22 44213706 5 31 18 46 718 2483904824 4 30 18 34 7044 424338326 4 30 18 23 66 37248182 4 30 18 41 315 2665440588 3 29 18 33 6427 481192448 3 29 18 24 28 25213081 3 29 18 41 945 2854909788 2 28 18 34 42 557684543 2 28 18 23 09 23186655 2 28 18 44 53 3711577892 1 31 18 35 112 479581708 1 31 18 22 03 16082225 1 31 18 41 858 2638717760 12 29 17 34 3347 314792355 12 29 17 21 34 20232708 12 29 17 42 308 2124736232 11 30 17 34 3726 284986414 11 30 17 21 47 46360510 11 30 17 42 963 2402653484 10 31 17 33 2351 345560818 10 31 17 17 78 21846867 10 31 17 42 26 2017164472 9 29 17 33 8418 387075201 9 29 17 17 6 28878027 9 29 17 38 53 2721768368 8 31 17 32 1544 388679941 8 31 17 17 01 34522064 8 31 17 41 2644275652 7 31 17 31 434 305432798 7 31 17 17 43 33681229 7 31 17 37 183 1688047324 6 30 17 31 8416 465512656 6 30 17 21 23 36745632 6 30 17 36 005 2736712144 5 31 17 30 9505 531538903 5 31 17 20 03 31189467 5 31 17 38 19 2616091604 4 28 17 32 1544 353037525 4 28 17 21 69 29644135 4 28 17 35 913 1493216360 3 31 17 32 4293 515456999 3 31 17 19 73 34175315 3 31 17 35 915 2248364856 2 28 17 32 344 519070330 2 28 17 17 09 30676370 2 28 17 34 248 2299874188 1 31 17 30 0784 526191463 1 31 17 17 11 28035900 1 31 17 30 338 2253324640 12 30 16 30 7894 507600373 12 30 16 18 03 25444583 12 30 16 28 955 2435086580 11 30 16 30 4671 740955377 11 30 16 18 6 39012203 11 30 16 27 63 2886219868 10 31 16 30 0595 397091344 10 31 16 17 3 24761832 10 31 16 28 385 2747656896 9 30 16 32 107 398279669 9 30 16 17 24 19679319 9 30 16 28 263 3880386952 8 31 16 32 9886 479724092 8 31 16 19 54 25819726 8 31 16 26 525 2520514268 7 29 16 34 9698 350949481 7 29 16 17 98 19642003 7 29 16 26 053 2743085488 6 30 16 33 3773 575342916 6 30 16 17 87 20511403 6 30 16 23 9 3122520940 5 31 16 32 8938 611641747 5 31 16 19 05 23540223 5 31 16 24 965 3604579072 4 29 16 31 0074 1186276124 4 29 16 18 7 31169081 4 29 16 23 435 3489534492 3 31 16 28 0972 1044553461 3 31 16 16 87 28453137 3 31 16 27 248 2984545864 2 29 16 28 1256 850735307 2 29 16 17 29 42325554 2 29 16 24 173 3243450188 1 29 16 28 903 703022054 1 29 16 17 66 32107232 1 29 16 24 335 5087392348 12 31 15 30 5998 740265143 12 31 15 16 89 33614794 12 31 15 26 315 3690505036 11 30 15 31 0643 849907056 11 30 15 17 31 48229891 11 30 15 29 575 3002562292 10 30 15 32 0596 680708574 10 30 15 16 97 46872040 10 30 15 29 875 4454815316 9 30 15 29 7751 580612318 9 30 15 18 18 32879389 9 30 15 27 575 4826189332 8 31 15 30 5429 546288292 8 31 15 20 7 47045212 8 31 15 28 19 6429149068 7 31 15 34 183 497481955 7 31 15 23 29 33181512 7 31 15 30 325 4233122788 6 30 15 31 7847 507655689 6 30 15 21 35 37040705 6 30 15 31 356 3514427364 5 29 15 32 9412 437880880 5 29 15 22 46 40875269 5 29 15 32 57 3816608504 4 30 15 32 1639 556389357 4 30 15 22 66 33166967 4 30 15 31 288 3984542044 3 31 15 32 9791 654758106 3 31 15 24 33 46548790 3 31 15 31 108 4554567640 2 27 15 32 5336 605350178 2 27 15 25 76 39067503 2 27 15 32 115 4546141972 1 30 15 29 6234 598304542 1 30 15 24 715 38731129 1 30 15 29 29 5221054452

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

Question: calculate (1) the monthly average return (2) the standard deviation of the monthly returns (3)annualize the monthly average return, (4) annualize the standard deviation of

calculate (1) the monthly average return (2) the standard deviation of the monthly returns (3)annualize the monthly average return, (4) annualize the standard deviation of the monthly returns

Security	PFE US Equity		Security	BLMN US Equity		Security	AAPL US Equity
Start Date	1/30/15 0:00		Start Date	1/30/15 0:00		Start Date	1/30/15 0:00
End Date	12/31/19 0:00		End Date	12/31/19 0:00		End Date	12/31/19 0:00
Period	M		Period	M		Period	M
Currency	USD		Currency	USD		Currency	USD

Date	PX_LAST	PX_VOLUME	Date	PX_LAST	PX_VOLUME	Date	PX_LAST	PX_VOLUME
12/31/19	37.1406	368888975	12/31/19	22.07	21610734	12/31/19	73.413	2395485460
11/29/19	36.515	423563709	11/29/19	24.05	19802761	11/29/19	66.813	1795689012
10/31/19	36.3728	387150329	10/31/19	19.81	20892949	10/31/19	62.19	2490606800
9/30/19	34.0598	421993608	9/30/19	18.93	30530847	9/30/19	55.993	2189633952
8/30/19	33.6996	605791456	8/30/19	18.04	42550180	8/30/19	52.185	2734062984
7/31/19	36.8183	560640386	7/31/19	17.03	32309420	7/31/19	53.26	1895828484
6/28/19	41.0652	437561440	6/28/19	18.91	32401279	6/28/19	49.48	2060875072
5/31/19	39.3588	524540458	5/31/19	19.31	56513325	5/31/19	43.768	2957826292
4/30/19	38.4962	461323305	4/30/19	19.99	25297047	4/30/19	50.168	2024471248
3/29/19	40.2594	525812964	3/29/19	20.45	29200963	3/29/19	47.488	2603925536
2/28/19	41.0936	427805576	2/28/19	20.68	31225172	2/28/19	43.288	1890162892
1/31/19	40.2404	599583699	1/31/19	18.43	26716275	1/31/19	41.61	3312396716
12/31/18	41.378	536813715	12/31/18	17.89	24692501	12/31/18	39.435	3595668028
11/30/18	43.8237	481866439	11/30/18	19.55	22305744	11/30/18	44.645	3845287788
10/31/18	40.8187	573683274	10/31/18	19.95	27694249	10/31/18	54.715	3158992272
9/28/18	41.7761	350654034	9/28/18	19.79	25250995	9/28/18	56.435	2715888160
8/31/18	39.3588	474885890	8/31/18	19.3	28209495	8/31/18	56.908	2801275348
7/31/18	37.8516	401469004	7/31/18	19.34	33033500	7/31/18	47.573	1575390904
6/29/18	34.3916	434975835	6/29/18	20.1	34195635	6/29/18	46.278	2110497460
5/31/18	34.0598	485553527	5/31/18	21.22	44213706	5/31/18	46.718	2483904824
4/30/18	34.7044	424338326	4/30/18	23.66	37248182	4/30/18	41.315	2665440588
3/29/18	33.6427	481192448	3/29/18	24.28	25213081	3/29/18	41.945	2854909788
2/28/18	34.42	557684543	2/28/18	23.09	23186655	2/28/18	44.53	3711577892
1/31/18	35.112	479581708	1/31/18	22.03	16082225	1/31/18	41.858	2638717760
12/29/17	34.3347	314792355	12/29/17	21.34	20232708	12/29/17	42.308	2124736232
11/30/17	34.3726	284986414	11/30/17	21.47	46360510	11/30/17	42.963	2402653484
10/31/17	33.2351	345560818	10/31/17	17.78	21846867	10/31/17	42.26	2017164472
9/29/17	33.8418	387075201	9/29/17	17.6	28878027	9/29/17	38.53	2721768368
8/31/17	32.1544	388679941	8/31/17	17.01	34522064	8/31/17	41	2644275652
7/31/17	31.434	305432798	7/31/17	17.43	33681229	7/31/17	37.183	1688047324
6/30/17	31.8416	465512656	6/30/17	21.23	36745632	6/30/17	36.005	2736712144
5/31/17	30.9505	531538903	5/31/17	20.03	31189467	5/31/17	38.19	2616091604
4/28/17	32.1544	353037525	4/28/17	21.69	29644135	4/28/17	35.913	1493216360
3/31/17	32.4293	515456999	3/31/17	19.73	34175315	3/31/17	35.915	2248364856
2/28/17	32.344	519070330	2/28/17	17.09	30676370	2/28/17	34.248	2299874188
1/31/17	30.0784	526191463	1/31/17	17.11	28035900	1/31/17	30.338	2253324640
12/30/16	30.7894	507600373	12/30/16	18.03	25444583	12/30/16	28.955	2435086580
11/30/16	30.4671	740955377	11/30/16	18.6	39012203	11/30/16	27.63	2886219868
10/31/16	30.0595	397091344	10/31/16	17.3	24761832	10/31/16	28.385	2747656896
9/30/16	32.107	398279669	9/30/16	17.24	19679319	9/30/16	28.263	3880386952
8/31/16	32.9886	479724092	8/31/16	19.54	25819726	8/31/16	26.525	2520514268
7/29/16	34.9698	350949481	7/29/16	17.98	19642003	7/29/16	26.053	2743085488
6/30/16	33.3773	575342916	6/30/16	17.87	20511403	6/30/16	23.9	3122520940
5/31/16	32.8938	611641747	5/31/16	19.05	23540223	5/31/16	24.965	3604579072
4/29/16	31.0074	1186276124	4/29/16	18.7	31169081	4/29/16	23.435	3489534492
3/31/16	28.0972	1044553461	3/31/16	16.87	28453137	3/31/16	27.248	2984545864
2/29/16	28.1256	850735307	2/29/16	17.29	42325554	2/29/16	24.173	3243450188
1/29/16	28.903	703022054	1/29/16	17.66	32107232	1/29/16	24.335	5087392348
12/31/15	30.5998	740265143	12/31/15	16.89	33614794	12/31/15	26.315	3690505036
11/30/15	31.0643	849907056	11/30/15	17.31	48229891	11/30/15	29.575	3002562292
10/30/15	32.0596	680708574	10/30/15	16.97	46872040	10/30/15	29.875	4454815316
9/30/15	29.7751	580612318	9/30/15	18.18	32879389	9/30/15	27.575	4826189332
8/31/15	30.5429	546288292	8/31/15	20.7	47045212	8/31/15	28.19	6429149068
7/31/15	34.183	497481955	7/31/15	23.29	33181512	7/31/15	30.325	4233122788
6/30/15	31.7847	507655689	6/30/15	21.35	37040705	6/30/15	31.356	3514427364
5/29/15	32.9412	437880880	5/29/15	22.46	40875269	5/29/15	32.57	3816608504
4/30/15	32.1639	556389357	4/30/15	22.66	33166967	4/30/15	31.288	3984542044
3/31/15	32.9791	654758106	3/31/15	24.33	46548790	3/31/15	31.108	4554567640
2/27/15	32.5336	605350178	2/27/15	25.76	39067503	2/27/15	32.115	4546141972
1/30/15	29.6234	598304542	1/30/15	24.715	38731129	1/30/15	29.29	5221054452

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!

You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return (%) Manager Y Return (%) 1 -1.0 -5.0 2 -1.0 -4.0 3...

can you help me for question B until D? Problem 18-05 You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return...

18.5 a. For each manager, calculate (1) the average annual return, (2) the standard deviation calculations. Round your answers to two decimal places. b. Assuming that the average annual risk-free...

the 1st picture is my question. the second picture is a example of how to solve it. Problem 18-05 You are evaluating the performance of two portfolio managers, and you have gathered annual return...

6. You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return (%) Manager Y Return (%) 1 -1.5 -6.5 2 -1.5 -3.5 3...

Below are monthly returns for the 4-week T-bill, the S&P 500 index, Duke Energy (DUK), Netflix (NFLX), Amazon.com (AMZN), and The Coca-Cola Company (KO). Use the monthly returns and Excel...

I will rate you, thanks You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: a. For each manager, calculate (1) the average...

You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: a) For each manager, calculate (1) the average annual return, (2) the...

11.0 You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: X Year Manager X Return (%) Manager Y Return (%) 1 -2,5 -4.0 2 -2.5...

1 7 8 You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return (%) Manager Y Return (%) -2.5 -4.0 2 -2.5 -3.0...

A certified check for $ 16 payable to Sam Goody was altered (after it had been certified) to $ 1,600. The check was then used to pay for merchandise that had been ordered from Goody costing $ 1,600....

The following data is available for three different alternatives. Assume an interest rate of 9% per year, compounded annually. Alternative A 5,000 725 infinite Initial Cost Annual Benefit Useful Life...

The following gifts are received in 2 0 2 2 by a not - for - profit entity: $ 3 , 0 0 0 specified by the donor to be used to pay salarles. $ 1 2 , 0 0 0 specified by the donor for new conference room...

Journal Entries for Sale, Return, and Remittance-Perpetual System On September 13, Brady Company sold merchandise with an invoice price of $1,400 ($1,100 cost), with terms of 2/10, n/30, to Dalton...