The URL can be used to link to this page

Home My WebLink AboutAgenda Report - July 20, 2022 C-03CITY OF 1 Die i 0 Z CALIFORNIA AGENDA ITEM C-3 COUNCIL COMMUNICATION AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: July 20, 2022 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 2021-164 on June 2, 2021 approving FY 21/22 Investment Policy. The attached Treasurer's Report for the quarter ending March 31, 2022 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 Not applicable. As per attached report. Andrew Keys Deputy City Manager/Internal Services Director APPROVED: s. auer(Jul5,202218:13PDT) Stephen Schwabauer, City Manager TYPE OF INVESTMENT Cash and Equivalents Farmers & Merchants Bank Main Farmers & Merchants Bank Payroll Local Agency Investment Fund Farmer's & Merchants Bank Money Market Wells Fargo Bank Money Market * Total Demand Deposit Accounts Bond Mutual Fund CAL TRUST Medium Term Fund Total Bond Mutual Funds Local Bank Certificates of Deaosit Farmers & Merchants Bank Total Local Bank Certificates of Deposit Neeotiable Certificates of Deoosit HORIZON BANK NATION ASSN CITI BANK CAPITAL ONE BANK USA NA CAPITAL ONE NA WELLS FARGO BANK NA GOLDMAN SACHS BANK USA AMERICAN EXPRESS BANK FSB SYNCHRONY BANK SALLIE MAE BANK/SALT LAKE CITY, UTAH STATE BANK OF INDIA MEDALLION BANK UTAH STIFEL BANK AND TRUST CITIBANK NA INDUSTRIAL & COM BK CHINA COMENITY CAPITAL BANK UBS BANK BARCLAYS BANK/DELAWARE BANK OF BARODA MCHENRY SAVINGS BK IL MORGAN STANLEY BANK MORGAN STANLEY PRIVATE BANK BMW BANK NORTH AMERICA FIRST NATL BK OF AMERICA TEXAS EXCHANGE BANK SSB BANK HAPOALIM BM NY Total Negotiable Certificates of Deposit Agency Securities FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL FARM CREDIT BANK SYSTEM ** FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK ** FEDERAL HOME LOAN MORTGAGE CO FREDDIE MAC FAMCA ** FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK ** FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FAMCA CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2022 Interest Rate Maturity Date Par Value Cost Due on Demand 3,671,788 Due on Demand 64,434 Due on Demand 59,382,423 Due on Demand 6,634,254 Due on Demand 1,140,494 Market Value % of Portfolio 3,671,788 2.11% 64,434 0.04% 59,382,423 34.16% 6,634,254 3.82% 1,140,494 0.66% 70,893,393 70,893,393 40.78% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 10,211,372 10,211,372 5.87% 10,211,372 10,211,372 5.87% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 0.20% 11/7/2023 2,000,000 2,000,000 2,000,000 1.15% 2,000,000 2,000,000 2,000,000 1.15% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.85% 5/4/2022 250,000 250,000 250,566 0.14% 1.95% 8/23/2022 250,000 250,000 251,253 0.14% 2.40% 11/22/2022 250,000 250,000 252,377 0.15% 2.40% 11/22/2022 250,000 250,000 252,377 0.15% 2.40% 11/22/2022 250,000 250,000 252,383 0.15% 2.40% 11/22/2022 250,000 250,000 252,377 0.15% 2.50% 12/5/2022 250,000 246,700 252,667 0.15% 2.60% 1/19/2023 250,000 250,000 253,122 0.15% 2.65% 1/24/2023 250,000 250,000 253,239 0.15% 2.70% 2/16/2023 250,000 250,000 253,413 0.15% 2.90% 4/10/2023 250,000 250,000 254,012 0.15% 2.95% 5/15/2023 250,000 250,000 254,318 0.15% 3.25% 6/6/2023 250,000 250,000 255,265 0.15% 3.30% 6/30/2023 250,000 250,000 255,551 0.15% 3.30% 7/16/2023 250,000 250,000 255,629 0.15% 3.35% 10/5/2023 250,000 250,000 256,066 0.15% 3.35% 10/10/2023 250,000 250,000 256,056 0.15% 3.55% 11/30/2023 250,000 250,000 256,933 0.15% 2.80% 3/14/2024 250,000 250,000 253,414 0.15% 1.95% 11/29/2024 250,000 250,000 247,065 0.14% 1.90% 11/29/2024 250,000 250,000 246,744 0.14% 0.90% 12/10/2024 250,000 250,000 240,134 0.14% 1.25% 12/30/2026 250,000 250,000 234,535 0.13% 1.25% 12/30/2026 250,000 250,000 235,092 0.14% 1.50% 1/7/2027 250,000 250,000 237,311 0.14% 6,250,000 6,246,700 6,261,900 3.60% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.62% 5/27/2022 250,000 249,475 250,741 0.14% 1.88% 6/1/2022 250,000 242,050 250,452 0.14% 2.00% 8/26/2022 250,000 242,725 251,061 0.14% 3.13% 9/9/2022 250,000 254,250 252,271 0.15% 2.38% 1/19/2023 250,000 246,300 251,662 0.14% 2.65% 3/8/2023 250,000 249,325 252,124 0.15% 2.70% 4/11/2023 250,000 249,500 252,718 0.15% 2.85% 5/8/2023 250,000 250,175 252,766 0.15% 2.90% 7/24/2023 250,000 249,150 252,871 0.15% 0.90% 1/18/2024 500,000 499,250 489,564 0.28% 1.63% 10/15/2024 500,000 508,800 490,350 0.28% 2.75% 12/13/2024 500,000 537,050 504,305 0.29% 1.25% 1/28/2025 500,000 500,000 482,959 0.28% 0.57% 9/24/2025 500,000 487,850 466,217 0.27% 0.60% 10/27/2025 500,000 497,750 469,906 0.27% 0.49% 12/18/2025 300,000 279,360 277,689 0.16% 0.90% 12/26/2025 500,000 499,900 471,797 0.27% 0.55% 1/20/2026 500,000 464,700 463,300 0.27% 0.85% 3/30/2026 400,000 399,840 376,188 0.22% 1.20% 4/28/2026 500,000 500,000 476,345 0.27% 1.00% 5/26/2026 500,000 500,000 472,457 0.27% 1.88% 9/11/2026 400,000 417,280 390,277 0.22% 1.05% 10/5/2026 500,000 500,000 469,118 0.27% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FEDERAL HOME LOAN MORTGAGE CO 0.80% 10/27/2026 500,000 489,350 460,109 0.26% FEDERAL HOME LOAN BANK ** 2.03% 2/25/2027 500,000 500,000 486,679 0.28% Total Agency Securities 9,850,000 9,814,080 9,513,926 5.47% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 1.75% 5/31/2022 250,000 242,225 250,555 0.14% UNITED STATES TREASURY 1.75% 6/30/2022 250,000 242,075 250,742 0.14% UNITED STATES TREASURY 1.88% 7/31/2022 250,000 243,025 250,908 0.14% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 240,325 250,723 0.14% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 242,675 251,035 0.14% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 243,750 251,152 0.14% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 243,600 251,191 0.14% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 251,289 0.14% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,075 249,717 0.14% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 249,482 0.14% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 249,600 0.14% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 249,277 0.14% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 252,168 0.15% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 247,510 0.14% UNITED STATES TREASURY 0.25% 6/15/2024 250,000 245,450 238,604 0.14% UNITED STATES TREASURY 0.38% 9/15/2024 250,000 245,350 237,725 0.14% UNITED STATES TREASURY 1.00% 12/15/2024 250,000 248,925 240,488 0.14% UNITED STATES TREASURY 0.50% 3/31/2025 250,000 244,475 235,762 0.14% UNITED STATES TREASURY 0.25% 6/30/2025 250,000 241,475 232,490 0.13% UNITED STATES TREASURY 0.25% 9/30/2025 250,000 240,475 231,201 0.13% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 345,065 323,941 0.19% UNITED STATES TREASURY 0.38% 12/31/2025 250,000 240,575 231,133 0.13% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 344,435 322,916 0.19% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 741,675 700,225 0.40% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 465,586 0.27% UNITED STATES TREASURY 0.88% 6/30/2026 250,000 244,025 233,789 0.13% UNITED STATES TREASURY 0.88% 9/30/2026 250,000 243,425 233,008 0.13% UNITED STATES TREASURY 1.25% 12/31/2026 250,000 247,500 236,533 0.14% Total US Treasury Notes 7,950,000 7,742,350 7,668,750 4.41% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio TD AMERITRADE HOLDING COMPANY 2.95% 4/1/2022 250,000 247,250 250,000 0.14% ORACLE CORP 2.50% 5/15/2022 100,000 99,200 100,059 0.06% UNITED PARCEL SERVICE 2.35% 5/16/2022 100,000 98,750 100,081 0.06% DEERE & COMPANY 2.60% 6/8/2022 100,000 99,150 100,113 0.06% 3M COMPANY 2.00% 6/26/2022 150,000 144,480 150,165 0.09% TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 246,950 251,001 0.14% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 243,150 250,740 0.14% MERCK & CO INC 2.40% 9/15/2022 100,000 98,700 100,202 0.06% JPMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,380 100,820 0.06% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,525 251,130 0.14% MICROSOFT CORP 2.65% 11/3/2022 250,000 247,575 251,392 0.14% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 251,330 0.14% VISA INC 2.80% 12/14/2022 250,000 247,525 251,925 0.14% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 100,894 0.06% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 251,702 0.14% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 151,672 0.09% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 100,507 0.06% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 251,890 0.14% WALMART INC 2.55% 4/11/2023 250,000 244,525 251,510 0.14% APPLE INC 2.40% 5/3/2023 250,000 240,875 251,430 0.14% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 255,765 0.15% CHEVRON CORPORATION 3.19% 6/24/2023 250,000 249,300 252,803 0.15% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 229,095 0.13% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 253,476 0.15% IBM CORP 3.38% 8/1/2023 500,000 492,500 507,388 0.29% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 260,594 0.15% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 321,397 0.18% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 299,315 0.17% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 249,256 0.14% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 304,089 0.17% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 253,237 0.15% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 405,924 0.23% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 254,400 0.15% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 529,500 509,001 0.29% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 304,222 0.18% BOEING CO 2.80% 3/1/2024 250,000 248,500 249,793 0.14% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 305,378 0.18% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 256,840 0.15% HORMEL FOODS CORP 0.65% 6/3/2024 500,000 495,100 480,402 0.28% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 508,083 0.29% AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 399,080 381,798 0.22% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 491,085 0.28% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 788,725 757,834 0.44% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 493,936 0.28% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 493,853 0.28% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 507,608 0.29% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 291,543 0.17% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 491,747 0.28% FLORIDA POWER & LIGHT CO ** 2.85% 4/1/2025 500,000 499,400 501,386 0.29% AMAZON.COM INC 0.80% 6/3/2025 500,000 497,950 473,986 0.27% APPLE INC 0.55% 8/20/2025 500,000 492,150 466,343 0.27% JOHNSON & JOHNSON 0.55% 9/1/2025 950,000 944,185 888,265 0.51% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 460,689 0.27% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 464,446 0.27% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 460,780 0.27% APPLE INC 0.70% 2/8/2026 500,000 492,000 465,334 0.27% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 277,309 0.16% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 373,018 0.21% BMW US CAPITAL LLC ** 2.80% 4/11/2026 500,000 495,900 493,893 0.28% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 234,713 0.14% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 469,286 0.27% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 466,192 0.27% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 465,478 0.27% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 499,300 452,250 0.26% MASS INSTITUTE OF TECH ** 3.31% 7/1/2026 500,000 532,750 504,909 0.29% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 250,000 233,036 0.13% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 248,200 233,573 0.13% TEXAS INSTRUMENTS INC 1.13% 9/15/2026 400,000 392,400 374,173 0.22% JPMORGAN CHASE & CO 2.95% 10/1/2026 500,000 534,550 496,806 0.29% PROCTER & GAMBLE CO/THE ** 1.90% 2/1/2027 350,000 347,270 339,054 0.20% PROGRESSIVE CORP ** 2.50% 3/15/2027 500,000 488,800 490,148 0.28% BEAL BANK - PLANO TX ** 2.00% 3/3/2027 250,000 250,000 242,569 0.14% NIKE INC ** 2.75% 3/27/2027 500,000 498,700 498,245 0.29% Total Corporate Securities 25,509,000 25,629,216 24,964,305 14.36% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY 2.46% 4/1/2022 250,000 246,275 250,000 0.14% CALIFORNIA ST-A-TXBL 2.37% 4/1/2022 500,000 496,950 500,000 0.29% SACRAMENTO CA PUBLIC 3.79% 4/1/2022 175,000 182,000 175,000 0.10% CALIFORNIA STATE DEPT OF WATER RESOURCES 2.00% 5/1/2022 300,000 291,690 300,241 0.17% UNIV OF CALIFORNIA -BC 2.61% 5/15/2022 250,000 250,000 250,538 0.14% FAIRFIELD-REF-TXBL 3.25% 6/1/2022 150,000 154,560 150,555 0.09% TULARE COUNTY CA PENSION OBLIGATION 3.20% 6/1/2022 250,000 250,250 250,885 0.14% ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 100,500 100,513 0.06% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 246,936 241,444 0.14% ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 124,925 125,369 0.07% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 209,600 201,965 0.12% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 120,960 120,777 0.07% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 161,840 161,296 0.09% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 260,884 262,000 0.15% TX PUB FIN AUTH-A-REF 3.08% 10/1/2022 300,000 300,000 298,888 0.17% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,035 447,580 0.26% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 74,243 75,582 0.04% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 80,740 0.05% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 450,000 443,775 452,748 0.26% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 311,585 0.18% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 287,960 0.17% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 250,530 0.14% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 251,083 0.14% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 507,056 0.29% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 502,450 500,296 0.29% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 145,105 0.08% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 310,315 0.18% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 291,418 0.17% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 420,591 0.24% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 250,176 0.14% TX PUB FIN AUTH-A-REF 5.08% 10/1/2023 300,000 300,000 293,014 0.17% NATIONAL SECS CLEARING 4.00% 12/7/2023 500,000 498,850 482,596 0.28% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 412,987 0.24% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 395,922 0.23% NATIONAL RURAL UTIL COOP 3.50% 2/8/2024 300,000 297,090 287,647 0.17% CALIFORNIA ST-TXBL-B 3.00% 4/1/2024 200,000 213,180 201,892 0.12% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 149,755 0.09% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 232,510 0.13% UNIV OF CALIFORNIA -BF 0.83% 5/15/2024 120,000 120,216 115,487 0.07% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 471,265 0.27% ORANGE -TXBL -REF 5.87% 6/1/2024 400,000 394,320 383,620 0.22% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 294,661 0.17% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 108,220 0.06% ANAHEIM PUBLIC FIN ** 0.63% 7/1/2024 250,000 245,500 238,499 0.14% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 256,307 0.15% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 148,341 0.09% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 167,419 0.10% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 244,907 0.14% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 217,540 0.13% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 297,049 0.17% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 498,231 0.29% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 395,117 0.23% MD ST -B 0.46% 8/1/2024 300,000 300,000 285,847 0.16% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 196,609 0.11% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 148,024 0.09% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 375,632 0.22% HAWAII ST -GB 0.80% 10/1/2024 125,000 124,938 119,509 0.07% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,279,801 0.74% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 179,833 0.10% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 96,622 0.06% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 138,448 0.08% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 312,711 0.18% CARSON -TXBL-REV 1.88% 1/15/2025 505,000 516,817 488,881 0.28% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 143,488 0.08% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 320,799 0.18% STANISLAUS CONSOL FIR 1.25% 4/1/2025 235,000 236,998 223,576 0.13% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 366,485 342,965 0.20% YALE UNIVERSITY 0.87% 4/15/2025 1,075,000 1,068,318 1,021,377 0.59% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 375,264 0.22% GOLDEN ST TOBACCO -B 1.40% 6/1/2025 300,000 300,000 284,197 0.16% LAKE PORT-REV-TXBL 1.18% 6/1/2025 155,000 155,233 146,938 0.08% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 234,416 0.13% U N I V CA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,242,765 1,155,763 0.66% SAN RAMON-TXBL 1.20% 7/1/2025 500,000 497,250 473,178 0.27% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 472,452 0.27% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 500,000 470,481 0.27% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 475,682 0.27% CASTRO VLY UNIF SCH 1.20% 8/1/2025 500,000 503,100 473,119 0.27% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 224,147 0.13% BELMONT-REDWOOD-A- 0.88% 8/1/2025 205,000 205,000 193,217 0.11% BELMONT-REDWOOD-B-REF 0.88% 8/1/2025 200,000 200,000 188,505 0.11% SAN BERNARDINO CCD 0.84% 8/1/2025 275,000 275,000 259,165 0.15% BELLFLOWER -TXBL 1.32% 8/1/2025 500,000 500,000 475,835 0.27% KLAMATH & TRINITY -B ** 1.83% 8/1/2025 250,000 250,000 240,040 0.14% SUTTER HEALTH 1.32% 8/15/2025 750,000 743,175 704,625 0.41% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value %of Portfolio M_ unitlual Securlttes Cont'd RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 357,276 0.21% MA CMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 204,019 0.12% CALIFORNIA STUNIV-B 0.86% 11/1/2025 100,000 100,000 92,750 0.05% STHRN KERN UNIF SD -B 1.08% 11/1/2025 370,000 370,000 348,223 0.20% VENTURA CNTY CA PUBLI ** 1.32% 11/1/2025 500,000 496,250 477,898 0.27% SACRAMENTO CNTY CA -B ** 1.04% 12/1/2025 485,000 471,275 455,304 0.26% BAY AREA CATOLL AUTH 2.43% 4/1/2026 230,000 245,834 225,273 0.13% CALIFORNIAST-TXBL-B 2.65% 4/1/2026 500,000 526,650 499,730 0.29% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 302,316 0.17% SAN FRANCISCO CA CITY 1.10% 6/15/2026 370,000 372,923 343,877 0.20% RED BLUFF-TXBL 1.46% 7/15/2026 350,000 356,965 326,431 0.19% SOCIETE GENERALE 1.35% 7/30/2026 500,000 500,000 500,000 0.29% BELMONT-REDWOOD-B-REF 1.10% 8/1/2026 205,000 205,000 191,519 0.11% SAN BERNARDINO CCD 1.10% 8/1/2026 230,000 230,000 215,126 0.12% BELLFLOWER-TXBL 1.60% 8/1/2026 465,000 463,512 441,378 0.25% KLAMATH & TRINITY -B ** 2.08% 8/1/2026 130,000 130,000 124,400 0.07% SAN FRANCISCO CO-TXBL 1.76% 9/1/2026 295,000 298,540 274,792 0.16% RIVERSIDE UNIF SD FIN ** 1.65% 9/1/2026 750,000 741,825 710,147 0.41% CALIFORNIA ST-TXBL 2.38% 10/1/2026 515,000 534,364 506,820 0.29% TEXASST-REF-TXBL 3.42% 10/1/2026 990,000 1,093,653 1,023,169 0.59% CA ST UNIV-D 1.14% 11/1/2026 375,000 369,563 342,939 0.20% OREGON ST -H -REF ** 1.19% 11/1/2026 115,000 112,309 107,550 0.06% CA ST DEPT OF WTR RES ** 1.05% 12/1/2026 500,000 485,500 463,170 0.27% NEW YORK ST ** 2.36% 2/15/2027 800,000 809,900 782,361 0.45% RIVERSIDE CO-TXBL-REV ** 2.96% 2/15/2027 205,000 206,046 204,119 0.12% SAN JOSE -C -REF -REV ** 1.73% 3/1/2027 195,000 189,345 182,454 0.10% Total Municipal Securities 37,365,000 37,817,491 36,489,409 20.99% Supranational Securities Interest Rate Maturity Date Par Value Cost Market Value %of Portfolio INTERAMER DEV ** 2.625 1/16/2024 300,000 309,510 301,755 0.17% INTERAMER DEV 0.39% 4/16/2024 500,000 499,900 479,959 0.28% INTL FIN CORP 0.60% 2/28/2025 500,000 496,250 475,905 0.27% INT BK RECON&D ** 2.05% 3/17/2025 750,000 740,400 741,476 0.43% INT BK RECON&D 0.65% 2/24/2026 500,000 493,900 465,612 0.27% INTERAMER DEV ** 0.82% 2/27/2026 500,000 501,500 465,252 0.27% INTL FIN CORP 2.13% 4/7/2026 396,000 418,730 390,537 0.22% INTERAMER DEV 0.80% 6/17/2026 500,000 496,750 469,705 0.27% INTL BK RECON & DEVELOP 0.88% 7/15/2026 500,000 500,900 468,699 0.27% INTL FIN CORP 0.82% 9/15/2026 400,000 396,720 372,759 0.21% INTL FIN CORP 0.75% 10/8/2026 250,000 246,000 231,690 0.13% INTERAMER DEV 1.50% 1/13/2027 1,000,000 995,900 957,015 0.55% Total Supranational Securities 6,096,000 6,096,460 5,820,363 3.35% INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS 95,020,000 95,346,297 92,718,653 53.34% TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS 176,451,062 173,823,418 100.00% * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. 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 June 2, 2021. 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.htmi. ooww r ;(� J,.,, � " Andrew Keys, Treassurrer/Director of Finance Susan Bjork, Budget Manager Jun 29, 2022 Jun 29, 2022 Review Date Review Date IRS Section 115 Retirement Benefit Trust Funds Market Value Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund $ 22,320,522 Total Pension Stabilization Fund $ 22,320,522 CalPERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 $ 2,367,307 Total CERBT $ 2,367,307 Total Section 115 Retirement Benefit Trust Funds $ 24,687,829 Restricted Cash Accounts Market Value PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market $ 527,838 Total PCE/TCE Central Plume Account $ 527,838 Total Restriction Cash Accounts $ 527,838