Affiance Financial, LLC — Q4 2019 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q4 2019
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	18.72%	-0.02%	+1.49%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	10.51%	—	+2.08%
3	IJR	Ishares Core S&p Small-cap E	ETF-Small Cap	8.40%	+0.10%	+6.74%
4	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	6.11%	+0.78%	+11.39%
5	XFFCX	Flaherty & Crumrine Pref INC	Stock-Other	4.82%	—	+2.67%
6	RSPS	Invesco S&p 500 Equal Weight	ETF-Large Cap & Growth	4.68%	—	-0.72%
7	VNQ	Vanguard Real Estate ETF	ETF-Other	4.30%	—	+94.79%
8	JPST	Jpmorgan Ultra-short Income	ETF-Other	2.56%	—	+4.56%
9	AAPL	Apple INC	Stock-Tech	2.25%	-0.14%	+3.44%
10	XLP	Ss Consumer Staples Sel Sect	ETF-Other	1.32%	—	-5.09%
11	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.23%	-0.01%	-0.56%
12	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	1.19%	+0.02%	-10.33%
13	MSFT	Microsoft CORP	Stock-Tech	1.19%	—	+3.69%
14	VIG	Vanguard Dividend Apprec ETF	ETF-Other	1.08%	—	—
15	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	1.05%	+0.36%	+6.08%
16	TECH	Bio-techne CORP	Stock-Healthcare	1.04%	+0.02%	—
17	EFA	Ishares Msci Eafe ETF	ETF-Other	1.03%	—	+18.78%
18	VDE	Vanguard Energy ETF	ETF-Other	1.01%	—	-19.14%
19	XMYDX	Blackrock Muniyield Fund	Stock-Other	1.00%	—	+2.48%
20	MMM	3m Co	Stock-Industrials	0.99%	+0.01%	-6.53%
21	TGT	Target CORP	Stock-Consumer Disc	0.92%	—	-0.08%
22	PML	Pimco Municipal Income Fd Ii	Stock-Other	0.87%	—	-1.86%
23	MMU	Western Asset Managed Munici	Stock-Other	0.83%	—	-0.29%
24	JNJ	Johnson & Johnson	Stock-Healthcare	0.82%	+0.04%	—
25	INTC	Intel CORP	Stock-Tech	0.81%	+0.04%	NEW
26	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.76%	—	-2.49%
27	UNH	Unitedhealth Group INC	Stock-Healthcare	0.72%	+0.09%	+8.91%
28	META	Meta Platforms Inc-class A	Stock-Comm Services	0.71%	—	+1.31%
29	VGT	Vanguard Info Tech ETF	ETF-Tech	0.69%	+0.08%	+4.37%
30	GIS	General Mills INC	Stock-Consumer Staples	0.63%	—	-0.18%
31	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	0.62%	—	+6.50%
32	VWO	Vanguard Ftse Emerging Marke	ETF-Emerging Markets	0.60%	-0.04%	+19.06%
33	JPM	Jpmorgan Chase & Co	Stock-Financials	0.54%	-0.01%	—
34	BND	Vanguard Total Bond Market	ETF-Other	0.51%	—	-18.29%
35	MDT	Medtronic plc	Stock-Healthcare	0.49%	—	-3.48%
36	VYM	Vanguard High Dvd Yield ETF	ETF-Other	0.47%	+0.05%	NEW
37	VTV	Vanguard Value ETF	ETF-Other	0.47%	+0.09%	—
38	PAYX	Paychex INC	Stock-Tech	0.46%	—	-21.29%
39	XLV	Ss Health Care Select Sector	ETF-Other	0.45%	—	-3.47%
40	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.44%	+0.05%	-6.33%
41	VZ	Verizon Communications INC	Stock-Comm Services	0.42%	—	—
42	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.39%	—	-1.56%
43	AMZN	Amazon.com INC	Stock-Consumer Disc	0.38%	-0.01%	-2.35%
44	C	Citigroup INC	Stock-Financials	0.37%	—	+0.05%
45	XOM	Exxon Mobil CORP	Stock-Energy	0.36%	-0.06%	EXIT
46	NZF	Nuveen Municipal Credit INC	Stock-Other	0.34%	—	-1.38%
47	XPMQX	Pimco Muni Income Fund Iii	Stock-Other	0.34%	—	+1.71%
48	NEAR	Ishares Sh Dba ETF Usd INC	ETF-Other	0.33%	—	-33.10%
49	IBM	Intl Business Machines CORP	Stock-Tech	0.31%	—	-10.47%
50	VB	Vanguard Small-cap ETF	ETF-Other	0.30%	+0.14%	NEW

1–50 of 141

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q4 2019, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	VNQ	Vanguard Real Estate ETF	+1.9%	+94.79%	Add
2	VTI	Vanguard Total Stock Mkt ETF	+0.5%	+11.39%	Add
3	AAPL	Apple INC	+0.4%	+3.44%	Add
4	IJR	Ishares Core S&p Small-cap E	+0.4%	+6.74%	Add
5	UNH	Unitedhealth Group INC	+0.2%	+8.91%	Add
6	EFA	Ishares Msci Eafe ETF	+0.1%	+18.78%	Add
7	VWO	Vanguard Ftse Emerging Marke	+0.1%	+19.06%	Add
8	MSFT	Microsoft CORP	+0.1%	+3.69%	Add
9	TGT	Target CORP	+0.1%	-0.08%	Trim
10	INTC	Intel CORP	+0.1%	+1.66%	Add
11	VGT	Vanguard Info Tech ETF	+0.1%	+4.37%	Add
12	VOO	Vanguard S&p 500 ETF	0%	+6.08%	Add
13	META	Meta Platforms Inc-class A	0%	+1.31%	Add
14	JPM	Jpmorgan Chase & Co	0%	—	Unchanged
15	TECH	Bio-techne CORP	0%	—	Unchanged
16	JNJ	Johnson & Johnson	0%	—	Unchanged
17	EFG	Ishares Msci Eafe Growth ETF	0%	-0.56%	Trim
18	IBM	Intl Business Machines CORP	-0.1%	-10.47%	Trim
19	SPEM	State Street Sp Ptf Em ETF	-0.1%	-57.37%	Trim
20	JPST	Jpmorgan Ultra-short Income	-0.1%	+4.56%	Add
21	NOW	Servicenow INC	-0.2%	-51.23%	Trim
22	VO	Vanguard Mid-cap ETF	-0.2%	-64.22%	Trim
23	XFFCX	Flaherty & Crumrine Pref INC	-0.2%	+2.67%	Add
24	PAYX	Paychex INC	-0.2%	-21.29%	Trim
25	MCD	Mcdonald's CORP	-0.2%	-2.49%	Trim
26	BND	Vanguard Total Bond Market	-0.2%	-18.29%	Trim
27	NEAR	Ishares Sh Dba ETF Usd INC	-0.2%	-33.10%	Trim
28	XOM	Exxon Mobil CORP	-0.3%	-36.36%	Trim
29	VDE	Vanguard Energy ETF	-0.3%	-19.14%	Trim
30	RSPS	Invesco S&p 500 Equal Weight	-0.3%	-0.72%	Trim
31	IJH	Ishares Core S&p Midcap ETF	-0.3%	+1.49%	Add
32	BSV	Vanguard Short-term Bond ETF	-0.9%	+2.08%	Add
33	WMT	Walmart INC	—	EXIT	Sold out
34	AOA	Ishares Core 80/20 Aggressiv	—	NEW	New buy
35	PEP	Pepsico INC	—	EXIT	Sold out
36	G	Genpact Limited	—	NEW	New buy
37	DHR	Danaher CORP	—	NEW	New buy
38	IPAC	Ishares Core Msci Pacific Et	—	NEW	New buy
39	USB	US Bancorp	—	EXIT	Sold out
40	WFC	Wells Fargo & Co	—	EXIT	Sold out
41	SRE	Sempra	—	NEW	New buy
42	MDLZ	Mondelez International Inc-a	—	EXIT	Sold out
43	XEL	Xcel Energy INC	—	NEW	New buy
44	VIOO	Vanguard S&p Small-cap 600 E	—	NEW	New buy
45	IVOO	Vanguard S&p Mid-cap 400 ETF	—	NEW	New buy
46	VT	Vanguard Tot World Stk ETF	—	NEW	New buy
47	IYK	Ishares US Consumer Staples	—	NEW	New buy
48	XLU	St Sr Utl Sl Se Spdr Etf-usd	—	NEW	New buy
49	VXF	Vanguard Extended Market ETF	—	NEW	New buy
50	IYM	Ishares U.s. Basic Materials	—	NEW	New buy