13F-HR filed by Affiance Financial, LLC
Affiance Financial, LLC filed this 13F-HR for the quarter ended 2021-03-31, filed 2021-04-21, with 154 holding rows worth $224,305,000.
- Accession
- 0001398344-21-008266
- Filer
- CIK 1723681
- Filed
- 2021-04-21
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q1 2021
A holdings report, 154 entries on the cover page, a total value of $224,305,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $224,308,000 with VALUE read as thousands by filing date, 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 |
|---|---|---|---|---|---|---|
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 325,163 | $26,725,000 | thousands by filing date | |
| IJH | 464287507 | COM | 100,002 | $26,029,000 | thousands by filing date | |
| VTI | 922908769 | COM | 73,334 | $15,157,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 67,574 | $10,241,000 | thousands by filing date | |
| PELOTON INTERACTIVE INC | 70614W100 | CL A COM | 83,311 | $9,367,000 | thousands by filing date | |
| Vanguard S&P 500 ETF | 922908363 | COM | 23,364 | $8,512,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V373 | S&P500 EQL STP | 45,607 | $7,200,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 57,680 | $7,046,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 70,502 | $6,476,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 59,270 | $6,433,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 23,335 | $5,502,000 | thousands by filing date | |
| J P MORGAN EXCHANGE TRADED F | 46641Q837 | ULTRA SHRT ETF | 100,221 | $5,087,000 | thousands by filing date | |
| ISHARES TR | 464288745 | GLB CNS DISC ETF | 27,455 | $4,476,000 | thousands by filing date | |
| ISHARES TR | 464287341 | GLOBAL ENERG ETF | 170,907 | $4,213,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 44,073 | $3,734,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 13,778 | $2,655,000 | thousands by filing date | |
| BIO-TECHNE CORP | 09073M104 | COM | 6,788 | $2,593,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 6,489 | $2,581,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 11,756 | $2,329,000 | thousands by filing date | |
| Vanguard Dividend Appreciation ETF | 921908844 | SHS | 14,801 | $2,177,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y308 | STATE STREET CON | 28,942 | $1,977,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 6,700 | $1,973,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 615 | $1,903,000 | thousands by filing date | |
| BLACKROCK MUNIYIELD FUND | 09253W104 | COM | 131,082 | $1,881,000 | thousands by filing date | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 19,296 | $1,877,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 10,610 | $1,744,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 4,685 | $1,743,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 840 | $1,738,000 | thousands by filing date | |
| WESTERN ASSET MANAGED MUNS F | 95766M105 | COM | 132,282 | $1,718,000 | thousands by filing date | |
| VGT | 92204A702 | SHS | 4,726 | $1,694,000 | thousands by filing date | |
| ISHARES MSCI EAFE GROWTH ETF | 464288885 | ETF | 16,819 | $1,690,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 22,028 | $1,671,000 | thousands by filing date | |
| ISHARES TR | 464287432 | 20 YR TR BD ETF | 11,336 | $1,535,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 25,329 | $1,447,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 6,427 | $1,441,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 19,199 | $1,229,000 | thousands by filing date | |
| GENERAL MILLS INC COM | 370334104 | Stock | 19,054 | $1,168,000 | thousands by filing date | |
| Tesla Motors, Inc | 88160R101 | COM | 1,696 | $1,133,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 21,347 | $1,111,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 6,979 | $1,062,000 | thousands by filing date | |
| PIMCO MUN INCOME FD II | 72200W106 | COM | 67,838 | $1,009,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 8,166 | $965,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R775 | ACTIVE BD ETF | 8,521 | $933,000 | thousands by filing date | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 7,504 | $876,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 3,250 | $830,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 388 | $800,000 | thousands by filing date | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 14,540 | $794,000 | thousands by filing date | |
| DELTA AIR LINES INC COM NEW | 247361702 | Stock | 15,372 | $742,000 | thousands by filing date | |
| Caterpillar Inc. | 149123101 | COM | 3,110 | $721,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 3,836 | $708,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 22,681 | $687,000 | thousands by filing date | |
| iShares U.S. Technology ETF | 464287721 | SHS | 7,580 | $665,000 | thousands by filing date | |
| ISHARES INC | 46434G863 | COM | 14,883 | $645,000 | thousands by filing date | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 7,018 | $639,000 | thousands by filing date | |
| DIAGEO PLC SPON ADR NEW | 25243Q205 | ADR | 3,703 | $608,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 10,159 | $591,000 | thousands by filing date | |
| Vanguard S&P Mid-Cap 400 ETF | 921932885 | SHS | 3,315 | $585,000 | thousands by filing date | |
| Vanguard Value ETF | 922908744 | SHS | 4,449 | $585,000 | thousands by filing date | |
| Citigroup Inc. | 172967424 | COM | 7,773 | $565,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C847 | COM | 6,757 | $559,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 2,603 | $557,000 | thousands by filing date | |
| PIMCO MUN INCOME FD III | 72201A103 | COM | 43,193 | $533,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 2,063 | $525,000 | thousands by filing date | |
| iShares Core Aggressive Allocation ETF | 464289859 | SHS | 7,686 | $514,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 4,250 | $509,000 | thousands by filing date | |
| Vanguard High Dividend Yield ETF | 921946406 | SHS | 4,981 | $504,000 | thousands by filing date | |
| MARRIOTT INTL INC NEW CL A | 571903202 | Stock | 3,388 | $502,000 | thousands by filing date | |
| NUVEEN MUN CR INCOME FD | 67070X101 | COM SH BEN INT | 30,812 | $498,000 | thousands by filing date | |
| ISHARES TR | 46435G516 | COM | 6,358 | $483,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 2,213 | $480,000 | thousands by filing date | |
| VANGUARD S&P SMALL-CAP 600 ETF | 921932828 | ETF | 2,415 | $480,000 | thousands by filing date | |
| ISHARES TR | 464287887 | S&P SML 600 GWT | 3,734 | $479,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 3,476 | $471,000 | thousands by filing date | |
| XCELENERGY INC | 98389B100 | COM | 7,005 | $466,000 | thousands by filing date | |
| ServiceNow,Inc. | 81762P102 | COM | 928 | $464,000 | thousands by filing date | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 4,858 | $462,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 3,885 | $420,000 | thousands by filing date | |
| DISCOVER FINL SVCS | 254709108 | COM | 4,320 | $410,000 | thousands by filing date | |
| APARTMENT INCOME REIT CORP | 03750L109 | COM | 8,960 | $383,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 5,443 | $382,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 1,733 | $382,000 | thousands by filing date | |
| ECOLAB INC COM | 278865100 | Stock | 1,729 | $370,000 | thousands by filing date | |
| GENPACT LIMITED SHS | G3922B107 | Stock | 8,172 | $350,000 | thousands by filing date | |
| ESSENTIAL UTILS INC COM | 29670G102 | Stock | 7,784 | $348,000 | thousands by filing date | |
| Eli Lilly and Company | 532457108 | COM | 1,800 | $336,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 3,174 | $324,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 816 | $323,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 5,690 | $318,000 | thousands by filing date | |
| ISHARES TR | 464288737 | GLB CNSM STP ETF | 5,060 | $294,000 | thousands by filing date | |
| FLAHERTY & CRUMRIN PFD & INM | 338478100 | COM | 11,733 | $275,000 | thousands by filing date | |
| INVESCO QQQ TR | 46090E103 | COM | 848 | $271,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 718 | $265,000 | thousands by filing date | |
| ISHARES U S ETF TR | 46431W507 | SHOR DURA BD ETF | 5,289 | $265,000 | thousands by filing date | |
| UNITED AIRLS HLDGS INC COM | 910047109 | Stock | 4,499 | $259,000 | thousands by filing date | |
| POLARIS INC COM | 731068102 | Stock | 1,892 | $253,000 | thousands by filing date | |
| MAGELLAN MIDSTREAM PARTNERS, L | 559080106 | COM UNIT RP LP | 5,526 | $240,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R887 | ST STR R2K LOWV | 2,151 | $240,000 | thousands by filing date | |
| KIMBERLY-CLARK CORP COM | 494368103 | Stock | 1,674 | $233,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 4,195 | $232,000 | thousands by filing date | |
| NXP SEMICONDUCTORS N V COM | N6596X109 | Stock | 1,152 | $232,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 950 | $231,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V621 | FINL PFD ETF | 11,656 | $220,000 | thousands by filing date | |
| ISHARES TR | 464287812 | US CONSM STAPLES | 1,225 | $217,000 | thousands by filing date | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 654 | $212,000 | thousands by filing date | |
| NORFOLK SOUTHN CORP COM | 655844108 | Stock | 775 | $208,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 1,519 | $206,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 4,079 | $200,000 | thousands by filing date | |
| Vanguard Extended Market ETF | 922908652 | SHS | 1,015 | $180,000 | thousands by filing date | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 1,809 | $161,000 | thousands by filing date | |
| iShares MSCI KLD 400 Social ETF | 464288570 | SHS | 1,928 | $147,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 2,222 | $142,000 | thousands by filing date | |
| GABELLI EQUITY TR INC COM | 362397101 | CEF | 20,132 | $137,000 | thousands by filing date | |
| ISHARES TR | 464287838 | U.S. BAS MTL ETF | 1,072 | $135,000 | thousands by filing date | |
| Vanguard Communication Services ETF | 92204A884 | SHS | 1,014 | $132,000 | thousands by filing date | |
| iShares U.S. Aerospace & Defense ETF | 464288760 | SHS | 1,024 | $107,000 | thousands by filing date | |
| ARK ETF TR | 00214Q401 | NEXT GNRTN INTER | 718 | $106,000 | thousands by filing date | |
| Vanguard Energy ETF | 92204A306 | SHS | 1,547 | $105,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 438 | $98,000 | thousands by filing date | |
| iShares Global Healthcare ETF | 464287325 | SHS | 1,254 | $97,000 | thousands by filing date | |
| iShares Global 100 ETF | 464287572 | SHS | 1,348 | $89,000 | thousands by filing date | |
| VANGUARD HEALTH CARE ETF | 92204A504 | ETF | 382 | $87,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 347 | $84,000 | thousands by filing date | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 1,038 | $81,000 | thousands by filing date | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 330 | $73,000 | thousands by filing date | |
| ARK ETF TR | 00214Q104 | INNOVATION ETF | 594 | $71,000 | thousands by filing date | |
| INVESCO S&P 500 TOP 50 ETF | 46137V233 | ETF | 225 | $67,000 | thousands by filing date | |
| ISHARES TR | 464288687 | COM | 1,418 | $54,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 230 | $51,000 | thousands by filing date | |
| iShares Global Tech ETF | 464287291 | SHS | 162 | $50,000 | thousands by filing date | |
| ARK ETF TR | 00214Q203 | AUTNMUS TECHNLGY | 507 | $43,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V282 | S&P500 EQL TEC | 125 | $34,000 | thousands by filing date | |
| THERAPEUTICSMD INC | 88338N107 | COM | 25,050 | $34,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V241 | S&P500 QUALITY | 740 | $33,000 | thousands by filing date | |
| ISHARES TR | 464289875 | CORE 40 MODE ETF | 705 | $31,000 | thousands by filing date | |
| VANGUARD WORLD FD | 92204A603 | INDUSTRIAL ETF | 155 | $29,000 | thousands by filing date | |
| ISHARES TR | 464288752 | US HOME CONS ETF | 363 | $25,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V332 | S&P500 EQL HLT | 94 | $25,000 | thousands by filing date | |
| ISHARES TR | 464287168 | COM | 200 | $23,000 | thousands by filing date | |
| ISHARES TR | 464288695 | GLOBAL MATER ETF | 203 | $18,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 107 | $17,000 | thousands by filing date | |
| 3D PRINTING ETF | 00214Q500 | ETF | 400 | $16,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 220 | $14,000 | thousands by filing date | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 196 | $13,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y407 | SBI CONS DISCR | 78 | $13,000 | thousands by filing date | |
| ARK ETF TR | 00214Q302 | GENOMIC REV ETF | 150 | $13,000 | thousands by filing date | |
| Vanguard Small-Cap Growth ETF | 922908595 | SHS | 45 | $12,000 | thousands by filing date | |
| ISHARES TR | 464289867 | CORE 60 BALA ETF | 215 | $12,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 37 | $11,000 | thousands by filing date | |
| ISHARES TR | 464289883 | CORE 30 70 ETF | 274 | $11,000 | thousands by filing date | |
| SPDR SER TR | 78468R689 | S&P KENSHO SMART | 149 | $9,000 | thousands by filing date | |
| Vanguard Mid-Cap Value ETF | 922908512 | SHS | 58 | $8,000 | thousands by filing date | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 48 | $8,000 | thousands by filing date | |
| ISHARES TR | 464287184 | CHINA LG-CAP ETF | 20 | $1,000 | thousands by filing date | |
| Vanguard Growth | 922908736 | COM | 0 | $0 | thousands by filing date | Value filed as zero, left out of ratios.Amount filed as zero, left out of ratios. |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001398344-21-008266 | this filing | 2021-04-21 | acceptance time not in the bulk data set |