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
-
Width of diffraction maximum we suppose that in a linear crystal there are identical point scattering centers at every lattice point pm = m a, where m is an integer. By analogy with (20), the total...
-
A set of eight \(30-\mathrm{kW}\) motor-pump units is used to deliver water through an elevation of \(30 \mathrm{~m}\). The efficiency of the pumps is specified to be 65 percent. Estimate the...
-
Choose letter \(\mathrm{C}\) (for committed fixed cost) or \(\mathrm{D}\) (for discretionary fixed cost) to indicate the type of each of the following described costs. a. Professional meeting...
-
Tim Jarosz Company had the following account balances at year-end: Cost of Goods Sold $60,000, Inventory $15,000, Operating Expenses $29,000, Sales Revenue $115,000, Sales Discounts $1,200 and Sales...
-
Licensees can gather adverse facts by having the seller complete the disclosure or disclaimer form, verifying seller information by checking public records, ___________________, and reviewing survey...
-
Lunatics, an e-commerce sports company wants to buy Rowdy Trading Cards at a cost of $504 million. Rowdy will operate for 20 years. They expect annual cash flows from operations to be $70.1 million...
-
2-3: Determine the yield strength-to-density ratios (specific strength) in units of kN m/kg for AISI 1018 CD steel, 2011-T6 aluminum, Ti-6Al-4V titanium alloy, and ASTM No. 40 gray cast iron. 2-4:...
-
Evaluate. 2|9 1 () 7 3 Write your answer in simplest form.
-
For the arithmetic sequence beginning with the terms {-2, 0, 2, 4, 6, 8...), what is the sum of the first 18 terms?
-
Solve 23z + 19 = 3(5z - 9) + 8z + 46.
-
1. a) State the restrictions (domain) for log3(x+5)=2-log, (x-3)
-
Determine if the given system is consistent. Do not completely solve the system. - 6x4 = -14 2X1 2x2 +23 = 0 X3 +6x4 = 0 - 5x1 +3X2 +5X3 + x4 = 60 9
-
Describe a situation where your decision making was influenced by some sort of decision making bias. What would you do differently now after having recognized that you employed that bias in that...
-
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...
-
Thornhill Company's income statement shows gross profit of \(\$ 432,000\), cost of goods sold of \(\$ 638,000\), and other expenses totaling \(\$ 390,000\). Compute the amounts of (a) revenue from...
-
Which of the following is not considered in determining contribution to common expenses? a. Income taxes b. Cost of goods sold c. Traceable expenses d. Netsales
-
The manager of which of the following segments of a business is responsible for revenue generation as well as for cost and expense control? a. Cost center b. Accounting department c. Profit center d....
Study smarter with the SolutionInn App