Plante Moran Financial Advisors, LLC Q2 2018 Filing

Filed July 26, 2018

Portfolio Value

$197.3M

Holdings

815

Report Date

Q2 2018

Filing Type

13F-HR

All Holdings (815 positions)

#	Stock	Shares	Value	% Portfolio	Type
1	DTEDTE Energy Holding Co	143,390	$14.9M	7.53%
2	IVViShares Core S&P 500	44,418	$12.1M	6.15%
3	SPYSPDR S&P 500 ETF	41,725	$11.3M	5.74%
4	JBLUJetBlue Airways Corp	365,806	$6.9M	3.52%
5	AAPLApple Inc	33,809	$6.3M	3.17%
6	VOOVanguard S&P 500 ETF	24,456	$6.1M	3.09%
7	PEPPepsiCo Inc	55,232	$6.0M	3.05%
8	IWBiShares Russell 1000	35,505	$5.4M	2.74%
9	SYKStryker Corporation	27,314	$4.6M	2.34%
10	MDYSPDR S&P Midcap 400 ETF	8,617	$3.1M	1.55%
11	IJHiShares Core S&P Mid-Cap	15,043	$2.9M	1.49%
12	BRK/BBerkshire Hathaway Inc Class B	14,865	$2.8M	1.41%
13	MSFTMicrosoft Corp	27,914	$2.8M	1.40%
14	VUGVanguard Growth ETF	16,724	$2.5M	1.27%
15	IWMiShares Russell 2000	14,294	$2.3M	1.19%
16	IWFiShares Russell 1000 Growth	13,432	$1.9M	0.98%
17	MCDMcDonald's Corp	12,295	$1.9M	0.98%
18	JNJJohnson & Johnson	15,744	$1.9M	0.97%
19	XPOXPO Logistics Inc	17,839	$1.8M	0.91%
20	VTIVanguard Total Stock Market ET	11,542	$1.6M	0.82%
21	JPMJPMorgan Chase & Co	14,802	$1.5M	0.78%
22	METAFacebook Inc Class A	7,742	$1.5M	0.76%
23	XLFIConsumer Staples Select Sector	28,273	$1.5M	0.74%
24	DONSPDR Dow Jones Industrial Aver	5,983	$1.5M	0.74%
25	SDYSPDR S&P Dividend ETF	14,986	$1.4M	0.70%
26	EFAiShares MSCI EAFE	20,641	$1.4M	0.70%	Put
27	VBKVanguard Small-Cap Growth ETF	7,863	$1.4M	0.70%
28	GOOGAlphabet Inc Class C Capital S	1,179	$1.3M	0.67%
29	PGProcter & Gamble Co	16,266	$1.3M	0.64%
30	BF/BBrown-Forman Corp Class B	25,422	$1.2M	0.63%
31	INTCIntel Corp	24,323	$1.2M	0.61%
32	PRFInvesco FTSE RAFI US 1000 ETF	10,127	$1.1M	0.58%
33	AQLTiShares Select Dividend	11,356	$1.1M	0.56%
34	VVisa Inc Class A	8,036	$1.1M	0.54%
35	GQ9SPDR Gold Shares	8,965	$1.1M	0.54%
36	AMZNAmazon.com Inc	620	$1.1M	0.53%
37	GOOGLAlphabet Inc Com Cl A	925	$1.0M	0.53%
38	ABBVAbbVie Inc	11,206	$1.0M	0.53%
39	VIGVanguard Dividend Appreciation	10,103	$1.0M	0.52%
40	PFEPfizer Inc	28,233	$1.0M	0.52%
41	CVXChevron Corp	7,812	$988K	0.50%
42	HDHome Depot Inc	4,970	$970K	0.49%
43	IWRiShares Russell Mid-Cap	4,485	$952K	0.48%
44	IJRiShares Core S&P Small-Cap	11,348	$947K	0.48%
45	MMM3M Co	4,404	$866K	0.44%
46	MAMasterCard Inc Class A	4,356	$856K	0.43%
47	—PIMCO Dynamic Credit and Mortg	34,995	$825K	0.42%
48	FITBFifth Third Bancorp	27,776	$797K	0.40%
49	NEOGNeogen Corp	9,784	$785K	0.40%
50	CSCOCisco Systems Inc	18,139	$781K	0.40%
51	ADPAutomatic Data Processing	5,759	$773K	0.39%
52	TDToronto-Dominion Bank	13,340	$772K	0.39%
53	DISWalt Disney Co	7,199	$755K	0.38%
54	OEFiShares S&P 100	6,098	$729K	0.37%
55	ETNEaton Corp PLC	9,604	$718K	0.36%
56	BACBank of America Corporation	25,242	$712K	0.36%
57	XOMExxon Mobil Corporation	8,569	$709K	0.36%
58	ABTAbbott Laboratories	11,613	$708K	0.36%
59	VTEBVanguard Tax-Exempt Bond ETF	13,795	$703K	0.36%
60	AONAon PLC	5,072	$696K	0.35%
61	IBMInternational Business Machine	4,757	$665K	0.34%
62	BF/ABrown-Forman Corp Class A	13,404	$655K	0.33%
63	NFLXNetflix Inc	1,655	$648K	0.33%
64	MANManpowerGroup	7,403	$637K	0.32%
65	TAT&T Inc	19,807	$636K	0.32%
66	IWNiShares Russell 2000 Value	4,420	$583K	0.30%
67	VGTVanguard Information Technolog	3,174	$576K	0.29%
68	WMTWal-Mart Stores Inc	6,292	$539K	0.27%
69	TXNTexas Instruments Inc	4,831	$533K	0.27%
70	KELKellogg Co	7,496	$524K	0.27%
71	—SPDR S&P 500 Growth	14,795	$520K	0.26%
72	SPYSPDR S&P 500 ETF	1,800	$488K	0.25%	Put
73	HONHoneywell International Inc	3,370	$485K	0.25%
74	XELXcel Energy Inc	10,407	$475K	0.24%
75	XLEEnergy Select Sector SPDR ETF	6,240	$474K	0.24%
76	IYFiShares US Financials	4,016	$471K	0.24%
77	CMCSAComcast Corp Class A	14,253	$468K	0.24%
78	UNHUnitedhealth Group Inc	1,900	$466K	0.24%
79	IWDiShares Russell 1000 Value	3,693	$448K	0.23%
80	AMGNAmgen Inc	2,366	$437K	0.22%
81	DUKDuke Energy Corporation	5,324	$421K	0.21%
82	YUMYum Brands Inc	5,358	$419K	0.21%
83	SHWSherwin-Williams Co	1,018	$415K	0.21%
84	VEAVanguard FTSE Developed Market	9,640	$414K	0.21%
85	IWOiShares Russell 2000 Growth	2,012	$411K	0.21%
86	KOCoca-Cola Co	9,309	$408K	0.21%
87	ACNAccenture PLC Class A	2,476	$405K	0.21%
88	COSTCostco Wholesale Corp	1,892	$395K	0.20%
89	MLMMartin Marietta Materials Inc	1,765	$394K	0.20%
90	BRBroadridge Financial Solutions	3,341	$385K	0.20%
91	MRKMerck & Co Inc	6,338	$385K	0.20%
92	CVSCVS Health Corp	5,655	$364K	0.18%
93	MBWMMercantile Bank Corp	9,648	$357K	0.18%
94	BACVerizon Communications Inc	6,973	$351K	0.18%
95	PKGPackaging Corp of America	3,127	$350K	0.18%
96	PFFiShares US Preferred Stock	9,245	$349K	0.18%
97	TIPiShares TIPS Bond	3,073	$347K	0.18%
98	DEODiageo PLC ADR	2,361	$340K	0.17%
99	YUMCYum China Holdings Inc	8,639	$332K	0.17%
100	XLKTechnology Select Sector SPDR	4,783	$332K	0.17%

Page 1 of 9Next