# Jensen’s Alpha Calculator in Excel

The Jensen’s Alpha is a popular risk-adjusted performance measure used by portfolio managers to determine how much excess returns their portfolio has generated over and above the market returns as suggested by the CAPM model.

A positive alpha indicates that the portfolio has outperformed the market, and vice versa.

The Jensen’s Alpha can be calculated using the following formula:

$\alpha =R_{P}-\left ( R_{f}+\beta \left ( R_{M} -R_{f}\right ) \right )$

Where:

- R
_{p}= Returns of the Portfolio - R
_{f}= Risk-free rate - β = Stock’s beta
- R
_{m}= Market return

Let’s look at how Jensen’s Alpha can be calculated in Excel.

**Step 1:** Let’s say we have the following returns data for our portfolio and a benchmark index in excel. The first thing we need to do is calculate the mean of both the returns.

**Step 2:** Once we have the data, we need to define a risk-free rate. Let’s say the risk-free rate is 1.5%.

**Step 3:** The next step is to calculate the portfolio Beta, which will be used to calculate the expected returns using CAPM. Beta will be calculated using the following formula:

β = Covariance(R_{p},R_{m})/Variance(R_{p})

Use the formula COVARIANCE.P(), and VAR.P() in excel to perform the above calculations.In our example, the value of Beta is 0.61.

**Step 4:** Now that we have the Beta, we can calculate the expected return using CAPM.

E(R_{p}) = 1.5%+0.61*(2.58%-1.5%)

E(R_{p}) =2.16%

**Step 5:** The last step is to calculate Jensen’s Alpha by subtracting the expected returns from the actual mean portfolio returns.

Jensen’s Alpha = 4.58% - 2.16% = 2.42%

## Data Science in Finance: 9-Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

### What's Included:

- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)## Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.