Calculate the average daily change in the index

Assignment Help Financial Management
Reference no: EM131817221

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 last daily change is for 11/1/2012, resulting in 21 daily changes.

b. Calculate the average daily change in the Index, shown to six 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.)

Date 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,413.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.57

11/6/2012 1,418.26

11/5/2012 1,407.49

11/2/2012 1,413.9

11/1/2012 1,409.34

10/31/2012 1,385.59

Average =

Reference no: EM131817221

Questions Cloud

What does it mean that during certain times : What does it mean that during certain times, money has a negative time value?
What is his holding period return : what is his holding period return if today when he sells it, stock price rises by 25%? What if the stock price declines by 25%?
Standard insurance is developing long-life insurance policy : Standard Insurance is developing a? long-life insurance policy for people who outlive their retirement nest egg.
How long will it take for the account to be paid off : If the current balance is $16,500, how long will it take for the account to be paid off?
Calculate the average daily change in the index : Calculate the average daily change in the Index, shown to six decimal places.
Planning to make monthly deposits : You are planning to make monthly deposits of $330 into a retirement account that pays 8 percent interest compounded monthly
What is the operating cash flow-cash flow from assets : What is the cash flow from assets for 2016? What is the operating cash flow for 2016? What is the cash flow to creditors for 2016?
Common equity section of timeless technology : Below is the common equity section (in millions) of Timeless Technology's last two year-end balance sheets:
Convert revenues into operating cash flow : Which of the following measures refers to a firm’s ability to convert revenues into operating cash flow?

Reviews

Write a Review

Financial Management Questions & Answers

  What is the payback period of this investment

What is the payback period of this investment? If you require a payback period of two years, will you make the movie?

  The interest is discounted monthly

Company XYZ purchased some machinery and gave a five-year note with a maturity value of $20,000. The discount rate is 8% annually and the interest is discounted monthly. How much did the company borrow?

  Degree of financial leverage under each of three plans

What is the degree of financial leverage under each of the three plans? compute earnings per share (EPS) before the expansion and under the two alternatives.

  Future and present value of an annuity due

If you start making $130 monthly contributions today and continue them for five years, what’s their future value if the compounding rate is 9.25 percent APR? What is the present value of this annuity?

  What is the macaulay duration

A bond with a coupon rate of 8 percent sells at a yield to maturity of 7 percent. If the bond matures in 10 years, what is the Macaulay duration?

  Calculate the effective annual return fund investors

A mutual fund has been advertising that, had you deposited $250 per months in the fund for the last 10 years, you would now have accumulated $85,000. Assuming that these deposits were made at the beginning of each month for a period of 120 months. Ca..

  Calculate financial ratios using only one year data

Based on the financial statements of the latest available annual report,-  calculate the following financial ratios using only one year data.

  More relevant-the pretax or the aftertax cost of debt

Jiminy's Cricket Farm issued a 30-year, 10 percent semiannual bond 7 years ago. The bond currently sells for 86.5 percent of its face value. The company’s tax rate is 35 percent. What is the pretax cost of debt? %? What is the aftertax cost of debt? ..

  What is the equivalent annual cost of buying

A firm can lease a truck for 5 years at a cost of $42,000 annually. It can instead buy a truck at a cost of $92,000, with annual maintenance expenses of $22,000. The truck will be sold at the end of 5 years for $32,000. What is the equivalent annual ..

  Find the energy stored in the device

For a particular device the proportionality is q (t) = 10 -7 v (t). If v (t) = 0 for t -5000t) for t ≥ 0, find the energy stored in the device at t = 100 μs.

  What are the capital structure weights

What is the total market value of the firm? What are the capital structure weights?

  What are the yield to maturity and yield to call of call

What are the yield to maturity and the yield to call of a 20 year, 8% bond that is selling for $1150 has a call value of $1100 in year 6? Which will the investor make? We buy a 15 year, 10% bond yielding 9%. We sell it after 4 years when market rates..

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