Question
can someone help me do this without using excel?
3. (30 points) - Rate of returns for A and B companies in different states of nature are provided in the following table: Sta
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Date: Page no A Companies dac: x-1C Prox² Eralentility (P) Return (in %) (x) 3 - 4 10 - 10.9 3.1 7.1 10.1 35.643 4.805 5.041B Campanies 4.7 . dy=y- Pdy? ce Return (im) (4) a - 2 .7 2.187 - .7 7 2.3 .245 .529 8.649 14 9.3 Variance (EPd x°) - 11.61 ajNow Calculation of Returns Conariance between A and B dy Px dx xdy Eralentility dx (P) O -10.9 - 2.7 .3 .5 L - .7 3.1 7.1 10.c) Crinen Weight of stock I Weight of Stock Af A Campanie (WA) = 80 (80%) of B Campanie (WB) = 20 (20%) Expected Return - ExpStandard - Deviation Standard Deciatian X WA)+/ Standard Deristian x WB] of a companie I cof B Companie 1 + 2x Couariance betA Campanie B Campanie (Theta) (Gamma) 4.7% a) Expected Return b) Standard Deviation 6.90% 7.46% 3.41%. Portfalia expected Ret

Add a comment
Know the answer?
Add Answer to:
can someone help me do this without using excel? 3. (30 points) - Rate of returns...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • hi i need help with this question but in details please how do i get each...

    hi i need help with this question but in details please how do i get each number??? i posted it before but the answers were not clear and when i tried to calculate it myself it resulted different note: without using excel 3. (30 points) - Rate of returns for A and B companies in different states of nature are provided in the following table: State of nature Probability Rate of return on A's share (% Rate of return on...

  • REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year S...

    REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during...

  • what's the solution by using Excel sheet and Excel Formula? 3. Assume that you invest 36%...

    what's the solution by using Excel sheet and Excel Formula? 3. Assume that you invest 36% of your wealth in stock A and 64% of your wealth in stock B. Let the standard deviation of stock A's return equal 19% and the standard deviation of stock B's return equal 29%. Let the correlation coefficient of return of Stock A with Stock B equal to -1. Further assume that the expected return of A is 14% and the expected return of...

  • QUESTION 2: The returns on shares A and B in four equally likely states at the...

    QUESTION 2: The returns on shares A and B in four equally likely states at the end of next year are summarized below. 30 State Probability Rates of Rates of Return of Return of Share A Share B 0.3 -25 10.4 50 25 0.2 5 -40 0.1 40 30 a. Calculate the expected return, variance and standard deviation for each share. b. Compute the coefficient of correlation for the returns to these shares. c. Calculate the expected return, variance and...

  • B13. (Excel: Portfolio returns and stand 996 a standard deviation of 10%, and HMT has an...

    B13. (Excel: Portfolio returns and stand 996 a standard deviation of 10%, and HMT has an expected return of 12% and a standard ation of 20%. The portfolio return and risk, of course, depend on the portfolio weight ard deviations) ARC has an expected return of dev,. rtfolio returns and stan- the correlation between ARC and HMT returns. Calculate the portfolio returns and ad dard deviations for the weights and correlations shown in the table PORTFOLIO STANDARD DEVIATION WEIGHTS FOR...

  • Expected Returns 0.17 0.11 0.30 Standard Deviation 0.12 0.05 Firm A's common stock Firm B's common...

    Expected Returns 0.17 0.11 0.30 Standard Deviation 0.12 0.05 Firm A's common stock Firm B's common stock Correlation coefficient (Computing the standard deviation for a portfolio of two risky investments) Mary Guilott recently graduated from college and is evaluating an investment in two companies' common stock. She has collected the following information abou the common stock of Firm A and Firm B: a. If Mary decides to invest 10 percent of her money in Firm A's common stock and 90...

  • I am quite pressed for time! Can someone help me find this solution? You are given...

    I am quite pressed for time! Can someone help me find this solution? You are given the following information: Stock return (rs) Probability (p) Market return Krm) 0.2 15 10 0.3 0.3 0.2 a. Compute the expected market return and expected stock returns. [4+4 marks] b. If the standard deviation of market returns is 5.64%, what is the standard deviation of stock returns? (5 marks) c. If you create a portfolio with 40% weight on market index and 60% weight...

  • Remember, the expected value of a probability distribution is a statistical measure of the average (mean)...

    Remember, the expected value of a probability distribution is a statistical measure of the average (mean) value expected to occur during all possible circumstances. To compute an asset's expected return under a range of possible circumstances (or states of nature), multiply the anticipated return expected to result during each state of nature by its probability of occurrence Consider the following case: Antonio owns a two-stock portfolio that invests in Celestial Crane Cosmetics Company (COC) and Lumbering Ox Truckmakers (LOT). Three-quarters...

  • answer using excel pease You work for a large investment management firm. The analysts with your...

    answer using excel pease You work for a large investment management firm. The analysts with your firm have made the following forecasts for the returns of stock A and stock B: VERY VERY WEAK VERY WEAK WEAK AVERAGE STRONG VERY VERY STRONG Probability 10.00% 15.00% 20.00% 25.00% 20.00% 10.00% 100.0% Stock A 60.00% 40.00% 20.00% 10.00% -15.00% -50.00% Stock B -60.00% -50.00% -15.00% 30.00% 60.00% 90.00% Answer the following questions: a) Calculate the expected returns, variance and the standard deviations...

  • A stock's returns have the following distribution: Probability of this Rate of Return If Demand Occurring...

    A stock's returns have the following distribution: Probability of this Rate of Return If Demand Occurring This Demand Occurs 0.2 Demand for the Company's Products Weak Below average Average Above average Strong 0.2 (8) 0.3 0.1 0.2 1.0 Assume the risk-free rate is 3%. Calculate the stock's expected return, standard deviation, coefficient of variation, and Sharpe ratio. Do not round Intermediate calculations. Round your answers to two decimal places. Stock's expected return: Standard deviation: Coefficient of variation: Sharpe ratio:

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