Skip to content

13F-HR filed by ASPIRIANT, LLC

ASPIRIANT, LLC filed this 13F-HR for the quarter ended 2017-09-30, filed 2017-11-13, with 203 holding rows worth $1,193,041,000.

Accession
0001172661-17-001943
Filed
2017-11-13
Accepted by EDGAR
acceptance time not in the bulk data set
Ingested
Source
SEC quarterly data set

Original filing

13F report for Q3 2017

A holdings report, 203 entries on the cover page, a total value of $1,193,041,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,193,041,000 with VALUE read as thousands by filing date, 13F file number 028-13064. 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
ISHARES INC464286525MSCI GBL MIN VOL1,473,585$119,920,000thousands by filing date
UBS Alerian MLP/ MLPI902641646TR UNIT4,307,586$108,293,000thousands by filing date
iShares Core S&P U.S. Value ETF464287663SHS1,238,600$64,841,000thousands by filing date
Vanguard S&P 500 ETF922908363COM188,829$43,574,000thousands by filing date
Vanguard Dividend Appreciation ETF921908844SHS430,421$40,800,000thousands by filing date
VANGUARD INTL EQUITY INDEX F922042676COM660,034$39,213,000thousands by filing date
Vanguard Real Estate922908553SHS448,039$37,228,000thousands by filing date
ISHARES TR CORE S&P 500 ETF464287200SHS142,688$36,090,000thousands by filing date
Vanguard FTSE Developed Markets ETF921943858SHS798,298$34,654,000thousands by filing date
ISHARES TR464287739U.S. REAL ES ETF411,646$32,882,000thousands by filing date
Vanguard Total Bond Market ETF921937835SHS362,072$29,675,000thousands by filing date
SPY78462F103SHS111,646$28,049,000thousands by filing date
iShares Russell 2000 ETF464287655SHS168,486$24,966,000thousands by filing date
iShares Core MSCI Emerging Markets ETF46434G103SHS459,014$24,796,000thousands by filing date
ISHARES TR464287465MSCI EAFE ETF357,960$24,513,000thousands by filing date
Vanguard FTSE All-World ex-US ETF922042775SHS406,226$21,412,000thousands by filing date
ISHARES TR464288257MSCI ACWI ETF307,451$21,159,000thousands by filing date
Berkshire Hathaway Inc084670702COM114,581$21,005,000thousands by filing date
Apple Inc037833100COM127,426$19,639,000thousands by filing date
SPDR INDEX SHS FDS78463X863ST DOW INTL ETF502,103$19,271,000thousands by filing date
ISHARES RUSSELL 1000 ETF464287622ETF127,021$17,768,000thousands by filing date
VANGUARD SCOTTSDALE FDS92206C409COM220,384$17,659,000thousands by filing date
Financial Select Sector SPDR Fund81369Y605SHS652,605$16,876,000thousands by filing date
ISHARES INC464286533MSCI EMERG MRKT210,249$12,215,000thousands by filing date
iShares MSCI USA Min Vol Factor ETF46429B697SHS239,414$12,052,000thousands by filing date
META PLATFORMS INC CL A30303M102COM66,742$11,404,000thousands by filing date
ISHARES RUSSELL 1000 VALUE ETF464287598ETF86,361$10,235,000thousands by filing date
iShares Core MSCI EAFE ETF46432F842SHS146,225$9,383,000thousands by filing date
Schwab U.S. Large-Cap ETF808524201SHS154,593$9,282,000thousands by filing date
ISHARES TR464287234MSCI EMG MKT ETF206,688$9,262,000thousands by filing date
CINCINNATI FINL CORP COM172062101Stock118,602$9,081,000thousands by filing date
Schwab US Mid-Cap ETF808524508SHS170,310$8,534,000thousands by filing date
VWO922042858SHS195,126$8,502,000thousands by filing date
VANGUARD MALVERN FDS922020805SHS171,440$8,478,000thousands by filing date
VANGUARD INDEX FDS922908637LARGE CAP ETF71,533$8,255,000thousands by filing date
ISHARES 1-5 YEAR INVESTMENT GRADE CORPORATE BOND ETF464288646ETF63,188$6,657,000thousands by filing date
Procter & Gamble Co742718109COM72,816$6,625,000thousands by filing date
SCHWAB STRATEGIC TR808524839US AGGREGATE B117,314$6,143,000thousands by filing date
Johnson & Johnson478160104COM47,082$6,121,000thousands by filing date
ROYAL BK CDA COM780087102Stock77,000$5,956,000thousands by filing date
Vanguard Total International Bond Index Fund ETF92203J407SHS106,832$5,832,000thousands by filing date
iShares MSCI ACWI ex U.S. ETF464288240SHS117,717$5,692,000thousands by filing date
Alphabet Inc. Reg. Shares A02079K305COM5,746$5,595,000thousands by filing date
USBANCORPDEL902973304COM NEW95,276$5,106,000thousands by filing date
Chevron Corporation166764100COM35,389$4,158,000thousands by filing date
JPMorgan Chase & Co46625H100COM43,330$4,138,000thousands by filing date
iShares Russell Midcap ETF464287499SHS19,708$3,885,000thousands by filing date
PepsiCo,Inc.713448108COM34,806$3,878,000thousands by filing date
Vanguard Intermediate-Term Corporate Bond ETF92206C870SHS41,016$3,610,000thousands by filing date
Microsoft Corp594918104COM47,696$3,553,000thousands by filing date
UBS AG LONDON BRH90267B682ETRAC ALER MLP195,641$3,475,000thousands by filing date
ISHARES TR464287689RUSSELL 3000 ETF22,654$3,382,000thousands by filing date
RAYTHEON CO755111507COM NEW17,282$3,224,000thousands by filing date
Vanguard Short-Term Bond ETF921937827SHS39,784$3,176,000thousands by filing date
3M CO COM88579Y101Stock14,805$3,108,000thousands by filing date
VTI922908769COM23,605$3,057,000thousands by filing date
ISHARES TR464288489INTL DEV RE ETF104,245$3,041,000thousands by filing date
Walt Disney Co254687106COM30,705$3,027,000thousands by filing date
BERKSHIRE HATHAWAY INC DEL084670108CL A11$3,022,000thousands by filing date
SSGA ACTIVE ETF TR78467V848ST STR TOTAL ETF61,048$3,008,000thousands by filing date
VGT92204A702SHS18,659$2,836,000thousands by filing date
SCHWAB STRATEGIC TR808524706EMRG MKTEQ ETF104,706$2,818,000thousands by filing date
ISHARES TR464288414NATIONAL MUN ETF24,947$2,766,000thousands by filing date
Union Pacific Corporation907818108COM23,456$2,720,000thousands by filing date
Comcast Corp20030N101COM69,499$2,674,000thousands by filing date
Verizon Communications Inc92343V104COM51,625$2,555,000thousands by filing date
Charles Schwab Corp808513105COM54,759$2,395,000thousands by filing date
Wells Fargo & Company949746101COM43,402$2,394,000thousands by filing date
TJX Companies Inc872540109COM32,173$2,372,000thousands by filing date
ISHARES MSCI EAFE MIN VOL FACTOR ETF46429B689ETF31,073$2,208,000thousands by filing date
Alphabet Inc. Reg. Shares C02079K107COM2,296$2,203,000thousands by filing date
Abbott Laboratories002824100COM40,544$2,163,000thousands by filing date
VANECK ETF TRUST92189F726BIOTECH ETF15,903$2,133,000thousands by filing date
Danaher Corporation235851102COM24,163$2,073,000thousands by filing date
Vanguard Materials ETF92204A801SHS15,840$2,036,000thousands by filing date
Qualcomm Incorporated747525103COM38,584$2,000,000thousands by filing date
JP MORGAN CHASE & CO46625H365EXCHANGE TRADED69,700$1,967,000thousands by filing date
CVS Health Corporation126650100COM24,120$1,961,000thousands by filing date
GENERAL ELEC CO369604103COM79,056$1,924,000thousands by filing date
EXXON MOBIL CORP30231G102COM22,246$1,824,000thousands by filing date
ISHARESRUSSELL1000GROWTHETF464287614STOK14,520$1,816,000thousands by filing date
iShares MSCI EAFE Value ETF464288877SHS32,437$1,771,000thousands by filing date
ISHARES TR464287630RUS 2000 VAL ETF14,088$1,749,000thousands by filing date
NextEra Energy,Inc.65339F101COM11,485$1,683,000thousands by filing date
Schwab US TIPS ETF808524870SHS29,979$1,657,000thousands by filing date
SPDR INDEX SHS FDS78463X871ST INTL CAP ETF46,444$1,626,000thousands by filing date
Cisco Systems,Inc.17275R102COM44,586$1,499,000thousands by filing date
SCHWAB STRATEGIC TR808524888INTL SCEQT ETF39,965$1,432,000thousands by filing date
SPDR INDEX SHS FDS78463X426ST STR MSCI EM22,659$1,385,000thousands by filing date
AT&T Inc00206R102COM35,208$1,379,000thousands by filing date
Intel Corp458140100COM36,143$1,376,000thousands by filing date
ENBRIDGE INC COM29250N105Stock32,872$1,375,000thousands by filing date
CELGENE CORP151020104COM9,014$1,314,000thousands by filing date
Merck & Co.,Inc.58933Y105COM20,341$1,302,000thousands by filing date
Pfizer Inc.717081103COM34,413$1,229,000thousands by filing date
WELLS FARGO & CO949746804PERP PFD CNV A925$1,216,000thousands by filing date
Vanguard Mega Cap Growth ETF921910816SHS11,575$1,212,000thousands by filing date
Coca-Cola Company191216100COM26,726$1,203,000thousands by filing date
RYDEX GUGGENHEIM78355W833GUG S&P500 EQ WT10,268$1,153,000thousands by filing date
Vanguard High Dividend Yield ETF921946406SHS14,105$1,144,000thousands by filing date
PAYPALHLDGSINC70450Y103STOK17,801$1,140,000thousands by filing date
ALLERGAN PLCG0177J108SHS5,486$1,124,000thousands by filing date
International Business Machines Corporation459200101COM7,608$1,104,000thousands by filing date
EOG RES INC COM26875P101Stock11,332$1,096,000thousands by filing date
TORONTO DOMINION BK ONT COM NEW891160509Stock18,319$1,031,000thousands by filing date
WENDYS CO COM95058W100Stock64,196$997,000thousands by filing date
Bristol-Myers Squibb Company110122108COM15,340$978,000thousands by filing date
iShares S&P 500 Value ETF464287408SHS8,992$970,000thousands by filing date
Schlumberger Limited806857108COM13,689$955,000thousands by filing date
iShares Core S&P Small-Cap ETF464287804SHS12,694$942,000thousands by filing date
Oracle Corporation68389X105COM19,466$941,000thousands by filing date
Philip Morris International Inc.718172109COM8,337$926,000thousands by filing date
EMERSON ELEC CO COM291011104Stock14,398$905,000thousands by filing date
United Parcel Service,Inc. Class B911312106COM7,436$893,000thousands by filing date
Duke Energy Corporation26441C204COM10,484$880,000thousands by filing date
NIKE,Inc. Class B654106103COM16,752$869,000thousands by filing date
iShares Core US Aggregate Bond ETF464287226SHS7,874$863,000thousands by filing date
MONSANTO CO NEW61166W101COM7,180$860,000thousands by filing date
Vanguard Value ETF922908744SHS8,354$834,000thousands by filing date
Amgen Inc.031162100COM4,315$805,000thousands by filing date
Amazon.com, Inc023135106COM818$786,000thousands by filing date
AMERICAN ELEC PWR CO INC COM025537101Stock10,549$741,000thousands by filing date
ISHARES TR464288513IBOXX HI YD ETF8,267$734,000thousands by filing date
Home Depot, Inc437076102COM4,439$726,000thousands by filing date
EXPRESS SCRIPTS HLDG CO30219G108COM11,465$726,000thousands by filing date
SPDR SER TR78464A359BBG CONV SEC ETF13,859$708,000thousands by filing date
BOX INC CL A10316T104Stock34,822$673,000thousands by filing date
REALTY INCOME CORP COM756109104REIT11,259$644,000thousands by filing date
EVERPURE INC CL A74624M102Stock38,748$620,000thousands by filing date
Energy Select Sector SPDR Fund81369Y506SHS8,861$607,000thousands by filing date
NOVARTIS AG SPONSORED ADR66987V109ADR7,058$606,000thousands by filing date
SPDR GOLD TR78463V107GOLD SHS4,843$589,000thousands by filing date
TABLEAU SOFTWARE INC87336U105CL A7,588$568,000thousands by filing date
PRAXAIR INC74005P104COM3,853$538,000thousands by filing date
CURRENCYSHS BRIT POUND STER23129S106BRIT POUND STE4,089$533,000thousands by filing date
Southern Company842587107COM10,797$531,000thousands by filing date
DBX ETF TR233051853XTRACK MSCI EURP18,740$531,000thousands by filing date
Vanguard Small-Cap ETF922908751SHS3,589$507,000thousands by filing date
MARATHON PETE CORP COM56585A102Stock8,729$490,000thousands by filing date
NEW YORK LIFE INVESTMENTS ET45409B107NYLI HEDGE MULTI16,046$479,000thousands by filing date
MasterCard, Inc57636Q104COM3,359$474,000thousands by filing date
Vanguard Small-Cap Growth ETF922908595SHS3,066$468,000thousands by filing date
ILLUMINA INC452327109COM2,347$468,000thousands by filing date
GENUINE PARTS CO COM372460105Stock4,779$457,000thousands by filing date
ISHARES RUSSELL MID-CAP GROWTH ETF464287481ETF3,925$444,000thousands by filing date
POWERSHARES ETF TR II S&P500 L73937B779COM9,636$441,000thousands by filing date
Bank of America Corp060505104COM16,481$418,000thousands by filing date
V F CORP COM918204108Stock6,220$395,000thousands by filing date
PAYCHEX INC704326107COM6,466$388,000thousands by filing date
Adobe Inc00724F101COM2,554$381,000thousands by filing date
AbbVie,Inc.00287Y109COM4,262$379,000thousands by filing date
Visa Inc92826C839COM3,466$365,000thousands by filing date
Gilead Sciences,Inc.375558103COM4,418$358,000thousands by filing date
Vanguard Intermediate-Term Bond ETF921937819SHS4,050$343,000thousands by filing date
CLOROX CO DEL189054109COM2,573$339,000thousands by filing date
Costco Wholesale Corporation22160K105COM2,045$336,000thousands by filing date
PRICE T ROWE GROUP INC COM74144T108Stock3,672$333,000thousands by filing date
Vanguard Consumer Staples ETF92204A207SHS2,365$328,000thousands by filing date
VAREX IMAGING CORP92214X106COMMON STOCK9,610$325,000thousands by filing date
Starbucks Corporation855244109COM5,817$312,000thousands by filing date
UnitedHealth Group Inc91324P102COM1,594$312,000thousands by filing date
ISHARES INC MSCI EURZONE ETF464286608MSCI EURZONE ETF7,160$310,000thousands by filing date
Vanguard FTSE Pacific ETF922042866SHS4,500$307,000thousands by filing date
McDonalds Corporation580135101COM1,956$306,000thousands by filing date
RYDEX ETF TRUST HEALTH CARE78355W841COM1,733$304,000thousands by filing date
Accenture Plc Class AG1151C101COM2,204$298,000thousands by filing date
BECTON DICKINSON & CO075887109COM1,497$293,000thousands by filing date
CARDINAL HEALTH INC14149Y108COM4,223$283,000thousands by filing date
Boeing Company097023105COM1,105$281,000thousands by filing date
SPDR SERIES TRUST78464A284NUVEEN ICE HIGH4,907$280,000thousands by filing date
SPDR S&P Dividend ETF78464A763SHS3,019$276,000thousands by filing date
MARATHON OIL CORP565849106COM20,083$272,000thousands by filing date
DTE ENERGY CO233331883UNIT 99/99/99995,000$272,000thousands by filing date
SEMPRA COM816851109Stock2,338$267,000thousands by filing date
POLARIS INC COM731068102Stock2,529$265,000thousands by filing date
NUVEEN CA DIVI ADV MUN67066Y105COM17,556$262,000thousands by filing date
EVERSOURCE ENERGY COM30040W108Stock4,291$259,000thousands by filing date
WORKDAY INC CL A98138H101Stock2,446$258,000thousands by filing date
ISHARES TR464287168COM2,694$252,000thousands by filing date
OCCIDENTAL PETE CORP674599105COM3,932$252,000thousands by filing date
Honeywell Technologies438516106COM1,720$244,000thousands by filing date
WALGREENS BOOTS ALLIANCE INC931427108COM3,022$233,000thousands by filing date
SCANA CORP NEW80589M102COM4,754$231,000thousands by filing date
SCHWAB STRATEGIC TR808524409US LCAP VA ETF4,413$229,000thousands by filing date
Vanguard Small-Cap Value ETF922908611SHS1,776$227,000thousands by filing date
ISHARES TR464287374NORTH AMERN NAT6,737$227,000thousands by filing date
PowerShares QQQ Trust Unit Ser73935A104COM1,558$227,000thousands by filing date
Salesforce.com, Inc79466L302COM2,376$222,000thousands by filing date
FULL HSE RESORTS INC359678109COM77,600$217,000thousands by filing date
EASTMAN CHEM CO COM277432100Stock2,364$214,000thousands by filing date
PUBLIC STORAGE COM74460D109REIT994$213,000thousands by filing date
CONSOLIDATED EDISON INC209115104COM2,602$210,000thousands by filing date
iShares iBoxx Inv Grade Corporate Bond ETF464287242SHS1,702$206,000thousands by filing date
Vanguard Utilities ETF92204A876SHS1,759$205,000thousands by filing date
ISHARES TR464288687COM5,245$204,000thousands by filing date
Walmart Inc.931142103COM2,608$204,000thousands by filing date
GLOBAL X FDS37950E226GLB X MLP ENRG I13,025$180,000thousands by filing date
HUNTINGTON BANCSHARES INC COM446150104Stock11,425$159,000thousands by filing date
FORD MTR CO COM345370860Stock11,131$133,000thousands by filing date
UNITED SEC BANCSHARES CALIF911460103COM12,480$119,000thousands by filing date
GOLDMAN SACHS MLP INC OPP FD38147W103COM SHS10,590$99,000thousands by filing date
SUPPORT COM INC86858W200COM NEW20,649$49,000thousands by filing date
ZIX CORP98974P100COM16,000$0thousands by filing dateValue filed as zero, left out of ratios.

Amendment chain

FilingRoleFiledAcceptedIngested
13F-HR 0001172661-17-001943this filing2017-11-13acceptance time not in the bulk data set