Modified Sharpe Ratio

How Sharp is the Sharpe-Ratio?

If popularity was the only measurement for risk metrics, the Sharpe ratio would tell us everything we need to know. Modified Sharpe Ratio covers further spectrum of risks in the field of investing. Any discussion on risk-adjusted performance is incomplete without touching on the topic of Sharpe ratio or Reward to Variability which divides the excess return of a portfolio above risk free rate by its standard deviation or volatility.

What is a good Sharpe Ratio?

Any Sharpe ratio greater than 1.0 is considered acceptable by investors. A ratio higher than 2.0 is considered to be good. A ratio of 3.0 or higher is excellent. A Sharpe ratio of 1 indicates that the returns on investment are proportional to the risk taken. A ratio lower than 1.0 indicates that return on investment is less than the risk taken.

Sharpe Ratio is defined as: rp – rf / σP

where,

rP = portfolio rate of return annualized normally
rF = risk free rate of return
σF = portfolio risk or volatility (annualized if portfolio return is annualized)

Sharpe ratio works well for normal-distributed returns, where the entire distribution can be explained through mean and variance alone. It is not sensitive to extreme loses and underestimates risk, and in such cases Sharpe ratio should be avoided. Its leading shortcoming is the fact that financial market returns do not follow a normal statistical distribution. The non-random part of the returns is commonly measured by Skewness, a measure of probability asymmetry, and Kurtosis with “fat tails”  which measures how peaked the random variables are.

Let’s say we have a portfolio with 8% risk premium and 25% volatility. The VaR is then roughly equal to 33.25% using a 95% confidence interval (-8 + 1.65*25, Z-value = 1.65 for 95% CI). As per VaR, there is a 95% probability that the losses on the portfolio will be restricted to $332,500 or 33.25% of a $1 million portfolio. We can flip that around and say there’s a 5% probability that the losses could exceed $332,500. VaR has limitations, starting with the assumption that returns are normally distributed.

Modified VaR and Modified Sharpe Ratio

Modified VaR or “MVaR” takes into account skewness and kurtosis of the returns distribution. It makes an attempt at finding a compromise between reality and computational simplicity. VaR can be modified using a Cornish-Fisher asymptotic expansion as follows:

Modified Sharpe Ratio

where,

zc = -1.65 with 95% confidence

rp = expected portfolio rate of return

S and K are skewness and kurtosis

Modified Sharpe Ratio adjusted for skewness and kurtosis can be expressed as:

Modified Sharpe Ratio = rp – rf / MVaR

You can find the excel model of MVaR towards the bottom of the post. The model calculates MVaR and Modified Sharpe Ratio once you fill in the annualized portfolio returns, confidence level, and portfolio amount. For calculating Z-value, use NORM.S.INV() for Excel 2010 and newer versions. Use NORMSINV() for Excel 2007 and earlier versions.

Modified Sharpe Ratio

1 Comment

 Add your comment
  1. Consider using expression:
    ASR=SR*(1+(skew/6)*SR-((Kurt-3)/24)*SR^2); where, SR=(Mean-Rf)/SD

Leave a Reply

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

All spreadsheets now pulling quotes from Bloomberg API

Got it!
X Get Bar