Sharpe Ratio Calculator

Sharpe ratio is a measure of risk and it is named after Nobel Laureate William F. Sharpe. The Sharpe ratio simply stated is a ratio of return vs risk. Given a set of investment choices, Sharpe ratio can help you decide which investment makes the most money. It is defined as the ratio between effective return of an investment and its standard deviation.

RpRf / σp

where,

Rp = expected return on investor’s portfolio

Rf = risk free rate of return

σp = the portfolio’s measure of risk or standard deviation

Example…

Let’s assume the expected return from your stock portfolio is 14%. If return on risk free T-notes are 3%, and your portfolio carries 0.05 standard deviation, the Sharpe portfolio can be calculated as:

(0.14 – 0.03) / 0.05 = 2.2.

In other words, if portfolio A generates a 8% return with a 1.50 Sharpe ratio and portfolio B also generates a 8% return with 1.25 Sharpe ratio, then A is better portfolio because you are getting the same return with less risk.

The higher the Sharpe ratio is, the higher the return an investor gets by bearing a unit of risk. The lower the Sharpe ratio is, the more risk the investor is bearing to earn additional returns. There are few assumptions which can be misleading to the investors. The main fallacy is that the assumption of investment returns are normally distributed. Returns can be skewed  or have other characteristics not described by normal distribution.

Sharpe Ratio Calculator-Excel

1. In the first column, enter annual returns of your portfolio such as ETF or Mutual Fund. You can get this information from your investment banker or online sources.

2. In the second column, enter risk-free return rate. This can typically be T-notes.

3. In the third column, take the difference between risk free return rate and actual return. This is the excess return. Name this column as Delta.

4. Do the following sub-steps

  1. Take the average of the Delta or excess return
  2. Take the Standard Deviation of Delta use STDEV function
  3. Lastly, take the ratio between average of Delta returns and Standard Deviation. This is your Sharpe Ratio.

Download Sharpe Ratio Calculator Spreadsheet

1 Comment

 Add your comment
  1. Jish
    The workbook is password protected. Please upload an unlocked version of the spreadsheet.

Leave a Comment

Your email address will not be published.