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.

Sharpe Ratio = rp – rf / σP


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.

Being realistic with MVaR or 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 realism and computational simplicity. VaR can be modified using a Cornish-Fisher asymptotic expansion as follows:

Modified Sharpe Ratio


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

The attached spreadsheet simplifies the calculation for you. It 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

Download Sharpe Ratio Calculator Spreadsheet

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 Comment

Your email address will not be published.