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

  Being uncomfortable is often one of the first things

Being uncomfortable is often one of the first things that we notice when we have different beliefs. Right? Why do we feel this? What makes us like this?

  Discuss your mitigation plan in term of psychological trauma

Discuss your mitigation plan in terms of psychological trauma. For instance, explain how it will reduce anxiety in knowing that preventative measures are in place and integrated with the plan's phases.

  Describe the importance of correlation

Describe the importance of correlation (aka covariation) for humans and non-humans according to Alloy and Tabachnik.

  Geometry is a very broad field of mathematics composed of a

geometry is a very broad field of mathematics composed of a wide range of tools that can be used for problem solving.

  Portrayal on film or on stage

Compare and contrast one character citing a preference of the portrayal on film or on stage. Support your selection and with specific choices that the actors made in bringing their character to life.

  Businesss offices of regional-national

What role do local chapters or businesss offices of regional, national, or international corporations play in the determination of meeting sites?

  Describing sociological perspectives of functionalism

Critically discuss how the three major sociological perspectives of functionalism, conflict theory, and interactionism view the role of social institutions in society.

  Social status-social capital or human capital

Which of the following do you feel has a greater impact on health status: social status, social capital, or human capital?

  Works of renaissance painting

Choose three works of Renaissance painting, sculpture or architecture and explain how they reflect classical ideals, but also contain innovations that either reinterpret or perfect those ideals.

  Prints the equivalent fahrenheit value

Write a program that aske the user to enter a temperature reading in centigrade and then prints the equivalent Fahrenheit value. Be sure to include at least one negative centigrade number in your test cases.

  Write work for company pbf energy overview of main external

just 2 pages of written work for a company pbf energy www.pbfenergy.com of the things titled below- pbf energy pbf is

  Effective therapeutic approach for treating

Which of the following is probably the least effective therapeutic approach for treating the many problems experienced by cocaine abusers?

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