Reference no: EM131151936
Homework: Computation of Dow Jones Industrial Average
1. Collect the names and closing share prices of the 30 companies in the DJIA from a recent WSJ or any other source (e.g., https://finance.yahoo.com). Compute the value of the DJIA using the divisor reported in the WSJ.State the date you picked for the computation.
2. Compare the value you computed with the value of the DJIA reported in the WSJ for the day you used. Are the two values same? Attach copy of the DJIA value for the date you picked from WSJ or other publication.
3. What is the weight of each company in the DJIA you computed?
4. Collect data on the number of shares traded for each company on the day you selected.
(a) Compute the market value of shares traded for each company.
(b) Compute the weight (wi) of each company using market value of each company in relation to the market value of all 30 companies. What is the sum of these weights?
(c) Identify companies with the highest and lowest weights. What explains the difference in weights?
(d) Compute "market value-weighted" average of the prices of the 30 companies included in the DJIA. (This is for exercise only- the MV weighted average would not represent the true picture of the price changes since the number of sharestraded on a given day is not a good proxy of the total number of shares outstanding for the company; however, the methodology to compute a more representative average is correct.)
5. Compute the value of the DJIA as in #1except that you use 30 as the divisor. Compare this value with that in #4 above. Which one is more realistic as a measure of "average price" of the 30 stocks in DJIA and why?
NOTES:
1. Each student works with a different set of prices of companies.
2. Clearly indicate the date you used.
3. The HW must be submitted in Excel. Use one worksheet for the narrative (Q1) and different worksheet for the showing computations.
4. Must show all computations using Excel
5. Multiple submissions of the same homework would be considered cheating and be penalized.
|
Calculate the monthly payment of principal and interest
: Calculate The monthly payment of principal and interest (PI). One-twelfth of annual property tax payments and hazard insurance payments.
|
|
Market her innovative line of data services
: Stephanie has an idea for a business that she thinks could be very lucrative. After occasionally traveling abroad, she wants to create a website to appeal to consumers worldwide and market her innovative line of data services. Communication among cou..
|
|
How much total work does it produced
: A heat engine accepts 200,000 kJ of heat from a source at 800 K and rejects 100,000 kJ of heat to a sink at 300 K. Calculate the entropy change of all the components of this engine and determine if it is completely reversible. How much total work ..
|
|
Identify the ethical code number and definition
: Discuss the ethical issues presented in this scenario; identify the ethical code number and definition. Describe the limits of confidentiality that must be considered.
|
|
Compute the market value of shares traded for each company
: Compute the market value of shares traded for each company. Compute the weight (wi) of each company using market value of each company in relation to the market value of all 30 companies. What is the sum of these weights?
|
|
What are the concerns about applying this theory?
: Identify the statistics for incidence and rate of your selected crime in the U.S. Evaluate any issues you find with the statistics and state if these statistics are accurate. Why or why not?
|
|
Important issues that we face as a society
: What do you think are the two most important issues that we face as a society and why? What are some ways that the business community might be able to help solve those two critical social issues
|
|
Supply chain to achieve zero weeks
: If fewer weeks of supply and higher inventory turnover are better, is it possible for a supply chain to achieve zero weeks of supply and infinite inventory turns? Why or why not? Discuss with reasoning.
|
|
Discuss how sex or gender impacts the work equation
: Discuss how sex or gender impacts the work equation between agency staff members. Be specific in your responses and illustrate using examples. Make sure that you support your points using scholarly sources.
|