City_of_Chandler_801218_801427_801217_Monthly_Plan_Assets_5.31.23.xlsx

XLSX spreadsheet 22 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 is a monthly plan assets report for the City of Chandler, Arizona, documenting retirement and deferred compensation plan fund holdings as of May 31, 2023. The report covers three distinct plan codes: 801217 (primary deferred compensation plan), 801218 (supplemental plan), and 801427 (retirement health savings plan). Plan 801217 represents the largest portfolio with 31 investment funds across multiple asset categories including stable value, bonds, balanced/asset allocation funds, U.S. stocks, and international equities, totaling approximately $29.6 million in assets across 2,471 participants. Plan 801218 contains minimal assets of approximately $8,415.77 distributed across two funds with only two participants, while Plan 801427 holds approximately $462,786.10 across eleven funds with 42 participants. The report itemizes each fund by CUSIP number, ticker symbol, asset category classification, number of participants with balances, fund balance amounts, and effective date, providing detailed transparency into the investment allocation across the City's retirement savings programs.

The asset distribution reflects a diversified investment strategy managed through MissionSquare, with significant concentration in target-date retirement funds and balanced portfolios designed to accommodate varying participant risk profiles and retirement timelines. The largest single holding is the MissionSquare Retirement Target 2030 Fund with 304 participants and $4,017,916.97 in assets, followed by the Target 2025 Fund with 280 participants and $4,014,234.58. The report demonstrates the City's comprehensive approach to retirement plan administration, with participants distributed across conservative to aggressive investment options including emerging markets, international equity index funds, and small-cap discovery funds. All fund balances are presented as of the effective date of May 31, 2023, providing a snapshot of the portfolio composition that would inform the administration and investment oversight requirements outlined in the concurrent Request for Proposals issued by the City for deferred compensation and retirement health savings plan services.

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_801217_Monthly_Plan_Assets_5.31.23.xlsx XLSX spreadsheet
City_of_Chandler_301601_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

801218

Report Dates: 05/2023 to 05/2023
Plan NamePlan CodeCUSIPTickerFund Long NameAsset CategoryParticipants With BalanceFund BalanceEffective Date
CITY OF CHANDLER80121892211A794MissionSquare Retirement Target 2015 FundBalanced/Asset Allocation1$7,934.3005/31/2023
CITY OF CHANDLER80121892211A638MissionSquare Retirement Target 2040 FundBalanced/Asset Allocation1$481.4705/31/2023

801427

Report Dates: 05/2023 to 05/2023
Plan NamePlan CodeCUSIPTickerFund Long NameAsset CategoryParticipants With BalanceFund BalanceEffective Date
CITY OF CHANDLER80142792211R383MissionSquare PLUS FundStable Value/Cash Management2$55,068.9205/31/2023
CITY OF CHANDLER80142792211A802MissionSquare Inflation Focused FundBond1$45,612.7405/31/2023
CITY OF CHANDLER80142792211A430MissionSquare Model Portfolio Global Equity Growth FundBalanced/Asset Allocation1$23,281.8805/31/2023
CITY OF CHANDLER80142792211A794MissionSquare Retirement Target 2015 FundBalanced/Asset Allocation8$86,688.5105/31/2023
CITY OF CHANDLER80142792211A760MissionSquare Retirement Target 2020 FundBalanced/Asset Allocation5$48,144.8305/31/2023
CITY OF CHANDLER80142792211A869MissionSquare Retirement Target Income FundBalanced/Asset Allocation19$161,450.3505/31/2023
CITY OF CHANDLER80142792211A364MissionSquare 500 Stock Index FundU.S. Stock2$21,937.1805/31/2023
CITY OF CHANDLER80142792211A166MissionSquare Aggressive Opportunities FundU.S. Stock1$3,631.7305/31/2023
CITY OF CHANDLER80142792211A398MissionSquare Equity Income FundU.S. Stock1$7,387.6405/31/2023
CITY OF CHANDLER80142792211A265MissionSquare Growth FundU.S. Stock1$22,183.9905/31/2023
CITY OF CHANDLER80142792211R805MissionSquare International FundInternational/Global Stock1$6,497.3305/31/2023

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