Calculate the average daily change in the index

Assignment Help Accounting Basics
Reference no: EM131748317

Problem - Assume that the spreadsheet below shows the closing prices for the S&P 500 Index for the month of November 2012. Using a column with six decimal places:

a. Calculate the daily percentage changes in the S&P 500 Index. The lag daily change is for 11/1/2012, resulting in 21 daily changes.

b. Calculate the average daily change in the Index, shown to 6 decimal places.

c. State the average daily change in the S&P 500 Index for the month of November 2012 as a percentage.

d. State the implied monthly change in the S&P 500 Index for the month of November 2012 as a percentage. (Notice the word implied-this in fact is not the correct percentage change for the month, as we will learn when we discuss the difference between the arithmetic mean and the geometric mean).

Data

Closing Pr

11/30/2012

1,400.38

11/29/2012

1,398.26

11/28/2012

1,390.84

11/27/2012

1,385.35

11/23/2012

1,375.93

11/22/2012

1,394.35

11/21/2012

1,390.71

11/20/2012

1,411.4

11/19/2012

1,426.63

11/16/2012

1,425.35

11/15/2012

1,423.57

11/14/2012

1,408.66

11/13/2012

1,403.04

11/12/2012

1,403.58

11/9/2012

1,388.28

11/8/2012

1,397.68

11/7/2012

1,392.37

11/6/2012

1,418.26

11/5/2012

1,407.49

11/2/2012

1,411.9

11/1/2012

1,409.34

10/31/2012

1,385.59

Reference no: EM131748317

Questions Cloud

What is the invention and when was it discovered : What is the discovery/invention, when was it discovered/invented, who discovered/invented it? How does it work? Be specific about the science of how it works.
Gain from substituting cultures for structure : In some sense, organization cultures may be considered to be substitutes for organization structures.
Discuss the dollar-value lifo retail inventory method : Connie Chung Corporation adopted the dollar-value LIFO retail inventory method
Discuss about the predicting physical activity : Predicting physical activity. Participation in physical activities typically declines between high school and young adulthood. This suggests that postsecondary.
Calculate the average daily change in the index : Calculate the average daily change in the Index, shown to 6 decimal places. Calculate the daily percentage changes in the S&P 500 Index
Drug trade insouth east asia : It's your job to show me how it relates - Start with a thesis or argument - Drug Trade in South East Asia
Discuss the internal control considerations : Discuss the internal control considerations, and identify issues and risk mitigation strategies
Compute confidence interval for the odds ratio : Online consumer spending. The Consumer Behavior Report is designed to provide insight into online shopping trends. One recent report asked the question.
Read and write a two page review on proem of evil : Mackis, Evil and Omnipotence" Plantinga, The free will defense Hick Evil & soul making Rowe Inductive Argument from evil against the existence of God

Reviews

Write a Review

Accounting Basics Questions & Answers

  Determine the holding period return for each investment

Determine the holding period return for each of the three investment alternatives open to Hector Francisco.

  Prepare an answer sheet with the column headings shown

Record transactions and adjustments. Prepare an answer sheet with the column headings shown after the following list of transactions.

  What might be the advantages of leasing the assets instead

What might be the disadvantages of leasing the assets instead of owning them?

  Explain some examples of input validation

Explain some examples of input validation checks that you have noticed when filling out forms on websites you have visited.

  What is the difference between a value chain

What is the difference between a value chain and a supply chain?

  What are some measurable benefits from private equity

What are some measurable benefits from private equity ownership of corporations?

  Prepare a production budget for next year

Prepare a production budget for next year - East Mountain Bike expects to sell 25,000 electronic bicycles next year

  Calculate and interpret the npvs for both scenarios

Solve for the number of payments that results in an NPV of $0. Calculate and interpret the NPVs for both scenarios

  What is the amount of uncollectible accounts expense for

classic auto parts sells new and used auto parts. although a majority of its sales are cash sales it makes a

  Product costs and period costs the costs that follow were

product costs and period costs the costs that follow were extracted from the accounting records of several different

  Compute the amount lyle

Lyle O 'Keefe invests $21,900 at 8% annual interest, leaving the money invested without withdrawing any of the interest for 9 years. At the end of the 9 years, Lyle withdrew the accumulated amount of money.

  Evaluate the cost of merchandise purchased and for sale

What is the difference between the cost of merchandise purchased and the cost of merchandise available for sale? Can they be the same amount? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd