City_of_Chandler_801217_Monthly_Plan_Assets_5.31.23.xlsx

XLSX spreadsheet 11 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

Written by GovTribe AI ·

This file is a monthly investment plan asset report for the City of Chandler's Plan 801217, dated May 31, 2023, which corresponds to the city's Deferred Compensation 457 Plan administered through MissionSquare. The report documents the allocation and balances across 32 investment funds spanning multiple asset categories including stable value/cash management, bonds, balanced/asset allocation, U.S. stocks, and international/global stocks. The plan serves 128 to 320 participants depending on the fund, with total combined assets across all funds exceeding $31 million as of the report date. This asset composition reflects the current investment holdings that would be relevant to any prospective vendor responding to the City of Chandler's RFP for plan administration and investment services, issued on May 12, 2023, with proposals due by June 13, 2023.

The report reveals that the City of Chandler's retirement plan currently utilizes MissionSquare's suite of investment options, with the largest concentrations in the Retirement Target Date Funds (particularly the 2030 and 2035 funds holding approximately $4 million and $3.2 million respectively) and the PLUS Fund stable value option holding $2.7 million. The diversified fund lineup and substantial asset base indicate a mature plan with significant fiduciary considerations for any incoming administrator. The specific fund performance data, participant distribution across various risk profiles, and existing MissionSquare platform infrastructure represent baseline conditions that any prospective vendor must account for in their proposal, particularly regarding transition planning, investment continuity, and participant communication during any administrative change.

View the file

Other files

File Type Posted
457_Plan_Document.docx.pdf PDF
4609_Deferred_Comp_RFP_FINAL.pdf PDF
4609_Addendum_1_FINAL.pdf PDF
City_of_Chandler_301601_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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

801217

Report Dates: 05/2023 to 05/2023
Plan NamePlan CodeCUSIPTickerFund Long NameAsset CategoryParticipants With BalanceFund BalanceEffective Date
CITY OF CHANDLER80121792211R383MissionSquare PLUS FundStable Value/Cash Management128$2,696,695.0305/31/2023
CITY OF CHANDLER80121792211A208MissionSquare Core Bond Index FundBond49$265,927.4205/31/2023
CITY OF CHANDLER80121792211R425MissionSquare High Yield FundBond15$57,502.7805/31/2023
CITY OF CHANDLER80121792211A802MissionSquare Inflation Focused FundBond32$221,236.7305/31/2023
CITY OF CHANDLER80121792211A505MissionSquare Low Duration Bond FundBond27$85,642.6205/31/2023
CITY OF CHANDLER80121792211A539MissionSquare Model Portfolio Conservative Growth FundBalanced/Asset Allocation9$76,744.7905/31/2023
CITY OF CHANDLER80121792211A430MissionSquare Model Portfolio Global Equity Growth FundBalanced/Asset Allocation26$378,004.1305/31/2023
CITY OF CHANDLER80121792211A463MissionSquare Model Portfolio Long-Term Growth FundBalanced/Asset Allocation35$218,647.2405/31/2023
CITY OF CHANDLER80121792211A497MissionSquare Model Portfolio Traditional Growth FundBalanced/Asset Allocation18$166,926.4205/31/2023
CITY OF CHANDLER80121792211A794MissionSquare Retirement Target 2015 FundBalanced/Asset Allocation121$2,608,687.6905/31/2023
CITY OF CHANDLER80121792211A760MissionSquare Retirement Target 2020 FundBalanced/Asset Allocation197$4,515,444.0705/31/2023
CITY OF CHANDLER80121792211A737MissionSquare Retirement Target 2025 FundBalanced/Asset Allocation280$4,014,234.5805/31/2023
CITY OF CHANDLER80121792211A695MissionSquare Retirement Target 2030 FundBalanced/Asset Allocation304$4,017,916.9705/31/2023
CITY OF CHANDLER80121792211A661MissionSquare Retirement Target 2035 FundBalanced/Asset Allocation320$3,197,644.3905/31/2023
CITY OF CHANDLER80121792211A638MissionSquare Retirement Target 2040 FundBalanced/Asset Allocation326$2,172,083.6505/31/2023
CITY OF CHANDLER80121792211A596MissionSquare Retirement Target 2045 FundBalanced/Asset Allocation259$1,402,387.2405/31/2023
CITY OF CHANDLER80121792211A562MissionSquare Retirement Target 2050 FundBalanced/Asset Allocation251$787,336.6205/31/2023
CITY OF CHANDLER80121792211R474MissionSquare Retirement Target 2055 FundBalanced/Asset Allocation211$324,656.8105/31/2023
CITY OF CHANDLER80121792211A133MissionSquare Retirement Target 2060 FundBalanced/Asset Allocation148$147,739.4605/31/2023
CITY OF CHANDLER80121792211A869MissionSquare Retirement Target Income FundBalanced/Asset Allocation75$1,254,681.6305/31/2023
CITY OF CHANDLER80121792211A364MissionSquare 500 Stock Index FundU.S. Stock138$1,343,421.4805/31/2023
CITY OF CHANDLER80121792211A166MissionSquare Aggressive Opportunities FundU.S. Stock56$391,813.3005/31/2023
CITY OF CHANDLER80121792211A299MissionSquare Broad Market Index FundU.S. Stock52$591,013.5805/31/2023
CITY OF CHANDLER80121792211A398MissionSquare Equity Income FundU.S. Stock47$341,039.6705/31/2023
CITY OF CHANDLER80121792211A331MissionSquare Growth & Income FundU.S. Stock59$291,812.7405/31/2023
CITY OF CHANDLER80121792211A265MissionSquare Growth FundU.S. Stock53$404,458.8105/31/2023
CITY OF CHANDLER80121792211A190MissionSquare Mid/Small Company Index FundU.S. Stock69$311,403.6705/31/2023
CITY OF CHANDLER80121792211A232MissionSquare Select Value FundU.S. Stock37$116,170.4805/31/2023
CITY OF CHANDLER80121792211R201MissionSquare Small Cap Discovery FundU.S. Stock17$34,175.0305/31/2023
CITY OF CHANDLER80121792211R458MissionSquare Emerging Markets FundInternational/Global Stock20$19,452.6905/31/2023
CITY OF CHANDLER80121792211R805MissionSquare International FundInternational/Global Stock58$180,502.5705/31/2023
CITY OF CHANDLER80121792211R508MissionSquare Overseas Equity Index FundInternational/Global Stock53$265,941.4905/31/2023

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