Agenda — Finance Committee, March 25, 2024

AGENDA

FINANCE COMMITTEE

SPECIAL MEETING NOTICE
MARCH 25, 2024
PUBLIC MEETING 4:00 P.M.

Members
Victor M. Gordo, Mayor
Tyron Hampton, District 1
Felicia Williams, District 2
STAFF
Matthew Hawkesworth, Director of Finance
Theresa Fuentes, Assistant City Attorney
Gloria Acevedo, Recording Secretary

MISSION STATEMENT
The City of Pasadena is dedicated to delivering exemplary municipal services, responsive to our entire community and consistent
with our history, culture and unique character.

In compliance with the Americans with Disabilities Act of 1990, Assistive Listening Devices are available from the City Clerk’s Office with a 24-hour advance notice.

Please call (626) 744-4124 to request use of a listening device.

Language translation services are available for this meeting by calling (
626)744-4124 at least 24 hours in advance.

Habrá servicio de interpretación disponible para éstas juntas llamando al (626)744-4124 por lo menos con 24 horas de anticipación.

Meet
ings are broadcast live on cable Channel 3 and on the Internet at http://pasadena.granicus.com/mediaplayer.php?came ra_id=2&publish_id=9 and https://www.pasadenamedia.org/watch/ (Click on Video Streamlining on the right side of the screen).

I
tems on the agenda may not be called in order listed. Agendas and supporting documents are available on the Internet at
https://www.cityofpasadena.net/commissions/city-council-finance-committee/ Mat
erials related to an item on this Agenda submitted to the Finance/Audit Committee after distribution of the agenda packet will be posted online and listed as: “Supplemental Agenda Material Received after the Posting of the agenda”

PUBLIC COMMENT AT THE FINANCE COMMITTEE SPECIAL MEETING FOR MARCH 25, 2024, AT 4:00 P.M. WILL BE ACCEPTED IN-PERSON AND BY VIDEOCONFERENCE/TELECONFERENCE.

Link to City Meeting Policy:
cityofpasadena.net/CityCouncilMeetingPolicy
TO VIEW A LIVE STREAM OF THE MEETING:
http://pasadena.granicus.com/MediaPlayer.php?publish_id=9 AND
WWW.PASADENAMEDIA.ORG
In order to facilitate public participation at meetings the City will accept public comment in the following manner:

1. Whether participating in-person or virtually at the meeting, members of the public may provide public comment by submitting a speaker card prior to the start of public comment on that item, at the following webpage:
www.cityofpasadena.net/commissions/public-comment/
If a public comment speaker wishes to speak on more than one agenda item, please indicate which items on the online form (multiple item speakers will be handled according to the process posted on the agenda and as specified in the City meeting policy). Public comments are limited to 3 minutes each, and the Chair and Committee may limit this time if reasonable under the circumstances.

2. In-person Meeting Participation: Complete an online speaker card at the following website: www.cityofpasadena.net/commissions/public-comment/ After submitting a public speaker card, members of the public may attend the meeting in-person by coming to the Pasadena City Council Chamber, Room S249 at City Hall at the date and start-time of the posted meeting.

Virtual Meeting Participation: For virtual participants, you may attend by connecting to the meeting using a computer, other electronic device, or by telephone. Please review the agenda to identify the published start time for the meeting and connect to the meeting just prior to, or at the start of the meeting.

To participate in public comment for an item and to be recognized to speak, it is required that the speaker login to the meeting using the same name or telephone number used on the Speaker Card form. This will allow City staff to locate and promote the speaker into the meeting when it is time for their public comment.

Participants’ phone calls to the Committee meeting will be recorded as part of the Committee meeting. By staying on the line and making public comment during the Committee meeting by phone, you are agreeing to have your phone call recorded. Following is the connectivity information for virtual participation:

Computer or electronic devices, join the meeting at: cityofpasadena.net/cczoom Telephone only dial-in: 1-669-900-6833, Meeting ID: 161 482 446

3. Speaker Card Help Line: If a public comment speaker needs assistance in completing a speaker card, please call the City Clerk’s Office at: (626) 744-4124.

Help line will open 30 minutes prior to the posted start time of the meeting.

4. Members of the public may submit correspondence of any length prior to the start of the meeting, at the following email address:
[email protected]
Correspondence will be forwarded to the Committee prior to the start of the meeting, posted online, and made part of the legislative record for the item.

LIVESTREAM WITH CAPTIONING IS AVAILABLE AT WWW.PASADENAMEDIA.ORG, AND ALSO AT WWW.CITYOFPASADENA.NET/COMMISSIONS/AGENDAS,

IF YOU NEED A REASONABLE MODIFICATION OR ACCOMMODATION PURSUANT

TO THE AMERICANS WITH DISABILITIES ACT

BECAUSE YOU ARE UNABLE TO PARTICIPATE ELECTRONICALLY AS SET FORTH ABOVE, CONTACT THE CITY CLERK’S OFFICE
AS SOON AS POSSIBLE AT (626) 744-4124 OR
[email protected].

SPECIAL MEETING
AGENDA

FINANCE COMMITTEE
M
ARCH 25, 2024
Public Meeting: 4:00 P.M.

Council Chamber, Pasadena City Hall
100 North Garfield Avenue, Room S249
PUBLIC MEETING – 4:00 P.M.

ROLL CALL
PUBLIC COMMENT – LIMITED TO ITEMS ON THIS SPECIAL MEETING

AGENDA AND WILL BE HEARD AT THE TIME THE ITEM IS

CONSIDERED

APPROVAL OF MINUTES
F
ebruary 26, 2024 Special Meeting
March 11, 2024 Cancellation Notice

NEW BUSINESS

1. QUARTERLY INVESTMENT REPORT- QUARTER ENDING DECEMBER 31, 202
3 INFORMATION ONLY

2. COVID-19 REIMBURSEMENT FINANCIAL UPDATE

ADJOURN
A

PPROVAL OF MINUTES
 February 26, 2024 Special Meeting
 March 11, 2024 Cancellation Notice
01 2/26/24 Finance Committee

CITY OF PASADENA

FINANCE COMMITTEE MINUTES

PASADENA CITY HALL
100 NORTH GARFIELD AVENUE
CITY HALL COUNCIL CHAMBER S249
FEBRUARY26, 2024

SPECIAL MEETING
O
PENING Chair Gordo called the special meeting of the Finance Committee to order at 3:16 p.m.

RO
LL CALL: Mayor Victor M. Gordo (Chair)
Councilmember Tyron Hampton ( Arrived at 3:15 p.m.)
Councilmember Felicia Williams (Absent)
Staff: Miguel Márquez, City Manager
Brenda Harvey-Williams, Assistant City Manager
Theresa Fuentes, Assistant City Attorney
Matthew Hawkesworth, Acting Assistant City Manager/Director of Finance Tony Olmos, Director of Public Works
Chad Augustin, Fire Chief
Joaquin Siques, Acting Director of Transportation
Tiffany Jacobs-Quinn, Director of Human Resources
Tim McDonald, Director of Library and Information Services Michael Paliwoda, Principal Human Resources Analyst
Kris Markarian, Deputy Director of Public Works/City Engineer Varoojan Avedian, Acting Assistant General Manager
Jonathan Paul, Principal Administrative Analyst
Tim Park, Budget Administrator
Thanos Gauthier, Public Works Administrator
Denise Garcia, Acting Management Analyst IV
Jim Wong, Senior Project Manager
Sebastian Hernandez, Principal Planner
Chinua Obaze, Management Analyst III
Gloria Acevedo, Recording Secretary
Gu
ests: Rev. Megan Katerjian, Chief Executive Officer, Door of Hope AP
PROVAL OF MINUTES: It was moved by Councilmember Hampton, seconded by Chair Gordo, to approve the minutes of the January 22, 2024 (special meeting) and the February 12, 2024, cancellation notice, as submitted. (Motion Unanimously carried) (Absent: Councilmember Williams) 02 2/26/24 Finance Committee

NEW BUSINESS AUTHORIZE THE CITY MANAGER TO EXECUTE ALL AGREEMENTS

FOR THE RECEIPT OF LOW CARBON TRANSIT OPERATIONS
PROGRAM (LCTOP) FUNDS IN THE AMOUNT OF $4,434 FROM THE

CITY OF MONTEBELLO
Chair Gordo introduced the item and Miguel Márquez, City Manager, introduced Joaquin Siques, Acting Director of Transportation, who provided a PowerPoint presentation.

It was moved by Councilmember Hampton, seconded by Chair Gordo, to approve staff’s recommendation and forward the item to the City Council for consideration. (Motion Unanimously carried) (Absent: Councilmember Williams)
AMENDMENT OF THE HOUSING DEPARTMENT'S FISCAL YEAR 2024
OPERATING BUDGET IN THE AMOUNT OF $1,903,12 1; APPROVAL

OF KEY BUSINESS TERMS OF AN AFFORDABLE HOUSING LOAN

AGREEMENT WITH DOOR OF HOPE FOR THE DEVELOPMENT OF A
TRANSITIONAL HOUSING PROJECT AT 724 N. MARENGO AVENUE

TO SERVE UNHOUSED PERSONS AND FAMILIES
Chair Gordo introduced the item and Jim Wong, Senior Project Manager, provided a PowerPoint presentation and responded to questions.

Councilmember Hampton requested clarification of the term “family”, asked about the duration that families stay in transition, and the success rate of the program. Rev. Megan Katerjian, Door of Hope, defined “family” as a parent or legal guardian holding custody of a child seventeen years of age and younger, families in Pasadena are expected to stay in transition for 7-8 months, and the success rate for one year is 95%, while the rate for five-years is 86%.

Councilmember Hampton also suggested for the Pasadena Housing Department and Door of Hope to work with participants to prepare them for future home ownership opportunities and expressed his gratitude to Door of Hope for their work. Chair Gordo echoed Councilmember Hampton’s comment.

Gloria Acevedo, recording secretary, advised the Finance Committee that 27 letters of correspondence were received supporting the item.

There were two public speakers in support of the item moving on to the full City Council:

W
endi Gaines, Pasadena Resident
Angela Lee, Pasadena Resident
It was moved by Councilmember Hampton, seconded by Chair Gordo, to approve staff’s recommendation and forward the item to the City Council 03 2/26/24 Finance Committee
for consideration. (Motion Unanimously carried) (Absent: Councilmember Williams)

RECOGNIZE AND APPROPRIATE FUNDS IN THE AMOUNT OF
$29,142 TO THE DEPARTMENT OF LIBRARIES AND INFORMATION
SERVICES’ FISCAL YEAR 2024 OPERATING BUDGET
Chair Gordo introduced the item and Chinua Obaze, Management Analyst III, provided a PowerPoint presentation and responded to questions.

Councilmember Hampton requested clarification on where the funds would be expended and for data representing program participation. Mr. Obaze responded that Jefferson School would be the primary location where the funds will be utilized and shared that last year, the program provided 647 lunch meals, 230 supplemental meal kits to families, 1,422 craft kits, 1,488 books, and had a total of 2,17 5 participants across all Pasadena Unified District sites.

Councilmember Hampton and Chair Gordo thanked staff for their work.

It was moved by Councilmember Hampton, seconded by Chair Gordo, to approve staff’s recommendation and forward the item to the City Council for consideration. (Motion Unanimously carried) (Absent: Councilmember Williams)
AMENDMENTS TO THE FISCAL YEAR 2024 ADOPTED OPERATING
BUDGET
Chair Gordo introduced the item and Matthew Hawkesworth, Acting Assistant City Manager/Director of Finance, introduced Jonathan Paul, Principal Administrative Analyst, who gave a brief outline of the item.

It was moved by Councilmember Hampton, seconded by Chair Gordo, to approve staff’s recommendation and forward the item to the City Council for consideration. (Motion Unanimously carried) (Absent: Councilmember Williams)
AUTHORIZATION TO INCREASE CONTRACT NO. 31537 WITH
AMERICAN RECLAMATION, INC. BY $1,673,568 AND ADD TWO

ADDITIONAL ONE -YEAR OPTIONS TO PROVIDE MATERIAL

RECOVERY PROCESSING
Chair Gordo introduced the item and Tony Olmos, Director of Public Works, provided a brief introduction and Thanos Gauthier, Public Works Administrator, provided a PowerPoint presentation and responded to questions.

Chair Gordo requested for staff to provide an update to the City Council on how the closing of Scholl Canyon may have a financial impact to the City. 04 2/26/24 Finance Committee
Mr. Gauthier will provide an update on the department’s diversion efforts at a future Municipal Services Committee meeting.

Councilmember Hampton asked staff to explore the opportunity to negotiate a fee reduction with the new Irwindale facility pri or to their opening and the issuance of a Request for Proposal (RFP). Mr. Olmos sated that the action would require exclusive negotiation and the current plan is to move forward with the RFP.

MONITORING REPORT
Chair Gordo introduced the item and Tony Olmos, Director of Public Works, introduced Denise Garcia, Acting Management Analyst IV, who provided a brief outline of the item and responded to questions.

Chair Gordo thanked staff for their work with the Washington Pa rk Community House.

Councilmember Hampton requested an update on playground shade structures at City Parks. Mr. Olmos shared that an award to commence work at Washington Park is slated for March 11, 2024, and that there are three parks in the design phase, staff is working with the Parks, Recreation and Community Services Department on funding strategies. Updates will be provided at future Finance Committee Meetings.

On the order of the Chair and consensus of the Committee, the item was received and filed.

ADJOURNMENT On the order of the Chair, the special meeting of the Finance Committee was adjourned at 4:08 p.m.

A
TTEST: ______________________
Mayor Victor Gordo, Chair
Finance Committee
____
________________
Gloria Acevedo
Recording Secretary

NEW BUSINESS
ITEM 1

1. QUARTERLY INVESTMENT REPORT- QUARTER
ENDING DECEMBER 31, 2023

City of Pasad ena
Quarterly Investment Report
Quarter Ending 12/31/2023
Prepared by the Department of Finance
Treasury Division
Attachment A

Quarterly Investment Report

I. Pooled Investment Portfolio

II. Capital Endowment Portfolio

III. Power Reserve Portfolio

IV. Miscellaneous Portfolios

V. Investments Held by Trustees

VI. PARS Section 115 Trust

I. Pooled Investment Portfolio

CITY OF PASADENA
Treasurer's Pooled Investment Portfolio
Vicken Erganian
City Treasurer
December 2023

PORTFOLIO COMPLIANCE
The Treasurer's investment portfolio is in compliance with the California Government Code Section 53601 and the City's Investment Policy approved by the City Council on June 12, 2023. The holdings in the investment pool are in compliance with the current investment policy statement. Further information on compliance issues can be obtained by calling the City of Pasadena Treasurer's Office. A complete copy of the monthly investment report on the investment portfolio including a detailed listing of each investment, is available by calling the Treasurer's office at (626)744-4422.

PORTFOLIO STRUCTURE AS OF 12/31/2023

TYPE MARKET VALUE PERCENT
Money Market - Collateralized 1,180 0.00% Certificates of Deposit 1,250,000 0.18%
Municipal Bonds 29,941,712 4.28%
Corporate Bonds 80,995,186 11.59%
Federal Agencies 390,943,604 55.93%
US Treasury Securities 43,589,902 6.24%
Supranationals 34,088,324 4.88%
Commercial Paper 24,126,950 3.45%
Money Market-CAMP 90,935,342 13.01%
LAIF 1,285,427 0.18%
Cash in Bank 1,793,390 0.26%
TOTALS: 698,951,018 100.00%
Accrued Interest Receivable 2,558,737
GRAND TOTAL: 701,509,755
PORTFOLIO LIQUIDITY AS OF 12/31/2023
Percent of
Aging Interval Par Value Portfolio
0-30 Days 114,015,340 15.55%
31 days - 1 Year 168,800,000 23.03%
1 - 2 Years 240,442,778 32.80%
2 - 3 Years 135,808,000 18.53%
3 - 4 Years 26,975,000 3.68%
4 - 5 Years 47,000,000 6.41%
Over 5 Years - 0.00%
TOTAL: 733,041,118 100.00%
Dec-23 Nov-23 Oct-23 Sep-23 Aug-23 Jul-23
Month-End Market Value 701,509,755 687,571,018 691,437,198 677,018,590 665,039,870 657,051,757 Modified Duration 1.45 1.38 1.28 1.28 1.38 1.47
Weighted Average Maturity 1.56 1.50 1.38 1.38 1.48 1.57 Current Book Yield to Maturity 2.690% 2.458% 2.296% 2.223% 2.143% 2.083% Effective Yield - Year to Date 2.240% 2.200% 2.150% 2.120% 2.090% 2.090% Interest Earned 1,383,204 1,355,631 1,311,121 1,202,291 1,111,375 1,115,809 Fiscal Year To Date Interest Earned 7,479,431 6,096,227 4,740,597 3,429,475 2,227,184 1,115,809 Fair Value Change Gain/(Loss) 4,994,842 4,337,301 1,589,352 (16,094) 1,573,542 1,285,606 Fiscal Year To Date change in fair value 13,764,550 8,769,708 4,432,406 2,843,054 2,859,147 1,285,606 Total Fiscal YTD Earnings 21,243,981 14,865,935 9,173,003 6,272,529 5,086,331 2,401,414

PORTFOLIO STATISTICS
MMF-Collateral

0.00%
Certificates of
Deposit

0.18%
Muni

4.28%
Corp Bond

11.59%
Fed Agency

55.93%
US Treasury

6.24%
Supranationals

4.88%
Commercial
Paper

3.45%
Money Market-
CAMP

13.01%
LAIF

0.18%
Cash in Bank

0.26%
1 1
YTM
365

Page 1 ends

3.960Local Agency Investment Fund864 1,038,937.96 1,038,937.96 3.9601,038,937.96SYS864 1

3.960LAIF-COVID Relief Funds Acct14053 246,489.53 246,489.53 3.960246,489.53SYS14053 1 1,285,427.491,285,427.491,285,427.491,285,427.49Subtotal and Average 3.960 1 Money Market Fund-CAMP

5.637California Asset Management Pr13824 90,935,341.98 90,935,341.98 5.56090,935,341.98SYS13824 1 90,935,341.9890,935,341.9890,935,341.9876,776,848.36Subtotal and Average 5.637 1 Collateralized Money Market

4.910EAST WEST BANK13067 1,179.87 1,179.87 4.9101,179.87SYS13067 1 1,179.871,179.871,179.871,179.87Subtotal and Average 4.910 1 Municipal Bonds

2.125Beverly Hills PFA13710 1,000,000.00 1,000,000.00 06/01/20242.12508/08/2019 987,390.00 AA+088006JM4 152

0.730Beverly Hills PFA13869 750,000.00 750,000.00 06/01/20240.73010/15/2020 736,350.00 AA+088006JY8 152

0.587City of Orange Taxable Pension13916 1,500,000.00 1,500,000.00 06/01/20240.58703/15/2021 1,473,315.00 AA684100AC4 152

2.070South Pasadena Unified School13748 325,000.00 330,269.44 08/01/20245.00012/12/2019 325,078.00 Aa2839278JX7 213

0.580SAN RAMON VLY CA UNIF SCH DIST13871 1,500,000.00 1,500,000.00 08/01/20240.58010/20/2020 1,463,520.00 Aa1799408Z77 213

0.575West Coast Contra Unified Scho13941 1,000,000.00 1,000,000.00 08/01/20240.57506/17/2021 975,930.00 AA9523474U3 213

0.685Califfornia State Univ Revenur13829 2,000,000.00 2,000,000.00 11/01/20240.68509/17/2020 1,930,840.00 Aa213077DMK5 305

0.982City of Arcadia13882 675,000.00 675,000.00 12/01/20240.98211/12/2020 650,551.50 Aaa039063AD4 335

0.650SANTA BARBARA CNTY CA SOLID WA13894 300,000.00 308,185.76 12/01/20243.67012/18/2020 296,481.00 A180136PDB6 335

5.377City of Corona Revenue Bond14035 1,500,000.00 1,419,287.16 05/01/20251.13111/27/2023 1,421,325.00 AA+21969AAD4 486

0.943Huntington Beach CA Public Fin13861 300,000.00 300,000.00 05/01/20250.94308/12/2020 284,649.00 AA446216HJ5 486

0.883UNIVERSITY OF CA REVENUE BONDS13827 1,000,000.00 1,000,000.00 05/15/20250.88307/16/2020 948,690.00 Aa291412HGE7 500

0.610UNIVERSITY OF CA REVENUE BONDS13893 5,000,000.00 5,018,435.62 05/15/20250.88312/16/2020 4,743,450.00 Aa291412HGE7 500

0.952California St Health Facs Fing13883 1,500,000.00 1,500,000.00 06/01/20250.95211/04/2020 1,420,380.00 Aa313032UXM5 517

0.824Redondo Beach Unified School13840 500,000.00 500,000.00 08/01/20250.82408/06/2020 469,575.00 Aa2757710TZ1 578

5.270San Jose Redevelopment Agency14034 2,000,000.00 1,934,266.89 08/01/20253.07611/24/2023 1,944,400.00 AA+798170AH9 578

2.311South Pasadena Unified School13747 675,000.00 701,794.07 08/01/20255.00012/12/2019 677,740.50 Aa2839278JY5 578

0.740SAN RAMON VLY CA UNIF SCH DIST13872 1,500,000.00 1,500,000.00 08/01/20250.74010/20/2020 1,411,155.00 Aa1799408Z85 578

0.938West Coast Contra Unified Scho13940 3,000,000.00 3,000,000.00 08/01/20250.93806/17/2021 2,833,410.00 AA9523474V1 578

1.181City of Arcadia13881 750,000.00 750,000.00 12/01/20251.18211/12/2020 701,632.50 Aaa039063AE2 700

5.738LOS ANGELES CA UNIF SCH DIST14027 1,975,000.00 1,973,918.49 05/01/20275.72010/20/2023 2,025,974.75 Aa3544646A77 1,216

5.190City of Corona Revenue Bond14036 2,500,000.00 2,181,532.66 05/01/20281.86311/29/2023 2,219,875.00 AA+21969AAG7 1,582 Portfolio PASD
APData Updated: SET_POOL: 01/23/2024 16:42
Run Date: 01/23/2024 - 16:43 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
2 YTM
365

Page 2 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
30,842,690.0929,941,712.2531,250,000.0030,837,718.52Subtotal and Average 1.974 566 Certificates of Deposit - Bank

0.650BMW BANK NORTH AMERICA13949 250,000.00 250,000.00 09/17/20240.65009/17/2021 250,000.0005580AD68 260

0.650SYNCHRONY BANK13952 250,000.00 250,000.00 09/17/20240.65009/17/2021 250,000.0087164YB60 260

0.650GOLDMAN SACHS BANK USA CD13951 250,000.00 250,000.00 09/23/20240.65009/22/2021 250,000.0038149MZY2 266

0.700SALLIE MAE BANK/SALT LKE CD13956 250,000.00 250,000.00 09/23/20240.70009/22/2021 250,000.00795451AW3 266

0.650UBS BANK USA13950 250,000.00 250,000.00 09/23/20240.65009/22/2021 250,000.0090348JT42 266 1,250,000.001,250,000.001,250,000.001,250,000.00Subtotal and Average 0.660 264 Federal Agency Issues - Coupon

5.126FED NATIONAL MORTGAGE ASSN14011 5,000,000.00 5,000,000.00 02/09/20245.12502/13/2023 4,998,211.75 Aaa3135GAEU1 39

5.250Federal Home Loan Bank14012 4,000,000.00 4,000,000.00 03/01/20245.25003/01/2023 3,999,091.64 Aaa3130AUZ23 60

5.200FED NATIONAL MORTGAGE ASSN14015 5,000,000.00 5,000,000.00 03/28/20245.20003/30/2023 4,998,331.20 Aaa3135GAFP1 87

0.500Federal Home Loan Bank13927 10,000,000.00 10,000,000.00 04/29/20240.50004/29/2021 9,840,168.30 Aaa3130ALXQ2 119

5.414Federal Home Loan Bank14017 5,000,000.00 5,000,000.00 06/07/20245.41005/10/2023 4,993,166.75 Aaa3130AVYY2 158

5.500Federal Home Loan Bank14020 5,000,000.00 5,000,000.00 06/28/20245.50006/28/2023 4,996,561.30 Aaa3130AWEX4 179

3.100FED HOME LOAN MORTAGE CORP13994 5,000,000.00 5,000,000.00 06/28/20243.10006/28/2022 4,950,071.55 Aaa3134GXYE8 179

0.625Federal Home Loan Bank13944 5,000,000.00 5,000,000.00 10/15/20240.62507/15/2021 4,830,938.90 Aaa3130AN4L1 288

0.500Federal Home Loan Bank13948 5,000,000.00 5,000,000.00 10/30/20240.50009/30/2021 4,818,643.30 Aaa3130ANYT1 303

0.900Federal Home Loan Bank13966 5,000,000.00 5,000,000.00 11/08/20240.90011/08/2021 4,830,158.70 Aaa3130APPQ2 312

1.100Federal Home Loan Bank13968 5,000,000.00 5,000,000.00 11/15/20241.10011/15/2021 4,836,278.35 Aaa3130APRA5 319

0.550Federal Home Loan Bank13937 10,000,000.00 10,000,000.00 11/26/20240.55005/26/2021 9,610,146.60 Aaa3130AMK92 330

0.650Federal Home Loan Bank13932 5,000,000.00 5,000,000.00 12/09/20240.65006/09/2021 4,804,032.95 Aaa3130AMJX1 343

1.150Federal Home Loan Bank13971 5,000,000.00 5,000,000.00 12/10/20241.15012/10/2021 4,829,863.65 Aaa3130AQ3F8 344

1.125Federal Home Loan Bank13973 5,000,000.00 5,000,000.00 01/21/20251.12501/21/2022 4,798,862.75 Aaa3130AQFG3 386

1.250Federal Home Loan Bank13975 5,000,000.00 5,000,000.00 01/28/20251.25001/28/2022 4,839,552.10 Aaa3130AQJ79 393

1.500Federal Home Loan Bank13977 5,000,000.00 5,000,000.00 02/18/20251.50002/18/2022 4,845,325.05 Aaa3130AQPF4 414

0.625Federal Home Loan Bank13933 5,000,000.00 5,000,000.00 02/27/20250.62505/27/2021 4,793,262.80 Aaa3130AMMG4 423

1.810Federal Home Loan Bank13979 4,700,000.00 4,700,000.00 02/27/20251.81002/28/2022 4,567,515.32 Aaa3130AQX99 423

0.650Federal Home Loan Bank13959 5,000,000.00 5,000,000.00 03/28/20250.65009/28/2021 4,779,377.85 Aaa3130AP5S0 452

3.000Federal Home Loan Bank13982 5,000,000.00 5,000,000.00 04/22/20253.00004/22/2022 4,913,859.40 Aaa3130ARJW2 477

0.750Federal Home Loan Bank13811 5,000,000.00 5,000,000.00 05/19/20250.75005/19/2020 4,759,766.40 Aaa3130AJLA5 504

3.400Federal Home Loan Bank13985 5,000,000.00 5,000,000.00 05/23/20253.40005/23/2022 4,934,443.80 Aaa3130ARZD6 508

0.750FED HOME LOAN MORTAGE CORP13814 5,000,000.00 5,000,000.00 05/28/20250.75005/28/2020 4,755,531.40 Aaa3134GVVX3 513

0.750FED HOME LOAN MORTAGE CORP13816 5,000,000.00 5,000,000.00 05/28/20250.75005/29/2020 4,755,531.40 Aaa3134GVB31 513

0.750FED HOME LOAN MORTAGE CORP13817 5,000,000.00 5,000,000.00 05/28/20250.75006/01/2020 4,755,531.40 Aaa3134GVB31 513 Portfolio PASD
APData Updated: SET_POOL: 01/23/2024 16:42
Run Date: 01/23/2024 - 16:43 PM (PRF_PM2) 7.3.0
3 YTM
365

Page 3 ends

0.780Federal Farm Credit Bank13820 5,000,000.00 5,000,000.00 06/16/20250.78006/16/2020 4,729,219.40 Aaa3133ELK37 532

0.764Federal Home Loan Bank13822 3,017,777.77 3,017,601.44 06/16/20250.76006/19/2020 2,864,398.79 Aaa3130AJPT0 532

5.600FED HOME LOAN MORTAGE CORP14022 5,000,000.00 5,000,000.00 06/26/20255.60006/30/2023 5,000,321.75 Aaa3134GYUQ3 542

4.100Federal Home Loan Bank13996 5,000,000.00 5,000,000.00 08/08/20254.10008/08/2022 4,973,027.90 Aaa3130ASRJ0 585

0.650FED NATIONAL MORTGAGE ASSN13828 5,000,000.00 5,000,000.00 08/14/20250.65008/14/2020 4,708,115.95 Aaa3136G4C43 591

0.614Federal Farm Credit Bank13863 5,000,000.00 4,999,667.23 08/25/20250.61009/10/2020 4,699,617.30 Aaa3133EL4W1 602

0.530Federal Farm Credit Bank13864 20,000,000.00 20,000,000.00 09/29/20250.53009/29/2020 18,691,931.40 Aaa3133EMBH4 637

4.300Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 09/30/20254.30009/30/2022 4,983,763.05 Aaa3130ATBN6 638

0.600FED HOME LOAN MORTAGE CORP13870 10,000,000.00 10,000,000.00 09/30/20250.60009/30/2020 9,356,569.10 Aaa3134GWVN3 638

0.600FED HOME LOAN MORTAGE CORP13873 10,000,000.00 10,000,000.00 10/15/20250.60010/15/2020 9,331,738.40 Aaa3134GWYS9 653

0.625FED HOME LOAN MORTAGE CORP13877 10,000,000.00 10,000,000.00 10/27/20250.62510/27/2020 9,324,014.40 Aaa3134GW3X2 665

0.600FED HOME LOAN MORTAGE CORP13878 5,000,000.00 5,000,000.00 10/27/20250.60010/27/2020 4,659,849.20 Aaa3134GW5P7 665

0.600FED HOME LOAN MORTAGE CORP13874 10,000,000.00 10,000,000.00 10/28/20250.60010/28/2020 9,318,696.00 Aaa3134GW3F1 666

0.600FED HOME LOAN MORTAGE CORP13876 5,000,000.00 5,000,000.00 10/28/20250.60010/28/2020 4,659,348.00 Aaa3134GW3Z7 666

0.600Federal Farm Credit Bank13888 10,000,000.00 10,000,000.00 11/24/20250.60011/24/2020 9,263,040.40 Aaa3133EMHF2 693

0.690FED HOME LOAN MORTAGE CORP13886 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,646,971.05 Aaa3134GXCS1 694

0.719FED HOME LOAN MORTAGE CORP13891 5,000,000.00 5,000,000.00 11/26/20250.65011/30/2020 4,648,723.00 Aaa3134GXFA7 695

5.000Federal Home Loan Bank14007 5,000,000.00 5,000,000.00 12/29/20255.00012/29/2022 4,972,420.70 Aaa3130AUBX1 728

5.350FED HOME LOAN MORTAGE CORP14002 5,000,000.00 5,000,000.00 12/29/20255.35012/29/2022 4,994,996.20 Aaa3134GY7A4 728

0.550Federal Home Loan Bank13900 5,000,000.00 5,000,000.00 02/12/20260.55002/12/2021 4,619,258.65 Aaa3130AKVR4 773

0.625Federal Home Loan Bank13905 5,000,000.00 5,000,000.00 02/17/20260.62502/17/2021 4,624,387.50 Aaa3130AL3S1 778

0.750Federal Home Loan Bank13907 5,000,000.00 5,000,000.00 02/24/20260.75002/24/2021 4,631,350.40 Aaa3130ALCV4 785

0.630Federal Home Loan Bank13906 5,000,000.00 5,000,000.00 02/26/20260.63002/26/2021 4,620,665.85 Aaa3130ALB94 787

0.844Federal Farm Credit Bank13911 10,000,000.00 9,999,132.22 03/02/20260.84003/02/2021 9,276,100.20 Aaa3133EMSK9 791

0.800Federal Home Loan Bank13908 5,000,000.00 5,000,000.00 03/04/20260.80003/04/2021 4,633,062.95 Aaa3130ALEY6 793

0.800Federal Home Loan Bank13909 5,000,000.00 5,000,000.00 03/10/20260.80003/10/2021 4,630,369.80 Aaa3130ALFS8 799

1.000Federal Home Loan Bank13910 4,875,000.00 4,875,000.00 03/23/20261.00003/23/2021 4,529,376.49 Aaa3130ALGJ7 812

6.000Federal Home Loan Bank14023 5,000,000.00 5,000,000.00 07/27/20266.00007/27/2023 4,996,853.50 Aaa3130AWML1 938

5.000Federal Farm Credit Bank13999 5,000,000.00 5,000,000.00 09/23/20265.00009/23/2022 4,969,860.70 Aaa3133ENN97 996

0.940Federal Farm Credit Bank13960 5,000,000.00 5,000,000.00 09/28/20260.94009/28/2021 4,564,781.25 Aaa3133EM6E7 1,001

1.000Federal Home Loan Bank13953 5,000,000.00 5,000,000.00 09/30/20261.00009/30/2021 4,571,626.45 Aaa3130ANYN4 1,003

1.250Federal Home Loan Bank13964 5,000,000.00 5,000,000.00 10/28/20261.25010/28/2021 4,593,912.35 Aaa3130APDQ5 1,031

5.500Federal Home Loan Bank14032 5,000,000.00 5,000,000.00 11/20/20265.50011/20/2023 5,019,633.15 Aaa3130AXUF3 1,054

5.750FED HOME LOAN MORTAGE CORP14037 5,000,000.00 5,000,000.00 12/07/20265.75012/07/2023 5,010,731.40 Aaa3134H1KV4 1,071

5.400FED HOME LOAN MORTAGE CORP14045 5,000,000.00 5,000,000.00 12/21/20265.40012/21/2023 5,000,026.65 Aaa3134H1MK6 1,085

5.400FED HOME LOAN MORTAGE CORP14046 5,000,000.00 5,000,000.00 12/21/20265.40012/21/2023 5,000,026.65 Aaa3134H1MK6 1,085 Portfolio PASD
APData Updated: SET_POOL: 01/23/2024 16:42
Run Date: 01/23/2024 - 16:43 PM (PRF_PM2) 7.3.0
4 YTM
365

Page 4 ends

5.400FED HOME LOAN MORTAGE CORP14047 5,000,000.00 5,000,000.00 12/21/20265.40012/28/2023 5,000,026.65 Aaa3134H1MK6 1,085

5.000Federal Home Loan Bank13998 5,000,000.00 5,000,000.00 09/14/20275.00009/28/2022 4,954,821.90 Aaa3130AT3P0 1,352

5.184FED HOME LOAN MORTAGE CORP14021 5,000,000.00 5,000,000.00 06/28/20286.00006/30/2023 4,991,421.05 Aaa3134GYUE0 1,640

6.000FED HOME LOAN MORTAGE CORP14024 5,000,000.00 5,000,000.00 07/27/20286.00007/28/2023 4,988,281.65 Aaa3134GYXS6 1,669

6.200FED HOME LOAN MORTAGE CORP14026 5,000,000.00 5,000,000.00 10/30/20286.20010/30/2023 4,999,390.35 Aaa3134H1HA4 1,764

6.200FED HOME LOAN MORTAGE CORP14028 5,000,000.00 5,000,000.00 10/30/20286.20010/30/2023 5,011,452.90 Aaa3134H1JA2 1,764

6.000FED HOME LOAN MORTAGE CORP14029 5,000,000.00 5,000,000.00 11/13/20286.00011/13/2023 5,010,361.30 Aaa3134H1KG7 1,778

5.350Federal Home Loan Bank14038 5,000,000.00 5,000,000.00 11/28/20285.35011/29/2023 5,040,506.50 Aaa3130AXVE5 1,793

5.750FED HOME LOAN MORTAGE CORP14042 5,000,000.00 5,000,000.00 12/26/20285.75012/26/2023 4,994,331.30 Aaa3134H1LS0 1,821 406,591,400.89390,943,604.14406,592,777.77410,220,404.98Subtotal and Average 2.258 703 Treasury Securities - Coupon

1.081US TREASURY13978 5,000,000.00 4,999,165.24 01/31/20240.87501/31/2022 4,982,285.35 Aaa91282CDV0 30

0.470US TREASURY13943 10,000,000.00 9,990,088.34 06/15/20240.25006/25/2021 9,781,640.60 Aaa91282CCG4 166

0.515US TREASURY13962 5,000,000.00 4,995,086.10 09/15/20240.37509/24/2021 4,842,187.50 Aaa91282CCX7 258

0.747US TREASURY13965 5,000,000.00 4,995,247.93 10/15/20240.62510/22/2021 4,835,937.50 Aaa91282CDB4 288

0.554US TREASURY13954 10,000,000.00 9,993,396.87 03/31/20250.50009/16/2021 9,509,765.60 Aaa912828ZF0 455

5.190US TREASURY14025 5,000,000.00 4,984,270.91 09/30/20255.00010/18/2023 5,051,953.10 Aaa91282CJB8 638

0.924US TREASURY13963 5,000,000.00 4,977,431.55 08/31/20260.75009/24/2021 4,586,132.80 Aaa91282CCW9 973 44,934,686.9443,589,902.4545,000,000.0054,609,282.79Subtotal and Average 1.166 381 Corporate Bonds - Coupon

0.654ROYAL BANK OF CANADA13918 5,000,000.00 4,999,433.47 01/19/20240.42503/11/2021 4,987,368.75 A178015K7L2 18

2.250GOLDMAN SACHS13980 2,500,000.00 2,500,000.00 03/15/20242.25003/15/2022 2,478,733.20 A238150AL86 74

3.125JPMORGAN CHASE FINANCIAL13983 2,000,000.00 2,000,000.00 04/29/20243.12504/29/2022 1,977,477.22 A148133DE55 119

0.800Goldman Sach Corporate Bond13935 5,000,000.00 5,000,000.00 06/03/20240.80006/03/2021 4,888,982.65 A238150AG41 154

0.672ROYAL BANK OF CANADA13947 5,000,000.00 4,999,374.07 07/29/20240.65007/29/2021 4,867,940.65 A178016EZU4 210

0.900NEW YORK LIFE GL13967 5,000,000.00 5,000,000.00 10/29/20240.90010/29/2021 4,832,565.70 Aaa64952WEJ8 302

4.050CITIGROUP GLOBAL MARKETS13990 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,448,728.17 A217330FVU2 512

4.050CITIGROUP GLOBAL MARKETS13991 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,448,728.17 A217330FVU2 512

0.825JP MORGAN13898 5,000,000.00 5,000,000.00 12/22/20250.82512/22/2020 4,592,042.55 A148128GY53 721

1.357BANK OF AMERICA CORP13923 5,000,000.00 4,921,905.51 01/26/20260.60003/25/2021 4,512,310.70 A106048WK82 756

0.752BANK OF NEW YORK MELLON13901 5,000,000.00 4,999,792.04 01/28/20260.75002/02/2021 4,607,731.95 A106406RAQ0 758

0.718APPLE INC13902 5,000,000.00 4,998,191.61 02/08/20260.70002/08/2021 4,632,456.25 Aaa037833EB2 769

1.250BANK OF AMERICA CORP13934 5,000,000.00 5,000,000.00 05/28/20261.25005/28/2021 4,546,897.00 A106048WM31 878

1.263BANK OF AMERICA CORP13945 3,623,000.00 3,617,522.61 06/25/20261.20007/21/2021 3,231,060.93 A106048WM64 906 Portfolio PASD
APData Updated: SET_POOL: 01/23/2024 16:42
Run Date: 01/23/2024 - 16:43 PM (PRF_PM2) 7.3.0
5 YTM
365

Page 5 ends

1.155ROYAL BANK OF CANADA13958 6,250,000.00 6,249,176.35 07/14/20261.15009/22/2021 5,720,035.81 A178016EZT7 925

1.365Credit Suisse New York13961 5,000,000.00 4,985,556.87 08/07/20261.25009/24/2021 4,534,735.50 A322550L2G5 949

5.433Toyota Motor Credit Corp14033 5,000,000.00 4,995,670.83 11/20/20265.40011/20/2023 5,120,024.15 A189236TLD5 1,054

5.214Met Life Glob Funding I14043 1,060,000.00 1,009,292.60 12/18/20263.45012/18/2023 1,020,802.15 Aa359217GBY4 1,082

5.650CITIGROUP14004 5,000,000.00 5,000,000.00 12/16/20275.65012/16/2022 4,949,887.05 Aa117330YDB3 1,445

5.330MUTUAL OF OMAHA GLOBAL14040 4,500,000.00 4,523,108.47 12/12/20285.45012/12/2023 4,596,677.33 A162829D2B5 1,807 84,799,024.4380,995,185.8884,933,000.0086,670,411.63Subtotal and Average 2.064 723 Commercial Paper Disc. -Amortizing

5.982Toyota Motor Credit Corp14030 5,000,000.00 4,826,895.64 08/09/20245.61011/15/2023 4,841,420.00 P-189233GH90 221

5.661MUFG BANK LTD NY14041 5,000,000.00 4,821,437.12 08/30/20245.31012/08/2023 4,825,675.00 P-162479LHW8 242

5.654BOFA SECURITIES INC CP14039 5,000,000.00 4,817,559.15 09/05/20245.30012/06/2023 4,819,995.00 A106054NJ51 248

5.585TOYOTA CREDIT CORPORATION14044 10,000,000.00 9,629,349.08 09/12/20245.24012/19/2023 9,639,860.00 P-189233GJC1 255 24,095,240.9924,126,950.0025,000,000.0016,609,194.18Subtotal and Average 5.694 244 Treasury Discounts -Amortizing
967,391.48Subtotal and Average
Supranationals

1.070Inter-American Devel Bank13976 5,000,000.00 5,003,196.85 01/16/20242.62501/21/2022 4,994,896.25 Aaa4581X0DF2 15

0.500Inter-American Devel Bank13955 10,000,000.00 10,000,000.00 09/23/20240.50009/23/2021 9,678,086.50 Aaa4581X0DZ8 266

0.610INTL FINANCE CORP13957 5,000,000.00 4,999,423.66 02/28/20250.60009/28/2021 4,762,360.60 Aaa45950VQJ8 424

0.647INTL BK RECON & DEVELOP13903 5,000,000.00 5,000,000.00 02/10/20260.65002/10/2021 4,624,008.40 Aaa459058JS3 771

5.750INTL BK RECON & DEVELOP14018 5,000,000.00 5,000,000.00 06/15/20265.75006/15/2023 5,005,961.40 Aaa45906M4C2 896

5.748INTL BK RECON & DEVELOP14031 5,000,000.00 5,000,000.00 09/29/20285.75011/17/2023 5,023,010.35 Aaa45906M4H1 1,733 35,002,620.5134,088,323.5035,000,000.0035,005,591.71Subtotal and Average 2.118 624 714,233,451.01 721,247,727.11 2.690 569697,157,627.56 719,737,613.19Total and Average Portfolio PASD
APData Updated: SET_POOL: 01/31/2024 10:43
Run Date: 01/31/2024 - 10:43 PM (PRF_PM2) 7.3.0
Cash 1,793,390.39
Accrued Interest 2,558,736.70
Total 701,509,754.65
6 COMPLIANCE REPORT
Pooled Investment Portfolio
As of 12/31/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Collateralized Money Market 0.00% 100% In compliance 102% Collateral 102% Collateral In compliance In compliance Certificates of Deposit 0.18% 30% In compliance n/a n/a In compliance In compliance Municipal Bonds 4.28% 100% In compliance Aaa/Aa3/Aa2/Aa1/A2/AA+/AA-/AAA/AA A or better In compliance In compliance US Treasury Securities 6.24% 100% In compliance Aaa AA+/Aaa In compliance In compliance Corporate Bonds 11.59% 30% In compliance* Aaa/Aa1/Aa3/A1/A2/A3 A or better In compliance In compliance Federal Agency Issues 55.93% 100% In compliance Aaa AA+/Aaa In compliance In compliance Supranationals 4.88% 30% In compliance Aaa AA or better In compliance In compliance Commercial Paper 3.45% 100% In compliance P-1 (Short-term)/A1/Aa1 P-1 (Short-term) In compliance In compliance Money Market-CAMP 13.01% 100% In compliance n/a n/a In compliance In compliance LAIF 0.18% 100% In compliance n/a n/a In compliance In compliance Cash 0.26% 100% In compliance Collateralized Collateralized In compliance In compliance 100.00%
Portfolio Value 701,509,755
7 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE POOL PORTFOLIO
December 31, 2023
Market Value % of Total
FHLB 184,880,452 26.35%
FHLMC 135,163,943 19.27%
FFCB 56,194,551 8.01%
Total Fed Agencies 376,238,946 53.63%
OTHER PORTFOLIO INVESTMENTS 325,270,809 46.37%
Total Investments 701,509,755 * 100.00%
note: * Includes Cash in Bank and Accrued Interest Receivable 8 Pooled Portfolio - Total Return Performance
ICE BofA Pooled
1-3 Index Portfolio
2005 Annual 1.746 2.073
2006 Annual 4.195 4.474
2007 Annual 6.706 5.736
2008 Annual 4.649 3.474
2009 Annual 3.784 3.398
2010 Annual 2.322 1.806
2011 Annual 1.540 1.490
2012 Annual 1.467 1.788
2013 Annual 0.696 0.417
2014 Annual 0.777 1.321
2015 1st quarter 0.594 0.628
2nd quarter 0.143 0.141
3rd quarter 0.284 0.431
4th quarter -0.350 -0.113

0.671 1.087
2016 1st quarter 0.982 0.713
2nd quarter 0.660 0.350
3rd quarter 0.027 0.170
4th quarter -0.385 -0.520

1.284 0.713
2017 1st quarter 0.393 0.440
2nd quarter 0.303 0.419
3rd quarter 0.342 0.380
4th quarter -0.182 -0.059

0.856 1.180
2018 1st quarter -0.185 -0.097
2nd quarter 0.291 0.269
3rd quarter 0.354 0.431
4th quarter 1.166 1.038

1.626 1.641
2019 1st quarter 1.219 0.963
2nd quarter 1.480 1.054
3rd quarter 0.700 0.593
4th quarter 0.606 0.590

4.005 3.200
2020 1st quarter 1.590 0.495
2nd quarter 1.215 0.962
3rd quarter 0.274 0.287
4th quarter 0.227 0.236

3.306 1.980
2021 1st quarter -0.028 -0.467
2nd quarter 0.063 0.437
3rd quarter 0.088 0.085
4th quarter -0.533 -0.638
-0. 410 -0.583
2022 1st quarter -2.580 -2.910
2nd quarter -0.625 -0.842
3rd quarter -1.503 -1.713
4th quarter 0.890 0.821
-3.818 -4.644
2023 1st quarter 1.480 1.599
2nd quarter -0.341 0.995
3rd quarter 0.781 1.000
4th quarter 2.640 2.230

4.560 5.824
Yield Fiscal YTD
Pooled Portfolio YTM 2.69%
State Treasurer's LAIF yield 3.62%
2 Year Average US Treasury yield 4.88%
9 CITY POOLED PORTFOLIO
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In %
Fiscal Year Total
June June June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2013 2014 2015 2016 2017 2019 2020 2021 2022 2023 2024 2024 2024 2024 Money Market 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Collateralized 12.91 16.74 9.14 7.25 3.97 1.59 11.73 6.76 0.00 0.00 0.00 0.00 Municipal Bonds 12.62 13.00 4.97 4.01 5.80 4.33 4.72 7.70 5.96 4.25 3.55 4.28 Corporate Bonds - Coupon 25.94 22.67 21.65 16.36 17.12 20.78 22.50 16.62 13.97 11.02 10.91 11.59 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Issues - Coupon 36.55 43.39 43.45 49.70 55.86 54.14 34.00 47.35 48.79 57.84 58.01 55.93 Repurchase Agreements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 L.A.I.F. 9.04 1.47 13.09 14.38 9.07 7.29 11.66 16.47 4.00 0.19 0.19 0.18 Cash 2.72 2.50 3.76 0.68 0.44 0.45 0.34 0.53 0.31 0.06 0.12 0.26 Treasury Securities 0.00 0.00 3.93 3.37 2.99 3.71 2.37 3.66 7.46 7.11 7.08 6.24 Treasury Securities Disc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.54 1.48 0.73 0.00 Supranationals 0.00 0.00 0.00 4.25 3.76 5.89 8.24 0.80 3.73 4.27 4.24 4.88 Bank Notes 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 0.00 0.00 0.00 0.99 0.82 0.00 0.00 1.55 2.97 0.74 3.45 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Amortized Zero Cpn Bonds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.77 0.00 0.00 0.00 Certificates of Deposit 0.22 0.23 0.00 0.00 0.00 1.00 0.00 0.00 0.20 0.19 0.19 0.18 Money Market-CAMP 0.00 0.00 0.00 0.00 0.00 0.00 3.89 0.12 11.72 10.61 14.24 13.01 Muni Variable Rate 0.00 0.00 0.00 0.00 0.00 0.00 0.54 0.00 0.00 0.00 0.00 0.00 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 0.00 0.00 10 II. Capital Endowment Portfolio

CITY OF PASADENA
Capital Endowment Portfolio
Vicken Erganian
City Treasurer
December 2023

PORTFOLIO STRUCTURE AS OF 12/31/2023

TYPE MARKET VALUE PERCENT
Money Market - CAMP 97,358 5.04%
Federal Agencies 1,835,093 94.96%
TOTALS: 1,932,451 100.00%
Accrued Interest Receivable 2,359
GRAND TOTAL: 1,934,810
PORTFOLIO LIQUIDITY AS OF 12/31/2023
Percent of
Aging Interval Par Value Portfolio
0-30 Days 97,358 4.87%
31 days - 1 Year 1,900,000 95.13%
1 - 2 Years - 0.00%
2 - 3 Years - 0.00%
3 - 4 Years - 0.00%
4 - 5 Years - 0.00%
Over 5 Years - 0.00%
TOTAL: 1,997,358 100.00% -

PORTFOLIO STATISTICS
Dec-23 Nov-23 Oct-23 Sep-23 Aug-23 Jul-23
Month-End Mkt Value 1,934,810 1,922,282 1,906,563 1,898,329 1,891,579 1,879,795 Modified Duration 0.83 0.91 0.98 1.06 1.14 1.21
Weighted Average Maturity 0.86 0.94 1.02 1.10 1.18 1.26 Current Book Yield to Maturity 1.226% 1.226% 1.203% 1.202% 1.200% 1.195% Effective Yield - Year to Date 1.200% 1.190% 1.190% 1.190% 1.170% 1.170% Interest Earned 2,042 2,004 1,994 1,992 1,987 1,971
Fiscal Year To Date Interest Earned 11,990 9,948 7,944 5,950 3,959 1,971 Fair Value Change Gain/(Loss) 13,338 10,863 6,240 4,759 9,796 2,856 Fiscal Year To Date change in fair value 47,852 34,514 23,651 17,411 12,652 2,856 Total Fiscal YTD earnings 59,842 44,462 31,595 23,361 16,611 4,828 MMF -
CAMP,

5.04%
Federal
Agencies,

94.96%
11 YTM
365

Page 1 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management

CAPITAL ENDOWMENT
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Money Market Fund-CAMP

5.637California Asset Management Pr14111 97,358.00 97,358.00 5.56097,358.00SYS14111 1 97,358.0097,358.0097,358.0097,358.00Subtotal and Average 5.637 1 Collateralized Money Market

4.800EAST WEST BANK13057 0.00 0.00 4.8000.00SYS13057 1

0.000.000.000.00Subtotal and Average 0.000 0
Federal Agency Issues - Coupon

1.000Federal Home Loan Bank13970 1,900,000.00 1,900,000.00 11/25/20241.00011/30/2021 1,835,092.60 Aaa3130APVG7 329 1,900,000.001,835,092.601,900,000.001,900,000.00Subtotal and Average 1.000 329 1,997,358.00 1,997,358.00 1.226 3131,932,450.60 1,997,358.00Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 01/24/2024 12:32
Run Date: 01/24/2024 - 12:32 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
Accrued Interest 2,359.20
Total 1,934,809.80
12 COMPLIANCE REPORT
Capital Endowment Portfolio
As of 12/31/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Money Market-CAMP 5.04% 100% In compliance n/a n/a In compliance In compliance Federal Agency Issues 94.96% 100% In compliance** Aaa AA+/Aaa In compliance In compliance 100.00%
Portfolio Value 1,934,810
**Compliance is measured based on the City's total investments which include the Pooled portfolio as well as the Power Reserve Fund. 13 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE CAPITAL ENDOWMENT PORTFOLIO
December 31, 2023
Market Value % of Total
FHLB 1,835,093 94.85%
Total 1,835,093 94.85%
OTHER PORTFOLIO INVESTMENTS 99,717 5.15%
Total Investments 1,934,810 * 100.00%
note: * Includes Accrued Interest Receivable
14 CAPITAL ENDOWMENT
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In % Fiscal Year Total
June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2016 2017 2018 2019 2020 2021 2022 2023 2024 2024 2024 2024 Money Market - Collateralized 100.00 1.80 0.75 0.03 1.10 3.10 3.38 0.00 0.00 0.00 Federal Agency Issues - Coupon 0.00 0.00 0.00 0.00 0.00 0.00 96.62 95.44 95.42 94.96 Corporate Bonds - Coupon 0.00 0.00 99.25 99.97 98.90 96.90 0.00 0.00 0.00 0.00 Municipal Bonds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 L.A.I.F. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Certificate of Deposit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Treasury Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 98.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mutual Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market - CAMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.56 4.58 5.04 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 0.00 0.00 15 III. Power Reserve Portfolio

CITY OF PASADENA
Power Reserve Portfolio
Vicken Erganian
City Treasurer
December 2023

PORTFOLIO STRUCTURE AS OF 12/31/2023

TYPE MARKET VALUE PERCENT
Municipal Bonds 1,874,940 4.48%
Federal Agencies 29,990,144 71.66%
L.A.I.F. 43,881 0.10%
Money Market-CAMP 9,943,034 23.76%
TOTALS: 41,851,999 100.00%
Accrued Interest Receivable 228,640
GRAND TOTAL: 42,080,638
PORTFOLIO LIQUIDITY AS OF 12/31/2023
Percent of
Aging Interval Par Value Portfolio
0 - 30 days 9,986,915 20.11%
31 days - 1 Year 5,000,000 10.07%
1 - 2 Years - 0.00%
2 - 3 Years 2,000,000 4.03%
3 - 4 Years - 0.00%
4 - 5 Years 6,000,000 12.08%
Over 5 Years 26,666,667 53.71%
TOTAL: 49,653,582 100.00%

PORTFOLIO STATISTICS
Dec-23 Nov-23 Oct-23 Sep-23 Aug-23 Jul-23
Month-End Market Value 42,080,638 40,115,939 39,139,748 39,528,732 40,442,878 40,281,402 Modified Duration 5.65 5.43 5.36 5.55 5.79 5.85
Weighted Average Maturity 7.56 7.64 7.72 7.81 7.89 7.98 Current Book Yield to Maturity 2.476% 2.475% 2.466% 2.454% 2.447% 2.415% Effective Yield - Year to Date 2.440% 2.440% 2.420% 2.410% 2.380% 2.350% Interest Earned 102,342 102,103 101,409 100,829 99,880 97,846 Fiscal Year To Date Interest Earned 604,409 502,067 399,964 298,555 197,726 97,846 Fair Value Change Gain/(Loss) 1,862,333 1,038,290 (654,594) (1,015,007) 61,596 (306,636) Fiscal Year To Date change in fair value 985,982 (876,351) (1,914,641) (1,260,047) (245,040) (306,636) Total Fiscal YTD Earnings 1,590,391 (374,284) (1,514,677) (961,491) (47,313) (208,790) Money Market-
CAMP

1.03%
Fed Agency

71.66%
LAIF

0.10%
Municipal
Bonds

4.54%
16 YTM
365

Page 1 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management

POWER RESERVE FUND
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
LAIF

3.960Local Agency Investment Fund6184 43,881.14 43,881.14 3.96043,881.14SYS6184 1 43,881.1443,881.1443,881.1443,881.14Subtotal and Average 3.960 1 Money Market Fund-CAMP

5.637California Asset Management Pr14063 9,943,033.57 9,943,033.57 5.5609,943,033.57SYS14063 1 9,943,033.579,943,033.579,943,033.579,943,033.57Subtotal and Average 5.637 1 Collateralized Money Market

4.800EAST WEST BANK13066 0.00 0.00 4.8000.00SYS13066 1

0.000.000.000.00Subtotal and Average 0.000 0
Municipal Bonds

2.560LA County Redevelopment TABs13553 2,000,000.00 1,991,342.43 09/01/20262.37508/25/2016 1,874,940.00 Aa254465AGS5 974 1,991,342.431,874,940.002,000,000.001,991,215.88Subtotal and Average 2.560 974 Federal Agency Issues - Coupon

1.000Federal Home Loan Bank13969 5,000,000.00 5,000,000.00 11/25/20241.00011/30/2021 4,826,883.50 Aaa3130APV69 329

1.230Federal Farm Credit Bank13946 6,000,000.00 6,000,000.00 08/02/20281.23008/02/2021 5,285,248.80 Aaa3133EMX80 1,675

1.230Federal Farm Credit Bank13890 5,000,000.00 5,000,000.00 11/25/20301.23011/25/2020 4,089,065.55 Aaa3133EMHN5 2,520

1.850Federal Home Loan Bank13788 1,666,667.00 1,666,667.00 04/08/20321.85004/08/2020 1,376,064.69 Aaa3130AJEA3 3,020

2.000Federal Home Loan Bank13904 10,000,000.00 10,000,000.00 02/25/20362.00002/25/2021 7,713,343.40 Aaa3130AL3X0 4,438

2.000Federal Farm Credit Bank13875 10,000,000.00 10,000,000.00 10/15/20402.00010/15/2020 6,699,538.20 Aaa3133EMCV2 6,132 37,666,667.0029,990,144.1437,666,667.0037,666,667.00Subtotal and Average 1.636 3,585 49,644,797.59 49,653,581.71 2.476 2,75941,851,998.85 49,644,924.14Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 01/23/2024 18:02
Run Date: 01/23/2024 - 18:02 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
Accrued Interest 228,639.55
Total 42,080,638.40
17 COMPLIANCE REPORT
Power Reserve Portfolio
As of 12/31/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Municipal Bonds 4.48% 100% In compliance Aa2 A or better In compliance In compliance Federal Agency Issues 71.66% 100% In compliance Aaa AA+/Aaa In compliance In compliance Money Market-CAMP 23.76% 100% In compliance n/a n/a In compliance In compliance LAIF 0.10% 100% In compliance n/a n/a In compliance In compliance 100.00%
Portfolio Value 42,080,638
18 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE POWER RESERVE PORTFOLIO
December 31, 2023
Market Value % of Total
FHLB 13,916,292 33.07%
FFCB 16,073,853 38.20%
Total Fed Agencies 29,990,144 71.27%
OTHER PORTFOLIO INVESTMENTS 12,090,494 28.73%
Total Investments 42,080,638 * 100.00%
note: * Includes Accrued Interest Receivable
19 Power Reserve Portfolio - Total Return Performance
ICE BofA Power
3-5 Index Reserve
2005 Annual 0.980 2.615
2006 Annual 4.184 4.540
2007 Annual 7.656 6.960
2008 Annual 4.610 3.683
2009 Annual 3.784 3.714
2010 Annual 1.113 1.206
2011 Annual 1.555 2.547
2012 Annual 1.467 3.027
2013 Annual -0.143 -0.184
2014 Annual 2.446 2.688
2015 1st quarter 1.550 0.910
2nd quarter -0.178 0.039
3rd quarter 0.995 0.884
4th quar
ter -0.793 -0.469

1.574 1.364
2016 1st quarter 2.420 1.197
2nd quarter 1.390 0.560
3rd quarter 0.080 0.190
4th quarter -1.840 -2.340

2.050 -0.393
2017 1st quarter 0.773 0.830
2nd quarter 0.873 0.803
3rd quarter 0.567 0.515
4th quarter -0.398 0.071

1.815 2.219
2018 1st quarter -0.890 -0.702
2nd quarter 0.013 0.284
3rd quarter 0.188 0.048
4th quarter 1.812 1.987

1.123 1.617
2019 1st quarter 2.245 1.538
2nd quarter 2.530 1.704
3rd quarter 1.196 0.877
4th quarter 0.430 0.460

6.401 4.579
**2020 1st quarter 1.594 0.950
2nd quarter 1.215 0.625
3rd quarter 0.274 0.249
4th quarter 0.227 0.249

3.31 2.073
2021 1st quarter -1.178 -2.549
2nd quarter 0.634 3.715
3rd quarter -0.037 -0.554
4th quarter -0.896 -0.015
-1.477 0.597
2022 1st quarter -5.970 -6.886
2nd quarter -3.282 -4.182
3rd quarter -4.420 -5.972
4th quarter 1.918 0.454
-11.754 -16.586
2023 1st quarter 2.980 2.517
2nd quarter -1.230 -0.212
3rd quarter -1.960 -2.378
4th quarter 5.827 6.459

5.617 6.386
Yeld Fiscal YTD
Power Reserve YTM 2.48%
St
ate Treasurer's LAIF yield 3.62%
2 Year
Average Treasury yield 4.37%
Index changed to ICE BofA 5-7 in 2022
20 POWER RESERVE FUND
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In % Fiscal Year Total
June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2016 2017 2018 2019 2020 2021 2022 2023 2024 2024 2024 2024 Money Market - Collateralized 7.43 0.02 4.34 2.58 32.06 0.08 0.00 0.00 0.00 0.00 Municipal Bonds 7.24 7.00 6.92 6.02 3.43 3.93 4.50 4.56 4.66 4.48 Federal Agency Issues - Coupon 77.86 79.82 82.96 85.12 51.22 57.67 75.33 72.13 70.71 71.66 L.A.I.F. 0.24 0.24 0.24 0.26 0.00 32.77 18.69 0.11 0.11 0.10 Corporate Bonds - Coupon 7.23 12.92 5.54 6.02 13.29 5.56 0.00 0.00 0.00 0.00 Certificate of Deposit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Treasury Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mutual Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market - CAMP 0.00 0.00 0.00 0.00 0.00 0.00 1.48 23.21 24.52 23.76 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 0.00 0.00 21 IV. Miscellaneous Portfolios
Fund Coupon Yield Maturity Face Value Cost Per Book Market Value City of Pasadena-Housing Succesor Agency
Money Mkt CAMP 5.560% 5.560% 1/1/2024 $2,413,819.11 $2,413,819.11 $2,413,819.11 LAIF 3.960% 3.960% 1/1/2024 $1.50 $1.50 $1.50
Weighted Average Maturity = 1 day $2,413,820.61 $2,413,820.61 $2,413,820.61 2002 Electric Revenue Reserve Fund
Money Mkt CAMP 5.560% 5.560% 1/1/2024 $106,336.99 $106,336.99 $106,336.99 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $4,000,000.00 $4,000,000.00 $3,738,386.28 Weighted Average Maturity = 1.73 $4,106,336.99 $4,106,336.99 $3,844,723.27 Annandale Assessment District
Municipal Bonds-Annandale Assessment 6.000% 6.000% 9/2/2040 $887,735.00 $887,735.00 $887,735.00 Weighted Average Maturity = 16.91
Miscellaneous Funds
December 31, 2023

Page 1 ends

22 Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
December 31, 2023
2012A Electric Parity Reserve Fund
Money Mkt CAMP 5.560% 5.560% 1/1/2024 $16,091.25 $16,091.25 $16,091.25 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $690,000.00 $690,000.00 $644,871.63 Weighted Average Maturity = 1.73 $706,091.25 $706,091.25 $660,962.88 2013A Electric Parity Reserve Fund
Money Mkt CAMP 5.560% 5.560% 1/1/2024 $314,681.41 $314,681.41 $314,681.41 FFCB 3133ELC28 0.730% 0.730% 5/27/2025 $8,000,000.00 $8,000,000.00 $7,568,902.56 Weighted Average Maturity = 1.37 $8,314,681.41 $8,314,681.41 $7,883,583.97

Page 2 ends

23 Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
December 31, 2023
2016A Electric Revenue Refunding Reserve
Money Mkt CAMP 5.560% 5.560% 1/1/2024 $54,678.80 $54,678.80 $54,678.80 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $2,680,000.00 $2,680,000.00 $2,504,718.81 Weighted Average Maturity = 1.73 $2,734,678.80 $2,734,678.80 $2,559,397.61 2020A Water Refund Revenue Bonds Project
LAIF 3.960% 3.960% 1/1/2024 $4,665.99 $4,665.99 $4,665.99 Weighted Average Maturity = 1 day $4,665.99 $4,665.99 $4,665.99 2021A Water Refund Revenue Bonds Project
LAIF 3.960% 3.960% 1/1/2024 $14,462.49 $14,462.49 $14,462.49 Money Mkt CAMP 5.560% 5.560% 1/1/2024 $1,234.98 $1,234.98 $1,234.98 Weighted Average Maturity = 1 day $15,697.47 $15,697.47 $15,697.47 GRAND TOTAL: $19,183,707.52 $19,183,707.52 $18,270,586.80

Page 3 ends

24 V. Investments Held by Trustees
Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2023 Market Yield 5.25%
Maturity 01/01/24
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY 2021A Water Revenue Refunding Bonds
Amy Green COI-2021A Account #209092
(213)630-6204 Cash - - - 01/ 01/24 0.00%
Lena Chan Debt Service-2021A Account #209093
(213) 630-6253 Cash - - - 01/ 01/24 0.00%
Reserve-2021A Account #209094
DREFUS GOVT CM INST 289 Cusip: X9USDDGCM 842,483.75 842,483.75 842, 483.75 01/ 01/24 5.26% Cash - - - 01/ 01/24 0.00%
Total 842,483.75 842,483.75 842, 483.75
BNY 2020A Water Revenue Refunding Bonds
Amy Green COI-2020 Account #746583
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/ 01/24 5.25% Lena Chan DEBT SERVICE-2020 Account #746585
(213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/ 01/24 5.25% Total - - -
2020AB POB Bonds
BNY POB COI-2020B Account #220413
Amy Green BlackRock Treasury Turst Dollars 63 Cusip: X9USDBTRD - - - 01/ 01/24 0.02% (213)630-6204 POB Bond Fund-2020B Account #220414
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 516.12 516. 12 516. 12 01/ 01/24 5.25% (213) 630-6253 POB Bond Fund-2020B Account #220415
Blackrock Tresus Trust Dollar 11 Cusip: X9USDBTRO 81.36 81.36 81. 36 01/ 01/24 5.01% POB COI-2020A Account #765976
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/ 01/24 5.25% POB Bond Fund-2020A Account #765990
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 1,119.85 1,119.85 1, 119.85 01/ 01/24 5.25% POB Bond Fund-2020A Account #765996
Blackrock Tresus Trust Dollar 11 Cusip: X9USDBTRO 177.23 177.23 177. 23 01/ 01/24 5.01% Total 1,894.56 1,894.56 1, 894.56
2019A Electric Revenue Bonds
BNY Electric COI-2019A Account #106207
Amy Green Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 38,566.03 38, 566.03 38, 566.03 01/ 01/24 5.25% (213)630-6204 Electric Bond Fund-2019A Account #113813 - Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 1,309.94 1, 309.94 1, 309.94 01/ 01/24 5.25% (213) 630-6253 - - - 01/ 01/24 5.25%
Total 39,875.97 39,875.97 39, 875.97

Page 1 of 5 ends

25 Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2023 Market Yield 5.25%
Maturity 01/01/24
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
US Bank 2018AB Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund- Series 2018A Account #248882000 (213) 615-6051 Fidelity Govt Protfolio CI Cusp:316175108 441.36 441. 36 441. 36 01/ 01/24 5.26% Adriana Marshall Costs of Issuance- Series 2018A Account #248882002 (213) 615-6033 Fidelity Govt Protfolio CI Cusp:316175108 - - - 01/ 01/24 5.26% Interest Fund- Series 2018B Account #248882100
Fidelity Govt Protfolio CI Cusp:316175108 54.48 54.48 54. 48 01/ 01/24 5.26% Principal Fund- Series 2018B Account #248882101
Fidelity Govt Protfolio CI Cusp:316175108 824.05 824.05 824. 05 01/ 01/24 5.26% Costs of Issuance- Series 2018B Account #248882102
Fidelity Govt Obl Fd Cl D 316175108 - - - 01/ 01/24 5.26% Total 1,319.89 1,319.89 1, 319.89
2017A Water Revenue Bonds
BNY Debt Service-2017A Account #948165
Amy Green Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/ 01/24 5.25% (213)630-6204 Reserve Fund-2017A Account #948269
Lena Chan Federal Home Loan Banks Cusip: 3130AL3S1 1,050,000.00 1, 050,000.00 971, 124.00 02/ 17/26 0.68% (213) 630-6253 DREYFUS CUSIP:X9USSGCM 38,427.14 38, 427.14 38, 427.14 01/ 01/24 5.26% Total 1,088,427.14 1,088,427.14 1, 009,551.14
US Bank 2016A Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund- Series 2016A Account #264433000 (213) 615-6051 Fidelity Govt Protfolio CI Cusp:316175108 321.27 321. 27 321. 27 01/ 01/24 5.26% Principal Fund- Series 2016A Account #264433001
Fidelity Govt Protfolio CI Cusp:316175108 1,507.69 1,507.69 1, 507.69 01/ 01/24 5.26% Adriana Marshall
Insurance & Condemnation Fund- Series 2016A Account
#264433002
(213) 615-6033 Fidelity Govt Obl Fd Cl D 316175108 0.19 0. 19 0. 19 01/ 01/24 5.26% Cost of Issuance- Series 2016A Account #264433003
First American Govt Obl Fd Cl D 31846V401 - - - 01/ 01/24 5.26% Total 1,829.15 1,829.15 1, 829.15
BNY Pasadena 2015A COPS Bond
Amy Green COPS Base Rental-2015A Account #336964
(213)630-6204 Cash Balance - - - 01/ 01/24 0.00%
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 6.10 6. 10 6. 10 01/ 01/24 5.25% (213) 630-6253 Total 6.10 6. 10 6. 10

Page 2 of 5 ends

26 Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2023 Market Yield 5.25%
Maturity 01/01/24
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY Pasadena Tax Pension 2015AB Bond
Amy Green Bond Fund-2015A POB Account #479226
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 605.16 605. 16 605. 16 01/ 01/24 5.25% Lena Chan Cash Balance - - - 01/ 01/24 0.00%
(213) 630-6253 Bond Fund-2015A POB Account #479227
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 244.28 244.28 244. 28 01/ 01/24 5.25% Cash Balance 01/01/24 0.00%
Bond Fund-2015A POB Account #479231
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 71.50 71.50 71. 50 01/ 01/24 5.25% Cash Balance - - - 01/ 01/24 0.00%
Total 920.94 920.94 920. 94
BNY Pasadena Water Revenue 2010AB
Amy Green 2010 A Parity Reserve Account #286245
(213)630-6204 DREYFUS CUSIP:X9USSGCM 25,341.54 25, 341.54 25, 341.54 01/ 01/24 5.26% Lena Chan Federal Home Loan Bank CUSIP:3130AL3S1 1,350,000.00 1, 350,000.00 1, 248,588.00 02/ 17/26 0.63% (213) 630-6253 Cash - - - 01/ 01/24 0.00%
2010 B Debt Service Account #286247
Cash - - - 01/ 01/24 4.19%
2010 B Parity Reserve Account #286248
DREYFUS CUSIP:X9USSGCM 7,991.03 7,991.03 7, 991.03 01/ 01/24 5.26% Federal Home Loan Bank CUSIP:3130AL3S1 300,000.00 300,000.00 277, 464.00 02/ 17/26 0.63% Cash - - - 01/ 01/24 0.00%
2010 A Debt Service Fund Account #286295
Cash - - - 01/ 01/24 0.00%
Total 1,683,332.57 1,683,332.57 1, 559,384.57
US Bank 2010 Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund (S631591)
(213) 615-6051 Fidelity Instl Mm Fds Government I CUSIP:316175108 349,154.30 349, 154.30 349, 154.30 01/ 01/24 5.26% Adriana Marshall Cash - - - 01/ 01/24 0.00%
(213) 615-6071 Principal Fund (S631592)
Fidelity Instl Mm Fds Government I CUSIP:316175108 3.34 3.34 3. 34 01/ 01/24 5.26% Bond Reserve Fund (S631593)
Federal Home Loan Bank Funds CUSIP: 3130ALBD5 15,500,000.00 15,500,000.00 10, 289,365.00 02/ 25/41 2.15% Fidelity Instl Mm Fds Government I CUSIP:316175108 72,971.22 72,971.22 72, 971.22 01/ 01/24 5.26% Cash - - - 01/ 01/24 0.00%
Total 15,922,128.86 15,922,128.86 10, 711,493.86

Page 3 of 5 ends

27 Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2023 Market Yield 5.25%
Maturity 01/01/24
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Va lue Date Yld
Computershare Corporate Trust PPFA (Paseo Colorado Parking Facilities) 2008 Tracy Mason Bond Fund Account #23200100
(213) 253-7536 Allspring Government Money Market Service 93,667.55 93,667. 55 93,667. 55 01/01/ 24 4.93% Cash - - - 01/01/ 24 0.00%
Reserve Fund Account #23200101
teresalynn.mason1@computershFHLB Cusip: 3130APVC6 2,000,000.00 2,000,000.00 1,838, 420.00 12/01/ 26 1.38% Well Fargo Advantage Government Money Market Service - - - 01/01/ 24 0.01% Cost of Issuance Fund Account #23200103
Well Fargo Advantage Government Money Market Service - - - 01/01/ 24 0.00% Total 2,093,667.55 2,093,667.55 1,932, 087.55
BNY Pasadena 2006,2008,2015 COP Reserves
Amy Green Reserve Account #281635
(213)630-6204 Federal Home Loan Banks CUSIP:3130AKKQ8 4,950,000.00 4,950, 000.00 4,033, 012.50 12/23/ 30 1.25% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 127,766.58 127,766. 58 127,766. 58 01/01/ 24 5.25% (213) 630-6253 Cash - - - 01/01/ 24 0.00%
Total 5,077,766.58 5,077,766.58 4,160, 779.08
Pasadena 2008AB COPS, 15A Parity Reserve
BNY Reserve Fund #281207
Amy Green Federal Home Loan Banks CUSIP:3130AKKQ8 1,325,000.00 1,325, 000.00 1,079, 543.75 12/23/ 30 1.25% (213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 34,200.10 34,200. 10 34,200. 10 01/01/ 24 5.25% Lena Chan Cash Balance - - -
(213) 630-6253 Total 1,359,200.10 1,359, 200.10 1,113, 743.85 BNY Pasadena 2008A COPS
Amy Green Base Rental Fund #281732
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 265,281.86 265,281. 86 265,281. 86 01/01/ 24 5.25% Lena Chan Cash Balance - - - 0.00%
(213) 630-6253 Interest Fund #281733
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 17.43 17.43 17.43 01/01/ 24 5.25% Letter of Credit #281734
Bank of America CUS: S86494570 1.00 1.00 1.00 03/31/ 25 0.00% Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 0.36 0.36 0.36 01/01/ 24 5.25% Total 265,300.65 265,300.65 265,300. 65
BNY Pasadena Conf Ctr 2006AB

Page 4 of 5 ends

28 Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2023 Market Yield 5.25%
Maturity 01/01/24
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
Amy Green Reserve Fund #281722
(213)630-6204 Federal Home Loan Banks CUSIP:3130AJRH4 10,800,000.00 10, 800,000.00 7, 331,580.00 06/ 29/40 2.07% Lena Chan Federal Home Loan Banks CUSIP:3130AKKQ8 270,000.00 270, 000.00 219, 982.50 12/ 23/30 1.25% (213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 356,696.93 356, 696.93 356, 696.93 01/ 01/24 5.25% Cash Balance 111,780.00 111,780.00 111, 780.00 01/ 00/00 0.00% Total 11,538,476.93 11,538,476.93 8, 020,039.43
BNY Pasadena Water Revenue 2003
Amy Green Parity Reserve Account #281651
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AL3S1 1,000,000.00 1, 000,000.00 924, 880.00 02/ 17/26 0.63% Lena Chan DREYFUS GOVT CM INST 289 CUSIP: X9USDDGCM 24,517.49 24, 517.49 24, 517.49 01/ 01/24 5.24% (213) 630-6253 Cash - - - 01/ 01/24 0.00%
Total 1,024,517.49 1,024,517.49 949, 397.49
BNY COPS Parity Reserve Fund(2006A, and 2008ABC COP)
Amy Green Certificate Reserve #281143
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AKKQ8 2,025,000.00 2, 025,000.00 1, 649,868.75 12/ 23/30 1.53% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 52,269.61 52, 269.61 52, 269.61 01/ 01/24 5.25% (213) 630-6253 Cash - - - 01/ 01/24 0.00%
(In aggegrate with 2006A, Total Funds 2,077,269.61 2, 077,269.61 1, 702,138.36 and 2008ABC COP reserve)
SCPPA SCPPA Investments
Atif Haji Datoo SCPPA Project Stabilization Fund
(213) 367-4668 Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN 64,303.73 64, 303.73 64, 303.73 01/ 01/24 5.26% Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN 1,029,849.37 1,029,849.37 1, 029,849.37 01/ 01/24 5.26% Fannie Mae Discount Notes CUSIP:33588SP1 1,200,000.00 1,192,510.84 1, 193,856.00 02/ 02/24 5.23% Federal Home Loan Bank CUSIP: 3130ANZG8 1,000,000.00 999,800.00 971, 520.00 09/ 16/24 0.75% - - - 09/ 01/23 4.92%
- - - 0. 00%
Total 3,294,153.10 3,286,463.94 3, 259,529.10
TOTAL FUND BALANCE 46,312,570.94$ 46,304,881.78$ 35,571,775.44$

Page 5 of 5 ends

29 VI. PARS Section 115 Trust
City of Pasadena
PARS Section 115 Trust
For the Month Ended December 31, 2023
Pension Account 6746056200
Mayket Value Book Value
Beginning Balance 12,266,283.95 12,724,938.10 Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 88,289.28 88,289.28
Interest 2,333.44 2,333.44
Other Income 4.97 4.97
Change in Accrued Income 122.30 122.30
Total Investment Income 90,749.99 90,749.99
Net Change in Unrealized Gain/Loss 353,092.93 -
Realized Gain/Loss 100,070.77 100,070.77
Total Mayket Value Adjustment 453,163.70 100,070.77
Trust Fees (2,653.42) (2,653.42)
PARS Fee (Net of Depository Earnings) (2,394.68) (2,394.68) Unreconciled Difference - -
Total (5,048.10) (5,048.10)
Ending Balance 12,805,149.54 12,910,710.76
1 Year Inception To Date
Investment Return (Inception-To-Date as of 12/31/2023) 11.13% 3.96% Pending BenchMayk Return (PARS Moderately Conservative) 10.29% 4.11% Pending Asset Allocation
Market Value Percentage
Cash and Equivalents 593,748.00 4.64%
Equity 3,703,598.19 28.92%
Fixed Income 8,505,347.61 66.42%
Accrued Income 2,455.74 0.02%
Total 12,805,149.54 100.00%
Account Manager:

Kyra Clarke
3121 Michelson Dr 3rd Fl
Irvine, CA 92612
949-224-7214, [email protected]
Cash and Equivalents

4.64%
Equity

28.92%
Fixed Income

66.42%
Accrued Income

0.02%
30 City of Pasadena
PARS Section 115 Trust
For the Month Ended December 31, 2023
Post Employments Benefits Trust 6746056201
Mayket Value Book Value
Beginning Balance 2,324,031.97 2,411,463.70 Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 14,925.20 14,925.20
Interest 409.84 409.84
Other Income 0.09 0.09
Change in Accrued Income 2.29 2.29
Total Investment Income 15,337.42 15,337.42
Net Change in Unrealized Gain/Loss, Fee Receipts & Deliveries Net 67,102.56 - Realized Gain/Loss 19,262.86 19,262.86
Total Mayket Value Adjustment 86,365.42 19,262.86
Trust Fees (504.05) (504.05)
PARS Fee (Net of Depository Earnings) (453.71) (453.71) Unreconciled Difference - -
Total (957.76) (957.76)
Ending Balance 2,424,777.05 2,445,106.22
1 Year Inception To Date
Investment Return (Inception-To-Date as of 12/31/2023) 11.17% 4.04% Pending BenchMayk Return (PARS Moderately Conservative) 10.29% 4.14% Pending Asset Allocation
Marrket Value Percentage
Cash and Equivalents 94,685.91 3.90%
Equity 715,307.13 29.50%
Fixed Income 1,614,371.88 66.58%
Accrued Income 412.13 0.02%
Total 2,424,777.05 100.00%
Account Manager:

Kyra Clarke
3121 Michelson Dr 3rd Fl
Irvine, CA 92612
949-224-7214, [email protected]
Cash and Equivalents

3.90%
Equity

29.50%
Fixed Income

66.58%
Accrued Income

0.02%
31 INFORMATION ONLY
ITEM 2

2. COVID-19 REIMBURSEMENT FINANCIAL UPDATE
DE

PARTMENT OF FINANCE
March 25, 2024
T
O: Miguel Márquez
City Manager
F
ROM: Matthew E. Hawkesworth
Director of Finance
SUB
JECT: COVID-19 Reimbursement Financial Update
T
his update provides details regarding the City of Pasadena’s submittal for the Federal Emergency Management Agency (FEMA) and the California Office of Emergency Services (CalOES) reimbursement related to expenditures incurred in response to the COVID-19 pandemic.

T
he City incurred expenditures in excess of $12.35 million that were submitted to CalOES and FEMA for reimbursement consideration. As presented to the City Council on many occasions during the pandemic response, some activities that the City undertook were the right thing to do for the community, regardless of reimbursement eligibility.

City staff would seek reimbursement for all expenses that did not have another funding source.

T
he City submitted 18 projects for reimbursement and received a final determination on five, as noted in the table below. For the one project that was rejected, the Pasadena Unified School District (PUSD) Meal Distribution, it was determined by CalOES and FEMA that supplementing the school district’s meal program on weekends and days in which the district’s distribution did not operate, and providing food to anyone who requested a meal was not related to an eligible Emergency Protective Measure (e.g., Individuals who test positive for COVID-19 or have been exposed to COVID-19, but do not require hospitalization; or individuals at high-risk, such as people over 65 or with certain underlying health conditions; or other populations that may need food assistance based on direction or guidance of the appropriate public health official). For reference, this is the program that the Pasadena Center Operating Company and the Rose Bowl Operating Company mobilized and provided bag lunches at PUSD sites.

T
hus far, the City has received approval for four projects. These projects include the three phases of the Great Plates Program and the establishment of the Alternative Care Site at the Pasadena Convention Center. These four projects total $5.46 million in reimbursements.

Financial Update
March 25, 2024

Page 2 of 2 ends

In the coming months, City staff will continue to respond to questions from CalOES and FEMA related to the 13 pending projects.

Title Cost Status
Great Plates Program (May-June 2020) $374,344.28 Approved Alternate Care Site $1,683,598.35 Approved
Great Plates Program $845,623.68 Approved
PUSD Meal Distribution (July-Sep. 2020) $594,306.00 Rejected Vaccine Administration $68,160.19 Pending
Great Plates Program (Oct. 2020-Jun. 2021) $2,555,075.24 Approved Labor-Public Health $3,630,499.47 Pending
Personnel Costs-Non Public Health $253,216.00 Pending
HR COVID Testing $247,180.00 Pending
COVID-19 Related Sanitation $376,647.00 Pending
COVID-19 Trailer Support $520,140.00 Pending
COVID-19 Contract Services Other $298,721.00 Pending
Materials and Supplies $635,716.00 Pending
Public Health COVID-19 Costs $11,798.00 Pending
Public Health Personnel Costs 7-1-22_5-31-23 $179,560.74 Pending Public Health Vaccine Clinic 7-1-22_5-31-23 $11,886.06 Pending Non-Departmental COVID-19 Costs 7-1-22_5-31-23 $49,140.00 Pending Fire Department COVID-19 Materials and Supplies 7-1-22_5-31-23 $14,400.82 Pending Total Expenditures $12,350,012.83

Finance CommitteeMarch 25, 2024

Finance Committee
March 25, 2024