ZuoTi.Pro
Question

Please enter the return standard deviations for MICROSOFT INC. and for the portfolio during the last...

Please enter the return standard deviations for MICROSOFT INC. and for the portfolio during the last calendar year (2017).

Please use daily returns, and make sure to show your work. Please keep in mind that the standard deviation you will get using daily data is the daily standard deviation. In finance, the practice is to annualize the standard deviation by multiplying the daily standard deviation by sqrt(252) - there are approximately 252 trading days in a year. This is especially important if you want to be able to compute the Sharpe ratio correctly. The numerator in the Sharpe ratio is the ***annual*** excess return. Therefore, the denominator, which is the standard deviation, should also be annualized.

PLEASE SHOW YOUR WORK. THANK YOU

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Please enter the return standard deviations for MICROSOFT INC. and for the portfolio during the last...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • SHARPE RATIO IN EXCEL: Hi there! Could someone please help me create a formula to input...

    SHARPE RATIO IN EXCEL: Hi there! Could someone please help me create a formula to input this formula for the Sharpe ratio into excel? (I have a list of returns) 4. Sharpe Ratio (rfo) We define the Sharpe ratio as the annualized compounded daily return divided by the annualized standard deviation (sd) of daily returns as given by the following formula 252 Sharpe Ratio V252. sd(R)

  • James, a portfolio manager, would like to form the following portfolio between Microsoft and Coca-Cola:            ...

    James, a portfolio manager, would like to form the following portfolio between Microsoft and Coca-Cola:             Expected return (%)      Standard Deviation (%) Weight Microsoft                 28                          42                    0.4                   Coca-Cola              12.5                         21                    0.6 The correlation between the two stocks is 0.5. Now, suppose James can include the Treasury bills (T-bills) into his two-stock portfolio. The interest rate of the T-bills is 3.8%. What is the Sharpe ratio of James’ portfolio? For this question, please round up to the third decimal...

  • 9. (Market portfolio, CML) In the Golkoland stock market, there are only two listed stocks, Xirkind...

    9. (Market portfolio, CML) In the Golkoland stock market, there are only two listed stocks, Xirkind and Yirkind. The risk-free rate of return in Golkoland is 5%, and the portfolio of Xirkind and Yirkind stocks which has the highest Sharpe ratio is given below: A C 3 Average return 4 Variance of returns 5 Standard deviation 6 Covariance of returns 7 Correlation 8 Risk-free return B DE Xirkind Yirkind 19.84% 15.38% 0.1575 0.1378 39.68% 37.12% <-- SQRT(C4)! -0.0110 -0.0747 <--...

  • Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T...

    Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T-bill 3% 0% You are an investment adviser and you have the three investments above to recommend to your clients. The correlation between A and B is -0.5. Solve for the optimal risky portfolio and enter the weights as a %, 99% should be entered as 99.00%. Percent invested in Portfolio A Percent invested in Portfolio B What is the standard deviation of the optimal risky portfolio? What...

  • Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E. The 5 stocks are as follows: Microsoft, Apple, Macy’s, Face...

    Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E. The 5 stocks are as follows: Microsoft, Apple, Macy’s, Facebook, & Amazon. Please enter the return correlations for the 5 stocks during the 2018 calendar year. Please use daily returns, and make sure to show your work. All 5 companies have been publicly traded with daily price data available in Yahoo...

  • You manage a risky portfolio with an expected return of 12% and a standard deviation of 24%. Assume that you can invest...

    You manage a risky portfolio with an expected return of 12% and a standard deviation of 24%. Assume that you can invest and borrow at a risk-free rate of 3%, using T-bills. a. Draw the Capital Allocation Line (CAL) for this combination of risky portfolio and risk-free asset. What is the Sharpe ratio of the risky portfolio? b. Your client chooses to invest 50% of their funds into your risky portfolio and 50% risk-free. What is the expected return and...

  • PLEASE ANSWER ASAP. I WILL RATE!! Woodpecker, Inc., stock has an annual return mean and standard...

    PLEASE ANSWER ASAP. I WILL RATE!! Woodpecker, Inc., stock has an annual return mean and standard deviation of 19 percent and 21 percent, respectively. What is the percentage smallest expected loss in the coming month with a probability of 2.5 percent? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Round the 2-score value to 3 decimal places when calculating your answer. Enter your answer as a percent rounded to 2 decimal places.) You...

  • You manage a risky portfolio with an expected rate of return of 19% and a standard...

    You manage a risky portfolio with an expected rate of return of 19% and a standard deviation of 33%. The T-bill rate is 7%. Your client chooses to invest 80% of a portfolio in your fund and 20% in a T-bill money market fund. What is the reward-to-volatility (Sharpe) ratio (S) of your risky portfolio? Your client’s? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Your reward-to-volatility ratio?________ Clients' reward-to-volatility ratio?_________

  • You manage a risky portfolio with an expected rate of return of 17% and a standard...

    You manage a risky portfolio with an expected rate of return of 17% and a standard deviation of 37%. The T-bill rate is 5%. Your client chooses to invest 80% of a portfolio In your fund and 20% In a T-bill money market fund. What is the reward-to-volatility (Sharpe) ratio (9) of your risky portfolio? Your client's? (Do not round Intermediate calculations. Round your answers to 4 decimal places.) Your reward-to-volatility ratio Client's reward-to-volatility ratio

  • finance help please 1. Assume that you manage a risky portfolio with an expected rate of...

    finance help please 1. Assume that you manage a risky portfolio with an expected rate of return of 18% and a standard deviation of 28%. The T-bill rate is 8%. Your client chooses to invest 70% of a portfolio in your fund and 30% in a T-bill money market fund. a) What is the expected value and standard deviation of the rate of return on his portfolio? b) Suppose that your risky portfolio includes the following investments in the given...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT