A Microsoft Excel spreadsheet can be used to calculate CAPM ... Calculating CAPM is meant to establish the so-called "efficient frontier." That is, it helps identify the highest potential return ...