G\T Y OF
PISMO BEACH CITY COUNCIL STAFF REPORT
.o�s'yo Bt Agenda Item #9.0
Meeting Date: March 18, 2025
TITLE:
Monthly Investment Transaction Report of the City's Cash and Investments for January 2025 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 January 31, 2025. 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 January 31, 2025. • 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 January 31, 2025.
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 3-18-2025 i'. 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 January Earned Ending
Investment Name Name of Institution Type of Investment Rate Book Value 2025 1/31/25 *Data Sources General Fund Reserves US Bank CDsIGASsICorp 2.77%avg 8,904,483 $ 8,983 $ 101,773 1 Bonds/Treasuries
City Pooled Funds-A US Bank CDsIGASsI Corp 2.20%avg 45,972,668 65,556 500,840 1 Bonds/MBSsI
Treasuries
Total All Securities $ 54,877,150 $ 74,538 $ 602,613 City Pooled Funds-B US Bank Custody 4.34% $ 503,964 $ 27,939 $ 68,050 1 City Pooled Funds-B Local Agency Invest. State Investment 4.62% 406,346 - 79,973 2 Fund(LAIF) Pool
City Pooled Funds-B PFM Asset Mgmt JPA Investment Pool 4.55% 13,412,104 51,644 412,103 3 CAMP
City Pooled Funds-B US Bank Checking&Sweep 4.00% 11,793,522 41,777 480,483 4 City Pooled Funds-B $ 26,115,936 $ 121,360 $ 1,040,609 City Pooled Funds total A+B $ 72,088,603 $ 186,916 $ 1,541,449 Funds Held with Fiscal Bond funds: 2017 Pier Project $ 2,272 $ 115 $ 2,311 5 Agent Wilmington Trust
Funds Held with Fiscal Bond funds: 2017 CREB's 709 30 733 5 Agent Wilmington Trust Project
Funds Held with Fiscal Bond funds: 2024 Public Safety 35,353,519 84,831 572,536 5 Agent Wilmington Trust Facility
CalPERS Benefit Trust
OPEB Trust Account CalPERS Benefit Trust Various managed by $ 5,575,679 $ - $ 231,373 6 Account CalPERS
TOTAL,Cash and Investments at January 31,2025: $ 121,925,266 $ 280,875 $ 2,450,175 TOTAL for City Managed Portfolio,Cash and Investments: $ 80,993,086 $ 195,899 $ 1,643,222 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 3-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
January 31, 2025
INVESTMENT ACTIVITY
PURCHASES OR DEPOSITS
01/09/25 Purchase Toyota Motor Credit Corp $ 264,854 01/09/25 Purchase US Treasury Note 369,773
01/10/25 Purchase UBS Ag Stamford 265,000
01/16/25 Purchase FHLMC Multiclass Mtg 330,000 01/17/25 Purchase Adobe Inc 399,788
Total $ 1,629,415
SALES, MATURITIES, CALLS OR WITHDRAWALS
01/07/25 Matured US Treasury Bill $ 1,471,165 01/27/25 Matured US Bank National $ 271,250 Total $ 1,742,415
ACTIVITY TOTAL $ (113,001)
INTEREST REVENUE
GENERAL FUND RESERVE INVESTMENTS
Interest Earned on Investments $ 8,983
POOLED INVESTMENTS
Interest Earned on Investments $ 65,556
TOTAL INTEREST EARNED $ 74,538
Data Source: Monthly Download of Transactions from US Bank Council Agenda 3-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; 1/31/2025 Ending
Bank Account Description Bank ID Beginning Balance Cash Receipts Disbursements Transfers•In Transfers•Out Balance General Checking US Bank $ 9,553,063 $ 8,164,547 $ (5,924,089) $ $ $ 11,793,522 LAIF LAIF 401,798 4,548 406,346
PFM Asset Management LLC CAMP 13,360,460 51,644 13,412,104 Total all Bank Accounts $ 23,315,321 $ 8,220,739 $ (5,924,089) $ $ $ 25,611,971 Ending
Fund Description Fund# Beginning Balance Cash Receipts Disbursements Transfers•In Transfers•Out Balance General Fund
General Fund 1001-10101 2,673,441 3,885,753 (2,068,904) 4,490,290 General Fund-Reserve 1001-10105 4,117 4,219 8,335 Half Cent Sales Tax Fund 1002 1,875,239 16,740 1,891,979 Special Revenue Funds
Gas Tax Fund 2001 427,836 43,577 471,413
LTF-Streets 2002 450,486 3,295 453,781
PEG Access Fund 2003 117,575 542 118,116 Police Grant Fund 2004 174,211 952 175,163 Housing In Lieu Fund 2005 99,231 627 99,858 LBID Fund 2006 986,739 174,201 (64,703) 1,096,237 Chapman House 2007 10,113 (8,612) (1,032) 469 Capital Projects Funds
Capital Projects Fund 3001 3,263,855 748,059 (2,326,477) 1,685,437 Public Facilities Fund 3002 926 7 933 Park Development Fund 3003 375,747 8,270 384,017 Circulation Fund 3101 599,137 14,532 613,670 Development Impact Fee Fund 3102 176,441 18,703 (11,521) 183,623 Developer Impact Fee Fund 3103 176,367 1,317 177,685 Underground Utility Fund 3201 17,436 130 17,566 Council Agenda 3-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: 1/31/2025 Ending
Fund Description Fund# Beginning Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance Debt Service Funds
Public Finance Authority Fund 4001
Public Finance Authority Fund 4002 - - F - Freeway Foothills AD Fund 4101 807 6 813 Spyglass AD Fund 4102 13,430 100 13,531 Indio-El Portal AD Fund 4112 780 6 786 Visalia Street AD Fund 4113 8,627 64 8,691 Enterprise Funds
Water Enterprise/Tax Fund 6101/6102 4,296,617 (69,413) (1,090,915) 3,136,289 Water Construction Fund 6103 693,918 19,641 (13,239) 700,320 Water Expansion Fund 6104 464,588 21,630 486,218 Water Central Coast Blue JPA 6105 25,875 777 (4,045) 22,608 Wastewater Enterprise Fund 6201 1,197,440 (272,284) (227,704) 697,452 Wastewater Construction Fund 6202 2,014,330 17,903 (12,203) 2,020,030 Wastewater Expansion Fund 6203 562,930 36,247 599,176 Wastewater CCB JPA 6204 52,536 1,578 (8,212) 45,902 LTF-Transit Fund 6301
Pier Operations Fund 6401 24,844 5,778 (3,851) 26,771 Parking Fund 6501 (138,981) 3,293,722 (69,232) 3,085,510 Internal Service Funds
Technology Service Fund 7101 4,109 116,432 (100,617) 19,925 Motor Vehicle Fund 7201 1,136,306 129,395 (115,472) 1,150,229 Trust&Agency Funds
SLO County TMD 8201 70,194 126,029 (138,076) 58,147 Control Funds
Payroll Control Fund 9301 1,071,686 1,249 325,264 1,398,198 Interest Control Fund 9302 212,123 (118,702) 93,421 Utility Billing Control Fund 9304 174,264 5,118 179,382 MIR Control Fund 9305
Total all cash funds 23,315,321 8,227,588 (5,930,938) 25,611,971 Council Agenda 3-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: 1/31/2025 Ending
Fund Description Fund# Beginning Balance Cash Receipts Disbursements Transfers-In Transfers-Out Balance
INVESTMENTS
General Fund
General Fund Money Mrkt Csh 1001-10108 272,128 135,032 407,160 General Fund-CD's 1001-10404 4,990,033 195,000 5,185,033 General Fund-Fed Agency 1001-10405 4,049,000 - 4,049,000 GF Reserve Money Mkt Cash 1001-10109 21,440 13,481 34,922 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 E 1001-10146 298,000 - 298,000 GF Reserve-Risk Mgmt-CD's 1001-10407 150,000 50,000 200,000 GF Reserve-Risk Mgmt-Fed Ac 1001-10140 50,000 - 50,000 GF Corp Bond-Pooled 1001-10141 529,143 658,392 1,187,535 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 369,773 9,448,562 GF Treasury Bill 1001-10411 1,471,165 (1,471,165) - GF Mortgage Back Sec 1001-10412 - 330,000 330,000 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 2,704 2,704 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 1,333 415 1,748 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 Money Market Cash 2006-10108 - 972 972 LBID Fund-Treasury Note 2006-10410 1,914,063 - 1,914,063 Capital Projects Funds
Capital Proj Fund Mny Mkt Cash 3001-10108 - 2,715 2,715 Capital Projects Fund-Pooled 3001-10141 403,640 - 403,640 Capital Projects Fund-Fed Agen 3001-10405 - 1,000,000 1,000,000 Capital Proj Fd Mortgage Back Si 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.Impact Fee Mny Mkt 3102-10108 1,078 1,154 2,233 Development Impact Fee Fund 3102-10404 245,000 - 245,000 Impact Fees Federal Agencies 3102-10405 - - Council Agenda 3-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: 1/31/2025 Transfers-
Fund Description Fund# Beginning Balance Cash Receipts Disbursements Transfers-In Out Ending Balance
INVESTMENTS
Debt Service Funds
Capital Proj Fund-Fiscal Agent 3001-10511 36,893,465 (1,539,946) 35,353,519 Public Fin Fiscal Agent-Pier 4002-10510 2,157 115 2,272 Public Fin Fiscal Agent-PSF 4002-10511 - - - Public Fin Fiscal Agent-CREBs 4002-10515 679 30 709 Visalia Street AD Fund 4113-10108 411 442 853 Visalia Street CD's 4113-10404 100,000 - 100,000 Enterprise Funds
Water Fund Money Mrkt Csh 6101-10108 1,714 4,975 6,688 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 - 1,052,195 1,052,195 Water Fund Treasury Note 6101-10410 3,317,461 - 3,317,461 Water Construction Money Mkt 6103-10108 (0) 5,630 5,630 Wtr Constr.Fd Corp Bond-Pool 6103-10141 393,028 - 393,028 Water Construction 6103-10404 504,363 - 504,363 Water Expansion Fd Mny Mkt Ca 6104-10108 - 278 278 Wtr Expansion Fund-Pooled 6104-10141 546,568 - 546,568 Wastewater Fund Money Market 6201-10108 4,212 1,855 6,068 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 800,392 1,862,392 WWtr Fund Treasury Note 6201-10410 - - - Wastewater Expansion Fund Mny 6203-10108 - 4,084 4,084 WWtr Expansion Fd Mortgage BE 6203-10412 1,094,546 - 1,094,546 Parking Enterprise Money Mrkt 6501-10108 3,145 4,829 7,974 Parking Fund Corp Bond-Pooled 6501-10141 1,852,587 (1,852,587) - Parking Enterprise 6501-10404 1,225,000 (245,000) 980,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 7,275 12,660 19,935 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,575,679 5,575,679 Total all Investments $ 97,774,867 $ (1,461,573) $ - $ - $ - $ 96,313,294 Total all Funds $ 121,090,188 $ 6,766,015 $ (5,930,938) $ $ $ 121,925,266 Council Agenda 3-18-2025 9.C-7