Skip to content

13F-HR filed by CHOREO, LLC

CHOREO, LLC filed this 13F-HR for the quarter ended 2017-06-30, filed 2020-06-04, with 259 holding rows worth $709,667,000.

Accession
0001214659-20-005402
Filed
2020-06-04
Accepted by EDGAR
acceptance time not in the bulk data set
Ingested
Source
SEC quarterly data set

Original filing

13F report for Q2 2017

A holdings report, 259 entries on the cover page, a total value of $709,667,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $709,667,000 with VALUE read as thousands by filing date, 13F file number 028-20277. The quarter's positions are built on this report. The resolved quarter.

The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).

Issuer as filedCUSIPClassAmountValueValue read asType
ISHARESRUSSELL1000GROWTHETF464287614STOK496,991$59,152,000thousands by filing date
Vanguard Growth922908736COM364,632$46,323,000thousands by filing date
ISHARES RUSSELL 1000 VALUE ETF464287598ETF370,625$43,152,000thousands by filing date
ISHARES RUSSELL 1000 ETF464287622ETF232,216$31,412,000thousands by filing date
SPY78462F103SHS120,569$29,296,000thousands by filing date
Vanguard Real Estate922908553SHS302,500$25,177,000thousands by filing date
VWO922042858SHS565,380$23,084,000thousands by filing date
Vanguard FTSE Developed Markets ETF921943858SHS470,981$19,461,000thousands by filing date
Vanguard Small-Cap Growth ETF922908595SHS131,250$19,127,000thousands by filing date
iShares Russell 2000 ETF464287655SHS133,392$18,798,000thousands by filing date
ISHARES TR464287648RUS 2000 GRW ETF101,643$17,154,000thousands by filing date
Vanguard Value ETF922908744SHS170,496$16,463,000thousands by filing date
ISHARES MSCI EAFE SMALL-CAP ETF464288273ETF277,936$16,076,000thousands by filing date
ISHARES TR464287630RUS 2000 VAL ETF129,371$15,378,000thousands by filing date
iShares S&P 500 Growth ETF464287309SHS106,808$14,617,000thousands by filing date
ISHARES TR CORE S&P 500 ETF464287200SHS55,929$13,615,000thousands by filing date
FIRST TR EXCHANGE-TRADED FD33738D101NO AMER ENERGY507,027$12,448,000thousands by filing date
ISHARES TR464287465MSCI EAFE ETF168,569$10,991,000thousands by filing date
Apple Inc037833100COM59,901$8,627,000thousands by filing date
ISHARES RUSSELL MID-CAP GROWTH ETF464287481ETF72,906$7,879,000thousands by filing date
VTI922908769COM58,800$7,318,000thousands by filing date
Vanguard Dividend Appreciation ETF921908844SHS78,158$7,243,000thousands by filing date
Vanguard S&P 500 ETF922908363COM32,057$7,119,000thousands by filing date
Vanguard Small-Cap Value ETF922908611SHS56,448$6,961,000thousands by filing date
SEI INVTS CO COM784117103Stock125,791$6,765,000thousands by filing date
VGT92204A702SHS40,441$5,712,000thousands by filing date
VANGUARD INTL EQUITY INDEX F922042676COM95,215$5,382,000thousands by filing date
ALPS ETF TR00162Q205EQUAL SEC ETF79,777$5,113,000thousands by filing date
VANGUARD WORLD FD92204A603INDUSTRIAL ETF39,413$5,082,000thousands by filing date
VANGUARD WORLD FD92204A405FINANCIALS ETF76,505$4,806,000thousands by filing date
Philip Morris International Inc.718172109COM39,500$4,681,000thousands by filing date
Microsoft Corp594918104COM63,584$4,383,000thousands by filing date
Vanguard Small-Cap ETF922908751SHS31,569$4,279,000thousands by filing date
Altria Group Inc02209S103COM55,957$4,202,000thousands by filing date
FIRST TR EXCHANGE-TRADED FD336917109SHS138,280$3,890,000thousands by filing date
EXXON MOBIL CORP30231G102COM47,291$3,818,000thousands by filing date
Merck & Co.,Inc.58933Y105COM57,783$3,730,000thousands by filing date
DBX ETF TR233051853XTRACK MSCI EURP134,132$3,673,000thousands by filing date
USBANCORPDEL902973304COM NEW69,403$3,623,000thousands by filing date
VANGUARD INDEX FDS922908637LARGE CAP ETF31,873$3,539,000thousands by filing date
SCHWAB STRATEGIC TR808524805INTL EQTY ETF104,813$3,331,000thousands by filing date
Berkshire Hathaway Inc084670702COM19,146$3,243,000thousands by filing date
BERKSHIRE HATHAWAY INC DEL084670108CL A11$2,802,000thousands by filing date
Johnson & Johnson478160104COM20,378$2,696,000thousands by filing date
ISHARES RUSSELL MID-CAP VALUE ETF464287473ETF31,690$2,665,000thousands by filing date
JPMorgan Chase & Co46625H100COM28,584$2,613,000thousands by filing date
iShares Russell Midcap ETF464287499SHS13,382$2,571,000thousands by filing date
International Business Machines Corporation459200101COM15,803$2,431,000thousands by filing date
Wells Fargo & Company949746101COM42,070$2,331,000thousands by filing date
Duke Energy Corporation26441C204COM27,823$2,326,000thousands by filing date
META PLATFORMS INC CL A30303M102COM15,144$2,286,000thousands by filing date
SCHWAB STRATEGIC TR808524888INTL SCEQT ETF64,325$2,163,000thousands by filing date
Boeing Company097023105COM10,889$2,153,000thousands by filing date
McDonalds Corporation580135101COM14,053$2,152,000thousands by filing date
AT&T Inc00206R102COM54,697$2,064,000thousands by filing date
IJH464287507COM10,924$1,900,000thousands by filing date
Procter & Gamble Co742718109COM21,656$1,887,000thousands by filing date
iShares Core S&P Small-Cap ETF464287804SHS26,617$1,866,000thousands by filing date
Comcast Corp20030N101COM47,601$1,860,000thousands by filing date
KONA GRILL INC50047H201COM493,788$1,827,000thousands by filing date
GENERAL ELEC CO369604103COM66,959$1,825,000thousands by filing date
Chevron Corporation166764100COM16,354$1,706,000thousands by filing date
Alphabet Inc. Reg. Shares C02079K107COM1,871$1,700,000thousands by filing date
Pfizer Inc.717081103COM49,513$1,663,000thousands by filing date
FISERV INC337738108COM13,548$1,657,000thousands by filing date
Intel Corp458140100COM47,748$1,611,000thousands by filing date
Bank of America Corp060505104COM59,877$1,453,000thousands by filing date
PepsiCo,Inc.713448108COM12,498$1,443,000thousands by filing date
ISHARES TR464287168COM15,609$1,440,000thousands by filing date
CSX Corporation126408103COM26,371$1,439,000thousands by filing date
ALLIANT ENERGY CORP COM018802108Stock35,617$1,431,000thousands by filing date
Verizon Communications Inc92343V104COM31,494$1,407,000thousands by filing date
Walt Disney Co254687106COM12,975$1,379,000thousands by filing date
ALPS ETF TR00162Q866ALERIAN MLP110,019$1,316,000thousands by filing date
CORE LABORATORIES N VN22717107COM12,952$1,312,000thousands by filing date
Amazon.com, Inc023135106COM1,351$1,308,000thousands by filing date
AbbVie,Inc.00287Y109COM17,356$1,259,000thousands by filing date
Bristol-Myers Squibb Company110122108COM22,556$1,257,000thousands by filing date
GENERAL DYNAMICS CORP COM369550108Stock6,195$1,227,000thousands by filing date
Coca-Cola Company191216100COM26,360$1,193,000thousands by filing date
ISHARES TR464288505MRGSTR SM CP ETF7,205$1,164,000thousands by filing date
Home Depot, Inc437076102COM7,534$1,156,000thousands by filing date
Alphabet Inc. Reg. Shares A02079K305COM1,237$1,150,000thousands by filing date
SPDR S&P Dividend ETF78464A763SHS12,698$1,129,000thousands by filing date
SPDR S&P Midcap 400 ETF Trust78467Y107SHS3,529$1,123,000thousands by filing date
iShares S&P 500 Value ETF464287408SHS10,487$1,101,000thousands by filing date
Starbucks Corporation855244109COM18,619$1,086,000thousands by filing date
Cisco Systems,Inc.17275R102COM34,139$1,069,000thousands by filing date
HMN FINL INC40424G108COM60,429$1,061,000thousands by filing date
UBS Alerian MLP/ MLPI902641646TR UNIT38,559$1,028,000thousands by filing date
POLYONE CORP73179P106COM25,126$977,000thousands by filing date
NORFOLK SOUTHN CORP COM655844108Stock7,754$944,000thousands by filing date
UnitedHealth Group Inc91324P102COM4,992$926,000thousands by filing date
MARATHON PETE CORP COM56585A102Stock17,201$900,000thousands by filing date
Automatic Data Processing,Inc.053015103COM8,566$882,000thousands by filing date
KRAFT HEINZ CO COM500754106Stock10,022$858,000thousands by filing date
Vanguard Mid-Cap Value ETF922908512SHS8,192$843,000thousands by filing date
ConocoPhillips20825C104COM18,597$818,000thousands by filing date
PNC FINL SVCS GROUP INC COM693475105Stock6,406$800,000thousands by filing date
Visa Inc92826C839COM8,492$796,000thousands by filing date
iShares Core MSCI Emerging Markets ETF46434G103SHS15,821$792,000thousands by filing date
Vanguard High Dividend Yield ETF921946406SHS9,887$773,000thousands by filing date
KIMBERLY-CLARK CORP COM494368103Stock5,881$765,000thousands by filing date
BP PLC SPONSORED ADR055622104ADR21,613$749,000thousands by filing date
iShares TIPS Bond ETF464287176SHS6,522$740,000thousands by filing date
Vanguard Total Bond Market ETF921937835SHS8,886$727,000thousands by filing date
VANGUARD WHITEHALL FDS921946885COM8,944$716,000thousands by filing date
WALGREENS BOOTS ALLIANCE INC931427108COM9,055$709,000thousands by filing date
Deere & Company244199105COM5,686$706,000thousands by filing date
Eli Lilly and Company532457108COM8,471$697,000thousands by filing date
Vanguard Total World Stock ETF922042742SHS10,188$693,000thousands by filing date
Vanguard Total International Bond Index Fund ETF92203J407SHS12,675$689,000thousands by filing date
Walmart Inc.931142103COM9,060$686,000thousands by filing date
VANGUARD SCOTTSDALE FDS92206C409COM8,553$685,000thousands by filing date
CVS Health Corporation126650100COM8,420$678,000thousands by filing date
iShares MSCI Japan ETF46434G822SHS12,636$678,000thousands by filing date
Union Pacific Corporation907818108COM6,169$672,000thousands by filing date
Oracle Corporation68389X105COM13,046$654,000thousands by filing date
NextEra Energy,Inc.65339F101COM4,596$644,000thousands by filing date
UNITED FIRE GROUP INC910340108COMMON STOCK14,500$639,000thousands by filing date
Vanguard Mid-Cap ETF922908629SHS4,420$630,000thousands by filing date
Costco Wholesale Corporation22160K105COM3,916$626,000thousands by filing date
JP MORGAN CHASE & CO46625H365EXCHANGE TRADED20,722$615,000thousands by filing date
Netflix, Inc64110L106COM3,999$597,000thousands by filing date
Tesla Motors, Inc88160R101COM1,648$596,000thousands by filing date
RAYTHEON CO755111507COM NEW3,673$596,000thousands by filing date
Abbott Laboratories002824100COM12,164$591,000thousands by filing date
Vanguard Consumer Staples ETF92204A207SHS4,159$591,000thousands by filing date
ALKERMES PLCG01767105SHS10,160$589,000thousands by filing date
ILLUMINA INC452327109COM3,312$575,000thousands by filing date
MAGNA INTL INC COM559222401Stock12,268$568,000thousands by filing date
CONSTELLATION BRANDS INC CL A21036P108Stock2,825$547,000thousands by filing date
ILLINOIS TOOL WKS INC452308109COM3,773$543,000thousands by filing date
CUMMINS INC COM231021106Stock3,322$539,000thousands by filing date
United Parcel Service,Inc. Class B911312106COM4,861$538,000thousands by filing date
SELECT SECTOR SPDR TR81369Y407SBI CONS DISCR5,996$537,000thousands by filing date
EMERSON ELEC CO COM291011104Stock8,822$526,000thousands by filing date
Lockheed Martin Corporation539830109COM1,884$523,000thousands by filing date
PROSHARES TR74348A467S&P 500 DV ARIST9,030$522,000thousands by filing date
ISHARES TR464287234MSCI EMG MKT ETF12,436$515,000thousands by filing date
ENTERPRISE PRODS PARTNERS L293792107COM19,026$515,000thousands by filing date
PHILLIPS 66 COM718546104Stock6,106$505,000thousands by filing date
PRINCIPAL FINANCIAL GROUP INC COM74251V102Stock7,801$500,000thousands by filing date
Citigroup Inc.172967424COM7,316$489,000thousands by filing date
GENERAL MILLS INC COM370334104Stock8,782$487,000thousands by filing date
ASMLHLDGNVFSPONSOREDADR1ADRREPS1ORDSHSN07059210STOK3,722$485,000thousands by filing date
FASTENAL CO COM311900104Stock11,117$484,000thousands by filing date
DIAGEO PLC SPON ADR NEW25243Q205ADR3,974$476,000thousands by filing date
Dow Chemical Company260543103COM7,551$476,000thousands by filing date
NIKE,Inc. Class B654106103COM7,975$472,000thousands by filing date
Health Care Select Sector SPDR Fund81369Y209SHS5,942$471,000thousands by filing date
WISDOMTREE EUROPE HEDGED EQUITY FUND97717X701ETF7,402$461,000thousands by filing date
FORD MTR CO COM345370860Stock40,680$455,000thousands by filing date
SPDR GOLD TR78463V107GOLD SHS3,807$449,000thousands by filing date
Lowes Companies,Inc.548661107COM5,775$448,000thousands by filing date
SUNTRUST BANKS INC867914103COM7,848$445,000thousands by filing date
DU PONT E I DE NEMOURS & CO263534109COM5,486$443,000thousands by filing date
Schlumberger Limited806857108COM6,715$442,000thousands by filing date
ISHARES TR MSCI UK ETF NEW46435G334MSCI UK ETF NEW13,267$442,000thousands by filing date
WISDOMTREE TR97717W307US LARGECAP DIVD5,195$437,000thousands by filing date
Amgen Inc.031162100COM2,521$434,000thousands by filing date
ROCKWELL COLLINS INC774341101COM4,133$434,000thousands by filing date
ENBRIDGE INC COM29250N105Stock10,804$430,000thousands by filing date
TIME WARNER INC887317303COM NEW4,274$429,000thousands by filing date
Vanguard FTSE Pacific ETF922042866SHS6,354$418,000thousands by filing date
ALLERGAN PLCG0177J108SHS1,717$417,000thousands by filing date
PRUDENTIAL FINL INC COM744320102Stock3,787$410,000thousands by filing date
Texas Instruments Incorporated882508104COM5,268$405,000thousands by filing date
CELGENE CORP151020104COM3,121$405,000thousands by filing date
WELLTOWER INC COM95040Q104REIT5,295$396,000thousands by filing date
ISHARES TR464287101S&P 100 ETF3,683$394,000thousands by filing date
PPG INDS INC COM693506107Stock3,568$392,000thousands by filing date
EOG RES INC COM26875P101Stock4,302$389,000thousands by filing date
Qualcomm Incorporated747525103COM6,997$386,000thousands by filing date
KLA CORP482480100COM4,080$373,000thousands by filing date
ROCKWELL AUTOMATION INC COM773903109Stock2,281$369,000thousands by filing date
VALERO ENERGY CORP COM91913Y100Stock5,473$369,000thousands by filing date
Chubb LimitedH1467J104COM2,520$368,000thousands by filing date
KONINKLIJKE PHILIPS N V NY REGIS SHS NEW500472303ADR10,123$363,000thousands by filing date
NEWELL BRANDS INC COM651229106Stock6,755$362,000thousands by filing date
ZOETIS INC CL A98978V103Stock5,792$362,000thousands by filing date
MONSANTO CO NEW61166W101COM3,060$362,000thousands by filing date
REYNOLDS AMERICAN INC761713106COMMON STOCK5,529$362,000thousands by filing date
Vanguard FTSE All-World ex-US Small-Cap ETF922042718SHS3,320$359,000thousands by filing date
ISHARES INC464286665MSCI PAC JP ETF8,054$358,000thousands by filing date
Financial Select Sector SPDR Fund81369Y605SHS14,378$355,000thousands by filing date
iShares Core MSCI EAFE ETF46432F842SHS5,743$350,000thousands by filing date
iShares iBoxx Inv Grade Corporate Bond ETF464287242SHS2,884$348,000thousands by filing date
BLOCK H & R INC COM093671105Stock11,152$347,000thousands by filing date
CROWN CASTLE INC COM22822V101REIT3,461$347,000thousands by filing date
UNILEVER PLC904767704SPON ADR NEW6,406$347,000thousands by filing date
iShares Gold Trust464285105ISHARES28,745$343,000thousands by filing date
ISHARES TR464288687COM8,742$342,000thousands by filing date
Energy Select Sector SPDR Fund81369Y506SHS5,157$335,000thousands by filing date
ALIBABA GROUP HLDG LTD01609W102SPONSORED ADS2,360$333,000thousands by filing date
Utilities Select Sector SPDR Fund81369Y886SHS6,391$332,000thousands by filing date
UBS AG LONDON BRH90267B682ETRAC ALER MLP17,518$328,000thousands by filing date
MARKELGROUPINC570535104STOK334$326,000thousands by filing date
Technology Select Sector SPDR Fund81369Y803SHS5,933$325,000thousands by filing date
Southern Company842587107COM6,716$322,000thousands by filing date
Gilead Sciences,Inc.375558103COM4,480$317,000thousands by filing date
iShares S&P Small-Cap 600 Value ETF464287879SHS2,246$314,000thousands by filing date
American Tower Corporation03027X100COM2,355$313,000thousands by filing date
NVIDIA Corp67066G104COM2,164$313,000thousands by filing date
DOMINION ENERGY INC COM25746U109Stock4,088$313,000thousands by filing date
BLACKROCK MUNIYIELD N J FD I09254Y109COM19,247$310,000thousands by filing date
CANADIANNATLRYCOF136375102STOK3,795$308,000thousands by filing date
Accenture Plc Class AG1151C101COM2,441$302,000thousands by filing date
MAGELLAN MIDSTREAM PARTNERS, L559080106COM UNIT RP LP4,210$300,000thousands by filing date
CLOROX CO DEL189054109COM2,241$299,000thousands by filing date
Adobe Inc00724F101COM2,110$298,000thousands by filing date
HORMEL FOODS CORP COM440452100Stock8,709$297,000thousands by filing date
SIMON PPTY GROUP INC NEW COM828806109REIT1,822$295,000thousands by filing date
GALLAGHER ARTHUR J & CO COM363576109Stock5,144$294,000thousands by filing date
NUVEEN PFD & INCOME OPPORTUN67073B106COM27,741$290,000thousands by filing date
OCCIDENTAL PETE CORP674599105COM4,771$289,000thousands by filing date
SCHWAB STRATEGIC TR808524839US AGGREGATE B5,478$286,000thousands by filing date
TEVA PHARMACEUTICAL INDS LTD SPONSORED ADS881624209ADR8,485$282,000thousands by filing date
CELANESE CORP DEL COM150870103Stock2,960$281,000thousands by filing date
BLACKROCK INC CL A COM09247X101COM662$280,000thousands by filing date
YUM BRANDS INC COM988498101Stock3,758$277,000thousands by filing date
TAIWAN SEMICONDUCTOR MFG874039100SPONSORED ADS7,637$276,000thousands by filing date
PAYPALHLDGSINC70450Y103STOK5,075$272,000thousands by filing date
AMERICAN WTR WKS CO INC NEW COM030420103Stock3,441$268,000thousands by filing date
ISHARES TR464288513IBOXX HI YD ETF3,003$265,000thousands by filing date
COLGATE PALMOLIVE CO COM194162103Stock3,548$263,000thousands by filing date
Waste Management, Inc.94106L109COM3,561$261,000thousands by filing date
METLIFE INC COM59156R108Stock4,748$261,000thousands by filing date
Progressive Corporation743315103COM5,782$255,000thousands by filing date
KINDER MORGAN INC DEL COM49456B101Stock13,059$250,000thousands by filing date
SPDR SERIES TRUST78468R739ST NUVE TERM ETF5,162$250,000thousands by filing date
FIRST FINANCIAL NORTHWEST IN32022K102COM15,395$248,000thousands by filing date
TEREX CORP NEW COM880779103Stock6,554$246,000thousands by filing date
Vanguard Intermediate-Term Bond ETF921937819SHS2,883$244,000thousands by filing date
COGNIZANT TECHNOLOGY SOLUTIONS CL A192446102Stock3,670$244,000thousands by filing date
ITAU UNIBANCO HLDG S A SPON ADR REP PFD465562106ADR21,456$237,000thousands by filing date
AMERICAN ELEC PWR CO INC COM025537101Stock3,334$232,000thousands by filing date
PROSHARES TR74347X849INDX FD10,305$232,000thousands by filing date
WOODWARD INC COM980745103Stock3,390$229,000thousands by filing date
GLAXOSMITHKLINE PLC-ADR37733W105SPONSORED ADR5,258$229,000thousands by filing date
VEREIT INC92339V100COM27,157$225,000thousands by filing date
Vanguard FTSE Europe ETF922042874SHS4,056$224,000thousands by filing date
SSGA ACTIVE ETF TR78467V848ST STR TOTAL ETF4,545$224,000thousands by filing date
Eaton Corp. PlcG29183103COM2,859$223,000thousands by filing date
Salesforce.com, Inc79466L302COM2,579$223,000thousands by filing date
HA SUSTAINABLE INFRA CAP INC41068X100COM9,673$221,000thousands by filing date
VANGUARD MALVERN FDS922020805SHS4,463$220,000thousands by filing date
GENERAL MTRS CO COM37045V100Stock6,253$218,000thousands by filing date
EQUIFAX INC COM294429105Stock1,577$217,000thousands by filing date
ISHARES TR464287556ISHARES BIOTECH684$212,000thousands by filing date
ADVANCED ENERGY INDS COM007973100Stock3,274$212,000thousands by filing date
STATE STR SPDR DOW JONES IND78467X109UT SER 1987$210,000thousands by filing date
V F CORP COM918204108Stock3,515$202,000thousands by filing date
EXPRESS SCRIPTS HLDG CO30219G108COM3,160$202,000thousands by filing date
MARATHON OIL CORP565849106COM13,801$164,000thousands by filing date
CYPRESS ENVIRONMENTL PARTNR232751107LTD PARTNER INT10,907$81,000thousands by filing date
VOYA PRIME RATE TRUST92913A100SH BEN INT10,646$57,000thousands by filing date
LLOYDS BANKING GROUP PLC539439AG4SDCV 7.500%12/350,000$55,000thousands by filing date
LLOYDS BANKING GROUP PLC SPONSORED ADR539439109ADR11,461$40,000thousands by filing date

Amendment chain

FilingRoleFiledAcceptedIngested
13F-HR 0001214659-20-005402this filing2020-06-04acceptance time not in the bulk data set