Best Return Date

For APPL Stock, find the following:

1) Using Excel functions, find the date of the highest holding period return.

2) Using Excel functions, find the stock price on the date of the highest holding period

return.

3) Using Excel functions, find the date of the second best holding period return.

Best Return Date For APPL Stock, find the following: 1) Using Excel functions, find the date of the highest holding period return. 2) Using Excel functions, find the stock price on the date of the highest holding period return. 3) Using Excel functions, find the date of the second best holding period return. Date APPL Stock Closing Price 10/3/16 26.381451 10/4/16 26.49399 10/5/16 26.505716 10/6/16 26.702665 10/7/16 26.742523 10/10/16 27 209095 10/11/16 27.267714 10/12/16 27511551 10/13/16 27.427147 10/14/16 27579542 10/17/16 27560793 10/18/16 27 542032 10/19/16 27.459969 10/20/16 27.445904 10/21/16 27-338049 10/24/16 27584236 10/25/16 27.724907 10/26/16 27.101238 10/27/16 26.840994 10/28/16 26.662802 10/31/16 26.620602 11/1/16 26.139957 11/2/16 26.163403 11/3/16 25.882963 11/4/16 25.649656 11/7/16 26.019653 11/8/16 26.172832 11/9/16 26.130411 11/10/16 25.40221 11/11/16 25.553036 11/14/16 24.912027 11/15/16 25 241962 11/16/16 25 920671 11/17/16 25911245 11/18/16 25.937166 11/21/16 26 330727 11/22/16 26.347223 11/23/16 26.212894 11/25/16 26.34487 11/28/16 25.293018 11229/16 26 267096 11/30/16 26 045572 12/1/16 25 802835 12/2/16 25 899462 12/5/16 25 713287 12/6/16 12/7/16 12/8/16 12/9/16 12/12/16 12/13/16 12/14/16 12/15/16 12/16/16 12/19/16 12/20/16 12/21/16 12/22/16 12/23/16 12/27/16 12/28/16 12/29/16 12/30/16 1/3/17 1/4/17 1/5/17 1/6/17 1/9/17 1/10/17 1/11/17 1/12/17 1/13/17 1/17/17 1/18/17 1/19/17 1/20/17 1/23/17 1/24/17 1/25/17 1/26/17 1/27/17 1/30/17 1/31/17 2/1/17 2/2/17 273/17 2/6/17 27/17 2/8/17 2/9/17 2/10/12 25.911245 26.165764 26.422638 26.853901 26.70072 27.146126 27.146126 27.294594 27 329947 27.487837 27.56089 27.586817 27.405357 27.459558 27.633949 27.516119 27.509047 27.294594 27.372358 27.341728 27.480768 27.787132 28.041647 28.069925 28.220751 28.102921 28.053431 28.279663 28.277306 28.227819 28.279663 28.298523 28.272596 28.722712 28.736858 28.739212 28.663797 28.597813 30.341728 30.289883 30.419497 30.704645 30 996868 31 11706 31341908 31.270903 2/13/17 2/14/17 2/15/17 2/16/17 2/17/17 2/21/17 2/22/17 2/23/17 2/24/17 2/27/17 2/28/17 3/1/17 3/2/17 3/3/17 3/6/17 3/7/17 3/8/17 3/9/17 3/10/17 3/13/17 3/14/17 3/15/17 3/16/17 3/17/17 3/20/17 3/21/17 3/22/17 3/23/17 3/24/17 3/27/17 3/28/17 3/29/17 33017 3/31/17 473/17 4/4/17 4/5/17 4/6/17 477/17 4/10/17 4/11/17 4/12/17 4/13/17 4/17/17 4/18/17 4/19/17 31.547832 31.957289 32.073265 32.0354 32.122971 32.354927 32.451969 32.31469 32.345463 32.409367 32.423557 33,086285 32.889843 33.08392 32.979774 33.022377 32.899307 32.823555 32.932442 32.94664 32.896931 33.244862 33.299305 33.133617 33.481552 33.098114 33.472084 33.353733 33.287472 33.344273 34.035397 34.111134 34.066162 34.002262 34.011734 34.264977 34.087463 34.002262 33.926521 33.886288 33521782 33.562023 33.38451 33.569126 33.420013 33.296936 4/20/17 4/21/17 4/24/17 4/25/17 4/26/17 4/27/17 4/28/17 5/1/17 5/2/17 5/3/17 5/4/17 5/5/17 5/8/17 5/9/17 5/10/17 5/11/17 5/12/17 5/15/17 5/16/17 5/17/17 5/18/17 5/19/17 5/22/17 5/23/17 5/24/17 5/25/17 5/26/17 5/30/17 5/31/17 6/1/17 6/2/17 6/5/17 6/6/17 6/7/17 6/8/17 6/9/17 6/12/17 6/13/17 6/14/17 61517 6/16/17 6/19/17 6/20/17 6/21/17 6/22/17 6/23/17 33.713512 33.673271 33.99752 34.208176 34.006996 34.03302 33.999889 34.693382 34.913494 34.806995 34.681545 35.256702 36.215271 36.44722 36.274445 36.588158 37.099136 37.00407 36.949406 35.708801 36.253052 36.376637 36.59766 36.552509 36.443176 36.569134 36507351 36.521606 36.305336 36.405151 36.944649 36.583397 36.706985 36.925636 36.835323 35.406971 34.560886 34 838963 34.499107 34.292336 33.812263 34.779537 34.463448 34.667831 34 610802 34 765278 7/30/21 8/2/21 8/3/21 8/4/21 8/5/21 8/6/21 8/9/21 8/10/21 8/11/21 8/12/21 8/13/21 8/16/21 8/17/21 8/18/21 8/19/21 8/20/21 8/23/21 8/24/21 8/25/21 8/26/21 8/27/21 8/30/21 8/31/21 9/1/21 9/2/21 9/3/21 9/721 9/8/21 9/9/21 9/10/21 9/13/21 9/1421 9/15/21 9/16/21 9/17/21 9/20/21 9/21/21 9722721 9/23/21 9/24/21 9/27/21 9/28/21 9/29221 9/30/21 145.641785 145.302307 147.139542 146.730164 146.839996 146.139999 146.089996 145.600006 145.860001 148.889999 149.100006 151119995 150.190002 146.360001 146.699997 148.190002 149.710007 149.619995 148.360001 147.539993 148.600006 153.119995 151.830002 152.509995 153.649994 154.300003 156.690002 155.110001 154.070007 148.970001 149.550003 148.119995 149029999 148.789993 146.059998 142.940002 143.429993 145.850006 146.830002 146.919998 145.369995 141910004 142830002 1415