Plante Moran Financial Advisors, LLC Q2 2017 Filing
Filed July 25, 2017
Portfolio Value
$159.9B
Holdings
847
Report Date
Q2 2017
Filing Type
13F-HR
All Holdings (847 positions)
| # | Stock | Shares | Value | % Portfolio | Type |
|---|---|---|---|---|---|
| 1 | DTEDTE Energy Holding Co | 138,358 | $14.6B | 9.15% | |
| 2 | SPYSPDR S&P 500 ETF | 40,409 | $9.8B | 6.11% | |
| 3 | PEPPepsiCo Inc | 49,815 | $5.8B | 3.60% | |
| 4 | AAPLApple Inc | 35,696 | $5.1B | 3.21% | |
| 5 | IVViShares Core S&P 500 | 20,808 | $5.1B | 3.17% | |
| 6 | VOOVanguard S&P 500 ETF | 19,865 | $4.4B | 2.76% | |
| 7 | SYKStryker Corporation | 28,018 | $3.9B | 2.43% | |
| 8 | PRAProAssurance Corp | 47,980 | $2.9B | 1.82% | |
| 9 | MDYSPDR S&P Midcap 400 ETF | 8,828 | $2.8B | 1.75% | |
| 10 | VUGVanguard Growth ETF | 18,760 | $2.4B | 1.49% | |
| 11 | IJHiShares Core S&P Mid-Cap | 13,140 | $2.3B | 1.43% | |
| 12 | IWBiShares Russell 1000 | 16,675 | $2.3B | 1.41% | |
| 13 | JNJJohnson & Johnson | 16,932 | $2.2B | 1.40% | |
| 14 | BRK/BBerkshire Hathaway Inc Class B | 12,805 | $2.2B | 1.36% | |
| 15 | ETNEaton Corp PLC | 25,394 | $2.0B | 1.24% | |
| 16 | INTCIntel Corp | 52,316 | $1.8B | 1.10% | |
| 17 | MSFTMicrosoft Corp | 23,458 | $1.6B | 1.01% | |
| 18 | SDYSPDR S&P Dividend ETF | 18,119 | $1.6B | 1.01% | |
| 19 | IWFiShares Russell 1000 Growth | 12,720 | $1.5B | 0.95% | |
| 20 | DONSPDR Dow Jones Industrial Aver | 6,943 | $1.5B | 0.93% | |
| 21 | VBKVanguard Small-Cap Growth ETF | 9,875 | $1.4B | 0.90% | |
| 22 | VTIVanguard Total Stock Market ET | 11,348 | $1.4B | 0.88% | |
| 23 | PGProcter & Gamble Co | 16,086 | $1.4B | 0.88% | |
| 24 | GOOGLAlphabet Inc Com Cl A | 1,428 | $1.3B | 0.83% | |
| 25 | GEGeneral Electric Co | 47,723 | $1.3B | 0.81% | |
| 26 | IWMiShares Russell 2000 | 8,792 | $1.2B | 0.77% | |
| 27 | —PowerShares FTSE RAFI US 1000 | 10,413 | $1.1B | 0.67% | |
| 28 | XPOXPO Logistics Inc | 16,614 | $1.1B | 0.67% | |
| 29 | GOOGAlphabet Inc Class C Capital S | 1,173 | $1.1B | 0.67% | |
| 30 | TAT&T Inc | 27,963 | $1.1B | 0.66% | |
| 31 | AQLTiShares Select Dividend | 11,303 | $1.0B | 0.65% | |
| 32 | JPMJPMorgan Chase & Co | 11,130 | $1.0B | 0.64% | |
| 33 | BNDVanguard Total Bond Market ETF | 12,287 | $1.0B | 0.63% | |
| 34 | MMM3M Co | 4,683 | $975.0M | 0.61% | |
| 35 | PFEPfizer Inc | 28,790 | $967.0M | 0.60% | |
| 36 | BACVerizon Communications Inc | 21,622 | $966.0M | 0.60% | |
| 37 | GQ9SPDR Gold Shares | 8,151 | $962.0M | 0.60% | |
| 38 | VIGVanguard Dividend Appreciation | 9,871 | $915.0M | 0.57% | |
| 39 | BF/BBrown-Forman Corp Class B | 18,658 | $907.0M | 0.57% | |
| 40 | DISWalt Disney Co | 8,260 | $878.0M | 0.55% | |
| 41 | IWRiShares Russell Mid-Cap | 4,458 | $856.0M | 0.54% | |
| 42 | CVXChevron Corp | 8,204 | $856.0M | 0.54% | |
| 43 | IBMInternational Business Machine | 5,203 | $800.0M | 0.50% | |
| 44 | ABBVAbbVie Inc | 10,967 | $795.0M | 0.50% | |
| 45 | CATCaterpillar Inc | 7,252 | $779.0M | 0.49% | |
| 46 | MGAMagna International Inc Class | 16,758 | $776.0M | 0.49% | |
| 47 | TDToronto-Dominion Bank | 15,319 | $772.0M | 0.48% | |
| 48 | METAFacebook Inc Class A | 5,080 | $767.0M | 0.48% | |
| 49 | HDHome Depot Inc | 4,760 | $730.0M | 0.46% | |
| 50 | WFCWells Fargo & Co | 13,096 | $726.0M | 0.45% | |
| 51 | VVisa Inc Class A | 7,673 | $720.0M | 0.45% | |
| 52 | XOMExxon Mobil Corporation | 8,726 | $704.0M | 0.44% | |
| 53 | FITBFifth Third Bancorp | 26,023 | $676.0M | 0.42% | |
| 54 | OEFiShares S&P 100 | 6,309 | $674.0M | 0.42% | |
| 55 | BF/ABrown-Forman Corp Class A | 13,494 | $665.0M | 0.42% | |
| 56 | KOCoca-Cola Co | 14,665 | $658.0M | 0.41% | |
| 57 | MCDMcDonald's Corp | 4,237 | $649.0M | 0.41% | |
| 58 | ADPAutomatic Data Processing | 6,261 | $641.0M | 0.40% | |
| 59 | XLEEnergy Select Sector SPDR ETF | 9,364 | $608.0M | 0.38% | |
| 60 | CMCSAComcast Corp Class A | 15,203 | $592.0M | 0.37% | |
| 61 | ABTAbbott Laboratories | 12,019 | $584.0M | 0.37% | |
| 62 | EFAiShares MSCI EAFE | 8,544 | $557.0M | 0.35% | |
| 63 | CSCOCisco Systems Inc | 17,659 | $553.0M | 0.35% | |
| 64 | 4I1Philip Morris International In | 4,571 | $537.0M | 0.34% | |
| 65 | HONHoneywell International Inc | 3,991 | $532.0M | 0.33% | |
| 66 | KELKellogg Co | 7,617 | $529.0M | 0.33% | |
| 67 | IWNiShares Russell 2000 Value | 4,420 | $525.0M | 0.33% | |
| 68 | —Monsanto Co | 4,371 | $517.0M | 0.32% | |
| 69 | NEOGNeogen Corp | 7,339 | $507.0M | 0.32% | |
| 70 | CVSCVS Health Corp | 5,987 | $482.0M | 0.30% | |
| 71 | MRKMerck & Co Inc | 7,278 | $466.0M | 0.29% | |
| 72 | —SPDR S&P 500 Growth | 3,736 | $442.0M | 0.28% | |
| 73 | AONAon PLC | 3,305 | $439.0M | 0.27% | |
| 74 | MLMMartin Marietta Materials Inc | 1,970 | $438.0M | 0.27% | |
| 75 | WMTWal-Mart Stores Inc | 5,407 | $409.0M | 0.26% | |
| 76 | TXNTexas Instruments Inc | 5,242 | $403.0M | 0.25% | |
| 77 | MOAltria Group Inc | 5,374 | $400.0M | 0.25% | |
| 78 | CMGChipotle Mexican Grill Inc Cla | 942 | $392.0M | 0.25% | |
| 79 | AMZNAmazon.com Inc | 397 | $384.0M | 0.24% | |
| 80 | PFFiShares US Preferred Stock | 9,697 | $380.0M | 0.24% | |
| 81 | CLColgate-Palmolive Co | 5,016 | $372.0M | 0.23% | |
| 82 | MAMasterCard Inc Class A | 3,000 | $364.0M | 0.23% | |
| 83 | MDLZMondelez International Inc Cla | 8,099 | $350.0M | 0.22% | |
| 84 | S9QSpirit AeroSystems Holdings In | 5,966 | $346.0M | 0.22% | |
| 85 | IWOiShares Russell 2000 Growth | 2,037 | $344.0M | 0.22% | |
| 86 | IWDiShares Russell 1000 Value | 2,884 | $336.0M | 0.21% | |
| 87 | CLXClorox Co | 2,486 | $331.0M | 0.21% | |
| 88 | GGBGerdau S A ADR | 107,823 | $329.0M | 0.21% | |
| 89 | MBWMMercantile Bank Corp | 10,438 | $329.0M | 0.21% | |
| 90 | ORCLOracle Corporation | 6,508 | $326.0M | 0.20% | |
| 91 | IJRiShares Core S&P Small-Cap | 4,648 | $326.0M | 0.20% | |
| 92 | VTEBVanguard Tax-Exempt Bond ETF | 6,297 | $323.0M | 0.20% | |
| 93 | XLKTechnology Select Sector SPDR | 5,570 | $305.0M | 0.19% | |
| 94 | COSTCostco Wholesale Corp | 1,873 | $299.0M | 0.19% | |
| 95 | UTXZUnited Technologies Corp | 2,448 | $299.0M | 0.19% | |
| 96 | KMBKimberly-Clark Corp | 2,217 | $286.0M | 0.18% | |
| 97 | MANManpowerGroup | 2,524 | $282.0M | 0.18% | |
| 98 | KHCThe Kraft Heinz Co | 3,217 | $276.0M | 0.17% | |
| 99 | BACBank of America Corporation | 11,321 | $275.0M | 0.17% | |
| 100 | SBUXStarbucks Corp | 4,700 | $274.0M | 0.17% |
Page 1 of 9Next