Using this platform, account for the following activity; Howthemarketworks.com

Stock Beta Expected Return

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

1. Enter the name and Beta for each stock in your portfolio.
2. Market return (rm) Your input of market rate of return, rm, can be based on past returns or projected future returns. Economist Peter Bernstein famously calculated that over the last 200 years, the stock market has returned an average of 9.6% per year. So use this as the systemic risk rate (rm).
3. Risk-free return (rrf): U.S. Treasury bills and bonds are most often used as the proxy for the risk-free rate. Most analysts try to match the duration of the bond with the projection horizon of the investment. To estimate your Stock portfolios required rate of return over a 10 year time horizon, you'll want to use the 10-year U.S. Treasury bond rate as your measure of rrf. It is currently 2.42%
4. Calculate the expected return for each stock position you hold r = rf +b(r m -rf )
5. Determine the stocks that should remain as part of your efficient portfolio.
6. Feel free to find out and use excel in this activity.