Nit' ill
PISMO BEACH CITY COUNCIL STAFF REPORT
Agenda Item #9.0
Meeting Date: September 3, 2024
TITLE:
Monthly Investment Transaction Report of the City's Cash and Investments for July 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 July 31, 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 July 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 July 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 Council Agenda 9-3-2024 9.C-1
Prepared by: Vanessa Garris, Finance Manager
Submitted by: Nadia Feeser, Administrative Service Director / City Treasurer City Manager Approval:
Council Agenda 9-3-2024 9.C-2
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 Date Interest
Earnings Actual Interest Earned Ending
Investment Name Name of Institution Type of Investment Rate Book Value Earned July 2024 7131/2024 * Data Sources General Fund Reserves US Bank CDs/GASs/Corp/ 2,07% avg 8,148,980 $ 15,246 $ 15,246 1 Muni Bonds
City Pooled Funds - A US Bank CDs/GASs/ Corp 3,00% avg 34,591,551 45,140 45,140 1 Bonds/ Muni Bonds/
US Treasury Note
Total All Securities $ 42,740,531 $ 60,387 $ 60,387
City Pooled Funds - B US Bank Custody 0.00% $ - $ 74 $ 74 1 City Pooled Funds - B Local Agency Invest. State Investment 4,55% 5,326,373 2 Fund Pool
City Pooled Funds - B US Bank Checking & Sweep 4.89% 28,846,416 113,813 113,813 3 City Pooled Funds • B $ 34,172,788 $ 113,887 $ 113,887
City Pooled Funds total A+ B $ 68,764,339 $ 159,027 $ 159,027 Funds Held with Fiscal Bond funds: 2017 Pier Project $ 399 $ 33 $ 33 4 Agent Wilmington Trust
Funds Held with Fiscal Bond funds: 2017 CREB's 238 20 20 4 Agent Wilmington Trust Project
CaIPERS Benefit Trust
OPEB Trust Account CaIPERS Benefit Various managed by $ 5,540,572 $ - $ 5 Trust Account CaIPERS
TOTAL, Cash and Investments at July 31, 2024: $ 82,454,529 $ 174,327 $ 174,327 TOTAL for City Managed Portfolio, Cash and Investments: $ 76,913,319 $ 174,274 $ 174,274 Notes:
* Data Sources for Book Values and Actual Interest Earned:
1= Monthly Customer Statement from US Bank
2 = Monthly statement from Local Agency Investment Fund 3 = Monthly reconciled bank statement from US Bank
4 = Monthly statement from Wilmington Trust
5 = Monthly statement from CaIPERS Benefit Trust Account Council Agenda 9-3-2024 9.C-3
Attachment 2
CITY OF PISMO BEACH
Attachment 2: For the General Fund Reserve and City Pooled Funds A Transactions on Investments in Securities
July 31, 2024
INVESTMENT ACTIVITY
PURCHASES OR DEPOSITS
No Activity $
Total
SALES, MATURITIES, CALLS OR WITHDRAWALS
No Activity
$
$
Total $
ACTIVITY TOTAL $
INTEREST REVENUE
GENERAL FUND RESERVE INVESTMENTS
Interest Earned on Investments $ 15,246
POOLED INVESTMENTS
Interest Earned on Investments $ 45,140
TOTAL INTEREST EARNED
Data Source: Monthly Download of Transactions from US Bank $ 60,387
Council Agenda 9-3-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: 713112024 Beginning Ending
Bank Account Description Bank ID Balance Cash Receipts Disbursements Transfers•In Transfers•Out Balance General Checking US Bank $ 28,603,597 $ 7,972,386 $ (7,788,213) $ 58,646 $ - $ 28,846,416 LAIF LAIF 5,263,562 62,811 - - - 5,326,373
Total all Bank Accounts $ 33,867,158 $ 8,035,197 $ (7,788,213) $ 58,646 $ • $ 34,172,788 Beginning Ending
Fund Description Fund # Balance Cash Receipts Disbursements Transfers•In Transfers•Out Balance General Fund
General Fund 1001-10101 7,672,311 2,701,461 (4,016,795) 6,356,976 General Fund -Reserve 1001-10105 4,723 15,261 19,984.14 Half Cent Sales Tax Fund 1002 2,158,435 2,102 2,160,537 Special Revenue Funds
Gas Tax Fund 2001 321,088 36,424 357,512
LTF - Streets 2002 318,996 (68) 318,928
PEG Access Fund 2003 103,639 (334) 103,305
Police Grant Fund 2004 107,243 (15,633) 91,610
Housing In Lieu Fund 2005 116,095 1,046 (1,200) 115,941 LBID Fund 2006 2,512,612 302,308 (76,971) 2,737,950
Chapman House 2007 66,231 2,694 (7,910) 61,015
Capital Projects Funds
Capital Projects Fund 3001 925,933 2,889,638 (95,688) 3,719,883 Public Facilities Fund 3002 898 - 898
Park Development Fund 3003 372,098 (498) 371,600
Circulation Fund 3101 575,239 (3) 575,236
Development Impact Fee Fund 3102 141,464 921 142,385
Developer Impact Fee Fund 3103 171,005 171,005
Underground Utility Fund 3201 16,906 16,906
Council Agenda 9-3-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: 713112024 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 V
Freeway Foothills AD Fund 4101 782 782
Spyglass AD Fund 4102 13,022 13,022
Indio -El Portal AD Fund 4112 756 756
Visalia Street AD Fund 4113 6,391 378 6,769
Enterprise Funds
Water Enterprise/Tax Fund 6101/6102 6,368,940 534,473 (1,945,525) 4,957,888 Water Construction Fund 6103 854,304 5,175 859,479
Water Expansion Fund 6104 958,059 958,059
Water Central Coast Blue JPA 6105 565 (0) 565
Wastewater Enterprise Fund 6201 894,017 520,989 (727,246) 687,760 Wastewater Construction Fund 6202 1,688,851 (3,921) 1,684,929 Wastewater Expansion Fund 6203 2,147,869 2,147,869
Wastewater CCB JPA 6204 1,147 (1) 1,146
LTF - Transit Fund 6301 28,898 - 28,898
Pier Operations Fund 6401 3,330 7,134 (14,958) (4,494)
Parking Fund 6501 100,464 441,708 (131,911) 410,260
Internal Service Funds
Technology Service Fund 7101 120,406 124,884 (157,248)
Motor Vehicle Fund 7201 3,031,512 124,633 (154,164)
88,042
3,001,981
Trust & Agency Funds
SLO County TMD 8201 166,561 232,997 (166,659) 232,900
Control Funds
Payroll Control Fund 9301 1,363,230 1,321 (306,142) 1,058,410 Interest Control Fund 9302 356,080 176,624 532,704
Utility Billing Control Fund 9304 178,769 4,623 183,392 M/R Control Fund 9305
Total all cash funds 33,867,158 8,111,969 (7,806,339) 34,172,788 Council Agenda 9-3-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: 7131/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 0
General Fund - CD's 1001-10404 6,460,033 6,460,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 Agf 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 3,672,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 897,022 ' 897,022
GF Municipal Bonds Reserve 1001-10143 1,018,013 1,018,013 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
Development Impact Fee Fund 3102-10404
Impact Fees Federal Agencies 3102-10405
0 245,000
0 245,000
Council Agenda 9-3-2024 9.C-7
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: 713112024 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 366 33 399
Public Fin Fiscal Agent-CREBs 4002-10515 218 20 238
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 1,750,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 500,000
CalPers Benefit Trust
OPEB Trust Account 8101-10408 5,540,572 - 5,540,572
Total all Investments $ 48,281,688 $ 53 $ $ $ - $ 48,281,741 Total all Funds $ 82,148,846 $ 8,112,022 $ (7,806,339) $ • $ - $ 82,454,529 Council Agenda 9-3-2024 9.C-8