Your portfolio has a beta of 1.25. The portfolio consists of 17 percent U.S. Treasury bills,...

Your portfolio has a beta of 1.25. The portfolio consists of 17 percent U.S. Treasury bills, 29 percent in stock A, and 54 percent in stock B. Stock A has a risk-level equivalent to that of the overall market.

What is the beta of stock B?

How can I use Excel to Find Beta?

Expert Solution

Beta of treasury bills will be zero because they are considered risk free.

Since stock A has risk level equivalent to that of the overall market, the beta of stock A will be 1.

Portfolio Beta = (Beta of stock A * Weight of stock A) + (Beta of stock B * Weight of stock B) + (Beta of Treasury bills * Weight of treasury bills)

(Beta of stock B * Weight of stock B) = Portfolio Beta - (Beta of stock A * Weight of stock A) - (Beta of Treasury bills * Weight of treasury bills)

Beta of stock B = (Portfolio Beta - (Beta of stock A * Weight of stock A) - (Beta of Treasury bills * Weight of treasury bills))/Weight of stock B

We can calculate Beta in the excel using above formula

jeff jeffy answered 1 year ago

Treasury bills and Treasury notes are an investment security issued by the U.S. government. A Treasury...

Treasury bills and Treasury notes are an investment security issued by the U.S. government. A Treasury bill matures within one year and investors typically roll over the matured Treasury bill and purchase another Treasury bill the same day. Treasury notes have maturities of up to 10 years. You are considering investing $50,000 in a Treasury bill that you will renew every 6 months or invest in a Treasury note that you will hold until maturity. Your investment time frame is...

Asset W has an expected return of 12.8 percent and a beta of 1.25. If the...

Asset W has an expected return of 12.8 percent and a beta of 1.25. If the risk-free rate is 4.7 percent, complete the following table for portfolios of Asset W and a risk-free asset. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your expected returns as a percent rounded to 2 decimal places, e.g., 32.16, and your beta answers to 3 decimal places, e.g., 32.161.) Percentage of Portfolio in Asset...

5. You have been managing a $5million portfolio that has a beta of 1.25 and a...

5. You have been managing a $5million portfolio that has a beta of 1.25 and a required rate of return of 12%. The current risk-free rate is 5.25%. Assume that you receive another $500,000. If you invest the money in a stock with a beta of 0.75, what will be the required return on your $5.5 million portfolio? Show work. a. 10.43% b. 11.75% c. 9.62% d. 10.17%

A hedge fund manager has a portfolio worth $50 million with a beta of 1.25. The...

A hedge fund manager has a portfolio worth $50 million with a beta of 1.25. The manager is concerned about the performance of the market over the next two months He plans to uses three-month stock market index futures to hedge his market exposure. The current stock market index level is 2,500 and one contract is on 250 times the futures price. The continuously compounded interest rate is 3% and the dividend yield on the stock market index is 2%....

Currently, your portfolio consists of $3,000 invested in share A with a beta of 0.7 and...

Currently, your portfolio consists of $3,000 invested in share A with a beta of 0.7 and $4,000 in share B with a beta of 0.5. You have another $12,000 to invest and want to divide it between share C with a beta of 1.3 and a risk-free asset. You want your portfolio beta to be 0.9. How much (to the nearest dollar) should you invest in the risk free asset? a. 2,000 b. 10,000 c. $3,000 d.8,800

A mutual fund manager has a $90.0 million portfolio with a beta of 1.25. The risk-free...

A mutual fund manager has a $90.0 million portfolio with a beta of 1.25. The risk-free rate is 3.50%, and the market risk premium is 6.00%. The manager expects to receive an additional $30.0 million which she plans to invest in a number of stocks. After investing the additional funds, she wants to reduce the portfolio’s risk level so that once the additional funds are invested the portfolio’s required return will be 11.75%. What must the average beta of the...

This is so hard especially the BETA portfolio I cannot calculate. Your investment portfolio consists of...

This is so hard especially the BETA portfolio I cannot calculate. Your investment portfolio consists of the following stocks Investment Portfolio Name Price Beta # shares Dow Chemical $ 59.72 1.34 15,000 Walmart $ 69.32 0.19 3,000 Boeing $ 128.00 1.36 8,000 Verizon $ 52.61 0.45 6,000 Consolidated Edison $ 74.00 0.17 3,000 Caterpillar $ 75.00 1.5 13,000 Deutsche bank $ 22.55 1.4 9,000 a) What is the portfolio beta? b) What is the required return on the portfolio if the...

Gretta's portfolio consists of $700,000 invested in a stock that has a beta of 1.5 and...

Gretta's portfolio consists of $700,000 invested in a stock that has a beta of 1.5 and $300,000 invested in a stock that has a beta of 0.8. The risk-free rate is 6% and the market risk premium is 5%. Which of the following statements is CORRECT? Answers: a. The portfolio's required return is less than 11%. b. If the risk-free rate remains unchanged but the market risk premium increases by 2%, Gretta's portfolio's required return will increase by more than...

What is the beta for a company with a 12% expected return, while treasury bills are...

What is the beta for a company with a 12% expected return, while treasury bills are yielding 5% and the market risk premium is 7%? a. 0.5 b. 1.0 c. 0.75 d. 1.5 e. 1.25

What is the expected return for a company with a beta of 0.5, while treasury bills...

What is the expected return for a company with a beta of 0.5, while treasury bills are yielding 3% and the return on the market portfolio is 10%? a. 5.50% b. 6.50% c. 17.00% d. 3.00% e. 8.00%

Question