Question

Please solve for green boxes and please show excel formulas.Risk and Return Porfolio Weights and the Security Market Line Do not round any calculations From the Topic Application of th

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Dear Student
Thank you for using homeworklib
Please find below the answer
Statement showing Computations
Particulars Amount
Let weight of stock A be w
Let weight of stock B be 1-w
1.1 = 1.3*w + .85 (1-w)
1.1 = 1.3w=.85 - .85w
.25 = .45w
w = .25/.45 = .5556
1-w = 1-.5556 = .4444
Weight of stock A=                      0.5556
Weight of stock B                    0.4444
Portfolio Expected return = 7.80%*.5556 + 5.80%*.4444
Portfolio Expected return = 4.33%+ 2.58% 6.91%
Stock A
7.80% = Rf + 1.3*MRP
Rf = 7.80% - 1.3MRP
Stock B
5.80% = Rf + .85*MRP
Rf = 5.80% - .85MRP
7.80% - 1.3MRP = 5.80% - .85MRP
2.00% =.45MRP
MRP = 2.0%/.45
Market risk premium 4.44%
Rf = 5.80% - .85*4.44% 2.03%
Risk free rate is 2.03%
Add a comment
Know the answer?
Add Answer to:
Please solve for green boxes and please show excel formulas. Risk and Return Porfolio Weights and...
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
  • Please show work/equations. Risk and Return Porfolio Weights and the Security Market Line Do not round...

    Please show work/equations. Risk and Return Porfolio Weights and the Security Market Line Do not round any calculations From the Topic "Application of the SML"pp. 240-242 An investor wants to build a 2-stock portfolio of the following stocks: Stock Beta 1.3 0.85 Expected Return 7.80% 5.80% 14 If the investor wants the Portfolio Beta to be 1.1, what should the weights of each stock be in the portfolio? 16 sub-calc area Desired Portfolio beta: Weight of Stock A: Weight of...

  • Please show also the formulas in excel. Calculate also exp return, risk, corr coefficient, optimal weight...

    Please show also the formulas in excel. Calculate also exp return, risk, corr coefficient, optimal weight and weights for portfolio and equity portfolio. Thank you for your time! 1 The fund manager has invested! 0 million euros into a bond portfolio which has expected annual return of 13% and 2 expected risk of 8.5% 3 To reduce his overall risk, porfolio manager decided to invest into equity portfolio 4 with expected annual return of 19% and risk 22%. 5 The...

  • A stock has a beta of 1.14 and an expected return of 10.5 percent. A risk...

    A stock has a beta of 1.14 and an expected return of 10.5 percent. A risk free asset currently early 2.4 percent. a. What is the expected return on a portfolio that is equally invested in the two assets? b. If a portfolio of the two assets has a beta of .92, what are the portfolio weights? c. If a portfolio of the two assets has an expected return of 9 percent, what is its beta? d. If a portfolio...

  • A stock has an expected return of 13.2 percent, the risk-free rate is 6 percent, and...

    A stock has an expected return of 13.2 percent, the risk-free rate is 6 percent, and the market risk premium is 10 percent. What must the beta of this stock be? (Do not round intermediate calculations. Round your answer to minimum 2 decimal places, e.g., 32.16.) ______ Hint: Solve for beta from the formula ER = RF + BETA x (RM - RF) where MRP=RM-RF

  • In the following table, indicate whether each statement refers to the Capital Market Line (CML) or...

    In the following table, indicate whether each statement refers to the Capital Market Line (CML) or to the Security Market Line (SML). Capital Market Line (CML) Security Market Line (SML) Statement This line defines the linear relationship between the expected return on an efficient portfolio and its standard deviation The slope of this line, th risk. - TRP/OM, reflects the investors' aggregated, or market-level, expected premium for This line describes the return on an individual security as the sum of...

  • Excel Online Structured Activity: Evaluating risk and return Stock X has a 10.0% expected return, a...

    Excel Online Structured Activity: Evaluating risk and return Stock X has a 10.0% expected return, a beta coeficient of 0.9, and a 30% standard deviation of expected returns. Stock Y has a 12.0% expected return, beta coefficient of 1.1, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions...

  • REQUIRED RATE OF RETURN (Percent) 20.0 Return on HC's Stock . / / 1.5 2.0 RISK...

    REQUIRED RATE OF RETURN (Percent) 20.0 Return on HC's Stock . / / 1.5 2.0 RISK (Beta) / / / / / CAPM Elements Risk-free rate (RF) Market risk premium (RPM) Happy Corp. stock's beta Required rate of return on Happy Corp. stock nalyst believes that inflation ir at Value CAPM Elements Risk-free rate (TRF) Market risk premium (RPM) Happy Corp. stock's beta Required rate of return on Happy Corp. stock An analyst believes that inflation is going to increase...

  • 5. The Capital Market Line and the Security Market Line Aa Aa E In the following...

    5. The Capital Market Line and the Security Market Line Aa Aa E In the following table, indicate whether each statement refers to the Capital Market Line (CML) or to the Security Market Line (SML). Capital Market Line (CML) Security Market Line (SML) Statement This line defines the linear relationship between the expected return on an efficient portfolio and its standard deviation. The slope of this line, TM - PRF) / OM, reflects the investors' aggregated, or market-level, expected premium...

  • 5. The Capital Market Line and the Security Market Line In the following table, check whether...

    5. The Capital Market Line and the Security Market Line In the following table, check whether each statement refers to the Capital Market Line (CML) or to the Security Market Line (SML). Statement Capital Market Line (CML) Security Market Line (SML) This line defines the linear relationship between the expected return on an efficient portfolio and its standard deviation. The slope of this line, (r̂Mr̂M – rRFrRF)/σMσM, reflects the investors’ aggregated, or market-level, expected premium for risk. This line describes...

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