The URL can be used to link to this page

CC SR 20191203 C - October Treasurer ReportRANCHO PALOS VERDES CITY COUNCIL MEETING DATE: 12/03/2019 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA DESCRIPTION: Consideration and possible action regarding the October 2019 Cash Balances/Monthly Treasurer’s Report RECOMMENDED COUNCIL ACTION: (1) Receive and file the October 2019 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: Angelina Garcia, Interim Director of Finance APPROVED BY: Ara Mihranian, Interim 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 October 2019. A separate report is prepared monthly for the Improvement Authority, and is presented under separate cover before the Authority Commission. The overall cash balances of the City totaled $62,071,019, with more than $25.6 million or 41% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has more than $8.4 million or 14% of the total cash balance with Bank of the West, and over $4.1 million or 7% with Malaga Bank. In addition, the City has a total Certificates of Deposit (CD) investments and Treasury Bills over $22.9 million or 37% of the total cash balance and a money market account over $0.8 million or 1% with Vining Sparks, our investment brokerage firm. The securities are held by the Bank of New York and are FDIC-insured. In summary, the City’s General Fund has over $17.2 million or 28% in cash balance, and the Capital Improvement Projects (CIP) Fund has over $27.3 million or 44% in cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $2.6 million or 4%, over $1.4 million or 2% in the 1911 Act Fund, over $0.9 million 1 or 2% in the Habitat Restoration Fund, over $1.3 million or 2% in the Quimby Fund, and over $11 million or 18% in Other Restricted Funds. The City’s cash balance increased by $21,919 from last month, and in comparison to the same period last year, the cash balance improved by $0.7 million. The major variance was due to the timing of disbursements for City projects. The major disbursements for this month included Stay Green for the citywide landscaping maintenance project, Kasa Construction for the Conestoga Trail Project, Daniel B. Stephens for the Portuguese Bend Landslide Project, Colich & Sons, LP for the Storm Drain Improvement Project, Aleshire & Wynder for the legal services, Sunbeam Consulting for the various City projects, and Palos Verdes Peninsula Land Conservancy for the acacia removal in the Fuel Modification Project. All other operating expenditures were disbursed in accordance with the Fiscal Year 2019-20 budget. In addition to the monthly cash balance report, Staff is also presenting the final cash position as of June 30, 2019 after the completion of the Fiscal Year 2018-19 financial audit. The major changes included Vining Sparks year-end interest earnings and other normal year-end adjusting items. 2 A-1 BEGINNING BALANCE PLUS: DEPOSITS PLUS: INTEREST EARNINGS(1} LESS: CHECK DISBURSEMENTS LESS: ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS : TRANSF ERS OUT ENDING BALANCE (1} All LAIF interest is paid quarterly. (2} Electronic Oisbursements: Payroll Payroll Charges Petty Cash Reimb Sales Taxes Postage Bank and Merchant Fees Bank oftheWeat OPERATING 8,847 ,965.73 1,927,503.53 (1,491,153.71) (594, 781.19) (14,919.77) (250,000.00) 8,424,614 .59 353,003.21 226,640.92 694.00 3,037 .00 2,500.00 8,906 .06 594,781.19 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2019 Malaga Bank Non-*gatlllble VlningSporb PETlYCASH LAIF.CITY CD MoneyMarbt 5,000.00 25,450,733.61 4,165,129.92 630,270.64 179,460.13 15,810.47 250,000.00 5,000.00 25,630 ,1 93.74 4 ,1 80,940.39 880,270 .64 (3) The net adjustment was due to void checks, returned item, and other adjustments. OCTOBER 2019 CASH BALANCE BY MAJOR FUNDS 2% YTDINT IN\IESTMENT CD TOTAL CASH RECEIVED 22,950,000.00 62,049,099 .90 1,927.503 53 195,270.60 195,270.60 (1,491,153 .71) (594,781.19) (14,919.77) 250,000.00 (250,000.00) 22,950 ,000.00 62,071 ,019.36 195,270.60 .GENERAL FUND 28% • EQUIPMENT REPLACEMENT 4% .1911ACT 2% []HABITAT RESTORATION 2% .QUIMBY 2% .OTHER RESTRICTED FUNDS 18% A-2 BALANCE FORWARD CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2019 CREDIT CASH Total Investment: 62,071 ,019.36 Change In Ending Cash Balance Change In Ending Cash Balance in% A-3 Investment Local Agency Investment Fund (LAIF-CITY) Note (1) CD -Non-Negotiable CD -Non-Negotiable Issuer of Investment State of California Malaga Bank Malaga Bank CD-Bank of New York -V1n1ng Sparks (Non-Alleg1ance Bank Negot1able) Texas Ally Bank American Bank Na Le Mars American Express Bank FSB American Express Centurion BMW Bank North America Bank of Deerfield Bankers Bank Mad1son WI Bar Harbor Bank & Trust Barclays Bank Delaware Benef1c1al Bank Bus1ness Bk of St LOUIS CIT Bank Cap1tal One NA Cap1tal One Bank USA Cathy Bank Commun1ty West Bank Cont1nental Bank UT Crossf1rst Bank East Boston Savings Bank Enerbank USA Exchange Bank Farmers&Merchants BK NEB First Bank of Highland F trst Commercial Bank MS First F1nancial Bank First Federal SVGS Bank F1rst Internet Bank of In F1rst National Bank of America First Nat' I Bank M1ch1gan First Umted Bk & Trust Flagstar Bank Gold Cast Bank/Ch1cago Goldman Sachs Bank USA HSBC Bank USA Henry County Bank OH Independent Bk/Memphis lndustnai&Com Bank Ch1na JP MORGAN CHASE BANK LCA Bank Corp Lakes1de Bank CUSIPt 01748DAY2 02007GKW2 024373AZ5 02587CHR4 02587DN38 05580ASE5 061785EG2 06610RAT6 066851WV4 06740KKD8 08173QBT2 12325EHV7 12556LBB1 14042RDA6 14042TBD8 149159NX9 20415QGX1 211163GYO 22766ABBO 27113PBM2 29266N6P7 301074DF4 30781TBD9 319141GE1 31984GFA2 32021MFC8 32031YCD4 32056GCQ1 32110YJT3 32114VBJ5 33742CAQO 33847E2J5 38058KDM5 38149MAU7 40434YGK7 426336BF9 45383USK2 45581EAF8 48121C802 801798LK6 51210SMD6 CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT OCTOBER 2019 Acquisition Date N/A 2/23/2018 2/23/2018 11/3/2017 7/25/2019 9/27/2019 12/19/2017 3/2112017 8/16/2019 9/25/2019 12/20/2017 6/28/2019 7/12/2017 10/7/2016 7/19/2017 8/23/2019 10/13/2016 7/24/2019 9/25/2019 7/26/2019 2/23/2018 6/9/2017 1/20/2017 10/13/2017 7/19/2019 1118/2017 6/7/2017 7/3112019 2/21/2018 1/17/2018 7/14/2017 1120/2017 1112/2018 10/11/2019 6/12/2019 9/9/2016 5/31/2019 3/21/2019 1/27/2017 11/16/2016 6/2/2017 2/15/2017 1112/2018 1/13/2017 Term N/A 24 Mas 24 Mas 60 Mas 36 Mas 36 Mas 48 Mas 60 Mas 18 Mas 42 Mas 48 Mas 24 Mas 60 Mas 48 Mas 60 Mas 30 Mas 48 Mas 36 Mas 24 Mas 18 Mas 36 Mas 60 Mas 60 Mas 48 Mas 24 Mas 60 Mas 60 Mas 24 Mas 48 Mas 37 Mas 60 Mas 60 Mas 27 Mas 54 Mas 36 Mas 45 Mas 36 Mas 36 Mas 60 Mas 37 Mas 60 Mas 60 Mas 60 Mas 54 Mas Maturity Date On Demand 212312020 2/23/2020 11/3/2022 712512022 9/27/2022 12/20/2021 4/5/2022 2/16/2021 3/24/2023 12/20/2021 6/28/2021 7/12/2022 10/7/2020 7/19/2022 2/23/2022 10/13/2020 7/25/2022 9/24/2021 1/26/2021 8/23/2021 6/9/2022 112012022 10/13/2021 7/19/2021 1118/2022 6/7/2022 7/30/2021 212212022 2/17/2021 7/14/2022 112012022 4/13/2020 4/11/2024 6/13/2022 6/9/2020 5/31/2022 3/21/2022 1/27/2022 12/16/2019 6/2/2022 2/15/2022 1/12/2023 7/13/2021 Market Value $ 25.630.194 $ 250.000 $ 3.930.940 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 25 ,630 ,194 219% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 250,000 1 75% 3,930,940 1 60% 250,000 2 20% 250,000 215% 250,000 1 65% 250,000 2 20% 250,000 2 45% 250,000 1 90% 250,000 1.65% 250.000 2 15% 250,000 2 10% 250,000 2.20% 250,000 1 35% 250,000 2 05% 250,000 1 95% 250,000 1 40% 250,000 2 10% 250.000 1 75% 250.000 1 95% 250,000 2 30% 250,000 2 05% 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 245% 250,000 2 15% 250,000 2 05% 250,000 2 00% 250,000 2 00% 250,000 2 00% 250,000 2.50% 250,000 1 15% 250,000 2 50% 250,000 2 45% 250,000 1 90% 250.000 1 15% 250,000 2 05% 250,000 2 30% 250,000 2 35% 250.000 1 95% A-4 Investment Treasury-Bank of New York(Vining Sparks) Summary Local Agency Investment Fund (LAIF-CITY) Certificate of Depostt-Malaga Bank Certificate of Deposit -Malaga Bank Certiftcate of Deposit-Vtning Sparks Treasury Btlls-Vtning Sparks Total Investment Issuer of Investment Landmark Communtty Bank Live Oak Banking Company Luana Savings Bank Medallton Bank Utah Mercanttl Bank NA Merrick Bank Mid-Missouri Bank Morgan Stanley Bank NA Morgan Stanley PVT Bank Morton Commun1ty Northfiled Bank Partners Bank Caltforn1a Peoples Untied Bank Preferred Bank La California Sallie Mae Bank/Salt Lake Stgnature Bank of Arkansas Signature Bk Chicago Southern States Bank Stearns Bank NA Sterltng Bank POP BL MO Summit Community Bank Suntrust Bank Synchrony Bank Thtrd Fed Sav&Ln Clevland Triad Bank Untted Community Bk Ill Washing ton Trust Weterly Wellesley Bank Wells Fargo Bank Whttney Bank!MS Worlds Foremost Bank United States Treas United States Treas Untied States Treas United States Treas United States Treas 25.630 ,193 74 250,000 .00 3.930,940 39 17,950,000 00 5,000 ,000 00 52,761 ,134.13 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2019 CUSI~ 51507LBV5 538036CG7 549103WGO 58404DFE6 58733AES4 59013JC23 59541 KBP1 61747MD73 61760AZ51 619165HP1 66612ABX5 70212YAU6 71270QQJ8 740367EW3 7954504P7 82669LGD9 82669VBY6 843879BB2 857894SD2 85916DVN2 86604XML7 86789VUPO 87165HRY8 88413QBU1 89579NBP7 90983WBNO 940637HW4 94948LCRO 949763D45 966594AW3 981571CV2 9128282J8 912828S35 912828S76 912828XH8 912828XM7 Acquisition Date 8/23/2019 8/19/2016 7/8/2016 911812019 1212912017 1011112017 111912018 12/2112017 9/1912019 1/19/2018 10/25/2017 1111812016 111812017 111912016 11116/2019 7/15/2016 11/8/2017 12/2012017 1113/2017 9/18/2019 112612018 812912017 61212017 1112412017 61212016 10/12/2017 11118/2016 711912019 6110/2019 1/25/2017 112112017 711512019 911212019 713112018 6/3012019 7/3112018 Term 36 Mas 48 Mas 48 Mas 36 Mas 36 Mas 60 Mas 60 Mas 36 Mas 48Mas 36 Mas 60 Mas 36 Mas 60 Mas 36 Mas 60 Mas 48 Mas 60Mas 40Mas 36 Mas 48 Mas 30 Mas 60 Mas 60 Mas 48 Mas 46 Mas 54 Mas 36 Mas 18 Mas 36 Mas 36 Mas 36 Mas 12 Mas 45 Mas 36 Mas 12 Mas 24 Mas Maturity Date 212312022 8/1912020 71812020 911912022 1212912020 10/11/2022 111912023 12/2112020 9/19/2023 1119/2021 1012512022 1111812019 1/1812022 1118/2019 1011612024 7/1512020 1118/2022 4/20/2021 1113/2020 9/1812023 712612021 812912022 6/212022 11124/2021 412/2020 4/12/2022 11/18/2019 1/19/2021 6/10/2022 1127/2020 112112020 7/15/2020 6/3012023 713112021 6/3012020 7/3112020 T alai Investment $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Market Value 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 200 000 1,000,000 1.000 .000 1.000 .0 00 1.000.000 1.000.000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Book Value Yield 250,000 1.90% 250 ,000 1 25% 250,000 1 15% 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 1 10% 250,000 2.05% 250,000 115% 250,000 1 90% 250 ,000 1 15% 250,000 2.15% 250,000 2 00% 250.000 1.60% 250 ,000 1.65% 250,000 2 20% 250,000 1.80% 250,000 2.40% 250.000 2 10% 250,000 1 25% 250 ,000 2.05% 250,000 1 35% 250 ,000 2 00% 250,000 2 50% 250 ,000 1 70% 200,000 1 75% 1,000,000 1 50% 1,000,000 1.38% $ 1,000,000 1 13% $ 1 000 ,000 1.63% $ 1.000 ,000 1 63% $ 52,761 ,134 Wetghled Return 1 99% A-5 NOTE: Malaga Bank -CD 7% CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT OCTOBER 2019 SUMMARY OF CASH BALANCE BY INSTITUTION OCTOBER 2019 Vining Sparks -Treasury 8% Bank of the West 14% State of California -LAIF 41% (1) LAIF marl<et 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 all 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. Vining Sparks-Money Market 1% Dated A-6 BEGINNING BALANCE PLUS: DEPOSITS PLUS: INTEREST EARNINGS(1) LESS CHECK DISBURSEMENTS LESS : ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS: TRANSFERS OUT ENDING BALANCE (1) All LA IF interest is paid quarterly. (2) Electronic Disbursements : Payroll Payroll Charges Bank and Merchant Fees Bank of the West OPERATING 5 ,865,408.60 1,814,840.73 (1,529,136.68) (600,320.83) (22,799 .36) (203,227.45) 5,324, 765 .01 368,171 .30 223,080.03 9 ,069 .50 600,320.83 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT JUNE 2019 {FINAL) Mallga Bank Non~otiable Vining Spartl;a PETTY CASH LAIF-CITY CD Money Market 5 ,000 .00 31 ,259,265.49 4 ,149,553 .75 15,576 .17 1,227 .17 5 ,000.00 31 ,259,265.49 4 ,165,129.92 1,227 .17 (3) The net adjustment was due to void checks, retumed item, and other adjustments . JUNE 2019 CASH BALANCE BY MAJOR FUNDS 1% Vining Spartca YTOINT INVESTMENT CD TOTAL CASH RECEIVED 22 ,814 ,829.03 64,094 ,056.87 1,814 ,840.73 15,576.17 570,828.33 (1,529,13668) (600,320.83) 431,943.52 410,371 .33 203,227.45 203,227 45 (203,227.45) 23,450,000 00 64 ,205,387 .59 570,828.33 .GENERAL FUND 31% .CIP43% .EQUIPMENT REPLACEMENT 4% .1911ACT 2% []HABITAT RESTORATION 1% .QUIMBY3% .OTHER RESTRICTED FUNDS 16% A-7 CASH BALANCES BY FUND Unrestricted GENERAL FUNO Restricted by Council Action BEAUTIFICATION FUND CIP EQUIPMENT REPLACEMENT BUILDING REPLACEMENT EMPLO YEE BENEF IT S SUbtotal Restricted by Law or External Agencies STREET MAINTENANCE 1972 ACT 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 MAI NTENANCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTRICT RPVTV GINSBURG CULTURE ARTS BU IL DING DONOR RESTRICTED CONTRIBUTION FEDERAL GRANTS STATE GRANTS QU IM BY LOW-MODERATE INCOM E HOUSIN G AFFORDABLE HSNG IN LIEU EET MEASURE A CAPITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEAUTIFICATION WATER QUALITY FLOOD PROTECTim REDEVELOPMENT OBLIGATION RETIR IMPROVEMENT DISTRICT 9 SPECIAL TRUSTS s~ GRAND TOTAl BALANCE FORWARD 20,959 952.03 21,640.61 25 ,6 12,959.48 2,608 ,865 .62 0.00 0.00 28 ,243,465.71 743,832 .26 28 ,097.98 32 ,429 .19 0.00 0.00 1,524,647.87 446,600 .09 81 ,884 .66 895 ,383 .81 2,022 ,142 .84 124 ,713 .64 797 ,795 .82 51 ,720 .33 939 ,371 .29 763,345 .51 88,472.84 333,605.81 0.00 1,752.05 769,271 .15 903 ,692 .99 0.00 1,759,649.30 153,813 .37 830 ,397 .81 506 ,544 .99 0 .00 79,134 .11 0 .00 0.00 200,000.00 190,3 14 .62 0.00 622,024.80 14,890,639. t3 64,094,05U7 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT JUNE 2019 DEBIT CREDIT CASH 5,633,250.34 6,955 522 .39 19,637,679.98 13 ,439 .68 35,080.29 0 .00 2 ,004 ,197 .19 285 ,605 .94 27 ,331 ,550 .73 93 ,991 .94 11.443.95 2 ,691,413 .61 0 .00 0 .00 0 .00 0.00 0.00 0.00 2,111,628.81 332 ,130.18 30,022,964 .34 166,423 .90 35 ,962 .76 874,293 .40 201 .56 0 .00 28 ,299 .54 236 .58 19 .01 32 ,646 .76 15 ,119 .00 15 ,119 .00 0 .00 0.00 0.00 0.00 16,774 .60 32,219.23 1,509 ,203 .24 33,727 26 20,108 .71 460 ,218 .64 530 .80 0 00 82,415.46 64 ,060.42 28 ,105 .01 931 ,3 39 .22 383 ,171 .91 26,356 .80 2,378 ,957 .95 786 .20 32 ,500 .00 92 ,999 .84 47 ,991 .36 6 ,123.50 839 ,663 .68 55 .568 .88 19 ,627 .36 87 ,661 .85 7 ,331 .94 0.00 946 .703 23 5,566 .24 2 ,423 .02 766 ,488 .73 602 .55 22 ,500.00 66 ,575 .39 5,153 .99 3,341 .05 335 ,418 .75 0.00 0 .00 0 .00 330.03 1,037.27 1,044 .81 17 ,163 .19 11,356.42 775 ,077 .92 2,726.40 859 ,109.71 47 ,309 .68 443 ,694 .05 443 ,694 .05 0 .00 12,379.62 48,468 .00 1,723,560 .92 36,086 .03 0.00 189,899.40 5,950 .93 0 .01 836,348 .73 3,516 .37 0 .00 510 ,061 .36 0.00 0 .00 0 .00 2,907 .53 82 ,041 .64 0.00 0.00 0.00 0.00 0 .00 0 00 0 .00 669 .38 11 ,317.28 189 ,352 .10 2 ,194 .14 0.00 192,5 08 .76 0.00 0.00 0 .00 55 ,248 .95 30,579.84 646,693 .91 1,386, 113.8.1 1,732 009.67 14,544 743.27 9.130,992.98 9 019662.24 64 205,387.59 Total Investment: 64 ,205 ,387 .59 Change In Ending Cash Balance (1,322,272 .05 (21,640 .61 1.718 ,591 .25 82 ,547 .99 0 .00 0.00 1,n9,498.83 130,461 .1 4 201 .56 217.57 0 .00 0 00 (15,444 .63) 13 ,618 .55 530 .80 35 ,955 .41 356,815 .1 1 (31 ,713 .80) 41 ,867 .86 35 ,941 .52 7 ,331 .94 3 ,143.22 (21 ,897 .45) 1,812 94 0 00 (707.24) 5,806.77 (856,383.31) 0 .00 (36 ,088 .38 36 ,086 .03 5,950 .92 3,5 16 .37 0.00 (79 ,134 .11) 0 .00 0 .00 (10 ,647.90 2 ,1 94 .14 0 .00 24 ,669.11 _(345,895.8& 111,330.n Change In Ending Cash Balance in % -6% -100% 7% 3% 0% 0% 6% 18% 1% 1% 0% 0% -1% 3% 1% 4% 18 % -25 % 5% 69% 1% 0% -25% 1% 0% -40% 1% -95% 0% -2% 23% 1% 1% 0% -100% 0% 0% -5% 1% 0% 4% -2% 0% A-8 Investment Checktng Accounts Petty Cash Issuer of Investment Bank of the West N/A Local Agency Investment Fund /LAIF-CITY) State of Ca l1 forn1a Note (1) Money Market Vtntng Sparks CD -Non-Negotrabte Malaga Bank CD -Non-Negotrable Malaga Bank CD-Bank of New York -V rmng Sparks (Non-Abacus Federal Negotrable) Sav1ngs Bank Allegrance Bank Texas Amencan Express Bank FSB Amencan Express Centunon Bank of New England NH Bankers Bank Mad1son WI Bankers Bank of the West Bar Harbor Bank & Trust Barclays Bank Delaware Benef1c1al Bank Bust ness Bk of St LOUIS Caldwell Bank & Trust Co Caprtal Bank Little Rock Caprtal One NA Carroll County State Bank Iowa Commun1ty F1n l SVCS Bank Contrnental Bank UT Crossftrst Bank East Boston Savtngs Bank Enerbank USA Everbank I Jacksonvtlle FL Farmers&Merchants BK NEB Ftrst Ba nk of Hrghland Ft rst Fmanctal Bank F rrst Federal SVGS Bank Ftrst Internet Bank of In F1rst Nat1onal Bank of Amer1ca Ftrst Nat'l Bank M1ch1gan Ftrst Western Bank Flagstar Bank Gold Cast Bank/Chrcago Goldman Sachs Bank USA HSBC Bank USA Henry County Bank OH CUS!Pt 00257TAUO 017~8DAY2 02587CHR~ 02587DN38 063847AM9 06610 RAT6 06610TDN2 066851WV~ 06740KKD8 08173QBT2 12325EHV7 128829ADO 139797 FRO 14042RDA6 145087AF9 20364ABW4 211163GYO 22766ABBO 27113PBM2 29266N6P7 29976DQ78 30781TBD9 319141GE1 32021MFC8 32031YCD4 32056GCQ1 32110YJT3 32114VBJ5 33749VAG3 33847E2J5 38058KDM5 38149MAU7 40434YGK7 426336BF9 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT JUNE 2019 Acquisition Date N/A N/A N/A N/A 2/23/2018 2123/2018 6/20/2016 11/3/2017 12/19/2017 3/2'/2017 10/21/2016 12/20/2017 9/14/2016 6/28/2019 7/12/2017 1017/2016 7/19/2017 8/19/2016 6/22/2016 10/13/201 6 8/12/2016 7/12/2016 2/23/2018 6/9/2017 1/20/2017 10/13/2017 8r2/2016 1/18/2017 6/712017 2/21/2018 1117/2018 7/14/2017 1/20/2017 1/12/2018 7/15/2016 6/12/2019 9/9/2016 5131/2019 3/21/2017 1/27/2017 Term N/A N/A N/A N/A 24 Mas 24 Mas 39 Mas 60 Mas 48 Mas 60 Mas 36 Mas 48 Mos 36 Mos 48 Mos 60 Mas 48 Mos 60 Mos 36 Mos 39 Mos 48 Mos 36Mos 36 Mos 36 Mos 60 Mas 60 Mos 48 Mos 36 Mos 60 Mos 60 Mos 48 Mas 37 Mas 60 Mos 60 Mos 2~ Mos 36 Mos 36 Mos 45 Mas 36 Mos 60 Mos 60 Mas Maturity Date On Demand On Demand On Demand Or Demand 2/23/2020 2/23/2020 9/17/2019 11/3/2022 12/20/2021 4/5/2022 10/21/2019 121201202 1 9/13/2019 6/28/2021 7/12/2022 10/7/2020 7/19/2022 8/19/2019 9/23/2019 10/13/2020 8/12/2019 7/12/2019 8/23/2021 6/9/2022 1/20/2022 10/13/2021 8/'2/2019 1/18/2022 6/7/2022 212212022 211712021 7/1 4/2022 1/20/2022 ~/13/2020 7/15/2019 6/13/2022 6/9/2020 5/31/2022 3/2112022 1127/2022 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Market Value 5 324 '765 5 000 31 259 265 1 227 250 000 3 915130 250 000 250 000 250 000 250 000 250 000 250 000 250 000 250 000 250 000 250 DOD 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 5 32~ .765 0 00% 5.000 0 00% $ 31 259 265 2 43% 1.227 0 00% 250 000 1 75% $ 39 15130 160% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 250.000 1 25% 250.000 2 20% 250 000 2 20% 250 DOD 2 45% 250 000 1 20% 250.000 2 15% 250 000 1 15% 250.000 2 10% 250.000 2 20% 250 000 1 35% 250 000 2 05% 250 000 1 00% 250 000 1 20% 250 000 1 40% 250 .000 1 00% 250.000 1 05% 250.000 2 30% 250 000 2 05% 250 000 2 00% 250 000 2 00% 250000 115% 250 000 2 05% 250000 210% 250.000 2 45% 250.000 2 15% 250.000 2 05% 250 000 2 00% 250 000 2 00% 250.000 1 00% 250 000 2 50% 250 000 1 15% 250 000 2 50% 250 000 2 45% 250 000 1 90% A-9 Treasury-Bank of New York(V1n1ng Sparks) CD -Bank of New York (V<n1 ng Sparks) Adl Summa ry Local Agency Investment Fund (LAIF-C ITY) Certtft cate of Oepostt -M a laga Bank Cert1f1cate of Depos1t • Malaga Bank Ce rt1f1 cate of DepoSit · V1n1ng Sparks Treasury B 1lls -V1n1ng Sparks Money Market -V1n1ng Sparks Tot al Investment Independent Bk/Memph1s lndustnai&Com Bank Ch1na International Bk Ch1cago lsbella Bank JP MORGAN CHASE BANK LCA Bank Corp Lakes1de Bank L1ve Oak Bank1n g Company Luana Savrngs Bank Mercantli Bank NA Mernck Bank Mtd-Mtssoun Bank Morgan Stanley Bank NA Morgan Stanley PVT Bank Morton Commun tty Northf1led Bank Partners Bank Caltfornta Peoples United Bank Preferred Bank La Caltfornta Sall1e Mae Bank/Salt Lake S1gnature Bank of Arkansas Stgnature Bk Ch1cago Southern States Bank Stearns Bank NA Summtt Communtty Bank Suntrust Bank Synchrony Bank Third Fed Sav&Ln Clevland Tnad Bank Unton Bank and Trust/OX Untied Communtty Bk Ill Wash tngton Tru st Weterly Wells Fargo Bank Whitney Bank!MS Worlds Foremost Bank Yadk1n Bank Um!ed States Treas U ntied States Treas United States Treas Untted States Treas Un1ted States Treas U nt ied S tates T reas United States Treas $ $ 3 1 259.265 250.000 3.9 15 130 17 .4 50000 6 000 000 1,227 58.875 623 45383USK2 45581 EAF8 45906ABR 7 464209C J2 48121C8Q2 801798LK6 5121 OSMD6 538036CG7 549103WGO 58733AES4 59013JC 23 59541 KBP1 6 1747MD73 61760ADT3 619165HP1 66612ABX5 702 12YAU6 71270QQJ8 740367EW3 795450ZF5 82669LGD9 82669VBY6 843879BB2 857894SD2 86604XML7 86789VUPO 87165HRY8 88413QBU1 89579NBP7 905200CE9 90983WBNO 940637HW4 949763D45 966594AW 3 981571CV2 984308EG7 9128282T6 9 12828D80 912828S76 9 12828TH 3 912828WS5 9 12828XH8 9 12828XM7 11 /16/2016 6/2/2017 1012012017 91712016 211512017 1/12/2018 1/13/2017 8/19/2016 7/8/2016 12129/2017 10/11/2017 1/19/2018 1212 1/2017 91712017 111912018 1012512017 11 /18/2016 111 8/2017 11 19/2016 10/12/2016 7/15/20 16 1118/2017 12120120 17 1113/2017 1/26/2018 8129/201 7 6/212017 1112412017 61212016 1120120 17 10/1212017 11118/2016 611 0/2019 1/2512017 1/21120 17 9/19/2016 8/3/201 8 813/2018 7131/2018 713112018 8124/2018 6/3012019 7131/2018 37 Mas 60 Mas 54 Mas 36 Mas 60 Mas 60 Mas 54 Mas 48 Mas 48 Mas 36 Mas 60 Mas 60 Mas 36 Mas 24 Mas 36 Mos 60 Mas 36 Mas 60 Mas 36 Mas 36 Mas 48 Mas 60 Mas 40Mos 36 Mas 30 Mas 60 Mas 60 Mas 48 Mas 46 Mas 30 Mas 54 Mas 36 Mas 36 Mos 36 Mas 36 Mas 36 Mas 12 Mas 12 Mas 36 Mas 12 Mas 10 Mas 12 Mas 24 Mos 1211612019 61212022 4/2012022 9/9/2019 2115/2022 1/12/2023 7113/2021 8/1912020 71812020 12/29/2020 10/1112022 1/1912023 12/2 1/2020 9/9/2019 1/19/2021 10/2512022 11/18/2019 1/18/2022 1118/2019 10/1 5/2019 c /15120 20 1118/2022 4/20/2021 1113/202 0 712612021 812912022 6/2/2022 1112412021 4/2/2020 7/22/2019 411212022 111 1812019 6110/2022 1/27/2020 1/2112020 9/1912019 8/31/2019 8/31/2019 7/31 12021 7/3112019 6/3012019 6/3012020 7/3112020 $ $ $ $ $ $ $ $ $ $ $ $ $ 250 000 250 000 250 000 250 000 250 DOD 2 50 000 250 ODD 250 000 250 ODD 250 DOD 250 000 250 000 250 000 250 000 250 000 250 000 250 000 2 50 000 250 000 250 000 250 DOD 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 200 000 250 000 500 000 500 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 Total Investment: $ s $ $ $ $ s $ $ $ $ $ $ $ 250 000 1 15% 250.000 2 05% 250 000 2 10% 250 000 1 15% 250 DOD 2 30% 250 000 2 35% 250.000 1 95% 250 000 1 25% 250 ODD 1 15% 250.000 2 20% 250 000 2 10% 250.000 2 35% 250.000 2 15% 250 000 1 75% 250 000 2 15% 250.000 2 15% 250 ODD 1 10% 250 000 2 05% 250.000 1 15% 250.000 1 30% 250.000 1 15% 250.000 2 15% 250 000 2 00% 250.000 1 60% 250 000 2 20% 250 000 1 80% 250 000 2 40% 250 000 2 10% 250 000 1 25% 250 000 1 45% 250 000 2 05% 250 000 1 35% 250 000 2 50% 250 000 1 70% 200 000 1 75 % 250 000 1 10% 500 000 1 25% 500 000 1 63% $ 1.000000 125% 1 000 000 0 88% 1 000 .000 1 63% 1 000 000 1 63% 1 000 000 1 63% $ 64,205,388 Total Investment Weighted Average Return 2 08% A-10 NOTE: Malaga Bank -CD 7% SUMMARY OF CASH BALANCE BY INSTITUTION JUNE 2019 Vining Sparks-Treasury 9% Bank of the West 8% Vining Sparks -Money Market 0% State of California-LAIF 49% {1) LAIF market values will be reported to vary from book value~ the City Cl!lculated share of total LAIF assets is less than the City book value . To the best of my knowiedge, there are no misstatements of material amounts wilh1n this repon ; or omissions of material amounts to cause the report to be misleading . I certify that this report accurately reflects all 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 ava ilable to meet the City's expenditure requirements for the next six months. Dated