Tandem Wealth Advisors LLC Diversified Active

Location: Phoenix, AZ

CIK: 0001842557 · Show all filings

Period: Q1 2023 (← Previous) (Next →)

Filing Date: Jul 7, 2023

Total Value: $161M (100.0% shares, 0.0% debt)

Holdings (46)

AGG ISHARES AGGREGATE BOND ETF 19.3%

Value $31.06M Shares 311,707 Est. Cost $96.99 Unrealized —

EFA ISHARES MSCI EAFE ETF 10.9%

Value $17.47M Shares 244,335 Est. Cost $65.64 Unrealized —

MDY S & P MID CAP 400 DEP RCPTS MID CAP 9.1%

Value $14.59M Shares 31,831 Est. Cost $445.88 Unrealized —

VCSH VANGUARD SHORT-TERM CORPORATE BOND ETF 7.9%

Value $12.62M Shares 165,527 Est. Cost $75.19 Unrealized —

MBB ISHARES MBS ETF 7.5%

Value $11.99M Shares 126,587 Est. Cost $92.75 Unrealized —

VYM VANGUARD HIGH DIVIDEND YIELD INDEX ETF 5.7%

Value $9.129M Shares 86,528 Est. Cost $108.21 Unrealized —

SPY SPDR S&P 500 ETF 5.6%

Value $8.953M Shares 21,869 Est. Cost $383.30 Unrealized —

QQQ POWERSHARES QQQ TR 5.4%

Value $8.613M Shares 26,838 Est. Cost $266.28 Unrealized —

IJR ISHARES S&P SMALLCAP 600 ETF 4.2%

Value $6.727M Shares 69,566 Est. Cost $95.76 Unrealized —

RSP GUGGENHEIM ETF TRUST S&P 500 EQUAL WEIGHT 4.1%

Value $6.52M Shares 45,086 Est. Cost $144.04 Unrealized —

VGT VANGUARD INFORMATION TECHNOLOGY 3.9%

Value $6.302M Shares 16,349 Est. Cost $319.41 Unrealized —

EEM ISHARES MSCI EMERGING MARKETS ETF 3.2%

Value $5.157M Shares 130,694 Est. Cost $37.90 Unrealized —

VTI VANGUARD TOTAL STK MKT 2.5%

Value $4.036M Shares 19,775 Est. Cost $191.19 Unrealized —

XLV HEALTH CARE SELECT SECTOR SPDR 2.5%

Value $3.99M Shares 30,818 Est. Cost $135.85 Unrealized —

BND VANGUARD TOTAL BOND MARKET ETF 1.4%

Value $2.271M Shares 30,765 Est. Cost $71.89 Unrealized —

AAPL APPLE INC 0.5%

Value $812K Shares 4,923 Est. Cost $140.70 Unrealized +3.4%

MSFT MICROSOFT 0.5%

Value $752K Shares 2,609 Est. Cost $234.05 Unrealized +6.6%

XLE ENERGY SELECT SECTOR SPDR 0.4%

Value $713K Shares 8,608 Est. Cost $87.47 Unrealized —

GOOGL ALPHABET INC CAP STK CL A 0.3%

Value $556K Shares 5,357 Est. Cost $94.32 Unrealized +1.0%

JNJ JOHNSON & JOHNSON COM 0.3%

Value $553K Shares 3,568 Est. Cost $157.06 Unrealized -5.8%

AVGO BROADCOM INC COM 0.3%

Value $463K Shares 721 Est. Cost $47.61 Unrealized +21.0%

COST COSTCO WHSL CORP NEW COM 0.3%

Value $434K Shares 874 Est. Cost $468.77 Unrealized +0.5%

TMO THERMO FISHER SCIENTIFIC INC COM 0.3%

Value $425K Shares 737 Est. Cost $524.96 Unrealized +6.4%

NVDA NVIDIA CORPORATION COM 0.3%

Value $408K Shares 1,470 Est. Cost $14.65 Unrealized +47.6%

LLY LILLY ELI & CO COM 0.3%

Value $407K Shares 1,185 Est. Cost $345.79 Unrealized -4.6%

CSCO CISCO SYS INC COM 0.2%

Value $398K Shares 7,619 Est. Cost $41.47 Unrealized +8.2%

PG PROCTER AND GAMBLE CO COM 0.2%

Value $372K Shares 2,503 Est. Cost $129.79 Unrealized +2.6%

VPU VANGUARD UTILITIES 0.2%

Value $356K Shares 2,411 Est. Cost $153.36 Unrealized —

UNH UNITEDHEALTH GROUP INC COM 0.2%

Value $338K Shares 715 Est. Cost $500.41 Unrealized -8.6%

LIN LINDE PLC SHS 0.2%

Value $335K Shares 942 Est. Cost $322.30 Unrealized 0.0%

V VISA INC 0.2%

Value $325K Shares 1,443 Est. Cost $196.98 Unrealized +10.6%

HON HONEYWELL INTL INC COM 0.2%

Value $323K Shares 1,688 Est. Cost $178.76 Unrealized -1.2%

NEE NEXTERA ENERGY INC COM 0.2%

Value $292K Shares 3,782 Est. Cost $73.82 Unrealized -4.3%

ICE INTERCONTINENTAL EXCHANGE INC COM 0.2%

Value $264K Shares 2,532 Est. Cost $95.52 Unrealized +5.0%

DE DEERE & CO COM 0.2%

Value $261K Shares 633 Est. Cost $388.70 Unrealized +2.2%

EMR EMERSON ELEC CO COM 0.2%

Value $255K Shares 2,921 Est. Cost $84.53 Unrealized -2.3%

HSY HERSHEY CO COM 0.2%

Value $249K Shares 978 Est. Cost $212.11 Unrealized +2.4%

CB CHUBB LIMITED COM 0.1%

Value $239K Shares 1,229 Est. Cost $199.93 Unrealized +1.4%

AMZN AMAZON.COM INC 0.1%

Value $238K Shares 2,300 Est. Cost $98.78 Unrealized -2.2%

ABT ABBOTT LABS COM 0.1%

Value $221K Shares 2,185 Est. Cost $97.62 Unrealized +2.4%

AMT AMERICAN TOWER CORP NEW COM 0.1%

Value $219K Shares 1,070 Est. Cost $189.59 Unrealized 0.0%

TJX TJX COS INC NEW COM 0.1%

Value $216K Shares 2,759 Est. Cost $70.72 Unrealized +7.0%

CAT CATERPILLAR INC COM 0.1%

Value $210K Shares 917 Est. Cost $206.59 Unrealized +11.6%

KLAC KLA CORP COM NEW 0.1%

Value $208K Shares 521 Est. Cost $383.34 Unrealized 0.0%

BX BLACKSTONE INC COM 0.1%

Value $206K Shares 2,344 Est. Cost $78.64 Unrealized +3.2%

JPM JPMORGAN CHASE & CO 0.1%

Value $205K Shares 1,575 Est. Cost $117.65 Unrealized +8.9%

Ticker	Issuer	Shares	Value	%	Est. Cost	Unrealized	Class	CUSIP
AGG	ISHARES AGGREGATE BOND ETF	311,707	$31.06M	19.3%	$96.99	—	ETF	464287226
EFA	ISHARES MSCI EAFE ETF	244,335	$17.47M	10.9%	$65.64	—	ETF	464287465
MDY	S & P MID CAP 400 DEP RCPTS MID CAP	31,831	$14.59M	9.1%	$445.88	—	ETF	78467Y107
VCSH	VANGUARD SHORT-TERM CORPORATE BOND ETF	165,527	$12.62M	7.9%	$75.19	—	ETF	92206C409
MBB	ISHARES MBS ETF	126,587	$11.99M	7.5%	$92.75	—	ETF	464288588
VYM	VANGUARD HIGH DIVIDEND YIELD INDEX ETF	86,528	$9.129M	5.7%	$108.21	—	ETF	921946406
SPY	SPDR S&P 500 ETF	21,869	$8.953M	5.6%	$383.30	—	ETF	78462F103
QQQ	POWERSHARES QQQ TR	26,838	$8.613M	5.4%	$266.28	—	ETF	46090E103
IJR	ISHARES S&P SMALLCAP 600 ETF	69,566	$6.727M	4.2%	$95.76	—	ETF	464287804
RSP	GUGGENHEIM ETF TRUST S&P 500 EQUAL WEIGHT	45,086	$6.52M	4.1%	$144.04	—	ETF	46137V357
VGT	VANGUARD INFORMATION TECHNOLOGY	16,349	$6.302M	3.9%	$319.41	—	ETF	92204A702
EEM	ISHARES MSCI EMERGING MARKETS ETF	130,694	$5.157M	3.2%	$37.90	—	ETF	464287234
VTI	VANGUARD TOTAL STK MKT	19,775	$4.036M	2.5%	$191.19	—	ETF	922908769
XLV	HEALTH CARE SELECT SECTOR SPDR	30,818	$3.99M	2.5%	$135.85	—	ETF	81369Y209
BND	VANGUARD TOTAL BOND MARKET ETF	30,765	$2.271M	1.4%	$71.89	—	ETF	921937835
AAPL	APPLE INC	4,923	$812K	0.5%	$140.70	+3.4%	Stock	037833100
MSFT	MICROSOFT	2,609	$752K	0.5%	$234.05	+6.6%	Stock	594918104
XLE	ENERGY SELECT SECTOR SPDR	8,608	$713K	0.4%	$87.47	—	ETF	81369Y506
GOOGL	ALPHABET INC CAP STK CL A	5,357	$556K	0.3%	$94.32	+1.0%	Stock	02079K305
JNJ	JOHNSON & JOHNSON COM	3,568	$553K	0.3%	$157.06	-5.8%	Stock	478160104
AVGO	BROADCOM INC COM	721	$463K	0.3%	$47.61	+21.0%	Stock	11135F101
COST	COSTCO WHSL CORP NEW COM	874	$434K	0.3%	$468.77	+0.5%	Stock	22160K105
TMO	THERMO FISHER SCIENTIFIC INC COM	737	$425K	0.3%	$524.96	+6.4%	Stock	883556102
NVDA	NVIDIA CORPORATION COM	1,470	$408K	0.3%	$14.65	+47.6%	Stock	67066G104
LLY	LILLY ELI & CO COM	1,185	$407K	0.3%	$345.79	-4.6%	Stock	532457108
CSCO	CISCO SYS INC COM	7,619	$398K	0.2%	$41.47	+8.2%	Stock	17275R102
PG	PROCTER AND GAMBLE CO COM	2,503	$372K	0.2%	$129.79	+2.6%	Stock	742718109
VPU	VANGUARD UTILITIES	2,411	$356K	0.2%	$153.36	—	ETF	92204A876
UNH	UNITEDHEALTH GROUP INC COM	715	$338K	0.2%	$500.41	-8.6%	Stock	91324P102
LIN	LINDE PLC SHS	942	$335K	0.2%	$322.30	0.0%	Stock	G54950103
V	VISA INC	1,443	$325K	0.2%	$196.98	+10.6%	Stock	92826C839
HON	HONEYWELL INTL INC COM	1,688	$323K	0.2%	$178.76	-1.2%	Stock	438516106
NEE	NEXTERA ENERGY INC COM	3,782	$292K	0.2%	$73.82	-4.3%	Stock	65339F101
ICE	INTERCONTINENTAL EXCHANGE INC COM	2,532	$264K	0.2%	$95.52	+5.0%	Stock	45866F104
DE	DEERE & CO COM	633	$261K	0.2%	$388.70	+2.2%	Stock	244199105
EMR	EMERSON ELEC CO COM	2,921	$255K	0.2%	$84.53	-2.3%	Stock	291011104
HSY	HERSHEY CO COM	978	$249K	0.2%	$212.11	+2.4%	Stock	427866108
CB	CHUBB LIMITED COM	1,229	$239K	0.1%	$199.93	+1.4%	Stock	H1467J104
AMZN	AMAZON.COM INC	2,300	$238K	0.1%	$98.78	-2.2%	Stock	023135106
ABT	ABBOTT LABS COM	2,185	$221K	0.1%	$97.62	+2.4%	Stock	002824100
AMT	AMERICAN TOWER CORP NEW COM	1,070	$219K	0.1%	$189.59	0.0%	REIT	03027X100
TJX	TJX COS INC NEW COM	2,759	$216K	0.1%	$70.72	+7.0%	Stock	872540109
CAT	CATERPILLAR INC COM	917	$210K	0.1%	$206.59	+11.6%	Stock	149123101
KLAC	KLA CORP COM NEW	521	$208K	0.1%	$383.34	0.0%	Stock	482480100
BX	BLACKSTONE INC COM	2,344	$206K	0.1%	$78.64	+3.2%	Stock	09260D107
JPM	JPMORGAN CHASE & CO	1,575	$205K	0.1%	$117.65	+8.9%	Stock	46625H100