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.

Reviews

Write a Review

Financial Management Questions & Answers

  What would the effective interest rate be on this loan

Wu Corporation has been offered a loan of $1,000,000 at a rate of 8.5%, simple interest, with monthly interest payments and a 365-day year. What would the effective interest rate be on this loan? If Wu's $1,000,000 loan had been 8.5%, add-on, payable..

  Devise a strategy to compete in this environment

Much of the intense competition in the financial services industry comes from products that are the most standardized, such as mortgages, automobile loans, money market accounts, savings accounts, and so on. These products will offer very low profit ..

  If we want to get some idea about an over time between two

1 which of the statements below is false?a if you invest money for a short period and buy a six-month cd you will not

  What is the expected return on the portfolio

You own a portfolio that is 32 percent invested in Stock X, 20 percent in Stock Y, and 48 percent in Stock Z. The expected returns on these three stocks are 6 percent, 19 percent, and 15 percent, respectively. What is the expected return on the portf..

  Adding robotic paint sprayer to its production line

The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer’s base price is $1,080,000, and it would cost another $22,500 to install it. The machine falls into the MACRS 3-year class, and it would be sold af..

  What is the project payback period if the initial cost

An investment project provides cash inflows of $705 per year for eight years. What is the project payback period if the initial cost is $1,450? What is the project payback period if the initial cost is $5,800?

  What is the effective annual rate annual percentage yield

You plan to apply for a loan from Bank of America. The nominal interest rate for this loan is 7.67 percent, compounded daily (with a 365 day per year.) What is the effective annual rate (EAR) annual percentage yield, of this loan?

  Prepare single-step income statement for the year ended

Prepare a single-step income statement for the year ended December 31, 2012. Include earnings per share for earnings before extraordinary items and net income. Prepare a multiple-step income statement. Include earnings per share for earnings before e..

  Firm can overcome the resistance of noncustomers

Identify and discuss at least five reasons why potential customers do not purchase a firm’s goods or services. For each reason, discuss ways that the firm can overcome the resistance of noncustomers.

  Mutual fund and annual rate of return

Suppose you are committed to owning a $195,000 Ferrari. If you believe your mutual fund can achieve a 13 percent annual rate of return and you want to buy the car in 10 years on the day you turn 30, how much must you invest today?

  Make in order to partake of future cybernetic goodness

You estimate that you will need $716 thousand in 30 years to buy some cybernetic body enhancements, including infrared vision, retractable claws, and expanded brain storage capacity. To achieve your financial goal, you want to make three equal-sized ..

  Is there any benefit of combining the two stocks

A portfolio is invested 40 percent in Stock G and 60 percent in Stock J. The expected returns on these stocks are 10 percent and 15 percent respectively. The standard deviations of these stocks are 10% and 18% and the correlation coefficient between ..

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