PISMO BEACH COUNCIL AGENDA REPORT
Agenda Item #9.B
SUBJECT/TITLE:
MONTHLY INVESTMENT TRANSACTION REPORT OF THE CITY’S CASH AND INVESTMENTS FOR NOVEMBER 2021 OF FY 2021-2022
RECOMMENDATION:
No action required; information only.
EXECUTIVE SUMMARY:
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 November 30, 2021. 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.
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 November 30, 2021. •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 November 30, 2021.
FISCAL IMPACT:
No fiscal impact from the report itself—information only.
ALTERNATIVES:
1.No Council action is proposed, other than to receive the information.
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 Meeting Date: January 4, 2022 Submitted by: Nadia Feeser, Administrative Services Director / City Treasurer City Manager Approval:
9.B-1Council Agenda 1-4-2022
City of Pismo Beach
Investment Name Name of Institution Type of Investment
Current
Earnings
Rate Book Value
Actual Interest
Earned November
2021
Actual Year-to-Date
Interest Earned
Ending 11/30/2021 * Data Sources
General Fund Reserves US Bank CDs/GASs/Corp/ Muni
Bonds
1.76% avg 6,818,013 13,665$ 50,070$ 1 City Pooled Funds - A US Bank CDs/GASs/Corp/ Muni
Bonds
1.68% avg 21,119,217 33,236 132,245 1 Total All Securities 27,937,230$ 46,901$ 182,315$ City Pooled Funds - B US Bank Custody 0.00%-$ 2$ 5$ 1 City Pooled Funds - B Local Agency Invest.
Fund
State Investment Pool 0.24%19,267,848 - 11,726 2 City Pooled Funds - B US Bank Checking 0.00%21,792,840 85 344 3 City Pooled Funds - B 41,060,688$ 87$ 12,075$ City Pooled Funds total A + B 62,179,905$ 33,323$ 144,319$ Funds Held with Fiscal
Agent
Bond funds:
Wilmington Trust
2017 Pier Project 278,181$ -$ -$ 4 Funds Held with Fiscal
Agent
Bond funds:
Wilmington Trust
2017 CREB's Project 229,526$ -$ -$ 4 CalPERS Benefit Trust
OPEB Trust Account CalPERS Benefit Trust
Account
Various managed by
CalPERS
4,727,421$ -$ (19,369)$ 5 TOTAL, Cash and Investments at November 30, 2021:74,233,047$ 46,988$ 175,021$ TOTAL for City Managed Portfolio, Cash and Investments:68,997,918$ 46,988$ 194,390$ 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 CalPERS Benefit Trust Account Attachment 1: Summary Table for All Funds,
including Book Values and Earnings Data for Investments in Other Financial Instruments
9.B-2Council Agenda 1-4-2022
Attachment 1
CITY OF PISMO BEACH
Attachment 2: For the General Fund Reserve and City Pooled Funds A Transactions on Investments in Securities
November 30, 2021
INVESTMENT ACTIVITY
PURCHASES OR DEPOSITS
11/09/21 Purchase Merrick Bank 245,000$
Total 245,000$
SALES, MATURITIES, CALLS OR WITHDRAWALS
11/23/21 Matured Bank Baroda 245,000$
Total 245,000$
ACTIVITY TOTAL -$
INTEREST REVENUE
GENERAL FUND RESERVE INVESTMENTS
Interest Earned on Investments 13,665$
POOLED INVESTMENTS
Interest Earned on Investments 33,236$
TOTAL INTEREST EARNED 46,901$
Data Source: Monthly Download of Transactions from US Bank
9.B-3Council Agenda 1-4-2022
Attachment 2
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:11/30/2021 Bank Account Description Bank ID
Beginning
Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance General Checking US Bank 20,330,659$ 3,981,052$ (2,563,942)$ 290,093$ (245,022)$ 21,792,840$ LAIF LAIF 19,267,848 - - - - 19,267,848 Total all Bank Accounts 39,598,508$ 3,981,052$ (2,563,942)$ 290,093$ (245,022)$ 41,060,688$ Fund Description Fund #
Beginning
Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance General Fund
General Fund 1001-10101 10,818,537 2,297,125 (1,174,263) - - 11,941,399 General Fund-Reserve 1001-10105 595,553 (231,335) - - - 364,218 Half Cent Sales Tax Fund 1002 3,179,409 1,290 - - - 3,180,699 Special Revenue Funds
Gas Tax Fund 2001 119,633 46,190 - - - 165,823 LTF - Streets 2002 400,443 (53) - - - 400,389 PEG Access Fund 2003 137,475 - - - - 137,475 Police Grant Fund 2004 251,744 - - - - 251,744 Housing In Lieu Fund 2005 3,146,647 5,129 - - - 3,151,776 LBID Fund 2006 1,577,124 224,421 (1,215) - - 1,800,330 Chapman House 2007 386,662 10 (14,193) - - 372,479 Capital Projects Funds
Capital Projects Fund 3001 (1,299,640) 936,431 (492,959) - - (856,168) Public Facilities Fund 3002 868 - - - - 868 Park Development Fund 3003 610,237 (392) - - - 609,845 Circulation Fund 3101 357,406 (5,802) - - - 351,603 Development Impact Fee Fund 3102 843,902 (354,395) - - - 489,507 Developer Impact Fee Fund 3103 165,210 - - - - 165,210 Underground Utility Fund 3201 16,333 - - - - 16,333
9.B-4Council Agenda 1-4-2022
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:11/30/2021 Fund Description Fund #
Beginning
Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance Debt Service Funds
Public Finance Authority Fund 4001 - - - - - - Public Finance Authority Fund 4002 - - - - - - Freeway Foothills AD Fund 4101 756 - - - - 756 Spyglass AD Fund 4102 12,581 - - - - 12,581 Indio-El Portal AD Fund 4112 731 - - - - 731 Visalia Street AD Fund 4113 99,906 - - - - 99,906 Enterprise Funds
Water Enterprise/Tax Fund 6101/6102 4,253,442 631,190 (165,518) - - 4,719,113 Water Tax - Gragg Fund 6102-10102 100 - - - - 100 Water Construction Fund 6103 497,531 1,249 (170,108) - - 328,672 Water Expansion Fund 6104 1,107,513 4,153 - - - 1,111,666 Wastewater Enterprise Fund 6201 3,701,528 (108,623) (175,017) - - 3,417,888 Wastewater Construction Fund 6202 1,006,818 - (1,456) - - 1,005,362 Wastewater Expansion Fund 6203 1,832,479 4,496 - - - 1,836,974 LTF - Transit Fund 6301 29,385 (72) - - - 29,313 Pier Operations Fund 6401 10,271 6,205 (2,308) - - 14,168 Parking Fund 6501 2,779,158 193,616 (45,960) - - 2,926,813 Internal Service Funds
Technology Service Fund 7101 58,140 66,629 (30,335) - - 94,433 Motor Vehicle Fund 7201 2,210,869 89,918 (86,099) - - 2,214,688 Trust & Agency Funds
SLO County TMD 8201 211,754 173,248 (211,754) - - 173,248 Control Funds
Payroll Control Fund 9301 270,892 13,958 32,690 - - 317,540 Interest Control Fund 9302 11,985 85 - - - 12,070 Utility Billing Control Fund 9304 195,461 5,674 - - - 201,135 M/R Control Fund 9305 - - - - - - Total all cash funds 39,598,838 4,000,345 (2,538,495) - - 41,060,688
9.B-5Council Agenda 1-4-2022
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:11/30/2021 Fund Description Fund #
Beginning
Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance
INVESTMENTS
General Fund
General Fund Money Mrkt Csh 1001-10108 0 - - - - 0 General Fund - CD's 1001-10404 4,833,000 - - - - 4,833,000 General Fund - Fed Agency 1001-10405 3,184,000 - - - - 3,184,000 GF - Half Cent Sales Tax CD's 1002-10404 1,225,000 - - - - 1,225,000 GF - Half Cent Sales Tax 1002-10405 - - - - - - GF - Half Cent Sales Tax Mny Mkt 1002-10108 0 - - - - 0 GF Reserve Money Mkt Cash 1001-10109 0 - - - - 0 GF Reserve - CD's 1001-10403 2,852,000 245,000 - - - 3,097,000 GF Reserve - Fed Agency 1001-10402 1,208,000 - - - - 1,208,000 GF Reserve - Building 1001-10406 447,000 - - - - 447,000 GF Reserve - Building - Federal Age1001-10146 53,000 - - - - 53,000 GF Reserve - Risk Mgmt - CD's 1001-10407 150,000 - - - - 150,000 GF Reserve - Risk Mgmt - Fed Agenc 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 435,101 - - - - 435,101 GF Municipal Bonds Reserve 1001-10143 1,263,013 - - - - 1,263,013 Risk Mgmt Muni Bonds Reserve 1001-10144 50,000 - - - - 50,000 Half Cent Sales Tax - Pooled 1002-10141 499,685 - - - - 499,685 Half Cent Sales Tax - Muni Bond 1002-10142 571,288 - - - - 571,288 GF CREB's Fiscal Agent 1001-10515 (0) - - - - (0) Special Revenue Funds
Housing In Lieu - Mny Mkt Csh 2005-10108 (0) - - - - (0) Housing In Lieu Fund 2005-10404 875,000 - - - - 875,000 Housing In-Lieu Fed Agencies 2005-10405 - - - - - - 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 245,000 - - - - 245,000 Develop. Impact Fee Mny Mkt 3102-10108 0 - - - - 0 Development Impact Fee Fund 3102-10404 735,000 (245,000) - - - 490,000 Impact Fees Federal Agencies 3102-10405 - - - - - -
9.B-6Council Agenda 1-4-2022
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:11/30/2021 Fund Description Fund #
Beginning
Balance Cash Receipts Disbursements Transfers-In Transfers-Out Ending Balance Debt Service Funds
Public Fin Fiscal Agent-Pier 4002-10510 3 278,179 - - - 278,181 Public Fin Fiscal Agent-CREBs 4002-10515 3 229,524 - - - 229,526 Enterprise Funds
Water Fund Money Mrkt Csh 6101-10108 0 - - - - 0 Water Fund CD's 6101-10404 590,000 - - - - 590,000 Wtr Fund Federal Agencies 6101-10405 2,155,000 - - - - 2,155,000 Wtr Fund Corp Bond - Pooled 6101-10141 - - - - - - Water Construction Money Mkt 6103-10108 (0) - - - - (0) Water Construction 6103-10404 490,000 - - - - 490,000 Wastewater Fund Money Market Ca6201-10108 0 - - - - 0 Wastewater Fund CD's 6201-10404 245,000 - - - - 245,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 Parking Enterprise Money Mrkt 6501-10108 (0) - - - - (0) Parking Enterprise 6501-10404 490,000 - - - - 490,000 Parking Fund Federal Agencies 6501-10405 1,000,000 - - - - 1,000,000 Internal Service Funds
MVR Fund Money Mrkt Csh 7201-10108 0 - - - - 0 MVR Fund CD's 7201-10404 100,000 - - - - 100,000 MVR Fund Federal Agencies 7201-10405 0 - - - - 0 CalPers Benefit Trust
OPEB Trust Account 8101-10408 4,727,421 - - - - 4,727,421 Total all Investments 32,664,656$ 507,702$ -$ -$ -$ 33,172,359$ Total all Funds 72,263,494$ 4,508,047$ (2,538,495)$ -$ -$ 74,233,047$
9.B-7Council Agenda 1-4-2022
Attachment 3