Calculating CAPM in Excel Now let’s assume you want to find the CAPM of a stock you are interested in investing in. Let’s assume the stock is Tesla (TSLA).