Question: Using excel please. (15 Percent) Consider the following returns: a. Calculate the variances of Stock X's, Stock Y's, and Stock Z's returns respectively. b. Calculate

Using excel please.

(15 Percent) Consider the following returns: a. Calculate the variances of Stock X's, Stock Y's, and Stock Z's returns respectively. b. Calculate covariance and correlation between Stock X's and Stock Y's returns. c. Given that the risk-free rate is \4, calculate the Sharpe ratio of a portfolio that is made up with \45 of Stock X, \25 of Stock Y, and \30 of Stock Z

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

8. (15 Percent) Consider the following returns: a. Calculate the variances of Stock X's, Stock Y's, and Stock Z's returns respectively. b. Calculate covariance and correlation between Stock X's and...

8. (15 Percent) Consider the following returns: a. Calcuate the variances of Stock X's, Stock Y's, and Stock Z's returns respectively, b. Calculate covariance and correlation between Stock X's and...

Hi Can you help with # 4 of the attached document What proportion of your funds should you invest in each fund in order to construct an optimal portfolio, which will earn 9% expected return? What is...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

The standard deviation is the square root of the variance, so the standard deviation is: Standard deviation: ? And for Slowpoke: to find the covariance. Doing so, we find: Since the correlation is...

All the parts should be well calculated, dont give the answer without calculations please 44. Consider the following three-period binomial tree model for a stock that pays dividends continuously at a...

Show all the workings 44. Consider the following three-period binomial tree model for a stock that pays dividends continuously at a rate proportional to its price. The length of each period is 1...

Show all the working correctly 44. Consider the following three-period binomial tree model for a stock that pays dividends continuously at a rate proportional to its price. The length of each period...

MANAGERIAL FINANCE HOMEWORK HMWK 5 1. value: 10.00 points Assuming semiannual compounding, what is the price of azero coupon bond with 17 years to maturity paying $1,000 at maturity if the YTM is (Do...

Please explain question #12. attached document with the document is provided. For problems 12-16, assume that you manage a risky portfolio with an expected rate of return of 17% and a standard...

A number of guidelines can be valuable in helping MNCs to make diverse teams more effective. What are five of these? Additionally, what underlying principles guided NUMMI in its effective use of...

What classification of inventory does a manufacturer have?

A firm could offer a pricing decision such as marking all cold and cough medications 1 0 % off right before or at the beginning of cold / flu season. This could cause consumers to stock up before...

I Pe blowng whan aglobie ase the present value tasles (6 marks): (3 miray) (if marks) (s)arks) Bricicustan Mre tolewing cotals apty EVC of PAFER QUESTIONS REQUIRED [20 Naris] Usa the infornation...