An investment analyst prepares the following distribution of the prices of two equity stocks, A and...

80.2K

Verified Solution

Question

Statistics

An investment analyst prepares thefollowing distribution of the prices of two equity stocks, A and B,she expects to see at the end of the coming financial year in eachof five states. The probability that each state might occur hasalso been estimated and is noted below. The current prices in themarket are £45 and £38 per share for A and B respectively.
State
1
2
3
4
5
Probability
0.10
0.15
0.25
0.25
0.25
Stock A
Prices (£)
39.53
40.78
43.63
43.88
49.56
Stock B
Prices (£)
23.50
33.11
38.58
44.02
44.59
For both stocks A and B, calculate the expected return, thevariance of the returns and the inter-quartile range of thereturns.
Calculate the covariance between the returns of A and B.
Calculate the correlation between the returns of A and B, usingthe correlation function in Excel, as well as, directly usingformulae. Explain the difference in the two correlationvalues.
For both stocks A and B, calculate the negative semi-varianceof the return at the end of the year. Why might investors takeaccount of the negative semi-variance of the returns as a measureof risk?

Answer & Explanation Solved by verified expert

3.6 Ratings (401 Votes)

IFor Stocks A and B Returns are derived Differencebetween Current value of Stock and value of stock from each stateFor Ex Return A 45 3953 547Return B 38 235 145refer below Screen shot where 152 and 324 are ExpectedReturns See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

State	1	2	3	4	5
Probability	0.10	0.15	0.25	0.25	0.25
Stock A
Prices (£)	39.53	40.78	43.63	43.88	49.56
Stock B
Prices (£)	23.50	33.11	38.58	44.02	44.59