1.a The stock prices for Wal-Mart and Target are shown below for the start of each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1.a The stock prices for Wal-Mart and Target are shown below for the start of each year since 2001. Calculate each year's percentage return for each stock. Wal-Mart and Target Stock Prices Date 1-Jan-01 1-Jan-02 1-Jan-03 1-Jan-04 1-Jan-05 1-Jan-06 1-Jan-07 1-Jan-08 1-Jan-09 1-Jan-10 1-Jan-11 1-Jan-12 1-Jan-13 1-Jan-14 1-Jan-15 1-Jan-16 1-Jan-17 Wal-Mart Closing price 41.6056 44.1860 35.4011 40.1495 39.4375 35.1342 36.8749 39.9832 37.7786 43.7688 46.9882 52.8295 61.7105 67.5019 78.7359 63.1936 65.4011 Return (%) Date 1-Jan-01 1-Jan-02 1-Jan-03 1-Jan-04 1-Jan-05 1-Jan-06 1-Jan-07 1-Jan-08 1-Jan-09 1-Jan-10 1-Jan-11 1-Jan-12 1-Jan-13 1-Jan-14 1-Jan-15 1-Jan-16 1-Jan-17 Target Closing price 28.47 33.49 21.41 29.03 39.08 42.44 47.96 43.71 24,94 41.68 45.29 42.88 52.15 50.07 67.15 67.97 62.50 Return (%) 33 34 1.b. Please graph the annual rates of return for each company with time on the horizontal axis and 35 rate of retun on the vertical. 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 1.c. Can you tell from the graph which stock has the highest average returns? Which seems to have 54 the most variable returns? [There isn't really a right answer here.] 55 56 57 58 59 60 61 62 1.d. Now calculate the average annual returns - both arithmetic and geometric for the two stocks. 63 64 65 Arithmetic average return 66 67 Geometric average return 68 Wal-Mart Arithmetic average return Geometric average return 69 1.e. Explain how the meanings of the arithmetic and geometric averages differ? When would we 70 prefer to use the simple average? When would we want to use the compound average? 71 72 73 74 75 76 77 78 79 80 81 82 83 1.f. Calculate the standard deviations of the returns for Wal-Mart and Target. 84 85 Standard deviation of 86 returns for Wal-Mart 87 88 1.g Calculate the Coefficient of Variation (CV) of each stock's returns. 89 90 CV of returns for Wal-Mart 91 Standard deviation of returns for Target Target's CV of returns for Target 92 93 1.h Based on the standard deviation that you just calculated, which stock is more risky? 94 95 96 97 98 99 100 101 102 1.i. Which stock would you choose to invest in? Explain. (HINT- There is no right answer here) 103 104 105 106 107 108 109 1.a The stock prices for Wal-Mart and Target are shown below for the start of each year since 2001. Calculate each year's percentage return for each stock. Wal-Mart and Target Stock Prices Date 1-Jan-01 1-Jan-02 1-Jan-03 1-Jan-04 1-Jan-05 1-Jan-06 1-Jan-07 1-Jan-08 1-Jan-09 1-Jan-10 1-Jan-11 1-Jan-12 1-Jan-13 1-Jan-14 1-Jan-15 1-Jan-16 1-Jan-17 Wal-Mart Closing price 41.6056 44.1860 35.4011 40.1495 39.4375 35.1342 36.8749 39.9832 37.7786 43.7688 46.9882 52.8295 61.7105 67.5019 78.7359 63.1936 65.4011 Return (%) Date 1-Jan-01 1-Jan-02 1-Jan-03 1-Jan-04 1-Jan-05 1-Jan-06 1-Jan-07 1-Jan-08 1-Jan-09 1-Jan-10 1-Jan-11 1-Jan-12 1-Jan-13 1-Jan-14 1-Jan-15 1-Jan-16 1-Jan-17 Target Closing price 28.47 33.49 21.41 29.03 39.08 42.44 47.96 43.71 24,94 41.68 45.29 42.88 52.15 50.07 67.15 67.97 62.50 Return (%) 33 34 1.b. Please graph the annual rates of return for each company with time on the horizontal axis and 35 rate of retun on the vertical. 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 1.c. Can you tell from the graph which stock has the highest average returns? Which seems to have 54 the most variable returns? [There isn't really a right answer here.] 55 56 57 58 59 60 61 62 1.d. Now calculate the average annual returns - both arithmetic and geometric for the two stocks. 63 64 65 Arithmetic average return 66 67 Geometric average return 68 Wal-Mart Arithmetic average return Geometric average return 69 1.e. Explain how the meanings of the arithmetic and geometric averages differ? When would we 70 prefer to use the simple average? When would we want to use the compound average? 71 72 73 74 75 76 77 78 79 80 81 82 83 1.f. Calculate the standard deviations of the returns for Wal-Mart and Target. 84 85 Standard deviation of 86 returns for Wal-Mart 87 88 1.g Calculate the Coefficient of Variation (CV) of each stock's returns. 89 90 CV of returns for Wal-Mart 91 Standard deviation of returns for Target Target's CV of returns for Target 92 93 1.h Based on the standard deviation that you just calculated, which stock is more risky? 94 95 96 97 98 99 100 101 102 1.i. Which stock would you choose to invest in? Explain. (HINT- There is no right answer here) 103 104 105 106 107 108 109
Expert Answer:
Answer rating: 100% (QA)
1a Calculate the percentage returns for each year for Walmart and Target For Walmart 2002 Return 441860 416056416056 00583 583 2003 Return 354011 441860441860 01979 1979 2004 Return 401495 35401135401... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025372
4th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
The following data are from Gennings, Chinchilli, and Carter, (1989). An in vitro toxicity study of isolated hepatocyte suspensions was conducted to study the impact of combining carbon tetrachloride...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Currently Amazon Go is being test marketed in a few cities ONLY in the United States. AmazonGo is a unique grocery store where people check-in to the store using their phones, take what they want and...
-
Using Figure 11.25 and the related text, describe the features of terracing, and list the major alterations to soil and water brought about by this agricultural method. Figure 11.25
-
Look again at question 5. Suppose (a) That it costs $95 to classify each new credit applicant and (b) That an almost equal proportion of new applicants falls into each of the four categories. In what...
-
A flywheel with a radius R=200 mm is designed to spin up to 8000 rpm. It is proposed to make it out of ductile (nodular) cast iron, but the casting shop can guarantee only that it will have no...
-
In a test of homogeneity, the alternate hypothesis says that the distributions in the rows are the same. In Exercises 68, determine whether the statement is true or false. If the statement is false,...
-
Please discuss the video "Fog of War" and proportionality in war. What was McNamara saying about proportionality during World War II? How do you think this impacted the decision making processes...
-
Consider the following information for Steering Stores for 2020 and 2021: 2020 2021 Total assets $66,640,000 $63,192,000 Noninterest-bearing current liabilities 4,928,000 5,544,000 Net income...
-
Cardinal Company is considering a five-year project that would require a $2,975,000 investment in equipment with a useful life of five years and no salvage value . The company's discount rate is 14%....
-
Discussion and analyze the influence a leader can have on the outcome of proposed organizational change with reference to the difference between leadership and management.
-
How can insights from experimental evolution and computational modeling elucidate the dynamics of adaptation in response to anthropogenic disturbances and climate change, informing conservation...
-
Write the first five terms of the sequence defined recursively. Express the terms as simplified fractions when applicable. a =3, a=4a-1+5 6 a2 az as
-
Consider a multi-threaded process with 10 threads. Thread 3 invokes an execlp() system call. Describe what will happen to each of the threads. 2. Suppose in a multithreaded process a thread makes a...
-
Quarter 4: Expand the market offering Review the market data from the test market. Adjust the division's strategy and tactics (brand design, pricing, advertising, service and sales personnel) as...
-
Compute the APY for each bank and round the percent to 4 decimal places. Then decide which bank would yield a higher saving account balance.
-
Justify whether the following relations are reflexive, symmetric, transitive, or antisymmetric. Also, determine if they are equivalence relations or partial order relations. (20 pts) (1) R = (R is a...
-
Determine the optimal use of Applichem's plant capacity using the Solver in Excel.
-
On January 2, 2013, Ubuy.com paid $100,000 to acquire 25 percent (10,000 shares) of the common stock of E-Net Corporation. The accounting period for both companies ends December 31. Give the journal...
-
Alison and Chuck Renny began operations of their furniture repair shop (Lazy Sofa Furniture, Inc.) on January 1, 2011. The annual reporting period ends December 31. The trial balance on January 1,...
-
Many retired people invest a significant portion of their money in bonds of corporations because of their relatively low level of risk. During the 1980s, significant inflation caused some interest...
-
The presence of air in the brake system fluid causes the brake pedal to feel __________________.
-
Three main components of pst brake antiskid systems are __________________, __________________ and a __________________.
-
__________________ pressure bleeding is not an option for power brakes; the air trapped in the brake system would be forced into the main hydraulic system, which should operate without air in the...
Study smarter with the SolutionInn App