The Sharpe ratio measures excess return per unit of return volatility. It is calculated by subtracting a risk-free rate from an investment’s average return and dividing the result by the standard deviation of its returns. The ratio can help compare investments on a risk-adjusted basis, but only when the data, period, and calculation method are consistent.
A higher ratio indicates more historical or expected excess return relative to measured volatility. It does not prove that an investment is safe, predict future performance, or capture every kind of risk.
Sharpe ratio formula
Sharpe ratio = (average portfolio return − risk-free rate) ÷ standard deviation of portfolio returns
A CFA Institute paper on the Sharpe ratio and information ratio defines the Sharpe ratio as excess return divided by the standard deviation of returns. Each input must use the same frequency and time period.
- Average portfolio return: For a historical ratio, use the arithmetic mean of consistent periodic total returns.
- Risk-free rate: Use a rate that matches the return period, currency, and analytical purpose. No asset is risk-free in every practical sense.
- Standard deviation: This measures how widely the periodic returns varied around their average. It counts upside and downside variation alike.
Worked Sharpe ratio example
Assume a portfolio has an annualized average return of 10%, the matched risk-free rate is 3%, and annualized return volatility is 12%.
- Calculate excess return: 10% − 3% = 7%.
- Divide excess return by volatility: 7% ÷ 12% = 0.583.
- Round consistently: the Sharpe ratio is approximately 0.58.
The result means the portfolio produced about 0.58 units of excess return per unit of measured volatility for the data used. It does not mean the portfolio earned an extra 0.58%, and it does not establish a future return.
How to calculate a historical Sharpe ratio
- Choose the investment and period. State the start date, end date, and return frequency.
- Collect total returns. Include distributions and use a consistent series, such as monthly returns.
- Match the risk-free rate. Convert the selected rate to the same periodic frequency as the investment returns.
- Calculate periodic excess returns. Subtract the periodic risk-free return from each portfolio return.
- Find the average and standard deviation. Divide the average excess return by the standard deviation used by your stated methodology.
- Document annualization. If you annualize, disclose the convention and its assumptions.
Excel and Google Sheets workflow
If monthly portfolio returns are in cells A2:A61 and matched monthly risk-free returns are in B2:B61, calculate monthly excess returns in column C with =A2-B2 and fill down. A sample-based monthly ratio is:
=AVERAGE(C2:C61)/STDEV.S(C2:C61)
A common convention multiplies a monthly ratio by SQRT(12) to annualize it. That shortcut assumes return behavior that may not hold. CFA Institute research on the statistics of Sharpe ratios explains that multiplying by the square root of 12 is valid only under special conditions. Report the periodic ratio when those assumptions are doubtful.
How to interpret a Sharpe ratio
There is no universal cutoff that makes a Sharpe ratio good or bad. Interpretation depends on the asset class, market environment, estimation window, return frequency, fees, and whether the ratio is before or after tax.
Use the ratio primarily for like-for-like comparison:
- same return frequency and time window;
- same currency and risk-free-rate convention;
- same treatment of fees and distributions;
- same sample or population standard-deviation method; and
- similar liquidity and investment constraints.
A negative ratio means the measured return was below the selected risk-free rate. Negative ratios can produce counterintuitive rankings, so do not treat a less negative number as a complete performance verdict.
Sharpe ratio limitations
Volatility is not the same as loss
Standard deviation penalizes large positive and negative deviations. It does not isolate downside risk or show the size and duration of drawdowns.
Results depend on the period
A calm window can produce a high ratio that falls sharply when a stress period enters the sample. Short histories also create substantial estimation uncertainty.
Return distributions may be irregular
Options, leverage, illiquid assets, and strategies with occasional large losses can produce skewed or fat-tailed returns. A smooth reported series may also reflect stale valuations rather than low economic risk.
Annualization can mislead
The square-root-of-time rule assumes independence and stable return behavior. Serial correlation and changing volatility can make a simple annualized figure unreliable.
The ratio omits other risks
Liquidity, credit, concentration, counterparty, operational, and valuation risks may not appear fully in return volatility. Combine the Sharpe ratio with drawdown analysis, holdings review, scenario tests, and qualitative due diligence.
- Sortino ratio: Uses downside deviation rather than total standard deviation.
- Information ratio: Measures active return relative to a benchmark divided by tracking error.
- Treynor ratio: Uses market beta rather than total volatility.
- Maximum drawdown: Measures the largest peak-to-trough decline in the selected period.
No single metric is sufficient. Select measures that match the decision being made and the risks that matter to the investor.
This article is educational and does not provide personalized financial advice. Historical risk-adjusted performance does not guarantee future results.
Frequently asked questions
What does the Sharpe ratio measure?
The Sharpe ratio measures average return above a selected risk-free rate per unit of return volatility. It is a risk-adjusted performance measure, not a forecast.
Is a higher Sharpe ratio always better?
A higher ratio indicates more excess return per unit of measured volatility for the chosen data. It is meaningful only when methods and periods are comparable, and it does not capture every risk.
Can a Sharpe ratio be negative?
Yes. A negative ratio means the measured return was below the selected risk-free rate. Comparisons among negative ratios can be counterintuitive and require additional context.
Should I use expected or historical returns?
Use expected inputs for a forward-looking estimate and realized inputs for historical evaluation. Label the method clearly because expected returns introduce model and forecasting uncertainty.
Does the Sharpe ratio include downside risk only?
No. Its standard-deviation denominator counts both upside and downside variation. A downside-focused measure such as the Sortino ratio answers a different question.
