Treynor Ratio is a risk-adjusted-return measure for historical portfolio evaluation, named after Jack Treynor. It is similar to the Sharpe Ratio except instead of total risk, it is the return per unit of market-related risk. It is calculated by subtracting the risk-free return from the portfolio return, then dividing by the portfolio beta.
Synonym: Treynor Measure
Doc: Interpreting the
Treynor Ratio is
difficult when your beta has a low R-squared.
Ali: Got it, so look at them in tandem.
This video can be accessed in a new window or App , at the YouTube Channel or from below.
Treynor Ratio definition for investment modeling (4:48)
The script includes two sections where we visualize and demonstrate the concept of the Treynor Ratio.
We're sitting here 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.
There are two types of performance calculations: returns-based and holdings-based. For the Treynor Ratio we will use returns-based performance analysis, meaning the input is monthly returns. Holdings-based performance analysis uses holdings and provides more detail, but is a bit 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 portfolio, 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, but we won't use that for the Treynor.
Because for beta, we need 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 the slope of this line is beta.
And last, in this section we have the formula for the Treynor ratio, the risk-free rate of 0.24% and a table for the calculation of several ratios.
Next, let's focus on this cell in blue an demonstrate.
This is one way to calculate the Treynor 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 of 0.79% minus the risk-free of 0.24%, then divide by beta of 1.10 to get 0.005. This basically matches the market, or benchmark.
So to interpret, the Portfolio had higher risk as measured by standard deviation and beta. Net-net, active returns started positive but after adjusting for market-related risk using Treynor, were on par with the benchmark.
Click box for answer.
False. It is more commonly used in a returns-based analysis.
Still unclear on the Treynor 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.
Our trained humans found other terms in the category risk-adjusted performance you may find helpful.
The FactorPad YouTube Channel is growing. Subscribe to be a part of it.