City_of_Chandler_301601_Monthly_Plan_Assets_5.31.23.xlsx
XLSX spreadsheet 19 KB Posted
- Solicitation number
- BPM005428
- Issued by
- Maricopa County, Chandler City, Arizona
About this file
This file is a monthly plan assets report for the City of Chandler's Deferred Compensation 457 Plan (Plan Code 301601) as of May 31, 2023, documenting the investment portfolio holdings and participant account balances across multiple asset categories. The report details 31 distinct investment funds spanning stable value/cash management, bonds, guaranteed lifetime income, balanced/asset allocation, U.S. stocks, international stocks, and specialty investments, with a combined total fund balance exceeding $178 million distributed across thousands of plan participants. The assets include core holdings such as the MissionSquare PLUS Fund ($19.1 million), Fidelity Contrafund ($19.0 million), and Vanguard Institutional Index Fund ($26.7 million), alongside target-date retirement funds ranging from 2020 through 2065 vintages that collectively hold approximately $42 million in assets. The report reflects the investment composition and participant diversification of the city's deferred compensation plan during this specific reporting period.
The document provides a snapshot of plan fund performance and allocation strategy as of the report date, with participant balances ranging from single-participant positions in specialty brokerage accounts to funds with over 500 participants such as the MissionSquare PLUS Fund and Fidelity Contrafund. Notable data anomalies appear in the CUSIP field for several Vanguard Target Retirement Funds, displaying error codes or formatting irregularities that suggest potential reporting system issues. The broad range of investment options and substantial aggregate balances indicate a mature, well-diversified retirement plan serving the city's workforce with multiple fund choices across risk and time horizons, reflecting investment strategies designed to accommodate participants with varying retirement timelines and risk tolerances.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 457_Plan_Document.docx.pdf | ||
| 4609_Deferred_Comp_RFP_FINAL.pdf | ||
| 4609_Addendum_1_FINAL.pdf | ||
| City_of_Chandler_801217_Monthly_Plan_Assets_5.31.23.xlsx | XLSX spreadsheet | |
| City_of_Chandler_801218_801427_801217_Monthly_Plan_Assets_5.31.23.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
301601
| Report Dates: 05/2023 to 05/2023 | ||||||||
| Plan Name | Plan Code | CUSIP | Ticker | Fund Long Name | Asset Category | Participants With Balance | Fund Balance | Effective Date |
| CITY OF CHANDLER | 301601 | 316175603 | FCGXX | Fidelity Investments Money Market Funds Government Portfolio | Stable Value/Cash Management | 139 | $1,333,806.52 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 92208J709 | MissionSquare PLUS Fund | Stable Value/Cash Management | 502 | $19,057,245.34 | 05/31/2023 | |
| CITY OF CHANDLER | 301601 | 693390841 | PHIYX | PIMCO High Yield Fund | Bond | 191 | $1,448,125.59 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 693390700 | PTTRX | PIMCO Total Return Fund | Bond | 229 | $2,896,695.26 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 921937603 | VBTLX | Vanguard Total Bond Market Index | Bond | 265 | $3,525,144.71 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 74440A696 | MissionSquare Retirement IncomeAdvantage Fund | Guaranteed Lifetime Income | 17 | $1,223,824.26 | 05/31/2023 | |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTWNX | Vanguard Target Retirement 2020 Fund | Balanced/Asset Allocation | 95 | $3,699,799.55 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTTVX | Vanguard Target Retirement 2025 Fund | Balanced/Asset Allocation | 169 | $7,378,574.66 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTHRX | Vanguard Target Retirement 2030 Fund | Balanced/Asset Allocation | 224 | $5,332,221.52 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTTHX | Vanguard Target Retirement 2035 Fund | Balanced/Asset Allocation | 262 | $10,169,009.61 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VFORX | Vanguard Target Retirement 2040 Fund | Balanced/Asset Allocation | 272 | $6,642,613.56 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTIVX | Vanguard Target Retirement 2045 Fund | Balanced/Asset Allocation | 298 | $5,725,384.33 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VFIFX | Vanguard Target Retirement 2050 Fund | Balanced/Asset Allocation | 275 | $4,610,389.88 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VFFVX | Vanguard Target Retirement 2055 Fund | Balanced/Asset Allocation | 208 | $2,073,961.69 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VTTSX | Vanguard Target Retirement 2060 Fund | Balanced/Asset Allocation | 159 | $1,657,171.46 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | ERROR:#DIV/0! | VLXVX | Vanguard Target Retirement 2065 Fund | Balanced/Asset Allocation | 70 | $955,276.76 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 9.2202E+106 | VTINX | Vanguard Target Retirement Income Fund | Balanced/Asset Allocation | 62 | $2,961,825.13 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 316071836 | FLCNX | Fidelity Contrafund® | U.S. Stock | 509 | $18,966,254.19 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 41664R267 | HFMVX | Hartford MidCap Fund | U.S. Stock | 115 | $281,691.46 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 47103D785 | JVTNX | Janus Henderson Venture Fund | U.S. Stock | 115 | $1,351,343.50 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 55273H353 | MEIKX | MFS Value Fund | U.S. Stock | 181 | $782,444.63 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 77957Q301 | PRVIX | T Rowe Price® Small-Cap Value Fund | U.S. Stock | 168 | $2,457,179.96 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 922040100 | VINIX | Vanguard Institutional Index Fund | U.S. Stock | 521 | $26,701,644.00 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 922908835 | VMCIX | Vanguard Mid-Cap Index Fund | U.S. Stock | 373 | $6,874,820.59 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 921946109 | VASVX | Vanguard Selected Value Fund | U.S. Stock | 116 | $1,226,193.16 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 922908686 | VSMAX | Vanguard Small-Cap Index Fund | U.S. Stock | 225 | $2,470,482.65 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 649280815 | RNWGX | American Funds New World Fund | International/Global Stock | 173 | $884,899.94 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 413838723 | OANIX | Oakmark International Fund | International/Global Stock | 323 | $2,908,143.61 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | 921909818 | VTIAX | Vanguard Total International Stock Index Fund | International/Global Stock | 244 | $4,294,695.90 | 05/31/2023 |
| CITY OF CHANDLER | 301601 | MissionSquare Brokerage | Specialty | 139 | $26,177,103.95 | 05/31/2023 | ||
| CITY OF CHANDLER | 301601 | MissionSquare Roth Brokerage | Specialty | 1 | $4,590.25 | 05/31/2023 | ||
| CITY OF CHANDLER | 301601 | 921908877 | VGSLX | Vanguard Real Estate Index Fund | Specialty | 237 | $1,139,024.09 | 05/31/2023 |
File details come from the government source that posted it. Updated .