Loading...
CC SR 20230919 C - CC July 2023 Treasury Report CITY COUNCIL MEETING DATE: 09/19/2023 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the July 2023 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the July 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, Interim Director of Finance 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 July 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 over $97.1 million with $55.7 million or 57% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has over $2.6 million or 3% of the total cash balance with Bank of the West 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 approximately $26 million or 26%, Treasury Bills and Agency Bonds over $8.5 million or 9% of the total cash balance, and a money market account at over $15,661 or less than 1%. The City holds a money market account with Stifel for the transaction of selling and purchase purposes. The securities are held by Bank of America and are FDIC-insured. 1 RANCHO PALOS VERDES V (L In summary, the City’s General Fund has over $32 million or 34% in the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $35 million or 37% in cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $3 million or 3%, over $2 million or 3% in the 1911 Act Fund, approximately $0.2 million or less than 1% in the Habitat Restoration Fund, approximately $0.3 million or less than 1% in the Quimby Fund, and over $22 million or 23% in Other Restricted Funds. The City’s cash balance increased by $2.3 million compared to the July 2022 balance. The increase was reported in the prior month, which included the significant fund from the second payment of the American Rescue Plan Act of $4.9 million received in July 2022 and $8 million from Bank of the West for the partial funding of the Ladera Linda Community Park Project in April 2022. Additionally, while comparing the balance in June 2023, the City’s cash balance decreased by $2 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, AMG and Associates for the Ladera Linda Community Park construction project, Fire Grazers for the goat grazing fuel modification project, Geosyntec Consultant for the Peninsula Coordinated Integrated Monitoring Program (CIMP) implementation of storm water, Hardy and Harper for the roadway maintenance project, the Los Angeles County Sheriff’s Department for law enforcement services, and Tyler Technologies for accounting software annual subscription. All expenditures were disbursed in accordance with the Fiscal Year 2023- 24 budget. 2 A-1 BEGINNING BALANCE PLUS: DEPOSITS PLUS. INTEREST EARNINGS(1) LESS· CHE CK DISBURSEMENTS LE SS· ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(J) PLUS TRANSFERS IN LESS: TRANSFERS OU T ENDING BALANCE (l ) All LAIF lll1eres1 IS paid quarte (2} El1!1ctron1c Disbursements . Plll'fOII Pii'Yrc tl Charges 6.al'I~ iilld Merch1n1 F HI Cal~s LumJ:J Paymerrt. B;1nk of th ■ We■t Opera1jng 3 ,701 ,7 80.19 2 776 ,754 .65 (3 574 .667 67) (1,7 10,794 .09) (4 026.08) 2,000,000 00 (520,000 00) 2,669,047 00 418 ,010.06 243 ,967 .21 13 133 .82 1,035,683 00 1,710,794 09 CITY OF RANCHO PALOS VEROES MONTiiL Y TREASURER'S REPORT JULY 2023 LAIF ..C ITY 5,000 00 57 ,29 1 088 14 443.354 01 (2 ,000,000.00) 5,000 00 55 ,73-4 ,442 .15 1M.tl,ao:11 8an11; Non..ffegotl ■bl!! c□ 4,405,830 17 4,405 ,830 ,17 SU tel Stlfef Mone!f Mlilfket lnlifl!'.1,t ,rn1nl 185 ,105.55 33 .547 ,000.00 60 .555 .65 (750 □00 .00) 750 ,000.00 520 ,000 .00 15,661.20 J.4,297.000.00 (3) The net adJustmMt was. dUt! to voiid check a.na mlsceoane,ous aajustment J ULY 2023 CASH BALAN CE BY MAJOR FUNDS 0% 0% 99,135,804.05 2 ,776 ,754 .65 503.909.66 (3,5 7◄,667,67) (1,7 10,7 .... 09) (4 ,026 .08) 2 ,520 ,000.00 (2 ,520.000 .00) 97 .126 .980 52 ■GENERAL FUND 34% ■CIP 37% ■ EQUIPMENT REPLACEMENT 3% ■1911 ACT 3% Q HABrTAT RESTORATION 0% CI QUIMBYO% II OTHER RESTRICTED FUNDS 23% A-2 CITY OF RANCH O PALO S VERDES MONTHLY TREASURER'S REPORT JULY 2023 I Ct>anoe In Change In I BALANCE End in g Cash Ending Cash CASH BALANCES BY FUND FORWARD DEBIT CREDIT CASH Balance Bala nce in% Unresrncted GENERAL FUND S3 Slt,412.87 8,172,905.74 928Z,tt2.7t 32,779,325.82 (1.110,087.05) -3% Restricted bv Council Action BEAUTIFICATION FUND 0.00 0.00 000 0 00 0.00 0% CIP 36 ,969 ,232 ,09 166.254 .56 1,301 ,678 68 35,833 ,807 .97 (1,135,424 12 -3% EQU IPMENT REPLACEMENT 3,196 ,621 .74 14,179,95 2 778 12 3,208 ,023.57 11 ,401 ,83 0% BU ILDING REPLACEMENT I 0.00 000 000 000 0.00 0% EMPLOYE E PENSION PLAN 1,059,633.10 4,465.65 0,00 1,064 098 75 4,465 .65 0% EMP LOYEE BENEFITS I 0 .00 0 00 0 .00 0 ,00 0 ,00 0% Sutltolal 41,225,486.93 114,IIDG.15 1304455.IIG .0, 101,UO.zt 1111t,5H.M -3% Restricted by Law or Ex /em al Aoenc,es STREET MAI NTENANCE 2,157 ,6 11 .96 186,690 39 90,658 .20 2,253,844 15 96 ,232 .19 4% 1972 ACT I 30,018.56 135.00 0 00 30,153.56 135 00 0% EL PRADO I 47 ,261 66 263.53 000 47 ,525 .19 263 53 1% CDBG I 0 .00 228 ,508.00 228,508.00 0 00 0.00 0% CDBG-R 0 00 0,00 0.00 0.00 0.00 0% 1911 ACT I 2.412,972.55 23,968.33 18 ,484 ,67 2,418,456.2 1 5,483.66 0% SOLID WASTE 368,184.61 18 045 61 20 , 136,75 366 093.47 (2,091 14 -1% AIR QUALllY MANAGEMENT 51 ,535.13 205.80 14,290.37 37 ,450.56 (14,0S4 .57 -27% PROPOS ITION C I 544,525 12 93,745.55 81 ,78503 556 ,485.64 11 ,960.52 2% PR OPOS ITION A 2,195 991 .21 11 9,166.73 0.00 2 ,315,157 .94 119,166.73 5% PU BLIC SAF ETY GRANTS 24 ,48 2,64 297 49 0 00 24,780.13 297.49 1% MEASURER 2,472 ,760, 12 79 ,299 69 31,239 59 2 520,820 .22 48 ,060 10 2% MEASURE M 653,157 .69 79 059 09 22 ,388 76 709 ,828 .02 56,670 33 9% HABITAT RESTORATION I 196 , 169 ,98 1,00713 41 ,659 .00 155 ,518 11 (40,651 .87 -21% SUB REGION 1 MAI NT ENANCE 760 ,727 54 3,397 .74 2,481 33 76 1,643 95 9 16.4 1 0% MEASURE A MAIN TENANCE ) 123,051 17 590 87 0.00 123 642.04 59087 0% ABALONE COVE SEWER Dl$TRICT 72,628.33 1,43 1 82 13 791 06 60,269.07 (12 ,359.26 -17% RPVTV 0.00 0 00 000 0.00 0 .00 0% GINSBURG CULTURE ARTS BU ILD ING 0 .00 0 00 0 00 0 .00 000 0% DONOR RESTR ICTED CONTR IB UTIONS 858,623 .06 6.635, 16 1,102.43 864,15579 5.532 73 1% FEDERAL GRANTS I 0 ,00 000 000 000 0,00 0% STATE GRANTS 1,439.850.56 6,551 05 235.00 1,446 166,61 6 ,316.05 100% FEDERAL GRANTS-ARPA I 5,668 483.33 26,048 .44 22, 157 ,91 5,672 ,373.86 3,890,53 0% QUIMBY 292 ,863.21 1,494 21 39,327 62 255,029 ,80 (37 ,833 41) -13% LOW-MODERATE INCOME HOUSING 381 ,118 .95 1,714.00 000 382,832 .95 1 714 00 0% AFFORDABLE HS NG IN LIEU ) 882 ,190.32 3,967.46 000 686 ,157 78 3,967.46 0% EET 91 257 14 405 77 6 ,124.44 85 .538.47 15,7 1667) -6% MEASURE A CAP ITAL 0.00 0 00 000 0.00 0.00 0% BIKEWAYS 0,00 0 00 0 ,00 0,00 0 ,00 0% UNDERGROUND UTILITIES I 0.00 0 .00 000 0 .00 000 0% ROADWAY BEAUTIFICATION ! 0.00 000 0.00 000 0.00 0% MEASURE W I 940,776.66 4,368 .20 31 ,817 15 913,327 71 (27 ,446.95} -3% WATER QUALllY FLOOD PROTECTION 000 0 00 0.00 0,00 0 ,00 0% REDEVELOPMENT OBLI GATION RETIR E 262,839,08 478 43 0 00 283317.51 478 .43 0% IMPROVEMENT DISTRICT 9 I 0 .00 000 0 .00 000 000 0% SPECIAL TRUSTS I T,071 .B23 67 39,105.50 39 .773 .50 1,071 155.67 (66800) 0% Sul>IOlal I 24,020 .904.25 926 780,99 705,960.83 24 ,2A1 72A.41 220,820,16 1 % GRAND TOTAL I 99,135,804.05 9,21M,S88.89 11,293,410.42 97,128,980.52 (2,008,823.53) -2% Total Investment: 97, 126,980.52 A-3 CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT JULY 2023 IHUIHOf Ac:qul•ltlon M;iih,1rlty Markltt: Book lr'tllet1tft111tM ln~IHtmenl CUSIPt D:111• T•rm Omo V•lue Value Yl•ld I Loe.al Agency lnve,lment Fund (L.AlF..CITY) Stllte of C11ifom1a NIA NIA On Damar'ld 5S,7J4 442 55.7:i.,442 3 .31% No,o (1) CD -Non -N ego'C ia b!e Malaga B.ank 2118/2023 6MO$ 2/21/2024 250,000 250 000 4~ CO -Nan-Negot1atJle Malaga Banti. 2118/2023 6Mo, 2i21/2024 s 4,155,830 4,155,830 4.00% CD • 8 ,imk of America •Slife! (Non,-N gohable) A:+ Fed c,&0!1 union Ao.st,n 00224TI\B2 6/2912022 60Mos 6/29/2027 t 250,000 250,000 3.55% Alaska USA Fed Ce Un 011852AHJ 3122,2023 36Mos 3/2J/2026 $ 250,000 250,000 5 15"- American Expr Nltl Bank 02589ABM3 3/3/2022 36 Mos 313/2025 $ 250,000 250,000 1 80'l!, American Firsl Cr Un 02616ABX6 3/30/;.>023 l6Mo5 3130/2026 $ 250,000 s 250,000 5.05% Ar1en ■I C redtt Union 04288LAA6 1120/2024 12 Mos 112112025 $ 250,000 $ 250,000 5 10'!<. Auburn 51•te Bank 05059LAC6 3131/2022 48 Mos 313112026 $ 250,000 $ 250.000 2 10'11> A.1.1s!in Telco Fed Cr Union 0523928N6 !112112022 2.-Meis 912012024 250,000 $ 250 000 J 70'11> AXOS Bank 05465DAK4 3/2612020 48 Mo.s 3/26/2024 250,000 $ 250 ,000 1 65'11> BMW Bank o1 NOl'l:tiem """'"c., 05580A&t5 7'2312021 :l6Mos 712312024 $ 250 000 $ 250,000 0~ Ba nk ,cf Baroda 06D6JHMT7 7/2212020 60Mo5 1,2212025 s 250,000 $ 250 000 0 65'1. 8-ill~ Forwaro 062163BN9 12/2812019 60Mos 12/16/2024 250 000 250.000 175,i, Bank Hapoalim 06251A2Q2 12/1 412020 60Mos 12/2512025 I 250,000 250.000 05<!% 6ankers8i1t1k, 08610R BL2 .,,312022 -t2 Mos 10/1412025 s 250,000 250 D00 2-05o/. Ban«. Ne.,port Rhode 066,47 JAV6 81312022 4S ~OS Bll/2026 s 250 000 . s 250,000 3.50% B.ankunife<j 0665190KB 3/512021 60 ,..o, J/512026 $ 250,000 2~.000 065% Baxter Credit Union 07181JABO 6123/2022 36 Mos 6123!;.>025 s 250.000 $ 250 .000 3.10% Bily(;Oil$1 Baolit 072727AZJ 1J24f2n20 60 Mos 1124/2025 $ 250,000 s 250.000 170'14, Beal Bank USA 07371CK32 3/912022 ~8Mos 314/2026 $ 25<!,000 s 250.000 190'M> Califomal Credil un,on 130162AK6 J/2512023 7Mo• 10125/2023 $ 250,000 $ 250.000 450% Capital One 14042ROBO 11/1712021 60Mos 11/17/2026 s 250,000 $ 250,000 11~ Capital One 14042RQS3 4/2012022 60MO$ 4/2012027 $ 250 ,000 250,000 280 .. Ceftic Bank 151l6RUXJ 4117/2020 60Mo.s 4117/2025 $ 250,000 250,000 ,so,,, Chief Finl Fttd Cr Un Roch:e:iiter l6663LAB1 7/2912022 60Mos 712912027 250,000 250 000 3.Slllb Cllie! Finl Feo Cr Un RoctiHlet 16863L.AE5 10,1212022 3S Mos 10/1'412025 250,0D0 250 000 460o/. Cernris Fed Cr Un 1!164JVAB6 512412023 24 Mos 5124/2025 s 250,000 s 250,000 5112% Coasl1ife Creclit Umon 190511L.ABO 2i13,'2D23 36Mo, 2112/2026 s 250,000 $ 250 ,000 4 .65% Com~nity Capilal Bank 20033A3A2 4114/2022 60Mos 4/14/2027 t 250,000 250,000 265% C()!T)munit,, Wesl c, Un :10416JACB 12123/;.>022 30Mo• 6/2312025 25o,OOO $ 250,000 5.00% Commun1t)"ll'lde FCU 2041 6TAV• 1218/2022 36 !IA05 12/812025 250,000 $ 2!i0 ,000 500% Conn-eclone Bank 20786ADL6 !1124/2021 50Mos 9127/2026 250,000 250,000 080% C0011exu.s Credrt Union ,oa,5WAT7 512612():12 l6Mos 5/27/2025 250,000 s 250,000 300% County Sctlool FCU 22258JAB7 2122/2023 SS Mos 9/3012027 249 ,000 $ 249 ,000 440% Credil Un of Tex Allen 22551KAB8 7122/2022 36 Mos 1,2212025 250,000 $ 250,000 3:ioo,. Oan Bk Mason 237412A50 6/2112022 .C2 MO$ 12i22/2025 250 000 $ 250,000 31D'l' o,soover Bank 254673870 412712022 36 Mos 4/2812025 $ 250,000 $ 250,000 280'llo Don F'1nancl1I Cr Union 25844MADO 10/2812D22 24Mos 10/28/2024 $ 250.000 $ 250 000 480% Eagle,-nark Sav,ngs Bank 27004PCM3 312/2022 60Mos l/2/2027 $ 250.000 $ 250.000 2.00% EvansvUle Teachers FCU 299~7BC2 2,1;/2023 12 Mos 2/512024 $ 249,000 s 249 ,000 3.30% Farmers Ins. Group FCU 30960QAM9 11112023 13Mos 1 /1812024 s 250,000 s 250,000 500% Farmers&Merchants Bank J078110P1 111412022 60 Mo, 1114/2027 $ 250,000 250,000 1 20'14o Fa,mers Staie Bannk 310567AG7 1111412022 36 Mos 11 ,, .. ,2025 s 250,000 s 250,000 5.00% First Bank Blue Earth 32114MAY3 10/2112022 30 M<>S 4121/2025 $ 250,000 s 250,000 445'11, Fr~t Feda-r.11 1 S&L 32022EAW6 12129/2021 60 Mos 12/29/2026 250,000 s 250,000 1 05'11 First Nat'I Sank J2110YXG5 6124/2022 60 Mos 6/2412027 250 ,000 250,000 325% Fir1,t Natl Bank/OAMA 321178EQ7 12/30/2021 60 MO$ 12/3012026 250 .000 250,000 1 25'11 Flushmg Bank 3 •387AFF1 1114/2022 3i6 Mos 111412025 250 000 250 000 4 7°"' four P'ls FCU Om.aria 35069LAD5 612912022 80 MO$ 6/29/2027 250 000 250,000 341)'Jr. Generations Bank 37149CAX5 511 212022 60Mos 5112<2027 250 000 250,000 3 111% GESA Cr Union J7424PAH7 7131/2023 36Mos 7/31/2026 250 000 2SO 000 5 25'11 GHS Feel Ctedit Union 36266LAA4 911512022 60Mos "''~2027 2SO 000 250.000 3 so,; G<eenstate Cf'9C1if Union 39573lDC9 112612023 27Moi. 412!112025 249,000 2,9.000 265'14o lnterCftldl1 Bank NA 458657MC4 1131/2022 60Mos 11.29/2027 250.000 s 250,000 1 35% Insight Cre-di1 Umon 45791JACO 2i27l2023 2•Mos 2124/2025 250,000 $ 250,000 510% JP Morgan Chase Bank 48l28UMX4 !113012020 60 JldOS !l/30/2025 250,000 $ 250,000 0,50°M Kemba Finl Credi1 Union •M36lAN2 9/2112022 60 Mos 9121/2027 250,000 s 250,000 410% Lebanon FC U PA 52248LAB2 B/412022 60 Mos a1,12021 250,000 $ 250,000 J 55',<, Live Oak ~nlonlg 5JOOJ6UG7 2/1'2022 ,a Mos 21212026 250 ,000 250,000 125% Magnolia Bank 5595B2AL5 10/301:1020 5,4 Mos 4/30/2025 250 ,000 250,000 0 .,0% Malaga Ban.k FSB 56102AA.J5 5129/2020 60 Mos 51291'20:15 250 ,000 250 ,000 0 70',<, A-4 CITY OF RANCHO PALOS VEROES MONTHLY TREASURER'S REPORT JULY 2023 laauerot Acqul1itk>n Maturky M~rket Book !nw•tm.nt lnvw•ttnerit CUSIPI o ... Torm Dale VallW!i V.alu■ Ylold Ma nin Bus ines, 6Pn.~ 57116ATMO 1/18/2020 60Mos ,,,s1202s 250,000 250,000 1 75% Midflcrt(la Cr Union 59741QAAO 7126/2023 60 Mos 7/26/2028 s 250,000 250,000 s.w ,. M lneola Communtt:,, Bank so2nNAB9 11/912022 60 Mo, 11/9/2027 $ 250,000 250,000 510% Morgan Stant&y Bk 61690UK82 61212022 36MO$ Sf.212025 250,000 250,000 3.05,,. Morgan Stanley PVT Bank 61760AZ51 9/1912019 ,eMos 9119/2023 250 ,000 250,000 1 85 '11, Mountain Ame, Feel CR UN 62384RALO 8/31/2022 36Mos Brnl/2025 s 250,000 250,000 3.50'11, N~'I B•nk or commerce 633J66FJ9 1119/2022 GO Mos 1/19/2027 $ 250,000 s 250,000 1 15%. Next>ank 653344CD1 511512023 2.-Mos 8/18/2025 $ 250,000 250,000 507% New York Commuriit)' Bilnlc. 6494'7UP2 61312021 36Mos 613/2024 s 250,000 250,000 0.35% Numerica Credit UriiOn 670~N8AO 111412022 24 Mos 11 /"'2D24 s 2S0,000 250,000 4 85% Oklahoma Fe-0 Crl!!drt Union 678SSWABJ 1112212022 24 Mos 11122/2024 $ 250,000 250,000 5,00% 04d Dom1nio.i Natl Bal'lk 679585AZ2 112012022 60 Mos 1/2012027 $ 250,000 250,000 115% Old Mis$lon Bank 66002LCN6 4/2912022 S4 Mos 10/2912026 $ 250,000 250,000 265% On path Fed Cr Union 6828JMA01 911512022 60Mos 9/18/2027 s 250.000 $ 250 ,000 l BOS. Pacific Western Bsnlt 69SIJ6YWM7 31712023 60MOS 3/7/2028 250,000 $ 250,000 5 15'1!. Pathfinder &mk 70320KBR 1 1/3112022 60Mos 1/2912027 250 000 s 250 000 120'1', PrtlsDurgh Ctty ttal l 72500MAAJ 8/1612022 60 Mos !i/1612027 25D ODO s 250 000 3 60'1', Popular Ban.It 73317AAY8 4113/2022 36 Mos 4/1412025 250.000 $ 250,000 2.45 % Preferreti Bank LA 740367MA2 711712020 60 Mos 711712025 250 ,000 s 250 ,000 0 .50% Raymonci James Bank 75"172RAN1 1112612019 60 Mos 11/26/2024 250,000 250 ,000 1 85'1{, Rogue Cr~dit Union 77535WJ.7 112012023 48 Mos 1120/2027 250.000 250,000 5.05% Saco&Biddl!>ro,ds Savs 7B577THR9 712 112022 60Mo1, 7121 12027 s 250,000 250.000 3.45% Sallie Mae Bank/Sah Lake 79545041>7 10/1612019 60Mos 1011612024 $ 250,000 250,000 ,_ Snyers Sv11$ aank 8D55088T4 10/2812022 60Mos 10/2812027 $ 250,000 s 250,000 490'll, Sh.aronv1ew Fed Cr Un,on 819866BM5 811512022 36 Mos 8115/2025 250,000 $ 250,000 340% Soutl'\wHt Finl Fed Cr Un 84485EAJ6 912112022 60 Mas 9121 /2027 250.000 s 250,000 3 80% State Bank of lndla 856285RS2 1112712019 72 Moi 111271,024 250 ,000 $ 250.000 2.05% StMing Bani<. POP BL MO 85916VDN2 911812019 48 Mo$ 911812023 250 ,000 s 250,000 165% Texas E,;c.r.angl!! Bank 88241T JJO 10123/2020 60 Mos 10/2312025 250,000 250,000 0 .60"' Te>e.as Exchange Bank 88241TJN1 1112512020 60Mos 11/2512025 250,000 s 250,000 0 60% Tait.as Exchange Sank 88241TJR2 12/1812020 60Moa 12/18/2025 $ 250,000 $ 250,000 0 .60% Tex.as Excange 8K SSB 88241TNVB 8/512022 S1 Mos 11/16/2026 $ 250 .000 s 250,000 3 .60% Thi! OIsI C r Un BBJ.40AAC5 1212212022 36Mos 1212212025 $ 250,000 250,000 5 25'1', TcyD!a Frr,anci al Svgs Bank B9235MLE9 7129/2021 60 Mos 7f2Qf2026 250 aaa 250 ,000 0 95'1!. Tn.Jlla nt Fed Cf Un 89789AAE7 311012023 lO Mot. 9110/2025 250.000 s 250 ,000 5 05"' Tn.i~one Finl Cr Uf'I 898'1MAF4 711912022 60 Mos 7/1912027 $ 250 ,000 $ 250,000 HO% TTCU Ftcl Cr un,cn 898541..AK9 7/2612023 60 Mos 71 2612028 $ 250,000 s 250.000 5 55% UBS Bant USA 90J.48JN30 6124/2021 36 Mos 61241202• $ 250,000 250.000 035% University Credrt Unian 914242MO 212112023 l1 Mos 9/2612025 s 249.000 249,000 4 OO'lb United B•nkers Bank 909557JP6 1211 61202 1 56Mo, 8/1712026 250,000 s 250,000 1 00"" Valley Strong Cr Unian 92Q1JJAJ4 12114/2022 24 Mo1 12113/2024 250,000 250.000 511)"" Vision Bank or Iowa 928:i4CCL4 1112912019 72 Mo, 11/2912024 250 ,000 250.000 175% WOr'1U!lt$ c,ei:h! Uni on 98136W.TT 912912022 60 Moi 9/2912027 250 ,000 250 ,000 HD% Wcr11:1rs Crec:lil Union 981l8MAM2 411712023 22 Mos 212812025 249 000 249 ,000 H9% Treasury-Bank. of New Yotk(Vin1ng Sp rks) U nrteci Sla!es Treas 91282CEX5 6/3012023 12Mos 6/30 12024 s 1 000,000 1.000,000 300% Unrted Slates Trea5 912828XZ8 6/3012020 SO Mos 6/3012025 $ 1 000,000 s 1,000,000 275% Unrted s1a1es Trea.s 91282CBC<! 111212021 60Moa 1213112025 2 000 000 $ 2 ,000,000 0 _38% Agency BOild$ FM P::arm Ctl!IICll1 Bank 3133ELF41 61812022 60 Mo, 618/2 027 1.000.000 1 000,000 0,94% F eci Farm Credi1 Bank 3133EMZ21 81612021 5-.il MO$ 4161.l026 1.000.000 1.000.000 0 69% Fe,d Farm Credit Sarik 3133ENYX2 6117/2022 24 MO$ 6117/2024 500,000 500 000 3 25% Fed Ftrm Credit Bank 3133ENNX4 1211512022 26 MO$ 211412025 s 1.052_000 1,05.l.OOO 167"' F ed Home Loan Bank 3130ASYR4 8/3012022 36Mos 812812025 $ 1 000.000 s 1,000.000 400% Total Investments M.U7,2U Summary . Weighted Re1um 3.13% Local Ag&nC)' l nwe,tmt!mt Fund (LAIF"~ ITY) 55.73• ... 2 .15 Cer11fic:.a1e of Depos~ -~111laga Bank 250,000 .00 Cer1Jflca1e of D&posH. . Malaga Bank 4,.155 S30 .17 Cer1dieate of Oaposr1 -S11fe1 25,145.000.00 Treasury Bills -StifeJ B.552.000 00 Total lnvestrnems N 1,J7,271.U BOW ba l ince 2,669 ,047.00 PeilyCast> 5 ,000 00 Stifel men~ m,al'kel 15 661 20 Total c~s.n & mvHlm4!1'11 97 1:15 ,9~0 52 Total c.sh & m'iestment from above 97, 1'15 .980 .52 A-5 NOTE: Malaga Bank · CD 5% CITY OF RANCHO PALOS VERDES MONTHLY TREASURER"S REPORT JULY 2023 SUMMARY OF CASH BALANCE BY INSTITUTION JULY 2023 Stifel -Trea,sury 9% Bank of the West 3% Stih!I -Money Market 0% (1) LAIF marlc.et ,.,alues WI ii be repon d 10 'Yary from book. value if the City calculaled share o f ttnal LAIF .use1s Is less lhan ttle City book value To the be.JI of my knowledge, there are rio m1utatl!lments of matenal t1rnount5 within ttus report . ot omissions of rnateniill amoums to cauH t he report to be m,sleadi"g l c1rt1fy th ■l th1s repcrt acc:urate,ly ref'lect1 .all City lni'ntments and compllH with the mve ,tment policy ar the City of Rancho Palos Vereles as i!ippraved by the Cily Co\lnCII Furtrui,rmore, I cerlrfy mat 1utfic:ienl mve-slmll!lnl 11ciu1al1y and arrt1,e ipa1.e~ r'@'venuH are available to rneei. the City's expen-dn:ure reguire~nls for the next !mt mon1.h1 . Re!.pecifully submtlled . Dated