Question

Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Closing Stock Price Stock August 15, 2016 $46.22 $36.33 $20.13 $59.57 $82.51 $32.54 August 15, 2013 $39.24 $35.73 $22.33 $60.93 $69.97 $29.27 0.72 August 15, 1987 $49.45 $9.48 $6.58 $25.21 $44.73 31.43 1.00 Divisor 0.70 Note: The number of shares of each stock outstanding has been the same on these dates. Therefore, the closing stock prices will behave identically to the closing market values Print DoneDeepa Chungi wishes to develop an average, or index, that can be used to measure the general behavior of stock prices over time. She has decided to include 6 closely followed, high-quality stocks in the average or index. She plans to use August 15, 1987, her birthday, as the base and is interested in measuring the value of the average or index on August 15, 2013, and August 15, 2016. She has found the closing prices for each of the 6 stocks, A through F, at each of the 3 dates and has calculated a divisor that can be used to adjust for any stock splits, company changes, and so on that have occurred since the base year, which has a divisor equal to 1.00. a. Using the data given in the table, EEB. calculate the market average, using the same methodology used to calculate the Dow averages, at each of the 3 dates-August 15, 1987, 2013, and 2016 b. Using the data given in the table and assuming a base index value of 10 on August 15, 1987, calculate the market index, using the same methodology used to calculate the S&P indexes, at each of the 3 dates. c. Use your findings in parts a and b to describe the general market condition-bull or bear that existed between August 15, 2013, and August 15, 2016 d. Calculate the percentage changes in the average and index values between August 15, 2013, and August 15, 2016. Why do they differ? a. The market average for 1987 isRound to two decimal places) The market average for 2013 isRound to two decimal places.) The market average for 2016 isRound to two decimal places) b. The market index for 1987 is (Round to two decimal places.) The market index for 2013 is(Round to two decimal places.) The market index for 2016isRound to two decimal places.) c. Both the market average and the market index show a general d. The percentage change in the average value is % (Round to two decimal places ) The percentage change in the index value is 96. (Round to two decimal places.) Why do they differ? (Select the best answer below.) O A. The numbers are the same because one is an average of stock prices on a particular day and the other is an index compared to a base period value. trend, indicating amarket. (Select from the drop-down menus.) B. The numbers are the same since, in an efficient market, both measures have to agree. O C. The numbers differ because one is an average of stock prices on a particular day and the other is an index compared to a base period value ( D. The numbers differ because one is an average of stock prices relative to a base period value and the other is an index on a particular day.

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Data Table (Click on the icon located on the top-right corner of the data table below...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Data Table (Click on the icon located on the top-right corner of the data table below...

    Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Closing Stock Price Stock August 15, 2016 $45.37 $36.82 $20.72 $58.85 $82.77 $31.04 August 15, 2013 $40.95 $35.77 $22.11 $60.25 $69.15 $29.36 0.73 August 15, 1987 $50.69 $10.38 $7.84 $25.32 $45.51 31.13 1.00 Divisor 0.68 Note: The number of shares of each stock outstanding has been the same on these dates. Therefore, the closing stock...

  • Data Table (Click on the icon located on the top-right corner of the data table below...

    Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Security Beta 1.37 0.77 -0.87 Print Done Assume the betas for securities A, B, and C are as shown here: EE a. Calculate the change in return for each security if the market experiences an increase in its rate of return of 12.5% over the next period b. Calculate the change in retum for ach...

  • (Click on the icon located on the top-right corner of the data table below in order...

    (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Projected Returrn Asset M 19% 19% 17% 14% 11% 11% Asset L Year 2018 2019 2020 2021 2022 2023 15% 15% 16% 18% 18% 18% Ass ma you ara cons dann g a o olo containing to asse s and M Assat L rapresent 44% oft a dolar value a. Calculare the projected portfolio return, . or...

  • (Click on the icon located on the top-right corner of the data table below in order...

    (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Stock Price $49.99 $51.16 $49.46 $51.93 $52.52 Dividend Jan 1 Mar 31 Jun 30 Sep 30 Dec 31 $0.59 $0.59 $0.76 $0.76 Using the data from the following table, EEB, calculate the return for investing in this stock from January 1 to December 31. Prices are after the dividend has been paid. The return from January 1...

  • 0 Data Table (Click on the icon located on the top-right corner of the data table...

    0 Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) 2 Year UnWN Cash inflows (CF) Project A Project B $10,000 $40,000 $20,000 $30,000 $30,000 $20,000 $40,000 $10,000 $20,000 $20,000 Print Done P10-3 (book/static) 15 Question Help Choosing between two projects with acceptable payback periods Shell Camping Gear, Inc., is considering two mutually exclusive projects. Each requires an initial investment of $100,000. John Shell,...

  • UP PUSS * Data Table (Click on the icon located on the top-right corner of the...

    UP PUSS * Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year* Recovery year 3 years 5 years 7 years 33% 20% 14% 45% 32% 25% 15% 18% 7% 12% OWN 10 years 10% 18% 14% 12% 9% 8% 9% 9% 7% 6% Print Done Question Help...

  • i Data Table (Click on the icon located on the top-right coner of the data table...

    i Data Table (Click on the icon located on the top-right coner of the data table below in order to copy its contents into a spreadsheet.) Cash inflows (CF) Project A $45,000 Year Project B $75,000 $45,000 $45,000 $45,000 $45,000 $45,000 $60,000 $30,000 $30,000 $30,000 $30,000 2 3 4 6 N L LO HW Score: 79.38%, 15.88 of 20 pts Score: 0.1 of 1 pt 14 of 16 (15 complete) P10-21 (book/static) Question Help All techniques, conflicting rankings Nicholson Roofing...

  • Data Table MI (Click on the icon located on the top-right corner of the data table...

    Data Table MI (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a ti spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes 10 years 10% 18% 14% 14% 45% 18% 4 5% 5% 5% 5% 10 Print Done P11-29 (similar to Question Help Integrative Investment decision Holliday Manufacturing is considering the replacement of an existing machine. The new machine costs $129 million...

  • (Click on the icon located on the top-right corner of the data table below in order...

    (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Creek Enterprises Income Statement for the Year Ended December 31, 2015 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses $29,987,000 20,980,000 $9,007,000 $3,041,000 1,818,000 183,000 956,000 Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate= 40%) Net...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT