9-Stable Value - Fixed Flows.xlsx

This Excel file contains quarterly cash flow data for the City of Tempe's stable value and fixed fund investments across multiple retirement plans from 2023 through 2025, related to the City's Financial Recordkeeper contract opportunity seeking qualified firms to provide retirement plan administration, recordkeeping, education, communications, and investment-related services for their 401(k), 457(b), and PEHP Plans. The data tracks contributions and distributions for three distinct investment products: Prudential Stable Value funds for both the City of Tempe 457(b) Plan and 401(k) Plan, and Nationwide Fixed Fund for both the Arizona Group Three and Arizona Pre Medicare plans, with quarterly reporting periods spanning from January 1, 2023 through June 30, 2025.

The financial data reveals consistent net outflows across all fund types, with distributions consistently exceeding contributions in nearly every quarter. The Prudential Stable Value funds show the largest absolute dollar amounts, with quarterly contributions ranging from approximately $200,000 to $1.3 million and distributions from $400,000 to $2.3 million. The Arizona Pre Medicare Nationwide Fixed Fund demonstrates the highest activity levels with quarterly contributions between $1.5-1.8 million and distributions of $1.0-1.3 million, while the Arizona Group Three fund shows the smallest volumes with contributions around $100,000-280,000 and distributions of $35,000-60,000 per quarter. This cash flow pattern suggests an aging workforce with more retirees drawing benefits than active employees contributing to the plans, which would be critical information for any financial recordkeeper evaluating the service requirements and complexity of managing these retirement plans.