Calculate the continuously compounded returns

Assignment Help Other Subject
Reference no: EM131449764

Download into Excel the monthly closing values of the Russell 2000 Index, Nikkei 225 Index, and the Dow Jones Industrial Average for the period January 1988 through the end of last month.

Calculate the continuously compounded returns for each month for each index. Calculate the average return, variance, standard deviation, covariance, correlation coefficient and beta for all possible combinations of returns.

Imagine that your grandparents had a portfolio weighted 20% Russell, 50% Nikkei and 30% Dow Jones for that entire period. Calculate their return, variance and standard deviation for the portfolio.

Verified Expert

Both companies had data from 1988 January to 2017 February. Calculating the mean, return, correlation, Beta, it will help the management of the company to make the decision especially when selling and buying of shares.

Reference no: EM131449764

Questions Cloud

Explain sequence of operations that you use to solve problem : Explain: 1) The sequence of operations that you use to solve the problem, and 2) Why this sequence of operations correctly solves the problem.
Importance of indexes for unstructured data warehouses : Define the importance of indexes for unstructured data warehouses. Provide an example of unstructured data and the indexes that you would define to manage.
Explain the essential skills that would make a person good : Describe two (2) financial career options that an individual with a finance education might pursue and explain the value that such a position adds to a company.
Unless specified in the useradd command : When creating user account using useradd how is the default group determined?
Calculate the continuously compounded returns : Calculate the continuously compounded returns for each month for each index. Calculate the average return, variance, standard deviation, covariance, correlation coefficient and beta for all possible combinations of returns.
Describe the supply chain management : Briefly describe the supply chain management (SCM) process. Discuss the role of SCM in e-business and e-commerce.
Design a class checkoutsystem : Design a class CheckoutSystem. Each checkout system has a method checkout that accepts the order and a credit cart as arguments and checkouts the items.
Justify the agenda-setter model : Consider the agenda-setter model of Romer and Ro-senthal (1978) (sec also Shepsle 1981). The object of the game is to make a one-dimensional decision.
Create an application that lets the user enter : Create an application that lets the user enter the amount that he or she has budgeted for a month.

Reviews

inf1449764

4/12/2017 6:27:03 AM

Use only closing prices (not open, high, low). Create a column for the returns using the logs for each index. Calculate the statistics above based on the columns of returns not the rows. I’m attaching the files I used as examples for Mod 10 and 11. Here is an example of 10 and 11 attached.

Write a Review

Other Subject Questions & Answers

  Successful introduction for academic paper

What elements go into a successful introduction for an academic paper? Which do you think are the most important and why? What might work best for your research paper?

  Explain the waxman-markey law achieve production efficiency

Would the Waxman-Markey law achieve production efficiency. Is the $846 billion that electricity producers would pay for the right to emit part of the opportunity cost of reenhouse gasses producing electricity

  Perfectly competitive with the usual-looking cost curves

Consider a firm that is perfectly competitive with the usual-looking cost curves. (An upward-sloping MC curve and U-shaped AVC and ATC curves.)

  Difference between direct and indirect observational methods

Explain the difference between direct and indirect observational methods and how the degree of intervention can be used to distinguish direct observational methods.

  Major advantage of a within participants design

What is the major advantage of a within participants design?

  What is meant by the social construction of race

Is your race more a matter of how you view yourself or of how others view you? In what ways is how you view yourself influenced by our society and culture?

  What is the role of the supreme court

In your reading from week 2 you read, "The Supreme Court in the American System of Government". On this webpage you read an excerpt by Retired Chief Justice Charles Evans Hughes on the role of the Supreme Court. Explain the two theories of constitu..

  Compare and contrast the approaches to performance-based pay

Compare and contrast the approaches to performance-based pay used by Lincoln Electric and Southwest Airlines. Overall, which plan do you think is more effective? Why?

  Similarities in the south and the west

using your table, which explains the major social and economic similarities that occurred in the South and the West.

  Web-based information for health and wellness education

What are the benefits and negative consequences of using web-based information for health and wellness education, medical diagnoses, and treatment?

  Describe the psychological effects of violence

Describe the psychological effects of violence that the children from Nigeria might be experiencing? Be sure to consider issues such as gender and age

  Discuss the difference between hearing and listening

Let's discuss the difference between hearing and listening. Look at Consider this Case on page 56 about how storytelling can facilitate effective listening. When you answer these questions, please use a story to describe your examples of "tuning o..

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