Faster Learning Tutorials

# Sharpe Ratio definition and tutorial

A ratio with many uses. Helpful for historical performance measurement and also risk forecasting applications.
1. Define - Define the Sharpe Ratio.
2. Context - Use Sharpe Ratio in a sentence.
3. Video - See the video.
4. Script - Read the transcript.
5. Quiz - Test your knowledge.
###### by Paul Alan Davis, CFA, July 6, 2016
Updated: December 21, 2018
##### If there is one risk measure preferred by investment consultants, it might just be the Sharpe Ratio.

~/ home  / finance  / glossary  / sharpe ratio

## Sharpe Ratio for Investment Modeling

Intermediate

Sharpe Ratio is a widely-adopted return-to-risk ratio used to evaluate historical portfolio performance. It is also used in forward-looking portfolio optimizations with the objective set to maximize this ratio. To calculate, subtract the risk-free return from the portfolio return, then divide by the portfolio standard deviation. It was named after William F. Sharpe, a key contributor to the Capital Asset Pricing Model, in the 1960s.

Synonyms: Sharpe Index, Sharpe Measure

### In a Sentence

Doc:  The Sharpe Ratio  influenced two different fields in Finance. So Bill sure was sharp.
Joe:  Excuse me, Professor. Was that supposed to be funny?

### Video

This video can be accessed in a new window or App , at the YouTube Channel or from below.

Sharpe Ratio definition for investment modeling (4:34)

### Video Script

The script includes two sections where we visualize and demonstrate the concept of the Sharpe Ratio.

#### Visualize

We're sitting in Excel and this is a snippet from our boot camp course.

Here we are focused on portfolios and specifically evaluating the historical performance of portfolios. See the video on portfolio optimization for related forward-looking concepts.

This method is called returns-based performance analysis, meaning we are taking monthly returns as the input. Holdings-based performance analysis uses holdings and provides more detail, but is too complex to cover here.

First, we need to create a portfolio. In this section we have a Market portfolio, like an index or benchmark, with these weights to four stocks, and another called Portfolio which is actively managed, with these weights. Active weights refer to the differences.

Here we have returns calculated over a 60-month period, totals and averages, based on data on the Returns tab. Let's focus on the second row, average arithmetic. The Portfolio beat the Market by 0.08% per month.

Next we have the standard deviation of monthly returns, so the Portfolio had higher monthly volatility.

While not required for the Sharpe Ratio, it is a good idea to run a regression, as shown on this chart, the 60 monthly returns on the Market plotted on the x-axis with the Portfolio return on the y-axis. So from the regression we get the measures alpha and beta here.

And last, this section we have the formula for the Sharpe Ratio, the risk-free rate of 0.24% and a table for the calculation of several ratios.

Next, let's focus on this cell G28 and demonstrate.

#### Demonstrate

This is one way to calculate the Sharpe Ratio in Excel, using monthly data but it is very common to use annual figures.

Ok, we have all the data we need. Using this formula, let's take the Portfolio return 0.79%, minus the risk-free of 0.24%, then divide by 5.30% to get 0.104. This is low, as Sharpe Ratios above 1.0 are considered good.

The Sharpe Ratio can be thought of as the slope of a line too, with a higher sloping line offering a higher reward-to-risk ratio, which is better. And remember, this can be negative as well.

### Quiz

Click box for answer.

The Sharpe Ratio can be interpreted as the slope of a line. | True or False?

True

#### Questions or Comments?

Still unclear on the Sharpe Ratio? Leave a question in the comments section on YouTube or check out the Quant 101 Series, specifically Analyze portfolio performance with linear regression in Excel.

### Related Terms

Our trained humans found other terms in the category risk-adjusted performance you may find helpful.

## What's Next?

Join other smart people like you at the FactorPad YouTube Channel.

• To see all terms in the Glossary, click Outline.
• To learn about the Sample Statistic, click Back.
• For an important output from a regression called Specific Risk, click Next.

~/ home  / finance  / glossary  / sharpe ratio

Keywords:
sharpe ratio
sharpe index
sharpe measure
reward-to-risk ratio
portfolio performance
optimization objective
return over standard deviation
maximize sharpe ratio
sharpe ratio example
stock portfolio
active management ratio
william sharpe
captial asset pricing model
capm
portfolio management
objective function