Affiance Financial, LLC — Q2 2017 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q2 2017
Creator: AlphaSMO
License: https://www.sec.gov/forms

CIK: 0001723681

Total reported value

$695.4M

← Back to latest quarter

Full holdings list this quarter

#	Ticker	Issuer	Asset Subclass	Weight	Weight Change	Shares Change
1	IJH	Ishares Core S&p Midcap ETF	ETF-Other	16.04%	-0.02%	-0.69%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	10.37%	—	+5.42%
3	VNQ	Vanguard Real Estate ETF	ETF-Other	7.91%	—	+3.12%
4	XLP	Ss Consumer Staples Sel Sect	ETF-Other	7.15%	—	-7.31%
5	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	6.73%	+0.02%	+10.77%
6	BND	Vanguard Total Bond Market	ETF-Other	6.01%	—	-23.57%
7	BIV	Vanguard Intermediate-term B	ETF-Other	5.26%	—	+9.96%
8	PFF	Ishares Preferred & Income S	ETF-Other	3.69%	—	-6.99%
9	XMYDX	Blackrock Muniyield Fund	Stock-Other	1.91%	—	-3.27%
10	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	1.74%	+0.78%	-4.09%
11	PML	Pimco Municipal Income Fd Ii	Stock-Other	1.53%	—	-8.92%
12	AAPL	Apple INC	Stock-Tech	1.41%	-0.14%	+7.38%
13	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.40%	-0.01%	+0.20%
14	EFA	Ishares Msci Eafe ETF	ETF-Other	1.32%	—	-2.19%
15	MMU	Western Asset Managed Munici	Stock-Other	1.30%	—	-8.89%
16	MMM	3m Co	Stock-Industrials	1.20%	+0.01%	+3.53%
17	JNJ	Johnson & Johnson	Stock-Healthcare	1.13%	+0.04%	-1.27%
18	VDE	Vanguard Energy ETF	ETF-Other	1.12%	—	-3.23%
19	META	Meta Platforms Inc-class A	Stock-Comm Services	1.07%	—	—
20	GIS	General Mills INC	Stock-Consumer Staples	0.96%	—	—
21	✓	Invesco Financial Preferred ETF	ETF-Other	0.90%	—	-30.34%
22	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.87%	—	—
23	XOM	Exxon Mobil CORP	Stock-Energy	0.85%	-0.06%	EXIT
24	✓	Blackrock Munihldgs Fd Ii In	Stock-Other	0.85%	—	-35.93%
25	VTV	Vanguard Value ETF	ETF-Other	0.80%	+0.09%	-11.06%
26	VIG	Vanguard Dividend Apprec ETF	ETF-Other	0.74%	—	-24.25%
27	XLV	Ss Health Care Select Sector	ETF-Other	0.67%	—	-6.63%
28	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	0.66%	+0.36%	-7.96%
29	MDT	Medtronic plc	Stock-Healthcare	0.58%	—	-11.53%
30	PAYX	Paychex INC	Stock-Tech	0.57%	—	—
31	TGT	Target CORP	Stock-Consumer Disc	0.53%	—	+34.36%
32	INTC	Intel CORP	Stock-Tech	0.53%	+0.04%	NEW
33	VO	Vanguard Mid-cap ETF	ETF-Other	0.52%	+0.02%	-8.78%
34	JPM	Jpmorgan Chase & Co	Stock-Financials	0.50%	-0.01%	-0.07%
35	VGT	Vanguard Info Tech ETF	ETF-Tech	0.46%	+0.08%	—
36	C	Citigroup INC	Stock-Financials	0.46%	—	-0.10%
37	UNH	Unitedhealth Group INC	Stock-Healthcare	0.43%	+0.09%	—
38	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.42%	+0.05%	+1.06%
39	GM	General Motors Co	Stock-Consumer Disc	0.41%	—	—
40	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.40%	—	+26.04%
41	MO	Altria Group INC	Stock-Consumer Staples	0.40%	—	—
42	PII	Polaris INC	Stock-Consumer Disc	0.40%	—	+0.17%
43	KXI	Ishares Global Consumer Stap	ETF-Other	0.38%	—	—
44	IYW	Ishares Ustechnology ETF	ETF-Tech	0.38%	+0.03%	—
45	CAT	Caterpillar INC	Stock-Industrials	0.35%	—	-2.38%
46	VV	Vanguard Large-cap ETF	ETF-Other	0.34%	—	-2.06%
47	WFC	Wells Fargo & Co	Stock-Financials	0.33%	—	+1.36%
48	NBH	Neuberger Municipal Fund INC	Stock-Other	0.32%	—	-16.16%
49	MSFT	Microsoft CORP	Stock-Tech	0.29%	—	+1.45%
50	VB	Vanguard Small-cap ETF	ETF-Other	0.28%	+0.14%	NEW

1–50 of 74

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q2 2017, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	IVV	Ishares Core S&p 500 ETF	+1%	+10.77%	Add
2	BSV	Vanguard Short-term Bond ETF	+0.8%	+5.42%	Add
3	BIV	Vanguard Intermediate-term B	+0.7%	+9.96%	Add
4	IJH	Ishares Core S&p Midcap ETF	+0.6%	-0.69%	Trim
5	VNQ	Vanguard Real Estate ETF	+0.5%	+3.12%	Add
6	MMM	3m Co	+0.2%	+3.53%	Add
7	MCD	Mcdonald's CORP	+0.2%	—	Unchanged
8	AAPL	Apple INC	+0.1%	+7.38%	Add
9	TGT	Target CORP	+0.1%	+34.36%	Add
10	EFG	Ishares Msci Eafe Growth ETF	+0.1%	+0.20%	Add
11	BRK-B	Berkshire Hathaway Inc-cl B	+0.1%	+26.04%	Add
12	META	Meta Platforms Inc-class A	+0.1%	—	Unchanged
13	JNJ	Johnson & Johnson	+0.1%	-1.27%	Trim
14	EFA	Ishares Msci Eafe ETF	+0.1%	-2.19%	Trim
15	UNH	Unitedhealth Group INC	+0.1%	—	Unchanged
16	C	Citigroup INC	+0.1%	-0.10%	Trim
17	GOOG	Alphabet Inc-cl C	+0.1%	+1.06%	Add
18	VB	Vanguard Small-cap ETF	+0.1%	+16.85%	Add
19	CAT	Caterpillar INC	+0.1%	-2.38%	Trim
20	PII	Polaris INC	+0.1%	+0.17%	Add
21	VTI	Vanguard Total Stock Mkt ETF	0%	-4.09%	Trim
22	IP	International Paper Co	0%	—	Unchanged
23	ABBV	Abbvie INC	0%	—	Unchanged
24	VYM	Vanguard High Dvd Yield ETF	0%	-8.74%	Trim
25	XOM	Exxon Mobil CORP	0%	-3.45%	Trim
26	VOO	Vanguard S&p 500 ETF	0%	-7.96%	Trim
27	INTC	Intel CORP	0%	-0.38%	Trim
28	VO	Vanguard Mid-cap ETF	0%	-8.78%	Trim
29	T	At&t INC	0%	-1.13%	Trim
30	PG	Procter & Gamble Co/the	0%	-5.05%	Trim
31	PML	Pimco Municipal Income Fd Ii	0%	-8.92%	Trim
32	IBM	Intl Business Machines CORP	0%	-2.61%	Trim
33	GIS	General Mills INC	0%	—	Unchanged
34	NBH	Neuberger Municipal Fund INC	0%	-16.16%	Trim
35	VTV	Vanguard Value ETF	-0.1%	-11.06%	Trim
36	MMU	Western Asset Managed Munici	-0.1%	-8.89%	Trim
37	PFF	Ishares Preferred & Income S	-0.1%	-6.99%	Trim
38	VDE	Vanguard Energy ETF	-0.1%	-3.23%	Trim
39	VIG	Vanguard Dividend Apprec ETF	-0.2%	-24.25%	Trim
40	XLP	Ss Consumer Staples Sel Sect	-0.3%	-7.31%	Trim
41	✓	Invesco Financial Preferred ETF	-0.3%	-30.34%	Trim
42	✓	Blackrock Munihldgs Fd Ii In	-0.4%	-35.93%	Trim
43	BND	Vanguard Total Bond Market	-1.6%	-23.57%	Trim
44	EPD	Enterprise Products Partners	—	EXIT	Sold out
45	MFAUSD	Mfa Financial INC	—	EXIT	Sold out
46	FVD	First Trust Value Line Dvd	—	EXIT	Sold out
47	✓	Rydex ETF Trust	—	EXIT	Sold out
48	O	Realty Income CORP	—	EXIT	Sold out
49	VHT	Vanguard Health Care ETF	—	EXIT	Sold out
50	BKCCUSD	Blackrock Capital Investment	—	EXIT	Sold out