How do you calculate the expected return of a stock in Excel?

In cell F2, enter the formula = ([D2*E2] + [D3*E3] + …) to render the total expected return.

What is a good rate of return for investment?

It’s important for investors to have realistic expectations about what type of return they’ll see. A good return on investment is generally considered to be about 7% per year. This is the barometer that investors often use based off the historical average return of the S&P 500 after adjusting for inflation.

What is the expected return of the portfolio?

Expected return measures the mean, or expected value, of the probability distribution of investment returns. The expected return of a portfolio is calculated by multiplying the weight of each asset by its expected return and adding the values for each investment.

What is expected return of portfolio?

How are stock returns normally distributed in the stock market?

More evidence of that is how the actual distribution of monthly S&P 500 returns is skinnier in its center than the normal distribution. The skinny middle and the fat tails imply that the normal distribution might not be the best describer of stock returns.

What is the standard deviation of stock returns?

Are Stock Returns Normal? Since 1950, the average annual return of the S&P 500 has been approximately 8% and the standard deviation of that return has been 12%. I want to look at monthly returns so let’s translate these to monthly:

What does fat tail mean for stock returns?

The fat tails mean that extreme events occur more frequently in reality than what a normal distribution would predict. More evidence of that is how the actual distribution of monthly S&P 500 returns is skinnier in its center than the normal distribution.

Is it normal for stock returns to be normal?

Stock returns are roughly normal after all and a lot of the benefits of investment theory such as diversification hold true even in a world of less than normal stock returns and fat tails (perhaps even more so).

You Might Also Like