Compute the weekly dollar return (for each week) for Amazon (AMZN), McKesson (MCK), and Kroger (KR)...

Transcribed Image Text:

Compute the weekly dollar return (for each week) for Amazon (AMZN), McKesson (MCK), and Kroger (KR) stock using the data provided (below and to the left) Q2 Using the weekly dollar return in your formula/answer (w. an Excel formula reference), compute the weekly percent return for each week for Amazon (AMZN), McKesson (MCK), and Kroger (KR) stock Comp for KR using Week 1 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Weekly adj. closing prices (S) MCK 133.30 131.03- 132.44 129.19 130.78 116.95 123.88 129.21 122.38 119.68 122.98 AMZN 1,915.01 2,003.00 1,889.65 1,788.61 1,764.03 1,642.81 1,665.53 1,712.43 1,593.41 1,502.06. 1,690.17. 1,629.13 1,591.91 1,377.45 1,478.02 1,575.39 1,640.56 1,696.20 1,670.57 1,626.23 1,588.22 1,607.95 1,631.56 1,671.73 1,620.80 1,712.36 1,764.77 1,780.75 1,837.28 1,843.06 1,861.69 1,950.63 1,962.46 1,889.98 1,869.00 1,823.28 1,775.07 1,804.03 1,869.67 1,911.30 1.893.63 123.80 115.59 107.35 109.03 113.28 121.04 125.51 125.89 126.16 127.31 134.32 130.29 123.39 111.18 118.53 117.82 116.34 115.99 115.34 113.40 116.86 122.73 130.06 124.24 129.13 121.39 129.89 132.73 132.66 133.99 KR 29.30 28.48 28.44 26.34 26.97 26.98 29.52 30.71 29.59 29.18 29.15 28.67 29.04 26.93 27.11 27.18 27.94 28.92 27.64 27.59 27.35 28.99 28.17 27.67 24.17 24.06 24.04 24.29 23.60 25.35 25.46 24.69 25.42 25.51 23.92 23.56 22.65 23.76 24.09 22.09 21.56 Compute the weekly dollar return (for each week) for Amazon (AMZN), McKesson (MCK), and Kroger (KR) stock using the data provided (below and to the left) Q2 Using the weekly dollar return in your formula/answer (w. an Excel formula reference), compute the weekly percent return for each week for Amazon (AMZN), McKesson (MCK), and Kroger (KR) stock Comp for KR using Week 1 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Weekly adj. closing prices (S) MCK 133.30 131.03- 132.44 129.19 130.78 116.95 123.88 129.21 122.38 119.68 122.98 AMZN 1,915.01 2,003.00 1,889.65 1,788.61 1,764.03 1,642.81 1,665.53 1,712.43 1,593.41 1,502.06. 1,690.17. 1,629.13 1,591.91 1,377.45 1,478.02 1,575.39 1,640.56 1,696.20 1,670.57 1,626.23 1,588.22 1,607.95 1,631.56 1,671.73 1,620.80 1,712.36 1,764.77 1,780.75 1,837.28 1,843.06 1,861.69 1,950.63 1,962.46 1,889.98 1,869.00 1,823.28 1,775.07 1,804.03 1,869.67 1,911.30 1.893.63 123.80 115.59 107.35 109.03 113.28 121.04 125.51 125.89 126.16 127.31 134.32 130.29 123.39 111.18 118.53 117.82 116.34 115.99 115.34 113.40 116.86 122.73 130.06 124.24 129.13 121.39 129.89 132.73 132.66 133.99 KR 29.30 28.48 28.44 26.34 26.97 26.98 29.52 30.71 29.59 29.18 29.15 28.67 29.04 26.93 27.11 27.18 27.94 28.92 27.64 27.59 27.35 28.99 28.17 27.67 24.17 24.06 24.04 24.29 23.60 25.35 25.46 24.69 25.42 25.51 23.92 23.56 22.65 23.76 24.09 22.09 21.56

Answer rating: 100% (QA)

Answer I The weekly dollar return can be calculated as Current Week closing price Previous Week Clos... View the full answer