Compute the weekly dollar return (for each week) for Amazon (AMZN), McKesson (MCK), and Kroger (KR)...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
? ????????? 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 50 Use your 44 use is 45 46 47 48 49 Made sales of product Cost for the inventory that was sold Amount of the invoice (above) that returns and...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
Is this a confined or unconfined aquifer? Please explain. 100 m amsl 78 m amsl 56 m amsl 48 m amsl A 50 m 11m B Clay Sand Clay 100 m
-
Draw the free-body diagram of the winch, which consists of a drum of radius 4 in. It is pin-connected at its center C, and at its outer rim is a ratchet gear having a mean radius of 6 in. The pawl AB...
-
Write a program (or series of programs) to test all the MINIX 3 system calls. For each call, try various sets of parameters, including some incorrect ones, to see if they are detected.
-
General Mills, Inc. The fiscal year 2017 annual report of General Mills, Inc. is available on this book's Website. Required a. Calculate (or identify) the following financial ratios for 2016 and...
-
The file Banks.csv includes data on a sample of 20 banks. The Financial Condition column records the judgment of an expert on the financial condition of each bank. This outcome variable takes one of...
-
6. In 2021, Art Corporation purchased land from its sole shareholder Michelle for 200,000. Michelle's basis in the land was 20,000. The land was recently appraised for 150,000, but Art paid 50,000...
-
On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and...
-
1. Consider multiplication of two matrices A and B. each of size nxn. Let the product be matrix C = A x B. Suppose n = 2 for some integer k. Consider the classical matrix multiplication algorithm...
-
What considerations affect the choice of a backup site?
-
Briefly describe the major components of a backup plan.
-
Briefly explain the difference between a hot-site and cold-site backup and recovery facility.
-
What are the purposes of the test-plan component of a disaster recovery plan? How does a "phased approach" facilitate testing of disaster recovery procedures?
-
Briefly describe the major components of a recovery plan. Why are the responsibilities of the recovery committee an important component of the plan?
-
Measure the following quantities: R - Range (at the location where projectile hits the ground) TE - Flight Time (at the location where projectile hits the ground) H - Maximum Height (at the peak of...
-
Nike manufactures shoes and sportswear. How has the Internet changed the way this company communicates with its suppliers and retail customers?
-
Prime Contractors (Prime) is a privately owned company that contracts with the U.S. government to provide various services under multiyear (usually five-year) contracts. Its principal services are as...
-
Lowe's Companies, a retailer of home improvement products, reported cost of goods sold of $31,729 million for Year 1. It reported merchandise inventories of $7,611 million at the beginning of Year 1...
-
Foreign Sub is a wholly owned subsidiary of U.S. Domestic Corporation. U.S. Domestic Corporation acquired the subsidiary several years ago. The financial statements for Foreign Sub for 2014 in its...
-
Sometimes total spending is excessive, and _________ occurs.
-
Sometimes total spending is insufficient, and _________ occurs.
-
In the case of market _________, appropriate government policies could improve on market outcomes.
Study smarter with the SolutionInn App