Many investors use the capital asset pricing model (CAPM) as a way to estimate ... it to other alternative investments. A Microsoft Excel spreadsheet can be used to calculate CAPM.