13F-HR filed by Somerset Group LLC
Somerset Group LLC filed this 13F-HR for the quarter ended 2023-06-30, filed 2023-08-11, with 64 holding rows worth $119,610,112.
- Accession
- 0001062993-23-016230
- Filer
- CIK 1567912
- Filed
- 2023-08-11
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2023
A holdings report, 64 entries on the cover page, a total value of $119,610,112 stated on the cover page (in dollars after the unit check, H1), rows summing to $119,610,112 with VALUE read as dollars as filed, 13F file number 028-15423. 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 |
|---|---|---|---|---|---|---|
| USBANCORPDEL | 902973304 | COM NEW | 272,830 | $9,014,303 | dollars as filed | |
| C H ROBINSON WORLDWIDE IN COM NEW | 12541W209 | Stock | 85,051 | $8,024,562 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 23,489 | $7,998,944 | dollars as filed | |
| Apple Inc | 037833100 | COM | 37,754 | $7,316,725 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 69,255 | $6,931,733 | dollars as filed | |
| INVESCO QQQ TR | 46090E103 | COM | 17,109 | $6,320,407 | dollars as filed | |
| NextEra Energy,Inc. | 65339F101 | COM | 58,081 | $4,309,610 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 31,927 | $4,162,004 | dollars as filed | |
| iShares U.S. Medical Devices ETF | 464288810 | SHS | 68,894 | $3,889,755 | dollars as filed | |
| PIMCO ETF TR | 72201R833 | ENHAN SHRT MA AC | 36,099 | $3,601,236 | dollars as filed | |
| PALO ALTO NETWORKS INC | 697435105 | COM | 14,022 | $3,582,761 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 5,169 | $2,782,990 | dollars as filed | |
| TRAVELERS COMPANIES INC COM | 89417E109 | Stock | 15,762 | $2,737,229 | dollars as filed | |
| BLACKSTONE INC | 09260D107 | COM | 28,424 | $2,642,579 | dollars as filed | |
| FORD MTR CO COM | 345370860 | Stock | 170,450 | $2,578,908 | dollars as filed | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 10,280 | $2,494,545 | dollars as filed | |
| Chevron Corporation | 166764100 | COM | 15,263 | $2,401,633 | dollars as filed | |
| iShares U.S. Financials ETF | 464287788 | SHS | 32,014 | $2,388,565 | dollars as filed | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 43,425 | $2,274,167 | dollars as filed | |
| FIRST TR EXCHANGE-TRADED FD | 33733E302 | DJ INTERNT IDX | 12,718 | $2,072,907 | dollars as filed | |
| Wells Fargo & Company | 949746101 | COM | 47,629 | $2,032,806 | dollars as filed | |
| CHENIERE ENERGY INC COM NEW | 16411R208 | Stock | 12,900 | $1,965,444 | dollars as filed | |
| Texas Instruments Incorporated | 882508104 | COM | 9,855 | $1,774,097 | dollars as filed | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 30,348 | $1,439,102 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 7,250 | $1,342,700 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 12,315 | $1,320,784 | dollars as filed | |
| SPY | 78462F103 | SHS | 2,761 | $1,223,896 | dollars as filed | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 16,059 | $1,204,425 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 9,566 | $1,156,625 | dollars as filed | |
| McDonalds Corporation | 580135101 | COM | 3,734 | $1,114,263 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 8,174 | $1,101,283 | dollars as filed | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 12,009 | $974,771 | dollars as filed | |
| Lowes Companies,Inc. | 548661107 | COM | 4,306 | $971,864 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 4,881 | $970,782 | dollars as filed | |
| Eli Lilly and Company | 532457108 | COM | 1,878 | $880,744 | dollars as filed | |
| SANMINA-SCI CORP | 800907206 | COM | 13,940 | $840,164 | dollars as filed | |
| iShares U.S. Aerospace & Defense ETF | 464288760 | SHS | 7,001 | $816,807 | dollars as filed | |
| Schwab Short Term US Treasury ETF | 808524862 | SHS | 16,345 | $785,541 | dollars as filed | |
| WEYERHAEUSER CO COM NEW | 962166104 | REIT | 19,777 | $662,727 | dollars as filed | |
| GLOBAL X FDS | 37954Y855 | LITHIUM BTRY ETF | 9,670 | $628,743 | dollars as filed | |
| ECOLAB INC COM | 278865100 | Stock | 3,336 | $622,798 | dollars as filed | |
| NORTHERN TR CORP COM | 665859104 | Stock | 7,500 | $556,050 | dollars as filed | |
| CHENIERE ENERGY PARTNERS L P | 16411Q101 | COM UNIT | 12,050 | $555,987 | dollars as filed | |
| CENCORA INC COM | 03073E105 | Stock | 2,872 | $552,659 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 3,184 | $527,016 | dollars as filed | |
| WILLIAMS COS INC COM | 969457100 | Stock | 15,388 | $502,110 | dollars as filed | |
| Merck & Co.,Inc. | 58933Y105 | COM | 3,613 | $416,904 | dollars as filed | |
| ISHARES U S ETF TR | 46431W507 | SHOR DURA BD ETF | 8,152 | $405,317 | dollars as filed | |
| ENERGY TRANSFER L P | 29273V100 | COM UT LTD PTN | 31,000 | $393,700 | dollars as filed | |
| ISHARES TR | 464288687 | COM | 12,650 | $391,264 | dollars as filed | |
| MPLX LP | 55336V100 | COM UNIT REP LTD | 10,000 | $339,400 | dollars as filed | |
| Schwab U.S. Small-Cap ETF | 808524607 | SHS | 7,265 | $318,207 | dollars as filed | |
| ENTERPRISE PRODS PARTNERS L | 293792107 | COM | 12,000 | $316,200 | dollars as filed | |
| Stryker Corporation | 086366710 | COM | 1,000 | $305,090 | dollars as filed | |
| S&P Global,Inc. | 78409V104 | COM | 750 | $300,668 | dollars as filed | |
| Whirlpool Corp | 096332010 | COM | 1,951 | $290,289 | dollars as filed | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 4,267 | $284,737 | dollars as filed | |
| Salesforce.com, Inc | 79466L302 | COM | 1,316 | $278,018 | dollars as filed | |
| GENERAL MILLS INC COM | 370334104 | Stock | 3,600 | $276,120 | dollars as filed | |
| 0 | 000000000 | 0 | 380 | $275,508 | dollars as filed | |
| Honeywell Technologies | 438516106 | COM | 1,207 | $250,452 | dollars as filed | |
| Caterpillar Inc. | 149123101 | COM | 1,000 | $246,050 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 1,578 | $239,446 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 6,352 | $232,991 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001062993-23-016230 | this filing | 2023-08-11 | acceptance time not in the bulk data set |