Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 7: Need help with the followoing. Please make sure to provide answer on excel format. thks 7 . The following are monthly percentage price

Question 7:

Need help with the followoing. Please make sure to provide answer on excel format.

thks

7. The following are monthly percentage price changes for four market indexes.

MonthDJIAS&P 500 Russell 2000 Nikkei

10.03 0.02 0.04 0.04

2 0.07 0.06 0.10 0.02

3 0.02 0.01 0.04 0.07

4 0.01 0.030.030.02

5 0.05 0.04 0.110.02

6 0.06 0.04 0.08 0.06

Compute the following.

a. Average monthly rate of return for each index

b. Standard deviation for each index

c. Covariance between the rates of return for the following indexes:

DJIAS&P 500

S&P 500Russell 2000

S&P 500Nikkei

Russell 2000Nikkei

d. The correlation coefficients for the same four combinations

e. Using the answers from parts (a), (b), and (d), calculate the expected return and standard

deviation of a portfolio consisting of equal parts of (1) the S&P and the Russell

2000 and (2) the S&P and the Nikkei. Discuss the two portfolios.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Theory and Policy

Authors: Paul R. Krugman, Maurice Obstfeld, Marc J. Melitz

10th edition

978-0133425895, 133425894, 978-0133423631, 133423638, 978-0133423648

More Books

Students also viewed these Finance questions

Question

Solve each system of equations. y = 5x + 3 2x + 3y = -8

Answered: 1 week ago

Question

=+b) Identify all the factor levels.

Answered: 1 week ago

Question

How does your clinical institution handle medication errors?

Answered: 1 week ago