How do you calculate the excess return of an ETF or indexed mutual fund?

For exchange-traded funds (ETFs), the excess return should equal the risk-adjusted (or beta) measure that exceeds the instrument's benchmark or annual expense ratio. It's easy to assess index mutual funds against the benchmark index: just subtract the benchmark's total return from the fund's net asset value to find the excess return. Due to mutual fund expenses, the excess return for an index fund is typically negative.

As a general rule, investors prefer index mutual funds and ETFs that outperform their benchmarks and have positive excess returns. Some investors and analysts believe it is almost impossible to generate excess returns over an extended time period for managed mutual funds due to the prevalence of high fees and market uncertainty.

Key Takeaways

  • For ETFs, the excess return should be equal to the risk-adjusted measure that exceeds the instrument's benchmark or annual expense ratio.
  • Like index mutual funds, most ETFs underperform their benchmarks, though ETFs tend to have higher excess returns on average compared with index mutual funds.
  • Using the CAPM method, one can compare two portfolios or ETFs with equal or highly similar risk profiles to see which produces the most excess returns.

Calculating Excess Return for Exchange Traded Funds

Similar to most index mutual funds, most ETFs underperform relative to their benchmark indexes. ETFs tend to have higher excess returns on average than index mutual funds.

Think of the expected return for an ETF as the ETF's alpha for a given price and risk profile. Several different measures of risk can be used to pair up an ETF with a benchmark. One common example is to use the weighted average cost of equity (WACE). If you don't have or don't want to use the annual expense ratio or a simple benchmark when calculating an ETF's excess return, use total return in excess of the expected return based on the capital asset pricing model (CAPM) formula.

The CAPM formula can be written as follows:

TEFTR = RFRR + ( ETFb × ( MR RFRR ) ) + ER where: TEFTR = Total ETF return RFRR = Risk-free rate of return ETFb = ETF beta MR = Market return ER = Excess return \begin{aligned} &\text{TEFTR} = \text{RFRR} + ( \text{ETFb} \times ( \text{MR} - \text{RFRR} ) ) + \text{ER} \\ &\textbf{where:} \\ &\text{TEFTR} = \text{Total ETF return} \\ &\text{RFRR} = \text{Risk-free rate of return} \\ &\text{ETFb} = \text{ETF beta} \\ &\text{MR} = \text{Market return} \\ &\text{ER} = \text{Excess return} \\ \end{aligned} TEFTR=RFRR+(ETFb×(MRRFRR))+ERwhere:TEFTR=Total ETF returnRFRR=Risk-free rate of returnETFb=ETF betaMR=Market returnER=Excess return

Rearranged, the formula looks like this:

ER = RFRR + ( ETFb × ( MR RFRR ) ) TEFTR \begin{aligned} &\text{ER} = \text{RFRR} + ( \text{ETFb} \times ( \text{MR} - \text{RFRR} ) ) - \text{TEFTR} \\ \end{aligned} ER=RFRR+(ETFb×(MRRFRR))TEFTR

Using the CAPM method, you can compare two portfolios or ETFs with equal or highly similar risk profiles (beta) to see which produces the most excess returns.

Calculating Excess Return for Index Funds

Index funds are designed to avoid large positive or negative excess returns relative to their index. Index fund creators use risk-control techniques and passive management to minimize the expected deviation from the benchmark.

Calculating the excess returns for an index fund is easy. To take a simple case, compare an S&P 500 index mutual fund's total returns to the S&P 500 performance. It is possible, though unlikely, for the indexed fund to outperform the S&P 500. In this case, the excess returns will be positive. It is more likely that the administrative fees associated with mutual funds will produce a slightly negative excess return.

Compare Accounts
×
The offers that appear in this table are from partnerships from which Investopedia receives compensation. This compensation may impact how and where listings appear. Investopedia does not include all offers available in the marketplace.
Provider
Name
Description