Affiance Financial, LLC — Q1 2018 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q1 2018
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	20.21%	-0.02%	+0.69%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	15.46%	—	+6.69%
3	XLP	Ss Consumer Staples Sel Sect	ETF-Other	7.88%	—	-0.67%
4	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	4.41%	+0.78%	+54.96%
5	VNQ	Vanguard Real Estate ETF	ETF-Other	3.95%	—	-51.93%
6	XFFCX	Flaherty & Crumrine Pref INC	Stock-Other	3.45%	—	—
7	XMYDX	Blackrock Muniyield Fund	Stock-Other	2.24%	—	+11.72%
8	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	1.83%	+0.02%	-15.67%
9	MMM	3m Co	Stock-Industrials	1.81%	+0.01%	+25.85%
10	AAPL	Apple INC	Stock-Tech	1.73%	-0.14%	-3.79%
11	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.73%	-0.01%	-6.86%
12	PFF	Ishares Preferred & Income S	ETF-Other	1.54%	—	-58.94%
13	PML	Pimco Municipal Income Fd Ii	Stock-Other	1.51%	—	-2.42%
14	MMU	Western Asset Managed Munici	Stock-Other	1.49%	—	-12.38%
15	EFA	Ishares Msci Eafe ETF	ETF-Other	1.48%	—	-4.72%
16	META	Meta Platforms Inc-class A	Stock-Comm Services	1.26%	—	—
17	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.98%	—	—
18	JNJ	Johnson & Johnson	Stock-Healthcare	0.97%	+0.04%	-17.58%
19	GIS	General Mills INC	Stock-Consumer Staples	0.96%	—	+4.31%
20	VDE	Vanguard Energy ETF	ETF-Other	0.94%	—	-9.95%
21	BND	Vanguard Total Bond Market	ETF-Other	0.85%	—	-88.52%
22	VTV	Vanguard Value ETF	ETF-Other	0.85%	+0.09%	-8.91%
23	XOM	Exxon Mobil CORP	Stock-Energy	0.83%	-0.06%	EXIT
24	INTC	Intel CORP	Stock-Tech	0.83%	+0.04%	NEW
25	TGT	Target CORP	Stock-Consumer Disc	0.77%	—	—
26	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	0.76%	+0.36%	-7.47%
27	PAYX	Paychex INC	Stock-Tech	0.69%	—	—
28	JPM	Jpmorgan Chase & Co	Stock-Financials	0.67%	-0.01%	-2.00%
29	VIG	Vanguard Dividend Apprec ETF	ETF-Other	0.67%	—	-5.10%
30	IBM	Intl Business Machines CORP	Stock-Tech	0.64%	—	+145.54%
31	VGT	Vanguard Info Tech ETF	ETF-Tech	0.62%	+0.08%	—
32	UNH	Unitedhealth Group INC	Stock-Healthcare	0.61%	+0.09%	+10.29%
33	✓	Blackrock Munihldgs Fd Ii In	Stock-Other	0.61%	—	-19.18%
34	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.58%	+0.05%	—
35	XLV	Ss Health Care Select Sector	ETF-Other	0.57%	—	—
36	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	0.53%	—	+144.06%
37	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.52%	—	—
38	C	Citigroup INC	Stock-Financials	0.51%	—	-0.46%
39	AMZN	Amazon.com INC	Stock-Consumer Disc	0.49%	-0.01%	+37.86%
40	✓	Invesco Financial Preferred ETF	ETF-Other	0.49%	—	-43.45%
41	MDT	Medtronic plc	Stock-Healthcare	0.48%	—	-17.50%
42	GM	General Motors Co	Stock-Consumer Disc	0.47%	—	—
43	MSFT	Microsoft CORP	Stock-Tech	0.46%	—	-1.45%
44	VB	Vanguard Small-cap ETF	ETF-Other	0.46%	+0.14%	NEW
45	CAT	Caterpillar INC	Stock-Industrials	0.40%	—	-24.22%
46	BIV	Vanguard Intermediate-term B	ETF-Other	0.39%	—	-94.37%
47	VO	Vanguard Mid-cap ETF	ETF-Other	0.38%	+0.02%	-12.39%
48	BA	Boeing Co/the	Stock-Industrials	0.37%	—	—
49	ABBV	Abbvie INC	Stock-Healthcare	0.35%	—	—
50	VEA	Vanguard Ftse Developed ETF	ETF-Other	0.34%	-0.09%	-9.55%

1–50 of 77

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q1 2018, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	BSV	Vanguard Short-term Bond ETF	+3.2%	+6.69%	Add
2	IJH	Ishares Core S&p Midcap ETF	+3.2%	+0.69%	Add
3	VTI	Vanguard Total Stock Mkt ETF	+2%	+54.96%	Add
4	XLP	Ss Consumer Staples Sel Sect	+0.7%	-0.67%	Trim
5	MMM	3m Co	+0.5%	+25.85%	Add
6	IBM	Intl Business Machines CORP	+0.4%	+145.54%	Add
7	BNDX	Vanguard Total Intl Bond ETF	+0.4%	+144.06%	Add
8	AMZN	Amazon.com INC	+0.3%	+37.86%	Add
9	AAPL	Apple INC	+0.2%	-3.79%	Trim
10	VB	Vanguard Small-cap ETF	+0.2%	+44.89%	Add
11	EFG	Ishares Msci Eafe Growth ETF	+0.2%	-6.86%	Trim
12	EFA	Ishares Msci Eafe ETF	+0.2%	-4.72%	Trim
13	PML	Pimco Municipal Income Fd Ii	+0.2%	-2.42%	Trim
14	META	Meta Platforms Inc-class A	+0.1%	—	Unchanged
15	MCD	Mcdonald's CORP	+0.1%	—	Unchanged
16	XOM	Exxon Mobil CORP	+0.1%	+2.71%	Add
17	VOO	Vanguard S&p 500 ETF	+0.1%	-7.47%	Trim
18	PAYX	Paychex INC	+0.1%	—	Unchanged
19	VTV	Vanguard Value ETF	0%	-8.91%	Trim
20	VDE	Vanguard Energy ETF	—	-9.95%	Trim
21	IVV	Ishares Core S&p 500 ETF	0%	-15.67%	Trim
22	MDT	Medtronic plc	0%	-17.50%	Trim
23	PII	Polaris INC	0%	-15.46%	Trim
24	VV	Vanguard Large-cap ETF	0%	-18.66%	Trim
25	MO	Altria Group INC	0%	-15.99%	Trim
26	WFC	Wells Fargo & Co	0%	-16.65%	Trim
27	MMU	Western Asset Managed Munici	-0.1%	-12.38%	Trim
28	DD	DuPont de Nemours, Inc.	-0.1%	-19.71%	Trim
29	GIS	General Mills INC	-0.1%	+4.31%	Add
30	✓	Blackrock Munihldgs Fd Ii In	-0.1%	-19.18%	Trim
31	IYW	Ishares Ustechnology ETF	-0.1%	-32.65%	Trim
32	KXI	Ishares Global Consumer Stap	-0.1%	-28.11%	Trim
33	CAT	Caterpillar INC	-0.1%	-24.22%	Trim
34	NBH	Neuberger Municipal Fund INC	-0.1%	-43.07%	Trim
35	JNJ	Johnson & Johnson	-0.1%	-17.58%	Trim
36	✓	Invesco Financial Preferred ETF	-0.2%	-43.45%	Trim
37	PFF	Ishares Preferred & Income S	-1.6%	-58.94%	Trim
38	VNQ	Vanguard Real Estate ETF	-3.6%	-51.93%	Trim
39	BND	Vanguard Total Bond Market	-5.5%	-88.52%	Trim
40	BIV	Vanguard Intermediate-term B	-5.6%	-94.37%	Trim
41	XFFCX	Flaherty & Crumrine Pref INC	—	NEW	New buy
42	BA	Boeing Co/the	—	NEW	New buy
43	IJT	Ishares S&p Small-cap 600 Gr	—	EXIT	Sold out
44	HON	Honeywell International INC	—	NEW	New buy
45	VWO	Vanguard Ftse Emerging Marke	—	EXIT	Sold out
46	VNLA	Janus Henderson Short Durati	—	NEW	New buy
47	PEP	Pepsico INC	—	EXIT	Sold out
48	WEP	Magellan Midstream Partners	—	EXIT	Sold out
49	KMB	Kimberly-clark CORP	—	EXIT	Sold out
50	APU	Amerigas Partners LP	—	EXIT	Sold out