Agenda — Finance Committee, March 13, 2023

AGENDA

FINANCE COMMITTEE

SPECIAL MEETING NOTICE
MARCH 13, 2023
PUBLIC MEETING 3: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.

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

Items 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/

Materials 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 SPECIAL FINANCE COMMITTEE MEETING FOR MARCH 13, 2023 AT 3:00 P.M. WILL BE ACCEPTED IN-PERSON AND BY VIDEOCONFERENCE/TELECONFERENCE.

Link to City Meeting Policy:
cityofpasadena.net/CityCouncilMeetingPolicy
In order to facilitate public participation at meetings the City will accept public comment in the following manner:

1. W
hether 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:
gac
[email protected]
C
orrespondence 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, I

F 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 13, 2023
Public Meeting: 3:00 P.M.

Council Chamber, Pasadena City Hall
100 North Garfield Avenue, Room S249
PUBLIC MEETING - 3: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

NEW BUSINESS

1. AMENDMENT TO THE HOUSING DEPARTMENT’S FISCAL YEAR 2023

OPERATING BUDGET AND APPROVAL OF KEY TERMS OF AMENDMENT TO AGREEMENT NO. 23,651 WITH HHP-FOOTHILL, LLC FOR
DEVELOPMENT OF INTERIM HOUSING PROJECT AT 2322 E. FOOTHILL

BOULEVARD FOR TRANSITION AGE YOUTH

2. AMENDMENT TO THE HOUSING DEPARTMENT’S FISCAL YEAR 2023 OPERATING BUDGET AND AUTHORIZATION TO AMEND CONTRACT NO. 31830 WITH THE FID GROUP DBA FRIENDS IN DEED WITH ADDITIONAL

FUNDING FOR THE PROVISION OF MOTEL VOUCHERS

3. RECOGNIZE AND APPROPRIATE GRANT FUNDS IN THE AMOUNT OF $42,981 FROM THE BLACK GOLD COOPERATIVE LIBRARY SYSTEM TO THE DEPARTMENT OF LIBRARIES AND INFORMATION SERVICES’ FISCAL YEAR 2023 OPERATING BUDGET

4. QUARTERLY INVESTMENT REPORT - QUARTER ENDING DECEMBER 31, 2022

INFORMATION ONLY

5. CONSUMER PRICE INDEX (CPI) ON CURRENT CONTRACTS

ADJOURN

Page 1 ends

NEW BUSINESS
ITEM 1
AMENDMENT TO THE HOUSING DEPARTMENT’S
FISCAL YEAR 2023 OPERATING BUDGET AND

APPROVAL OF KEY TERMS OF AMENDMENT TO
AGREEMENT NO. 23,651 WITH HHP-FOOTHILL, LLC

FOR DEVELOPMENT OF INTERIM HOUSING PROJECT
AT 2322 E. FOOTHILL BOULEVARD FOR TRANSITION

AGE YOUTH

Page 2 ends

Page 3 ends

Page 4 ends

Page 5 ends

Page 6 ends

NEW BUSINESS
ITEM 2
AM
ENDMENT TO THE HOUSING DEPARTMENT’S
FISCAL YEAR 2023 OPERATING BUDGET AND
AUTHORIZATION TO AMEND CONTRACT NO.
31830 WITH THE FID GROUP DBA FRIENDS IN

DEED WITH ADDITIONAL FUNDING FOR THE

PROVISION OF MOTEL VOUCHERS

Page 7 ends

e a 9 0 I
TO: Honorable Mayor and City Council
THROUGH: Finance Committee
FROM: Housing Department
March 13, 2023
SUBJECT: AMENDMENT TO THE HOUSING DEPARTMENT'S FISCAL YEAR 2023 OPERATING BUDGET AND AUTHORIZATION TO AMEND
CONTRACT NO. 31830 WITH THE FID GROUP DBA FRIENDS IN

DEED WITH ADDITIONAL FUNDING FOR THE PROVISION OF MOTEL

VOUCHERS
RECOMMENDATION:

It is recommended that the City Council take the following actions:
1) Find that the recommended actions are exempt from the California Environmental Quality Act ("CEQA") pursuant to State CEQA Guidelines per Section 15061 (b) (3), the "common sense" provision that CEQA only applies to projects that may have an effect on the environment;
2) Amend the Housing Department's Fiscal Year 2023 Operating Budget by transferring $100,000 from the unappropriated fund balance in the General Fund (101) to the Housing Department's Other Housing Fund (238) for expenses associated with the provision of weather-activated motel vouchers to people experiencing homelessness as detailed in the background section of this report; 3) Authorize the City Manager to amend Contract No. 31830 with The FID Group, dba Friends In Deed, to increase the total contract value by up to $100,000 for emergency shelter services as detailed in the body of this report. Competitive price bidding is not required pursuant to City Charter Section 1002(F) (contracts for professional or unique services); and
4) To the extent the amendment could be considered a separate procurement subject to the Competitive Selection Process, grant the contract an exemption pursuant to Pasadena Municipal Code (PMC) Section 4.08.049(8), contracts for which the City's best interests are served.

MEETING OF 03/-1..3/2023 AGENDA ITEM NO. __ l_l __ _

Page 8 ends

Authorization to Amend FY 2023 Operating Budget and Contract No. 31830 March 13, 2023

Page 2 of 4 ends

BACKGROUND:

On January 18 and February 27 of this year, Council approved the collective addition of $200,000 of General Fund dollars to Contract No. 31830 with Friends In Deed to support the continued provision of weather-activated motel vouchers. According to the National Weather Service, Pasadena received more than double the amount of rain than is typical throughout January and February. This increased precipitation, in addition to colder temperatures, has more frequently activated the City's system of providing motel stays, through non-profit partners such as Friends In Deed, to people experiencing homelessness during inclement weather. At the same time, federal emergency grant funding that supported weather-activated motel vouchers during the past two winter seasons is no longer available. In response, as a hypothermia prevention measure, Council has approved the use of General Funds to expand and sustain the provision of protective motel stays to those without homes.

Since January 5, Friends In Deed has provided motel stays to 117 unduplicated individuals on 43 nights as detailed in Table A. Additionally, at the time of this report's writing, the agency's staff had reserved 65 motel for ten nights (3/9-3/19) response to forecasted rain and low overnight temperatures. Friends In Deed staff expressed that they have been limited by motel room availability in recent weeks and hoped to reserve even more rooms. It is projected that the $100,000 of General Funds in February will be expended by March 14, 2023.

Table A
Dates #of Other GF GF
(Thurs.- # of People Nights Funding Approved Approved
Wed.) Served Activated Sources January 18 February 27 Unfunded Total
Expenditures
Weeks 1/5/23-
1-7
Week
8 Week
9 Week
10*
Week
11*
Week
12 Week
13 Total
2/22/23 113 26 $59,855.55 $62,723.55 $122,579.10
2/23/23-
3/1/23 90 7 $0.0C $37,276.4£: $48,693.55 $85,97(
3/2/23-
3/8/23 0 0 $0.0C $0.00 $0.00 $0.00
3/9/23-
3/15/23 80 7 $0.00 $0.00 $51,306.45 $11,693.55 $63,000
3/16/23- I
3/22/23 80 3 $0.00 $0.0C $0.00 $27,000 $27,000
3/23/23-
$0.od 3/29/23 TBD TBD TBC $0.00- TBD TBC
3/30/23-
4/5/23 TBD TBD TBD $0.00 $0.00 TBC TBD
43 $59,855.55 $100,000.00 $100,000.00 ;::$38,693.55 ;::$298,549.10 *Projected as of 3/9/23
The provision of weather-activated motel vouchers is currently scheduled through April 5, 2023. As such, the Department requests an additional $100,000 from General Fund which will be used to sustain the provision of motel

Page 9 ends

Authorization to Amend FY 2023 Operating Budget and Contract No. 31830 March 13, 2023

Page 3 of 4 ends

Staff recommends the approval of an amendment to Contract No. 31830 which will include an additional $100,000 of General Funds to allow Friends In Deed to support the weather-activated motel vouchers through April 5, 2023. Any funds not expended by April 5, 2023 will be returned to the City.

The Department recommends a competitive selection exemption due to Friends In Deed's demonstrated success and existing infrastructure to administer motel-based emergency shelter, including weather-activated motel vouchers. It is in the City's best interest to support the expansion of this program to protect residents experiencing homelessness from hypothermia during inclement weather.

ENVIRONMENTAL ANALYSIS:

The actions proposed herein are exempt from the California Environmental Quality Act (CEQA), pursuant to State CEQA Guidelines Section 15061 (b)(3), the "common sense" provision of CEQA which applies to projects which may have the potential a significant effect on the environment. Where it can be seen with certainty no possibility that the activity in question may have a significant effect on the environment, the activity is not subject to CEQA. The approval of an amendment to the Department's FY 2023 Operating Budget and an existing contract to add funding not have a significant effect on the environment and, hence, is not subject to CEQA.

COUNCIL POLICY CONSIDERATION:

Approval of the recommended actions will sustain the provision of weather-activated, motel vouchers for people experiencing unsheltered homelessness in Pasadena during the 2023 winter season. This action is consistent with the City Council's goal to support and promote the quality of life and local economy. The proposed actions are in accordance with the Pasadena Continuum of Care system, General Plan Housing Element, Five-Year Consolidated Plan, and Five-Year Public Housing Authority

Page 10 ends

Authorization to Amend FY 2023 Operating Budget and Contract No. 31830 March 13, 2023

Page 4 of 4 ends

FISCAL IMPACT:

Approval of the recommended actions will increase the Department's Fiscal Year 2023 Operating Budget in the Other Housing Fund (238) by $100,000 for the amendment to Contract No. 31830 with Friends in Deed. The General Fund's unappropriated fund balance will decrease by $100,000.

Prepared by:
for JENNIFER O'REILLY-JONES
Program Coordinator Ill
Respectfully submitted,
w.Jt....:.v r-�
WILLIAM K. HUANG (/
Housing Director
Approved by:
�_..__O� MIGEL MARQUEZ
City Manager

Page 11 ends

NEW BUSINESS
ITEM 3

RECOGNI

ZE AND APPROPRIATE GRANT FUNDS IN
THE AMOUNT OF $42,981 FROM THE BLACK GOLD

COOPERATIVE LIBRARY SYSTEM TO THE

DEPARTMENT OF LIBRARIES AND INFORMATION
SERVICES' FISCAL YEAR 2023 OPERATING BUDGET

Page 12 ends

Page 13 ends

Page 14 ends

Page 15 ends

Page 16 ends

Page 17 ends

Page 18 ends

Page 19 ends

Page 20 ends

INFORMATION ONLY
ITEM 4

QUARTERLY INVESTMENT REPORT - QUARTER
ENDING DECEMBER 31, 2022

Page 21 ends

Page 22 ends

Page 23 ends

Page 24 ends

Page 25 ends

Page 26 ends

Page 27 ends

Page 28 ends

Page 29 ends

City of Pasadena
Quarterly Investment Report
Quarter Ending 12
/31/2022
Prepared by the Department of Finance
Treasury Division
Attachment A

Page 30 ends

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

Page 31 ends

I. Pooled Investment Portfolio

Page 32 ends

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

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 20, 2022. 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/2022

TYPE MARKET VALUE PERCENT
Money Market - Collateralized 454 0.00%
Certificates of Deposit 1,250,000 0.20%
Municipal Bonds 32,408,639 5.15%
Corporate Bonds 89,268,825 14.18%
Federal Agencies 342,677,339 54.42%
US Treasury Securities 46,761,130 7.43%
Supernationals 23,154,155 3.68%
Commercial Paper 24,314,460 3.86%
Money Market-CAMP 57,331,643 9.10%
US Treasury Securities Disc 9,830,710 1.56%
LAIF 1,249,044 0.20%
Cash in Bank 1,477,316 0.23%
TOTALS: 629,723,714 100.00%
Accrued Interest Receivable 1,726,167
GRAND TOTAL: 631,449,881
PORTFOLIO LIQUIDITY AS OF 12/31/2022
Percent of
Aging Interval Par Value Portfolio
0-30 Days 60,058,457 8.93%
31 days - 1 Year 136,020,000 20.22%
1 - 2 Years 129,800,000 19.30%
2 - 3 Years 211,942,778 31.51%
3 - 4 Years 124,748,000 18.55%
4 - 5 Years 10,000,000 1.49%
Over 5 Years - 0.00%
TOTAL: 672,569,235 100.00%
Dec-22 Nov-22 Oct-22 Sep-22 Aug-22 Jul-22
Month-End Market Value 631,449,881 620,128,765 618,944,368 615,577,316 618,937,411 627,904,658 Modified Duration 1.82 1.82 1.87 1.96 1.97 2.02
Weighted Average Maturity 1.94 1.94 2.00 2.08 2.08 2.12 Current Book Yield to Maturity 1.707% 1.479% 1.403% 1.331% 1.200% 1.132% Effective Yield - Year to Date 1.310% 1.260% 1.210% 1.160% 1.110% 1.060% Interest Earned 795,749 738,376 710,973 637,773 603,728 559,284 Fiscal Year To Date Interest Earned 4,045,882 3,250,134 2,511,758 1,800,785 1,163,012 559,284 Fair Value Change Gain/(Loss) 532,669 3,972,334 (1,832,503) (7,920,701) (7,017,634) 2,386,228 Fiscal Year To Date change in fair value (9,879,607) (10,412,276) (14,384,610) (12,552,107) (4,631,406) 2,386,228 Total Fiscal YTD Earnings (5,833,725) (7,162,142) (11,872,852) (10,751,322) (3,468,394) 2,945,512

PORTFOLIO STATISTICS
MMF-Collateral

0.00%
Certificates of
Deposit

0.20%
Muni

5.15%
Corp Bond

14.18%
Fed Agency

54.42%
US Treasury

7.43%
Supranationals

3.68%
Commercial
Paper

3.86%
Money Market-
CAMP

9.10%
US Treasury
Securities Disc

1.56%
LAIF

0.20%
Cash
in
Bank

0.23%
1

Page 33 ends

2.290Local Agency Investment Fund864 1,009,520.18 1,009,520.18 2.2901,009,520.18SYS864 1

2.290LAIF-COVID Relief Funds Acct14053 239,523.52 239,523.52 2.290239,523.52SYS14053 1 1,249,043.701,249,043.701,249,043.701,249,043.70Subtotal and Average 2.290 1 Money Market Fund-CAMP

4.563California Asset Management Pr13824 57,331,642.81 57,331,642.81 4.50057,331,642.81SYS13824 1 57,331,642.8157,331,642.8157,331,642.8170,285,074.38Subtotal and Average 4.563 1 Collateralized Money Market

0.750EAST WEST BANK13067 454.30 454.30 0.750454.30SYS13067 1 454.30454.30454.30454.30Subtotal and Average 0.750 1
Municipal Bonds

2.364RIVERSIDE CALIFORNIA POB13810 1,000,000.00 1,000,000.00 02/15/20232.36305/06/2020 997,150.00 Aa276913CAX7 45

0.499Beverly Hills PFA13868 500,000.00 500,000.00 06/01/20230.49910/15/2020 491,710.00 AA+088006JX0 151

2.361Glendora CA PENSN OBLIG13989 1,450,000.00 1,446,956.17 06/01/20231.84805/18/2022 1,432,904.50 AAA378612AD7 151

0.391City of Orange Taxable Pension13915 1,500,000.00 1,500,000.00 06/01/20230.39103/15/2021 1,473,000.00 AA684100AB6 151

1.477STATE OF CALIFORNIA13885 1,000,000.00 1,000,000.00 07/01/20231.47711/24/2020 983,130.00 A-13017HAK2 181

1.650La Canada Unified School Distr13806 500,000.00 500,000.00 08/01/20231.65004/28/2020 491,900.00 Aa1502516QX8 212

1.078Oak Grove CA Sch Dist13821 500,000.00 500,000.00 08/01/20231.07806/25/2020 491,040.00 Aa3671205Y55 212

0.692Oxnard School District13841 500,000.00 500,000.00 08/01/20230.69209/03/2020 488,035.00 AA692020T34 212

2.025Buena Park Community RDA13738 1,240,000.00 1,240,000.00 09/01/20232.03311/13/2019 1,215,224.80 AA-119144AV5 243

2.085Escondido Lease Revenue Bonds13744 830,000.00 830,000.00 09/01/20232.08511/26/2019 816,412.90 AA-29634EEE8 243

0.475Califfornia State Univ Revenur13830 2,000,000.00 2,000,000.00 11/01/20230.47509/17/2020 1,932,380.00 Aa213077DMJ8 304

2.125Beverly Hills PFA13710 1,000,000.00 1,000,000.00 06/01/20242.12508/08/2019 966,250.00 AA+088006JM4 517

0.730Beverly Hills PFA13869 750,000.00 750,000.00 06/01/20240.73010/15/2020 710,100.00 AA+088006JY8 517

0.587City of Orange Taxable Pension13916 1,500,000.00 1,500,000.00 06/01/20240.58703/15/2021 1,412,460.00 AA684100AC4 517

2.070South Pasadena Unified School13748 325,000.00 339,302.77 08/01/20245.00012/12/2019 327,710.50 Aa2839278JX7 578

0.580SAN RAMON VLY CA UNIF SCH DIST13871 1,500,000.00 1,500,000.00 08/01/20240.58010/20/2020 1,410,075.00 Aa1799408Z77 578

0.575West Coast Contra Unified Scho13941 1,000,000.00 1,000,000.00 08/01/20240.57506/17/2021 938,250.00 AA9523474U3 578

0.685Califfornia State Univ Revenur13829 2,000,000.00 2,000,000.00 11/01/20240.68509/17/2020 1,855,180.00 Aa213077DMK5 670

0.982City of Arcadia13882 675,000.00 675,000.00 12/01/20240.98211/12/2020 631,131.75 Aaa039063AD4 700

0.650SANTA BARBARA CNTY CA SOLID WA13894 300,000.00 317,115.69 12/01/20243.67012/18/2020 294,054.00 A180136PDB6 700

0.943Huntington Beach CA Public Fin13861 300,000.00 300,000.00 05/01/20250.94308/12/2020 274,698.00 AA446216HJ5 851

0.883UNIVERSITY OF CA REVENUE BONDS13827 1,000,000.00 1,000,000.00 05/15/20250.88307/16/2020 917,120.00 Aa291412HGE7 865

0.610UNIVERSITY OF CA REVENUE BONDS13893 5,000,000.00 5,031,870.48 05/15/20250.88312/16/2020 4,585,600.00 Aa291412HGE7 865

0.952California St Health Facs Fing13883 1,500,000.00 1,500,000.00 06/01/20250.95211/04/2020 1,371,690.00 Aa313032UXM5 882

0.824Redondo Beach Unified School13840 500,000.00 500,000.00 08/01/20250.82408/06/2020 452,605.00 Aa2757710TZ1 943 Portfolio PASD
APData Updated: SET_POOL: 01/24/2023 11:04
Run Date: 01/24/2023 - 11:04 PM (PRF_PM2) 7.3.0
2

Page 34 ends

YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2022
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Municipal Bonds

2.311South Pasadena Unified School13747 675,000.00 718,716.65 08/01/20255.00012/12/2019 682,337.25 Aa2839278JY5 943

0.740SAN RAMON VLY CA UNIF SCH DIST13872 1,500,000.00 1,500,000.00 08/01/20250.74010/20/2020 1,359,195.00 Aa1799408Z85 943

0.938West Coast Contra Unified Scho13940 3,000,000.00 3,000,000.00 08/01/20250.93806/17/2021 2,727,900.00 AA9523474V1 943

1.181City of Arcadia13881 750,000.00 750,000.00 12/01/20251.18211/12/2020 679,395.00 Aaa039063AE2 1,065 34,398,961.7632,408,638.7034,295,000.0034,400,560.47Subtotal and Average 1.031 596 Certificates of Deposit - Bank

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

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

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

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

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

2.250Federal Home Loan Bank13986 5,000,000.00 5,000,000.00 06/09/20232.25006/09/2022 4,943,950.55 Aaa3130AS4W6 159

3.250Federal Home Loan Bank13995 5,000,000.00 5,000,000.00 07/27/20233.25007/27/2022 4,957,899.70 Aaa3130ASQ44 207

4.625Federal Home Loan Bank14000 5,000,000.00 5,000,000.00 10/27/20234.62510/27/2022 4,994,298.85 Aaa3130ATNK9 299

0.320FED HOME LOAN MORTAGE CORP13879 10,000,000.00 10,000,000.00 11/02/20230.32011/02/2020 9,634,445.50 Aaa3134GW6E1 305

0.320FED HOME LOAN MORTAGE CORP13880 5,000,000.00 5,000,000.00 11/02/20230.32011/02/2020 4,817,222.75 Aaa3134GW6E1 305

0.320FED HOME LOAN MORTAGE CORP13887 10,000,000.00 10,000,000.00 11/24/20230.32011/24/2020 9,592,786.60 Aaa3134GXCA0 327

0.250Federal Home Loan Bank13896 5,000,000.00 5,000,000.00 12/28/20230.25012/28/2020 4,774,500.35 Aaa3130AKL79 361

0.250Federal Home Loan Bank13897 5,000,000.00 5,000,000.00 12/28/20230.25012/28/2020 4,774,500.35 Aaa3130AKL79 361

0.800Federal Home Loan Bank13972 7,500,000.00 7,500,000.00 12/28/20230.80012/28/2021 7,195,889.25 Aaa3130AQ6F5 361

0.500Federal Home Loan Bank13927 10,000,000.00 10,000,000.00 04/29/20240.50004/29/2021 9,434,644.40 Aaa3130ALXQ2 484

3.100FED HOME LOAN MORTAGE CORP13994 5,000,000.00 5,000,000.00 06/28/20243.10006/28/2022 4,874,447.35 Aaa3134GXYE8 544

0.625Federal Home Loan Bank13944 5,000,000.00 5,000,000.00 10/15/20240.62507/15/2021 4,642,530.65 Aaa3130AN4L1 653

0.500Federal Home Loan Bank13948 5,000,000.00 5,000,000.00 10/30/20240.50009/30/2021 4,625,149.85 Aaa3130ANYT1 668

0.900Federal Home Loan Bank13966 5,000,000.00 5,000,000.00 11/08/20240.90011/08/2021 4,656,273.05 Aaa3130APPQ2 677

1.100Federal Home Loan Bank13968 5,000,000.00 5,000,000.00 11/15/20241.10011/15/2021 4,680,998.15 Aaa3130APRA5 684

0.550Federal Home Loan Bank13937 10,000,000.00 10,000,000.00 11/26/20240.55005/26/2021 9,226,523.00 Aaa3130AMK92 695

0.650Federal Home Loan Bank13932 5,000,000.00 5,000,000.00 12/09/20240.65006/09/2021 4,621,095.15 Aaa3130AMJX1 708

1.150Federal Home Loan Bank13971 5,000,000.00 5,000,000.00 12/10/20241.15012/10/2021 4,681,291.40 Aaa3130AQ3F8 709

1.125Federal Home Loan Bank13973 5,000,000.00 5,000,000.00 01/21/20251.12501/21/2022 4,654,773.00 Aaa3130AQFG3 751

1.250Federal Home Loan Bank13975 5,000,000.00 5,000,000.00 01/28/20251.25001/28/2022 4,657,976.50 Aaa3130AQJ79 758

1.500Federal Home Loan Bank13977 5,000,000.00 5,000,000.00 02/18/20251.50002/18/2022 4,687,740.35 Aaa3130AQPF4 779

0.625Federal Home Loan Bank13933 5,000,000.00 5,000,000.00 02/27/20250.62505/27/2021 4,584,146.85 Aaa3130AMMG4 788

1.810Federal Home Loan Bank13979 4,700,000.00 4,700,000.00 02/27/20251.81002/28/2022 4,420,809.85 Aaa3130AQX99 788 Portfolio PASD
APData Updated: SET_POOL: 01/24/2023 11:04
Run Date: 01/24/2023 - 11:04 PM (PRF_PM2) 7.3.0
3

Page 35 ends

0.650Federal Home Loan Bank13959 5,000,000.00 5,000,000.00 03/28/20250.65009/28/2021 4,574,690.85 Aaa3130AP5S0 817

3.000Federal Home Loan Bank13982 5,000,000.00 5,000,000.00 04/22/20253.00004/22/2022 4,805,533.25 Aaa3130ARJW2 842

0.750Federal Home Loan Bank13811 5,000,000.00 5,000,000.00 05/19/20250.75005/19/2020 4,561,514.85 Aaa3130AJLA5 869

3.400Federal Home Loan Bank13985 5,000,000.00 5,000,000.00 05/23/20253.40005/23/2022 4,839,165.85 Aaa3130ARZD6 873

0.750FED HOME LOAN MORTAGE CORP13814 5,000,000.00 5,000,000.00 05/28/20250.75005/28/2020 4,557,892.60 Aaa3134GVVX3 878

0.750FED HOME LOAN MORTAGE CORP13816 5,000,000.00 5,000,000.00 05/28/20250.75005/29/2020 4,541,407.10 Aaa3134GVB31 878

0.750FED HOME LOAN MORTAGE CORP13817 5,000,000.00 5,000,000.00 05/28/20250.75006/01/2020 4,541,407.10 Aaa3134GVB31 878

0.780Federal Farm Credit Bank13820 5,000,000.00 5,000,000.00 06/16/20250.78006/16/2020 4,562,064.95 Aaa3133ELK37 897

0.764Federal Home Loan Bank13822 3,017,777.77 3,017,480.52 06/16/20250.76006/19/2020 2,748,684.79 Aaa3130AJPT0 897

4.100Federal Home Loan Bank13996 5,000,000.00 5,000,000.00 08/08/20254.10008/08/2022 4,924,612.55 Aaa3130ASRJ0 950

0.650FED NATIONAL MORTGAGE ASSN13828 5,000,000.00 5,000,000.00 08/14/20250.65008/14/2020 4,524,159.05 Aaa3136G4C43 956

0.614Federal Farm Credit Bank13863 5,000,000.00 4,999,465.55 08/25/20250.61009/10/2020 4,509,327.00 Aaa3133EL4W1 967

0.530Federal Farm Credit Bank13864 20,000,000.00 20,000,000.00 09/29/20250.53009/29/2020 17,875,900.60 Aaa3133EMBH4 1,002

4.300Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 09/30/20254.30009/30/2022 4,994,515.95 Aaa3130ATBN6 1,003

0.600FED HOME LOAN MORTAGE CORP13870 10,000,000.00 10,000,000.00 09/30/20250.60009/30/2020 9,008,131.50 Aaa3134GWVN3 1,003

0.600FED HOME LOAN MORTAGE CORP13873 10,000,000.00 10,000,000.00 10/15/20250.60010/15/2020 8,920,249.50 Aaa3134GWYS9 1,018

0.625FED HOME LOAN MORTAGE CORP13877 10,000,000.00 10,000,000.00 10/27/20250.62510/27/2020 8,959,686.90 Aaa3134GW3X2 1,030

0.600FED HOME LOAN MORTAGE CORP13878 5,000,000.00 5,000,000.00 10/27/20250.60010/27/2020 4,492,973.95 Aaa3134GW5P7 1,030

0.600FED HOME LOAN MORTAGE CORP13874 10,000,000.00 10,000,000.00 10/28/20250.60010/28/2020 8,985,155.80 Aaa3134GW3F1 1,031

0.600FED HOME LOAN MORTAGE CORP13876 5,000,000.00 5,000,000.00 10/28/20250.60010/28/2020 4,492,577.90 Aaa3134GW3Z7 1,031

0.600Federal Farm Credit Bank13888 10,000,000.00 10,000,000.00 11/24/20250.60011/24/2020 8,950,300.50 Aaa3133EMHF2 1,058

0.690FED HOME LOAN MORTAGE CORP13886 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,479,893.80 Aaa3134GXCS1 1,059

0.719FED HOME LOAN MORTAGE CORP13891 5,000,000.00 5,000,000.00 11/26/20250.65011/30/2020 4,485,234.65 Aaa3134GXFA7 1,060

5.000Federal Home Loan Bank14007 5,000,000.00 5,000,000.00 12/29/20255.00012/29/2022 4,991,219.35 Aaa3130AUBX1 1,093

5.350FED HOME LOAN MORTAGE CORP14002 5,000,000.00 5,000,000.00 12/29/20255.35012/29/2022 5,008,695.00 Aaa3134GY7A4 1,093

0.550Federal Home Loan Bank13900 5,000,000.00 5,000,000.00 02/12/20260.55002/12/2021 4,435,076.75 Aaa3130AKVR4 1,138

0.625Federal Home Loan Bank13905 5,000,000.00 5,000,000.00 02/17/20260.62502/17/2021 4,442,423.15 Aaa3130AL3S1 1,143

0.750Federal Home Loan Bank13907 5,000,000.00 5,000,000.00 02/24/20260.75002/24/2021 4,457,106.05 Aaa3130ALCV4 1,150

0.630Federal Home Loan Bank13906 5,000,000.00 5,000,000.00 02/26/20260.63002/26/2021 4,439,317.90 Aaa3130ALB94 1,152

0.844Federal Farm Credit Bank13911 10,000,000.00 9,998,732.22 03/02/20260.84003/02/2021 8,950,157.90 Aaa3133EMSK9 1,156

0.800Federal Home Loan Bank13908 5,000,000.00 5,000,000.00 03/04/20260.80003/04/2021 4,461,580.55 Aaa3130ALEY6 1,158

0.800Federal Home Loan Bank13909 5,000,000.00 5,000,000.00 03/10/20260.80003/10/2021 4,472,986.10 Aaa3130ALFS8 1,164

1.000Federal Home Loan Bank13910 4,875,000.00 4,875,000.00 03/23/20261.00003/23/2021 4,370,025.56 Aaa3130ALGJ7 1,177

5.000Federal Farm Credit Bank13999 5,000,000.00 5,000,000.00 09/23/20265.00009/23/2022 4,969,979.65 Aaa3133ENN97 1,361

0.940Federal Farm Credit Bank13960 5,000,000.00 5,000,000.00 09/28/20260.94009/28/2021 4,387,109.25 Aaa3133EM6E7 1,366

1.000Federal Home Loan Bank13953 5,000,000.00 5,000,000.00 09/30/20261.00009/30/2021 4,414,588.30 Aaa3130ANYN4 1,368

1.250Federal Home Loan Bank13964 5,000,000.00 5,000,000.00 10/28/20261.25010/28/2021 4,447,001.15 Aaa3130APDQ5 1,396

5.000Federal Home Loan Bank13998 5,000,000.00 5,000,000.00 09/14/20275.00009/28/2022 4,961,097.50 Aaa3130AT3P0 1,717 Portfolio PASD
APData Updated: SET_POOL: 01/24/2023 11:04
Run Date: 01/24/2023 - 11:04 PM (PRF_PM2) 7.3.0
4

Page 36 ends

0.761US TREASURY13974 10,000,000.00 9,998,913.39 12/31/20230.75012/31/2021 9,614,450.00 Aaa91282CDR9 364

1.081US TREASURY13978 5,000,000.00 4,989,008.99 01/31/20240.87501/31/2022 4,798,240.00 Aaa91282CDV0 395

0.470US TREASURY13943 10,000,000.00 9,968,294.63 06/15/20240.25006/25/2021 9,389,060.00 Aaa91282CCG4 531

0.515US TREASURY13962 5,000,000.00 4,988,134.27 09/15/20240.37509/24/2021 4,662,695.00 Aaa91282CCX7 623

0.747US TREASURY13965 5,000,000.00 4,989,225.35 10/15/20240.62510/22/2021 4,672,070.00 Aaa91282CDB4 653

0.554US TREASURY13954 10,000,000.00 9,988,099.85 03/31/20250.50009/16/2021 9,191,410.00 Aaa912828ZF0 820

0.924US TREASURY13963 5,000,000.00 4,968,965.48 08/31/20260.75009/24/2021 4,433,205.00 Aaa91282CCW9 1,338 49,890,641.9646,761,130.0050,000,000.0049,888,185.36Subtotal and Average 0.684 644 Corporate Bonds - Coupon

2.728APPLE INC13693 5,000,000.00 5,000,829.59 02/23/20232.85004/24/2019 4,986,237.90 Aaa037833BU3 53

0.441TOYOTA CREDIT CORPORATION13929 3,000,000.00 2,999,678.03 04/06/20230.40004/09/2021 2,966,727.93 A189236TJD8 95

2.500JPMORGAN CHASE FINANCIAL13984 2,000,000.00 2,000,000.00 05/01/20232.50004/29/2022 1,977,518.28 A148133DE71 120

2.750CITIGROUP GLOBAL MARKETS13988 2,500,000.00 2,500,000.00 06/16/20232.75005/16/2022 2,466,477.90 A217330FUE9 166

5.001JPMORGAN CHASE FINANCIAL14009 5,000,000.00 5,000,000.00 12/26/20235.00012/22/2022 4,998,317.55 A148133PDD2 359

0.654ROYAL BANK OF CANADA13918 5,000,000.00 4,988,102.82 01/19/20240.42503/11/2021 4,774,887.00 A178015K7L2 383

2.250GOLDMAN SACHS13980 2,500,000.00 2,500,000.00 03/15/20242.25003/15/2022 2,345,931.70 A238150AL86 439

3.125JPMORGAN CHASE FINANCIAL13983 2,000,000.00 2,000,000.00 04/29/20243.12504/29/2022 1,912,604.60 A148133DE55 484

0.800Goldman Sach Corporate Bond13935 5,000,000.00 5,000,000.00 06/03/20240.80006/03/2021 4,683,039.95 A238150AG41 519

0.672ROYAL BANK OF CANADA13947 5,000,000.00 4,998,290.74 07/29/20240.65007/29/2021 4,669,141.70 A178016EZU4 575

0.900NEW YORK LIFE GL13967 5,000,000.00 5,000,000.00 10/29/20240.90010/29/2021 4,633,502.90 Aaa64952WEJ8 667

4.050CITIGROUP GLOBAL MARKETS13990 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,417,585.78 A217330FVU2 877

4.050CITIGROUP GLOBAL MARKETS13991 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,417,585.78 A217330FVU2 877

0.825JP MORGAN13898 5,000,000.00 5,000,000.00 12/22/20250.82512/22/2020 4,343,815.45 A148128GY53 1,086

1.526BANK OF AMERICA CORP13923 5,000,000.00 4,884,168.58 01/26/20260.60003/25/2021 4,352,587.40 A206048WK82 1,121

0.752BANK OF NEW YORK MELLON13901 5,000,000.00 4,999,691.82 01/28/20260.75002/02/2021 4,434,057.00 A106406RAQ0 1,123

0.718APPLE INC13902 5,000,000.00 4,997,331.61 02/08/20260.70002/08/2021 4,442,558.95 Aaa037833EB2 1,134

1.250BANK OF AMERICA CORP13934 5,000,000.00 5,000,000.00 05/28/20261.25005/28/2021 4,308,150.50 A206048WM31 1,243

1.263BANK OF AMERICA CORP13945 3,623,000.00 3,615,316.95 06/25/20261.20007/21/2021 2,984,588.24 A206048WM64 1,271

1.155ROYAL BANK OF CANADA13958 6,250,000.00 6,248,851.58 07/14/20261.15009/22/2021 5,510,187.44 A178016EZT7 1,290

1.365Credit Suisse New York13961 5,000,000.00 4,980,001.83 08/07/20261.25009/24/2021 4,050,744.60 A322550L2G5 1,314

5.650CITIGROUP14004 5,000,000.00 5,000,000.00 12/16/20275.65012/16/2022 4,699,556.30 Aa117330YDB3 1,810 91,712,263.5584,375,804.8591,873,000.0089,000,477.19Subtotal and Average 1.866 838 Commercial Paper Disc. -Amortizing

2.597Credit Suisse NY13992 5,000,000.00 4,981,359.11 02/24/202306/02/2022 4,957,920.00 P-12254EBPQ8 54

5.353BOFA SECURITIES INC CP14001 5,000,000.00 4,879,785.14 06/20/20235.06010/24/2022 4,882,130.00 P-106054PTL0 170 Portfolio PASD
APData Updated: SET_POOL: 01/24/2023 11:04
Run Date: 01/24/2023 - 11:04 PM (PRF_PM2) 7.3.0
5

Page 37 ends

5.432MUFG BANK LTD NY14003 5,000,000.00 4,827,763.48 09/01/20235.12012/07/2022 4,832,515.00 P-162479MW17 243

5.411NATIXIS NY BRANCH14005 5,000,000.00 4,823,513.97 09/08/20235.10212/19/2022 4,818,700.00 P-163873KW86 250

5.334MUFG BANK LTD NY14006 5,000,000.00 4,821,090.17 09/15/20235.03012/20/2022 4,823,195.00 P-162479MWF6 257 24,333,511.8724,314,460.0025,000,000.0017,940,415.58Subtotal and Average 4.812 194 Treasury Discounts -Amortizing

2.208US TREASURY13993 10,000,000.00 9,918,369.58 05/18/20232.11506/07/2022 9,830,710.00 Aaa912796W47 137

4.766US TREASURY14008 5,000,000.00 4,891,416.99 06/22/20234.53012/22/2022 4,893,020.00 Aaa912796ZQ5 172 14,809,786.5714,723,730.0015,000,000.0011,486,444.38Subtotal and Average 3.053 149 Supranationals

1.070Inter-American Devel Bank13976 5,000,000.00 5,079,921.15 01/16/20242.62501/21/2022 4,886,696.60 Aaa4581X0DF2 380

0.500Inter-American Devel Bank13955 10,000,000.00 10,000,000.00 09/23/20240.50009/23/2021 9,320,062.40 Aaa4581X0DZ8 631

0.610INTL FINANCE CORP13957 5,000,000.00 4,998,926.10 02/28/20250.60009/28/2021 4,602,916.35 Aaa45950VQJ8 789

0.647INTL BK RECON & DEVELOP13903 5,000,000.00 5,000,000.00 02/10/20260.65002/10/2021 4,344,479.45 Aaa459058JS3 1,136 25,078,847.2523,154,154.8025,000,000.0025,081,818.46Subtotal and Average 0.667 712 661,640,865.88 671,091,918.58 1.707 708628,246,397.76 670,145,832.06Total and Average Portfolio PASD
APData Updated: SET_POOL: 01/24/2023 11:04
Run Date: 01/24/2023 - 11:04 PM (PRF_PM2) 7.3.0
6

Page 38 ends

COMPLIANCE REPORT
Pooled Investment Portfolio
As of 12/31/22
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.20% 30% In compliance n/a n/a In compliance In compliance Municipal Bonds 5.15% 100% In compliance Aaa/Aa3/Aa2/Aa1/A2/AA+/AA-/AAA/AA A or better In compliance In compliance US Treasury Securities 7.43% 100% In compliance Aaa AA+/Aaa In compliance In compliance Corporate Bonds 14.18% 30% In compliance* Aa1/A1/A2/A3 A or better In compliance In compliance Federal Agency Issues 54.42% 100% In compliance Aaa AA+/Aaa In compliance In compliance Supranationals 3.68% 30% In compliance Aaa AA or better In compliance In compliance Commercial Paper 3.86% 100% In compliance P-1 (Short-term) P-1 (Short-term) In compliance In compliance Money Market-CAMP 9.10% 100% In compliance n/a n/a In compliance In compliance US Treasury Securities Disc 1.56% 100% In compliance Aaa AA+/Aaa In compliance In compliance LAIF 0.20% 100% In compliance n/a n/a In compliance In compliance Cash 0.23% 100% In compliance Collateralized Collateralized In compliance In compliance 100.00%
Portfolio Value 631,449,881
7

Page 39 ends

INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE POOL PORTFOLIO
December 31, 2022
Market Value % of Total
FHLB 182,556,132 28.91%
FHLMC 101,392,208 16.06%
FFCB 54,204,840 8.58%
Total Fed Agencies/Supranationals 342,677,339 54.27%
OTHER PORTFOLIO INVESTMENTS 288,772,542 45.73%
Total Investments 631,449,881 * 100.00%
note: * Includes Cash in Bank and Accrued Interest Receivable 8

Page 40 ends

Pooled Portfolio - Total Return Performance
ICE BofA Pooled
1-3 Index Portfolio
2003 Annual 2.717 2.931
2004 Annual 1.226 2.090
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
Effective Yield Fiscal YTD
Pooled Portfolio effective yield 1.31%
State Treasurer's LAIF yield 1.72%
2 Year Average US Treasury yield 3.82%
9

Page 41 ends

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 2018 2019 2020 2021 2022 2023 2023 2023 2023 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 3.54 1.59 11.73 6.76 0.00 0.00 0.00 Municipal Bonds 12.62 13.00 4.97 4.01 5.80 5.78 4.33 4.72 7.70 5.96 5.37 5.15 Corporate Bonds - Coupon 25.94 22.67 21.65 16.36 17.12 15.47 20.78 22.50 16.62 13.97 14.06 14.18 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 60.37 54.14 34.00 47.35 48.79 53.04 54.42 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 6.47 7.29 11.66 16.47 4.00 0.20 0.20 Cash 2.72 2.50 3.76 0.68 0.44 0.43 0.45 0.34 0.53 0.31 0.49 0.23 Treasury Securities 0.00 0.00 3.93 3.37 2.99 3.26 3.71 2.37 3.66 7.46 7.57 7.43 Treasury Securities Disc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.54 1.59 1.56 Supranationals 0.00 0.00 0.00 4.25 3.76 4.49 5.89 8.24 0.80 3.73 3.76 3.68 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.00 0.82 0.00 0.00 1.55 2.42 3.86 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.00 0.77 0.00 0.00 Certificates of Deposit 0.22 0.23 0.00 0.00 0.00 0.19 1.00 0.00 0.00 0.20 0.20 0.20 Money Market-CAMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.89 0.12 11.72 11.30 9.10 Muni Variable Rate 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.54 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

Page 42 ends

II. Capital Endowment Portfolio

Page 43 ends

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

PORTFOLIO STRUCTURE AS OF 12/31/2022

TYPE MARKET VALUE PERCENT
Money Market - Collateralized 13 0.00%
Money Market - CAMP 74,134 4.02%
Federal Agencies 1,770,174 95.98%
TOTALS: 1,844,320 100.00%
Accrued Interest Receivable 2,171
GRAND TOTAL: 1,846,492
PORTFOLIO LIQUIDITY AS OF 12/31/2022
Percent of
Aging Interval Par Value Portfolio
0-30 Days 74,147 3.76%
31 days - 1 Year - 0.00%
1 - 2 Years - 0.00%
2 - 3 Years 1,900,000 96.24%
3 - 4 Years - 0.00%
4 - 5 Years - 0.00%
Over 5 Years - 0.00%
TOTAL: 1,974,147 100.00% -

PORTFOLIO STATISTICS
Dec-22 Nov-22 Oct-22 Sep-22 Aug-22 Jul-22
Month-End Mkt Value 1,846,492 1,840,763 1,828,787 1,833,119 1,857,675 1,876,121 Modified Duration 1.77 1.84 1.92 2.00 2.09 2.18
Weighted Average Maturity 1.83 1.91 2.00 2.08 2.16 2.24 Current Book Yield to Maturity 1.134% 1.116% 1.074% 1.066% 1.046% 1.032% Effective Yield - Year to Date 1.060% 1.050% 1.040% 1.030% 1.010% 1.000% Interest Earned 1,854 1,800 1,755 1,726 1,708 1,672 Fiscal Year To Date Interest Earned 10,516 8,661 6,861 5,106 3,381 1,672 Fair Value Change Gain/(Loss) 3,874 10,176 (6,086) (26,282) (20,154) (11,169) Fiscal Year To Date change in fair value (49,642) (53,516) (63,691) (57,605) (31,323) (11,169) Total Fiscal YTD earnings (39,126) (44,855) (56,830) (52,499) (27,942) (9,496) MMF -
Collateral
, 0.00%
MMF -
CAMP,

4.02%
Federal
Agencies,

95.98%
11

Page 44 ends

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

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

4.563California Asset Management Pr14111 74,133.68 74,133.68 4.50074,133.68SYS14111 1 74,133.6874,133.6874,133.6874,133.68Subtotal and Average 4.563 1 Collateralized Money Market

0.750EAST WEST BANK13057 13.19 13.19 0.75007/01/2022 13.19SYS13057 1

13.1913.1913.1913.19Subtotal and Average 0.750 1
Federal Agency Issues - Coupon

1.000Federal Home Loan Bank13970 1,900,000.00 1,900,000.00 11/25/20241.00011/30/2021 1,770,173.61 Aaa3130APVG7 694 1,900,000.001,770,173.611,900,000.001,900,000.00Subtotal and Average 1.000 694 1,974,146.87 1,974,146.87 1.134 6681,844,320.48 1,974,146.87Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 01/18/2023 11:22
Run Date: 01/18/2023 - 11:22 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
12

Page 45 ends

COMPLIANCE REPORT
Capital Endowment Portfolio
As of 12/31/22
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 Money Market-CAMP 4.02% 100% In compliance n/a n/a In compliance In compliance Federal Agency Issues 95.98% 100% In compliance** Aaa AA+/Aaa In compliance In compliance 100.00%
Portfolio Value 1,846,492
**Compliance is measured based on the City's total investments which include the Pooled portfolio as well as the Power Reserve Fund. 13

Page 46 ends

INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE CAPITAL ENDOWMENT PORTFOLIO
December 31, 2022
Market Value % of Total
FHLB 1,770,174 95.87%
Total 1,770,174 95.87%
OTHER PORTFOLIO INVESTMENTS 76,318 4.13%
Total Investments 1,846,492 * 100.00%
note: * Includes Accrued Interest Receivable
14

Page 47 ends

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 2015 2016 2017 2018 2019 2020 2021 2022 2023 2023 2023 2023 Money Market - Collateralized 100.00 100.00 1.80 0.75 0.03 1.10 3.10 3.38 0.00 0.00 Federal Agency Issues - Coupon 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96.62 96.49 95.98 Corporate Bonds - Coupon 0.00 0.00 0.00 99.25 99.97 98.90 96.90 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 0.00 98.20 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 0.00 3.51 4.02 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

Page 48 ends

III. Power Reserve Portfolio

Page 49 ends

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

PORTFOLIO STRUCTURE AS OF 12/31/2022

TYPE MARKET VALUE PERCENT
Money Market - Collateralized 33 0.00%
Municipal Bonds 1,834,120 4.66%
Federal Agencies 28,666,148 72.87%
L.A.I.F. 42,654 0.11%
Money Market-CAMP 8,795,916 22.36%
TOTALS: 39,338,871 100.00%
Accrued Interest Receivable 213,683
GRAND TOTAL: 39,552,554
PORTFOLIO LIQUIDITY AS OF 12/31/2022
Percent of
Aging Interval Par Value Portfolio
0 - 30 days 8,838,603 18.22%
31 days - 1 Year - 0.00%
1 - 2 Years - 0.00%
2 - 3 Years 5,000,000 10.31%
3 - 4 Years - 0.00%
4 - 5 Years 2,000,000 4.12%
Over 5 Years 32,666,667 67.35%
TOTAL: 48,505,270 100.00%

PORTFOLIO STATISTICS
Dec-22 Nov-22 Oct-22 Sep-22 Aug-22 Jul-22
Month-End Market Value 39,552,554 39,567,133 38,262,460 39,374,095 41,061,284 42,426,446 Modified Duration 6.30 6.40 6.28 6.55 6.86 7.09
Weighted Average Maturity 8.56 8.63 8.71 8.81 8.88 8.98 Current Book Yield to Maturity 2.205% 2.119% 1.964% 1.918% 1.648% 1.640% Effective Yield - Year to Date 1.860% 1.810% 1.730% 1.670% 1.610% 1.610% Interest Earned 87,545 84,298 78,370 70,296 65,901 65,434 Fiscal Year To Date Interest Earned 451,843 364,298 280,000 201,630 131,335 65,434 Fair Value Change Gain/(Loss) (102,153) 1,220,375 (1,190,005) (1,756,826) (1,431,063) 498,711 Fiscal Year To Date change in fair value (2,760,961) (2,658,808) (3,879,183) (2,689,179) (932,352) 498,711 Total Fiscal YTD Earnings (2,309,118) (2,294,510) (3,599,183) (2,487,548) (801,018) 564,145 Money Market-
CAMP

1.03% Muni

4.66%
Fed Agency

72.87%
Municipal
Bonds

4.54%
Money Market-
CAMP

22.36%
16

Page 50 ends

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

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

2.290Local Agency Investment Fund6184 42,654.14 42,654.14 2.29042,654.14SYS6184 1 42,654.1442,654.1442,654.1442,654.14Subtotal and Average 2.290 1 Money Market Fund-CAMP

4.563California Asset Management Pr14063 8,795,915.85 8,795,915.85 4.5008,795,915.85SYS14063 1 8,795,915.858,795,915.858,795,915.858,795,915.85Subtotal and Average 4.563 1 Collateralized Money Market

0.750EAST WEST BANK13066 33.04 33.04 0.75033.04SYS13066 1

33.0433.0433.0433.04Subtotal and Average 0.750 1
Municipal Bonds

2.560LA County Redevelopment TABs13553 2,000,000.00 1,988,095.84 09/01/20262.37508/25/2016 1,834,120.00 Aa254465AGS5 1,339 1,988,095.841,834,120.002,000,000.001,987,969.29Subtotal and Average 2.560 1,339 Federal Agency Issues - Coupon

1.000Federal Home Loan Bank13969 5,000,000.00 5,000,000.00 11/25/20241.00011/30/2021 4,658,351.60 Aaa3130APV69 694

1.230Federal Farm Credit Bank13946 6,000,000.00 6,000,000.00 08/02/20281.23008/02/2021 5,089,422.84 Aaa3133EMX80 2,040

1.230Federal Farm Credit Bank13890 5,000,000.00 5,000,000.00 11/25/20301.23011/25/2020 3,974,843.00 Aaa3133EMHN5 2,885

1.850Federal Home Loan Bank13788 1,666,667.00 1,666,667.00 04/08/20321.85004/08/2020 1,339,400.20 Aaa3130AJEA3 3,385

2.000Federal Home Loan Bank13904 10,000,000.00 10,000,000.00 02/25/20362.00002/25/2021 7,284,687.20 Aaa3130AL3X0 4,803

2.000Federal Farm Credit Bank13875 10,000,000.00 10,000,000.00 10/15/20402.00010/15/2020 6,319,442.90 Aaa3133EMCV2 6,497 37,666,667.0028,666,147.7437,666,667.0037,666,667.00Subtotal and Average 1.636 3,950 48,493,239.32 48,505,270.03 2.205 3,12339,338,870.77 48,493,365.87Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 01/18/2023 11:30
Run Date: 01/18/2023 - 11:30 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
17

Page 51 ends

COMPLIANCE REPORT
Power Reserve Portfolio
As of 12/31/22
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 Municipal Bonds 4.66% 100% In compliance Aa2 A or better In compliance In compliance Federal Agency Issues 72.87% 100% In compliance Aaa/AA AA+/Aaa In compliance In compliance Money Market-CAMP 22.36% 100% In compliance n/a n/a In compliance In compliance LAIF 0.11% 100% In compliance n/a n/a In compliance In compliance 100.00%
Portfolio Value 39,552,554
18

Page 52 ends

INVESTMENTS IN ISSUERS REPRESENTING OVER 5%

OF THE POWER RESERVE PORTFOLIO
December 31, 2022
Market Value % of Total
FHLB 13,282,439 33.58%
FFCB 15,383,709 38.89%
Total Fed Agencies 28,666,148 72.48%
OTHER PORTFOLIO INVESTMENTS 10,886,406 27.52%
Total Investments 39,552,554 * 100.00%
note: * Includes Accrued Interest Receivable
19

Page 53 ends

Power Reserve Portfolio - Total Return Performance
ICE BofA Power
3-5 Index Reserve
2003 Annual 4.214 3.940
2004 Annual 2.740 3.430
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 qu
arter -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.627 -6.886
2nd quarter -2.810 -4.182
3rd quarter -4.590 -5.972
4th quarter 1.68 0.454
Effective Yield Fiscal YTD
Power Reserve effective yield 1.86%
State T
reasurer's LAIF yield 1.72%
2 Year Av
erage Treasury yield 3.82%
** Index has been changed to LT03TRUU 5-7 Year Index beginning 2022 20

Page 54 ends

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 2015 2016 2017 2018 2019 2020 2021 2022 2023 2023 2023 2023 Money Market - Collateralized 11.53 7.43 0.02 4.34 2.58 32.06 0.08 0.00 0.00 0.00 Municipal Bonds 10.83 7.24 7.00 6.92 6.02 3.43 3.93 4.50 4.65 4.66 Federal Agency Issues - Coupon 66.34 77.86 79.82 82.96 85.12 51.22 57.67 75.33 73.43 72.87 L.A.I.F. 0.24 0.24 0.24 0.24 0.26 0.00 32.77 18.69 0.05 0.11 Corporate Bonds - Coupon 11.06 7.23 12.92 5.54 6.02 13.29 5.56 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 0.00 1.48 21.87 22.36 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

Page 55 ends

IV. Miscellaneous Portfolios

Page 56 ends

Fund Coupon Yield Maturity Face Value Cost Per Book Market Value City of Pasadena-Housing Succesor Agency
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $2,291,971.02 $2,291,971.02 $2,291,971.02 Money Mkt Collateralized (East West Bank) 0.750% 0.750% 1/1/2023 $167.23 $167.23 $167.23 LAIF 2.290% 2.290% 1/1/2023 $1.46 $1.46 $1.46
Weighted Average Maturity = 1 day $2,292,139.71 $2,292,139.71 $2,292,139.71 2002 Electric Revenue Reserve Fund
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $80,365.33 $80,365.33 $80,365.33 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/1/2023 $4.30 $4.30 $4.30 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $4,000,000.00 $4,000,000.00 $3,575,180.12 Weighted Average Maturity = 2.73 $4,080,369.63 $4,080,369.63 $3,655,549.75 Annandale Assessment District
Municipal Bonds-Annandale Assessment 6.000% 6.000% 9/2/2040 $917,035.00 $917,035.00 $917,035.00 Weighted Average Maturity = 17.93
Miscellaneous Funds
December 31, 2022
22

Page 57 ends

Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
December 31, 2022
2012A Electric Parity Reserve Fund
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $11,724.82 $11,724.82 $11,724.82 Money Mkt Collateralized (East West Bank) 0.750% 0.750% 1/1/2023 $0.59 $0.59 $0.59 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $690,000.00 $690,000.00 $616,718.57 Weighted Average Maturity = 2.74 $701,725.41 $701,725.41 $628,443.98 2013A Electric Parity Reserve Fund
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $242,538.26 $242,538.26 $242,538.26 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/1/2023 $13.41 $13.41 $13.41 FFCB 3133ELC28 0.730% 0.730% 5/27/2025 $8,000,000.00 $8,000,000.00 $7,314,542.56 Weighted Average Maturity = 2.36 $8,242,551.67 $8,242,551.67 $7,557,094.23 2013A Electric Project
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $1,026.56 $1,026.56 $1,026.56 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/1/2023 $0.07 $0.07 $0.07 LAIF 2.290% 2.290% 1/1/2023 $0.00 $0.00 $0.00
Weighted Average Maturity = 1 day $1,026.63 $1,026.63 $1,026.63 23

Page 58 ends

Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
December 31, 2022
2016A Electric Revenue Refunding Project
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $8,864.62 $8,864.62 $8,864.62 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/0/1900 $0.65 $0.65 $0.65 Weighted Average Maturity = 1 day $8,865.27 $8,865.27 $8,865.27 2016A Electric Revenue Refunding Reserve
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $38,114.07 $38,114.07 $38,114.07 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 10/31/2018 $1.73 $1.73 $1.73 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $2,680,000.00 $2,680,000.00 $2,395,370.68 Weighted Average Maturity = 2.74 $2,718,115.80 $2,718,115.80 $2,433,486.48 Frontier
Money Mkt CAMP 4.500% 4.500% 1/1/2023 $0.00 $0.00 $0.00 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/0/1900 $7.43 $7.43 $7.43 Weighted Average Maturity = 1 day $0.00 $0.00 $0.00
2020A Water Refund Revenue Bonds Project
LAIF 2.290% 2.290% 1/1/2023 $2,116,117.93 $2,116,117.93 $2,116,117.93 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/0/1900 $0.24 $0.24 $0.24 Money Mkt CAMP 4.500% 4.500% 1/1/2023 $3,295.87 $3,295.87 $3,295.87 Weighted Average Maturity = 1 day $2,119,414.04 $2,119,414.04 $2,119,414.04 2021A Water Refund Revenue Bonds Project
LAIF 2.290% 2.290% 1/1/2023 $10,403,361.53 $10,403,361.53 $10,403,361.53 Money Mkt Collateralized (East West Bank) 0.750% 0.100% 1/1/2023 $0.09 $0.09 $0.09 Money Mkt CAMP 4.500% 4.500% 1/1/2023 $1,172.65 $1,172.65 $1,172.65 Weighted Average Maturity = 1 day $10,404,534.27 $10,404,534.27 $10,404,534.27 GRAND TOTAL: $31,485,777.43 $31,485,777.43 $30,017,589.36 24

Page 59 ends

V. Investments Held by Trustees

Page 60 ends

Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2022
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY 2021A Water Revenue Refunding Bonds
James Dickson COI-2021A Account #209092
(213)630-6204 Cash - - - 01/01/23 0.00%
Lena Chan Debt Service-2021A Account #209093
(213) 630-6253 Cash - - - 01/01/23 0.00%
Reserve-2021A Account #209094
DREFUS GOVT CM INST 289 Cusip: X9USDDGCM 802,990.92 802,990.92 802,990.92 01/01/23 4.19% Cash - - - 01/01/23 0.00%
Total 802,990.92 802,990.92 802,990.92
BNY 2020A Water Revenue Refunding Bonds
James Dickson COI-2020 Account #746583
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% Lena Chan DEBT SERVICE-2020 Account #746585
(213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% Total - - -
2020AB POB Bonds
BNY POB COI-2020B Account #220413
James Dickson BlackRock Treasury Turst Dollars 63 Cusip: X9USDBTRD - - - 01/01/23 0.02% (213)630-6204 POB Bond Fund-2020B Account #220414
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 348.53 348.53 348.53 01/01/23 4.16% (213) 630-6253 POB COI-2020A Account #765976
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% POB Bond Fund-2020A Account #765990
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 756.29 756.29 756.29 01/01/23 4.16% Total 1,104.82 1,104.82 1,104.82
2019A Electric Revenue Bonds
BNY Electric COI-2019A Account #106207
James Dickson Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 36,755.45 36,755.45 36,755.45 01/01/23 4.16% (213)630-6204 Electric Bond Fund-2019A Account #113813 - Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 376.30 376.30 376.30 01/01/23 4.16% (213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% Total 37,131.75 37,131.75 37,131.75
25

Page 61 ends

Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2022
$ 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 149.89 149.89 149.89 01/01/23 4.07% Adriana Marshall Costs of Issuance- Series 2018A Account #248882002 (213) 615-6033 Fidelity Govt Protfolio CI Cusp:316175108 - - - 01/01/23 4.07% Interest Fund- Series 2018B Account #248882100
Fidelity Govt Protfolio CI Cusp:316175108 25.55 25.55 25.55 01/01/23 4.07% Principal Fund- Series 2018B Account #248882101
Fidelity Govt Protfolio CI Cusp:316175108 421.12 421.12 421.12 01/01/23 4.07% Costs of Issuance- Series 2018B Account #248882102
Fidelity Govt Obl Fd Cl D 316175108 - - - 01/01/23 2.87% Total 596.56 596.56 596.56
2017A Water Revenue Bonds
BNY Debt Service-2017A Account #948165
James Dickson Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% (213)630-6204 Reserve Fund-2017A Account #948269
Lena Chan Federal Home Loan Banks Cusip: 3130AL3S1 1,050,000.00 1,050,000.00 932,914.50 02/17/26 0.63% (213) 630-6253 DREYFUS CUSIP:X9USSGCM 30,200.55 30,200.55 30,200.55 01/01/23 4.19% Total 1,080,200.55 1,080,200.55 963,115.05
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 188.66 188.66 188.66 01/01/23 4.07% Principal Fund- Series 2016A Account #264433001
Fidelity Govt Protfolio CI Cusp:316175108 26.63 26.63 26.63 01/01/23 4.07% 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/23 4.07% Cost of Issuance- Series 2016A Account #264433003
First American Govt Obl Fd Cl D 31846V401 - - - 01/01/23 2.87% Total 215.48 215.48 215.48
BNY Pasadena 2015A COPS Bond
James Dickson COPS Base Rental-2015A Account #336964
(213)630-6204 Cash Balance - - - 01/01/23 0.00%
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 197,242.04 197,242.04 197,242.04 01/01/23 4.16% (213) 630-6253 Total 197,242.04 197,242.04 197,242.04
26

Page 62 ends

Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2022
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY Pasadena Tax Pension 2015AB Bond
James Dickson Bond Fund-2015A POB Account #479226
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 576.30 576.30 576.30 01/01/23 4.16% Lena Chan Cash Balance - - - 01/01/23 0.00%
(213) 630-6253 Bond Fund-2015A POB Account #479231
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 48.39 48.39 48.39 01/01/23 4.16% Cash Balance - - - 01/01/23 0.00%
Total 624.69 624.69 624.69
` Pasadena Water Revenue 2011A
James Dickson 2011 Water Revenue Debt Service Fund Account #288994 (213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 4.16% Lena Chan Total - - -
(213) 630-6253
BNY Pasadena Water Revenue 2010AB
James Dickson 2010 A Parity Reserve Account #286245
(213)630-6204 DREYFUS CUSIP:X9USSGCM 15,892.52 15,892.52 15,892.52 01/01/23 4.19% Lena Chan Federal Home Loan Bank CUSIP:3130AL3S1 1,350,000.00 1,350,000.00 1,199,461.50 02/17/26 0.63% (213) 630-6253 Cash - - - 01/01/23 0.00%
2010 B Debt Service Account #286247
Cash - - - 01/01/23 4.19%
2010 B Parity Reserve Account #286248
DREYFUS CUSIP:X9USSGCM 5,780.68 5,780.68 5,780.68 01/01/23 4.19% Federal Home Loan Bank CUSIP:3130AL3S1 300,000.00 300,000.00 266,547.00 02/17/26 0.63% Cash - - - 01/01/23 0.00%
2010 A Debt Service Fund Account #286295
Cash - - - 01/01/23 0.00%
Total 1,671,673.20 1,671,673.20 1,487,681.70
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 337,844.45 337,844.45 337,844.45 01/01/23 4.07% Adriana Marshall Cash - - - 01/01/23 0.00%
(213) 615-6071 Principal Fund (S631592)
Fidelity Instl Mm Fds Government I CUSIP:316175108 3.22 3.22 3.22 01/01/23 4.07% Bond Reserve Fund (S631593)
Federal Home Loan Bank Funds CUSIP: 3130ALBD5 15,500,000.00 15,500,000.00 10,048,340.00 02/25/41 2.15% Fidelity Instl Mm Fds Government I CUSIP:316175108 71,760.22 71,760.22 71,760.22 01/01/23 4.07% Cash - - - 01/01/23 0.00%
Total 15,909,607.89 15,909,607.89 10,457,947.89
27

Page 63 ends

Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2022
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
Wells Fargo Bank PPFA (Paseo Colorado Parking Facilities) 2008 Tracy Mason Bond Fund Account #23200100
(213) 253-7536 Allspring Government Money Market Service 79,543.23 79,543.23 79,543.23 01/01/23 3.90% Mataka Mpose Cash - - - 01/01/23 0.00%
Reserve Fund Account #23200101
[email protected] FHLB Cusip: 3130APVC6 2,000,000.00 2,000,000.00 1,780,540.00 12/01/26 1.38% [email protected] Well Fargo Advantage Government Money Market Service - - - 01/01/23 0.01% Cost of Issuance Fund Account #23200103
Well Fargo Advantage Government Money Market Service - - - 01/01/23 0.00% Total 2,079,543.23 2,079,543.23 1,860,083.23
BNY Pasadena 2006,2008,2015 COP Reserves
James Dickson Reserve Account #281635
(213)630-6204 Federal Home Loan Banks CUSIP:3130AKKQ8 4,950,000.00 4,950,000.00 3,918,766.50 12/23/30 1.25% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 62,216.42 62,216.42 62,216.42 01/01/23 4.16% (213) 630-6253 Cash - - - 01/01/23 0.00%
Total 5,012,216.42 5,012,216.42 3,980,982.92
Pasadena 2008AB COPS, 15A Parity Reserve
BNY Reserve Fund #281207
James Dickson Federal Home Loan Banks CUSIP:3130AKKQ8 1,325,000.00 1,325,000.00 1,048,962.75 12/23/30 1.25% (213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 16,653.85 16,653.85 16,653.85 01/01/23 4.16% Lena Chan Cash Balance - - -
(213) 630-6253 Total 1,341,653.85 1,341,653.85 1,065,616.60 BNY Pasadena 2008A COPS
James Dickson Base Rental Fund #281732
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 251,604.66 251,604.66 251,604.66 01/01/23 4.16% Lena Chan Cash Balance - - - 0.00%
(213) 630-6253 Interest Fund #281733
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 4.28 4.28 4.28 01/01/23 4.16% Letter of Credit #281734
Bank of America CUS: S86494570 1.00 1.00 1.00 03/31/23 0.00% Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 0.36 0.36 0.36 01/01/23 4.16% Total 251,610.30 251,610.30 251,610.30
BNY Pasadena Conf Ctr 2006AB
James Dickson Base Rent 2006A #281715
(213)630-6204 AMBAC Insurance Pol#25713BE for $27,139,972.15 Lena Chan DTD 9/7/06 Due 2/1/23 Cus: S86692630 1.00 1.00 1.00 02/01/23 0.00% (213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 345,772.29 345,772.29 345,772.29 01/01/23 4.16% Cash Balance - - - 0.00%
28

Page 64 ends

Schedule of Funds Held by Trustees

CITY OF PASADENA
For Period Ending 12/31/2022
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
Reserve Fund #281722
Federal Home Loan Banks CUSIP:3130AJRH4 10,800,000.00 10,800,000.00 7,269,480.00 06/29/40 2.07% Federal Home Loan Banks CUSIP:3130AKKQ8 270,000.00 270,000.00 213,750.90 12/23/30 1.25% Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 228,166.49 228,166.49 228,166.49 01/01/23 4.16% Rebate Fund #281726
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 3.48 3.48 3.48 01/01/23 4.16% Cash Balance - - - 0.00%
Prepayment #281735
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 01/01/23 0.00% Total 11,643,943.26 11,643,943.26 8,057,174.16
BNY Pasadena Water Revenue 2003
James Dickson Parity Reserve Account #281651
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AL3S1 1,000,000.00 1,000,000.00 888,490.00 02/17/26 0.63% Lena Chan DREYFUS GOVT CM INST 289 CUSIP: X9USDDGCM 17,248.87 17,248.87 17,248.87 01/01/23 4.19% (213) 630-6253 Cash - - - 01/01/23 0.00%
Total 1,017,248.87 1,017,248.87 905,738.87
BNY COPS Parity Reserve Fund(2006A, and 2008ABC COP)
James Dickson Certificate Reserve #281143
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AKKQ8 2,025,000.00 2,025,000.00 1,603,131.75 12/23/30 1.25% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 25,453.56 25,453.56 25,453.56 01/01/23 4.16% (213) 630-6253 Cash - - - 01/01/23 0.00%
(In aggegrate with 2006A, Total Funds 2,050,453.56 2,050,453.56 1,628,585.31 and 2008ABC COP reserve)
SCPPA SCPPA Investments
Atif Haji Datoo SCPPA Project Stabilization Fund
(213) 367-4668 Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN 2,365,698.70 2,365,698.70 2,365,698.70 01/01/23 3.58% Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN 92,756.08 92,756.08 92,756.08 01/01/23 3.58% US Treasury Bill Cusip: 912796ZK8 2,000,000.00 1,987,586.67 1,997,140.00 01/17/23 3.99% Federal Home Loan Bank Discount Note CUSIP: 313384BX6 1,500,000.00 1,486,512.50 1,492,095.00 02/15/23 4.15% Federal Home Loan Bank CUSIP: 3130ATZL4 2,000,000.00 2,000,000.00 2,002,140.00 04/28/23 4.60% Federal Home Loan Bank CUSIP: 3130ANZG8 1,000,000.00 999,800.00 933,650.00 09/16/24 0.15% 12/09/22 3.00%
- - - 0.00%
Total 8,958,454.78 8,932,353.95 8,883,479.78
TOTAL FUND BALANCE 52,056,512.17$ 52,030,411.34$ 40,581,922.07$ 29

Page 65 ends

VI. PARS Section 115 Trust

Page 66 ends

City of Pasadena
PARS Section 115 Trust
For the Month Ended December 31, 2022
Pension Account 6746056200
Market Value Book Value
Beginning Balance 11,777,756.42 12,636,102.66
Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 109,797.85 109,797.85
Interest 1,761.44 1,761.44
Other Income 7.81 7.81
Change in Accrued Income 1,833.00 1,833.00
Total Investment Income 113,400.10 113,400.10
Net Change in Unrealized Gain/Loss (424,088.73) -
Realized Gain/Loss 118,784.23 118,784.23
Total Market Value Adjustment (305,304.50) 118,784.23
Trust Fees (2,559.25) (2,559.25)
PARS Fee (Net of Depository Earnings) (2,313.26) (2,313.26) Unreconciled Difference - -
Total (4,872.51) (4,872.51)
Ending Balance 11,580,979.51 12,863,414.48
1 Year Inception To Date
Investment Return (Inception-To-Date as of 12/31/2022) -13.45% 2.51% Benchmark Return (PARS Moderately Conservative) -12.35% 2.85% Asset Allocation
Market Value Percentage
Cash and Equivalents 626,044.07 5.41%
Equity 3,242,741.43 28.00%
Fixed Income 7,708,599.54 66.56%
Accrued Income 3,594.47 0.03%
Total 11,580,979.51 100.00%
Account Manager:

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

5.41%
Equity

28.00%
Fixed Income

66.56%
Accrued Income

0.03%
30

Page 67 ends

City of Pasadena
PARS Section 115 Trust
For the Month Ended December 31, 2022
Post Employments Benefits Trust 6746056201
Market Value Book Value
Beginning Balance 2,231,180.08 2,395,252.33
Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 19,497.63 19,497.63
Interest 309.99 309.99
Other Income 0.11 0.11
Change in Accrued Income 41.84 41.84
Total Investment Income 19,849.57 19,849.57
Net Change in Unrealized Gain/Loss, Fee Receipts & Deliveries Net (81,389.57) - Realized Gain/Loss 23,262.61 23,262.61
Total Market Value Adjustment (58,126.96) 23,262.61
Trust Fees (486.45) (486.45)
PARS Fee (Net of Depository Earnings) (438.23) (438.23) Unreconciled Difference - -
Total (924.68) (924.68)
Ending Balance 2,191,978.01 2,437,439.83
1 Year Inception To Date
Investment Return (Inception-To-Date as of 12/31/2022) -13.48% 2.52% Benchmark Return (PARS Moderately Conservative) -12.35% 2.82% Asset Allocation
Market Value Percentage
Cash and Equivalents 107,786.28 4.92%
Equity 614,631.63 28.04%
Fixed Income 1,469,207.75 67.03%
Accrued Income 352.35 0.02%
Total 2,191,978.01 100.00%
Account Manager:

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

4.92%
Equity

28.04%
Fixed Income

67.03%
Accrued Income

0.02%
31

Page 68 ends

INFORMATION ONLY
ITEM 5

CONSUMER PRICE INDEX (CPI) ON CURRENT

CONTRACTS

Page 69 ends

Page 70 ends

AFFECT OF CPI ON CURRENT CONTRACTS
March 13, 2023

Page 2 of 3 ends

As a result, departments in collaboration with the Purchasing Division continue to review renewals and option year extensions closely.

BUDGET
The City monitors inflation, as it can directly impact the cost of providing services, which can affect decision-making associated with the Operating Budget. During the annual budget process, the City adjusts the General Fee Schedule and the Schedule of Taxes, Fees, and Charges by an amount equal to the change in the Consumer Price Index (CPI) for the Los Angeles-Long Beach-Anaheim metropolitan area for the preceding 12- month period ending March 1st (pursuant to Pasadena Municipal Code). Additionally, the City uses the aforementioned change in CPI to also adjust contractual line items within the budget category for Services and Supplies.

CONCLUSION
Currently, the City has 846 active contracts, of which 132 contracts totaling $81,225,815 in Fiscal Year 2023 include price adjustment clauses. Based on the review of the price adjustment clauses, the estimated annual increases range between 3% and 9.6%, which is an additional $9,893,198 for these contracts. This amount is based upon normal procurement volumes but could fluctuate up or down depending actual procurements or services provided.

As costs are measured during the procurement process through competitive bids and competitive selections, three of the largest categories of procurements are trending up.

The U.S. Bureau of Labor Statistics reported in November 2022 that gasoline prices averaged $5.03 a gallon in the Los Angeles-Long Beach-Anaheim area, an increase of $2.06 higher than November 2020. While the City procures fuel in bulk at lower prices and is exempt from certain taxes, the proportional increase is similar. The State of California, Department of General Services Construction Costs Index (CCI) reported construction costs have increased 9.3% over the past 12 months. Similarly, the Raw Material Price Index continues to increase, reflecting an 18% increase compared to a year ago. Raw materials costs affect the City's bid prices, which include but are not limited to the purchase of vehicles, cabling, vehicle parts, office supplies, and electrical equipment costs.

Similarly, the Pasadena Water and Power department (PWP) has been experiencing increased energy costs and has had to procure more expensive energy from the market as a replacement. The U.S. Bureau of Labor Statistics reported that the amount Los Angeles area households paid for electricity in December 2022 was 57.6% more than the nationwide average. Last December, electricity costs were 69.0% higher in the Los Angeles area compared to the nation. In the past five years, prices paid by Los Angeles area consumers for electricity exceeded the U.S. average by 36.3% or more in the month of December. Since PWP is required to make energy purchases to meet customer demand, PWP is assessing whether to increase future positions with forward energy contracts if doing so would lower the cost of energy purchases in the future.

Page 71 ends

AFFECT OF CPI ON CURRENT CONTRACTS
March 13, 2023

Page 3 of 3 ends

CPI, while significant, is not the only factor that plays into costs. The City will continue to evaluate contract renewals and option year extensions on a case-by-case basis to determine if contracts will be renewed under existing contract terms, or if it is in the City's best interest to process a new solicitation.

Page 72 ends

Finance CommitteeMarch 13, 2023

Finance Committee
March 13, 2023