Sortino Ratio Formula: How to Calculate It in Excel
March 9, 2026
What is Sortino Ratio?
The Sortino ratio is a risk–adjusted performance metric that evaluates the return of an investment relative to its downside (sometimes also referred to as “bad”) volatility. It is a refinement of the Sharpe ratio and was developed to address a key limitation in traditional mean–variance analysis, the treatment of all volatility as equally undesirable.
Under the modern portfolio theory, risk is typically determined by standard deviation, which penalizes both positive and negative deviations from the mean. In practice, investors are primarily concerned with downside outcomes, that is, returns that fall below a required or target level.
The Sortino ratio replaces total standard deviation with downside deviation and evaluates how much excess return a portfolio generates per unit of downside risk taken. By focusing exclusively on negative deviations from a specified threshold provides a more intuitive measure of risk-adjusted performance when loss aversion is fundamental to the analysis.
Key Learning Points
- The Sortino ratio evaluates how much excess return a portfolio generates per unit of negative volatility
- Unlike the Sharpe ratio, the Sortino ratio penalizes only returns that fall below a chosen minimum acceptable return (MAR)
- It provides deeper insight for strategies where downside protection is important or where returns are not normally distributed
- For a comprehensive performance evaluation, the Sortino ratio should be considered alongside other metrics such as the Sharpe ratio, maximum drawdown, and other tail-risk measures
How to Calculate Sortino Ratio?
The calculation of the Sortino Ratio involves several steps:
Step 1: Obtain the Return Series
First, we need to collect the periodic returns (e.g., monthly or daily). We also need to ensure consistency in frequency when specifying the Minimum Acceptable Return (MAR).
Step 2: Defining the Minimum Acceptable Return (MAR)
This may be:
- The risk-free rate, such as the Treasury Bill Benchmark
- Zero – typical for capital preservation strategies
- A required rate of return – for example some retirement strategies may have a target annual return of 7%
- A mandate-specific hurdle rate – for example a hedge fund may have a specific hurdle rate (let’s say 6%) before performance fees apply
Step 3: Calculating the downside deviation for each period
Variable definitions are given below:
We then need to square these negative deviations, average them across the sample, and take the square root:
Step 4: Calculating the excess return:
Step 5: Applying the formula:
Consistency in the methodology (for example, whether to divide by total observations or only downside observations) should always be clearly stated, as it affects comparability.
Variable definitions:
Rp = Return on the portfolio
Rt = Portfolio return in period t
MAR = Minimum acceptable return
od = Downside deviation
N = Total number of periods
Dt= Downside component in period t
Instructor Tip: Instructor tip: Always match the time periods. If you are using monthly returns, the MAR must also be monthly. If you annualize returns, annualize downside deviation consistently (multiply return by 12 and downside deviation by √12). Mixing frequencies is a common calculation error.
Sortino Ratio Interpretation
The Sortino ratio measures how efficiently a portfolio converts downside risk into excess return. Specifically, it shows how much return above a minimum acceptable return (MAR) is earned per unit of negative volatility.
Because it focuses only on returns below MAR, the Sortino ratio is particularly useful when downside protection is a priority for the investment strategy.
Below are some general guidelines:
- If > 1, then returns are adequately compensating for downside risk
- If > 2, this indicates strong downside risk-adjusted performance
- If < 1, excess returns may not justify downside exposure
- If < 0, the strategy is failing to meet its minimum performance objective
However, while these thresholds provide a reference point, the Sortino ratio is most meaningful in relative analysis. For example, when comparing managers within the same asset class and style of investing or evaluating a strategy against a benchmark.
Importantly, the choice of MAR significantly affects interpretation. A higher MAR increases the likelihood that returns fall below the threshold, which raises downside deviation, and essentially lowers the ratio. Therefore, the basis for, and level of, MAR must always be clearly stated.
The Sortino ratio also does not capture extreme tail risk or maximum drawdown. It remains a variance-based measure and should be supplemented with additional downside risk metrics, particularly for strategies with asymmetric return distributions.
Instructor Tip: Do not rely on this metric alone. Combine the Sortino ratio with other measures such as the Sharpe ratio, maximum drawdown, and tail risk metrics to build a more complete view of the strategy’s risk-adjusted performance.
Sortino Ratio Formula Excel
The Excel example below shows a step-by-step calculation of the Sortino ratio using monthly returns and a specific MAR.
The example uses a conditional formula to isolate and square downside deviations (i.e. the downside component is only calculated when Excess Return is negative) and then computes downside deviation and divides average excess return by this value to arrive at the final Sortino ratio result.
What is a Good Sortino Ratio?
Although it is difficult to universally determine what a “good” Sortino ratio is, since it depends on many portfolio characteristics such as asset class, time horizon, and market conditions, practitioners would often assume:
- If > 1 – acceptable to good downside risk-adjusted performance
- If > 2 – strong performance
- If > 3 – exceptional performance
Nevertheless, these thresholds should not be interpreted mechanically. For example, equity strategies operating in volatile markets may naturally exhibit lower ratios than market-neutral or absolute return strategies.
It is important to remember that the Sortino ratio is most meaningful in relative terms, which is when comparing strategies with similar investment objectives or benchmarks. A higher ratio indicates that returns more than compensate for downside volatility relative to the selected MAR.
On the other hand, a negative Sortino ratio signals that the portfolio’s average return falls below the minimum acceptable return, indicating insufficient compensation for the downside exposure.
Sortino Ratio vs Sharpe Ratio
The Sharpe ratio assumes that total variability is an appropriate measure of investment risk. This assumption is reasonable when returns are approximately normally distributed and investor preferences are symmetric with respect to volatility.
However, distributions in reality are often non-normal and exhibit skewness or fat tails (particularly in alternative investments or strategies involving options). In such cases, penalizing upside volatility may distort the real risk profile.
The Sortino ratio aims to correct this by isolating negative deviations from a specified target return. As a result, a portfolio with:
- High upside volatility but limited losses may have a modest Sharpe Ratio, but a strong Sortino ratio
- Infrequent but severe drawdowns may exhibit an acceptable Sharpe Ratio but a weak Sortino ratio
Therefore, the Sortino ratio is usually preferred when evaluating strategies where downside protection is a key objective.
Sortino Ratio vs Sharpe Ratio Formula
Both the Sharpe and the Sortino ratios measure excess return relative to risk, but the difference is in how risk is defined. The Sharpe ratio uses total volatility as the risk metric, treating upside and downside variability symmetrically.
Where:
- = return on the portfolio
- = risk-free rate
- = standard deviation of portfolio returns
On the other hand, the Sortino ratio replaces standard deviation with downside deviation.
Where:
- = minimum acceptable return
- = downside deviation
The risk-free rate may also be replaced with a target or hurdle rate reflecting the investor’s objectives. The result is a measure that aligns more closely with downside risk preferences rather than overall dispersion.
Which is Better, Sharpe or Sortino?
Neither of the two metrics is universally superior and the appropriate choice depends on the context of the analysis. Generally, the Sharpe ratio is often favored when evaluating broadly diversified portfolios with rather normally distributed returns. Alternatively, if return distributions exhibit skewness and downside protection is key to the investment strategy, the Sortino ratio is normally preferred.
In practice, investors would often compute both metrics to provide a more complete view of the portfolio’s risk-adjusted returns. The Sharpe ratio is a general measure of the total risk-adjusted performance, while the Sortino ratio offers additional insight into downside exposure.
Instructor Tip: If using the metrics in isolation, watch for misleading signals. A strategy can exhibit a strong Sharpe ratio, but a weak Sortino ratio if downside losses are concentrated in fewer but larger drawdowns. Conversely, a high Sortino ratio may hide overall volatility. For robust analysis, investors would typically assess both metrics alongside others such as drawdown and tail-risk measures.
Conclusion
The Sortino ratio provides a refined view of risk-adjusted performance by isolating downside volatility rather than penalizing total variability. This makes it particularly valuable when loss aversion and capital preservation are among the objectives of an investment strategy. It provides essential insight into how efficiently a portfolio manages adverse outcomes, and when used alongside complementary risk metrics, it can offer a more robust overall assessment of the portfolio’s performance.