Affiance Financial, LLC — Q1 2020 13F Holdings

Name: Affiance Financial, LLC — 13F Holdings, Q1 2020
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	17.79%	-0.02%	+8.78%
2	BSV	Vanguard Short-term Bond ETF	ETF-Other	9.13%	—	-31.87%
3	VTI	Vanguard Total Stock Mkt ETF	ETF-Other	6.88%	+0.78%	+14.40%
4	SMLV	Ss Spdr US Sc Low Vol Idx	ETF-Other	6.06%	—	—
5	RSPS	Invesco S&p 500 Equal Weight	ETF-Large Cap & Growth	4.98%	—	+0.45%
6	XFFCX	Flaherty & Crumrine Pref INC	Stock-Other	4.66%	—	+0.41%
7	VNQ	Vanguard Real Estate ETF	ETF-Other	4.40%	—	+8.69%
8	MSFT	Microsoft CORP	Stock-Tech	2.78%	—	+87.16%
9	IJR	Ishares Core S&p Small-cap E	ETF-Small Cap	2.58%	+0.10%	-63.35%
10	AAPL	Apple INC	Stock-Tech	2.47%	-0.14%	+1.09%
11	PTON	Peloton Interactive Inc-a	Stock-Consumer Disc	2.24%	—	—
12	JPST	Jpmorgan Ultra-short Income	ETF-Other	2.05%	—	-35.02%
13	XLP	Ss Consumer Staples Sel Sect	ETF-Other	1.31%	—	-8.66%
14	EFG	Ishares Msci Eafe Growth ETF	ETF-Other	1.20%	-0.01%	-5.19%
15	IVV	Ishares Core S&p 500 ETF	ETF-Large Cap & Growth	1.19%	+0.02%	+0.04%
16	MMM	3m Co	Stock-Industrials	1.14%	+0.01%	+19.08%
17	VIG	Vanguard Dividend Apprec ETF	ETF-Other	1.12%	—	+0.08%
18	XMYDX	Blackrock Muniyield Fund	Stock-Other	1.12%	—	+3.77%
19	TECH	Bio-techne CORP	Stock-Healthcare	1.00%	+0.02%	-10.87%
20	EFA	Ishares Msci Eafe ETF	ETF-Other	0.97%	—	-2.50%
21	JNJ	Johnson & Johnson	Stock-Healthcare	0.92%	+0.04%	—
22	MMU	Western Asset Managed Munici	Stock-Other	0.90%	—	-3.86%
23	VWO	Vanguard Ftse Emerging Marke	ETF-Emerging Markets	0.86%	-0.04%	+51.79%
24	TGT	Target CORP	Stock-Consumer Disc	0.84%	—	—
25	VOO	Vanguard S&p 500 ETF	ETF-Large Cap & Growth	0.81%	+0.36%	-23.31%
26	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	0.80%	—	+2.68%
27	MCD	Mcdonald's CORP	Stock-Consumer Disc	0.80%	—	—
28	PML	Pimco Municipal Income Fd Ii	Stock-Other	0.78%	—	-9.46%
29	GIS	General Mills INC	Stock-Consumer Staples	0.76%	—	-1.32%
30	META	Meta Platforms Inc-class A	Stock-Comm Services	0.75%	—	+4.86%
31	INTC	Intel CORP	Stock-Tech	0.73%	+0.04%	NEW
32	VGT	Vanguard Info Tech ETF	ETF-Tech	0.71%	+0.08%	-4.19%
33	BND	Vanguard Total Bond Market	ETF-Other	0.67%	—	+3.63%
34	UNH	Unitedhealth Group INC	Stock-Healthcare	0.66%	+0.09%	-12.83%
35	AMZN	Amazon.com INC	Stock-Consumer Disc	0.57%	-0.01%	+13.64%
36	VDE	Vanguard Energy ETF	ETF-Other	0.57%	—	-4.32%
37	GOOG	Alphabet Inc-cl C	Stock-Comm Services	0.49%	+0.05%	+2.53%
38	MDT	Medtronic plc	Stock-Healthcare	0.48%	—	—
39	XLV	Ss Health Care Select Sector	ETF-Other	0.48%	—	—
40	JPM	Jpmorgan Chase & Co	Stock-Financials	0.43%	-0.01%	—
41	BRK-B	Berkshire Hathaway Inc-cl B	Stock-Other	0.41%	—	+2.31%
42	VT	Vanguard Tot World Stk ETF	ETF-Other	0.37%	—	+276.13%
43	VZ	Verizon Communications INC	Stock-Comm Services	0.37%	—	-20.91%
44	VGLT	Vanguard Long-term Treasury	ETF-Gov Bonds	0.37%	—	—
45	NZF	Nuveen Municipal Credit INC	Stock-Other	0.35%	—	-3.84%
46	IBM	Intl Business Machines CORP	Stock-Tech	0.32%	—	—
47	NEAR	Ishares Sh Dba ETF Usd INC	ETF-Other	0.31%	—	-22.20%
48	XPMQX	Pimco Muni Income Fund Iii	Stock-Other	0.31%	—	-12.94%
49	GOOGL	Alphabet Inc-cl A	Stock-Comm Services	0.30%	+0.04%	+19.87%
50	PG	Procter & Gamble Co/the	Stock-Consumer Staples	0.29%	—	—

1–50 of 135

Holding changes this quarter

Position changes disclosed by Affiance Financial, LLC for the quarter ending Q1 2020, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	MSFT	Microsoft CORP	+1.6%	+87.16%	Add
2	VTI	Vanguard Total Stock Mkt ETF	+0.8%	+14.40%	Add
3	RSPS	Invesco S&p 500 Equal Weight	+0.3%	+0.45%	Add
4	VT	Vanguard Tot World Stk ETF	+0.3%	+276.13%	Add
5	AAPL	Apple INC	+0.2%	+1.09%	Add
6	XMYDX	Blackrock Muniyield Fund	+0.1%	+3.77%	Add
7	VNQ	Vanguard Real Estate ETF	+0.1%	+8.69%	Add
8	MMU	Western Asset Managed Munici	+0.1%	-3.86%	Trim
9	VIG	Vanguard Dividend Apprec ETF	0%	+0.08%	Add
10	MCD	Mcdonald's CORP	0%	—	Unchanged
11	VGT	Vanguard Info Tech ETF	0%	-4.19%	Trim
12	IVV	Ishares Core S&p 500 ETF	—	+0.04%	Add
13	XLP	Ss Consumer Staples Sel Sect	0%	-8.66%	Trim
14	EFG	Ishares Msci Eafe Growth ETF	0%	-5.19%	Trim
15	TECH	Bio-techne CORP	0%	-10.87%	Trim
16	VZ	Verizon Communications INC	-0.1%	-20.91%	Trim
17	EFA	Ishares Msci Eafe ETF	-0.1%	-2.50%	Trim
18	UNH	Unitedhealth Group INC	-0.1%	-12.83%	Trim
19	TGT	Target CORP	-0.1%	—	Unchanged
20	INTC	Intel CORP	-0.1%	-20.41%	Trim
21	PML	Pimco Municipal Income Fd Ii	-0.1%	-9.46%	Trim
22	JPM	Jpmorgan Chase & Co	-0.1%	—	Unchanged
23	C	Citigroup INC	-0.1%	-7.95%	Trim
24	XFFCX	Flaherty & Crumrine Pref INC	-0.2%	+0.41%	Add
25	VTV	Vanguard Value ETF	-0.2%	-36.73%	Trim
26	VYM	Vanguard High Dvd Yield ETF	-0.2%	-43.50%	Trim
27	VOO	Vanguard S&p 500 ETF	-0.2%	-23.31%	Trim
28	VDE	Vanguard Energy ETF	-0.4%	-4.32%	Trim
29	JPST	Jpmorgan Ultra-short Income	-0.5%	-35.02%	Trim
30	IJH	Ishares Core S&p Midcap ETF	-0.9%	+8.78%	Add
31	BSV	Vanguard Short-term Bond ETF	-1.4%	-31.87%	Trim
32	IJR	Ishares Core S&p Small-cap E	-5.8%	-63.35%	Trim
33	SMLV	Ss Spdr US Sc Low Vol Idx	—	NEW	New buy
34	PTON	Peloton Interactive Inc-a	—	NEW	New buy
35	PAYX	Paychex INC	—	EXIT	Sold out
36	XOM	Exxon Mobil CORP	—	EXIT	Sold out
37	GM	General Motors Co	—	EXIT	Sold out
38	VV	Vanguard Large-cap ETF	—	EXIT	Sold out
39	WTRG	Essential Utilities, Inc.	—	EXIT	Sold out
40	CVX	Chevron CORP	—	EXIT	Sold out
41	MO	Altria Group INC	—	EXIT	Sold out
42	WTRG	Essential Utilities INC	—	NEW	New buy
43	IP	International Paper Co	—	EXIT	Sold out
44	BOND	Pimco Active Bond Exchange-t	—	NEW	New buy
45	G	Genpact Limited	—	EXIT	Sold out
46	NOC	Northrop Grumman CORP	—	EXIT	Sold out
47	DHR	Danaher CORP	—	EXIT	Sold out
48	IPAC	Ishares Core Msci Pacific Et	—	EXIT	Sold out
49	SRE	Sempra	—	EXIT	Sold out
50	PII	Polaris INC	—	EXIT	Sold out