Calculate the holding-period returns

Assignment Help Financial Management

Reference no: EM13937551

The following are end of the month prices for both the Standard & Poors 500 Index and Nike's Common stock. Using the data here calculate the holding-period returns, the average monthly return and the standard deviation for both the S&P 500 and Nike. Use Microsoft Excel to construct your submission.

2011 NIKE S&P 500 INDEX

June $89.98 $1,320.64

July $90.15 $1,292.28

August $86.65 $1,218.89

September $85.51 $1,131.42

October $96.35 $1,253.30

November $96.18 $1,246.96

December $96.37 $1,257.60

2012 NIKE S&P 500 INDEX

January $103.99 $1,312.41

February $107.92 $1,365.68

March $108.44 $1,408.47

April $111.87 $1,397.91

May $108.18 $1,310.33

June $98.45 $1,335.69

Reference no: EM13937551

Questions Cloud

Perfect cubes in two ways : Smallest x = sum of 2 perfect cubes in two ways

Calculate the store total revenue, total profit : The table below depicts the prices and total costs a local used-book store faces. The bookstore competes with a number of similar stores, but it capitalizes on its location and the word-of-mouth reputation of the coffee it serves to its customers...

Medication therapy for an elderly person : Describe in detail 3 ways that medication therapy for an elderly person is different than a younger or middle-age client

Write a c program for word game for a given name of word : Write a C++ Program for word game for a given name of word and profession. The program should ask user for name, age, city, college, profession, animal, and pet name to print the statement.

Calculate the holding-period returns : The following are end of the month prices for both the Standard & Poors 500 Index and Nike's Common stock. Using the data here calculate the holding-period returns, the average monthly return and the standard deviation for both the S&P 500 and Nike.

Calculate the projects internal rate of return : S. Miller is looking to expand an existing project. The expansion requires an immediate investment of $73 million. S. Miller anticipates that the project will generate one future cash flow of $200 million that will arrive at the end of year 6, and on..

Annual exchange rate volatility : Use one-period binomial model to find the value of a one-year American Put option on £ with an exercise price of $1.58/£. The current spot rate is $1.53/£. One-year forward rate is $1.52/£. One-year U.S. interest rate is 3.5%. Annual exchange rate vo..

Prepare the shareholders equity section of the balance sheet : The following account balances can be found in the general ledger of Abco Corporation at year-end. Prepare the shareholders' equity section of the balance sheet.

Determine the optimal production run quantity : Construct a P-chart for this process using 2σ limits and describe the variation in the process - construct a c-chart using 3σ limits for this process and indicate if the process was out of control at any time.

User Account

All Pages