A Microsoft Excel spreadsheet can be used to calculate ... use since most beta calculations are based on the S&P 500. Example of CAPM Calculation We find that Tesla has a beta of 0.48.