G\T Y OF
PISMO BEACH CITY COUNCIL STAFF REPORT
Agenda Item #9.0
Meeting Date: November 19, 2024
TITLE:
Monthly Investment Transaction Report of the City's Cash and Investments for September 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 September 30, 2024. California State 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 September 30, 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 September 30, 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: ff
Council Agenda 11-19-2024 9.C-1
Attachment 1
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 September 2024 9/30/2024 Data Sources General Fund Reserves US Bank CDs/GASs/Corp/ 2.41%avg 7,130,967 $ 22,304 $ 44,710 1 Muni Bonds
City Pooled Funds-A US Bank CDs/GASs/Corp 2.28%avg 24,001,193 268,211 362,561 1 Bonds/Muni Bonds
Total All Securities $ 31,132,160 $ 290,515 $ 407,271 City Pooled Funds-B US Bank Custody 0.00% $ - $ 6,090 $ 6,306 1 City Pooled Funds-B Local Agency Invest. State Investment 4.71% 326,373 75,425 75,425 2 Fund(LAIF) Pool
City Pooled Funds-B PFM Asset Mgmt JPA Investment Pool 5.29% 24,061,525 61,524 61,524 3 CAMP
City Pooled Funds-B US Bank Checking&Sweep 4.76% 21,071,634 68,461 279,851 4 City Pooled Funds-B $ 45,459,532 $ 211,501 $ 423,106 City Pooled Funds total A+B $ 69,460,725 $ 479,712 $ 785,666 Funds Held with Fiscal Bond funds: 2017 Pier Project $ 402 $ 2 $ 36 5 Agent Wilmington Trust
Funds Held with Fiscal Bond funds: 2017 CREB's 240 1 22 5 Agent Wilmington Trust Project
CalPERS Benefit Trust
OPEB Trust Account CalPERS Benefit Trust Various managed by $ 5,781,483 $ 436,172 $ 436,172 6 Account CalPERS
TOTAL,Cash and Investments at September 30,2024: $ 82,373,817 $ 938,190 $ 1,266,607 TOTAL for City Managed Portfolio,Cash and Investments: $ 76,591,692 $ 502,015 $ 830,377 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 11-19-2024 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
September 30, 2024
INVESTMENT ACTIVITY
PURCHASES OR DEPOSITS
No Activity $ -
Total $ -
SALES, MATURITIES, CALLS OR WITHDRAWALS
09/11/24 Matured Alma Bank $ 245,000
09/12/24 Matured US Treasury Bill $ 8,003,991 09/18/24 Matured Abacus Federal Savings Bank 245,000 09/27/24 Full Call FHLB 500,000
09/30/24 Full Call FHLB 500,000
Total $ 9,493,991
ACTIVITY TOTAL $ (9,493,991)
INTEREST REVENUE
GENERAL FUND RESERVE INVESTMENTS
Interest Earned on Investments $ 22,304
POOLED INVESTMENTS
Interest Earned on Investments $ 268,211 TOTAL INTEREST EARNED $ 290,515
Data Source: Monthly Download of Transactions from US Bank Council Agenda 11-19-2024 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: 9130/2024 Beginning Ending
Bank Account Description Bank ID Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance General Checking US Bank $ 18,718,800 $ 5,978,357 $ (4,416,118) $24,790,596 $(24,000,001) $ 21,071,634 LAIF LAIF 15,326,373 - (15,000,000) 326,373 PFM Asset Management LLC CAMP 61,524 - 24,000,001 - 24,061,525 Total all Bank Accounts $34,045,172 $ 6,039,881 $ (4,416,118) $48,790,597 $(39,000,001) $ 45,459,532 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance General Fund
General Fund 1001-10101 7,186,272 8,788,368 (1,791,884) 14,182,756 General Fund-Reserve 1001-10105 800,395 268,409 - - 1,068,804.47 Half Cent Sales Tax Fund 1002 2,541,384 162,917 - - 2,704,302 Special Revenue Funds
Gas Tax Fund 2001 262,654 39,735 - 302,389 LTF-Streets 2002 396,328 (68) - 396,260 PEG Access Fund 2003 113,342 (334) - 113,008 Police Grant Fund 2004 69,808 (8,143) - - 61,665 Housing In Lieu Fund 2005 113,014 113 (18,000) - 95,127 LBID Fund 2006 3,016,322 333,408 (137,583) 3,212,147 Chapman House 2007 40,268 1,500 (24,216) 17,552 Capital Projects Funds
Capital Projects Fund 3001 3,339,347 1,144,410 (691,069) 3,792,688 Public Facilities Fund 3002 908 - 908 Park Development Fund 3003 384,779 (498) (2,836) 381,445 Circulation Fund 3101 580,768 (5,037) - 575,732 Development Impact Fee Fund 3102 160,042 991 - 161,033 Developer Impact Fee Fund 3103 172,925 - 172,925 Underground Utility Fund 3201 17,096 - 17,096 Council Agenda 11-19-2024 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: 9130/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 791 - 791 Spyglass AD Fund 4102 13,168 - 13,168 Indio-El Portal AD Fund 4112 765 - 765 Visalia Street AD Fund 4113 7,228 406 - 7,633 Enterprise Funds
Water Enterprise/Tax Fund 6101/6102 4,690,876 1,584,197 (125,083) 6,149,990 Water Construction Fund 6103 1,069,757 76 1,069,832 Water Expansion Fund 6104 977,379 - 977,379 Water Central Coast Blue JPA 6105 26,987 3,700 - 30,687 Wastewater Enterprise Fund 6201 (1,760,640) 1,510,647 (237,649) (487,642) Wastewater Construction Fund 6202 1,838,910 1,806 (1,806) 1,838,910 Wastewater Expansion Fund 6203 2,185,536 - 2,185,536 Wastewater CCB JPA 6204 54,793 7,512 62,305 LTF-Transit Fund 6301 - -
Pier Operations Fund 6401 (8,416) 10,313 (4,913) (3,015) Parking Fund 6501 708,725 979,534 (59,680) 1,628,579 Internal Service Funds
Technology Service Fund 7101 60,157 95,026 (132,598) 22,585 Motor Vehicle Fund 7201 3,085,830 538,993 (843,833) 2,780,989 Trust&Agency Funds
SLO County TMD 8201 296,474 241,791 (296,474) 241,791 Control Funds
Payroll Control Fund 9301 1,161,731 2,990 (54,479) 1,110,241 Interest Control Fund 9302 274,201 129,985 - 404,186 Utility Billing Control Fund 9304 165,268 3,716 - 168,984 WR Control Fund 9305 - - -
Total all cash funds 34,045,172 15,836,462 (4,422,103) 45,459,532 Council Agenda 11-19-2024 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: 9/30/2024 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance
INVESTMENTS
General Fund
General Fund Money MrktCsh 1001-10108 0 0
General Fund-CD's 1001-10404 5,725,033 (245,000) 5,480,033 General Fund-Fed Agency 1001-10405 4,049,000 4,049,000 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
GF Reserve Money Mkt Cash 1001-10109 0 0
GF Reserve-CD's 1001-10403 3,672,967 (245,000) 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 E 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 290,655 290,655 GF Municipal Bonds Reserve 1001-10143 245,000 245,000 Risk Mgmt Muni Bonds Reserve 1001-10144 50,000 50,000 Half Cent Sales Tax-Pooled 1002-10141 - - Half Cent Sales Tax-Muni Bond 1002-10142 -
GF CREB's Fiscal Agent 1001-10515 (0) (0) GF Treasury Note 1001-10410 6,003,991 (6,003,991) - Special Revenue Funds
Housing In Lieu-Mny Mkt Csh 2005-10108 (0) (0) 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 - - Capital Projects Funds
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.Impact Fee Mny Mkt 3102-10108 0 0
Development Impact Fee Fund 3102-10404 245,000 245,000 Impact Fees Federal Agencies 3102-10405 - - Council Agenda 11-19-2024 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: 9/30/2024 Beginning Ending
Fund Description Fund# Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance
INVESTMENTS
Debt Service Funds
Public Fin Fiscal Agent-Pier 4002-10510 401 2 402 Public Fin Fiscal Agent-CREBs 4002-10515 239 1 240 Visalia Street CD's 4113-10404 100,000 - 100,000 Enterprise Funds
Water Fund Money Mrkt Csh 6101-10108 0 0
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 1,000,000 (1,000,000) Water Construction Money Mkt 6103-10108 (0) (0) Water Construction 6103-10404 504,363 504,363 Wastewater Fund Money Market 6201-10108 0 0
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 1,000,000 (1,000,000) - Parking Enterprise Money Mrkt 6501-10108 (0) (0) Parking Fund Corp Bond-Pooled 6501-10141 500,000 500,000 Parking Enterprise 6501-10404 1,225,000 1,225,000 Parking Fund Federal Agencies 6501-10405 1,750,000 (750,000) 1,000,000 Parking Fund Treasury Note 6501-10410 - - Internal Service Funds
MVR Fund Money Mrkt Csh 7201-10108 0 - 0 MVR Fund CD's 7201-10404 1,526,000 - 1,526,000 MVR Fund Federal Agencies 7201-10405 500,000 (250,000) - 250,000 CalPers Benefit Trust
OPEB Trust Account 8101-10408 5,346,513 434,970 5,781,483 Total all Investments $45,973,304 $ (9,059,019) $ - $ - $ - $ 36,914,285 Total all Funds $80,018,477 $ 6,777,443 $ (4,422,103) $ - $ - $ 82,373,817 Council Agenda 11-19-2024 9.C-7