Loading...
CC SR 20240206 C - City December 2023 Treasury Report CITY COUNCIL MEETING DATE: 02/06/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the December 2023 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the December 2023 Cash Balances/Monthly Treasurer’s Report. FISCAL IMPACT: None Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Jane Lin, Senior Accountant REVIEWED BY: Vina Ramos, Director of Finance VR APPROVED BY: Ara Mihranian, AICP, City Manager ATTACHED SUPPORTING DOCUMENTS: A. Monthly Treasurer’s Report (page A-1) BACKGROUND AND DISCUSSION: This report summarizes the cash balance of all funds and investments for the month of December 2023. A separate report is prepared monthly for the Improvement Authority and presented under separate cover before the Authority Commission. The overall cash balances of the City totaled $96 million with approximately $50 million or 52% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has over $4 million or 4% of the total cash balance with BMO and over $4.4 million or 5% with Malaga Bank. Additionally, the investments under the City’s brokerage firm Stifel includes Certificates of Deposit (CD) investments over $29 million or 30%, Treasury Bills and Agency Bonds $8.5 million or 9% of the total cash balance, and a money market account has a balance of $70,677 or 1% of the total cash balance. The City holds a money market account with Stifel for transaction s related to the selling and purchasing of investments, as applicable. The securities are held by Bank of America and are FDIC- insured. 1 In summary, the City’s General Fund has over $30 million or 32% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $37 million or 39% of cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $3 million or 4%, over $2 million or 3% in the 1911 Act Fund, over $0.2 million or less than 1% in the Habitat Restoration Fund, approximately $0.2 million or less than 1% in the Quimby Fund, and over $22 million or 23% in Other Restricted Funds. Compared to the December 2022 balance, the City’s cash balance increased by over $3 million, primarily due to the increase in revenue sources. This increase is expected and aligns with the Fiscal Year 2023-24 adopted budget for revenues. Additionally, while comparing the balance in November 2023, the City’s cash balance increased by $3.5 million, mainly attributed to the timing of billing for general services and disbursements for City-approved projects. The major disbursements for this month included Aleshire and Wynder for legal services, Hardy and Harper for annual right-of- way maintenance program, Hout Construction for Portuguese Bend area landslide services, Iteris Incorporate for the comprehensive traffic study at Western Avenue, J.F. Prieto Engineer for Abalone Cove area emergency repairs, Nuvis for landscape architecture services for the Western Avenue Beautification Project, Ron’s Maintenance for stormwater cleaning at the catch basin area, and Transtech Engineers for building plan check services. All expenditures were disbursed in accordance with the FY 2023-24 budget. 2 BEGINNING BALANCE PLUS : DEPOSITS PLUS : INTEREST EARNINGS(1) LE SS : CHECK DISBURSEMENTS LESS : ELECTRONIC DISBURSEMENTS(2) ADJUSTMEN TS(3) PLUS: TRANSFERS IN LESS: TRANSFERS OUT ENDING BALANCE (1) AU LAIF interest is paid quarterly. (2) Electronic Disbursements : Payroll Payroll Charges Postage Bank and Merchant Fees BMO Operating 2,566,228.10 5,972 ,531.41 (1,728,954 .35) (780,820 .81) (3,767 .00) 3,000 ,000 .00 (5 ,000,000.00) 4,025 ,217 .35 500,323.28 266 ,874 .52 3,000.00 10,623.01 780,820.81 (3) The net adjustment was due to a returned item and other adjustment. CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT DECEMBER 2023 Petty Cash 5,000 .00 5,000 .00 LAIF-CITY 47 ,724 ,461 .20 5,000 ,000.00 (3 ,000,000.00) 49 ,724,461 .20 Ma laga Bank Non -Negotiable co 4,447,871 .01 4,447 ,871.01 Stifel Stifel Money Market In vest ment 235,553 .39 37 ,544,000.00 (164 ,876.60) 250,000.00 70 ,676.79 37,794 ,000.00 DECEMBER 2023 CASH BALANCE BY MAJOR FUNDS 0% 0% Total Cash 92,523 ,113.70 5,972 ,531.41 (1 ,728,954 .35) (780,820.81) 81 ,356 .40 8,000,000.00 (8,000 ,000.00) 96,067 ,226.35 ■GENERAL FUND 32% ■CI P 39% ■ EQUIPMENT REPLACEMENT 4% m1911 ACT 3% C HABITAT RESTORATION 0% CQUIMBYO% COTHER RESTRICTED FUNDS 23% A-1 CAS H BALANCES BY FUND Unrestricted GENERAL FUN D Restricted bv Council Action BEAUT IFICATION FUND CIP EQUIPMENT REPLACEMENT BUILD ING REPLACEMENT EMPLOYEE PENSION PLAN EMPLOYEE BENEFITS Subtotal Restricted by Law or External Agencies STREET MAINTENANCE 1972 ACT GAS TAX-SB1 EL PR ADO CDBG CDBG-R 1911 ACT SOLID WASTE AIR QUALITY MANAGEMENT PROPOSITION C PROPOS ITI ON A PUBLIC SA FETY GRANTS MEASURER MEASURE M HABITAT RESTORAT ION SUBREGION 1 MAINTENANCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTRICT RPVTV GINSBURG CULTURE ARTS BUI LDI NG DON OR RESTRICTED CONTRIBUTIONS FEDERAL GRANTS STATE GRANTS FEDERAL GRANTS-ARPA QUIMBY LOW-MODERATE IN COME HOUSING AFFORDAB LE HSNG IN LIEU EET MEASURE A CAP ITAL BIKEWAYS UNDERGROUND UTILITIES RO A DWAY BE AU TIFICA TION MEASUREW WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OB LI GATION RETIRE IMPR OVEM ENT DISTRICT 9 SPECIAL TRUSTS Subtotal GRAND TOTAL CITY OF RANCHO PALOS V ERDES MONTHLY TREASURER'S REPORT DECEMBER 2023 BALANCE FORWARD DEBIT CREDIT 27,978,538.6 5 15,729,301.47 13,252,373.31 0 .00 0.00 0 .00 36 ,776 ,815 .61 1,207 ,754.32 846,263.27 3,260 ,287 .74 70 ,831.95 12 ,149.62 0.00 0.00 0.00 1,161 ,347 .54 3,226.34 0.00 0.00 0.00 0.00 41,198,450.89 1,281,8 12.61 858,412,89 782 ,778.17 104,957 .17 193,370 .92 30,394 .52 84.44 0.00 1,746 ,181 .17 81 ,161.43 0.00 48 ,092 .37 1,458 .38 0.00 6 ,592.26 0.00 0.00 0 .00 0 .00 0 .00 2,370,540 .68 342 ,003.52 22 ,773.93 341,663 .56 3,273.29 9 ,847 .00 38 ,887 .46 108.03 0.00 348,120.80 77,014 .73 0.00 2 ,263 ,813.88 97 ,970 .25 0.00 120,386.46 3 1,231.94 42,500.00 2,666,049 .13 64,438 .59 2,625 .76 698 ,627.06 1,899.66 55,595.70 113,585 .93 140,185.47 0 .00 767 ,532 .06 17 ,148.20 1,990.47 99 ,563.48 20,938.58 25 ,000 .00 25,175.79 41 ,821.48 16,321.3 1 0.00 0.00 0.00 0 .00 0 .00 0 .00 894 ,691 .41 2,485.69 474.43 0 .00 0.00 0.00 1,550 ,645.01 5,157 .34 14 ,265.00 4,655 ,392 .97 13,007 .54 0 .00 199,990.95 555.59 0.00 385,892 .20 1,072.05 0.00 903 ,639 .20 2,510.40 0.00 86,037 .77 239 .02 0.00 0 .00 0.00 0 .00 0 .00 0.00 0.00 0 .00 0.00 0.00 0.00 0.00 0 .00 876 ,297 .34 2,430.11 26 ,95 1.50 0.00 0.00 0.00 285,245.53 792 .44 0.00 0 .00 0.00 0.00 1,040,307 .00 11 ,028 .00 9,472.55 23,346,124.16 1,064,973.34 421,188.57 92,523,1 13.70 18,076,087.42 14,531 ,974.77 Tota l Investment: Change In Change In Ending Cash Ending Cash CASH Balance Balance in% 30,455,466 .81 2 476,928 .16 9% 0.00 0.00 0% 37 ,138,306.66 361,491 .05 1% 3,318 ,970.07 58 ,682 .33 2% 0.00 0.00 0% 1,164 ,573 .88 3,226.34 0% 0 .00 0.00 0% 41,621,85 0,61 423,399.72 1% 694 ,364.42 (88 ,413.7 5 -11% 30,478.96 84.44 0% 1,827 ,342 .60 81 ,161.43 0% 49 ,550.75 1,458.38 3% 6 ,592.26 0 .00 0% 0.00 0.00 0% 2 ,689,770.27 319,229.59 13% 335,089 .85 (6 ,573 .71 -2% 38 ,995.49 108.03 0% 425 ,135.53 77 ,014.73 22% 2,361 ,784 .13 97,970.25 4% 109,118.40 (11 ,268.06 -9% 2,727 ,861 .96 61,8 12 .83 2% 644,931.02 (53,696 .04) -8% 253,771.40 140,185.47 123% 782 ,689 .79 15,157.73 2% 95 ,502.06 (4 ,061.42) -4% 50,675.96 25 ,500 .17 101% 0.00 0.00 0% 0.00 0.00 0% 896,702 .67 2,011 .26 0% 0.00 0.00 0% 1,541 ,537 .35 (9 ,107.66) -1% 4,668,400 .51 13,007 .54 0% 200,546.54 555 .59 0% 386,964.25 1,072.05 0% 906 ,149.60 2,5 10.40 0% 86 ,276.79 239.02 0% 0.00 0.00 0% 0.00 0.00 0% 0.00 0 .00 0% 0 .00 0.00 0% 851 ,775 .95 (24 ,521 39 -3% 0 .00 0 .00 0% 286 ,037 .97 792.44 0% 0.00 0 .00 0% 1,041 ,862.45 1,555.45 0% 23,989,908.93 643,784.77 3% 96,067,226.35 3,544,112.65 4% 96,067,226.35 A-2 Investment Local Agency Investment Fund (LAIF-CITY) Note (1) CD -Non-Negotiable CO -Non-Negotiable Issuer of Investment State of California Malaga Bank Malaga Bank CD -Bank of America -Stifel (Non-Negotiable) A+ Fed Credit Union Austin Advia Cr Un Alaska USA Fed Ce Un Alliant Credit Union American Expr Natl Bank American First Cr Un Arsenal Credit Union Auburn State Bank Austin Telco Fed Cr Union AXOS Bank Bank of Baroda Bank Forward Bank Hapoalim Bankers Bank BankNewport Rhode Bankunited Baxter Credit Union Baycoast Bank Beal Bank USA BMW Bank of Northern America Capital One Capital One Celtic Bank Centris Fed Cr Un Chief Finl Fed Cr Un Rochester Chief Finl Fed Cr Un Rochester Coastlife Credit Union Comenity Capital Bank Community West Cr Un Communitywide FCU Connectone Bank Connexus Credit Union County School FCU Credit Un of Tex Allen Dannemora Fed Cr Un Dart Bk Mason Dept of Labor Fed Cr Un Discover Bank Dort Financial Cr Union Eaglemark Savings Bank Empower Credit Union Evansville Teachers FCU Farmers Ins. Group FCU Farmers&Merchants Bank Farmers State Bannk First Bank Blue Earth First Comwl Fed Cr Union First Federal S&L First lndpt Bank First Nat'I Bank First Natl Bank/DAMA Flushing Bank Four Pts FCU Omaha Generations Bank GESA Cr Union GHS Fed Credit Union Greenstate Credit Union Hapo Cmnty Cr Un !ntercredit Bank NA Insight Credit Union JP Morgan Chase Bank Kemba Finl Credit Union Lebanon FCU PA Liberty First Cr Un Lincoln Park Cmnty Cr Un Live Oak Bankinig Magnolia Bank Malaga Bank FSB CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT DECEMBER 2023 CUSIP# 00224TA82 00782JAC6 011852AH3 01882MAH5 02589ABM3 02616ABX6 04288LM6 05059LAC6 052392BN6 05465DAK4 06063HMT7 062163BN9 06251A2Q2 06610RBL2 06647JAV6 066519QK8 07181JABO 072727AZ3 07371CK32 05580AB45 14042RQBO 14042RQS3 15118RUX3 15643VA88 16863LA81 16863LAE5 19058LABO 20033A3A2 20416JAC8 20416TAV4 20786ADL6 20825WAT7 22258JA87 22551KA88 236334ADO 237412ASO 24951AAD8 254673870 25844MADO 27004PCM3 291916ABO 299547BC2 30960QAM9 307811DP1 310567AG7 32114MAY3 31982NAA4 32022EAW6 32056VAM9 32110YXG5 32117BEQ7 34387AFF1 35089LAD5 37149CAX5 37424PAH7 36266LM4 39573LDC9 41138NA84 458657MC4 45791JACO 48128UMX4 48836LAN2 52248LAB2 530520AM7 534574AC2 538036UG7 559582AL5 56102AAJ5 Acquisition Date NIA 2/18/2023 2/18/2023 6/29/2022 9/27/2023 3/22/2023 11/15/2023 3/3/2022 3/30/2023 1/20/2024 3/31/2022 9/21/2022 3/26/2020 7/22/2020 12/28/2019 12/14/2020 4/13/2022 8/3/2022 3/5/2021 6/23/2022 1/24/2020 3/9/2022 7/23/2021 11/17/2021 4/20/2022 4/17/2020 5/24/2023 7/29/2022 10/12/2022 2/13/2023 4/14/2022 12/23/2022 12/8/2022 9/24/2021 5/26/2022 2/22/2023 7/22/2022 12/28/2023 6/21/2022 9/14/2023 4/27/2022 10/28/2022 3/2/2022 9/29/2023 2/6/2023 1/1/2023 1/14/2022 11/14/2022 10/21/2022 8/8/2023 12/29/2021 8/23/2023 6/24/2022 12/30/2021 11/4/2022 6/29/2022 5/12/2022 7/31/2023 9/15/2022 1/26/2023 8/31/2023 1/31/2022 2/27/2023 9/30/2020 9/21/2022 8/4/2022 8/29/2023 8/28/2023 2/1/2022 10/30/2020 5/29/2020 Term N/A 6Mos 6 Mos 60 Mos 60 Mos 36 Mos 60 Mos 36 Mos 36 Mos 12 Mos 48 Mos 24 Mos 48 Mos 60 Mos 60 Mos 60 Mos 42 Mos 48 Mos 60 Mos 36 Mos 60 Mos 48 Mos 36 Mos 60 Mos 60 Mos 60 Mos 24 Mos 60 Mos 36 Mos 36 Mos 60 Mos 30 Mos 36 Mos 60 Mos 36 Mos 55 Mos 36 Mos 60 Mos 42 Mos 36 Mos 36 Mos 24 Mos 60 Mos 60 Mos 12 Mos 13 Mos 60 Mos 36 Mos 30 Mos 24 Mos 60 Mos 60 Mos 60 Mos 60 Mos 36 Mos 60 Mos 60 Mos 36 Mos 60 Mos 27 Mos. 42 Mos. 60 Mos 24 Mos 60 Mos 60 Mos 60 Mos 48 Mos 60 Mos 48 Mos 54 Mos 60 Mos Maturity Date On Demand 2/21/2024 2/21/2024 6/29/2027 9/27/2028 3/23/2026 11/15/2028 3/3/2025 3/30/2026 1/21/2025 3/31/2026 9/20/2024 3/26/2024 7/22/2025 12/18/2024 12/25/2025 10/14/2025 8/3/2026 3/5/2026 6/23/2025 1/24/2025 3/4/2026 7/23/2024 11/17/2026 4/20/2027 4/17/2025 5/24/2025 7/29/2027 10/14/2025 2/12/2026 4/14/2027 6/23/2025 12/8/2025 9/27/2026 5/27/2025 9/30/2027 7/22/2025 12/28/2028 12/22/2025 9/14/2026 4/28/2025 10/28/2024 3/2/2027 9/29/2028 2/5/2024 1/18/2024 1/14/2027 11/14/2025 4/21/2025 8/8/2025 12/29/2026 8/30/2028 6/24/2027 12/30/2026 11/4/2025 6/29/2027 5/12/2027 7/31/2026 9/15/2027 4/29/2025 2/26/2027 1/29/2027 2/24/2025 9/30/2025 9/21/2027 8/4/2027 8/30/2027 8/28/2028 2/2/2026 4/30/2025 5/29/2025 Market Value 49,724,461 250,000 4,197,871 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 $ $ $ $ $ $ $ $ $ $ $ $ Book Value 49,724,461 250,000 4,197,871 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 Yield 3.93% 4.00% 4.00% 3.55% 5.07% 5.15% 5.34% 1.80% 5.05% 5.10% 2.10% 3.70% 1.65% 0.65% 1.75% 0.50% 2.05% 3.50% 0.65% 3.10% 1.70% 1.90% 0.50% 1.10% 2.80% 1.50% 5.02% 3.50% 4.60% 4.65% 2.65% 5.00% 5.00% 0.80% 3.00% 4.40% 3.30% 5.30% 3.10% 5.60% 2.80% 4.60% 2.00% 5.15% 3.30% 5.00% 1.20% 5.00% 4.45% 5.50% 1.05% 5.30% 3.25% 1.25% 4.70% 3.40% 3.10% 5.25% 3.80% 2.65% 5.00% 1.35% 5.10% 0.50% 4.10% 3.55% 5.00% 5.00% 1.25% 0.40% 0.70% A-3 CITY OF RANCHO PALOS VERDES MONTHLY TREAS URER'S REPORT NOVEMBER 2023 Issuer of Acquisition Matu rity Market Book Investment In vestment CUSIP# Date Term Date Va lue Val ue Yield Marlin Business Bank 57116ATM0 1/15/2020 60 Mos 1/15/2025 250 ,000 250,000 1.75 % Midflorida Cr Union 59741QAA0 7/26/2023 60 Mos 7/26/2028 250 ,000 250,000 5.55% Mineo la Community Bank 60273NAB9 11/9/2022 60Mos 11/9/2027 250 ,000 250,000 5.10% Money One FCU 60936TAL3 9/14/2023 60 Mos 9/14/2028 250,000 250 ,000 5.07% Morgan Stanley Bk 61690UK82 6/2/2022 36 Mos 6/212025 250,000 250 ,000 3.05% Mountain Amer Fed CR UN 62384RAL0 8/3 1/2022 36 Mos 8/29/2025 250,000 250 ,000 3.50 % Mutual First Fed Cr Union 62825MAA2 8/3/2023 24 Mos 8/4/2025 250,000 s 250,000 5.20% Nat'I Bank of Commerce 633368FJ9 1/19/2022 60 Mos 1/19/2027 250,000 $ 250 ,000 1.15% Nexbank 653344CD1 5/15/2023 24 Mos 5/15/2025 250,000 250,000 5.07 % New Yo rk Community Bank 649447UP2 6/3/2021 36 Mos 6/3/2024 s 250,000 250,000 0 .35% Numerica Credit Union 67054NBA0 11/4/2022 24 Mos 11/4 /2024 s 250,000 250,000 4.85 % Oklahoma Fed Credit Union 67886WAB3 11 /22/2022 24 Mos 11/22/2024 250,000 250,000 5.00% Old Dominion Nat ;I Bank 679585AZ2 1/20/2022 60 Mos 1/20/2027 250,000 250 ,000 1.15% Old Mission Bank 68002LCN6 4/29/2022 54 Mos 10/29/2026 250,000 250 ,000 2.65% Onpath Fed Cr Union 68283MAG1 9/15/2022 60 Mos 9/15/2027 250,000 250,000 3.80% Pacific Western Bank 69506YWM7 317/2023 60Mos 317/2028 250,000 s 250 ,000 5.15% Pathfinder Bank 70320KBR1 1/31/2022 60 Mos 1/29/2027 250 ,000 s 250,000 1.20% Pima Fed Cr Un 722000AC0 8/17/2023 36 Mos 8/17/2026 250 ,000 250,000 5.30% Pittsburgh City Hall 72500MAA3 8/16/2022 60 Mos 8/16/2027 250 ,000 250,000 3.60% Popular Bank 73317AAY8 4/13/2022 36 Mos 4/14/2025 250 ,000 250,000 2.45% Preferred Bank LA 740367MA2 7/17/2020 60 Mos 7/17/2025 250,000 250 ,000 0.50% Raymond James Bank 75472RAN1 11/26/2019 60Mos 11/26/2024 250,000 250,000 1.85 % Rogue Credit Union 77535MAL7 1/20/2023 48 Mos 1/20/2027 250,000 s 250 ,000 5.05% Saco&Biddefords Savs 78577THR9 7/21/2022 60Mos 7/21 /2027 250,000 $ 250 ,000 3.45% same Mae Bank/Salt Lake 7954504P7 10/16/2019 60 Mos 10/16/2024 250 ,000 s 250 ,000 1.90% Sawyers Svgs Bank 805508BT4 10/28/2022 60 Mos 10/28/2027 250,000 $ 250,000 4.90% Sharonview Fed Cr Union 819866BM5 8/15/2022 36 Mos 8/15/2025 250 ,000 250 ,000 3.40% Signature Fed Cr Un 82671DAA5 10/27/2022 48 Mos 10/27/2026 248 ,000 248,000 4.60% Southwest Finl Fed Cr Un 84485EAJ6 9/21/2022 60 Mos 9/2 1/2027 250,000 250,000 3.80% State Bank of India 856285RS2 11/27/2019 72 Mos 11 /27/2024 250 ,000 250,000 2.05% St Lawrence Fed Cr Un 791125AC1 12/1/2023 60Mos 1211 /2028 250,000 250,000 5.69 % Texas Exchange Bank 88241T JJ0 10/23/2020 60 Mos 10/23/2025 250,000 250,000 0.60% Texas Exchange Bank 88241TJN1 11 /25/2020 60 Mos 11/25/2025 250,000 250 ,000 0.60 % Texas Exchange Bank 88241T JR2 12/18/2020 60 Mos 12/18/2025 250,000 s 250 ,000 0.60% Texas Excange BK SSB 88241TNV8 8/5/2022 51 Mos 11/16/2026 250 ,000 s 250,000 3.60% The Dist Cr Un 88340AAC5 1212212022 36 Mos 1212212025 250 ,000 s 250 ,000 5.25% Toyota Financial Svgs Bank 89235MLE9 7/29/2021 60Mos 7/29/2026 250,000 250,000 0.95% Truliant Fed Cr Un 89789AAE7 3/10/2023 30 Mos 9/10/2025 250,000 250,000 5.05% Trustone Finl Cr Un 89841MAF4 7/19/2022 60 Mos 7/19/2027 250,000 250,000 3.40% TTCU Fed Cr Union 89854LAK9 7/26/2023 60 Mos 7/26/2028 250,000 250 ,000 5.55% Tucson Fed Ce Un 898812AC6 9/8/2023 60 Mos 9/8/2028 250,000 250 ,000 5.00% UBS Bank USA 90348JN30 6/24/2021 36 Mos 6/24/2024 250,000 250,000 0.35% University Credit Union 914242AA0 2/21/2023 31 Mos 9/26/2025 249 ,000 249,000 4.00% United Bankers Bank 909557JP6 12/16/2021 56Mos 8/17/2026 s 250,000 250 ,000 1.00 % Valley Strong Cr Union 920133AJ4 12/14/2022 24 Mos 12/13/2024 250,000 250,000 5.10% Vision Bank of Iowa 92834CCL4 11/29/2019 72 Mos 11/29/2024 250,000 250,000 1.75% Workers Credit Union 98138MAT7 9/29 /2022 60 Mos 9/29/2027 250,000 250,000 4.50% Workers Credit Union 98138MAM2 4/17/2023 22 Mos 2/28/2025 249 ,000 249,000 1.49% Workers Fed Cr Un 98138MCB4 11/15/2023 60 Mos 11/15/2027 250,000 250,000 5.35% Treasury-Bank of New York(Vining Sparks) United States Treas 91282CEX5 6/30/2023 12 Mos 6/30/2024 1,000,000 1,000,000 3.00% United States Treas 9 12828XZ8 6/30/2020 GO Mos 6/30/2025 1,000 ,000 1,000 ,000 2 .75% United States Treas 91282CBC4 1/1212021 60Mos 12131/2025 2,000 ,000 2,000 ,000 0.38 % Agency Bonds Fed Farm Credit Bank 3133ELF41 6/8/2022 60 Mos 6/8/2027 1,000 ,000 1,000,000 0.94% Fed Farm Cred it Bank 3133EMZ21 8/6/2021 54 Mos 4/6/2026 1,000,000 1,000,000 0.69 % Fed Farm Credit Bank 3133ENYX2 6/17/2022 24 Mos 6/17/2024 500 ,000 500,000 3.25% Fed Farm Credit Bank 3133ENNX4 12115/2022 26 Mos 2114/2025 1,052 ,000 1,052 ,000 1.67% Fed Home Loan Bank 3130ASYR4 8/30/2022 36Mos 8/28/2025 1,000 ,000 1,000,000 4.00 % Total Investments 91,966,332 Summary: Local Agency Investment Fund (LAIF-CITY) 49 ,724 ,461 .20 Certificate of Deposit -Malaga Bank 250 ,000.00 Certificate of Deposit• Malaga Bank 4,197 ,871.0 1 Certificate of Deposit• Stifel 29 ,242,000.00 Treasury Bills -Stifel 8,552 ,000.00 Total Investments 91 ,966,332.21 BOW balance 4,025,217 .35 Petty Cash 5,000.00 Stifel money market 70 ,676.79 Total cash & investment 96,067,226.35 Total cash & investment from above 96 ,067,226.35 A-4 NOTE: M alaga Ba nk • CD 5% CITY OF RANCHO PALOS VERDES MONTH LY TREASURER'S REPORT DECEMBER 2023 SUMMARY OF CASH BALANCE BY INSTITUTION DECEMBER 2023 St ifel • Tr eas ury 9% Stifel • M o ney M arket 0% St at e of Ca lifornia -LAIF 52 % (1) LAIF market values will be reported to vary from book value if the City calculated share of total LAIF assets is less than the City book value . To the best of my knowledge , there are no misstatements of material amounts within this report ; or omissions of material amounts to cause the report to be misleading . I certify that this report accurately reflects au City investments and complies with the investment policy of the City of Rancho Palos Verdes as approved by the City Council. Furthermore. I certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months . Respectfully submitted , ~h Treasurer Dated A-5