13F-HR filed by Affiance Financial, LLC
Affiance Financial, LLC filed this 13F-HR for the quarter ended 2023-03-31, filed 2023-04-18, with 94 holding rows worth $188,970,251.
- Accession
- 0001085146-23-001737
- Filer
- CIK 1723681
- Filed
- 2023-04-18
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q1 2023
A holdings report, 94 entries on the cover page, a total value of $188,970,251 stated on the cover page (in dollars after the unit check, H1), rows summing to $188,970,251 with VALUE read as dollars as filed, 13F file number 028-18187. The quarter's positions are built on this report. The resolved quarter.
The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).
| Issuer as filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 200,223 | $19,361,596 | dollars as filed | |
| Vanguard Value ETF | 922908744 | SHS | 123,222 | $17,018,190 | dollars as filed | |
| IJH | 464287507 | COM | 62,468 | $15,627,058 | dollars as filed | |
| VTI | 922908769 | COM | 74,622 | $15,230,401 | dollars as filed | |
| INVESCO EXCHANGE TRADED FD T | 46137V373 | S&P500 EQL STP | 65,321 | $11,132,378 | dollars as filed | |
| Apple Inc | 037833100 | COM | 51,039 | $8,416,360 | dollars as filed | |
| Vanguard S&P 500 ETF | 922908363 | COM | 19,675 | $7,399,177 | dollars as filed | |
| Vanguard Real Estate | 922908553 | SHS | 61,442 | $5,102,147 | dollars as filed | |
| J P MORGAN EXCHANGE TRADED F | 46641Q837 | ULTRA SHRT ETF | 98,556 | $4,959,367 | dollars as filed | |
| UnitedHealth Group Inc | 91324P102 | COM | 7,857 | $3,713,375 | dollars as filed | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 8,771 | $3,605,966 | dollars as filed | |
| ISHARES MSCI EAFE GROWTH ETF | 464288885 | ETF | 38,288 | $3,586,820 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 10,362 | $2,987,554 | dollars as filed | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 19,093 | $2,907,100 | dollars as filed | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 11,365 | $2,776,810 | dollars as filed | |
| SPY | 78462F103 | SHS | 5,307 | $2,172,633 | dollars as filed | |
| Vanguard Dividend Appreciation ETF | 921908844 | SHS | 14,048 | $2,163,532 | dollars as filed | |
| TARGET CORP COM | 87612E106 | Stock | 12,969 | $2,148,055 | dollars as filed | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 21,767 | $2,004,523 | dollars as filed | |
| McDonalds Corporation | 580135101 | COM | 6,553 | $1,832,284 | dollars as filed | |
| SELECT SECTOR SPDR TR | 81369Y308 | STATE STREET CON | 23,818 | $1,779,488 | dollars as filed | |
| ISHARES TR | 464287341 | GLOBAL ENERG ETF | 46,341 | $1,749,836 | dollars as filed | |
| ISHARES TR | 46435G516 | COM | 23,218 | $1,667,981 | dollars as filed | |
| BIO-TECHNE CORP | 09073M104 | COM | 22,228 | $1,649,095 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 22,689 | $1,516,760 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 14,393 | $1,496,872 | dollars as filed | |
| Tesla Motors, Inc | 88160R101 | COM | 6,591 | $1,367,369 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 6,438 | $1,364,470 | dollars as filed | |
| GENERAL MILLS INC COM | 370334104 | Stock | 15,836 | $1,353,389 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 12,623 | $1,326,805 | dollars as filed | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 17,380 | $1,243,018 | dollars as filed | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 5,811 | $1,225,656 | dollars as filed | |
| ISHARES TR | 464287432 | 20 YR TR BD ETF | 11,449 | $1,217,859 | dollars as filed | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 30,245 | $1,193,468 | dollars as filed | |
| ISHARES TR | 46436E551 | ESG SELECT SCRE | 34,068 | $1,157,971 | dollars as filed | |
| INVESCO QQQ TR | 46090E103 | COM | 3,452 | $1,107,850 | dollars as filed | |
| ISHARES INC | 46434G863 | COM | 34,847 | $1,096,984 | dollars as filed | |
| SPDR Portfolio Emerging Markets ETF | 78463X509 | SHS | 31,949 | $1,090,419 | dollars as filed | |
| CAPITAL GROUP DIVIDEND VALUE | 14020W106 | SHS CREAT UNIT | 43,063 | $1,073,991 | dollars as filed | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 6,481 | $1,028,924 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 3,274 | $1,010,990 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 9,747 | $1,006,768 | dollars as filed | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 6,558 | $990,324 | dollars as filed | |
| VGT | 92204A702 | SHS | 2,534 | $976,781 | dollars as filed | |
| PRIVIA HEALTH GROUP INC | 74276R102 | COM | 34,742 | $959,227 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 6,171 | $956,507 | dollars as filed | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 7,289 | $943,634 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 7,136 | $929,892 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 8,723 | $904,837 | dollars as filed | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 9,734 | $886,281 | dollars as filed | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 8,336 | $830,599 | dollars as filed | |
| PIMCO ETF TR | 72201R775 | ACTIVE BD ETF | 8,261 | $766,249 | dollars as filed | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 14,865 | $727,228 | dollars as filed | |
| DIAGEO PLC SPON ADR NEW | 25243Q205 | ADR | 3,702 | $670,883 | dollars as filed | |
| ServiceNow,Inc. | 81762P102 | COM | 1,387 | $644,567 | dollars as filed | |
| Eli Lilly and Company | 532457108 | COM | 1,835 | $630,176 | dollars as filed | |
| MARRIOTT INTL INC NEW CL A | 571903202 | Stock | 3,678 | $610,695 | dollars as filed | |
| Medtronic Plc | G5960L103 | COM | 6,817 | $549,587 | dollars as filed | |
| ECOLAB INC COM | 278865100 | Stock | 3,288 | $544,263 | dollars as filed | |
| Vanguard S&P Mid-Cap 400 ETF | 921932885 | SHS | 6,190 | $524,169 | dollars as filed | |
| iShares U.S. Technology ETF | 464287721 | SHS | 5,595 | $519,272 | dollars as filed | |
| Honeywell Technologies | 438516106 | COM | 2,678 | $511,819 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C847 | COM | 7,701 | $504,493 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 3,117 | $496,756 | dollars as filed | |
| XCELENERGY INC | 98389B100 | COM | 7,025 | $473,783 | dollars as filed | |
| Lockheed Martin Corporation | 539830109 | COM | 1,000 | $472,730 | dollars as filed | |
| MEDICAL PROPERTIES TRUST INC COM | 58463J304 | REIT | 57,230 | $470,431 | dollars as filed | |
| iShares S&P Global Clean Energy Index Fund | 464288224 | COM | 23,415 | $463,149 | dollars as filed | |
| DELTA AIR LINES INC COM NEW | 247361702 | Stock | 12,343 | $431,018 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 4,443 | $412,844 | dollars as filed | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 5,379 | $397,132 | dollars as filed | |
| VANGUARD S&P SMALL-CAP 600 ETF | 921932828 | ETF | 4,426 | $392,985 | dollars as filed | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 4,647 | $384,548 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 3,655 | $366,028 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 2,441 | $362,957 | dollars as filed | |
| ISHARES TR | 464289867 | CORE 60 BALA ETF | 7,179 | $359,165 | dollars as filed | |
| DISCOVER FINL SVCS | 254709108 | COM | 3,626 | $358,450 | dollars as filed | |
| Abbott Laboratories | 002824100 | COM | 3,474 | $351,777 | dollars as filed | |
| Union Pacific Corporation | 907818108 | COM | 1,733 | $348,784 | dollars as filed | |
| ISHARES TR | 464288737 | GLB CNSM STP ETF | 5,042 | $312,352 | dollars as filed | |
| AT&T Inc | 00206R102 | COM | 15,806 | $304,275 | dollars as filed | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 654 | $301,965 | dollars as filed | |
| iShares S&P 500 Value ETF | 464287408 | SHS | 1,917 | $290,924 | dollars as filed | |
| Schwab U.S. Large-Cap Growth ETF | 808524300 | SHS | 4,356 | $283,881 | dollars as filed | |
| Boeing Company | 097023105 | COM | 1,332 | $282,957 | dollars as filed | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 2,586 | $278,616 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 557 | $276,757 | dollars as filed | |
| Intel Corp | 458140100 | COM | 8,129 | $265,605 | dollars as filed | |
| CAPITAL GRP FIXED INCM ETF T | 14020Y102 | CORE PLUS INCM | 11,493 | $261,925 | dollars as filed | |
| ISHARES TR | 464287812 | US CONSM STAPLES | 1,225 | $244,057 | dollars as filed | |
| Verizon Communications Inc | 92343V104 | COM | 5,875 | $228,495 | dollars as filed | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 4,480 | $226,957 | dollars as filed | |
| POLARIS INC COM | 731068102 | Stock | 1,893 | $209,467 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 1,885 | $206,709 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001085146-23-001737 | this filing | 2023-04-18 | acceptance time not in the bulk data set |