Affiance Financial, LLC Top Holdings and 13F Report (2023)

About Affiance Financial, LLC

Investment Activity

Affiance Financial, LLC has $369.12 million in total holdings as of December 31, 2022.
Affiance Financial, LLC owns shares of 95 different stocks, but just 19 companies or ETFs make up 80% of its holdings.
Approximately 10.46% of the portfolio was purchased this quarter.
About 5.17% of the portfolio was sold this quarter.
This quarter, Affiance Financial, LLC has purchased 95 new stocks and bought additional shares in 32 stocks.
Affiance Financial, LLC sold shares of 32 stocks and completely divested from 7 stocks this quarter.

Largest Holdings

Vanguard S&P 500 ETF: $73,589,882
iShares Core U.S. Aggregate Bond ETF: $51,189,830
Vanguard Total Stock Market ETF: $40,221,583
Vanguard FTSE Developed Markets ETF: $22,531,849
iShares Core MSCI EAFE ETF: $14,959,855

Largest New Holdings this Quarter

NVIDIA: $993,012 Holding
Netflix: $227,141 Holding
iShares Global 100 ETF: $218,250 Holding
Wells Fargo & Company: $213,467 Holding
Salesforce: $203,899 Holding

Largest Purchases this Quarter

iShares Core S&P Mid-Cap ETF: 142,004 shares (about $8.63M)
Vanguard Total Stock Market ETF: 31,281 shares (about $8.13M)
Health Care Select Sector SPDR Fund: 28,671 shares (about $4.24M)
iShares Core MSCI EAFE ETF: 47,067 shares (about $3.49M)
iShares Core U.S. Aggregate Bond ETF: 33,680 shares (about $3.30M)

Largest Sales this Quarter

iShares Core S&P Small-Cap ETF: 36,329 shares (about $4.02M)
Vanguard Real Estate ETF: 33,587 shares (about $2.90M)
Invesco S&P 500 Equal Weight Consumer Staples ETF: 76,520 shares (about $2.52M)
Vanguard Mid-Cap ETF: 3,470 shares (about $867.01K)
iShares ESG Screened S&P Mid-Cap ETF: 17,685 shares (about $726.50K)

Sector Allocation Over Time

Selling

Neutral

Buying

Latest 13F Holdings and Changes Since Previous Quarterly Filing

Issuer Name	Holdings Value	Approximate Purchase/Sale	Change in Shares	Shares Held	% of Portfolio	Sector
VOO Vanguard S&P 500 ETF	$73,589,882	$1,817,527 ▲	2.5%	153,089	19.9%	ETF
AGG iShares Core U.S. Aggregate Bond ETF	$51,189,830	$3,298,620 ▲	6.9%	522,665	13.9%	Finance
VTI Vanguard Total Stock Market ETF	$40,221,583	$8,129,980 ▲	25.3%	154,757	10.9%	ETF
VEA Vanguard FTSE Developed Markets ETF	$22,531,849	$1,036,312 ▲	4.8%	449,110	6.1%	ETF
IEFA iShares Core MSCI EAFE ETF	$14,959,855	$3,493,330 ▲	30.5%	201,560	4.1%	ETF
IJH iShares Core S&P Mid-Cap ETF	$11,874,126	$8,625,325 ▲	265.5%	195,491	3.2%	ETF
VXF Vanguard Extended Market ETF	$10,969,098	$585,402 ▲	5.6%	62,584	3.0%	ETF
IWF iShares Russell 1000 Growth ETF	$8,871,156	$547,032 ▲	6.6%	26,320	2.4%	ETF
AAPL Apple	$8,794,674	$213,153 ▲	2.5%	51,286	2.4%	Computer and Technology
VTV Vanguard Value ETF	$8,571,040	$474,088 ▲	5.9%	52,628	2.3%	ETF
VWO Vanguard FTSE Emerging Markets ETF	$6,722,840	$394,100 ▲	6.2%	160,949	1.8%	ETF
IVV iShares Core S&P 500 ETF	$5,430,192	$158,258 ▲	3.0%	10,328	1.5%	ETF
RSPS Invesco S&P 500 Equal Weight Consumer Staples ETF	$5,425,658	$2,519,809 ▼	-31.7%	164,763	1.5%	ETF
XLV Health Care Select Sector SPDR Fund	$5,200,153	$4,235,613 ▲	439.1%	35,200	1.4%	ETF
MSFT Microsoft	$4,910,205	$29,032 ▲	0.6%	11,670	1.3%	Computer and Technology
SPEM SPDR Portfolio Emerging Markets ETF	$4,646,579	$723,257 ▲	18.4%	128,394	1.3%	ETF
IJR iShares Core S&P Small-Cap ETF	$4,218,420	$4,015,169 ▼	-48.8%	38,168	1.1%	ETF
UNH UnitedHealth Group	$3,938,601	$57,389 ▲	1.5%	7,961	1.1%	Medical
EFG iShares MSCI EAFE Growth ETF	$3,548,788	$524,658 ▼	-12.9%	34,192	1.0%	ETF
SPY SPDR S&P 500 ETF Trust	$2,859,624	$26,677 ▲	0.9%	5,467	0.8%	Finance
VT Vanguard Total World Stock ETF	$2,825,485	$116,688 ▲	4.3%	25,570	0.8%	ETF
CGDV Capital Group Dividend Value ETF	$2,775,598	$150,313 ▼	-5.1%	85,403	0.8%	ETF
PIMCO ETF TR	$2,597,985	$913,272 ▲	54.2%	28,282	0.7%	ACTIVE BD ETF
META Meta Platforms	$2,581,829	$548,220 ▼	-17.5%	5,317	0.7%	Computer and Technology
VIG Vanguard Dividend Appreciation ETF	$2,538,462	$26,844 ▼	-1.0%	13,901	0.7%	ETF
CGCP Capital Group Core Plus Income ETF	$2,284,676	$831,357 ▲	57.2%	101,722	0.6%	ETF
TGT Target	$2,222,391	$52,631 ▼	-2.3%	12,541	0.6%	Retail/Wholesale
GOOG Alphabet	$2,198,330	$29,691 ▼	-1.3%	14,438	0.6%	Computer and Technology
AMZN Amazon.com	$1,928,262	$78,646 ▲	4.3%	10,690	0.5%	Retail/Wholesale
MCD McDonald's	$1,898,369	$112,780 ▼	-5.6%	6,733	0.5%	Retail/Wholesale
IWD iShares Russell 1000 Value ETF	$1,863,640		0.0%	10,405	0.5%	ETF
ESGD iShares ESG Aware MSCI EAFE ETF	$1,832,736	$86,303 ▼	-4.5%	22,935	0.5%	Manufacturing
XLP Consumer Staples Select Sector SPDR Fund	$1,750,095	$80,254 ▼	-4.4%	22,919	0.5%	ETF
VO Vanguard Mid-Cap ETF	$1,640,831	$867,014 ▼	-34.6%	6,567	0.4%	ETF
BRK.B Berkshire Hathaway	$1,613,220	$117,753 ▲	7.9%	3,836	0.4%	Finance
TECH Bio-Techne	$1,437,786	$116,284 ▼	-7.5%	20,426	0.4%	Medical
JPM JPMorgan Chase & Co.	$1,431,744		0.0%	7,148	0.4%	Finance
LLY Eli Lilly and Company	$1,431,446	$3,890 ▲	0.3%	1,840	0.4%	Medical
GOOGL Alphabet	$1,411,196	$60,372 ▲	4.5%	9,350	0.4%	Computer and Technology
ESGE iShares ESG Aware MSCI EM ETF	$1,375,028	$163,954 ▲	13.5%	42,663	0.4%	Manufacturing
EFA iShares MSCI EAFE ETF	$1,363,450	$10,621 ▲	0.8%	17,073	0.4%	Finance
VGT Vanguard Information Technology ETF	$1,328,678		0.0%	2,534	0.4%	ETF
QQQ Invesco QQQ	$1,209,039	$258,858 ▼	-17.6%	2,723	0.3%	Finance
EEM iShares MSCI Emerging Markets ETF	$1,153,609	$4,847 ▼	-0.4%	28,082	0.3%	Finance
IXC iShares Global Energy ETF	$1,140,606		0.0%	26,556	0.3%	ETF
MMM 3M	$1,131,622	$3,718 ▼	-0.3%	11,567	0.3%	Multi-Sector Conglomerates
JPST JPMorgan Ultra-Short Income ETF	$1,018,343	$68,814 ▼	-6.3%	20,185	0.3%	ETF
GIS General Mills	$1,001,622	$29,527 ▼	-2.9%	14,315	0.3%	Consumer Staples
NVDA NVIDIA	$993,012	$993,012 ▲	New Holding	1,099	0.3%	Computer and Technology
MAR Marriott International	$927,996		0.0%	3,678	0.3%	Consumer Discretionary
BNDX Vanguard Total International Bond ETF	$899,865	$155,495 ▼	-14.7%	18,293	0.2%	ETF
JNJ Johnson & Johnson	$883,537	$1,107 ▼	-0.1%	5,585	0.2%	Medical
IWP iShares Russell Mid-Cap Growth ETF	$824,319	$66,429 ▼	-7.5%	7,222	0.2%	ETF
XJH iShares ESG Screened S&P Mid-Cap ETF	$813,179	$726,500 ▼	-47.2%	19,795	0.2%	ETF
NOW ServiceNow	$763,925	$289,712 ▼	-27.5%	1,002	0.2%	Computer and Technology
IYW iShares U.S. Technology ETF	$733,916		0.0%	5,434	0.2%	Manufacturing
HON Honeywell International	$683,072	$133,413 ▲	24.3%	3,328	0.2%	Multi-Sector Conglomerates
PRVA Privia Health Group	$680,596		0.0%	34,742	0.2%	Medical
TSLA Tesla	$639,172	$547,058 ▼	-46.1%	3,636	0.2%	Auto/Tires/Trucks
ECL Ecolab	$586,381	$173,212 ▼	-22.8%	2,539	0.2%	Basic Materials
VNQ Vanguard Real Estate ETF	$562,508	$2,904,821 ▼	-83.8%	6,504	0.2%	ETF
DEO Diageo	$550,763		0.0%	3,702	0.1%	Consumer Staples
ABBV AbbVie	$549,760		0.0%	3,019	0.1%	Medical
PRU Prudential Financial	$548,161	$822 ▲	0.2%	4,669	0.1%	Finance
DIS Walt Disney	$527,223	$6,853 ▼	-1.3%	4,308	0.1%	Consumer Discretionary
IVOO Vanguard S&P Mid-Cap 400 ETF	$518,140		0.0%	5,030	0.1%	ETF
ORCL Oracle	$476,439	$37,683 ▼	-7.3%	3,793	0.1%	Computer and Technology
LMT Lockheed Martin	$454,870		0.0%	1,000	0.1%	Aerospace
UNP Union Pacific	$426,197		0.0%	1,733	0.1%	Transportation
COST Costco Wholesale	$403,679	$5,128 ▲	1.3%	551	0.1%	Retail/Wholesale
ABT Abbott Laboratories	$394,173		0.0%	3,468	0.1%	Medical
VGLT Vanguard Long-Term Treasury Index ETF	$384,171		0.0%	6,485	0.1%	ETF
VIOO Vanguard S&P Small-Cap 600 ETF	$376,058		0.0%	3,705	0.1%	ETF
XOM Exxon Mobil	$371,922		0.0%	3,199	0.1%	Oils/Energy
SCHG Schwab U.S. Large-Cap Growth ETF	$366,522		0.0%	3,953	0.1%	ETF
XEL Xcel Energy	$362,933		0.0%	6,752	0.1%	Utilities
IVE iShares S&P 500 Value ETF	$358,115		0.0%	1,917	0.1%	ETF
INTC Intel	$333,509	$36,973 ▼	-10.0%	7,550	0.1%	Computer and Technology
PG Procter & Gamble	$331,703	$21,746 ▼	-6.2%	2,044	0.1%	Consumer Staples
DHR Danaher	$330,855		0.0%	1,624	0.1%	Multi-Sector Conglomerates
NOC Northrop Grumman	$313,044		0.0%	654	0.1%	Aerospace
KXI iShares Global Consumer Staples ETF	$303,990		0.0%	4,981	0.1%	ETF
AOR iShares Core Growth Allocation ETF	$292,132	$1,225 ▲	0.4%	5,247	0.1%	ETF
MDT Medtronic	$276,527	$107,282 ▼	-28.0%	3,173	0.1%	Medical
MPW Medical Properties Trust	$264,709		0.0%	56,321	0.1%	Finance
V Visa	$252,567	$8,093 ▲	3.3%	905	0.1%	Business Services
BA Boeing	$252,238		0.0%	1,307	0.1%	Aerospace
IYK iShares U.S. Consumer Staples ETF	$248,540	$165,693 ▲	200.0%	3,675	0.1%	ETF
SPLG SPDR Portfolio S&P 500 ETF	$227,784	$115,061 ▼	-33.6%	3,702	0.1%	ETF
NFLX Netflix	$227,141	$227,141 ▲	New Holding	374	0.1%	Consumer Discretionary
IOO iShares Global 100 ETF	$218,250	$218,250 ▲	New Holding	2,441	0.1%	ETF
WFC Wells Fargo & Company	$213,467	$213,467 ▲	New Holding	3,683	0.1%	Finance
CRM Salesforce	$203,899	$203,899 ▲	New Holding	677	0.1%	Computer and Technology
PNR Pentair	$200,869	$200,869 ▲	New Holding	2,351	0.1%	Industrial Products
BTZ BlackRock Credit Allocation Income Trust	$106,900	$106,900 ▲	New Holding	10,000	0.0%	Financial Services
TLT iShares 20+ Year Treasury Bond ETF	$0	$1,574,041 ▼	-100.0%	0	0.0%	ETF
XLK Technology Select Sector SPDR Fund	$0	$1,182,405 ▼	-100.0%	0	0.0%	ETF
DAL Delta Air Lines	$0	$550,072 ▼	-100.0%	0	0.0%	Transportation
DFS Discover Financial Services	$0	$408,030 ▼	-100.0%	0	0.0%	Finance
T AT&T	$0	$252,153 ▼	-100.0%	0	0.0%	Computer and Technology