Question

The expected return on the market is 15 percent with a standard deviation of 12.5 percent and the risk-free rate is 5 percentplease show workings and dont have to show in excel

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer : C: 2 and 3 Only

The capital market line expressed by the following formula:

Rp = R; +(Rm – Rp) *oplom

Where

Rp is portfolio expected/required rate of return

Rf is risk free rate of return

Rm is market return

Sigma P is portfolio standard deviation

Sigma m is market standard deviation

Using the above formula for all four portfolio we get the below mentioned results:

Rf = 5%    Rm = 15%       Market Standard Deviation= 12.5%  

Portfolio 1:

Rp1 = 5 + (15-5)*28.75/12.5 = 28% Does not match with the given return i.e. 3.%

Rp2 = 5 + (15-5) * 25/12.5 = 25% Matches with the given expected return

Rp3 = 5 + (15-5)*6.25/12.5 = 10% Matches with the given expected return

Rp3 = 5 + (15-5) *5.5/12.5 = 9.4% Does not match with given expected return i.e. 9%

Therefore, the answer will be 2 and 3 only.

Add a comment
Know the answer?
Add Answer to:
please show workings and dont have to show in excel The expected return on the market...
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
  • Expected Portfolio Return Beta 22 0.8 A Market 173 1.0 D) Expected Portfolio Return Beta 30.28 1.8 A Market 198 1.0 If...

    Expected Portfolio Return Beta 22 0.8 A Market 173 1.0 D) Expected Portfolio Return Beta 30.28 1.8 A Market 198 1.0 If the simple CAPM is valid and all portfolios are priced correctly, which of the situations below is possible? Consider each situation independently, and assume the risk-free rate is 5% A) Expected Portfolio Return Beta 198 0.8 Market 198 1.0 B) Expected Standard Return Deviation Portfolio 228 88 A Market 17B 168

  • 1. Expected return and standard deviation Aa Aa Wilson holds a two-stock portfolio that invests equally...

    1. Expected return and standard deviation Aa Aa Wilson holds a two-stock portfolio that invests equally in Kelevra Industries and Old Glory Insurance Company (50% of his portfolio is in each stock). Each stock's expected return for the next year will depend on market conditions. The stocks' expected returns if there are poor, average, or great market conditions are shown below State of Probability of Kelevra Old Glory Economy State of Economy Industries Insurance Co Poor Average Great 0.25 0.50...

  • Please show work. It can be done in excel if needed. Expected Return Standard Deviation Correlation...

    Please show work. It can be done in excel if needed. Expected Return Standard Deviation Correlation with Stock A Stock A Stock B 20% 25% 0% 10% 15% 5% 0.2 | ТВ If you need an expected return of 12% and you only have the access to the two stocks above (but no access to TB), what is your portfolio composition? What is the standard deviation of your portfolio?

  • Please answer 1. The two-asset case Aa Aa The expected return for asset A is 8.75%...

    Please answer 1. The two-asset case Aa Aa The expected return for asset A is 8.75% with a standard deviation of 4.00%, and the expected return for asset B is 4.50% with a standard deviation of 10.00%. Based on your knowledge of efficient portfolios, fill in the blanks in the following table with the appropriate answers Proportion of Portfolio in Security A Proportion of Portfolio in Security B Expected Portfolio Return Standard Deviation Op (%) Case II (PAB-0.5) (PAB0.3) (PAB-0.8)...

  • Describe and illustrate the expected relationship between risk and expected return based on security market line...

    Describe and illustrate the expected relationship between risk and expected return based on security market line (SML) Hwang DBS Bhd has identified three potential stocks to buy in FBM KLCU but will only pick two to be added in the portfolio. The following information has been collected: AirAsia Daya Material Muhibbah Engineering Expected return 12% 25% 18% Standard deviation of return 2.2 5.9 3.4 Covariances of returns between companies AirAsia and Daya Material 8.2 AirAsia and Muhibbah Engineering 2.5 Daya...

  • Question1 Describe and illustrate the expected relationship between risk and expected return based on security market...

    Question1 Describe and illustrate the expected relationship between risk and expected return based on security market line (SML)             (7mark) Hwang DBS Bhd has identified three potential stocks to buy in FBM KLCU but will only pick two to be added in the portfolio. The following information has been collected:   AirAsia Daya Material Muhibbah Engineering Expected return 12% 25% 18% Standard deviation of return 2.2 5.9 3.4 Covariances of returns between companies AirAsia and Daya Material 8.2 AirAsia and Muhibbah...

  • With excel formulas please.. D18 Standard deviation of return Expected return 15% 25% 0.0865 33% 46%...

    With excel formulas please.. D18 Standard deviation of return Expected return 15% 25% 0.0865 33% 46% 2 ABC Covariance(ABCXYZ) 5 Correlation ABC,XYZ) 0.5698 <. -B4/C2'C3) 7 Section a 8 Portfolio allocation 9 Percentage ABC t0 Percentage XYZ 25.00% 75 0096 <..-1-B9 12 Expected return 13 Standard deviation 14 15 Section b Standard deviation of return 16 Percentage of ABC Expected return 0% 10% 30% 40% 50% 60% 70% 80% 90% 100% 20 24 29 Section c 30 Proportion of ABC...

  • Q7-Consider the following combination of expected return and risk for various portfolios (named A-H) on the...

    Q7-Consider the following combination of expected return and risk for various portfolios (named A-H) on the risk-return diagram. Assume a risk-free rate of 12% where one may borrow or lend at this rate. Expected Return (%) Risk (%) A 10 23 B 12.5 21 C D E F G H 15 16 17 18 18 20 25 29 29 32 35 45 Sharpe Ratio 1. Which of the above portfolios has the highest Sharpe ratio? (Must express in percentage) (5pts.)...

  • 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...

  • 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...

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