Jensen’s Alpha is a risk-adjusted performance benchmark that tells you how by much the returns of an actively managed portfolio are above or below market returns.

Originating in the late 1960s, Jensen’s Alpha (often abbreviated to Alpha) was developed to evaluate the skill of active fund managers in stock picking.

- A positive Alpha means that a portfolio has beaten the market, while a negative value indicates underperformance
- A fund manager with a negative alpha and a beta greater than one has added risk to the portfolio but has poorer performance than the market

Careful stock picking and financial engineering means that investors can add alpha to a portfolio without adversely affecting beta.

According to the Capital Asset Pricing Model, Alpha is defined by this equation

alpha = r_{s} – [r_{f} + β (r_{b} - r_{f})]

where r_{s} is the expected portfolio return, r_{f} is the risk-free rate, β is the portfolio beta, and r_{b} is the market return. Beta describes the volatility of the portfolio with respect to that of the wider market, and is calculated with this equation

The market return is usually described by the expected return of an index fund, like the FTSE or S&P500.

## Calculate Alpha with Excel

Thse steps describe how you can calculate Alpha with Excel (there’s a link to download the tutorial spreadsheet at the bottom). The screegrabs describe the formulae used in the spreadsheet.

**Step 1**: Put the returns of your portfolio and the benchmark index into Excel, and calculate the average returns

**Step 2**. Define your risk free rate. If the returns specified in Step 1 are monthly returns, then your risk free rate has to be on a monthly basis.

**Step 3**. Calculate the portfolio Beta, and then the Alpha.

**Download Excel Spreadsheet to Calculate Jensen’s Alpha with Excel**

The F9 cell Alpha formula is wrong : it should be “B20-E6-F8*(C20-E6)” rather than “B20-E6+F8*(C20-E6)”

I’ve made the appropriate corrections.

Thank you for your eagle-eyed correction!

Also, you should correct the CAPM formula for alpha: instead of “alpha = rs – rf + β (rb – rf)”, please write “alpha = rs – [rf + β (rb – rf)]“.

Done! Thank you.

Isn’t this a monthly alpha calculation? How would you annualize?

You annualize a monthly Jensen’s Alpha with this calculation:

(1+alpha)^12 – 1

I calculated the monthly Alpha based on a mean monthly standard deviations, monthly risk free interest rate and beta calculated form the same data. The values work out fine.

When the monthly Alpha, the mean monthly standard deviations, and the monthly risk free interest rate are annualzed with the formula above, why does to the annualized Alpha value not Tie out using the same beta??

Thanks!

Your calculation is based on the assumption that the risk free rate was the same for every period which is unlikely to be the case. How would you modify the calculation to take into account varying risk free rates over the time period covered?

Given the monthly and yearly calculation does this then mean a daily alpha would be(1+alpha)^250-1?

If I have data for 9 years worth of back testing, how do I calculate the average annual alpha? Here are my inputs:

Beta: 0.88

Portfolio Return: 925%

Risk Free Return: 16.76%

Market Return:16.13%

Is calculating alpha over such a long period accepted?

Is it possible to find Alpha through a regression, if so how? I need to find if alpha is significant, t-stat will do.

thanks