• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Finance Train

Finance Train

High Quality tutorials for finance, risk, data science

  • Home
  • Data Science
  • CFA® Exam
  • PRM Exam
  • Tutorials
  • Careers
  • Products
  • Login

Jensen’s Alpha Calculator in Excel

Financial Modelling, Investment Management, Portfolio Management

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:

  • Rp = Returns of the Portfolio
  • Rf = Risk-free rate
  • β = Stock’s beta
  • Rm = 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.

jensen1

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(Rp,Rm)/Variance(Rp)

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(Rp) = 1.5%+0.61*(2.58%-1.5%)

E(Rp) =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%

Download Jensen’s Alpha Calculator

Join Our Facebook Group - Finance, Risk and Data Science

Posts You May Like

How to Improve your Financial Health

CFA® Exam Overview and Guidelines (Updated for 2021)

Changing Themes (Look and Feel) in ggplot2 in R

Coordinates in ggplot2 in R

Facets for ggplot2 Charts in R (Faceting Layer)

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Latest Tutorials

    • Data Visualization with R
    • Derivatives with R
    • Machine Learning in Finance Using Python
    • Credit Risk Modelling in R
    • Quantitative Trading Strategies in R
    • Financial Time Series Analysis in R
    • VaR Mapping
    • Option Valuation
    • Financial Reporting Standards
    • Fraud
Facebook Group

Membership

Unlock full access to Finance Train and see the entire library of member-only content and resources.

Subscribe

Footer

Recent Posts

  • How to Improve your Financial Health
  • CFA® Exam Overview and Guidelines (Updated for 2021)
  • Changing Themes (Look and Feel) in ggplot2 in R
  • Coordinates in ggplot2 in R
  • Facets for ggplot2 Charts in R (Faceting Layer)

Products

  • Level I Authority for CFA® Exam
  • CFA Level I Practice Questions
  • CFA Level I Mock Exam
  • Level II Question Bank for CFA® Exam
  • PRM Exam 1 Practice Question Bank
  • All Products

Quick Links

  • Privacy Policy
  • Contact Us

CFA Institute does not endorse, promote or warrant the accuracy or quality of Finance Train. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.

Copyright © 2021 Finance Train. All rights reserved.

  • About Us
  • Privacy Policy
  • Contact Us