Loading...
HomeMy WebLinkAboutAgenda Report - November 7, 2018 C-04TM CITY OF LODI COUNCIL COMMUNICATION AGENDA ITEM C-4 AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: November 7, 2018 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, 2018 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: http://www.lodi.gov/finance/revenue.html. FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: As per attached report. 0/1440,J Andrew Keys Treasurer Attachment APPROVED: auer, 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 CALTRUST Medium Term Fund Total Bond Mutual Funds Local Bank Certificates of Deposit Farmers & Merchants Bank BBVA Compass Total Local Bank Certificates of Deposit CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Negotiable Certificates of Deposit MORGAN STANLEY BANK NA MORGAN STANLEY PRIVATE BANK WEX BANK INTEREST BEARING PACIFIC CITY BANK INTEREST MARQUIS BANK INTEREST BEARING BRIDGEWATER BANK BLOOMINGTON MINNESOTA BELMONT SAVINGS BANK INTEREST TIAA FSB INTEREST BEARING ALLY BANK INTEREST BANKING BERKSHIRE BANK PITTSFIELD NEBRASKALAND NATIONAL BANK MB FINANCIAL BANK NA MERRICK BANK DISCOVER BANK THIRD FEDERAL SAVINGS & LOAN CLEVELAND BMW BANK NORTH AMERICA ENERBANK USA BMO HARRIS BANK NATIONAL ASSN HORIZON BANK NATION ASSN CAPITAL ONE BANK USA NA CAPITAL ONE NA GOLDMAN SACHS BANK USA WELLS FARGO BANK NA JP MORGAN CHASE BANK NA AMERICAN EXPRESS BANK FSB SYNCHRONY BANK SALLIE MAE BANK/SALT LAKE CITY, UTAH STATE BANK OF INDIA BANK UNITED NA MEDALLION BANK UTAH STIFEL BANK AND TRUST CITIBANK NA INDUSTRIAL & COM BK CHNA ** COMENITY CAPITAL BANK ** ANCHOR D BANK ** Total Negotiable Certificates of Deposit Agency Securltles FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION TENNESSEE VALLEY AUTHORITY Due on Demand Due on Demand Due on Demand Due on Demand Due on Demand 4,076,791 55,028 17,050,830 3,808,935 3,028 4,076,791 55,028 17,050,830 3,808,935 3,028 24,994,613 24,994,613 4.21% 0.06% 1759% 3.93% 0.00% 25.79% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 12,434,900 12,434,900 12.83% 12,434, 900 12,434,900 12.83% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.00% 11/7/2019 2,000,000 2,000,000 2,000,000 2.06% 2.50% 3/13/2021 249,995 249,995 249,995 0.26% 2,249,995 2,249,995 2,249,995 2.32% Interest Rate Maturity Date Par Value Cost 1.80% 11/22/2019 1.75% 11/22/2019 1.75% 11/22/2019 1.70% 11/25/2019 1.70% 11/29/2019 2.20% 8/17/2020 1.95% 11/23/2020 1.95% 11/23/2020 2.05% 11/24/2020 1.85% 11/24/2020 1.85% 11/27/2020 2.00% 11/17/2021 2.10% 11/17/2021 2.15% 11/22/2021 2.10% 11/24/2021 2.20% 11/29/2021 2.55% 1/18/2022 2.80% 4/13/2022 2.85% 5/4/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.30% 11/30/2022 2.50% 12/5/2022 2.60% 1/19/2023 2.65% 1/24/2023 2.70% 2/16/2023 2.90% 3/29/2023 2.90% 4/10/2023 2.95% 5/15/2023 3.25% 6/6/2023 3.30% 6/30/2023 3.30% 7/16/2023 3.20% 9/21/2023 Interest Rate 1.38% 1.45% 0.88% 1.50% 2.05% 1.50% 2.25% 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 Market Value % of Portfolio 250,000 247,808 0.26% 250,000 247,667 0.26% 250,000 247,667 0.26% 250,000 247,495 0.26% 250,000 247,460 0.26% 250,000 246,968 0.25% 250,000 244,877 0.25% 250,000 244,897 0.25% 250,000 245,407 0.25% 250,000 244,369 0.25% 250,000 244,318 0.25% 250,000 241,778 0.25% 250,000 242,524 0.25% 250,000 242,888 0.25% 250,000 242,498 0.25% 250,000 243,203 0.25% 250,000 245,509 0.25% 250,000 247,085 0.25% 250,000 247,379 0.26% 250,000 242,005 0.25% 250,000 242,005 0.25% 250,000 242,005 0.25% 250,000 239,950 0.25% 250,000 240,974 0.25% 246,699 240,929 0.25% 250,000 243,500 0.25% 250,000 243,963 0.25% 250,000 244,304 0.25% 250,000 246,075 0.25% 250,000 246,024 0.25% 250,000 246,318 0.25% 250,000 249,436 0.26% 250,000 249,885 0.26% 250,000 249,818 0.26% 250,000 248,426 0.26% 8,750,000 8,746,699 8,577,413 8.85% Maturity Date Par Value Cost 3/18/2019 500,000 6/3/2019 500,000 8/5/2019 500,000 12/30/2019 500,000 1/30/2020 250,000 2/28/2020 500,000 3/15/2020 250,000 1 Market Value 496,996 497,722 496,507 491,629 495,085 247,902 494,585 248,441 496,491 492,811 492,684 247,783 491,449 248,153 % of Portfolio 0.51% 0.51% 0.51% 0.51% 0.26% 0.51% 0.26% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2018 TYPE OF INVESTMENT Agency Securiteis (continued) FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION STEP FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION STEP FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL AGRICULTURE MORTGAGE CORPORATION ** FEDERAL FARM CREDIT BANK SYSTEM ** FEDERAL HOME LOAN MORTGAGE CORPORATION ** Total Agency Securities US Treasury Notes UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY Interest Rate Marurity Date Par Value Cost Market Value % of Portfolio 2.50% 2.55% 1.55% 2.84% 1.50% 1.70% 5.25% 2.15% 2.35% 2.38% 1.75% 1.25% 1.50% 1.02% 2.30% 1.25% 2.00% 1.38% 2.63% 2.00% 2.00% 2.63% 1.65% 2.62% 1.88% 1.75% 2.00% 3.13% 2.25% 2.45% 2.38% 2.00% 2.70% 2.65% 2.70% 2.85% 2.50% 2.90% 3.24% 3.00% 4/27/2020 5/15/2020 7/27/2020 9/17/2020 10/22/2020 11/13/2020 12/11/2020 1/26/2021 2/22/2021 3/12/2021 4/9/2021 5/6/2021 6/30/2021 7/27/2021 7/30/2021 8/17/2021 9/28/2021 10/7/2021 12/10/2021 1/5/2022 2/28/2022 3/11/2022 4/19/2022 5/27/2022 6/1/2022 7/5/2022 8/26/2022 9/9/2022 10/27/2022 12/29/2022 1/19/2023 1/30/2023 2/23/2023 3/8/2023 4/11/2023 5/8/2023 6/28/2023 7/24/2023 8/14/2023 9/26/2023 250,000 250,000 500,000 250,000 205,000 250,000 250,000 500,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 230,000 250,000 500,000 250,000 250,000 250,000 250,000 250,000 250,000 500,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 13,935,000 249,526 248,854 0.26% 249,734 248,995 0.26% 492,355 488,743 0.50% 251,200 250,009 0.26% 199,527 199,326 0.21% 244,468 243,848 0.25% 266,094 262,522 0.27% 498,625 490,836 0.51% 247,195 247,383 0.26% 247,737 247,002 0.25% 242,978 242,703 0.25% 240,040 239,842 0.25% 242,625 240,889 0.25% 246,750 244,724 0.25% 249,125 245,272 0.25% 238,514 238,809 0.25% 244,105 243,370 0.25% 238,923 238,838 0.25% 248,755 247,556 0.26% 243,235 242,783 0.25% 221,548 222,130 0.23% 248,853 247,393 0.26% 481,125 477,799 0.49% 249,465 247,041 0.25% 242,059 240,574 0.25% 238,208 239,193 0.25% 242,734 240,768 0.25% 254,254 251,157 0.26% 246,063 242,058 0.25% 494,125 487,616 0.50% 246,300 243,717 0.25% 249,375 247,390 0.26% 248,000 245,369 0.25% 249,325 246,275 0.25% 249,500 246,674 0.25% 250,174 248,353 0.26% 249,750 249,413 0.26% 249,160 248,240 0.26% 250,000 248,311 0.26% 250,000 249,604 0.26% 13,762,667 13,688,467 14.12% Interest Rate Maturity Date Par Value Cost 0.75% 1.63% 1.25% 1.38% 1.75% 1.38% 1.63% 1.38% 1.13% 1.25% 1.38% 1.38% 1.13% 1.13% 2.00% 1.13% 2.00% 2.00% 1.50% 2/15/2019 4/30/2019 5/31/2019 7/31/2019 9/30/2019 4/30/2020 6/30/2020 1/31/2021 2/28/2021 3/31/2021 4/30/2021 5/31/2021 6/30/2021 7/31/2021 8/31/2021 9/30/2021 10/31/2021 12/31/2021 1/31/2022 2 500,000 500,000 500,000 500,000 500,000 500,000 500,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 400,000 250,000 Market Value % of Portfolio 494,071 497,012 0.51% 497,934 497,617 0.51% 495,276 495,859 0.51% 495,315 495,059 0.51% 497,480 495,508 0.51% 491,523 489,160 0.50% 493,607 489,961 0.51% 241,844 241,670 0.25% 239,815 239,932 0.25% 240,368 240,361 0.25% 240,904 240,781 0.25% 240,547 240,430 0.25% 238,335 238,496 0.25% 237,921 238,115 0.25% 244,513 243,887 0.25% 237,186 237,422 0.24% 244,134 243,467 0.25% 394,512 388,859 0.40% 240,139 238,896 0.25% TYPE OF INVESTMENT US Treasury Notes (contInuedi UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio ss UNITED STATES TREASURY ** Total US Treasury Notes Corporate Securities TOYOTA MOTOR CREDIT CORPORATION PEPSICO INC GENERAL ELECTRIC CO MERCK & COMPANY INC CHEVRON CORP NEVADA POWER COMPANY IBM CORP CISCO SYSTEMS INC TARGET CORPORATION AUTOMATIC DATA PROCESSING BANK OF AMERICA CORP COCA-COLA COMPANY WELLS FARGO & COMPANY WELLS FARGO BANK NA MICROSOFT CORP CISCO SYSTEMS INC EXXON MOBIL CORPORATION BERKSHIRE HATHAWAY INC PNC BANK NA COSTCO WHOLESALE CORP ALPHABET INC TOTAL CAPITAL INTERNATIONAL SA AMERICAN HONDA FINANCE APPLE INC MIZUHO FINANCIAL CORPORATION BOEING COMPANY PFIZER INC TOYOTA MOTOR CREDIT CORP PACIFICORP JOHNSON & JOHNSON TD AMERITRADE HOLDING COMPANY ORACLE CORP UNITED PARCEL SERVICE DEERE & COMPANY 3M COMPANY TOYOTA MOTOR CREDIT CORPORATION PROCTER & GAMBLE COMPANY MERCK & CO INC JPMORGAN CHASE & CO GENERAL ELECTRIC CO MICROSOFT CORP AUSTRALIA & NEW ZEALAND BANKING GROUP NY 1.88% 2/28/2022 250,000 243,370 241,650 0.25% 1.88% 3/31/2022 250,000 243,143 241,426 0.25% 1.75% 5/31/2022 250,000 242,223 239,902 0.25% 1.75% 6/30/2022 250,000 242,065 239,697 0.25% 1.88% 7/31/2022 250,000 243,028 240,537 0.25% 1.63% 8/31/2022 250,000 240,313 238,008 0.25% 1.88% 9/30/2022 250,000 242,668 240,078 0.25% 2.00% 10/31/2022 250,000 243,745 241,055 0.25% 2.00% 11/30/2022 250,000 243,603 240,869 0.25% 2.13% 12/31/2022 250,000 244,688 241,885 0.25% 1.50% 2/28/2023 250,000 237,063 235,137 0.24% 1.50% 3/31/2023 250,000 236,790 234,902 0.24% 1.63% 4/30/2023 250,000 238,225 235,938 0.24% 1.63% 5/31/2023 250,000 236,525 235,713 0.24% 2.63% 6/30/2023 250,000 247,329 246,445 0.25% 1.25% 7/31/2023 250,000 231,621 230,986 0.24% 10, 650, 000 10,361,819 10,316,721 10.64% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.10% 1/17/2019 500,000 501,165 499,568 0.52% 1.35% 10/4/2019 500,000 494,006 493,123 0.51% 2.20% 1/9/2020 500,000 499,181 494,706 0.51% 1.85% 2/10/2020 300,000 296,400 295,888 0.31% 1.96% 3/3/2020 500,000 498,091 493,578 0.51% 2.75% 4/15/2020 250,000 249,765 249,294 0.26% 1.63% 5/15/2020 500,000 494,010 489,597 0.51% 2.45% 6/15/2020 250,000 248,618 248,018 0.26% 3.88% 7/15/2020 250,000 256,310 254,241 0.26% 2.25% 9/15/2020 300,000 297,516 296,174 0.31% 2.63% 10/19/2020 500,000 503,172 493,960 0.51% 2.45% 11/1/2020 250,000 248,290 247,283 0.26% 2.55% 12/7/2020 200,000 199,591 196,852 0.20% 2.60% 1/15/2021 250,000 246,540 245,789 0.25% 4.00% 2/8/2021 100,000 104,600 102,519 0.11% 2.20% 2/28/2021 150,000 147,659 146,875 0.15% 2.22% 3/1/2021 150,000 147,915 147,019 0.15% 2.20% 3/15/2021 100,000 99,297 98,054 0.10% 2.15% 4/29/2021 500,000 495,965 485,866 0.50% 2.15% 5/18/2021 100,000 99,008 97,824 0.10% 3.63% 5/19/2021 100,000 104,000 101,574 0.10% 2.75% 6/19/2021 250,000 248,075 247,397 0.26% 1.65% 7/12/2021 250,000 239,433 239,769 0.25% 1.55% 8/4/2021 500,000 485,396 479,627 0.49% 2.27% 9/13/2021 250,000 240,903 240,538 0.25% 2.35% 10/30/2021 250,000 245,363 244,937 0.25% 2.20% 12/15/2021 200,000 198,284 194,519 0.20% 2.60% 1/11/2022 250,000 246,665 244,616 0.25% 2.95% 2/1/2022 250,000 249,816 246,597 0.25% 2.25% 3/3/2022 250,000 245,167 244,088 0.25% 2.95% 4/1/2022 250,000 247,243 245,179 0.25% 2.50% 5/15/2022 100,000 99,204 97,330 0.10% 2.35% 5/16/2022 100,000 98,749 96,627 0.10% 2.60% 6/8/2022 100,000 99,153 97,556 0.10% 2.00% 6/26/2022 150,000 144,485 143,936 0.15% 2.80% 7/13/2022 250,000 246,950 245,143 0.25% 2.15% 8/11/2022 250,000 243,146 240,645 0.25% 2.40% 9/15/2022 100,000 98,701 96,934 0.10% 3.25% 9/23/2022 100,000 101,377 99,116 0.10% 2.70% 10/9/2022 250,000 242,535 241,242 0.25% 2.65% 11/3/2022 250,000 247,580 244,899 0.25% 2.63% 11/9/2022 250,000 243,450 240,713 0.25% 8 TYPE OF INVESTMENT Corporate Securities {continued{ VISA INC JPMORGAN CHASE & CO BANK OF NEW YORK MELLON CORP WELLS FARGO & COMPANY UNITED HEALTH GROUP INC EXXON MOBIL CORPORATION WALMART INC APPLE INC SOUTHERN CALIFORNIA EDISON CHEVRON CORPORATION ORACLE CORP ** SHELL INTERNATIONAL FIN ** GILEAD SCIENCES INC ** Total Corporate Securities CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Munitfpal Securities OREGON ST DEPT OF ADMINISTRATIVE SERVICES CALIFORNIA STATE TAXABLE -VARIOUS UNIVERSITY OF CALIFORNIA CA REVENUES UTAH ST BUILD AMERICA SANTA MONICA CA COMMUNITY COLLEGE DISTRICT CAMPBELL CA UNION HIGH SCHOOL DISTRICT LOS ANGELES CA MUNICIPAL IMPT CORPL SAN RAMON CA REDEVELOPMENT AGENCY CONNECTICUT GENERAL OBLIGATION POMONA CA REVENUE WATER FACILITIES PROJECT ALAMEDA COUNTY CA JOINT POWERS AUTHORITY LANCASTER CA REDEVELOPMENT AGENCY CONNECTICUT ST GENERAL OBLIGATION OAKLEY CA REDEVELOPMENT AGENCY SCOTTS VALLEY CA REDEVELOPMENT AGENCY SANTA FE SPRINGS CA COMMUNITY DEVELOPMENT PALM DESERT CA REDEVELOPMENT AGENCY TEXAS ST PUBLIC FINANCE AUTHORITY CALIFORNIA STATE HIGH SPEED RAIL UNIVERSITY OF CALIFORNIA UNIVERSITY OF CALIFORNIA CA REVENUES BURBANK-GLENDALE-PASADENA AIPORT AUTHORITY LA MIRADA CA REDEVELOPMENT YUBA LEVEE FINANCING AUTHORITY SAN DIEGO CA REDEVELOPMENT AGENCY ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM STATE OF MARYLAND CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY CALIFORNIA STATE DEPT OF WATER RESOURCES TULARE COUNTY CA PENSION OBLIGATION ADELANTO PUBLIC UTILITIES ARKANSAS ST AMENDMENT 82 OCEANSIDE CA PENSION OBLIGATION SAN BERNARDINO COUNTY REDEVELOPMENT VISTA CA REDEVELOPMENT SAN LEANDRO CA REDEVELOPMENT AGENCY SAN FRANCISCO CITY & COUNTY CA CALIFORNIA DEPARTMENT OF WATER RESOURCES CALIFORNIA HOUSING FINANCE AGENCY CARSON CA REDEVELOPMENT GEORGIA ST GENERAL OBLIGATION OHIO ST THIRD FRONTIER RESEARCH RIVERSIDE CA PENSION OBLIGATION SAN DIEGO TOBACCO SETTLEMENT ** 2.80% 12/14/2022 250,000 247,518 245,038 0.25% 2.97% 1/15/2023 150,000 147,503 146,095 0.15% 2.95% 1/29/2023 100,000 100,069 97,549 0.10% 3.45% 2/13/2023 150,000 152,147 147,343 0.15% 2.75% 2/15/2023 100,000 99,143 96,994 0.10% 2.73% 3/1/2023 250,000 247,040 244,420 0.25% 2.55% 4/11/2023 250,000 244,525 242,309 0.25% 2.40% 5/3/2023 250,000 240,887 240,354 0.25% 3.40% 6/1/2023 254,000 252,849 251,571 0.26% 3.19% 6/24/2023 250,000 249,295 248,187 0.26% 3.63% 7/15/2023 250,000 253,415 252,765 0.26% 3.40% 8/12/2023 250,000 252,275 249,693 0.26% 2.50% 9/1/2023 260,000 249,886 248,140 0.26% 13,614,000 13,479,323 13,359,669 13.78% Interest Rate Maturity Date Par Value Cost 1.60% 4/1/2019 250,000 2.25% 5/1/2019 245,000 1.80% 7/1/2019 100,000 3.19% 7/1/2019 100,000 1.63% 8/1/2019 230,000 1.50% 8/1/2019 155,000 2.34% 11/1/2019 260,000 2.75% 2/1/2020 105,000 2.29% 3/15/2020 500,000 2.01% 5/1/2020 150,000 2.60% 6/1/2020 550,000 2.39% 8/1/2020 235,000 2.50% 8/1/2020 265,000 2.85% 9/1/2020 145,000 2.25% 9/1/2020 150,000 1.63% 9/1/2020 235,000 2.25% 10/1/2020 250,000 3.53% 10/1/2020 350,000 2.63% 4/1/2021 500,000 3.24% 5/15/2021 150,000 1.79% 5/15/2021 250,000 4.13% 7/1/2021 90,000 2.91% 8/15/2021 250,000 2.86% 9/1/2021 250,000 2.25% 9/1/2021 250,000 2.41% 2/1/2022 250,000 2.65% 3/15/2022 300,000 2.46% 4/1/2022 250,000 2.00% 5/1/2022 300,000 3.20% 6/1/2022 250,000 3.50% 7/1/2022 240,000 2.84% 7/1/2022 100,000 3.84% 8/15/2022 200,000 3.25% 9/1/2022 160,000 3.00% 9/1/2022 120,000 3.21% 9/1/2022 260,000 2.40% 11/1/2022 445,000 2.52% 12/1/2022 275,000 2.88% 2/1/2023 200,000 3.00% 2/1/2023 80,000 2.23% 2/1/2023 310,000 2.11% 5/1/2023 250,000 2.63% 6/1/2023 250,000 3.44% 6/1/2023 500,000 4 248,723 245,348 99,503 100,917 228,316 153,402 259,093 104,941 493,235 148,584 550,506 236,203 262,448 147,120 150,111 228,133 247,823 358,351 501,060 152,684 244,733 94,323 253,195 252,980 246,163 246,915 300,480 246,270 291,678 250,245 246,936 100,499 209,604 161,840 120,960 260,887 437,052 272,212 200,000 81,000 299,559 240,273 243,888 500,745 Market Value % of Portfolio 248,823 0.26% 244,304 0.25% 99,017 0.10% 100,362 0.10% 227,960 0.24% 153,245 0.16% 258,411 0.27% 104,505 0.11% 491,915 0.51% 147,284 0.15% 546,128 0.56% 231,294 0.24% 260,410 0.27% 143,699 0.15% 147,164 0.15% 227,219 0.23% 245,593 0.25% 354,221 0.37% 496,250 0.51% 150,767 0.16% 242,225 0.25% 91,186 0.09% 246,160 0.25% 246,813 0.25% 243,153 0.25% 243,475 0.25% 292,863 0.30% 243,040 0.25% 289,104 0.30% 248,088 0.26% 240,799 0.25% 98,671 0.10% 203,828 0.21% 157,234 0.16% 119,261 0.12% 259,444 0.27% 427,957 0.44% 268,202 0.28% 194,552 0.20% 77,648 0.08% 297,668 0.31% 236,130 0.24% 240,743 0.25% 495,585 0.51% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2018 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities (continued) CALIFORNIA VARIOUS PURPOSE ** 3.50% 8/1/2023 305,000 310,481 308,007 0.32% CENTRAL CONTRA COSTA SANITATION DISTRICT ** 3.12% 9/1/2023 415,000 417,283 413,294 0.43% Total Municipal Securities 11,475,000 11,446,698 11,303,698 11.66% INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS 60,673,995 60,047,201 59,495,962 61.38% TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. 97,476,714 96,925,474 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 January 20, 2016. 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• ww.lodi.gov/finance/revenue.html, �7Ltin� fW y •Lh � i L Andrew Keys, Treasurer/Director Finance Susan Bjork, Budget Man ger Dhfij \ 8 [D Review Date Review Date 5 IRS Section 115 Retirement Benefit Trust Funds Market Value Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund $ 11,595,138 Total Pension Stabilization Fund 5 11,595,138 Cal PERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 $ Total CERBT $ 1,160,944 1,160,944 Total Section 115 Retirement Benefit Trust Funds $ 12,756,082 Restricted Cash Accounts Market Value PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market $ Total PCE/TCE Central Plume Account $ 2,181,788 2,181,788 Total Restriction Cash Accounts S 2,181,788