13F-HR filed by BLUESTEM FINANCIAL ADVISORS, LLC
BLUESTEM FINANCIAL ADVISORS, LLC filed this 13F-HR for the quarter ended 2022-06-30, filed 2022-08-12, with 64 holding rows worth $9,450,000.
- Accession
- 0001214659-22-009924
- Filer
- CIK 1820680
- Filed
- 2022-08-12
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2022
A holdings report, 64 entries on the cover page, a total value of $9,450,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $9,450,000 with VALUE read as thousands by filing date, 13F file number 028-20314. A later restatement replaced it, so the quarter does not use it. 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 TR CORE S&P 500 ETF | 464287200 | SHS | 4,720,692 | $1,941,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 22,214,009 | $1,711,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Small-Cap ETF | 922908751 | SHS | 5,710,947 | $1,101,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 14,050,406 | $1,070,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard FTSE All-World ex-US ETF | 922042775 | SHS | 17,100,964 | $915,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Real Estate | 922908553 | SHS | 6,354,576 | $633,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 6,107,125 | $272,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VTI | 922908769 | COM | 1,060,252 | $218,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 1,956,783 | $195,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 1,836,864 | $189,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| ISHARES TR | 46432F859 | CORE 1 5 YR USD | 3,910,298 | $187,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 666,597 | $125,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares ESG Aware MSCI USA Small-Cap ETF | 46435U663 | SHS | 3,462,390 | $119,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| SPDR SER TR STATE STR SPDR PORT S&P 500 ETF | 78464A854 | SHS | 2,373,845 | $114,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| ISHARES TR | 46435U218 | ESG MSCI LEADR | 1,564,709 | $112,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard ESG International Stock ETF | 921910725 | SHS | 1,953,894 | $103,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| ISHARES TR | 464288802 | ESG OPTIMIZED | 810,445 | $71,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 258,013 | $56,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VANGUARD STAR FDS | 921909768 | COM | 816,712 | $45,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Apple Inc | 037833100 | COM | 233,803 | $35,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| SPY | 78462F103 | SHS | 79,655 | $33,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Schwab US REIT ETF | 808524847 | SHS | 1,121,689 | $26,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| IJH | 464287507 | COM | 74,228 | $18,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VANGUARD SCOTTSDALE FDS | 92206C847 | COM | 225,990 | $16,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 313,708 | $16,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard ESG U.S. Stock ETF | 921910733 | SHS | 207,113 | $15,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 167,972 | $13,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VANGUARD BD INDEX FDS | 921937793 | LONG TERM BOND | 137,524 | $11,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| KROGER CO COM | 501044101 | Stock | 172,422 | $9,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Intermediate-Term Treasury ETF | 92206C706 | SHS | 90,542 | $6,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 107,366 | $6,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Microsoft Corp | 594918104 | COM | 18,338 | $5,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Southern Company | 842587107 | COM | 62,620 | $5,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 67,401 | $5,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares 0-5 Year TIPS Bond ETF | 46429B747 | SHS | 47,906 | $5,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares ESG Aware US Aggregate Bond ETF | 46435U549 | SHS | 91,417 | $4,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| NUSHARES ETF TR | 67092P607 | NUVEEN ESG SMLCP | 100,838 | $4,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| FIRST MID BANCSHARES INC | 320866106 | COMMON STOCK | 112,964 | $4,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Oracle Corporation | 68389X105 | COM | 35,460 | $3,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| ISHARES TR | 464288208 | MRGSTR MD CP ETF | 40,922 | $3,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Abbott Laboratories | 002824100 | COM | 14,738 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| AbbVie,Inc. | 00287Y109 | COM | 10,690 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| PepsiCo,Inc. | 713448108 | COM | 13,957 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Mid-Cap Growth ETF | 922908538 | SHS | 12,543 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| FORD MTR CO COM | 345370860 | Stock | 134,346 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| PUBLIC SVC ENTERPRISE GROUP COM | 744573106 | Stock | 25,560 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| AMEREN CORP COM | 023608102 | Stock | 17,270 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| INVESCO MSCI SUSTAINABLEFUTURE ETF | 46137V407 | ETF | 34,825 | $2,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| AT&T Inc | 00206R102 | COM | 26,138 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Comcast Corp | 20030N101 | COM | 12,400 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 20,033 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 12,749 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 10,313 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Pfizer Inc. | 717081103 | COM | 10,733 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Starbucks Corporation | 855244109 | COM | 17,608 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard ESG U.S. Corporate Bond ETF | 921910691 | SHS | 21,266 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Vanguard Value ETF | 922908744 | SHS | 10,121 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Verizon Communications Inc | 92343V104 | COM | 22,602 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| VWO | 922042858 | SHS | 18,562 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| Walt Disney Co | 254687106 | COM | 10,543 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| MCCORMICK & CO INC COM NON VTG | 579780206 | Stock | 12,400 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| HNI CORP COM | 404251100 | Stock | 26,598 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| ISHARES TR | 464288505 | MRGSTR SM CP ETF | 14,985 | $1,000 | thousands by filing date | Value about 1/1,000 of the price other filers imply, kept as filed and left out of ratios. |
| INDEPENDENCE RLTY TR INC | 45378A106 | COM | 14,304 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001214659-22-009924 | this filing | 2022-08-12 | acceptance time not in the bulk data set | |
| 13F-HR/A 0001214659-22-012916 | base | 2022-11-01 | acceptance time not in the bulk data set |