VDC · Vanguard

Vanguard Consumer Staples ETF

Name: VDC (Vanguard Consumer Staples ETF) look-through valuation
Creator: ratio/fox
License: https://ratiofox.com/data-licence/v1

See how 103 reported holdings combine into this ETF’s P/E and P/S. Market value, signed ordinary earnings and revenue are added before each ratio is calculated.

Holdings dated 31 May 2026Price US$231.75 as of 21 August 2026Meets ratio/fox coverage standard

Core valuation

Trailing P/E29.50×99.01% of 99.69% disclosed weight

Latest-quarter run-rate P/E28.35×99.06% of 99.69% disclosed weight

Trailing P/S1.21×99.06% of 99.69% disclosed weight

Latest-quarter run-rate P/S1.24×99.13% of 99.69% disclosed weight

Coverage is the share of positive eligible-equity holding value represented in each metric. The published holdings account for 99.69% of fund weight. The reliability standard requires at least 90.00% disclosed fund weight and metric coverage, with no individual uncovered holding above 1.00%.

Largest reported holdings

Holding	Weight	Trailing P/E	Trailing P/S
WMTWalmart Inc.	14.50%	36.05×	1.15×
COSTCostco Wholesale Corp.	11.83%	47.56×	1.43×
PGProcter & Gamble Co.	8.69%	20.64×	3.89×
KOCoca-Cola Co.	7.91%	28.61×	7.95×
PEPPepsiCo Inc.	4.52%	22.46×	2.05×
PMPhilip Morris International Inc.	4.36%	26.51×	7.07×
MOAltria Group Inc.	3.90%	13.74×	4.71×
MDLZMondelez International Inc. Class A	2.68%	31.71×	2.10×
CLColgate-Palmolive Co.	2.37%	34.92×	3.50×
MNSTMonster Beverage Corp.	2.23%	23.00×	5.32×

Top 10 of 103 reported holdings. * A holding uses its latest full-year result only when both trailing and latest-quarter inputs are unavailable; open the stock for the exact year end.

Most similar funds

Ranked by shared weight across matching disclosed company holdings and explicitly reported same-currency cash.

US92204A8505 · Vanguard Consumer Staples Index Fund95.86% holdings overlap · United States
XLP · State Street Consumer Staples Select Sector SPDR ETF73.95% holdings overlap · US market
KXI · iShares Global Consumer Staples ETF59.01% holdings overlap · NYSE Arca
IYK · iShares U.S. Consumer Staples ETF58.79% holdings overlap · US market
RSPS · Invesco S&P 500 Equal Weight Consumer Staples ETF50.57% holdings overlap · US market

Sources and limitations

Holdings are sourced from Vanguard and company financial inputs retain primary-source links. Monetary values are normalised to USD. Corporate actions, reporting lags, unmapped securities and cash can create differences from provider figures.

Open official holdings source

Research holdings date: 31 May 2026. Informational research, not investment advice.

about

If your portfolio was one company, what would its P/E and P/S be?

Fund P/E figures published by issuers are often simplified.

One major issuer describes portfolio P/E as the weighted average price/earnings ratio of the stocks it holds.

This approach can exclude loss-making companies, causing the reported P/E to appear lower and the portfolio to look more attractively valued than when all holdings’ signed earnings are combined.

ratio/fox treats each ETF, mutual fund, or portfolio as one large conglomerate made up of its holdings. It combines their market values, signed earnings, and sales before calculating P/E and P/S. Loss-making companies reduce total earnings, while missing inputs reduce the reported coverage rather than being treated as zero.

The result is a consistent look-through valuation of the entire basket, with trailing and latest-quarter run-rate figures shown separately.

Public research pages may be cached for up to five minutes, so a newly published price or filing can take that long to appear.

How much of each company do you really own?

A company may appear in several ETFs and mutual funds while also being held directly. ratio/fox looks through every route, calculates each effective position, and combines matching companies. Instead of separate line items, you see your total exposure to the underlying company.

How much of one fund do you already own through another?

Every ETF and mutual-fund page ranks the 25 most similar funds by shared portfolio weight. Matching companies and explicitly reported same-currency cash count toward overlap; unknown positions do not. See whether a new fund genuinely broadens your portfolio or mainly adds more of the companies you already own.

Which investments appear in public discovery?

Public API lists, browse pages, and sitemaps share the same research-ready universe. ETF and mutual-fund discovery requires an official holdings source and at least one disclosed holding. Stock discovery requires a positive locally supported market capitalisation. Direct detail lookups may still resolve identity-only audit rows; those pages show a clear unavailable state and are marked noindex until usable research data arrives.

Data quality

Registered users

Users unavailable

Registered users with verification state and portfolio counts
email	verification	portfolios	created	updated

User portfolios

Portfolios unavailable

Read-only summaries of registered users' portfolios
owner	portfolio	holdings	value	created	updated

Stocks -

ETFs -

Mutual funds -

Mutual fund share classes

ETF holdings -

Official P/E/P/S inputs -

Public prices -

Accepted market caps -

Rejected market caps -

Unmapped holdings -

Stale holdings sources -

Dead official links -

Core valuation readiness

Core valuation readiness by metric, priority, and coverage
metric	priority	stock coverage	weight	most missing fields

ETF coverage

ETF coverage by holdings, mapping gaps, mapped weight, and P/E/P/S inputs
ETF	holdings	unmapped holdings	unmapped weight	mapped weight	official P/E/P/S inputs

Mutual fund coverage

Mutual fund share-class, holdings, and Core valuation coverage
mutual fund	share classes	holdings	unmapped holdings	unmapped weight	weakest core coverage	largest gap

Open data-quality issues

Open data-quality issues with severity and suggested action
severity	category	target	message	suggested action

ratio/fox calculates each stock’s real P/E and P/S from its latest reported earnings and revenue

stocks

Loading stock list Order results

Page loading

Stocks with P/E and P/S valuation and source details
ticker	company	P/E · trailing	P/E · quarter	P/S · trailing	P/S · quarter	exchange	country	currency	source currency	market cap	provider market cap	price market cap	price market cap status	current price	shares outstanding	earnings	forward earnings	fwd earn low	fwd earn high	fwd earn sources	revenue	forward revenue	fwd rev low	fwd rev high	fwd rev sources	forward P/E	forward P/S	earnings yield	fwd earnings yield	sales yield	fwd sales yield	earnings date	revenue date	price date	shares date	earnings/revenue provider	price provider	market cap source
Loading stock list...

ratio/fox calculates each portfolio's real P/E and P/S as if it was one single company.

portfolios

Account portfolios with value, holdings, and period-aware P/E and P/S metrics
portfolio	value	holdings	look-through	P/E · trailing	P/E · quarter	P/S · trailing	P/S · quarter

ratio/fox calculates each ETF’s real P/E and P/S as if it was one single company.

ETFs

Loading ETF list Order results

Page loading

ETFs with look-through P/E and P/S valuation and source details
ticker	ETF	P/E · trailing	P/E · quarter	P/S · trailing	P/S · quarter	issuer	market	listed on	current price	currency	price in original currency	price date	price provider	listing type	relationship	primary	benchmark	holdings	forward P/E	fwd P/E min	fwd P/E max	forward P/S	fwd P/S min	fwd P/S max	earnings yield	fwd earnings yield	sales yield	fwd sales yield	trailing P/E value gap	fwd P/E value coverage	fwd P/E value gap	trailing P/S value coverage	trailing P/S value gap	fwd P/S value coverage	fwd P/S value gap	coverage notes
Loading ETF list...

ratio/fox calculates each fund's real P/E and P/S as if it was one single company.

mutual funds

Loading mutual fund list Order results

Page loading

Mutual-fund share classes with NAV, holdings dates, and income treatment
mutual fund	ISIN	income	NAV	P/E · trailing	P/E · quarter	P/S · trailing	P/S · quarter	NAV date	holdings date	holdings	issuer
Loading mutual fund list...

ETF valuation

Result unavailable View holdings

Forward P/E -

Forward P/E range -

Forward P/S -

Forward P/S range -

Forward P/E coverage -

Forward P/S coverage -

Holdings

ETF, mutual-fund, or portfolio holdings with units, weights, values, USD inputs, and P/E/P/S
holding	exchange	units	weight	value	current price	market cap	earnings	forward earnings	revenue	forward revenue	P/E · trailing	P/E · quarter	company forward P/E	P/S · trailing	P/S · quarter	company forward P/S	actions

Back to valuation summary

Most similar funds

Shared weight is the sum of the smaller matching position in each fund. Explicit same-currency cash counts; missing or unresolved positions do not.

The 25 ETFs and mutual funds with the greatest shared portfolio weight
identifier	name	listed in	overlap (%)

Look-through stocks

Portfolio ETF, mutual-fund, and stock holdings expanded into underlying stocks with weights, values, USD inputs, and P/E/P/S
holding	exchange	units	weight	value	current price	market cap	earnings	forward earnings	revenue	forward revenue	P/E · trailing	P/E · quarter	company forward P/E	P/S · trailing	P/S · quarter	company forward P/S

Back to valuation summary

Trading listings

One company and one set of fundamentals, available through these exchange instruments.

Exchange instruments for this company
ticker	market	instrument	underlying ratio

ETF and mutual-fund exposure

No funds

ETFs and mutual funds that include this stock, with the stock weight in each fund
fund	weight	holding date

Sources & inputs Loading audit

Source data rows for this stock
property	valuation item	fiscal/source period	value	source currency/unit	USD value	FX metadata	filing/report date	loaded when	source	note

Vanguard Consumer Staples ETF

Core valuation

Largest reported holdings

Most similar funds

Sources and limitations

Open ratio/fox through a web server

about

If your portfolio was one company, what would its P/E and P/S be?

How much of each company do you really own?

How much of one fund do you already own through another?

Which investments appear in public discovery?

Data quality

Registered users

User portfolios

Core valuation readiness

ETF coverage

Mutual fund coverage

Open data-quality issues

stocks

portfolios

Browser portfolios

New portfolio

ETFs

mutual funds

ETF valuation

eight reported quarters

This detail is unavailable

Included portfolios

Holdings

Most similar funds

Look-through stocks

Trading listings

ETF and mutual-fund exposure

Vanguard Consumer Staples ETF

Core valuation

Largest reported holdings

Most similar funds

Sources and limitations

Open ratio/fox through a web server

about

If your portfolio was one company, what would its P/E and P/S be?

How much of each company do you really own?

How much of one fund do you already own through another?

Which investments appear in public discovery?

Data quality

Registered users

User portfolios

Core valuation readiness

ETF coverage

Mutual fund coverage

Open data-quality issues

stocks

portfolios

Portfolio account

Browser portfolios

New portfolio

ETFs

mutual funds

ETF valuation

eight reported quarters

This detail is unavailable

Included portfolios

Holdings

Most similar funds

Look-through stocks

Trading listings

ETF and mutual-fund exposure