Affiance Financial, LLC - Q1 2017 holdings

$129 Million is the total value of Affiance Financial, LLC's 81 reported holdings in Q1 2017. The portfolio turnover from Q4 2016 to Q1 2017 was 12.8% .

 Value Shares↓ Weighting
IJH BuyISHARES TRcore s&p mcp etf$19,959,000
+7.2%
116,570
+3.5%
15.43%
+3.4%
BSV BuyVANGUARD BD INDEX FD INCshort trm bond$12,325,000
+9.3%
154,604
+8.9%
9.53%
+5.4%
BND SellVANGUARD BD INDEX FD INCtotal bnd mrkt$9,782,000
-4.2%
120,644
-4.5%
7.56%
-7.6%
XLP SellSELECT SECTOR SPDR TRsbi cons stpls$9,624,000
+0.2%
176,327
-5.1%
7.44%
-3.4%
VNQ BuyVANGUARD INDEX FDSreit etf$9,554,000
+7.9%
115,679
+7.8%
7.39%
+4.1%
IVV BuyISHARES TRcore s&p500 etf$7,434,000
+13.8%
31,331
+7.9%
5.75%
+9.8%
BIV BuyVANGUARD BD INDEX FD INCintermed term$5,935,000
+17.5%
70,982
+16.8%
4.59%
+13.4%
PFF SellISHARES TRu.s. pfd stk etf$4,918,000
+0.7%
127,079
-3.1%
3.80%
-2.8%
MYD BuyBLACKROCK MUNIYIELD FD INC$2,375,000
+26.8%
165,296
+24.8%
1.84%
+22.4%
VTI BuyVANGUARD INDEX FDStotal stk mkt$2,214,000
+36.6%
18,252
+29.8%
1.71%
+31.8%
PML BuyPIMCO MUN INCOME FD II$2,022,000
+103.2%
160,749
+97.4%
1.56%
+96.0%
MMU BuyWESTERN ASST MNGD MUN FD INC$1,789,000
+16.6%
130,032
+16.3%
1.38%
+12.4%
EFG BuyISHARES TReafe grwth etf$1,653,000
+40.8%
23,785
+29.0%
1.28%
+35.8%
AAPL BuyAPPLE INC$1,648,000
+27.9%
11,471
+3.1%
1.27%
+23.3%
MUH SellBLACKROCK MUNIHLDGS FD II IN$1,631,000
+1.3%
105,051
-4.1%
1.26%
-2.3%
EFA SellISHARES TRmsci eafe etf$1,622,000
-0.8%
26,043
-8.0%
1.25%
-4.3%
PGF SellPOWERSHARES ETF TRUSTfinl pfd ptfl$1,590,000
+0.6%
85,226
-3.2%
1.23%
-2.9%
VDE BuyVANGUARD WORLD FDSenergy etf$1,588,000
-7.2%
16,417
+0.4%
1.23%
-10.5%
JNJ BuyJOHNSON & JOHNSON$1,355,000
+8.1%
10,881
+0.1%
1.05%
+4.4%
MMM Buy3M CO$1,339,000
+9.5%
6,999
+2.2%
1.04%
+5.6%
GIS BuyGENERAL MLS INC$1,288,000
+10.7%
21,835
+16.0%
1.00%
+6.9%
FB SellFACEBOOK INCcl a$1,258,000
+22.7%
8,858
-0.6%
0.97%
+18.4%
VIG SellVANGUARD SPECIALIZED PORTFOLdiv app etf$1,197,000
-1.4%
13,304
-6.7%
0.93%
-4.8%
XOM SellEXXON MOBIL CORP$1,122,000
-10.8%
13,677
-1.9%
0.87%
-13.9%
VTV SellVANGUARD INDEX FDSvalue etf$1,120,000
-21.4%
11,739
-23.4%
0.87%
-24.2%
MCD  MCDONALDS CORP$929,000
+6.5%
7,1670.0%0.72%
+2.7%
VOO SellVANGUARD INDEX FDS$878,000
+2.1%
4,057
-3.1%
0.68%
-1.5%
XLV SellSELECT SECTOR SPDR TRsbi healthcare$846,000
-15.6%
11,381
-21.7%
0.65%
-18.6%
EPD  ENTERPRISE PRODS PARTNERS L$807,000
+2.0%
29,2410.0%0.62%
-1.6%
MFA SellMFA FINL INC$758,000
-5.0%
93,779
-10.3%
0.59%
-8.4%
MDT SellMEDTRONIC PLC$752,000
+0.1%
9,333
-11.5%
0.58%
-3.3%
PAYX SellPAYCHEX INC$745,000
-6.3%
12,641
-3.2%
0.58%
-9.6%
INTC  INTEL CORP$709,000
-0.6%
19,6620.0%0.55%
-4.2%
VO SellVANGUARD INDEX FDSmid cap etf$696,000
-10.3%
4,998
-15.2%
0.54%
-13.5%
JPM  JPMORGAN CHASE & CO$609,000
+1.8%
6,9320.0%0.47%
-1.7%
VGT  VANGUARD WORLD FDSinf tech etf$560,000
+11.6%
4,1310.0%0.43%
+7.7%
TGT SellTARGET CORP$525,000
-25.6%
9,519
-2.7%
0.41%
-28.3%
C  CITIGROUP INC$518,000
+0.6%
8,6590.0%0.40%
-2.9%
GM  GENERAL MTRS CO$515,000
+1.4%
14,5770.0%0.40%
-2.2%
MO  ALTRIA GROUP INC$478,000
+5.8%
6,6910.0%0.37%
+2.2%
UNH  UNITEDHEALTH GROUP INC$478,000
+2.4%
2,9160.0%0.37%
-1.1%
GOOG SellALPHABET INCcap stk cl c$471,000
+1.1%
568
-6.0%
0.36%
-2.7%
NBH SellNEUBERGER BERMAN INTER MUNI$468,000
-18.6%
31,527
-10.9%
0.36%
-21.5%
KXI  ISHARES TRglb cnsm stp etf$467,000
+8.1%
4,6950.0%0.36%
+4.3%
FVD SellFIRST TR VALUE LINE DIVID IN$464,000
+0.4%
15,989
-3.1%
0.36%
-3.0%
IYW SellISHARES TRu.s. tech etf$462,000
-12.0%
3,416
-21.8%
0.36%
-15.2%
PII BuyPOLARIS INDS INC$450,000
+1.8%
5,372
+0.2%
0.35%
-1.7%
VV SellVANGUARD INDEX FDSlarge cap etf$421,000
-4.5%
3,891
-9.7%
0.33%
-7.9%
WFC SellWELLS FARGO & CO NEW$410,000
+0.2%
7,369
-0.7%
0.32%
-3.4%
BRKB  BERKSHIRE HATHAWAY INC DELcl b new$390,000
+2.4%
2,3390.0%0.30%
-1.0%
CAT SellCATERPILLAR INC DEL$390,000
-8.2%
4,204
-8.3%
0.30%
-11.4%
T SellAT&T INC$368,000
-9.1%
8,865
-6.9%
0.28%
-12.3%
VYM SellVANGUARD WHITEHALL FDS INChigh div yld$364,000
+0.3%
4,693
-2.0%
0.28%
-3.4%
PG BuyPROCTER AND GAMBLE CO$360,000
+9.4%
4,003
+2.5%
0.28%
+5.3%
DIS BuyDISNEY WALT CO$358,000
+12.2%
3,156
+3.3%
0.28%
+8.2%
IBM  INTERNATIONAL BUSINESS MACHS$353,000
+4.7%
2,0280.0%0.27%
+1.1%
MSFT SellMICROSOFT CORP$349,000
+5.1%
5,294
-0.8%
0.27%
+1.5%
VEA SellVANGUARD TAX MANAGED INTL FDftse dev mkt etf$314,000
-31.3%
7,984
-36.2%
0.24%
-33.6%
ORCL SellORACLE CORP$306,000
+13.3%
6,849
-2.5%
0.24%
+9.7%
VB SellVANGUARD INDEX FDSsmall cp etf$299,000
+0.3%
2,243
-3.0%
0.23%
-3.3%
IJT  ISHARES TRsp smcp600gr etf$298,000
+2.1%
1,9470.0%0.23%
-1.7%
IP  INTL PAPER CO$285,000
-4.0%
5,6050.0%0.22%
-7.6%
ABBV BuyABBVIE INC$285,000
+5.9%
4,373
+1.9%
0.22%
+1.9%
GOOGL  ALPHABET INCcap stk cl a$270,000
+6.7%
3190.0%0.21%
+3.0%
WMT  WAL-MART STORES INC$267,000
+4.3%
3,7030.0%0.21%
+0.5%
VWO  VANGUARD INTL EQUITY INDEX Fftse emr mkt etf$263,000
+11.4%
6,6090.0%0.20%
+7.4%
IJR BuyISHARES TRcore s&p scp etf$260,000
+3.2%
3,762
+105.5%
0.20%
-0.5%
PEP BuyPEPSICO INC$258,000
+10.3%
2,303
+3.0%
0.20%
+6.4%
KMB BuyKIMBERLY CLARK CORP$244,000
+15.6%
1,855
+0.5%
0.19%
+11.8%
NZF  NUVEEN MUNICIPAL CREDIT INC$243,000
+1.7%
16,8900.0%0.19%
-2.1%
RHS SellRYDEX ETF TRUSTgug s&p500 ewcon$223,000
-21.5%
1,792
-24.6%
0.17%
-24.6%
GILD SellGILEAD SCIENCES INC$219,000
-60.5%
3,222
-58.4%
0.17%
-62.0%
CVX BuyCHEVRON CORP NEW$217,000
+6.4%
2,018
+16.3%
0.17%
+2.4%
O  REALTY INCOME CORP$214,000
+3.4%
3,5950.0%0.16%
-0.6%
VHT SellVANGUARD WORLD FDShealth car etf$211,000
-32.2%
1,531
-37.7%
0.16%
-34.5%
AMZN NewAMAZON COM INC$211,000238
+100.0%
0.16%
APU SellAMERIGAS PARTNERS L Punit l p int$205,000
-61.1%
4,348
-60.5%
0.16%
-62.3%
ABT NewABBOTT LABS$202,0004,550
+100.0%
0.16%
LEA NewLEAR CORP$200,0001,415
+100.0%
0.16%
BKCC  BLACKROCK CAPITAL INVESTMENT$96,000
+9.1%
12,6830.0%0.07%
+4.2%
EVLV  EVINE LIVE INCcl a$37,000
-14.0%
28,8070.0%0.03%
-14.7%
BP ExitBP PLCsponsored adr$0-5,428
-100.0%
-0.16%
KO ExitCOCA COLA CO$0-4,998
-100.0%
-0.17%
PSK ExitSPDR SERIES TRUSTwells fg pfd etf$0-4,956
-100.0%
-0.17%
TEVA ExitTEVA PHARMACEUTICAL INDS LTDadr$0-6,050
-100.0%
-0.18%
EDV ExitVANGUARD WORLD FDextended dur$0-2,412
-100.0%
-0.21%
BKN ExitBLACKROCK INVT QUALITY MUN T$0-26,426
-100.0%
-0.31%
MMP ExitMAGELLAN MIDSTREAM PRTNRS LP$0-6,206
-100.0%
-0.38%
VZ ExitVERIZON COMMUNICATIONS INC$0-11,922
-100.0%
-0.51%
Original filings

The following EDGAR filing(s) were analyzed to create this report:

  • View 13F-HR filed 2017-12-08
Signatures

The EDGAR filing(s) were signed by:

Top long-term holdings
NameQuarters ownedLatest quarter ownedMax weighting
SELECT SECTOR SPDR TR36Q3 202317.6%
VANGUARD INDEX FDS36Q3 202310.2%
VANGUARD INDEX FDS36Q3 20238.1%
APPLE INC36Q3 20234.8%
ISHARES TR36Q3 20236.7%
VANGUARD INDEX FDS36Q3 20234.4%
MICROSOFT CORP36Q3 20233.3%
3M CO36Q3 20232.3%
VANGUARD SPECIALIZED PORTFOL36Q3 20232.6%
SELECT SECTOR SPDR TR36Q3 20236.8%

View Affiance Financial, LLC's complete holdings history.

Latest filings
TypeFiled
13F-HR2024-04-15
13F-HR2024-01-10
13F-HR2023-10-11
13F-HR2023-07-12
13F-HR2023-04-18
13F-HR2023-01-20
13F-HR2022-10-27
13F-HR2022-07-14
13F-HR/A2022-04-19
13F-HR2022-04-12

View Affiance Financial, LLC's complete filings history.

Compare quarters

Issues

The following issues were detected while analyzing the report:

  • The reported total value is incorrect (129316000.0 != 129317000.0)

Export Affiance Financial, LLC's holdings