WB
PISMO BEACH CITY COUNCIL STAFF REPORT
Agenda Item #9.0
Meeting Date: February 18, 2025
TITLE:
Monthly Investment Transaction Report of the City's Cash and Investments for December 2024 of Fiscal Year 2025
RECOMMENDATION:
No action recommended; for information only.
DISCUSSION:
This report updates the City Council on the City of Pismo Beach's monthly transactions of the City's investment portfolio for the month ending December 31, 2024. California Government Code Section 53607 states that if the authority of the legislative body to invest or reinvest funds for the City is delegated to the City Treasurer, the City Treasurer shall make a monthly report of those transactions to the legislative body. Pursuant to Government Code Section 6505.5, this information is being provided here to the Pismo Beach Public Financing Authority, the Pismo Beach Public Financing Agency, and the Central Coast Blue Regional Recycled Water Authority, through the members of the City Council who sit on those boards.
The attached report includes all transactions of the City's investments managed by the City, including funds invested in various securities and the City's pooled funds invested in various financial instruments.
• Attachment 1 provides a summary of the City's cash, investments, and monthly interest earnings based on book value as of December 31, 2024. • Attachment 2 provides details on the investment transactions for the General Fund Reserve and City Pooled Funds A (for deferred capital projects), including: purchases or deposits; sales, maturities, calls or withdrawals; and interest earnings. • Attachment 3 provides details of the monthly transactions by fund for City Pooled Funds B (for current year expenditures) for the month ending December 31, 2024.
FISCAL IMPACT:
No fiscal impact from the report itself—information only.
ATTACHMENTS:
1. Summary Table for ALL Funds, including Book Values and Earnings Data for Investments in Other Financial Instruments
2. For the General Fund Reserve and City Pooled Funds A—Transactions on Investments in Securities
3. For City Pooled Funds B—Summary of monthly transactions by fund Prepared by: Vanessa Garris, Finance Manager
Submitted by: Nadia Feeser, Administrative Service Director/ City Treasurer City Manager Approval:
Council Agenda 2-18-2025 l x 9.C-1
Attachment 1
City of Pismo Beach
Attachment 1:Summary Table for All Funds,
including Book Values and Earnings Data for Investments in Other Financial Instruments Actual Year-to-
Current Actual Interest Date Interest
Earnings Earned Earned Ending
Investment Name Name of Institution Type of Investment Rate Book Value December 2024 12/31/24 *Data Sources General Fund Reserves US Bank CDs/GASs/Corp 2.77%avg 8,854,483 $ 19,171 $ 92,790 1 Bonds/Treasuries
City Pooled Funds-A US Bank CDs/GASs/Corp 2.20%avg 46,135,668 (27,846) 435,284 1 Bonds/MBSs/
Treasuries
Total All Securities $ 54,990,151 $ (8,675) $ 528,074 City Pooled Funds-B US Bank Custody 4.34% $ 312,736 $ 10,057 $ 40,111 1 City Pooled Funds-B Local Agency Invest, State Investment 4.62% 401,798 4,548 79,973 2 Fund(LAIF) Pool
City Pooled Funds-B PFM Asset Mgmt JPA Investment Pool 4.73% 13,360,460 53,267 360,459 3 CAMP
City Pooled Funds-B US Bank Checking&Sweep 4.16% 9,553,063 41,175 438,706 4 City Pooled Funds-B $ 23,628,057 $ 109,048 $ 919,249 City Pooled Funds total A+B $ 69,763,726 $ 81,201 $ 1,354,533 Funds Held with Fiscal Bond funds: 2017 Pier Project $ 2,157 $ 2,157 $ 2,196 5 Agent Wilmington Trust
Funds Held with Fiscal Bond funds: 2017 CREB's 679 679 702 5 Agent Wilmington Trust Project
Funds Held with Fiscal Bond funds: 2024 Public Safety 36,893,465 487,705 487,705 5 Agent Wilmington Trust Facility
CalPERS Benefit Trust
OPEB Trust Account CalPERS Benefit Trust Various managed by $ 5,575,679 $ (204,800) $ 231,373 6 Account CalPERS
TOTAL,Cash and Investments at December 31,2024: $ 121,090,188 $ 386,114 $ 2,169,300 TOTAL for City Managed Portfolio,Cash and Investments: $ 78,618,208 $ 100,373 $ 1,447,323 Notes:
*Data Sources for Book Values and Actual Interest Earned:
1 =Monthly investment statement from US Bank
2=Monthly statement from Local Agency Investment Fund
3=Monthly statement from PFM Asset Management LLC
4=Monthly reconciled bank statement from US Bank
5=Monthly statement from Wilmington Trust
6=Monthly statement from CalPERS Benefit Trust Account
Council Agenda 2-18-2025 9.C-2
Attachment 2
CITY OF PISMO BEACH
Attachment 2: For the General Fund Reserve and City Pooled Funds A Transactions on Investments in Securities
December 31, 2024
INVESTMENT ACTIVITY
PURCHASES OR DEPOSITS
12/10/24 Purchase US Treasury Note $ 2,018,516 12/11/24 Purchase US Treasury Note 1,963,438 12/11/24 Purchase US Treasury Note 2,017,188 12/11/24 Purchase US Treasury Note 1,803,906 12/11/24 Purchase US Treasury Note 1,914,063 12/11/24 Purchase US Treasury Note 1,396,523 12/11/24 Purchase Accenture Capital 393,028
12/11/24 Purchase Citibank 552,195
12/11/24 Purchase Cooperatieve Centrale Raiffeis Coco 546,568 12/11/24 Purchase State Street 403,640
12/12/24 Purchase US Treasury Note 1,886,250 12/12/24 Purchase US Treasury Note 1,920,938 12/12/24 Purchase US Treasury Note 1,408,008 12/12/24 Purchase US Treasury Note 1,424,766 12/12/24 Purchase US Treasury Note 1,361,836 12/13/24 Purchase FHLMC Multiclass 554,146
12/13/24 Purchase FHLMC Multiclass 556,682
12/16/24 Purchase Australia New Zealand 800,392 12/16/24 Purchase US Treasury Bill 1,471,165
12/17/24 Purchase FNMA Grd Remic 540,400
Total $ 24,933,646
SALES, MATURITIES, CALLS OR WITHDRAWALS
12/30/24 Matured First National Bank McGregor $ 245,000 Total $ 245,000
ACTIVITY TOTAL $ 24,688,646
INTEREST REVENUE
GENERAL FUND RESERVE INVESTMENTS
Interest Earned on Investments $ 19,171
POOLEDINVESTMENTS
Interest Earned on Investments $ (27,846)
TOTAL INTEREST EARNED $ (8,675)
Data Source: Monthly Download of Transactions from US Bank Council Agenda 2-18-2025 9.C-3
Attachment 3
Attachment 3: For City Pooled Funds B-Summary of monthly transactions by fund City of Pismo Beach -Bank Account Proof of Cash for the month ending: 12131/2024 Beginning Ending
Bank Account Description Bank ID Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance General Checking US Bank $34,610,219 $ 5,510,014 $ (5,567,169) $ 299,420 $(25,299,420) $ 9,553,063 LAIF LAIF 401,798 - 401,798
PFM Asset Management LLC CAMP 13,307,192 53,267 - 13,360,460 Total all Bank Accounts $48,319,209 $ 5,563,281 $ (5,567,169) $ 299,420 $(25,299,420) $ 23,315,321 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance General Fund
General Fund 1001-10101 15,022,628 (10,004,140) (2,392,939) 2,625,550 General Fund-Reserve 1001-10105 1,366,943 (1,362,827) - 4,116.53 Half Cent Sales Tax Fund 1002 2,755,238 (879,999) 1,875,239 Special Revenue Funds
Gas Tax Fund 2001 389,285 38,551 - 427,836 LTF-Streets 2002 449,202 1,285 450,486 PEG Access Fund 2003 117,552 22 117,575 Police Grant Fund 2004 156,131 18,080 - 174,211 Housing In Lieu Fund 2005 99,046 184 - 99,231 LBID Fund 2006 3,362,386 (2,089,433) (286,183) 986,771 Chapman House 2007 13,784 (2,245) (1,287) 10,253 Capital Projects Funds
Capital Projects Fund 3001 2,584,242 1,522,146 (842,533) 3,263,855 Public Facilities Fund 3002 924 3 - 926 Park Development Fund 3003 390,211 (14,464) - 375,747 Circulation Fund 3101 591,868 7,269 599,137 Development Impact Fee Fund 3102 171,263 9,528 (4,350) 176,441 Developer Impact Fee Fund 3103 175,838 530 - 176,367 Underground Utility Fund 3201 17,384 52 - 17,436 Council Agenda 2-18-2025 9.C-4
Attachment 3
Attachment 3: For City Pooled Funds B•Summary of monthly transactions by fund City of Pismo Beach •Bank Account Proof of Cash for the month ending: 12131/2024 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance Debt Service Funds
Public Finance Authority Fund 4001 -
Public Finance Authority Fund 4002 -
Freeway Foothills AD Fund 4101 804 2 807 Spyglass AD Fund 4102 13,390 40 13,430 Indio-El Portal AD Fund 4112 778 2 780 Visalia Street AD Fund 4113 8,601 26 8,627 Enterprise Funds
Water Enterprise/Tax Fund 610116102 7,681,595 (2,463,265) (905,557) 4,312,773 Water Construction Fund 6103 1,086,522 (392,604) 693,918 Water Expansion Fund 6104 1,003,285 (538,697) 464,588 Water Central Coast Blue JPA 6105 32,169 97 (6,388) 25,878 Wastewater Enterprise Fund 6201 637,991 781,715 (206,513) 1,213,194 Wastewater Construction Fund 6202 1,877,376 187,034 (50,080) 2,014,330 Wastewater Expansion Fund 6203 2,238,448 (1,675,519) 562,930 Wastewater CCB JPA 6204 65,314 197 (12,970) 52,542 LTF-Transit Fund 6301 - -
Pier Operations Fund 6401 (5,267) 36,419 (2,561) 28,591 Parking Fund 6501 1,774,478 (1,880,286) (32,596) (138,404) Internal Service Funds
Technology Service Fund 7101 34,950 114,246 (135,844) 13,351 Motor Vehicle Fund 7201 2,299,474 (992,947) (167,984) 1,138,543 Trust&Agency Funds
SLO County TIMID 8201 50,097 185,028 (164,930) 70,194 Control Funds
Payroll Control Fund 9301 1,432,308 4,868 (365,491) 1,071,686 Interest Control Fund 9302 249,832 (37,709) 212,123 Utility Billing Control Fund 9304 173,136 1,127 174,264 WR Control Fund 9305 -
Total all cash funds 48,319,209 (19,425,683) (5,578,205) 23,315,321 Council Agenda 2-18-2025 9.C-5
Attachment 3
Attachment 3: For City Pooled Funds B-Summary of monthly transactions by fund City of Pismo Beach -Bank Account Proof of Cash for the month ending: 12/31/2024 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance
INVESTMENTS
General Fund
General Fund Money Mrkt Csh 1001-10108 0 272,128 272,128 General Fund-CD's 1001-10404 5,235,033 (245,000) 4,990,033 General Fund-Fed Agency 1001-10405 4,049,000 - 4,049,000 GF Reserve Money Mkt Cash 1001-10109 0 21,440 21,440 GF Reserve-CD's 1001-10403 3,427,967 - 3,427,967 GF Reserve-Fed Agency 1001-10402 2,208,000 2,208,000 GF Reserve-Building 1001-10406 202,000 202,000 GF Reserve-Building-Federal 1001-10146 298,000 298,000 GF Reserve-Risk Mgmt-CD's 1001-10407 150,000 150,000 GF Reserve-Risk Mgmt-Fed Ac 1001-10140 50,000 50,000 GF Corp Bond-Pooled 1001-10141 529,143 529,143 GF Corp Bond-Reserve 1001-10145 500,000 500,000 GF Municipal Bonds Pooled 1001-10142 -
GF Municipal Bonds Reserve 1001-10143
Risk Mgmt Muni Bonds Reserve 1001-10144 - - GF Treasury Note 1001-10410 9,078,789 9,078,789 GF Treasury Bill 1001-10411 1,471,165 1,471,165 GF Reserve Treasury Note 1001-10413 - 2,018,516 2,018,516 GF CREB's Fiscal Agent 1001-10515 (0) - (0) GF-Half Cent Sales Tax CD's 1002-10404 735,000 735,000 GF-Half Cent Sales Tax Fed Ag(1002-10405 500,000 500,000 GF-Half Cent Sales Tax Mny Mk 1002-10108 0 0
Half Cent Sales Tax-Pooled 1002-10141 - - Half Cent Sales Tax-Muni Bond 1002-10142 - - Half Cent Sales Tax Treasury Not 1002-10410 - 1,424,766 1,424,766 Special Revenue Funds
Housing In Lieu-Mny Mkt Csh 2005-10108 (0) 1,333 1,333 Housing In Lieu Fund 2005-10404 385,000 - 385,000 Housing In-Lieu Fed Agencies 2005-10405 140,000 140,000 Housing In-Lieu Treasury Note 2005-10410 - - - LBID Fund-Treasury Note 2006-10410 1,914,063 1,914,063 Capital Projects Funds
Capital Projects Fund-Pooled 3001-10141 403,640 403,640 Capital Proj Fd Mortgage Back SE 3001-10412 556,682 556,682 Park Develop. Fund Mny Mkt 3003-10108 - - Park Development Fund 3003-10404
Park Develop Federal Agencies 3003-10405
Circulation Fees Mny Mkt 3101-10108
Circulation Fees 3101-10404 - - - Develop.ImpactFee Mny Mkt 3102-10108 0 1,078 1,078 Development Impact Fee Fund 3102-10404 245,000 - 245,000 Impact Fees Federal Agencies 3102-10405 - - Council Agenda 2-18-2025 9.C-6
Attachment 3
Attachment 3: For City Pooled Funds B-Summary of monthly transactions by fund City of Pismo Beach-Bank Account Proof of Cash for the month ending: 12/31/2024 Beginning
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance
INVESTMENTS
Debt Service Funds
Public Fin Fiscal Agent-Pier 4002-10510 920,231 (918,074) 2,157 Public Fin Fiscal Agent-PSF 4002-10511 - 36,893,465 36,893,465 Public Fin Fiscal Agent-CREBs 4002-10515 239,763 (239,084) 679 Visalia Street AD Fund 4113-10108 - 411 411 Visalia Street CD's 4113-10404 100,000 - 100,000 Enterprise Funds
Water Fund Money Mrkt Csh 6101-10108 0 1,714 1,714 Water Fund CD's 6101-10404 735,000 - 735,000 Wtr Fund Federal Agencies 6101-10405 2,155,000 2,155,000 Wtr Fund Corp Bond-Pooled 6101-10141 - - - Water Fund Treasury Note 6101-10410 3,317,461 3,317,461 Water Construction Money Mkt 6103-10108 (0) - (0) Wtr Constr. I'd Corp Bond-Pool 6103-10141 - 393,028 393,028 Water Construction 6103-10404 504,363 - 504,363 Wtr Expansion Fund-Pooled 6104-10141 - 546,568 546,568 Wastewater Fund Money Market 6201-10108 0 4,212 4,212 Wastewater Fund CD's 6201-10404 490,000 - 490,000 Wastewater Fund Fed Agencies 6201-10405 2,100,000 2,100,000 WWtr Fund Corp Bond-Pooled 6201-10141 1,062,000 1,062,000 WWtr Fund Treasury Note 6201-10410 - - - WWtr Expansion Fd Mortgage&6203-10412 - 1,094,546 1,094,546 Parking Enterprise Money Mrkt 6501-10108 (0) 3,145 3,145 Parking Fund Corp Bond-Pooled 6501-10141 500,000 1,352,587 1,852,587 Parking Enterprise 6501-10404 1,225,000 - 1,225,000 Parking Fund Federal Agencies 6501-10405 1,000,000 1,000,000 Parking Fund Treasury Note 6501-10410 - - - Internal Service Funds
MVR Fund Money Mrkt Csh 7201-10108 0 7,275 7,275 MVR Fund CD's 7201-10404 1,526,000 - 1,526,000 MVR Fund Federal Agencies 7201-10405 250,000 - 250,000 MVR Fund Treasury Note 7201-10410 - 1,361,836 1,361,836 CalPers Benefit Trust
OPEB Trust Account 8101-10408 5,781,483 (205,804) 5,575,679 Total all Investments $37,242,982 $ 60,531,886 $ - $ - $ - $ 97,774,867 Total all Funds $85,562,191 $ 41,106,203 $ (5,578,205) $ - $ - $ 121,090,188 Council Agenda 2-18-2025 9.C-7