Columbia India Consumer ETF
ALTAR
Score™
3.2% info Recommen-
dation
AVOID
2020E    2021E
P/E
ratio
66.6x P/Sales
ratio
0.9x
P/BV
ratio
2.8x Div.
yield
1.4%


  • Description
  • Performance
  • Comps
  • premium Fundamentals
  • premium Valuation
  • premium Rating
The Columbia India Consumer ETF& tracks the Indxx India Consumer Index, a market-cap-weighted index of 30 Indian consumer discretionary stocks listed on the National Stock exchange or the Bombay Stock Exchange.

FUND BASICS
Category Emerging Market Equities
Fund Sponsor Columbia
Website www.columbiathreadneedleetf.com
Inception date Aug 10, 2011
Assets (mns) $72
Currency USD
Expense ratio 75 bp
Distributions Annually

FUND STRUCTURE
Regulation Open-Ended Fund
Custodian
Weighting Market Cap
Index replication Optimized
Uses derivatives No
Options available No

SECTOR BREAKDOWN

 


CONSTITUENT BREAKDOWN
No. of constituents 31
Wgt avg mkt cap (mns) $4,627
Large cap (>$10bn) 35.6%
Mid cap ($2-10bn) 62.9%
Small cap (<$2bn) 1.5%
Developed mkts 0.0%
Emerging mkts 100.0%

TOP TEN HOLDINGS
ITC LTD 5.2 %
AVENUE SUPERMARTS LTD. 5.0 %
EICHER MOTORS LTD 4.6 %
HERO HONDA MOTORS LIMITED 3.9 %
TATA MOTORS LTD 3.4 %
TATA TEA LTD 2.9 %
MAHINDRA & MAHINDRA LTD. 2.8 %
JUBILANT FOODWORKS LTD 2.4 %
BALKRISHNA INDUSTRIES LIMITED 1.8 %
BAJAJ AUTO LIMITED 1.8 %
Total 33.8 %

TOP COUNTRY EXPOSURE
INDIA 40.4 %










HISTORICAL PERFORMANCE info

  Custom date range Compare to  
  thru


Standardized Annual Returns (thru June 30)
Year-to-date 1 year 5 years 10 years Since Incep.
-10.6% -8.1% 2.1% -- 7.7%

Market Correlations
versus... Beta R-squared
S&P500 0.64 22%
MSCI EAFE 0.84 33%
MSCI Emg. Mkts. 0.70 36%

Technical Indicators
Recent close $38.10
30d moving avg. $36.28
Annualized volatility 23.2%
Short interest (ETF) 0.8%
Relative strength (RSI) 68

Liquidity measures
Avg. volume (thou.) 8
Turnover 0.4%
Bid/Ask (% of price) 1.69%
ADV underlying (mns) $88

Distributions


FINDING ALTERNATIVE FUNDS

Below is a list of 78 potential alternatives to the Columbia India Consumer ETF ETF based on the alternatives' overlap in portfolio holdings with INCO. Consider funds with lower expense ratios and/or higher ALTAR Score™ ratings as possible alternatives.

Benchmark ticker: INCO Expense: 75 bp ALTAR Score™: 3.2%


ALTERNATIVE ETFs BASED ON OVERLAP WITH INCO
Ticker Fund
Name
Overlap1
vs INCO
(%)
Expense
ratio
(bp)
Savings
vs INCO
(bp)
ALTAR
Score™
(%)
ALTAR
vs INCO
(%)
NFTY First Trust India NIFTY 50 Equal Weight ETF 14.2 80 -5 8.0 +4.9
INDA iShares MSCI India ETF 10.8 69 6 5.4 +2.3
INDY iShares India 50 ETF 10.0 94 -19 5.8 +2.6
FLIN Franklin FTSE India ETF 9.9 19 56 5.9 +2.7
PIN Invesco India ETF 9.4 78 -3 5.9 +2.7
IXSE WisdomTree India Ex-State-Owned Enterprises Fund 9.2 58 17 5.1 +2.0
EPI WisdomTree India Earnings Fund 8.5 85 -10 9.1 +5.9
ECON Columbia Emerging Markets Consumer ETF 6.1 59 16 4.7 +1.6
SMIN iShares MSCI India Small Cap ETF 3.0 76 -1 3.4 +0.2
FTAG First Trust Indxx Global Agriculture ETF 2.4 70 5 6.6 +3.4
QEMM SPDR MSCI Emerging Markets StrategicFactors ETF 2.4 30 45 9.1 +6.0
EMDV ProShares MSCI Emerging Markets Dividend Growers ETF 2.1 60 15 8.7 +5.6
EMCG WisdomTree Emerging Markets Consumer Growth Fund 2.1 32 43 7.5 +4.4
BKF iShares MSCI BRIC ETF 2.0 69 6 8.0 +4.8
MXDE Nationwide Maximum Diversification Emerging Mkts Core Eq 1.9 64 11 5.0 +1.8
JHEM John Hancock Multifactor Emerging Markets ETF 1.8 49 26 8.9 +5.7
DVEM WisdomTree Emerging Markets Dividend Fund 1.7 32 43 8.6 +5.5
FDEM Fidelity Targeted Emerging Markets Factor ETF 1.7 45 30 9.9 +6.7
CEZ VictoryShares Emerging Market Volatility Wtd Index ETF 1.7 50 25 10.6 +7.5
EEMA iShares MSCI Emerging Markets Asia ETF 1.6 50 25 8.1 +4.9
XSOE WisdomTree Emerging Markets ex-State-Owned Enterprises Fund 1.5 32 43 6.5 +3.4
KEMX KraneShares MSCI Emerging Markets EX China Index ETF 1.5 49 26 8.3 +5.1
GMF SPDR S&P Emerging Asia Pacific ETF 1.5 49 26 7.8 +4.6
EEMV iShares Edge MSCI Min Vol Emerging Markets ETF 1.4 25 50 8.0 +4.8
AAXJ iShares MSCI All Country Asia ex Japan ETF 1.4 68 7 7.6 +4.4
SCHE Schwab Emerging Markets Equity ETF 1.4 11 64 8.4 +5.2
FLAX Franklin FTSE Asia Ex Japan ETF 1.4 19 56 8.2 +5.1
EEMX SPDR MSCI Emerging Markets Fossil Fuel Free ETF 1.3 30 45 8.3 +5.2
VWO Vanguard FTSE Emerging Markets ETF 1.3 10 65 8.6 +5.4
EEM iShares MSCI Emerging Markets ETF 1.3 68 7 7.9 +4.8
DBEM Xtrackers MSCI Emerging Markets Hedged Equity ETF 1.3 65 10 7.9 +4.8
SPEM SPDR Portfolio Emerging Markets ETF 1.3 11 64 8.3 +5.1
IEMG iShares Core MSCI Emerging Markets ETF 1.2 13 62 8.4 +5.2
AVEM Avantis Emerging Markets Equity ETF 1.2 33 42 9.4 +6.3
GSEE Goldman Sachs MarketBeta Emerging Markets Equity ETF 1.2 36 39 8.7 +5.5
DGRE WisdomTree Emerging Markets Quality Dividend Growth Fund 1.2 32 43 9.4 +6.3
RNEM Emerging Markets Equity Select ETF 1.1 75 0 10.7 +7.6
FNDE Schwab Fundamental Emerging Markets Large Co. Index ETF 1.0 39 36 13.3 +10.1
GEM Goldman Sachs ActiveBeta Emerging Markets Equity ETF 1.0 45 30 8.3 +5.2
RFEM First Trust Riverfront Dynamic Emerging Markets ETF 1.0 95 -20 9.9 +6.7
DNL WisdomTree Global ex-US Quality Dividend Growth Fund 0.9 58 17 8.0 +4.8
EMMF WisdomTree Emerging Markets Multifactor Fund 0.9 48 27 9.9 +6.8
JPEM JPMorgan Diversified Return Emerging Markets Equity ETF 0.9 44 31 9.3 +6.1
ESGE iShares ESG MSCI EM ETF 0.9 25 50 9.2 +6.0
PXH Invesco FTSE RAFI Emerging Markets ETF 0.9 50 25 13.7 +10.6
EMSG Xtrackers MSCI Emerging Markets ESG Leaders Equity ETF 0.9 20 55 7.3 +4.1
TLTE FlexShares Morningstar Emerging Markets Factor Tilt Index 0.8 59 16 11.6 +8.4
AXJL WisdomTree Asia Pacific ex-Japan Fund 0.7 48 27 9.7 +6.5
VEGI iShares MSCI Global Agriculture Producers ETF 0.7 39 36 6.2 +3.0
ACWV iShares Edge MSCI Min Vol Global ETF 0.6 20 55 5.7 +2.6
VIGI Vanguard International Dividend Appreciation ETF 0.6 25 50 5.7 +2.5
IQDE FlexShares International Quality Dividend Defensive Index Fd 0.5 47 28 12.5 +9.3
DBAW Xtrackers MSCI All World ex US Hedged Equity ETF 0.4 40 35 7.2 +4.1
IXUS ishares Core MSCI Total International Stock ETF 0.4 9 66 7.6 +4.5
CWI SPDR MSCI ACWI ex-US ETF 0.4 30 45 7.4 +4.2
EEMO Invesco S&P Emerging Markets Momentum ETF 0.4 29 46 7.0 +3.8
EEMS iShares MSCI Emerging Markets Small Cap ETF 0.4 69 6 8.3 +5.1
VEU Vanguard FTSE All-World ex-US Index Fund 0.4 8 67 7.8 +4.7
VXUS Vanguard Total International Stock Index Fund 0.4 8 67 7.8 +4.6
VSGX Vanguard ESG International Stock ETF 0.4 17 58 7.4 +4.3
ACSG Xtrackers MSCI ACWI ex USA ESG Leaders Equity ETF 0.3 16 59 7.1 +4.0
IGRO iShares International Dividend Growth ETF 0.3 22 53 8.2 +5.0
NUEM Nuveen ESG Emerging Markets Equity ETF 0.3 45 30 7.7 +4.6
DGS WisdomTree Emerging Markets SmallCap Dividend Fund 0.3 63 12 13.0 +9.8
CRBN iShares MSCI ACWI Low Carbon Target ETF 0.3 20 55 6.2 +3.1
LOWC SPDR MSCI ACWI Low Carbon Target ETF 0.2 20 55 6.2 +3.0
HDAW Xtrackers MSCI All World ex US High Dividend Yield Hedged 0.2 20 55 11.3 +8.2
VT Vanguard Total World Stock Index Fund 0.2 8 67 6.3 +3.1
SDG iShares Sustainable MSCI Global Impact ETF 0.2 49 26 6.0 +2.8
EWX SPDR S&P Emerging Markets Small Cap ETF 0.2 65 10 6.4 +3.3
VSS Vanguard FTSE All World (ex-US) Small Cap Index Fund 0.1 11 64 7.0 +3.8
QLVE FlexShares Emerging Markets Quality Low Volatility Index Fun 0.1 40 35 7.5 +4.3
FEM First Trust Emerging Markets AlphaDEX Fund 0.1 80 -5 11.6 +8.5
VYMI Vanguard International High Dividend Yield ETF 0.0 32 43 10.4 +7.2
EMGF iShares Edge MSCI Multifactor Emerging Markets ETF 0.0 45 30 9.7 +6.5
ACWF iShares FactorSelect MSCI Global ETF 0.0 35 40 8.1 +5.0
ACWI iShares MSCI ACWI ETF 0.0 32 43 6.0 +2.8
ACWX iShares MSCI ACWI ex U.S. ETF 0.0 32 43 7.5 +4.3

1Overlap is the percentage of holdings by weight that are identical. For example, if Fund A has a 2% position in Apple, Inc. (AAPL) and Fund B has a 5% position, their overlapping position in AAPL is 2%.

Content on this tab for subscribers only**

RESULTS & ESTIMATES

  2015 2016 2017 2018 2019 2020E 2021E
Sales per share ** ** ** ** ** ** **
Earnings per share ** ** ** ** ** ** **
Dividends per share info ** ** ** ** ** ** **
Book value per share ** ** ** ** ** ** **

 

Sales per share growth   **% **% **% **% **% **%
EPS growth   **% **% **% **% **% **%

Sales per share growth   **% **% **% **% **% **%
EPS growth   **% **% **% **% **% **%

OTHER FUNDAMENTAL METRICS

Long term EPS growth est. **%   Debt-to-equity **x
Asset turnover **%   Assets-to-equity **x

Return on equity

Revision activity*
*Six months ago = 100

Net margins

Compound annual growth rates

Content on this tab for subscribers only

VALUATION METRICS
  2019 2020E 2021E
Price-to-sales ** ** **
Price-to-earnings ** ** **
Price-to-cash flow ** ** **
Price-to-growth ** ** **
Price-to-book value ** ** **
Yield ** ** **

Historical valuation trends

Forward
multiple:
Columbia India Consumer ETF
Relative
to:
S&P500 MSCI EAFE MSCI Emg. Mkts. Other ETF:

AVOID

Not worthwhile for most investors. A rating of AVOID is assigned to ETFs with ALTAR Scores in the lowest quintile (the bottom 20%) of their category. Often, funds in this category consist of stocks with little if any history or expectation of profitability, and as a result our fundamentally-driven analysis may not be relevant.

ALTAR Score™


Calculation of ALTAR Score™
Avg. Return on Equity 10.5 %
Divided by: Fwd. P/BV 2.7 x
Less: Expense ratio 75 bp
Equals: ALTAR Score 3.2 %
info More information on ALTAR Score™

MODERN PORTFOLIO THEORY info

CONSENSUS RECOMMENDATIONS: FUND CONSTITUENTS
COMPOSITE
RATING
1.66 CATEGORY
AVERAGE
1.45
 
The composite rating is a weighted average of analysts' consensus recommendations for individual ETF constituents, based on the following scale:

BUY = 1; OVERWEIGHT = 1.5, HOLD = 2; UNDERWEIGHT = 2.5; and SELL = 3.

Readers are cautioned that because analyst ratings tend to be inflated, the composite score may be more useful as a relative measure of sentiment between funds rather than as a stand-alone recommendation.
 

 

See RATING tab for calculation of ALTAR Score™
Risk & reward. Uses std. dev. as proxy for risk, ALTAR Score™ for return forecast.
Dividends paid by constituents to the fund. May differ from actual distributions to shareholders due to constituent changes, timing issues or other factors.
Monthly returns based on changes in price plus dividends. May differ from daily returns reported by funds. See below for standardized returns.