4-City of Tempe Market Values 2Q2025.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Financial Recordkeeper State and local contract opportunity
Solicitation number
26-018
Issued by
Maricopa County, Tucson City, Arizona

About this file

Written by GovTribe AI ·

This is a quarterly investment portfolio report for the City of Tempe, Arizona's retirement plans, showing market values and participant counts for Q2 2025. The file documents investment holdings across four separate retirement plans: the City of Tempe 457(b) plan, 401(k) plan, Pre-Medicare plan, and Group Three plan, with a total combined portfolio value exceeding $250 million. The report details specific fund allocations across various asset categories including target-date retirement funds from American Funds, index funds from Fidelity and Vanguard, international funds, bonds, small-cap and mid-cap equity funds, and stable value investments, with participant counts ranging from single digits to over 1,400 participants per fund option.

The portfolio structure reveals significant concentrations in conservative investments, with Prudential Stable Value funds holding approximately $40 million across plans and serving nearly 3,000 total participants, while Schwab Personal Choice Retirement Accounts represent another $64.7 million in self-directed investments. The largest individual fund holdings include the Fidelity 500 Index Fund with over $35 million across all plans and T. Rowe Price Large Cap Growth with more than $20 million total. This investment data directly relates to the City of Tempe's solicitation for a new financial recordkeeper to provide retirement plan administration, recordkeeping, education, and investment-related services for these same 401(k), 457(b), and PEHP plans, indicating the substantial scale and complexity of the retirement benefits administration contract opportunity.

View the file

Other files for this state and local contract opportunity

Other files attached to Financial Recordkeeper, newest first.
File Type Posted
11-26-018 Bid Tabulation.pdf PDF
6-Executed 457 Adoption Agreement.pdf PDF
3-Basic Plan Document 0046648002.pdf PDF
8-Pre Medicare PEHP.pdf PDF
1-26-018 RFP.docx DOCX document
10-26-018 Addendum 1.docx DOCX document
2-Basic Plan Document 0046648001.pdf PDF
5-Executed 401k Adoption Agreement.pdf PDF
7-Group Three PEHP.pdf PDF
9-Stable Value - Fixed Flows.xlsx XLSX spreadsheet

On GovTribe

Work with this file on GovTribe

  • 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.

Sheet1

Plan NameInvestment NameCUSIPAsset CategoryTickerCurrent Qtr BalanceParticipants
CITY OF TEMPE-457AmFds 2010 TrgtDtRtrmt R602630T282Asset AllocationRFTTX$265,428.0767
CITY OF TEMPE-457AmFds 2020 TrgtDtRtrmt R602630T316Asset AllocationRRCTX$3,233,705.93183
CITY OF TEMPE-457AmFds 2025 TrgtDtRtrmt R602630T324Asset AllocationRFDTX$1,387,851.8530
CITY OF TEMPE-457AmFds 2030 TrgtDtRtrmt R602630T332Asset AllocationRFETX$10,732,865.03447429
CITY OF TEMPE-457AmFds 2035 TrgtDtRtrmt R602630T340Asset AllocationRFFTX$1,017,272.9147
CITY OF TEMPE-457AmFds 2040 TrgtDtRtrmt R602630T357Asset AllocationRFGTX$11,472,381.90460
CITY OF TEMPE-457AmFds 2045 TrgtDtRtrmt R602630T365Asset AllocationRFHTX$508,948.4962
CITY OF TEMPE-457AmFds 2050 TrgtDtRtrmt R602630T373Asset AllocationRFITX$6,363,707.09384
CITY OF TEMPE-457AmFds 2055 TrgtDtRtrmt R602630T217Asset AllocationRFKTX$590,129.4985
CITY OF TEMPE-457AmFds 2060 TrgtDtRtrmt R602631C320Asset AllocationRFUTX$2,900,456.75314
CITY OF TEMPE-457AmFds 2065 TrgtDtRtrmt R602631V591Asset AllocationRFVTX$64,640.0850
CITY OF TEMPE-457AmFds New Prspct R6648018810InternationalRNPGX$3,955,424.21352
CITY OF TEMPE-457DFA US Trgt Val Inst233203595Small CapDFFVX$1,110,508.08470
CITY OF TEMPE-457Fid 500 Indx315911750Large CapFXAIX$20,624,711.13625
CITY OF TEMPE-457Fid MdCap Indx316146265Mid CapFSMDX$4,552,920.11272
CITY OF TEMPE-457Fid SmCap Indx316146182Small CapFSSNX$1,675,174.14112
CITY OF TEMPE-457Fid Ttl Bd K631617L764BondsFTKFX$3,705,597.27379
CITY OF TEMPE-457Fid Ttl Intl Indx31635V638InternationalFTIHX$3,490,314.29398
CITY OF TEMPE-457Fid US Bd Indx316146356BondsFXNAX$2,445,517.36238
CITY OF TEMPE-457Harbor SmCap Gr Rtrmt411512494Small CapHNSGX$164,149.66158
CITY OF TEMPE-457JPM SmCap Eq R648127B862Small CapVSENX$4,071,809.50698
CITY OF TEMPE-457MFS MdCap Gr R6552987554Mid CapOTCKX$5,580,923.94611
CITY OF TEMPE-457Prudential Stbl Val74490A869Short-Term InvestmentsPSV0X$25,980,242.291,442
CITY OF TEMPE-457Schwab Personal Choice Retirement AccountNot Applicable$54,853,099.72294
CITY OF TEMPE-457TRowePr LgCap Gr I45775L408Large CapTRLGX$12,928,835.38754
CITY OF TEMPE-457Virtus Crdex MdCpValEq R692837F441Mid CapSMVZX$1,994,712.08461
CITY OF TEMPE-457Vngrd Eq Inc Adml921921300Large CapVEIRX$5,917,942.32662
CITY OF TEMPE-457Vngrd Intl Gr Adml921910501InternationalVWILX$2,427,858.75465
CITY OF TEMPE-457Vngrd Intl Val Inv921939203InternationalVTRIX$4,470,160.29507
CITY OF TEMPE-457Vngrd RealEst Indx Adml921908877SpecialtyVGSLX$989,671.03495
CITY OF TEMPE-401KAmFds 2010 TrgtDtRtrmt R602630T282Asset AllocationRFTTX$248,982.0261
CITY OF TEMPE-401KAmFds 2020 TrgtDtRtrmt R602630T316Asset AllocationRRCTX$1,671,165.48173
CITY OF TEMPE-401KAmFds 2025 TrgtDtRtrmt R602630T324Asset AllocationRFDTX$356,232.6017
CITY OF TEMPE-401KAmFds 2030 TrgtDtRtrmt R602630T332Asset AllocationRFETX$6,938,407.18470
CITY OF TEMPE-401KAmFds 2035 TrgtDtRtrmt R602630T340Asset AllocationRFFTX$433,267.8146
CITY OF TEMPE-401KAmFds 2040 TrgtDtRtrmt R602630T357Asset AllocationRFGTX$4,726,061.51438
CITY OF TEMPE-401KAmFds 2045 TrgtDtRtrmt R602630T365Asset AllocationRFHTX$90,154.0759
CITY OF TEMPE-401KAmFds 2050 TrgtDtRtrmt R602630T373Asset AllocationRFITX$3,561,619.61444
CITY OF TEMPE-401KAmFds 2055 TrgtDtRtrmt R602630T217Asset AllocationRFKTX$242,170.6994
CITY OF TEMPE-401KAmFds 2060 TrgtDtRtrmt R602631C320Asset AllocationRFUTX$1,846,554.00320
CITY OF TEMPE-401KAmFds 2065 TrgtDtRtrmt R602631V591Asset AllocationRFVTX$222,530.5654
CITY OF TEMPE-401KAmFds New Prspct R6648018810InternationalRNPGX$1,609,370.12361
CITY OF TEMPE-401KDFA US Trgt Val Inst233203595Small CapDFFVX$567,445.93374
CITY OF TEMPE-401KFid 500 Indx315911750Large CapFXAIX$13,478,844.27581
CITY OF TEMPE-401KFid MdCap Indx316146265Mid CapFSMDX$1,883,027.73240
CITY OF TEMPE-401KFid SmCap Indx316146182Small CapFSSNX$624,184.20101
CITY OF TEMPE-401KFid Ttl Bd K631617L764BondsFTKFX$1,990,432.25349
CITY OF TEMPE-401KFid Ttl Intl Indx31635V638InternationalFTIHX$2,273,383.15362
CITY OF TEMPE-401KFid US Bd Indx316146356BondsFXNAX$1,981,791.98223
CITY OF TEMPE-401KHarbor SmCap Gr Rtrmt411512494Small CapHNSGX$110,345.42141
CITY OF TEMPE-401KJPM SmCap Eq R648127B862Small CapVSENX$3,034,931.21639
CITY OF TEMPE-401KMFS MdCap Gr R6552987554Mid CapOTCKX$3,781,320.37590
CITY OF TEMPE-401KPrudential Stbl Val74490A869Short-Term InvestmentsPSV0X$14,094,536.721,338
CITY OF TEMPE-401KSchwab Personal Choice Retirement AccountNot Applicable$9,884,383.13135
CITY OF TEMPE-401KTRowePr LgCap Gr I45775L408Large CapTRLGX$7,850,705.76725
CITY OF TEMPE-401KVirtus Crdex MdCpValEq R692837F441Mid CapSMVZX$1,571,706.75402
CITY OF TEMPE-401KVngrd Eq Inc Adml921921300Large CapVEIRX$2,636,867.87584
CITY OF TEMPE-401KVngrd Intl Gr Adml921910501InternationalVWILX$1,315,229.98408
CITY OF TEMPE-401KVngrd Intl Val Inv921939203InternationalVTRIX$3,120,572.56485
CITY OF TEMPE-401KVngrd RealEst Indx Adml921908877SpecialtyVGSLX$502,052.84427
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2010 TrgtDtRtrmt R602630T282Asset AllocationRFTTX$6,774,117.59216
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2020 TrgtDtRtrmt R602630T316Asset AllocationRRCTX$302,845.9223
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2025 TrgtDtRtrmt R602630T324Asset AllocationRFDTX$126,442.747
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2030 TrgtDtRtrmt R602630T332Asset AllocationRFETX$633,505.7231
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2035 TrgtDtRtrmt R602630T340Asset AllocationRFFTX$85,639.626
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2040 TrgtDtRtrmt R602630T357Asset AllocationRFGTX$215,196.6812
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2045 TrgtDtRtrmt R602630T365Asset AllocationRFHTX$7,917.023
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2050 TrgtDtRtrmt R602630T373Asset AllocationRFITX$85,396.837
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2055 TrgtDtRtrmt R602630T217Asset AllocationRFKTX$7,332.553
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds 2060 TrgtDtRtrmt R602631C320Asset AllocationRFUTX$56,803.477
CITY OF TEMPE ARIZONA PRE MEDICAREAmFds New Prspct R6648018810InternationalRNPGX$192,467.2217
CITY OF TEMPE ARIZONA PRE MEDICAREDFA US Trgt Val Inst233203595Small CapDFFVX$123,877.5513
CITY OF TEMPE ARIZONA PRE MEDICAREFid 500 Indx315911750Large CapFXAIX$1,526,354.8448
CITY OF TEMPE ARIZONA PRE MEDICAREFid MdCap Indx316146265Mid CapFSMDX$269,096.7617
CITY OF TEMPE ARIZONA PRE MEDICAREFid SmCap Indx316146182Small CapFSSNX$82,079.4614
CITY OF TEMPE ARIZONA PRE MEDICAREFid Ttl Bd K631617L764BondsFTKFX$402,204.4619
CITY OF TEMPE ARIZONA PRE MEDICAREFid Ttl Intl Indx31635V638InternationalFTIHX$84,001.745
CITY OF TEMPE ARIZONA PRE MEDICAREFid US Bd Indx316146356BondsFXNAX$144,229.728
CITY OF TEMPE ARIZONA PRE MEDICAREHarbor SmCap Gr Rtrmt411512494Small CapHNSGX$17,266.213
CITY OF TEMPE ARIZONA PRE MEDICAREJPM SmCap Eq R648127B862Small CapVSENX$31,852.7111
CITY OF TEMPE ARIZONA PRE MEDICAREMFS MdCap Gr R6552987554Mid CapOTCKX$133,399.5718
CITY OF TEMPE ARIZONA PRE MEDICARENationwide Fixed FundFixed Assets/Cash$13,386,343.75931
CITY OF TEMPE ARIZONA PRE MEDICARETRowePr LgCap Gr I45775L408Large CapTRLGX$708,856.9634
CITY OF TEMPE ARIZONA PRE MEDICAREVanguard Treas MMkt Fd IS921932109Short-Term InvestmentsVUSXX$617,468.0718
CITY OF TEMPE ARIZONA PRE MEDICAREVirtus Crdex MdCpValEq R692837F441Mid CapSMVZX$132,258.978
CITY OF TEMPE ARIZONA PRE MEDICAREVngrd Eq Inc Adml921921300Large CapVEIRX$161,831.0618
CITY OF TEMPE ARIZONA PRE MEDICAREVngrd Intl Gr Adml921910501InternationalVWILX$208,321.0816
CITY OF TEMPE ARIZONA PRE MEDICAREVngrd Intl Val Inv921939203InternationalVTRIX$18,204.666
CITY OF TEMPE ARIZONA PRE MEDICAREVngrd RealEst Indx Adml921908877SpecialtyVGSLX$40,015.8111
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2010 TrgtDtRtrmt R602630T282Asset AllocationRFTTX$11,399,706.83265
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2020 TrgtDtRtrmt R602630T316Asset AllocationRRCTX$261,809.7734
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2025 TrgtDtRtrmt R602630T324Asset AllocationRFDTX$252,834.5422
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2030 TrgtDtRtrmt R602630T332Asset AllocationRFETX$2,066,902.12110
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2035 TrgtDtRtrmt R602630T340Asset AllocationRFFTX$448,322.2128
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2040 TrgtDtRtrmt R602630T357Asset AllocationRFGTX$2,270,529.7686
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2045 TrgtDtRtrmt R602630T365Asset AllocationRFHTX$448,933.9431
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2050 TrgtDtRtrmt R602630T373Asset AllocationRFITX$1,998,702.0682
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2055 TrgtDtRtrmt R602630T217Asset AllocationRFKTX$752,302.4440
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2060 TrgtDtRtrmt R602631C320Asset AllocationRFUTX$229,477.907
CITY OF TEMPE ARIZONA GROUP THREEAmFds 2065 TrgtDtRtrmt R602631V591Asset AllocationRFVTX$44,319.355
CITY OF TEMPE ARIZONA GROUP THREEAmFds New Prspct R6648018810InternationalRNPGX$361,908.2354
CITY OF TEMPE ARIZONA GROUP THREEDFA US Trgt Val Inst233203595Small CapDFFVX$169,108.8451
CITY OF TEMPE ARIZONA GROUP THREEFid 500 Indx315911750Large CapFXAIX$3,238,632.56145
CITY OF TEMPE ARIZONA GROUP THREEFid MdCap Indx316146265Mid CapFSMDX$837,162.20130
CITY OF TEMPE ARIZONA GROUP THREEFid SmCap Indx316146182Small CapFSSNX$490,394.3775
CITY OF TEMPE ARIZONA GROUP THREEFid Ttl Bd K631617L764BondsFTKFX$301,892.3055
CITY OF TEMPE ARIZONA GROUP THREEFid Ttl Intl Indx31635V638InternationalFTIHX$425,090.9166
CITY OF TEMPE ARIZONA GROUP THREEFid US Bd Indx316146356BondsFXNAX$287,202.1439
CITY OF TEMPE ARIZONA GROUP THREEHarbor SmCap Gr Rtrmt411512494Small CapHNSGX$806.251
CITY OF TEMPE ARIZONA GROUP THREEJPM SmCap Eq R648127B862Small CapVSENX$345,900.6195
CITY OF TEMPE ARIZONA GROUP THREEMFS MdCap Gr R6552987554Mid CapOTCKX$391,765.28114
CITY OF TEMPE ARIZONA GROUP THREENationwide Fixed FundFixed Assets/Cash$8,274,860.30440
CITY OF TEMPE ARIZONA GROUP THREETRowePr LgCap Gr I45775L408Large CapTRLGX$1,685,927.74152
CITY OF TEMPE ARIZONA GROUP THREEVanguard Treas MMkt Fd IS921932109Short-Term InvestmentsVUSXX$360,191.0630
CITY OF TEMPE ARIZONA GROUP THREEVirtus Crdex MdCpValEq R692837F441Mid CapSMVZX$140,953.8048
CITY OF TEMPE ARIZONA GROUP THREEVngrd Eq Inc Adml921921300Large CapVEIRX$819,502.40132
CITY OF TEMPE ARIZONA GROUP THREEVngrd Intl Gr Adml921910501InternationalVWILX$344,809.58101
CITY OF TEMPE ARIZONA GROUP THREEVngrd Intl Val Inv921939203InternationalVTRIX$299,486.6392
CITY OF TEMPE ARIZONA GROUP THREEVngrd RealEst Indx Adml921908877SpecialtyVGSLX$137,278.9671

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