Affiance Financial, LLC — Q3 2017 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q3 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.56%	-0.02%	-0.69%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	11.40%	—	+8.86%
3	VNQ	Vanguard Real Estate ETF	ETF-Other	8.13%	—	+1.88%
4	XLP	Ss Consumer Staples Sel Sect	ETF-Other	7.18%	—	+1.06%
5	BND	Vanguard Total Bond Market	ETF-Other	6.10%	—	+0.20%
6	BIV	Vanguard Intermediate-term B	ETF-Other	5.85%	—	+9.88%
7	PFF	Ishares Preferred & Income S	ETF-Other	3.48%	—	-5.73%
8	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	2.13%	+0.02%	-69.85%
9	XMYDX	Blackrock Muniyield Fund	Stock-Other	2.12%	—	+9.15%
10	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	1.90%	+0.78%	+4.07%
11	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.57%	-0.01%	+5.72%
12	AAPL	Apple INC	Stock-Tech	1.53%	-0.14%	-0.15%
13	MMU	Western Asset Managed Munici	Stock-Other	1.52%	—	+13.93%
14	PML	Pimco Municipal Income Fd Ii	Stock-Other	1.49%	—	-3.82%
15	EFA	Ishares Msci Eafe ETF	ETF-Other	1.40%	—	—
16	MMM	3m Co	Stock-Industrials	1.23%	+0.01%	+0.79%
17	META	Meta Platforms Inc-class A	Stock-Comm Services	1.23%	—	+0.61%
18	JNJ	Johnson & Johnson	Stock-Healthcare	1.13%	+0.04%	+0.47%
19	GIS	General Mills INC	Stock-Consumer Staples	1.01%	—	+10.84%
20	VDE	Vanguard Energy ETF	ETF-Other	0.98%	—	-18.20%
21	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.90%	—	—
22	XOM	Exxon Mobil CORP	Stock-Energy	0.87%	-0.06%	EXIT
23	VTV	Vanguard Value ETF	ETF-Other	0.84%	+0.09%	+0.22%
24	✓	Invesco Financial Preferred ETF	ETF-Other	0.83%	—	-8.07%
25	✓	Blackrock Munihldgs Fd Ii In	Stock-Other	0.81%	—	-4.63%
26	VIG	Vanguard Dividend Apprec ETF	ETF-Other	0.71%	—	-7.77%
27	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	0.69%	+0.36%	—
28	XLV	Ss Health Care Select Sector	ETF-Other	0.67%	—	-3.86%
29	PAYX	Paychex INC	Stock-Tech	0.61%	—	—
30	INTC	Intel CORP	Stock-Tech	0.60%	+0.04%	NEW
31	TGT	Target CORP	Stock-Consumer Disc	0.60%	—	-1.59%
32	JPM	Jpmorgan Chase & Co	Stock-Financials	0.54%	-0.01%	+1.08%
33	MDT	Medtronic plc	Stock-Healthcare	0.51%	—	-0.48%
34	C	Citigroup INC	Stock-Financials	0.51%	—	—
35	VGT	Vanguard Info Tech ETF	ETF-Tech	0.51%	+0.08%	—
36	GM	General Motors Co	Stock-Consumer Disc	0.47%	—	—
37	UNH	Unitedhealth Group INC	Stock-Healthcare	0.46%	+0.09%	—
38	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.45%	+0.05%	+1.92%
39	PII	Polaris INC	Stock-Consumer Disc	0.44%	—	-3.59%
40	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.43%	—	—
41	CAT	Caterpillar INC	Stock-Industrials	0.41%	—	—
42	IYW	Ishares Ustechnology ETF	ETF-Tech	0.41%	+0.03%	—
43	VO	Vanguard Mid-cap ETF	ETF-Other	0.39%	+0.02%	-27.48%
44	KXI	Ishares Global Consumer Stap	ETF-Other	0.38%	—	—
45	MSFT	Microsoft CORP	Stock-Tech	0.37%	—	+13.96%
46	VV	Vanguard Large-cap ETF	ETF-Other	0.35%	—	—
47	MO	Altria Group INC	Stock-Consumer Staples	0.34%	—	—
48	DD	DuPont de Nemours, Inc.	Stock-Other	0.34%	—	—
49	WFC	Wells Fargo & Co	Stock-Financials	0.33%	—	+0.82%
50	VEA	Vanguard Ftse Developed ETF	ETF-Other	0.31%	-0.09%	+9.48%

1–50 of 76

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q3 2017, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	BSV	Vanguard Short-term Bond ETF	+1%	+8.86%	Add
2	BIV	Vanguard Intermediate-term B	+0.6%	+9.88%	Add
3	IJH	Ishares Core S&p Midcap ETF	+0.5%	-0.69%	Trim
4	MMU	Western Asset Managed Munici	+0.2%	+13.93%	Add
5	VNQ	Vanguard Real Estate ETF	+0.2%	+1.88%	Add
6	XMYDX	Blackrock Muniyield Fund	+0.2%	+9.15%	Add
7	EFG	Ishares Msci Eafe Growth ETF	+0.2%	+5.72%	Add
8	META	Meta Platforms Inc-class A	+0.2%	+0.61%	Add
9	VTI	Vanguard Total Stock Mkt ETF	+0.2%	+4.07%	Add
10	AAPL	Apple INC	+0.1%	-0.15%	Trim
11	BND	Vanguard Total Bond Market	+0.1%	+0.20%	Add
12	MSFT	Microsoft CORP	+0.1%	+13.96%	Add
13	EFA	Ishares Msci Eafe ETF	+0.1%	—	Unchanged
14	INTC	Intel CORP	+0.1%	—	Unchanged
15	TGT	Target CORP	+0.1%	-1.59%	Trim
16	GM	General Motors Co	+0.1%	—	Unchanged
17	CAT	Caterpillar INC	+0.1%	—	Unchanged
18	ABBV	Abbvie INC	+0.1%	-4.57%	Trim
19	C	Citigroup INC	+0.1%	—	Unchanged
20	VEA	Vanguard Ftse Developed ETF	+0.1%	+9.48%	Add
21	VGT	Vanguard Info Tech ETF	+0.1%	—	Unchanged
22	GIS	General Mills INC	+0.1%	+10.84%	Add
23	PII	Polaris INC	0%	-3.59%	Trim
24	LEA	Lear CORP	0%	—	Unchanged
25	PAYX	Paychex INC	0%	—	Unchanged
26	VTV	Vanguard Value ETF	0%	+0.22%	Add
27	JPM	Jpmorgan Chase & Co	0%	+1.08%	Add
28	XLP	Ss Consumer Staples Sel Sect	0%	+1.06%	Add
29	BRK-B	Berkshire Hathaway Inc-cl B	0%	—	Unchanged
30	GOOG	Alphabet Inc-cl C	0%	+1.92%	Add
31	IYW	Ishares Ustechnology ETF	0%	—	Unchanged
32	AMZN	Amazon.com INC	0%	+14.75%	Add
33	VOO	Vanguard S&p 500 ETF	0%	—	Unchanged
34	UNH	Unitedhealth Group INC	0%	—	Unchanged
35	KMB	Kimberly-clark CORP	0%	-3.75%	Trim
36	VIG	Vanguard Dividend Apprec ETF	0%	-7.77%	Trim
37	PML	Pimco Municipal Income Fd Ii	0%	-3.82%	Trim
38	✓	Blackrock Munihldgs Fd Ii In	0%	-4.63%	Trim
39	NBH	Neuberger Municipal Fund INC	-0.1%	-16.62%	Trim
40	MO	Altria Group INC	-0.1%	—	Unchanged
41	✓	Invesco Financial Preferred ETF	-0.1%	-8.07%	Trim
42	MDT	Medtronic plc	-0.1%	-0.48%	Trim
43	VO	Vanguard Mid-cap ETF	-0.1%	-27.48%	Trim
44	VDE	Vanguard Energy ETF	-0.1%	-18.20%	Trim
45	PFF	Ishares Preferred & Income S	-0.2%	-5.73%	Trim
46	IVV	Ishares Core S&p 500 ETF	-4.6%	-69.85%	Trim
47	DD	DuPont de Nemours, Inc.	—	NEW	New buy
48	AEP	American Electric Power Company, Inc.	—	NEW	New buy
49	UNP	Union Pacific CORP	—	NEW	New buy
50	EVLVUSD	Evine Live INC	—	EXIT	Sold out