Loading...
HomeMy WebLinkAboutResolution 2023-078 N.C.S. 06/05/2023 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Resolution No. 2023-078 N.C.S. of the City of Petaluma, California REGARDING RECEIPT AND FILING OF THE CITY TREASURER'S QUARTERLY REPORT DATED DECEMBER 31, 2022 WHEREAS, the City of Petaluma Investment policy approved by the City Council pursuant to Resolution no. 2022-103 N.C.S. adopted June 6, 2022 requires the City Treasurer to provide a quarterly investment report to the City Council for compliance with the adopted City Investment Policy; and WHEREAS, the City Treasurer has provided for City Council review a quarterly Treasurer's report dated December 31, 2022; and WHEREAS, this action is exempt from the requirements of the California Environmental Quality Act (CEQA) in accordance with CEQA Guidelines Section 15378, as approving the City's investment policy does not meet CEQA's definition of a"project,"because the action does not have the potential for resulting in either a direct physical change in the environment or a reasonably foreseeable indirect physical change in the environment, it is a fiscal activity which does not involve commitment to any specific project,and because the action constitutes organizational or administrative activities of governments that will not result in direct or indirect physical changes in the environment. NOW, THEREFORE,BE IT RESOLVED, by the City Council of the City of Petaluma as follows: 1. Declares the above recitals to be true and correct and are incorporated into this resolution as findings of the City Council. 2. The City Council has received and approves the City Treasurer's Quarterly Report dated December 31, 2022, attached hereto as Exhibit A. 3. Finds that this action is exempt from the requirements of the California Environmental Quality Act (CEQA) in accordance with CEQA Guidelines Section 15378,as approving the City's investment policy does not meet CEQA's definition of a"project,"because the action does not have the potential for resulting in either a direct physical change in the environment or a reasonably foreseeable indirect physical change in the environment, it is a fiscal activity which does not involve commitment to any specific project, and because the action constitutes organizational or administrative activities of governments that will not result in direct or indirect physical changes in the environment. 4. The City Council directs the City Clerk to file the quarterly Treasurer's Report dated December 31, 2022, in the official City records. Resolution No. 2023-078 N.C.S. Page 1 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Under the power and authority conferred upon this Council by the Charter of said City. REFERENCE: I hereby certify the foregoing Resolution was introduced and adopted by the Approved as to Council of the City of Petaluma at a Regular meeting on the 5'day of June 2023, DocusignedfWnl: by the following vote: ity Attorney AYES: Mayor McDonnell,Vice Mayor Cader Thompson,Councilmembers Barnacle, Healy,Nau,Pocekay,Shribbs NOES: None ABSENT: None ABSTAIN: None DocuSigned by: DocuSigned by: ATTEST: City C erk Mayor Resolution No. 2023-078 N.C.S. Page 2 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Exhibit A City of Petaluma Quarterly Investment Report October 1 to December 31 , 2022 u .� g58 This report is presented in accordance with the City's investment policy and the California Government Code. The policy and Government Code requires the Treasurer to certify that sufficient cash flow is available for the next six months to meet the expected demand or provide an explanation as to why sufficient cash may not be available. The attached report outlines the current investments, weighted average and yields of pooled investments. The month end account statement of assets managed by Public Financial Management, LLC (PFM),the Local Agency Investment Funds (LAIF)quarterly statement, and the City's performance summary of portfolio investments as compared to applicable benchmarks are included. The report also includes the Treasurer's certification of adequate cash flow. We respectfully submit the quarterly investment report for the quarter ending December 31, 2022. DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 CITY OF PETALUMA, CALIFORNIA CITY TREASURER'S QUARTERLY REPORT For the quarter ending December 31, 2022 Cash activity, for the fiscal year: Cash and Investments, Beginning of the quarter, 10/1/22 $ 197,264,343 Cash Receipts 68,104,666 Cash Disbursements (62,374,841) Cash and Investments,End of the Onarter, 12/31/22 $ 202,994,168 Cash and Investment Portfolio at December 31, 2022 Percent Fair Market Par Value of Value* (Cost) Portfolio Investments Managed by City Treasurer: Local Agency Investment Funds (LAIF) 68,542,469 70,207,140 34.59% CAMP Pool (CA Asset Management Prog) 46,238,680 46,238,680 22.78% PFM Investments Securities ** 40,930,480 42,684,507 21.03% Checking Accounts 23,657,406 23,657,406 11.65% Subtotal 179,369,036 182,787,733 90.05% Investments Managed by Fiscal Agents: Trustee Money Market Accounts 20,206,435 20,206,435 9.95% Subtotal 20,206,435 20,206,435 9.95% Total Cash and Investments 199,575,471 202,994,168 100.00% I certify that this report contains the total amounts of cash and investments at December 31, 2022 The investments are in conformity with the Investment Policy. A copy of the Investment Policy is available for review in the Finance Department. The City Treasurer's cash management program provides sufficient liquidity to meet expenditure requirements for the next six months. We respectfully submit the quarterly investment report for the quarter ending December 31, 2022 Corey Garbe4tlil, Finance Director Dated *Fair market values are furnished by the State of California, Local Agency Investment Fund and California Asset Management Program. ** See detail attached DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 CITY OF PETALUMA,CALIFORNIA CITI FREASI!RER'S QUARTERLY REPORT For the quarter ending December31,2022 Ileginnilig End of ImcNimcnk/Fin;inci:illnstitule ofOuarler Incren9e*A Decrease Quarter Investureuts Alauagetl br C10,Treasurer: LAW 69,605,444.02 236,841.74 69,842,285,76 LAW accrued interest 236,841.74 364,853.77 (236,841.74) 364,853.77 Sub-Total LAW 69,842,285.76 601,695.51 (236,841.74) 70,207,139.53 CAMP Pool-Treasurer's Investment Money Markel 48,577,182.17 4,135,490.79 (6,473,992.69) 46,238,680.27 Sub-Total CAMP Pool Managed Account 48,577,182.17 4,135,490,79 (6,473,992.69) 46,238,680.27 Federal Agency Bonds/Discount Notes 9,493,876.79 529,474,12 (1,427,350.28) 8,596,000.63 Fed Agency accnied interest 16,481.94 37,036.52 (32,092,67) 21,425.79 US Treasury Bonds/Notes 30,279,987.35 5,272,024.41 (1,573,831.06) 33,978,180,70 US Treasury accrued interest 62.782.69 90,933.35 (64,816.16) 88,899.88 Sub-Total PFNI Securities Managed Account wx 39,853,128.77 5,929,468.40 (3,098,090.17) 42,684,507.00 Subtotal 158,272,596.70 10,666,654.70 (9,808,924.60) 159,130,326.80 Checking Accounts: Exchange-General Operating 16,287,967.34 43,803,553.87 (39.619,320.41) 20,472,200.90 Exchange-Payroll 2,552,959,72 8,400,000.00 (7,848,340.33) 3,104,619.39 Exchange-Savings Thomas Lee Charity Trust 1,277.38 - (1,277.38) Policc"rnist 80,539.08 46.81 80,585.89 Sub-Total Checking Accounts 18,922,743.52 52,203,600.68 (47,468,938.12) 23,657,406.08 Total Cash and Investments Managed by the City Treasurer 177,195,340.22 62,870,255.38 (57,277,862.72) 182,787,732.88 lavestatents Alauaged by Trustees nccal Agents: Bank of New York 20,060,962.18 1,932,364.03 (1,795,518.76) 20,197,907.45 US Bank First American Treas 8,040.77 3,302,046.75 (3,301,459.63) 8,627.89 Sub-Total Trustees Money Market Account 20,069,002.95 5,234,410.78 (5,0%,978.39) 20,206,435.34 Total Cash and Investments Managed by Fiscal Agents 20,069,002.95 5,234,410.78 (5,096,978.39) 20,206,435.34 TOTAI.CASH AND INVESTMENTS 197,264,343.17 68,104,666.16 (62,374,841.11) 202,994,168.22 ••See detail aunched Accrued interest (475,179A4) General Ledger 202,518,988.78 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 City of Petaluma, California Cash/Investment by Type - December 31, 2022 Total Cash/Investments $ 20299949168 Cash 23,657,406 11.65% LAW 70,207,140 34.59% CA Pool Asset Mgmt Prog 46,238,680 22.78% CAMP Investments 42,684,507 Fiscal Agents 21.03% 20,206,435 9.95% DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 CITY OF PETALUMA,CALIFORNIA CITY TREASURER'S QUARTERLY REPORT For the quarter ending December 31,2022 Cost vs. Fair Market Value Unrealized Cost FV Gain/(Loss) US Treasury Bond/Note 33,978,180.70 32,570,612.17 (1,407,568.53) Federal Agency Bond/Discount Note 8,596,000.63 8,359,868.32 (236,132.31) Corporate Note - - - Certificate of Deposit - - - Sub-Total PFM Treasurer's Invest.Securities 42,574,181.33 40,930,480.49 (1,643,700.84) CAMP Pool Money Market Fund 46,238,680.27 46,238,680.27 - Sub-Total CAMP Treasurer's Investments 88,812,861.60 87,169,160.76 (1,643,700.84) Accrued Interest 110,325.67 CAMP Total Investment Managed Securities Held** $7,279,486.43 LAIF 69,842,285.76 68,542,469.00 (1,299,816.76) LAIF amortized cost rate 0,98138925800 ** See detail attached DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 ('ity of Petaluma Performance Summaries Returns as of BAML 1-3 Year Treasury December 31, 2022 City of Petaluma Index Past Quarter 0.67% 0.74% Past 6 Months -0.70% -0.84% Past Year -3.35% -3.65% Past 3 Years -0.23% -0.41% Past 5 Years 0.89% 0 77% Yield to Maturity 1.45% - Notes: I. ICE Bank of America Merrill Lynch(BAML)Indices provided by Bloomberg Financial Markets, 2. CAMP Cash Reserve Pool holdings excluded from performance and yield calculations. 3. Performance numbers for periods greater than one year are presented on an annualized basis. 4. Yield for the City is calculated as the average of the quarter's three-month end Yield to Maturity at Cost. DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 413/23,5:41 PM Untitled Page soup. MALIA M. COHEN California State Controller LOCAL AGENCY INVESTMENT FUND REMITTANCE ADVICE Agency Name PETALUMA Account Number 98-49-650 As of 01/13/2023, your Local Agency Investment Fund account has been directly credited with the interest earned on your deposits for the quarter ending 12/31/2022. Earnings Ratio .00005680946709337 Interest Rate 2.07% Dollar Day Total $ 6,422,411,347.30 Quarter End Principal Balance $ 69,842,285.76 Quarterly Interest Earned $ 364,853.77 littps://Iaif.sco.ca.gov/Result.aspx 1/1 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 oa���NvrsT,y�Fyl State of California Pooled Money Investment Account uQ, n a o c Market Valuation 12/31/2022 Carrying Cost Plus Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury: Bills $ 35,572,298,376.73 $ 35,896,965,984.48 $ 35,813,625,000.00 NA Notes $ 96,336,543,012.97 $ 96,327,058,254.86 $ 93,171,299,000.00 $ 287,620,426.50 Federal Agency: SBA $ 338,889,007.89 $ 338,889,007.89 $ 338,773 080.09 $ 1,004,954.08 MBS-REMICs $ 3,465,697.68 $ 3,465,697.68 $ 3,425,155.69 $ 15,470.20 Debentures $ 9,096,582,571.99 $ 9,096,520,766.45 $ 8,886,499,200.00 $ 26,924,215.25 Debentures FIR $ - $ - $ - $ - Debentures CL $ 2,900,000,000.00 $ 2,900,000,000.00 $ 2,833,516,000.00 $ 26,791,810.50 Discount Notes $ 25,325,736,041.68 $ 25,562,614,902.86 $ 25,510,373,000.00 NA Su ranational Debentures $ 2,426,390,203.78 $ 2,425,759,648.22 $ 2,338,151,100.00 $ 7,37( ,511. Cl Su ranational Debentures FIR $ - $ $ - $ CDs and YCDs FIR $ - $ - $ - $ Bank Notes $ 100,000,000.00 $ 100,000,000.00 $ 99,990,832.29 $ 1,541,666.67 CDs and YCDs $ 12,400,000,000.00 $ 12,400,000,000.00 $ 12,382,893,375.51 $ 124,083,166.66 Commercial Paper $ 7,895,772,944.44 $ 7,975,413,013.94 $ 7,970,181,986.08 NA Corporate: Bonds FIR $ - $ - $ - $ - Bonds $ 530,321,150.56 $ 530,164,414.45 $ 503,140,960.00 $ 4,279,027.65 Repurchase Agreements $ - $ - $ - $ Reverse Repurchase $ - $ - $ - $ - Time Deposits $ 5,144,000,000.00 $ 5,144,000,000.00 $ 5,144,000,000.00 NA PMIA&GF Loans $ 376,811,000.00 $ 376,811,000.00 $ 376,811,000.00 NA TOTAL $ 198,446,810,007.72 $ 199,077,662,690.83 $ 195,372,679,689.66 $ 479,637,279.01 Fair Value Including Accrued Interest $ 195,852,316,968.67 Repurchase Agreements,Time Deposits, PMIA&General Fund loans,and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost(0.981389258). As an example: if an agency has an account balance of$20,000,000.00,then the agency would report its participation in the LAIF valued at$19.627,785.16 or$20,000,000.00 x 0.981389258. DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Managed Account Detail of Securities Held For the Month Ending December 31,2022 City of Petaluma - TREASURER'S INVESTMENTS - 531-00 - (12511505) Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value U.S.Treasury :. US TREASURY NOTES 91282CAF8 425.000.00 AA+ Aaa 02/17/21 02/17/21 424,684.57 0.15 200.66 424,921.58 41376.88 DTD 08/15/2020 0.125%08/15/2023 US TREASURY NOTES 91282CDA6 1,250,000.00 AA+ Aaa 10/01/21 10/06/21 1,249.316.41 0.28 798.42 1,249,743.18 1,208,984.38 DTD 09/30/2021 0.250%09/30/2023 US TREASURY N/B NOTES 91282CDDO 1,850,000.00 AA+ Aaa 11/01/21 11/03/21 1,844,652.34 0.52 1,188.19 1,847,771.20 1,783,515.63 DTD 10/31/2021 0.375%10/31/2023 US TREASURY NOTES 91282CAW1 525,000.00 AA+ Aaa 12/01/20 12/03/20 525,492.19 0.22 170.41 525.145.33 504.820.31 DTD 11/15/2020 0.250%11/15/2023 US TREASURY NIB NOTES 91282CDMO 750,000.00 AA+ Aaa 12/03/21 12/03/21 748,066.41 0.63 329.67 749,114.33 721,523.40 DTD 11/30/2021 0.5000/a 11/30/2023 US TREASURY NOTES 91282CBA8 503,000.00 AA+ Aaa 04/29/21 04/30/21 501,035.16 0.27 29.36 502,287.00 481.779.69 DTD 12/15/2020 0.125%12/15/2023 US TREASURY NOTES 91282CBA8 1,100,000.00 AA+ Aaa 01/06/21 01/07/21 1,097,378,91 0.21 64.22 1,099,149.12 1.053,593.75 DTD 12/15/2020 0.125%12/15/2023 US TREASURY NOTES 91282CBEO 2,000,000.00 AA+ Aaa 02/02/21 02/03/21 1,996,796.88 0.18 1,1S4.89 1,998,871.76 1,906,875.00 DTD 01/15/20210.125%01/15/2024 US TREASURY NOTES 91282CBM2 600,000.00 AA+ Aaa 03/05/21 03/05/21 596,742.19 0.31 283.29 598,759.79 570.000.00 DTD 02/15/2021 0.125%02/15/2024 US TREASURY NOTES 912828)(70 1,025.000.00 AA+ Aaa 04/01/21 04/05/21 1,075,889.65 0.37 3,511.05 1,047.017.38 988,964.90 DTD 05/01/2017 2.000%04/30/2024 US TREASURY NIB NOTES 91282CCG4 1,100,000.00 AA+ Aaa 07/01/21 07/07/21 1,092,867.19 0.47 128.43 1,096,473.44 1,032,453.18 DTD 06/15/20210.250%06/15/2024 US TREASURY NIB NOTES 91282CCL3 600,000.00 AA+ Aaa 08/04/21 08/06/21 600.703.13 0.33 1,039.40 600,367.28 561,937.50 DTD 07/15/20210.375%07/15/2024 US TREASURY NIB NOTES 91282CCL3 925,000.00 AA+ Aaa 08/09/21 08/10/21 924,458.01 0.40 1,602.41 924,715.84 966,320.31 DTD 07/15/2021 0.375%07/15/2024 US TREASURY NOTES 912828D56 1,000.000.00 AA+ Aaa 10/05/22 10/06/22 966,914.06 4.24 8,970.79 971,153.35 964,843.80 DTD 08/15/2014 2.375%08/15/2024 PFM Asset Management LLC Account 531-00 Page 5 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Managed Account Detail of Securities Held For the Month Ending December 31, 2O22 City of Petaluma - TREASURER`S INVESTMENTS - 531-00 - (12511505) Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value U.S.Treasury Bond/Note US TREASURY N/B NOTES 91282CCT6 1.500.000.00 AA+ Aaa 091OV21 09/03/21 1,498,359.38 0.41 2.124.66 1,499,098.19 1,401.328.20 DTD 08/15/2021 0.375%08/15/2024 US TREASURY NIB NOTES 91282CCX7 350,000.00 AA+ Aaa 09/23/21 09/24/21 348,578.13 0.51 391.57 349.185.07 326,101.58 DTD 09/15/2021 0.375%09/15/2024 US TREASURY N/B NOTES 91282CCX7 1,000,000.00 AA+ Aaa 10/01/21 10/06/21 995,937.50 0.51 1.118.79 997,645.64 931,718.80 DTD 09/15/2021 0.375%09/15/2024 US TREASURY NOTES 912828YM6 1,000.000.00 AA+ Aaa 05/04/21 05/06/21 1,036,523.44 0.44 2,569.06 1,019,179.11 947,187.50 DTD 10/31/2019 1.500%10/31/2024 US TREASURY N/B NOTES 91282CDH1 925,000.00 AA+ Aaa 12JO1121 12/03/21 921.639.65 0.88 900.73 922.867.83 863,429.69 DTD 11/15/2021 0.750%11/15/2024 US TREASURY NOTES 912828YV6 1,500,000.00 AA+ Aaa 06/02/21 06/07/21 1.555,664.06 0.42 1.978,02 1,530,588.98 1,419,140.70 DTD 11/30/2019 1.500%11/30/2024 US TREASURY N/B NOTES 91282CDN8 850,000.00 AA+ Aaa 01/03/22 01/05/22 849,169.92 1.03 396.98 849,448.67 795.281.25 DTD 12/15/2021 1.000%12/15/2024 US TREASURY N/B NOTES 91282CDS7 1.000.000.00 AA+ Aaa 02/01/22 02/03/22 992.343.75 1.39 5,197.01 994,703.89 935.468.80 DTD O1/15/2022 1.125%O1/15/202S US TREASURY N/B NOTES 91282CDZ1 575,000.00 AA+ Aaa 03/03/22 03/04/22 572,169.92 1.67 3.257.81 572.964.65 541,039.06 DTD 02/15/202-2 1.500%02/15/2025 US TREASURY N/B NOTES 91282CDZ1 1.000,000.00 AA+ Aaa 02/10/22 02/15/22 991,757.81 1.78 5,665.76 994,164.29 940,937.50 DTD 02/1512022 1.500%02/15/2025 US TREASURY NOTES 912828ZL7 1,000.000.00 AA+ Aaa 04/01/22 04/05/22 933,398.44 2.65 642.26 949,499.26 912,500.00 DTD 04/30/2020 0.375%04/30/2025 US TREASURY NOTES 912828ZL7 1,500.000.00 AA+ Aaa 05/02/22 05/04/22 1,390,781.25 2.94 963.40 1,414,985.41 1.368,750.00 DTD 04130,12020 0.375%04/30/2025 US TREASURY N/B NOTES 91282CEU1 1,000,000.00 AA+ Aaa 06/09/22 06/15/22 996.445.31 3.00 1.342.72 997,093.98 966.093.80 DTD 06/15/2022 2.875%06/15/2025 US TREASURY NOTES 912828ZW3 2,000,000.00 AA+ Aaa 06/O1/22 06/03/22 1,846,250.00 2.88 13.81 1,875,274.93 1,811,250.00 DTD 06/30/2020 0.250%06/30/2025 PFM Asset Management LLC Account 531-00 Page 6 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Managed Account Detail of Securities Held For the Month Ending December 31,2022 City of Petaluma - TREASURER'S INVESTMENTS - 531-00 - (12511505) Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value U.S.Treasury Bond/ Note I US TREASURY N/13 NOTES 91282CEY3 1.100,000.00 AA+ Aaa 08/02/22 08/03/22 1,099,054.69 3.03 15244.57 1,099.187.23 1,065,281.25 DTD 07/15/2022 3.000%07/15/2025 US TREASURY N/B NOTES 91282CFK2 575,000.00 AA+ Aaa 10/06/22 10/07/22 562,848.63 4.27 6.004.14 563.821.64 563,320.31 DTD 09/15/2022 3.500%09/15/2025 US TREASURY N/B NOTES 91282CFW6 1,500,000.00 AA+ Aaa 12/16/22 12/16/22 1,519,746.09 4.02 8,763.81 1,519,449.44 1,509,375.00 DTD 11/15/2022 4.500%11/15/2025 US TREASURY N/B NOTES 91282CFW6 2.200.000.00 AA+ Aaa 12/06/22 12/08/22 2,222.515.63 4.13 12,853.59 2,222,012.02 2,213.750.00 DTD 1'1/152022 4.500%11/15/2025 Security Type Sub-Total 34,228,000.00 33,978,180.70 1.S8 88,899.88 34,006,660.81 32,570,612.17 Federal Agency Commercial Mortgage-Backed Security FHMS K038 Al 3137BBBC3 432.33 AA+ Aaa 11/20/18 11/26/18 426.18 2.92 0.94 431.38 432.33 DTD 06/01/2014 2.604%10/01/2023 FHMS K724 A2 3137BTU25 115.793.86 AA+ Aaa 03/03/20 03/06/20 122,130.85 1.52 295.47 117,236.89 114,340.24 DTD 01/01/2017 3.062%11/01/2023 FHMS K724 A2 3137STIJ25 115,793.86 AA+ Aaa 01/28/21 02/02/21 123,618.99 0.58 295.47 118.167.95 114,340.23 DTD 01/01/2017 3.062%11/01/2023 FHMS K039 A2 313713DCW4 325.000.00 AA+ Aaa 08/31/22 09/06/22 322.092.77 3.81 894.56 322,605.04 317.712.64 DTD 09/01/2014 3.303%07/01/2024 FHLMC MULTIFAMILY STRUCTURED POOL 3137FBTA4 365,477.24 AA+ Aaa 05/25/22 05/31/22 365.962.64 3.00 933.19 365,831.04 356.896.62 DTD 11/01/2017 3.064%08/01/2024 FHMS K041 A2 31378FE98 165.000.00 AA+ Aaa IV08/22 1V14/22 158,954.30 5.22 436.01 158.9S4.30 160,250.46 DTD 12/16/2014 3.171%10/01/2024 FHMS K130 Al 3137FUZN7 8,362.82 AA+ Aaa 07/23/20 07/30/20 8,362.65 0.53 3.67 8,362.74 8,362.82 DTD 07/01/2020 0.526%01/01/2025 FHMS K045 A2 3137BHX]1 182.506.43 AA+ Aaa 10/07/22 10/13/22 176.034.76 4.71 459.76 176,673.15 176.640.10 DTD 05/01/2015 3.023%01/01/2025 FHMS K045 A2 3137BHX01 319,386.27 AA+ Aaa 07/13/22 07/18/22 315.543.65 3.54 804.59 316,258.26 309,120.17 DTD 05/01/2015 3.023%01/01/2025 PFM Asset Management LLC Account 531-00 Page 7 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 - For the Month Ending December 31, 2022 Managed Account Detail of Securities Held 9 City of Petaluma -TREASURER'S INVESTMENTS - 531-00 - (12511505) Sewrity Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value Federal Agency Commercial Mortgage-Backed Security FHMS K046 A2 3137BJP64 350,000.00 AA+ Aaa 08/03/22 08/08/22 347,388.67 3.51 934.79 347,388.67 338A14.30 DTD 06/17/2015 3.205%0310112025 FHMS K047 A2 3137BKRJ1 375,000.00 AA+ Aaa 05/19/22 05/24/22 377,402.34 3.10 1,040.31 377,402.34 363,067.64 DTD 07/30/2015 3.329%05/01/2025 FHMS K132 Al 3137F72U8 21.598.16 AA+ Aaa 11/18/20 11/30/20 21,598.06 0.52 9.29 21,598.11 20.679.42 DTD 11/01/2020 0.516%06/01/2025 FHMS K048 A2 3137BLAC2 200,000.00 AA+ Aaa 10/05/22 10/11/22 193.882.81 4.52 547.33 193,882.81 193,420.64 DTD 09/24/2015 3.284%06/01/2025 FHMS K053 A2 31376N6G4 375,000.00 AA+ Aaa 08/04/22 08/09/22 370,678.71 3.36 935.94 370,678.71 358,520.63 DTD 03/29/2016 2.995%12/01/2025 FNA 2016-M3 A2 3136ARTES 303.824.22 AA+ Aaa 08/31/22 09/06/22 293.534.55 3.76 684.11 293,534.55 287,707.52 DTD 03/31/2016 2.702%02/01/2026 Security Type Sub-Total 3,223,175.18 3,197,611.93 3.45 8,275.43 3,189,005.94 3,119,905.76 ObligationFederal Agency Collateralized Mortgage FHLMC MULTIFAMILY STRUCTURED P 3137BEVH4 325,000.00 AA- Aaa 08/31/22 09/06/22 321.470.70 3.81 877.77 322.039.47 316,424.62 DTD 11/01/2014 3.241%09/01/2024 Security Type Sub-Total 325,000.00 321,470.70 3.81 877.77 322,039.47 316,424.62 Federal Agency Bond/ Note FANNIE MAE NOTES 3135G05G4 225,000.00 AA+ Aaa 10/07/20 10!08/20 224.919.00 0.26 267.19 224,984.69 219,773.25 DTD 07/10/2020 0.250%07/10/2023 FANNIE MAE NOTES 3135G05G4 270,000.00 AA- Aaa 10/02/20 10/06/20 270,140.40 0.23 320.62 270,026.49 263,727.90 DTD 07/10/2020 0.250%07/10/2023 FANNIE MAE NOTES(CALLABLE) 3135GOSRO 425.000.60 AA+ Aaa 08/11/20 08/12/20 424,235.00 0.36 49938 424,845.32 413,449.78 DTD 08/10/2020 0.300%08/10/2023 FREDDIE MAC NOTES 3137EAEV7 490,000.00 AA+ Aaa 08/19/20 08/21/20 489.500.20 0.28 432.15 489,893.03 475,829.69 DTD 08/21/2020 0.250%08/24/2023 PFM Asset Management LLC Account 531-00 Page 8 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 Managed Account Detail of Securities Held For the Month Ending December 31, 2022 City of Petaluma -TREASURER'S INVESTMENTS - 531-00 - (12511505) Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value Federal Agency Bond/ Note I FREDDIE MAC NOTES 3137EAEW5 200.000.00 AA+ Aaa 10/07/20 10/08/20 199.936.00 0.26 156.94 199.984.98 193,858.40 DTD 09/04/2020 0.250%09/08/2023 FREDDIE MAC NOTES 3137EAEW5 215.000.00 AA+ Aaa 09/02/20 09/04/20 215.039.26 0.24 168.71 215.008.93 208,397.78 DTD 09/04/2020 0.250%09/08/2023 FREDDIE MAC NOTES 3137EAEW5 335.000.00 AA+ Aaa 09/02/20 09/04/20 334,889.45 0.26 262.88 334,974.85 324,712.82 DTD 09/04/2020 0.250%09/08/2023 FREDDIE MAC NOTES 3137EAEWS 500,000.00 AA+ Aaa 10/02/20 10/06/20 500,330.00 0.23 392.36 500.077.32 484,646.00 DTD 09/04/2020 0.250%09/0812023 FANNIE MAE NOTES 3135G06H1 485.000.00 AA+ Aaa 11/23/20 11/25/20 484.447.10 0.29 114.51 484,833.68 465.204.73 DTD 11/25/2020 0.250%11/27/2023 FREDDIE MAC NOTES 3137EAFA2 450,000.00 AA+ Aaa 12/02/20 12/04/20 449.554.50 0.28 84.38 449,862.89 431,245.80 DTD 12/04/2020 0.250%12/04/2023 FFCS NOTES 3133EMRZ7 340.000.00 AA+ Aaa 02/22/21 02/26/21 339,877.60 0.26 295.14 339.952.94 322,850.06 DTD 02/26/2021 0.2-50%02/26/2024 FEDERAL HOME LOAN BANK NOTES 3130AP081 600,000.00 AA+ Aaa 08/05/22 08/0922 569.049.49 3.40 883.33 574,509.13 560.940.00 (CALLABLE) DTD 11/08/2021 1.0000/a 1110812024 FREDDIE MAC NOTES(CALLABLE) 3134GXM35 575,000.00 AA+ Aaa 07/29/22 08/05/22 575,000.00 3.60 6,395.00 57S,000.00 558.901.73 DTD 08/05/2022 3.600%08/01/2025 Security Type Sub-Total 5,110,000.00 5,076,918.00 1.01 12,272.59 5,083,954.25 4,923,537.94 Managed Account Sub-Total 42,886,175.18 42,574,181.33 1.67 110,325.67 42,601,660.47 40,930,480.49 3oint Powers Authority CAMP Pool 46,238,680.27 AAAm NR 46.238.680.27 0.00 46,238,680.27 46,238,680.27 Liquid Sub-Total 46,238,680.27 46,238,680.27 0.00 46,238,680.27 46,238,680.27 PFM Asset Management LLC Account 531-00 Pace 9 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 C111 111 III , Managed Account Detail of Securities Held For the Month Ending December 31, 2022 City of Petaluma -TREASURER'S INVESTMENTS - 531-00 - (12511505) Securities Sub-Total $89,124,855.45 $88,812,861.60 1.67% $110,325.67 S88,840,340.74 $87,169,160.76 Accrued Interest s110,325.67 Total Investments 587,279,486.43 PFM Asset Management LLC AccoLn'531-00 Pace 10 DocuSign Envelope ID:527B540E-AC34-435E-B155-6851AB611960 cwi Account Statement For the Month Ending December 31, 2022 City of Petaluma -TREASURER'S INVESTMENTS - 531-00 Trade Settlement Share or Dollar Amount Total Date Date Transaction Descri lion Unit Price of Transaction Shares Owned CAMP .. 12/27/22 12/27/22 Purchase-Principal 3137BBBC3 1.00 2,693.36 46,045,813.77 12/27/22 12/27/22 Purchase-Principal 3136ARTE8 1.00 12,061.12 46,057,874.89 12/27/22 12/27/22 Purchase-Principal 3136AEGQ4 1.00 6,956.23 46,064,831.12 12/27/22 12/27/22 Purchase-Principal 3136AEGQ4 1.00 5,319.47 46,070,150.59 12/27/22 12/27/22 Redemption- Reversal of Interest 3137BTU25 from 12/25/2022 1.00 (591.77) 46,069,558.82 12/30!22 01/03/23 Accrual Income Div Reinvestment-Distributions 1.00 169,121.45 46,238,680.27 Closing Balance 46,238,680.27 Month of Fiscal YTD December January-December Opening Balance 47,129,168.28 40,092,471.04 Closing Balance 46,238,680.27 Purchases 2,867,762.10 26,627,945.29 Average Monthly Balance 46,287,474.10 Redemptions(Excl. Checks) (3,758,250.11) (20,481,736.06) Monthly Distribution Yield 4.30% Check Disbursements 0.00 0.00 Closing Balance 46,238,680.27 46,238,680.27 Cash Dividends and Income 169,121.45 809,950.59 PFM Asset Management LLC Account 531-00 Page 21