Loading...
IA SR 20201201 C - IA October Treasurer Report IMPROVEMENT AUTHORITY MEETING DATE: 12/01/2020 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive and file the October 2020 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED IMPROVEMENT AUTHORITY ACTION: (1) Receive and file the October 2020 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, Accountant REVIEWED BY: Trang Nguyen, Director of Finance APPROVED BY: Ara Mihranian, AICP, Chief Administrative Officer ATTACHED SUPPORTING DOCUMENTS: A. Monthly Treasurer’s Report (page A-1) BACKGROUND AND DISCUSSION: The cash balances of the Improvement Authority decreased by $24,373 during the month, ending with an overall balance of $1,187,040 on October 31, 2020. The decrease was due to the operating expenses, which included disbursements to McGee Surveying Consulting for the dewatering well activities and to Southern California Edison (SCE) for utility bills. 1 BEGINNING BALANCE PLUS: DEPOSITS PLUS: INTEREST EARNINGS(!) LESS: CHECK DISBURSEMENTS LESS: ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS: TRANSFERS OUT ENDING BALANCE (1) AIILAIF interest is paid quarterly. (2) Electronic Disbursements: Payroll Payroll Charges Bank and Merchant Fees Bank of the W.ot Open ling 3,251 ,753.40 1 ,873,582.50 (3,684,821 .24) (870,687.49) 4 ,314.74 2,000,000.00 2 ,594,141 .91 523,735.00 338,221 .31 8,7 31 .18 870,687.49 (3) The net adjustment was due to void cheeks and petty cash transaction. CITY OF RANCHO PALOS VERDES MONTHLY T REASURER'S REPORT OCTOBER 2020 5,000.00 5,000.00 Mo llgo Bank Non-1-legoti.oble LAIF.CITY CD 34,059,619.46 4,224,963.35 73,389.22 13,949.82 (2,000,000.00) 32,1 33,008.68 4 ,238,913.17 Vining Sporb Mon.yMarbt 72,362.84 9,222.50 16,182.71 97,768.05 OCTOBER 2020 CASH BALANCE BY MAJOR FUNDS 1% Vining Sporllo In-TotoiCUI! 20,250,000.00 61 ,863,699.05 1 ,873,582.50 96,561 .54 (3,684,821.24 ) (870,687.49) 20,497.45 2 ,000,000.00 (2,000,000.00) 20,250,000.00 59,318,831 .81 .GENERA L FUND 30% YTDint -- 96,561 .54 96,561 .54 .EQUIPMENT REPLACEMENT 5 % .1911 ACT 2% J:I HABITAT RESTORATION 1% .QUIMBY2% .OTHER RESTR ICTED FUNDS 16% A-1 CASH BALANCES BY FUND Unrestricted GENERAL FUND Restricted by Council Action BEAUTIFICATION FUND CIP EQUIPMENT REPLACEMENT BUILDING REPLACEMENT EMPLOYEE BENEFITS Subtotal Restricted by Law or External Agencies STREET MAINTENANCE 1972ACT EL PRADO CDBG CDBG-R 1911 ACT SOLID WASTE AIR QUALITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLIC SAFETY GRANTS MEASURER MEASURE M HABITAT RESTORATION SUBREGION 1 MAINTENANCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTRICT RPVTV GINSBURG CULTURE ARTS BUILDING DONOR RESTRICTED CONTRIBUTIONS FEDERAL GRANTS STATE GRANTS QUIMBY LOW-MODERATE INCOME HOUSING AFFORDABLE HSNG IN LIEU EET MEASURE A CAPITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEAUTIFICATION WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OBLIGATION RETIRE IMPROVEMENT DISTRICT 9 SPECIAL TRUSTS Subtotal GRAND TOTAL BALANCE FORWARD 19,364,091 .35 0.00 25,981,658.40 2,631 ,496.18 0.00 0 .00 28,613,154.58 1 '1 05,585.37 28,884.78 36,331 .25 24,120.22 0 .00 1,405,392.52 451 ,588.22 152,761 .74 754,760.52 2,220,155.53 43 ,919.91 1,393,856.92 241 ,693.41 769,273.14 772,105.82 36,283.60 245,551 .71 0 .00 0.00 783,453.80 0 .00 0.00 1,202,021 .88 222,220.89 856,127.34 331 ,328.20 0 .00 0 .00 0 .00 0 .00 0 .00 3,192.02 0 .00 805 ,844.33 13,886,453.12 61 ,863,699.05 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2020 DEBIT CREDIT CASH 6,252,620.02 7,718,259.87 17,898,451 .50 0.00 0 .00 0.00 36,322.87 86,977.55 25,931,003.72 3 ,704.40 60,437.46 2,574,763.12 0.00 0 .00 0.00 0.00 0 .00 0.00 40,027.27 147,415.01 28,505,766.84 157,972 .95 506,814.82 756 ,743.50 40.83 0 .00 28,925.61 51.31 0 .00 36,382.56 10,000.00 16,506.66 17,613.56 0.00 0.00 0.00 2,032.30 21 ,534.27 1,385,890.55 13,792.14 21,804.80 443,575.56 209.69 9,110.00 143,861 .43 67,134.79 570.50 821 ,324.81 82,598 .90 789,299.36 1,513,455.07 77,488.98 0.00 121 ,408.89 51 ,403.78 22,108.48 1 ,423,152.22 57,048.51 63,548.80 235,1 93.12 1,109.37 0.00 770,382.51 1,089.93 7,288.05 765,907.70 74 .86 0 .00 36,358.46 360.78 5 ,201 .42 240 ,711 .07 0.00 000 0.00 0.00 0 .00 0.00 2 ,606.93 1,865.32 784,195.41 0.00 0 .00 0.00 13,992.17 13,992.17 0.00 1,699.40 0 .00 1,203 ,721 .28 314.17 0.00 222,535.06 1,210.38 0 .00 857,337.72 483.03 24,638.00 307,173.23 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 0 .00 0.00 4.51 274.88 2 ,921.65 0.00 0 .00 0.00 32 ,711 .75 42,713.58 795,842.50 575,431 .46 1,547,271 .11 12,914,613.47 6,868,078.75 9,412,945.99 59,318,831 .81 Total Investment: 59,318,831 .81 Change In Ending Cash Balance (1 ,465,639.85 0 .00 _(50 ,654.68 (56 ,733.06 0 .00 0 .00 (107,387.74 (348,841 .87 40.83 51 .31 (6,506.66 0 .00 (19,501 .97 (8,012.66 J8,900.31 66,564.29 (706,700.46 77,488.98 29,295.30 (6 ,500.29 1 '1 09.37 (6, 198.12 74 .86 {4,840.64 0.00 0 .00 741 .61 0.00 0.00 1,699.40 314.17 1,210.38 (24,154.97 0 .00 0 .00 0 .00 0 .00 0 .00 (270.37 0 .00 (10,001 .83 (971 ,839.65 (2,544,867.24 Change In Ending Cash Balance in% -8% 0% Oo/o -2% Oo/o Oo/o 0% -32% 0% Oo/o -27% 0% -1% -2% -6% 9% -32% 176% 2% -3% 0% -1% 0% -2% 0% 0% Oo/o 0% 0% 0% 0% 0% -7% 0% 0% 0% 0% 0% -8% 0% -1% -7% -4% A-2 Investment Local Agency Investment Fund (LAIF-CITY) Note (1) CD-Non-Negotiable CD -Non-Negotiable CD-Bank of New York -Vining Sparks (Non- Negotiable) Issuer of Investment State of California Malaga Bank Malaga Bank Allegiance Bank Texas Ally Bank American Bank Na Le Mars American Express Bank FSB American Express Centurion AXOS Bank BMW Bank North America Babin Bank of Deerfield Bank Forward Bankers Bank Madison WI Bar Harbor Bank & Trust Barclays Bank Delaware Baycoast Bank Business Bk of St. Louts CIT Bank Capital One Bank USA Cathy Bank Celtic Bank Community West Bank Continental Bank UT Crossfirst Bank Eaglebank East Boston Savings Bank Enerbank USA Exchange Bank Farmers&Merchants BKNEB First Bank of Highland First Commercial Bank MS First F inancial Bank First Federal SVGS Bank First Internet Bank of In First National Bank of America Flagstar Bank Goldman Sachs Bank USA Henry County Bank OH lndustriai&Com Bank China JP Morgan Chase Bank LCA Bank Corp La keside Bank Landmark Community Bank MAGBNC Malaga Bank FSB CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT OCTOBER 2020 CUSIPlJ 01748DAY2 02007GKW2 024373AZ5 02587CHR4 02587DN38 05465DAK4 05580ASE5 06063HMT7 061785EG2 062163BN9 06610RAT6 066851WV4 06740KKD8 072727AZ3 12325EHV7 12556LBB1 14042TBD8 149159NX9 15118RUX3 20415QGX1 211163GYO 22766ABBO 27002YET9 27113PBM2 29266N6P7 301074DF4 30781TBD9 319141GE1 31984GFA2 32021 MFC8 32031YCD4 32056GCQ1 32110YJT3 33847E2JS 38149MAU7 426336BF9 45581EAF8 48128UMX4 801798LK6 51210SMD6 51507 LBV5 559582AL5 56102AAJ5 Aequi•ition Date N/A 212312020 212312020 1113/2017 7/25/2019 9/27/2019 12/19/2017 3/21/2017 3/26/2020 8116/2019 7/22/2020 9/25/2019 12/2812019 12/20/2017 6/2812019 7/12/2017 1/24/2020 7/19/201 7 8/23/2019 7/24/2019 9/25/2019 4/17/2020 7126/2019 2/23/2018 6/9/2017 1/1712020 1/20/2017 10/13/2017 7/19/2019 1/18/2017 617/2017 7/31/2019 2/21/2018 1/17/2018 7/14/2017 1/20/2017 6/12/2019 5/31/2019 112712017 6/2/2017 9/30/2020 1/12/2018 1/13/2017 8/23/2019 10/30/2020 5/29/2020 Tenn N/A 24 Mas 24 Mas 60 Mas 36 Mas 36 Mas 48 Mas 60 Mas 48 Mas 18 Mas 60 Mas 4 2 Mas 60 Mas 48 Mas 24 Mas 60 Mas 60 Mas 60 Mas 30 Mas 36Mos 24 Mas 60Mos 18Mos 36 Mas 60 Mas 36 Mas 60 Mas 48 Mas 24 Mas 60Mos 60Mos 24 Mas 48Mos 37 Mas 60Mos 60 Mas 36 Mas 36 Mas 60Mos 60 Mas 60Mos 60 Mas 54 Mas 36 Mos 54 Mas 60 Mas On Demand 2/21/2022 2/21/2022 11/3/2022 7/25/2022 912712022 12/20/2021 4/5/2022 3/26/2024 2/16/2021 7/22/2025 3/24/2023 12/1812024 12/20/2021 6/28/2021 7/12/2022 1/24/2025 7/19/2022 2/23/2022 712512022 9/24/2021 4/17/2025 1/26/2021 8/23/2021 6/9/2022 1/17/2023 1/20/2022 10/13/2021 7/19/2021 1118/2022 617/2022 7/30/2021 2/22/2022 2/17/2021 7/1 4/2022 1/20/2022 6/13/2022 5/31/2022 112712022 6/2/2022 9/30/2025 1/12/2023 7/13/2021 2/23/2022 4/30/2025 5/29/2025 Market Value $ 32.133,009 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 250,000 3,988,913 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 250,000 250,000 250,000 250,000 250 ,000 250,000 250,000 250,000 250,000 250,000 250,000 Book Value Yield $ 32,133,009 0.62% $ 250,000 1 50% $ 3,988,913 1.40% $ 250,000 2.20% $ 250,000 2.15% $ 250,000 1.65',0 $ 250,000 2.20% $ 250,000 2.45% $ 250,000 1.65% $ 250,000 1.90% $ 250,000 0.65% $ 250,000 1.65% $ 250,000 1.75',0 $ 250,000 2.15% $ 250,000 2.10% $ 250,000 2.20% $ 250,000 1.70% $ 250,000 2 05% $ 250,000 1.95% $ 250,000 2.10% $ 250,000 175% $ 250,000 1.50% $ 250,000 1.95% $ 250,000 2.30% $ 250,000 2 .05% $ 250,000 1.70',0 $ 250,000 2 00% $ 250,000 2.00% $ 250,000 2 05% $ 250,000 2 .05% $ 250,000 2.10% $ 250,000 1.95% $ 250,000 2.45% $ 250,000 2 .15',0 $ 250,000 2.05% $ 250,000 2 00% $ 250,000 2 50% $ 250,000 2.50',0 $ 250,000 1. 90% $ 250,000 2 05',0 $ 250,000 0.30% $ 250,000 2 .35% $ 250,000 1.95',0 $ 250,000 1.90% $ 250,000 0.40% $ 250,000 0.70% A-3 Investment Treasury-Bank of New York(Vining Sparks) Summary: Local Agency Investment Fund (LAIF-CITY) Certificate of Deposit -Malaga Bank Certificate of Depos1t -Malaga Bank Certificate of Deposit -Vining Sparks Treasury Bills-Vining Sparks Total In vestment Issuer of Investment Marlin Business Ban k Medallion Bank Utah Mercantil Bank NA Merrid< Bank Mid-Missouri Bank Morgan Stanley Bank NA Morgan Stanley PVT Bank Morton Community Northfiled Bank Peoples United Bank Preferred Bank LA Raymond James Bank Sallie Mae Bank/Salt Lake Signature Bk Chicago Southern States Bank State Bank of India State Bank of Chilton Sterling Bank POP BL MO Summit Community Bank Synchrony Bank BKCROW Thi rd Fed Sav&Ln Clevland Vision Bank of Iowa Wellesley Bank W e lls Fargo Nat' I Bank West Wells Fargo Bank United States Treas United States Treas United States Treas 32,133,008.68 250,00000 3,988,91 3.17 17,2 50,000.00 3,000,000.00 56,621 ,921 .85 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2020 CUStPfl 57116ATMO 58404DFE6 58733AES4 59013JC23 59541KBP1 61747MD73 61760AZ51 619165HP1 66612ABX5 71270QQJ8 740367MA2 75472RAN1 7954504P7 82669VBY6 843879882 856285RS2 85641PDV9 85916VDN2 86604XML7 87165HRY8 88241T JJO 88413QBU1 92834CCL4 94948LCRO 949495AQ8 949763D45 91 2828S35 912828S76 912828XZ8 Acquiaition Doh! 1115/2020 9/18/2019 12/29/2017 10/1112017 1/19/2018 12/21/2017 9/19/2019 1119/2018 10/25/2017 1/18/2017 7/17/2020 11/26/2019 11116/2019 1118/2017 1212012017 11/27/2019 9/1112020 9/18/2019 1126/2018 6/2/2017 10/23/2020 11/24/2017 11/29/2019 7/19/2019 1117/2020 6/10/2019 9/12/2019 7/31/2018 6/3012020 Tenn 60 Mos 36 Mos 36 Mos 60 Mos 60 Mos 36 Mos 48 Mos 36 Mos 60 Mos 60 Mos 60 Mos 72 Mos 60 Mos 60 Mos 40 Mos 72 Mos 60 Mos 48Mos 30Mos 60 Mos 60 Mos 48 Mos 72 Mos 18 Mos 36 Mos 36Mos 45 Mos 36 Mos 60Mos 1/15/2025 9/1912022 12/29/2020 10/1112022 1/19/2023 12/2112020 9/19/2023 1/19/2021 10/25/2022 1118/2022 7/17/2025 11/2612024 10/16/2024 111812022 4/20/2021 11127 /202 4 9/1112025 9/18/2023 7/26/202 1 6/2/2022 10/23/2025 11/24/2021 11129/2024 1/19/2021 1/1 7/2023 6/10/2022 6/30/2023 7/31/2021 61301202 5 Total Investment $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 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 1,000.000 1,000,000 1,000.000 Book Value Yield $ 250,000 1.75'Ao $ 250,000 1.70% $ 250,000 2.20% $ 250,000 2.10% $ 250,000 2.35% $ 250,000 2.15% $ 250,000 1.85% $ 250,000 2.15% $ 250,000 2.15% $ 250,000 2.05% $ 250,000 0.50% $ 250,000 1.85% $ 250,000 1.90% $ 250,000 2 .15% $ 250,000 2 00% $ 250,000 2.05% $ 250,000 0.50% $ 250,000 1.65% $ 250,000 2.20% $ 250,000 2.40% $ 250,000 0.60% $ 250,000 2.10% $ 250.000 1.75% $ 250,000 2.00% $ 250,000 1.90% $ 250,000 2 .50% $ 1,000,000 1.38% $ 1,000,000 1.13% $ 1,000,000 2.75% $ 56,621 ,922 Weighted Return 1.12% A-4 NOT E: Malaga Bank -CD 7% CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2020 SUMMARY OF CASH BALANCE BY INSTITUTION OCTOBER 2020 Vining Sparks-Treasury Bank of the West Vining Sparks -Money Market 0% 5% 5% State of California -LAIF 54% (1) LAIF marl<et valuas will ba reported to vary from book value if the City calculated share of total LAIF assets is less than the City book valua. To the bast of my knowledge, there are no misstatements of material amounts within this nsport; or omissions of material amounts to cause the nsport to ba misleading. I certify that this nsport accurately reflects all City investments end complies with the investment policy of the City of Rancho Palos Verdes as approved by the City Council. Furthermore, I certify that SUfficient invastment liquidity and anticipated revenues are available to meet the City's expendituns requirements for the next six months. Respectfully submiHed, A-5