Affiance Financial, LLC — Q3 2018 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q3 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	22.79%	-0.02%	+30.52%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	12.17%	—	-0.68%
3	IJR	Ishares Core S&p Small-cap E	ETF-Small Cap	5.36%	+0.10%	+2162.44%
4	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	5.31%	+0.78%	+3.27%
5	RSPS	Invesco S&p 500 Equal Weight	ETF-Large Cap & Growth	4.39%	—	+1.39%
6	XFFCX	Flaherty & Crumrine Pref INC	Stock-Other	4.03%	—	+1.90%
7	VNQ	Vanguard Real Estate ETF	ETF-Other	2.17%	—	-10.41%
8	MMM	3m Co	Stock-Industrials	2.14%	+0.01%	+1.43%
9	AAPL	Apple INC	Stock-Tech	1.75%	-0.14%	+0.94%
10	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	1.65%	+0.02%	-3.91%
11	XLP	Ss Consumer Staples Sel Sect	ETF-Other	1.61%	—	-7.36%
12	XMYDX	Blackrock Muniyield Fund	Stock-Other	1.43%	—	+1.25%
13	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.43%	-0.01%	-0.61%
14	TECH	Bio-techne CORP	Stock-Healthcare	1.34%	+0.02%	—
15	MMU	Western Asset Managed Munici	Stock-Other	1.25%	—	+4.65%
16	JNJ	Johnson & Johnson	Stock-Healthcare	1.11%	+0.04%	+8.46%
17	PML	Pimco Municipal Income Fd Ii	Stock-Other	1.11%	—	-1.15%
18	MSFT	Microsoft CORP	Stock-Tech	1.07%	—	-0.92%
19	EFA	Ishares Msci Eafe ETF	ETF-Other	1.06%	—	-1.66%
20	VDE	Vanguard Energy ETF	ETF-Other	0.90%	—	-2.74%
21	NEAR	Ishares Sh Dba ETF Usd INC	ETF-Other	0.84%	—	+68.49%
22	VEA	Vanguard Ftse Developed ETF	ETF-Other	0.81%	-0.09%	+4.40%
23	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.80%	—	+0.85%
24	GIS	General Mills INC	Stock-Consumer Staples	0.76%	—	+9.76%
25	INTC	Intel CORP	Stock-Tech	0.75%	+0.04%	NEW
26	XOM	Exxon Mobil CORP	Stock-Energy	0.73%	-0.06%	EXIT
27	TGT	Target CORP	Stock-Consumer Disc	0.73%	—	+0.87%
28	PAYX	Paychex INC	Stock-Tech	0.69%	—	—
29	META	Meta Platforms Inc-class A	Stock-Comm Services	0.68%	—	+19.91%
30	VTV	Vanguard Value ETF	ETF-Other	0.67%	+0.09%	-0.95%
31	BND	Vanguard Total Bond Market	ETF-Other	0.66%	—	-2.30%
32	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	0.64%	+0.36%	+0.47%
33	UNH	Unitedhealth Group INC	Stock-Healthcare	0.62%	+0.09%	+5.76%
34	VIG	Vanguard Dividend Apprec ETF	ETF-Other	0.61%	—	—
35	MDT	Medtronic plc	Stock-Healthcare	0.57%	—	+8.85%
36	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.56%	—	+5.26%
37	XLV	Ss Health Care Select Sector	ETF-Other	0.55%	—	—
38	VYM	Vanguard High Dvd Yield ETF	ETF-Other	0.52%	+0.05%	NEW
39	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.52%	+0.05%	+0.91%
40	JPM	Jpmorgan Chase & Co	Stock-Financials	0.52%	-0.01%	-1.06%
41	VGT	Vanguard Info Tech ETF	ETF-Tech	0.51%	+0.08%	—
42	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	0.51%	—	+10.46%
43	AMZN	Amazon.com INC	Stock-Consumer Disc	0.51%	-0.01%	-2.30%
44	VWO	Vanguard Ftse Emerging Marke	ETF-Emerging Markets	0.50%	-0.04%	+8.40%
45	IBM	Intl Business Machines CORP	Stock-Tech	0.48%	—	—
46	VZ	Verizon Communications INC	Stock-Comm Services	0.43%	—	+9.51%
47	VB	Vanguard Small-cap ETF	ETF-Other	0.42%	+0.14%	NEW
48	C	Citigroup INC	Stock-Financials	0.41%	—	—
49	✓	Blackrock Munihldgs Fd Ii In	Stock-Other	0.37%	—	-4.33%
50	GM	General Motors Co	Stock-Consumer Disc	0.36%	—	+0.07%

1–50 of 89

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q3 2018, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	IJR	Ishares Core S&p Small-cap E	+5.1%	+2162.44%	Add
2	IJH	Ishares Core S&p Midcap ETF	+3.2%	+30.52%	Add
3	NEAR	Ishares Sh Dba ETF Usd INC	+0.3%	+68.49%	Add
4	TECH	Bio-techne CORP	+0.2%	—	Unchanged
5	AAPL	Apple INC	+0.1%	+0.94%	Add
6	JNJ	Johnson & Johnson	+0.1%	+8.46%	Add
7	MDT	Medtronic plc	0%	+8.85%	Add
8	BRK-B	Berkshire Hathaway Inc-cl B	0%	+5.26%	Add
9	TGT	Target CORP	0%	+0.87%	Add
10	ABT	Abbott Laboratories	0%	—	Unchanged
11	UNH	Unitedhealth Group INC	—	+5.76%	Add
12	AMZN	Amazon.com INC	—	-2.30%	Trim
13	VZ	Verizon Communications INC	—	+9.51%	Add
14	HON	Honeywell International INC	—	—	Unchanged
15	MSFT	Microsoft CORP	0%	-0.92%	Trim
16	XLV	Ss Health Care Select Sector	0%	—	Unchanged
17	CAT	Caterpillar INC	0%	—	Unchanged
18	VGT	Vanguard Info Tech ETF	0%	—	Unchanged
19	BA	Boeing Co/the	0%	—	Unchanged
20	BNDX	Vanguard Total Intl Bond ETF	0%	+10.46%	Add
21	IBM	Intl Business Machines CORP	0%	—	Unchanged
22	C	Citigroup INC	0%	—	Unchanged
23	VIG	Vanguard Dividend Apprec ETF	0%	—	Unchanged
24	GOOG	Alphabet Inc-cl C	0%	+0.91%	Add
25	JPM	Jpmorgan Chase & Co	0%	-1.06%	Trim
26	PAYX	Paychex INC	-0.1%	—	Unchanged
27	VOO	Vanguard S&p 500 ETF	-0.1%	+0.47%	Add
28	VWO	Vanguard Ftse Emerging Marke	-0.1%	+8.40%	Add
29	MCD	Mcdonald's CORP	-0.1%	+0.85%	Add
30	VTV	Vanguard Value ETF	-0.1%	-0.95%	Trim
31	GIS	General Mills INC	-0.1%	+9.76%	Add
32	PII	Polaris INC	-0.1%	+0.18%	Add
33	VEA	Vanguard Ftse Developed ETF	-0.1%	+4.40%	Add
34	XOM	Exxon Mobil CORP	-0.1%	+0.98%	Add
35	✓	Blackrock Munihldgs Fd Ii In	-0.1%	-4.33%	Trim
36	GM	General Motors Co	-0.1%	+0.07%	Add
37	MMM	3m Co	-0.2%	+1.43%	Add
38	PFF	Ishares Preferred & Income S	-0.2%	-18.67%	Trim
39	CVX	Chevron CORP	-0.2%	-42.70%	Trim
40	IVV	Ishares Core S&p 500 ETF	-0.2%	-3.91%	Trim
41	VTI	Vanguard Total Stock Mkt ETF	-0.3%	+3.27%	Add
42	XLP	Ss Consumer Staples Sel Sect	-0.3%	-7.36%	Trim
43	RSPS	Invesco S&p 500 Equal Weight	-0.5%	+1.39%	Add
44	VNQ	Vanguard Real Estate ETF	-0.7%	-10.41%	Trim
45	XFFCX	Flaherty & Crumrine Pref INC	-0.7%	+1.90%	Add
46	BSV	Vanguard Short-term Bond ETF	-2.1%	-0.68%	Trim
47	ECL	Ecolab INC	—	NEW	New buy
48	LEA	Lear CORP	—	EXIT	Sold out
49	XXI	Twenty One Capital, Inc.	—	EXIT	Sold out
50	PRU	Prudential Financial INC	—	NEW	New buy