The URL can be used to link to this page

Home My WebLink AboutAgenda Report - November 4, 2020 C-03AGENDA ITEM CM3 &Q%� CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: November 4, 2020 PREPARED BY: Deputy City Manager RECOMMENDED ACTION. Accept the quarterly investment report as required by the City of Lodi Investment Policy. BACKGROUND INFORMATION: Government Code Section 53646 prescribes suggested investment reporting requirements for California public agencies. The City Council adopted Resolution 2018-33 on March 7, 2018, requiring the Treasurer to submit a quarterly investment reporting in accordance with Section 53646. The attached Treasurer's Report for the quarter ending September 30, 2020 is in compliance with the State's reporting recommendations and the City of Lodi's Investment Policy and Internal Control Guidelines. The investment report, investment policy and historical investment reports can be accessed on the City website by following this link: httr)://www.lodi.gov/196/Finance FISCAL IMPACT FUNDING AVAILABLE: Attachment Not applicable. As per attached report. 00AItur X,,'w Andrew Keys Treasurer APPROVED: - SO,,j'. 70 71, n, 46 rb i1 Stephen Schwabauer, City Manager :y�rc.�ar.�ei SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2020 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Cash and Equivalents Farmers & Merchants Bank Main * Due on Demand 3,737,986 3,737,986 2.79% Farmers & Merchants Bank Payroll * Due on Demand 46,383 46,383 0.03% Local Agency Investment Fund Due on Demand 34,557,661 34,557,661 25.77% Farmer's & Merchants Bank Money Market * Due on Demand 10,348,135 10,348,135 7.72% Wells Fargo Bank Money Market * Due on Demand 6,768,206 6,768,206 5.05% Total Demand Deposit Accounts 55,458,371 55,458,371 41.36% Bond Mutual Fund Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAL TRUST Medium Term Fund Due on Demand 10,512,889 10,512,889 7.84% Total Bond Mutual Funds 10,512,889 10,512,889 7.84% Local Bank Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Farmers & Merchants Bank 1.00% 11/7/2021 2,000,000 2,000,000 2,000,000 1.49% BBVA Compass 2.50% 3/13/2021 249,995 249,995 249,995 0.19% Total Local Bank Certificates of Deposit 2,249,995 2,249,995 2,249,995 1.68% Negotiable Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BELMONT SAVINGS BANK INTEREST 1.95% 11/23/2020 250,000 250,000 250,697 0.19% TIAA FSB INTEREST BEARING 1.95% 11/23/2020 250,000 250,000 250,710 0.19% ALLY BANK INTEREST BANKING 2.05% 11/24/2020 250,000 250,000 250,762 0.19% BERKSHIRE BANK PITTSFIELD 1.85% 11/24/2020 250,000 250,000 250,685 0.19% NEBRASKALAND NATIONAL BANK 1.85% 11/27/2020 250,000 250,000 250,710 0.19% MB FINANCIAL BANK NA 2.00% 11/17/2021 250,000 250,000 255,385 0.19% MERRICK BANK 2.10% 11/17/2021 250,000 250,000 255,667 0.19% DISCOVER BANK 2.15% 11/22/2021 250,000 250,000 255,890 0.19% THIRD FEDERAL SAVINGS & LOAN CLEVELAND 2.10% 11/24/2021 250,000 250,000 255,774 0.19% BMW BANK NORTH AMERICA 2.20% 11/29/2021 250,000 250,000 256,132 0.19% ENERBANK USA 2.55% 1/18/2022 250,000 250,000 257,945 0.19% HORIZON BANK NATION ASSN 2.85% 5/4/2022 250,000 250,000 260,867 0.19% CITI BANK 1.95% 8/23/2022 250,000 250,000 258,614 0.19% CAPITAL ONE BANK USA NA 2.40% 11/22/2022 250,000 250,000 262,043 0.20% CAPITAL ONE NA 2.40% 11/22/2022 250,000 250,000 262,043 0.20% GOLDMAN SACHS BANK USA 2.40% 11/22/2022 250,000 250,000 262,043 0.20% WELLS FARGO BANK NA 2.40% 11/22/2022 250,000 250,000 262,032 0.20% AMERICAN EXPRESS BANK FSB 2.50% 12/5/2022 250,000 246,699 261,939 0.20% SYNCHRONY BANK 2.60% 1/19/2023 250,000 250,000 264,051 0.20% SALLIE MAE BANK/SALT LAKE CITY, UTAH 2.65% 1/24/2023 250,000 250,000 264,421 0.20% STATE BANK OF INDIA 2.70% 2/16/2023 250,000 250,000 265,096 0.20% MEDALLION BANK UTAH 2.90% 4/10/2023 250,000 250,000 267,206 0.20% STIFEL BANK AND TRUST 2.95% 5/15/2023 250,000 250,000 268,169 0.20% CITIBANK NA 3.25% 6/6/2023 250,000 250,000 270,572 0.20% INDUSTRIAL & COM BK CHNA 3.30% 6/30/2023 250,000 250,000 271,410 0.20% COMENITY CAPITAL BANK 3.30% 7/16/2023 250,000 250,000 271,718 0.20% UBS BANK 3.35% 10/5/2023 250,000 250,000 273,704 0.20% BARCLAYS BANK/DELAWARE 3.35% 10/10/2023 250,000 250,000 273,790 0.20% HSBC BANK 3.50% 10/31/2023 250,000 250,000 250,635 0.19% BANK OF BARODA 3.55% 11/30/2023 250,000 250,000 276,343 0.21% MCHENRY SAVINGS BK IL 2.80% 3/14/2024 250,000 250,000 271,971 0.20% MORGAN STANLEY BANK 1.95% 11/29/2024 250,000 250,000 266,892 0.20% MORGAN STANLEY PRIVATE BANK 1.90% 11/29/2024 250,000 250,000 266,375 0.20% CELTIC BANK 1.70% 3/13/2025 250,000 250,000 251,878 0.19% Total Negotiable Certificates of Deposit 8,500,000 8,496,699 8,894,170 6.63% Agency Securities FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.50% 10/22/2020 205,000 199,527 205,161 0.15% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.70% 11/13/2020 250,000 244,468 250,466 0.19% FEDERAL HOME LOAN BANK 5.25% 12/11/2020 250,000 266,094 252,492 0.19% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.35% 2/22/2021 250,000 247,195 252,164 0.19% FEDERAL HOME LOAN BANK 2.38% 3/12/2021 250,000 247,737 252,486 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.75% 4/9/2021 250,000 242,978 252,087 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.25% 5/6/2021 250,000 240,040 251,646 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.25% 8/17/2021 250,000 238,514 252,454 0.19% :y�rc.�ar.�ei SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2020 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 9/28/2021 250,000 244,105 254,594 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.38% 10/7/2021 250,000 238,923 253,092 0.19% FEDERAL HOME LOAN BANK 2.63% 12/10/2021 250,000 248,755 257,378 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 1/5/2022 250,000 243,235 255,960 0.19% FEDERAL HOME LOAN BANK 2.63% 3/11/2022 250,000 248,853 258,985 0.19% FEDERAL HOME LOAN BANK 2.62% 5/27/2022 250,000 249,465 260,143 0.19% FEDERAL FARM CREDIT BANK SYSTEM 1.88% 6/1/2022 250,000 242,059 257,094 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 8/26/2022 250,000 242,734 258,745 0.19% FEDERAL HOME LOAN BANK 3.13% 9/9/2022 250,000 254,254 264,170 0.20% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.38% 1/19/2023 250,000 246,300 262,263 0.20% FEDERAL FARM CREDIT BANK SYSTEM 2.65% 3/8/2023 250,000 249,325 264,847 0.20% FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 265,689 0.20% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,174 267,278 0.20% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,160 268,404 0.20% FEDERAL FARM CREDIT BANK SYSTEM 1.13% 3/17/2025 500,000 500,000 500,991 0.37% FARMER MAC 1.35% 4/1/2025 1,000,000 1,000,000 1,000,806 0.75% Total Agency Securities 6,955,000 6,883,392 7,119,394 5.31% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 2.63% 11/15/2020 250,000 248,868 250,769 0.19% UNITED STATES TREASURY 2.38% 12/31/2020 250,000 247,420 251,393 0.19% UNITED STATES TREASURY 1.38% 1/31/2021 250,000 241,844 251,025 0.19% UNITED STATES TREASURY 1.13% 2/28/2021 250,000 239,815 251,055 0.19% UNITED STATES TREASURY 1.25% 3/31/2021 250,000 240,368 251,436 0.19% UNITED STATES TREASURY 1.38% 4/30/2021 250,000 240,904 251,846 0.19% UNITED STATES TREASURY 1.38% 5/31/2021 250,000 240,547 252,109 0.19% UNITED STATES TREASURY 1.13% 6/30/2021 250,000 238,335 251,875 0.19% UNITED STATES TREASURY 1.13% 7/31/2021 250,000 237,921 252,090 0.19% UNITED STATES TREASURY 2.00% 8/31/2021 250,000 244,513 254,268 0.19% UNITED STATES TREASURY 1.13% 9/30/2021 250,000 237,186 252,441 0.19% UNITED STATES TREASURY 2.00% 10/31/2021 250,000 244,134 255,020 0.19% UNITED STATES TREASURY 2.00% 12/31/2021 400,000 394,512 409,281 0.31% UNITED STATES TREASURY 1.50% 1/31/2022 250,000 240,139 254,551 0.19% UNITED STATES TREASURY 1.88% 2/28/2022 250,000 243,370 256,300 0.19% UNITED STATES TREASURY 1.88% 3/31/2022 250,000 243,143 256,533 0.19% UNITED STATES TREASURY 1.75% 5/31/2022 250,000 242,223 256,748 0.19% UNITED STATES TREASURY 1.75% 6/30/2022 250,000 242,065 257,080 0.19% UNITED STATES TREASURY 1.88% 7/31/2022 250,000 243,028 257,988 0.19% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 240,313 257,158 0.19% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 242,668 258,701 0.19% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 243,745 259,717 0.19% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 243,603 260,088 0.19% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,688 261,172 0.19% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,063 258,213 0.19% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,790 258,467 0.19% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 259,551 0.19% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 259,863 0.19% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,329 266,973 0.20% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,621 257,744 0.19% Total US Treasury Notes 7,650,000 7,392,900 7,831,454 5.84% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BANK OF AMERICA CORP 2.63% 10/19/2020 500,000 503,172 500,545 0.37% COCA-COLA COMPANY 2.45% 11/1/2020 250,000 248,290 250,440 0.19% WELLS FARGO & COMPANY 2.55% 12/7/2020 200,000 199,591 200,808 0.15% WELLS FARGO BANK NA 2.60% 1/15/2021 250,000 246,540 251,675 0.19% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2020 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd MICROSOFT CORP 4.00% 2/8/2021 100,000 104,600 101,345 0.08% CISCO SYSTEMS INC 2.20% 2/28/2021 150,000 147,659 151,172 0.11% EXXON MOBIL CORPORATION 2.22% 3/1/2021 150,000 147,915 150,992 0.11% BERKSHIRE HATHAWAY INC 2.20% 3/15/2021 100,000 99,297 100,722 0.08% PNC BANK NA 2.15% 4/29/2021 500,000 495,965 504,615 0.38% ALPHABET INC 3.63% 5/19/2021 100,000 104,000 102,154 0.08% DETROIT EDISON CO 3.90% 6/1/2021 375,000 385,585 380,448 0.28% TOTAL CAPITAL INTERNATIONAL SA 2.75% 6/19/2021 250,000 248,075 254,396 0.19% AMERICAN HONDA FINANCE 1.65% 7/12/2021 250,000 239,433 252,558 0.19% APPLE INC 1.55% 8/4/2021 500,000 485,396 504,806 0.38% MIZUHOFINANCIAL CORPORATION 2.27% 9/13/2021 250,000 240,903 254,506 0.19% BOEING COMPANY 2.35% 10/30/2021 250,000 245,363 253,267 0.19% PFIZER INC 2.20% 12/15/2021 200,000 198,284 204,622 0.15% TOYOTA MOTOR CREDIT CORP 2.60% 1/11/2022 250,000 246,665 257,349 0.19% PACIFICORP 2.95% 2/1/2022 250,000 249,816 256,847 0.19% JOHNSON&JOHNSON 2.25% 3/3/2022 250,000 245,167 256,459 0.19% WELLS FARGO & COMPANY 3.50% 3/8/2022 400,000 400,000 416,930 0.31% TD AMERITRADE HOLDING COMPANY 2.95% 4/1/2022 250,000 247,243 258,437 0.19% ORACLE CORP 2.50% 5/15/2022 100,000 99,204 103,132 0.08% UNITED PARCEL SERVICE 2.35% 5/16/2022 100,000 98,749 103,139 0.08% DEERE & COMPANY 2.60% 6/8/2022 100,000 99,153 103,406 0.08% 3M COMPANY 2.00% 6/26/2022 150,000 144,485 154,391 0.12% TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 246,950 260,981 0.19% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 243,146 258,863 0.19% MERCK & CO INC 2.40% 9/15/2022 100,000 98,701 103,725 0.08% 1PMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,377 105,698 0.08% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,535 259,167 0.19% MICROSOFT CORP 2.65% 11/3/2022 250,000 250,000 261,636 0.20% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 262,021 0.20% VISA INC 2.80% 12/14/2022 250,000 247,518 262,645 0.20% JPMORGAN CHASE & CO 2.97% 1/15/2023 150,000 147,503 154,893 0.12% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,069 105,337 0.08% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 260,136 0.19% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,147 158,971 0.12% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,143 104,980 0.08% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,040 262,918 0.20% WALMART INC 2.55% 4/11/2023 250,000 244,525 262,817 0.20% APPLE INC 2.40% 5/3/2023 250,000 240,887 263,219 0.20% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,849 270,120 0.20% CHEVRON CORPORATION 3.19% 6/24/2023 250,000 249,295 267,161 0.20% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 230,000 237,333 0.18% ORACLE CORP 3.63% 7/15/2023 250,000 253,415 271,475 0.20% IBM CORP 3.38% 8/1/2023 500,000 492,500 542,835 0.40% SHELL INTERNATIONAL FIN 3.40% 8/12/2023 250,000 252,275 270,453 0.20% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 272,853 0.20% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 315,000 349,507 0.26% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 300,000 315,059 0.23% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,228 262,435 0.20% COCA-COLA CO 3.20% 11/1/2023 238,000 235,651 258,803 0.19% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,885 324,694 0.24% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,873 273,430 0.20% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,358 434,668 0.32% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,448 273,207 0.20% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 538,075 548,315 0.41% 3M COMPANY 3.25% 2/14/2024 300,000 300,000 326,781 0.24% BOEING CO 2.80% 3/1/2024 250,000 248,917 255,033 0.19% DETROIT EDISON CO 3.65% 3/15/2024 300,000 300,000 326,825 0.24% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 263,445 277,058 0.21% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 500,000 546,713 0.41% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 500,000 520,531 0.39% WELLS FARGO & COMPANY 3.30% 9/9/2024 500,000 500,000 816,980 0.61% :y�rc.�ar.�ei SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2020 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 500,000 526,144 0.39% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 500,000 525,897 0.39% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 500,000 550,527 0.41% JP MORGAN CHASE FINANCIAL STEP 2.15% 1/31/2025 1,000,000 1,000,000 1,000,627 0.75% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 300,000 313,431 0.23% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 500,000 533,580 0.40% Total Corporate Securities 20,122,000 20,039,639 21,369,640 15.94% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio MT SAN ANTONIO CCD 1.94% 8/1/2020 400,000 400,000 420,008 0.31% PALM DESERT CA REDEVELOPMENT AGENCY 2.25% 10/1/2020 250,000 247,823 250,000 0.19% TEXAS ST PUBLIC FINANCE AUTHORITY 3.53% 10/1/2020 350,000 358,351 350,000 0.26% CALIFORNIAST- VARIOUS 5.00% 12/1/2020 200,000 200,000 201,602 0.15% CONNECTICUT-A-TXBL 2.54% 3/15/2021 175,000 175,000 176,689 0.13% CALIFORNIA STATE HIGH SPEED RAIL 2.63% 4/1/2021 500,000 501,060 505,600 0.38% UNIVERSITY OF CALIFORNIA 3.24% 5/15/2021 150,000 152,684 152,705 0.11% UNIVERSITY OF CALIFORNIA CA REVENUES 1.79% 5/15/2021 250,000 244,733 252,268 0.19% BURBANK-G LEN DALE -PASADENA AIPORT AUTHORITY 4.13% 7/1/2021 90,000 94,323 91,618 0.07% MT DIABLO SD -REF -B 5.00% 7/1/2021 600,000 600,000 621,816 0.46% LA MIRADA CA REDEVELOPMENT 2.91% 8/15/2021 250,000 253,195 253,380 0.19% YUBA LEVEE FINANCING AUTHORITY 2.86% 9/1/2021 250,000 252,980 254,348 0.19% SAN DIEGO CA REDEVELOPMENT AGENCY 2.25% 9/1/2021 250,000 246,163 253,973 0.19% ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM 2.41% 2/1/2022 250,000 246,915 256,443 0.19% POMONA REDEV AGY-REF 3.55% 2/1/2022 275,000 283,441 284,455 0.21% CA ST-TXBL 6.65% 3/1/2022 640,000 716,619 676,294 0.50% STATE OF MARYLAND 2.65% 3/15/2022 300,000 300,480 310,278 0.23% CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY 2.46% 4/1/2022 250,000 246,270 255,153 0.19% CALIFORNIA ST-A-TXBL 2.37% 4/1/2022 500,000 502,362 514,470 0.38% SACRAMENTO CA PUBLIC 3.79% 4/1/2022 175,000 175,000 182,872 0.14% CALIFORNIA STATE DEPT OF WATER RESOURCES 2.00% 5/1/2022 300,000 291,678 308,055 0.23% UNIV OF CALIFORNIA -BC 2.61% 5/15/2022 250,000 250,000 259,080 0.19% FAIRFIELD-REF-TXBL 3.25% 6/1/2022 150,000 150,000 156,605 0.12% TULARE COUNTY CA PENSION OBLIGATION 3.20% 6/1/2022 250,000 250,245 260,750 0.19% ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 100,499 104,544 0.08% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 246,936 249,058 0.19% ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 125,000 128,110 0.10% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 209,604 212,258 0.16% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 120,960 124,561 0.09% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 161,840 164,987 0.12% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 260,887 272,691 0.20% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,052 462,453 0.34% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 75,000 78,596 0.06% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 83,491 0.06% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 200,000 443,770 470,259 0.35% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,559 324,344 0.24% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,230 297,608 0.22% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,273 260,673 0.19% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,888 260,740 0.19% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,745 526,955 0.39% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 506,070 500,970 0.37% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 149,824 0.11% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,481 329,626 0.25% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 290,000 306,054 0.23% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 445,594 0.33% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2020 TYPE OF INVESTMENT MunlcicaI Securities Coned CALIFORNIA STATE MUNI TAX OAKLAND PENSION-TXBL RIVERSIDE CA UNIFIED SCHOOL DIST CORTE MADERA-TXBL-REF TULARE COUNTY BRD ED-TXBL CHAFFEY COMMUNITY COLLEGE DT RIVERSIDE CO PUB FIN LOMPOC VALLEY MED-TXBL SAN FRANCISCO CITY TAMALPAIS UN HSD-TXBL TEN NESS E E -C- R E F -TX B L CONTRA COSTA CA COMNTY M I N N ESOTA ST-C-TXBL SOLANO COMMUNITY COLLEGE DT SAN FRANCISCO REDEV-C ORANGE COUNTY CA WATER DIST W SACRAMENTO AREA ESCONDIDO JT POWERS CARMICHAEL WATER DIST INDIO PUB FIN-B-TXBL VENTURA COUNTY CA PUBLIC SEMITROPIC IMP DIST-A CON EDISON CO OF NY INC CALIFORNIA-TXBL Total Municipal Securities INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.25% 10/1/2023 250,000 239,738 262,858 0.20% 4.35% 12/15/2023 400,000 400,000 444,720 0.33% 1.98% 2/1/2024 400,000 400,000 415,332 0.31% 2.75% 5/1/2024 150,000 150,357 156,492 0.12% 2,31% 5/1/2024 235,000 235,000 240,191 0.18% 1.72% 6/1/2024 480,000 480,000 496,248 0.37% 1.92% 7/1/2024 300,000 300,000 305,748 0.23% 2.07% 7/1/2024 110,000 110,000 114,859 0.09% 3.76% 8/1/2024 250,000 250,000 277,093 0;21% 2.02% 8/1/2024 150,000 150,000 157,379 0.12% 1,97% 8/1/2024 170,000 170,000 178,537 0;13% 1.77% 8/1/2024 250,000 250,000 259,488 0.19% 3.00% 8/1/2024 215,000 215,000 235,395 0.18% 2.16% 8/1/2024 300,000 300,000 315,111 0.24% 3.13% 8/1/2024 500,000 500,000 534,435 0.40% 1.94% 8/15/2024 200,000 200,000 209,280 0.16% 2.07% 9/1/2024 150,000 150,000 156,920 0.12% 2.19% 9/1/2024 380,000 380,000 399,167 0.30% 2.17% 11/1/2024 1,295,000 1,295,000 1,365,642 1.02% 3.35% 11/1/2024 180,000 180,000 185,044 0.14% 1.22% 11/1/2024 100,000 100,000 101,812 0.08% 2.36% 12/1/2024 140,000 140,000 148,133 0.11% 3.30% 12/1/2024 310,000 310,000 340,101 0.25% 3.38% 4/1/2025 315,000 315,000 351,228 0.26% 19,540 000 19,857,490 20,653,063 15.4056 65,016,995 64,920,114 68,117,716 50.80% 130,891,374 134, 088,976 100.00% CERTIFICATION I certify this report accurately reflects all city pooled investments and is in conformity with state law and the investment policy statement adopted by the City Council on February 5, 2020. The investment program herein shown provides sufficient cash liquidity to meet the next six months estimated expenditures. A copy of this report is available in the City Clerk's Office or online at http://www.lodi.gov/finance/revenue.html. Andrew Keys, Treasurer/Director of Finance Susan Bjork, Budget Manager Oct 22, 2020 Review Date Oct 22, 2020 Review Date IRS Section 115 Retirement Benefit Trust Funds Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund Total Pension Stabilization Fund CalPERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 Total CERBT Total Section 115 Retirement Benefit Trust Funds Restricted Cash Accounts PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market Total PCE/TCE Central Plume Account Total Restriction Cash Accounts Market Value $ 17,356,637 $ 17,356,637 $ 2,087,451 $ 2,087,451 $ 19,444,088 Market Value $ 1,637,025 $ 1,637,025 $ 1,637,025