Holdings are itemized directly on this plan's Schedule of Assets, below.
| Name | EIN | Location | Relation | Direct comp | Indirect comp |
|---|---|---|---|---|---|
| BENEFIT MANAGEMENT GROUP, INC | 20-0188125 | — | NONE | $78K | — |
| TED WINDSOR & ASSOCIATES | 36-4374704 | — | NONE | $28K | — |
| CALIBRE CPA GROUP, PLLC | 47-0900880 | — | NONE | $26K | — |
| AMERICAN REALTY ADVISORS | 33-0123114 | — | NONE | $25K | — |
| COMERICA BANK | 42-1741646 | — | NONE | $25K | — |
| SEGAL MARCO ADVISORS | 13-2646110 |
Rows tagged as a trust or pooled fund hold many underlying securities. Click one to drill into its own Schedule of Assets — where the individual funds, shares, and CUSIPs live.
| PI | Investment | Type | Shares / units | Cost | Current value | % of plan |
|---|---|---|---|---|---|---|
| c. Total market value plus contributions | — | — | — | $52.0M | 151.6% | |
| c. Total market value plus contributions | — | — | — | $46.7M | 136.2% |
| — |
| NONE |
| $25K |
| — |
| MARCO, MCGUIRE & ARREOLA | 88-4115449 | — | NONE | $21K | — |
| LEGACY PROFESSIONALS | 32-0043599 | — | NONE | $9K | — |
| NORTHERN TRUST COMPANY | 36-1561860 | — | NONE | $3K | — |
| 6. Test [is #4 > #5] FALSE Non-forfeitable Inactive Benefits Greater Than Non-forfeitable Active Benefits 7. Non-forfeitable inactive benefits [exhibit 3] | — | — | — | $43.9M | 128.1% |
| 1. Retirees and beneficiaries | — | — | $2.5M | $36.5M | 106.4% |
| 4. Market value of assets plus present value of contributions from 1/1/2024 through 12/31/2030 a. Market value of assets [from exhibit 1] | — | — | — | $30.1M | 87.7% |
| [Exhibit 3 line 8] 2. Test [is #1 <= 65%] TRUE Six-Year Projection of Benefit Payments 3. Present value of benefit payments and administrative expenses from 1/1/2024 through 12/31/2030 [see exhibit 5] | — | — | — | $25.8M | 75.4% |
| b. Present value of expected contributions [exhibit 5] | — | — | — | $21.9M | 63.8% |
| Current Year and Four-Year Projection of Benefit Payments Test Four-Year Projection of Benefit Payments 1. Present value of benefit payments and administrative expenses from 1/1/2024 through 12/31/2028 [see exhibit 5] | — | — | — | $19.6M | 57.2% |
| b. Present value of expected contributions [exhibit 5] | — | — | — | $16.6M | 48.5% |
| Fidelity Total M arket Index M utual fund N/A | — | — | $11.8M | $14.4M | 42.1% |
| 8. Non-forfeitable active benefits [exhibit 3] | — | — | — | $9.4M | 27.3% |
| PIM CO Total Return Inst Fund M utual fund N/A | — | — | $8.3M | $8.1M | 23.7% |
| 2. Terminated vested employees | — | — | $487K | $7.4M | 21.7% |
| 3. Deductions a. Benefit payments | — | — | — | $4.2M | 12.4% |
| Calculation of hours during year ending 12/31/2023 1. Expected contributions for year ending 12/31/2023 | — | — | — | $3.9M | 11.3% |
| NT COLL AGGRE BOND INDEX FUND NORTHERN TRUST INVESTMENTS INC · EIN 45-6138589 / PN 029 | Common Collective Trust | — | $3.0M | $3.0M | 8.8% |
| b. Actual (market basis) | — | — | — | $3.0M | 8.7% |
| ii. Net appreciation/(depreciation) | — | — | — | $2.5M | 7.4% |
| 4. Net increase/(decrease) | — | — | — | $2.4M | 7.0% |
| Limited partnerships American Core Realty Fund Limited partnership N/A | — | — | $2.6M | $2.3M | 6.7% |
| d. Recognized return on assets [(a)] (expected amount) | — | — | — | $2.1M | 6.2% |
| 4. Investment income a. Expected (actuarial basis) | — | — | — | $2.1M | 6.2% |
| 4. Total interest on unfunded and normal cost | — | — | — | $2.1M | 6.1% |
| M utual funds Fidelity Diversified International Fund M utual fund N/A | — | — | $1.6M | $1.7M | 4.9% |
| M FS Institutional International Equity Fund M utual fund N/A | — | — | $1.6M | $1.6M | 4.6% |
| AFL-CIO BUILDING INVESTMENT TRUST PNC BANK, NA · EIN 52-6328901 / PN 001 | Common Collective Trust | — | $872K | $875K | 2.6% |
| c. Unrecognized gain/(loss) on assets [(b) - (a)] | — | — | — | $870K | 2.5% |
| Cash equivalents Comerica Short Term Fund Cash equivalents N/A | — | — | $828K | $828K | 2.4% |
| 2. Normal cost for the plan year ending 12/31/2024 [exhibit 8] | — | — | — | $608K | 1.8% |
| [#1 + #2(c) - #3(c) + #4(d)] 6. Recognition of asset gains/(losses) over five years Original Remaining 12/31/2023 Balance Unrecognized Recognition a. Year ended 12/31/2019 2,785,536 0 | — | — | — | $557K | 1.6% |
| 2. Additions a. Investment income i. Interest and dividends | — | — | — | $488K | 1.4% |
| c. Year ended 12/31/2021 | — | — | $760K | $380K | 1.1% |
| b. Year ended 12/31/2020 | — | — | $374K | $374K | 1.1% |
| Active Employees Hourly Contribution Rate Per Negotiated Collective Bargaining Agreements Expected Hours of Contribution & Normal Cost - Current Plan Expected Hours = | — | — | — | $267K | 0.8% |
| b. Expenses | — | — | — | $232K | 0.7% |
| b. Administrative | — | — | — | $232K | 0.7% |
| e. Year ended 12/31/2023 | — | — | $696K | $174K | 0.5% |
| 4. Active non-vested benefits | — | — | $6K | $96K | 0.3% |
| f. Total | — | — | $75K | $75K | 0.2% |
| c. Miscellaneous income | — | — | — | $8K | <0.1% |
| 60 to 64 2 $ 1,303.56 1 $ 1,400.00 1 $ 2,000.00 2 $ 2,200.00 1 | — | — | — | $4K | <0.1% |
| 55 to 59 1 $ 160.00 2 $ 680.00 1 $ 1,120.00 2 $ 1,357.61 4 $ 1,950.03 5 $ 2,192.00 2 $ 2,717.72 1 | — | — | — | $4K | <0.1% |
| 50 to 54 2 1 $ 360.00 1 $ 1,240.00 5 $ 1,384.00 4 $ 1,780.00 5 | — | — | — | $2K | <0.1% |
| 45 to 49 3 2 $ 200.00 5 $ 640.00 4 $ 1,110.00 11 $ 1,389.09 6 $ 1,806.67 3 | — | — | — | $2K | <0.1% |
| 40 to 44 4 $ 10.00 4 $ 250.00 6 $ 586.67 3 $ 1,026.67 3 | — | — | — | $1K | <0.1% |
| 35 to 39 2 4 $ 180.00 10 $ 576.00 4 $ 930.00 5 | — | — | — | $1K | <0.1% |
