Calculate the standard deviation of the historical returns compared to the mean determined in Step 3. In Excel, this can be achieved by using the STDEV function.

Reviewed by Thomas Brock Fact checked by Suzanne Kvilhaug CAPM: An Overview Many investors use the capital asset pricing model (CAPM) as a way to estimate the potential return of a stock or other ...