CE Course: After-tax returns: How to estimate the impact of taxes on ETF performance

By Justin Bender and Dan Bortolotti | January 23, 2015 | Last updated on January 23, 2015
15 min read

COURSE SUMMARY

Justin Bender and Dan Bortolotti of PWL Capital explain how to estimate the impact of taxes on ETF performance.

Introduction

If clients hold ETF investments outside registered accounts, taxes can take a big bite out of returns. Unfortunately, comparing the tax-efficiency of similar ETFs is difficult, because there is no standard method for estimating after-tax returns. In Canada, fund returns are reported on a pre-tax basis, but this can be misleading. As we will see, two funds with similar pre-tax returns can perform very differently when you account for the tax investors would pay on the distributions.

Background

In 2001, the Securities and Exchange Commission made it mandatory for U.S. fund companies to supply after-tax return calculations. This standardized reporting helped investors better understand the impact taxes have on the performance of their mutual funds and ETFs. For example, here’s how the Vanguard Total Stock Market ETF (VTI) reports performance on its website:

Source: The Vanguard Group

Two years later, Amin Mawani, Moshe Milevsky, and Kamphol Panyagometh published a paper in the Canadian Tax Journal called The Impact of Personal Income Taxes on Returns and Rankings of Canadian Equity Mutual Funds. The authors calculated the after-tax returns of 343 Canadian mutual funds with at least 10 years of performance data. They discovered that ranking funds based on before-tax and after-tax return produced very different results.

For example, the best-performing fund before taxes dropped to 16th place when its after-tax return was compared to others. The authors also found that investors in the highest marginal tax bracket lost about 1.35 percentage points per year to taxes on fund distributions.

More than a decade later, Canadian funds are still not required to publish after-tax returns. Morningstar Canada, a fund data provider, does calculate after-tax returns for a number of mutual funds and ETFs, but only if the fund companies provide the necessary data, and not all of them do.

Methodology

In this course we share our methodology for calculating after-tax returns, which we have applied to several popular Canadian ETFs. It will not satisfy all critics, but we believe it is a useful starting point, especially since there is no standardized methodology required by Canadian securities regulators.

Our method for calculating the pre-liquidation after-tax return for an ETF is adapted from the Morningstar After-Tax Return Methodology, which was designed for U.S. investors. We have made changes where we felt they were appropriate for Canadian investors.

A pre-liquidation after-tax return accounts for taxes paid on distributions before the after-tax proceeds are reinvested in additional units. The investor has little control over these distributions, as they are the result of the fund manager’s selections and trading.

A post-liquidation after-tax return includes the capital gain or loss realized when investors actually sell their shares. Because investors can usually choose when to sell their shares, post-liquidation after-tax returns will vary greatly among individuals.

Throughout this course we have limited the discussion to pre-liquidation after-tax returns.

To make our calculations, we created a spreadsheet that allowed us to input the date, amount and character of each distribution paid by the ETF. We also entered the net asset value (NAV) per share on the ex-dividend date of each distribution. The spreadsheet then calculated the before-tax return (both reported and adjusted, as explained below), after-tax return, and tax cost ratio for the ETF over periods of one to 10 years.

We have made our PWL 2013 After-Tax Rate of Return Calculator for Canadian ETFs available for download (an up-to-date version of Excel is necessary to use the spreadsheet). The spreadsheet is protected so the formulas cannot be altered. However, we have included detailed descriptions of these formulas in the appendix. (For the 2014 version of the calculator, click here. Note: the 2013 version is required to complete the exam for this course).

How to use the spreadsheet

To help you understand and use our downloadable spreadsheet, we’ll work through a calculation using the iShares Core S&P/TSX Composite High Dividend Index ETF (XEI).

1. Note the ex-dividend date of each distribution.

Start by visiting the ETF’s web page and clicking the “Distributions” tab to view the dates and amounts of each distribution. Record the ex-dividend date for each distribution in 2013, as you will need to enter these into the spreadsheet.

2013 Ex-Dividend Dates: XEI

XEI Distributions

Source: BlackRock Canada

The spreadsheet assumes all distributions are reinvested on the ex-dividend date. In reality an investor would not be able to reinvest the distributions until the payment date; however, most before-tax performance calculations assume dividends are reinvested on the ex-dividend date, so this allows our before and after-tax comparisons to remain consistent.

Also, payment dates may fall in the month following the ex-dividend date, which can lead to confusion when calculating the after-tax rate of return over a specific period using our spreadsheet. For instance, as you can see in the above table, many iShares ETFs had year-end distributions in 2013 that were not paid until January 6, 2014.

2. Look up the ETF’s net asset value (NAV) per share on each ex-dividend date and the last day of each year.

An ETF’s net asset value per share at the close of each trading day is available on the fund’s web page. These historical prices can be downloaded as an Excel file. (After downloading the spreadsheet, click the “Historical” tab to view the correct worksheet.)

XEI Download

Source: BlackRock Canada

For each ex-dividend date you have collected, look up the historical price per share. Also collect each year-end NAV surrounding the period you will be analyzing. In our example, we would need to collect 12 ex-dividend date NAVs from 2013 as well as two year-end NAVs: one for December 30, 2012 and the other for December 31, 2013.

3. Collect all the distribution data for the ETF

We created columns on the spreadsheet for each type of distribution an ETF might pay: Canadian dividends (eligible and non-eligible), other income (including interest and income from real estate investment trusts), foreign income, return of capital and capital gains. We also included columns for foreign tax paid (typically withholding tax on dividends) and reinvested distributions.

You can obtain this information from the CDS Innovations Tax Breakdown Posting service (an up-to-date version of Excel is necessary to use CDS Innovations spreadsheets). For a complete description of how this works, see our earlier course: As easy as ACB: Understanding and tracking adjusted cost base with ETFs.

We recommend you print the Statement of Trust Income Allocations and Designations report for each tax year in order to input the numbers into our spreadsheet.

2013 Statement of Trust Income Allocations and Designations: XEI Statement of Trust Income - XEI

Sources: BlackRock Canada, CDS Innovations Inc.

Some of the distribution information in these reports is confusing. Please note the following:

  • The distinction between eligible (labeled EDVi on our spreadsheet) and non-eligible dividends (NDVi) did not exist until the 2006 tax year. Dividends received in prior years were characterized simply as Canadian dividends (CDVi).
  • Foreign income (FINi) is the gross amount of foreign dividends. It is a combination of the net amount distributed to investors plus the Level II foreign withholding tax (see “The Impact of Foreign Withholding Taxes” in the Appendices).
  • Foreign tax paid (FTPi) should be entered as a positive value in our spreadsheet.
  • On the spreadsheets available from CDS Innovations, reinvested distributions (RDSi) are normally labeled as Total Non Cash Distribution per Unit ($), or mentioned in the Notes section of the Statement of Income Allocations and Designations report.
  • Some ETF providers, such as BMO Financial Group, use percentages rather than dollar figures when itemizing distributions in their CDS reports. You will need to convert these to a dollar figure before entering them into our spreadsheet.

4. Enter all the data into the spreadsheet

Once you have gathered the ex-dividend dates, historical prices and distribution details for the 2013 tax year, you should have all the information you need to calculate the ETF’s one-year after-tax return.

The spreadsheet is pre-filled with the name of each month in column A: simply enter the ex-dividend date in column B. (For ETFs that pay distributions quarterly in March, June, September and December, just leave the other months blank.)

Then enter each cash distribution in the appropriate box. Be careful to include any reinvested distributions as well (they are usually at year end).

PWL 2013 After-Tax Rate of Return Calculator: XEI

Sources: PWL Capital Inc., BlackRock Canada, CDS Innovations Inc.

The spreadsheet will calculate the total annual distributions of each type. You may find it helpful to compare these totals to the annual summary on the ETF’s website. If the totals don’t match, go back and make sure you haven’t mistyped something.

Total Annual Distributions

Understanding the Tax Cost Ratio

The simplest way to measure the tax-efficiency of an ETF is to divide the after-tax return by the before-tax return. This will produce its “tax-efficiency ratio,” a number between 0 and 1 indicating the proportion of the before-tax return the investor gets to keep.

For example, in 2013 the iShares U.S. High Yield Bond Index ETF (CAD-Hedged) (XHY) had an after-tax return of 3.74% and a before-tax return of 6.85%, resulting in a tax-efficiency ratio of 0.546. This means the investor kept 54.6% of the before-tax return and lost 45.4% to taxes.

Unfortunately, if the fund has a negative before-tax return, the tax-efficiency ratio would not make any sense. In 2013, for example, the iShares Canadian Universe Bond Index ETF (XBB) had an after-tax return of -3.10% and a before tax return of -1.47%, resulting in a tax-efficiency ratio of +2.11 or +211%, which is obviously incorrect.

A different measure, the tax cost ratio, was popularized by Morningstar as a way to measure the proportion of a fund’s annualized return that is lost to taxes on distributions. It produces a useful value whether the returns are positive or negative.

Where ATR is the after-tax return and BTR is the before-tax return, the equation for the tax cost ratio is:

Tax Cost Ratio

A taxable investor who is comparing two similar funds that have the same before-tax return would prefer the fund with the lower tax cost ratio.

Note, however, that the tax cost ratio can be distorted by differences in management fees and unrecoverable foreign withholding taxes. For a full explanation, see the Appendices.

Comparing ETFs on an After-Tax Basis

Calculating after-tax returns allows you to compare two or more ETFs with similar before-tax returns and investment holdings. Sometimes this produces surprising results.

In our sample calculation we saw that XEI had a before-tax return of 15.10% in 2013. The iShares Canadian Value Index ETF (XCV) performed almost identically that year with a before tax-return of 15.07%. These two ETFs also have similar holdings.

Their after-tax returns, however, were significantly different: XCV had an after-tax return of 13.80% and a tax cost ratio of 1.10%. XEI had an after-tax return of 12.73%, with a tax cost ratio of 2.06%. (This was largely due to the realization of significant capital gains by XEI during 2013.)

To be fair, these are only one-year figures: a longer measurement period should be used for these types of comparisons.

PWL 2013 After-Tax Rate of Return Calculator: XCV

Sources: PWL Capital Inc., BlackRock Canada, CDS Innovations Inc.

Comparing the tax cost ratio of funds in different asset classes can also help investors make better asset location decisions. For example, the iShares Canadian Universe Bond Index ETF (XBB) had a 10-year tax cost ratio of 2.01%, nearly twice that of the iShares Core S&P/TSX Capped Composite Index ETF (XIC), which came in at around 1.02%.

We’ve included the after-tax returns and tax cost ratios below of ETFs in 13 different asset classes.

After-Tax Returns and Tax Cost Ratios:

All periods ending December 31, 2013

iShares Canadian Short Term Bond Index ETF (XSB) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 1.47% 2.54% 3.03% 3.95%
After-Tax Return 0.12% 1.06% 1.42% 2.07%
Tax Cost Ratio 1.33% 1.44% 1.56% 1.81%
iShares Canadian Universe Bond Index ETF (XBB) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return -1.47% 3.62% 4.44% 4.94%
After-Tax Return -3.10% 1.84% 2.51% 2.84%
Tax Cost Ratio 1.66% 1.72% 1.84% 2.01%
iShares Canadian Real Return Bond Index ETF (XRB) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return -13.41% 1.50% 5.71%
After-Tax Return -15.62% -0.51% 3.88%
Tax Cost Ratio 2.55% 1.98% 1.73%
iShares U.S. High Yield Bond Index ETF (CAD-Hedged) (XHY) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 6.85% 8.21%
After-Tax Return 3.74% 4.70%
Tax Cost Ratio 2.92% 3.25%
iShares J.P. Morgan USD Emerging Markets Bond Index ETF (CAD-Hedged) (XEB) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return -7.48%
After-Tax Return -9.48%
Tax Cost Ratio 2.15%
iShares S&P/TSX Canadian Preferred Share Index ETF (CPD) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return -3.03% 2.29% 7.57%
After-Tax Return -4.48% 0.79% 6.05%
Tax Cost Ratio 1.49% 1.47% 1.41%
iShares Canadian Select Dividend Index ETF (XDV) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 18.96% 10.23% 15.63%
After-Tax Return 17.11% 8.31% 13.92%
Tax Cost Ratio 1.55% 1.75% 1.48%
iShares S&P/TSX Capped REIT Index ETF (XRE) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return -5.99% 9.72% 19.79% 9.61%
After-Tax Return -8.56% 7.64% 17.84% 7.93%
Tax Cost Ratio 2.72% 1.90% 1.63% 1.53%
iShares Global Real Estate Index ETF (CGR) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 8.29% 9.86% 11.13%
After-Tax Return 7.03% 8.29% 9.29%
Tax Cost Ratio 1.17% 1.42% 1.66%
iShares Core S&P/TSX Capped Composite Index ETF (XIC) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 12.74% 3.14% 11.58% 7.93%
After-Tax Return 11.56% 2.22% 10.62% 6.82%
Tax Cost Ratio 1.04% 0.89% 0.86% 1.02%
iShares Core S&P 500 Index ETF (CAD-Hedged) (XSP) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 32.91% 16.00% 16.98% 5.10%
After-Tax Return 31.74% 14.48% 15.50% 3.92%
Tax Cost Ratio 0.88% 1.32% 1.26% 1.12%
iShares MSCI EAFE Index ETF (CAD-Hedged) (XIN) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 25.58% 9.33% 10.21% 3.87%
After-Tax Return 23.94% 7.77% 8.70% 1.82%
Tax Cost Ratio 1.31% 1.43% 1.37% 1.97%
iShares MSCI Emerging Markets Index ETF (XEM) 1-Year Return 3-Year Annualized Return 5-Year Annualized Return 10-Year Annualized Return
Before-Tax Return 2.63% -0.26%
After-Tax Return 1.56% -1.18%
Tax Cost Ratio 1.05% 0.92%

APPENDICES

Prices

In our after-tax return calculations, the price per share (NAV) is labeled as follows:

Pe = the price per share (NAV) at the end of the holding period
Pb = the price per share (NAV) at the beginning of the holding period
Pi = the price per share (NAV) on the ex-dividend date

Our formulas for after-tax distribution accounts for the different tax rates that apply to the various types of investment income. We have labeled them as follows:

INCi = taxable interest income distributed on day i ($ per share):T3 Box No. 26
FINi = taxable foreign income distributed on day i ($ per share):T3 Box No. 25
CDVi = taxable Canadian dividends distributed on day i ($ per share):T3 Box No. 23 (pre-2006)
EDVi = taxable eligible dividends distributed on day i ($ per share):T3 Box No. 49 (post-2005)
NDVi = taxable non-eligible dividends distributed on day i ($ per share):T3 Box No. 23 (post- 2005)
CAPi = capital gains distributed on day i ($ per share):T3 Box No. 21
ROCi = return of capital distributed on day i ($ per share):T3 Box No. 42
RDSi = reinvested distributions on day i ($ per share):Non cash distribution per share ($)
FTPi = foreign tax paid on distributions on day i ($ per share):T3 Box No. 34

Tax Rates

TXIi = the  maximum combined federal / provincial income tax rate at time i
TXCi = the  maximum combined federal / provincial Canadian dividend income tax rate at time  i
TXEi = the  maximum combined federal / provincial eligible dividend income tax rate at time  i
TXNi = the  maximum combined federal / provincial non eligible dividend income tax rate at  time i
TXGi = the  maximum combined federal / provincial capital gain tax rate at time i

Equations

After-Tax Distribution Per Share:

Pre-Liquidation After-Tax Return:

Pre-Liquidation After-Tax Return

where n =          number of distributions in the holding period

Tax Assumptions

We have assumed our hypothetical investor is taxed at the maximum combined federal/provincial rate during each tax year. For example, in 2004 residents of Newfoundland and Labrador paid the highest rate on all sources of investment income relative to residents of other provinces or territories. However, in 2013 Nova Scotians paid the highest taxes on all income except non-eligible dividends, where residents of Manitoba paid the highest taxes.

It is unlikely any Canadian would pay the highest marginal tax rate on all sources of income in a year when these were split between two or more provinces. But this method allows investors to view a worst-case scenario for after-tax returns and compare it to their before-tax return. In practice, an investor’s returns will generally fall somewhere between these two values.

Maximum combined federal / provincial income tax rates: 2004–2013

Tax Rates 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Income 48.64% 48.64% 48.64% 48.25% 48.25% 48.25% 48.25% 50.00% 50.00% 50.00%
Capital Gains 24.32% 24.32% 24.32% 24.13% 24.13% 24.13% 24.13% 25.00% 25.00% 25.00%
Eligible Dividends 32.52% 30.63% 29.69% 29.69% 30.68% 34.85% 36.06% 36.06%
Non-Eligible Dividends 37.32% 36.75% 37.40% 38.21% 39.66% 41.17% 41.17% 39.15%
Canadian Dividends 37.32% 37.32%

Source: Deloitte

Provincial Source 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Income NF NF NF NS NS NS NS NS NS NS
Capital Gains NF NF NF NS NS NS NS NS NS NS
Eligible Dividends NF NF QC QC QC NS NS NS
Non-Eligible Dividends NF MB MB MB PEI PEI PEI MB
Canadian Dividends NF NF

Source: Deloitte

The Impact of Foreign Withholding Taxes

The PWL 2013 After-Tax Rate of Return Calculator generates two types of before-tax returns, which we have labeled “Reported” and “Adjusted.” The difference between these figures comes about due to foreign withholding taxes.

Many countries impose a tax on dividends paid to foreign investors: for example, the U.S. government levies a 15% tax on dividends paid to Canadians. These taxes are withheld before the dividends are paid in cash.

In non-registered accounts, investors are subject to withholding taxes levied by the countries where the stocks are domiciled, whether that is the U.S. or an overseas market. We refer to this as Level I withholding tax.

When international stocks are held indirectly via a Canadian-listed ETF that holds a U.S.-listed ETF, investors may also be subject to what we’ve called Level II withholding tax. This is an additional 15% withheld by the US government before the U.S.-listed ETF pays the dividends to Canadian investors.

(For a full discussion, see our course, Foreign Withholding Taxes: How to estimate the hidden tax drag on U.S. and international equity index funds and ETFs.)

When ETFs report their before-tax returns, they presume these withholding taxes are lost. However, the final level of foreign withholding taxes (which is designated as foreign tax paid in box 34 of your T3 slip) is generally recoverable when the ETF is held in a taxable account. So we felt it was necessary to add this back before calculating the ETF’s tax cost ratio.

In our calculations, we have adjusted the before-tax distribution per-share calculation (relative to what is posted on the ETF provider’s websites) by adding the foreign tax paid (FTPi) to each distribution before reinvesting it. The result is higher before-tax returns, as well as a higher tax cost ratio. The after-tax return remains unchanged.

Before-Tax Distribution Per-Share Adjusted:

Before-Tax Distribution Per-Share Adjusted

Before-Tax Return Adjusted:

Before-Tax Return Adjusted

where n =          number of distributions in the holding period

For example, assume a U.S. equity ETF received gross dividends of 2%, of which 15% (or 0.3 percentage points) was withheld at source, resulting in net dividends of 1.7%. If the fund’s net asset value also grew by 5%, the reported before-tax return would be 6.7%. Assuming a 50% tax rate on foreign income, the reported and adjusted amounts would differ as shown below (the after-tax return in both examples would be 6%).

Example: Impact of Reported Foreign Tax Paid on the Tax Cost Ratio

Reported Adjusted
Foreign Income 2.00% 2.00%
minus Foreign Tax Paid Box 34 @ 15% 0.30% 0.00%
equals Net Foreign Income 1.70% 2.00%
plus Unrealized Capital Gains 5.00% 5.00%
equals Before-Tax Return 6.70% 7.00%
After-Tax Return* 6.00% 6.00%
Tax Cost Ratio 0.66% 0.93%

*After-Tax Return is calculated as 2.00% × (1 – 0.50) + 5.00% = 6.00%

Moreover, when a Canadian-domiciled ETF holds a US-listed ETF of international or emerging markets stocks, another layer of unrecoverable foreign withholding tax will apply in a taxable account. Unfortunately, our before-tax return calculation adjustment does not account for this additional layer of foreign withholding taxes. The result is that the adjusted before-tax return still understates what the investor should actually receive. The actual tax cost ratio is also higher than the adjusted tax cost ratio.

In the example below, we’ve assumed a 3% dividend, a 4% unrealized capital gain, estimated and reported foreign withholding taxes of 7.5% and 15% respectively, as well as a 50% tax rate on foreign income. Our adjusted before-tax calculation leads to a better estimate of the tax cost ratio, but the calculation still underestimates the actual before-tax return and actual tax cost.

Example: Impact of Unreported Foreign Tax Paid on the Tax Cost Ratio

Reported Adjusted Actual
Foreign Income 3.00% 3.00% 3.00%
minus Foreign Tax Paid estimated @ 7.5% 0.23% 0.23%
equals Net Foreign Income estimated 2.78% 2.78%
minus Foreign Tax Paid Box 34 @ 15% 0.42% 0.00%
equals Net Foreign Income Box 34 2.36% 2.78%
plus Unrealized Capital Gains 4.00% 4.00% 4.00%
equals Before-Tax Return 6.36% 6.78% 7.00%
After-Tax Return* 5.39% 5.39% 5.39%
Tax Cost Ratio 0.91% 1.30% 1.51%

*After-Tax Return is calculated as 2.78% × (1 – 0.50) + 4.00% = 5.39%

The Impact of Fees on the Tax Cost Ratio

ETF managers use the fund’s income to pay fees and expenses and then pass on what’s left to unitholders. That means funds with higher management expense ratios (MERs) typically make smaller distributions, which results in a lower amount of tax payable by the investor.

As a result, when two otherwise comparable funds have different fees, the one with the higher MER may have a lower tax cost ratio. Although low taxes are desirable, most rational investors would prefer not to pay less in taxes because they paid more in fees.

We’ve illustrated this for a pair of funds with similar investment objectives, gross dividend yields of 3%, unrealized gains of 4%, and MERs of 0.30% and 0.80% respectively. We’ve assumed no foreign withholding taxes and a personal marginal tax rate of 50%.

Note that the higher-MER fund appears to have an advantage with a lower tax cost ratio. However, the after-tax return (which is more important) is higher for the lower-MER fund.

Lower MER Fund Higher MER Fund
Foreign Income 3.00% 3.00%
minus Management Expense Ratio (MER) 0.30% 0.80%
equals Net Foreign Income 2.70% 2.20%
plus Unrealized Capital Gains 4.00% 4.00%
equals Before-Tax Return 6.70% 6.20%
After-Tax Return* 5.35% 5.10%
Tax Cost Ratio 1.27% 1.04%

*After-Tax Returns are calculated as 2.70% × (1 – 0.50) + 4.00% = 5.35% and 2.20% × (1 – 0.50) + 4.00% = 5.10%

Next steps

Justin Bender and Dan Bortolotti