Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

S&P 500 S H Average Monthly Return 0.47% 1.44% 1.87% Average Annual Return 5.69% 17.24% 22.50% Average monthly Geometric Return 100.41% 101.13% 201.28% Average Annual

S&P 500 S H
Average Monthly Return 0.47% 1.44% 1.87%
Average Annual Return 5.69% 17.24% 22.50%
Average monthly Geometric Return 100.41% 101.13% 201.28%
Average Annual Geometric Return 1204.95% 1213.52% 2415.36%
Monthly Standard Deviation 3.50% 7.97% 9.29%
Annual Standard Deviation 12.11% 27.60% 32.17%

Correlation of S &H 0.058035719

(In EXCEL)

a) Which stock (S or H) is most risky if they are held alone and not in a portfolio?

b) Now consider the following two portfolios:

X: A portfolio with a weight of 98% in S&P 500 and 2% in S

Y: A portfolio with a weight of 98% in S&P 500 and 2% in H.

How does each stock affect the variability of the investment

c) Perform a regression for each stock on the Index returns

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

The Bank Analysts Handbook Money Risk And Conjuring Tricks

Authors: Stephen M. Frost

1st Edition

0470091185, 978-0470091180

More Books

Students also viewed these Finance questions

Question

2. Hilbert matrix H[i,j] = 1./(i+j-1), 1

Answered: 1 week ago