City_of_Chandler_301601_Monthly_Plan_Assets_5.31.23.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Request for Proposals - City of Chandler Deferred Compensation 457 Plan and Retirement Health Savings Plan Administration, Investment and Trust Services ; HR3-953-4609
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

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 NamePlan CodeCUSIPTickerFund Long NameAsset CategoryParticipants With BalanceFund BalanceEffective Date
CITY OF CHANDLER301601316175603FCGXXFidelity Investments Money Market Funds Government PortfolioStable Value/Cash Management139$1,333,806.5205/31/2023
CITY OF CHANDLER30160192208J709MissionSquare PLUS FundStable Value/Cash Management502$19,057,245.3405/31/2023
CITY OF CHANDLER301601693390841PHIYXPIMCO High Yield FundBond191$1,448,125.5905/31/2023
CITY OF CHANDLER301601693390700PTTRXPIMCO Total Return FundBond229$2,896,695.2605/31/2023
CITY OF CHANDLER301601921937603VBTLXVanguard Total Bond Market IndexBond265$3,525,144.7105/31/2023
CITY OF CHANDLER30160174440A696MissionSquare Retirement IncomeAdvantage FundGuaranteed Lifetime Income17$1,223,824.2605/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTWNXVanguard Target Retirement 2020 FundBalanced/Asset Allocation95$3,699,799.5505/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTTVXVanguard Target Retirement 2025 FundBalanced/Asset Allocation169$7,378,574.6605/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTHRXVanguard Target Retirement 2030 FundBalanced/Asset Allocation224$5,332,221.5205/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTTHXVanguard Target Retirement 2035 FundBalanced/Asset Allocation262$10,169,009.6105/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VFORXVanguard Target Retirement 2040 FundBalanced/Asset Allocation272$6,642,613.5605/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTIVXVanguard Target Retirement 2045 FundBalanced/Asset Allocation298$5,725,384.3305/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VFIFXVanguard Target Retirement 2050 FundBalanced/Asset Allocation275$4,610,389.8805/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VFFVXVanguard Target Retirement 2055 FundBalanced/Asset Allocation208$2,073,961.6905/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VTTSXVanguard Target Retirement 2060 FundBalanced/Asset Allocation159$1,657,171.4605/31/2023
CITY OF CHANDLER301601ERROR:#DIV/0!VLXVXVanguard Target Retirement 2065 FundBalanced/Asset Allocation70$955,276.7605/31/2023
CITY OF CHANDLER3016019.2202E+106VTINXVanguard Target Retirement Income FundBalanced/Asset Allocation62$2,961,825.1305/31/2023
CITY OF CHANDLER301601316071836FLCNXFidelity Contrafund®U.S. Stock509$18,966,254.1905/31/2023
CITY OF CHANDLER30160141664R267HFMVXHartford MidCap FundU.S. Stock115$281,691.4605/31/2023
CITY OF CHANDLER30160147103D785JVTNXJanus Henderson Venture FundU.S. Stock115$1,351,343.5005/31/2023
CITY OF CHANDLER30160155273H353MEIKXMFS Value FundU.S. Stock181$782,444.6305/31/2023
CITY OF CHANDLER30160177957Q301PRVIXT Rowe Price® Small-Cap Value FundU.S. Stock168$2,457,179.9605/31/2023
CITY OF CHANDLER301601922040100VINIXVanguard Institutional Index FundU.S. Stock521$26,701,644.0005/31/2023
CITY OF CHANDLER301601922908835VMCIXVanguard Mid-Cap Index FundU.S. Stock373$6,874,820.5905/31/2023
CITY OF CHANDLER301601921946109VASVXVanguard Selected Value FundU.S. Stock116$1,226,193.1605/31/2023
CITY OF CHANDLER301601922908686VSMAXVanguard Small-Cap Index FundU.S. Stock225$2,470,482.6505/31/2023
CITY OF CHANDLER301601649280815RNWGXAmerican Funds New World FundInternational/Global Stock173$884,899.9405/31/2023
CITY OF CHANDLER301601413838723OANIXOakmark International FundInternational/Global Stock323$2,908,143.6105/31/2023
CITY OF CHANDLER301601921909818VTIAXVanguard Total International Stock Index FundInternational/Global Stock244$4,294,695.9005/31/2023
CITY OF CHANDLER301601MissionSquare BrokerageSpecialty139$26,177,103.9505/31/2023
CITY OF CHANDLER301601MissionSquare Roth BrokerageSpecialty1$4,590.2505/31/2023
CITY OF CHANDLER301601921908877VGSLXVanguard Real Estate Index FundSpecialty237$1,139,024.0905/31/2023

File details come from the government source that posted it. Updated .