Question

Excel Activity: Evaluating Risk and Return

Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015–2020. The Winslow 5000 data are adjusted to include dividends.

Bartman Industries
Reynolds Inc.
Winslow 5000
YearStock Price
Dividend
Stock Price
Dividend
Includes Dividends
2020$16.95

$1.15

$50.50

$2.90

$12,324.64
201914.30

1.06

53.75

2.80

9,133.05
201816.10

1.00

50.50

2.65

9,022.59
201710.55

0.95

58.70

2.35

6,582.21
201610.97

0.90

62.15

2.10

5,773.46
20157.52

0.85

57.20

1.85

4,800.88

Assume the risk-free rate during this time was 2%. Calculate the Sharpe ratios for Bartman, Reynolds, and the Index over this period using their average returns. Round your answers to four decimal places.


Bartman Industries
Reynolds Inc.
Winslow 5000
Sharpe ratio




Estimate Bartman's and Reynolds's betas by running regressions of their returns against the index's returns. Round your answers to four decimal places.

Bartman's beta: _______________

Reynolds's beta: ______________

Assume that the risk-free rate on long-term Treasury bonds is 4.5%. Assume also that the average annual return on the Winslow 5000 is not a good estimate of the market's required return—it is too high. So use 10% as the expected return on the market. Use the SML equation to calculate the two companies' required returns. Round your answers to two decimal places.

Bartman's required return: ____________ %

Reynolds's required return: ___________ %

If you formed a portfolio that consisted of 50% Bartman and 50% Reynolds, what would the portfolio's beta and required return be? Round your answer for the portfolio's beta to four decimal places and for the portfolio's required return to two decimal places.

Portfolio's beta: ______________

Portfolio's required return: _____________ %

Suppose an investor wants to include Bartman Industries's stock in his portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.825, 0.914, and 1.403, respectively. Calculate the new portfolio's required return if it consists of 30% of Bartman, 10% of Stock A, 35% of Stock B, and 25% of Stock C. Round your answer to two decimal places.

______________ %


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 9 more requests to produce the answer.

1 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Excel Activity: Evaluating Risk and Return
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 8-22. Evaluating Risk and Return Bartman Industries’s and Reynolds Inc.’s stock prices and dividends, along with...

    8-22. Evaluating Risk and Return Bartman Industries’s and Reynolds Inc.’s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2012–2017. The Winslow 5000 data are adjusted to include dividends. Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Stock Price Dividend Includes Dividends 2017 $17.25 $1.15 $48.75 $3.00 $11,663.98 2016 14.75 1.06 52.30 2.90 8,785.70 2015 16.50 1.00 48.75 2.75 8,679.98 2014 10.75 0.95 57.25 2.50 6,434.03 2013 11.37 0.90 60.00 2.25...

  • Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating...

    Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 25.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....

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

    Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 25.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...

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

    Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 25.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...

  • 2. 3: Risk and Rates of Return: Risk in Portfolio Context Risk and Rates of Return:...

    2. 3: Risk and Rates of Return: Risk in Portfolio Context Risk and Rates of Return: Risk in Portfolio Context The capital asset pricing model (CAPM) explains how risk should be considered when stocks and other assets are held . The CAPM states that any stock's required rate of return is the risk-free rate of return plus a risk premium that reflects only the risk remaining diversification. Most individuals hold stocks in portfolios. The risk of a stock held in...

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

  • HR Industries (HRI) has a beta of 1.7; LR Industries's (LRI) beta is 0.9. The risk-free...

    HR Industries (HRI) has a beta of 1.7; LR Industries's (LRI) beta is 0.9. The risk-free rate is 6%, and the required rate of return on an average stock is 13%. The expected rate of inflation built into rRF falls by 1.5 percentage points, the real risk-free rate remains constant, the required return on the market falls to 10.5%, and all betas remain constant. After all of these changes, what will be the difference in the required returns for HRI...

  • CAPM AND REQUIRED RETURN HR Industries (HRI) has a beta of 2.2, while LR Industries's (LRI)...

    CAPM AND REQUIRED RETURN HR Industries (HRI) has a beta of 2.2, while LR Industries's (LRI) beta is 0.4. The risk-free rate is 6%, and the required rate of return on an average stock is 13%. The expected rate of inflation built into rRF falls by 1.5 percentage points; the real risk-free rate remains constant; the required return on the market falls to 10.5%; and all betas remain constant. After all of these changes, what will be the difference in...

  • EVALUATING RISK AND RETURN Stock X has a 10.5% expected return, a beta coefficient of 1.0,...

    EVALUATING RISK AND RETURN Stock X has a 10.5% expected return, a beta coefficient of 1.0, and a 35% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 30.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. Cvx= ?Cvy=? C.Calculate each stock's required rate of return.Rx=?...

  • QUESTION 1: QUESTION 2: A portfolio is invested 10 percent in Stock G, 50 percent in...

    QUESTION 1: QUESTION 2: A portfolio is invested 10 percent in Stock G, 50 percent in Stock J, and 40 percent in Stock K. The expected returns on these stocks are 9 percent, 15 percent, and 19 percent, respectively. What is the portfolio's expected return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Expected return You own a stock portfolio invested 30 percent in Stock Q, 25 percent in Stock...

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