You have $15,000 to invest in a stock portfolio and a goal of an expected return...

You have $15,000 to invest in a stock portfolio and a goal of an expected return of 12.5 percent. You can choose between Stock E with an expected return of 14.3 percent and Stock F with an expected return of 10.5 percent. How much should you invest in each stock? Please show work in Excel sheet

Portfolio Value $ 15,000

Stock E E(R) 14.30%

Stock F E(R) 10.50%

Portfolio E(R) 12.50%

Weight of Stock X ?

Weight of Stock Y ?

Dollar in Stock X ?

Dollars in Stock Y ?

Solutions

Expert Solution

Please upvote if the ans is helpful. Thanks.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You have $17,200 to invest and would like to create a portfolio with an expected return...

You have $17,200 to invest and would like to create a portfolio with an expected return of 11 percent. You can invest in Stock K with an expected return of 9.9 percent and Stock L with an expected return of 13.5 percent. How much will you invest in Stock K? $10,949.07 $4,598.61 $7,007.41 $5,255.56 $11,944.44 Based on the following information, what is the standard deviation of returns? State of Economy Probability of State of Economy Rate of Return if State...

You would like to invest $20,000 and have a portfolio expected return of 12 percent. You...

You would like to invest $20,000 and have a portfolio expected return of 12 percent. You are considering two securities, X and Y. X has an expected return of 20 percent and Y has an expected return of 10 percent. How much should you invest in stock X if you invest the balance in stock Y to achieve the 12 percent portfolio return? a) $5,500 b) $4,000 c) $7,000 d) $6,250

You have a three-stock portfolio. Stock A has an expected return of 16 percent and a...

You have a three-stock portfolio. Stock A has an expected return of 16 percent and a standard deviation of 41 percent, Stock B has an expected return of 20 percent and a standard deviation of 46 percent, and Stock C has an expected return of 15 percent and a standard deviation of 46 percent. The correlation between Stocks A and B is .30, between Stocks A and C is .20, and between Stocks B and C is .05. Your portfolio...

You have a three-stock portfolio. Stock A has an expected return of 17 percent and a...

You have a three-stock portfolio. Stock A has an expected return of 17 percent and a standard deviation of 38 percent, Stock B has an expected return of 20 percent and a standard deviation of 56 percent, and Stock C has an expected return of 15 percent and a standard deviation of 38 percent. The correlation between Stocks A and B is 0.30, between Stocks A and C is 0.20, and between Stocks B and C is 0.05. Your portfolio...

You have a portfolio of three stocks: Stock A, Stock B, and Stock C. The expected return...

You have a portfolio of three stocks: Stock A, Stock B, and Stock C. The expected return of Stock A is 8%, the expected return of Stock B is 10%, and the expected return of Stock C is 12%. The expected return of the portfolios is 10.5%. If the weight of asset B is three times the weight of asset A, what are the weights for the three assets?

Analyzing a Portfolio You have $100,000 to invest in a portfolio containing Stock X and Stock...

Analyzing a Portfolio You have $100,000 to invest in a portfolio containing Stock X and Stock Y. Your goal is to create a portfolio that has an expected return of 12.7 percent. If Stock X has an expected return of 11.4 percent and a beta of 1.25 and Stock Y has an expected return of 8.68 percent and a beta of .85, how much money will you invest in Stock Y? How do you interpret your answer? What is the...

A portfolio consists of $15,000 in Stock M and $22,900 invested in Stock N. The expected...

A portfolio consists of $15,000 in Stock M and $22,900 invested in Stock N. The expected return on these stocks is 8.80 percent and 12.40 percent, respectively. What is the expected return on the portfolio? 11.69% 10.22% 10.98% 10.60% 9.37% You decide to invest in a portfolio consisting of 30 percent Stock A, 30 percent Stock B, and the remainder in Stock C. Based on the following information, what is the expected return of your portfolio? State of Economy Probability...

You have a portfolio with $15,000 invested in Stock A with a beta of 2.5, $25,000...

You have a portfolio with $15,000 invested in Stock A with a beta of 2.5, $25,000 invested in stock B with a beta of 0.7, and $10,000 invested in Stock C with a beta of 1.0. If the risk-free rate is 2% and the market risk premium is 6%, what is the required return of the portfolio?

QUESTION 62 1. You invest $100 in the market portfolio with an expected return of 12%...

QUESTION 62 1. You invest $100 in the market portfolio with an expected return of 12% and a standard deviation of 15%, and a T-bill that pays 5%. If you desire to form a portfolio with an expected return of 10%, what percentages of your money must you invest in the market portfolio? 45.3% 65.5% 71.4% 83.5% 85.24% 1 points QUESTION 63 1. The market portfolio has an expected return of 12% and a standard deviation of 20 %....

You have a portfolio with a standard deviation of 25 % and an expected return of...

You have a portfolio with a standard deviation of 25 % and an expected return of 15 %. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20 % of your money in the new stock and 80 % of your money in your existing portfolio, which one should you add? Expected Return Standard Deviation Correlation with Your Portfolio's Returns Stock A 15% 23% 0.4 Stock B 15%...

Subjects