How to calculate depreciation for fixed assets with the straight-line method, the sum of the years’ digits method, and others, using Microsoft Excel ...

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).