Columbia India Consumer ETF
ALTAR
Score™		 1.7% info Recommen-
dation		 AVOID
2024E    2025E
P/E
ratio		 33.3x P/Sales
ratio		 3.2x
P/BV
ratio		 7.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) $15
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 Yes

SECTOR BREAKDOWN

 


CONSTITUENT BREAKDOWN
No. of constituents 15
Wgt avg mkt cap (mns) $21,951
Large cap (>$10bn) 81.6%
Mid cap ($2-10bn) 18.4%
Small cap (<$2bn) 0.0%
Developed mkts 0.0%
Emerging mkts 100.0%

TOP TEN HOLDINGS
TATA MOTORS LTD 7.3 %
ZOMATO LTD. 5.9 %
BAJAJ AUTO LIMITED 5.7 %
TRENT LTD 5.3 %
MAHINDRA & MAHINDRA LTD. 5.2 %
TATA TEA LTD 5.1 %
TITAN INDUSTRIES LIMITED 4.6 %
MARUTI SUZUKI INDIA LTD 4.3 %
HERO HONDA MOTORS LIMITED 4.1 %
AVENUE SUPERMARTS LTD. 3.7 %
Total 51.2 %

TOP COUNTRY EXPOSURE
INDIA 92.3 %










HISTORICAL PERFORMANCE info

  Custom date range Compare to  
  thru


Standardized Annual Returns (thru March 31)
Year-to-date 1 year 5 years 10 years Since Incep.
6.3% 46.1% 12.7% 12.0% 11.4%

Market Correlations
versus... Beta R-squared
S&P500 0.43 28%
MSCI EAFE 0.44 28%
MSCI Emg. Mkts. 0.36 20%

Technical Indicators
Recent close $63.10
30d moving avg. $56.81
Annualized volatility 14.3%
Short interest (ETF) 13.1%
Relative strength (RSI) 75

Liquidity measures
Avg. volume (thou.) 44
Turnover 18.0%
Bid/Ask (% of price) 0.22%
ADV underlying (mns) $203

Distributions


FINDING ALTERNATIVE FUNDS

Below is a list of 104 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™: 1.7%


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 23.7 80 -5 6.3 +4.6
ECON Columbia Emerging Markets Consumer ETF 20.3 49 26 4.9 +3.2
NDIA Global X India Active ETF 18.3 75 0 6.6 +5.0
INDA iShares MSCI India ETF 17.6 65 10 3.7 +2.1
FLIN Franklin FTSE India ETF 17.0 19 56 5.3 +3.7
INDY iShares India 50 ETF 15.9 89 -14 3.8 +2.1
PIN Invesco India ETF 15.6 78 -3 3.9 +2.2
GLIN VanEck India Growth Leaders ETF 11.8 77 -2 5.4 +3.8
EEMO Invesco S&P Emerging Markets Momentum ETF 10.2 29 46 6.3 +4.6
EMC Global X Emerging Markets Great Consumer ETF 9.8 75 0 5.0 +3.3
MINV Matthews Asia Innovators Active ETF 8.9 79 -4 2.9 +1.2
EPI WisdomTree India Earnings Fund 8.8 85 -10 6.8 +5.1
DGRE WisdomTree Emerging Markets Quality Dividend Growth Fund 7.5 32 43 7.7 +6.0
EMMF WisdomTree Emerging Markets Multifactor Fund 7.4 48 27 9.4 +7.8
NUEM Nuveen ESG Emerging Markets Equity ETF 7.1 36 39 6.9 +5.2
INQQ India Internet & Ecommerce ETF 7.0 86 -11 11.0 +9.3
EMM Global X Emerging Markets ex-China ETF 6.2 75 0 3.7 +2.1
OND ProShares On-Demand ETF 5.8 58 17 -2.5 -4.1
XC WisdomTree Emerging Markets Ex-China Fund 5.8 32 43 6.2 +4.6
EEMV iShares MSCI Emerging Markets Min Vol Factor ETF 5.6 25 50 7.1 +5.4
RNEM First Trust Emerging Markets Equity Select ETF 5.4 75 0 8.4 +6.8
FTAG First Trust Indxx Global Agriculture ETF 5.2 70 5 9.1 +7.5
STXE Strive Emerging Markets Ex-China ETF 5.1 32 43 7.0 +5.3
QLVE FlexShares Emerging Markets Quality Low Volatility Index Fun 5.1 40 35 7.2 +5.6
XSOE WisdomTree Emerging Markets ex-State-Owned Enterprises Fund 5.0 32 43 6.4 +4.7
FMQQ FMQQ The Next Frontier Internet & Ecommerce ETF 5.0 86 -11 2.0 +0.3
QEMM SPDR MSCI Emerging Markets StrategicFactors ETF 4.8 30 45 8.7 +7.0
DGIN VanEck Digital India ETF 4.8 71 4 1.6 -0.0
DEHP Dimensional Emerging Markets High Profitability ETF 4.5 41 34 7.4 +5.7
BKF iShares MSCI BIC ETF 4.3 69 6 7.4 +5.7
ROAM Hartford Multifactor Emerging Markets ETF 4.2 44 31 11.8 +10.2
KEMX KraneShares MSCI Emerging Markets EX China Index ETF 4.2 24 51 7.2 +5.5
ESGE iShares ESG Aware MSCI EM ETF 4.1 25 50 7.8 +6.1
JHEM John Hancock Multifactor Emerging Markets ETF 4.0 49 26 8.5 +6.8
EMXC iShares MSCI Emerging Markets ex China ETF 4.0 25 50 6.7 +5.1
RFEM First Trust Riverfront Dynamic Emerging Markets ETF 4.0 95 -20 11.6 +10.0
EEMA iShares MSCI Emerging Markets Asia ETF 4.0 49 26 6.8 +5.2
GMF SPDR S&P Emerging Asia Pacific ETF 3.9 49 26 6.5 +4.8
EMXF iShares ESG Advanced MSCI EM ETF 3.9 16 59 7.6 +5.9
FLAX Franklin FTSE Asia Ex Japan ETF 3.9 19 56 7.3 +5.7
AAXJ iShares MSCI All Country Asia ex Japan ETF 3.7 70 5 6.5 +4.8
EEMX SPDR MSCI Emerging Markets Fossil Fuel Free ETF 3.5 30 45 7.6 +6.0
KEMQ KraneShares Emerging Markets Consumer Technology Index ETF 3.5 60 15 1.0 -0.7
GEM Goldman Sachs ActiveBeta Emerging Markets Equity ETF 3.4 45 30 8.7 +7.0
BKEM BNY Mellon Emerging Markets Equity ETF 3.3 11 64 7.8 +6.2
GSEE Goldman Sachs MarketBeta Emerging Markets Equity ETF 3.3 36 39 7.6 +5.9
SCHE Schwab Emerging Markets Equity ETF 3.3 11 64 7.7 +6.0
DFSE Dimensional Emerging Markets Sustainability Core 1 ETF 3.2 41 34 7.9 +6.3
DBEM Xtrackers MSCI Emerging Markets Hedged Equity ETF 3.2 66 9 7.4 +5.7
IWFH iShares Virtual Work and Life Multisector ETF 3.1 47 28 -3.6 -5.2
EMDV ProShares MSCI Emerging Markets Dividend Growers ETF 3.1 60 15 10.0 +8.4
FDEM Fidelity Emerging Markets Multifactor ETF 3.0 25 50 12.1 +10.5
JEMA JPMorgan ActiveBuilders Emerging Markets Equity ETF 3.0 33 42 7.3 +5.6
VWO Vanguard FTSE Emerging Markets ETF 3.0 8 67 7.7 +6.0
DFAE Dimensional Emerging Core Equity Market ETF 3.0 35 40 7.8 +6.2
MEM Matthews Emerging Markets Equity Active ETF 2.9 79 -4 5.9 +4.2
EMSG Xtrackers MSCI Emerging Markets ESG Leaders Equity ETF 2.9 20 55 7.7 +6.0
EMCR Xtrackers Emerging Markets Carbon Reduction and Climate Impr 2.9 15 60 7.2 +5.5
JPEM JPMorgan Diversified Return Emerging Markets Equity ETF 2.9 44 31 10.4 +8.7
EDIV SPDR S&P Emerging Markets Dividend ETF 2.8 49 26 11.1 +9.4
LDEM iShares ESG MSCI EM Leaders ETF 2.8 17 58 7.9 +6.3
RAYE Rayliant Quantamental Emerging Market ex-China Equity ETF 2.8 88 -13 6.3 +4.6
SPEM SPDR Portfolio Emerging Markets ETF 2.8 7 68 7.6 +6.0
DFEM Dimensional Emerging Markets Core Equity 2 ETF 2.7 38 37 8.4 +6.7
EMDM First Trust Bloomberg Emerging Market Democracies ETF 2.6 75 0 9.8 +8.1
EEM iShares MSCI Emerging Markets ETF 2.5 69 6 7.1 +5.4
MFEM PIMCO RAFI Dynamic Multi-Factor Emerging Markets Equity ETF 2.4 50 25 10.7 +9.0
IEMG iShares Core MSCI Emerging Markets ETF 2.4 9 66 7.7 +6.0
UEVM VictoryShares Emerging Markets Value Momentum ETF 2.2 45 30 12.9 +11.2
XCEM Columbia EM Core ex-China ETF 2.0 16 59 7.4 +5.7
AVEM Avantis Emerging Markets Equity ETF 1.9 33 42 9.3 +7.6
FEEM FlexShares ESG & Climate Emerging Markets Core Index ETF 1.8 18 57 8.0 +6.3
TLTE FlexShares Morningstar Emerging Markets Factor Tilt Index 1.6 59 16 9.7 +8.1
EMGF iShares Emerging Markets Equity Factor ETF 1.6 25 50 8.8 +7.1
VEGI iShares MSCI Agriculture Producers ETF 1.6 39 36 9.2 +7.6
FNDE Schwab Fundamental Emerging Markets Large Co. Index ETF 1.4 39 36 12.8 +11.1
EMQQ EMQQ The Emerging Markets Internet & Ecommerce ETF 1.4 86 -11 2.1 +0.4
CGXU Capital Group International Focus Equity ETF 1.2 54 21 4.2 +2.5
FEM First Trust Emerging Markets AlphaDEX Fund 1.2 80 -5 16.5 +14.8
GTEK Goldman Sachs Future Tech Leaders Equity ETF 1.2 75 0 3.2 +1.5
PXH Invesco FTSE RAFI Emerging Markets ETF 1.2 49 26 12.7 +11.0
IWTR iShares MSCI Water Management Multisector ETF 1.2 47 28 4.9 +3.2
DFEV Dimensional Emerging Markets Value ETF 1.1 43 32 11.1 +9.4
VIGI Vanguard International Dividend Appreciation ETF 1.0 15 60 5.6 +4.0
CWI SPDR MSCI ACWI ex-US ETF 0.9 30 45 6.9 +5.3
DBAW Xtrackers MSCI All World ex US Hedged Equity ETF 0.9 41 34 6.8 +5.1
VEU Vanguard FTSE All-World ex-US Index Fund 0.9 8 67 7.3 +5.6
ACWX iShares MSCI ACWI ex U.S. ETF 0.9 34 41 6.8 +5.1
SCHY Schwab International Dividend Equity ETF 0.8 14 61 9.4 +7.7
DFAX Dimensional World ex U.S. Core Equity 2 ETF 0.8 30 45 7.9 +6.2
VXUS Vanguard Total International Stock ETF 0.8 7 68 7.2 +5.6
AVES Avantis Emerging Markets Value ETF 0.8 36 39 12.3 +10.6
IXUS iShares Core MSCI Total International Stock ETF 0.8 7 68 7.0 +5.3
VSGX Vanguard ESG International Stock ETF 0.8 12 63 6.9 +5.2
ACWV iShares MSCI Global Min Vol Factor ETF 0.7 20 55 6.8 +5.1
IGRO iShares International Dividend Growth ETF 0.5 15 60 7.2 +5.5
CRBN iShares MSCI ACWI Low Carbon Target ETF 0.3 20 55 5.7 +4.0
SDG iShares MSCI Global Sustainable Development Goals ETF 0.3 49 26 5.9 +4.2
ACWI iShares MSCI ACWI ETF 0.3 32 43 5.5 +3.9
DNL WisdomTree Global ex-US Quality Dividend Growth Fund 0.3 42 33 6.9 +5.2
VT Vanguard Total World Stock ETF 0.3 7 68 5.9 +4.2
NZAC SPDR MSCI ACWI Climate Paris Aligned ETF 0.3 12 63 5.1 +3.4
VYMI Vanguard International High Dividend Yield ETF 0.2 22 53 9.9 +8.2
SPGM SPDR Portfolio MSCI Global Stock Market ETF 0.0 9 66 5.8 +4.1

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

  2019 2020 2021 2022 2023 2024E 2025E
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
  2023 2024E 2025E
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 18.1 %
Divided by: Fwd. P/BV 7.5 x
Less: Expense ratio 75 bp
Equals: ALTAR Score 1.7 %
info More information on ALTAR Score™
MODERN PORTFOLIO THEORY info

CONSENSUS RECOMMENDATIONS: FUND CONSTITUENTS
COMPOSITE
RATING		 1.51 CATEGORY
AVERAGE		 1.39
 
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.