Pacifica City Council
October 14, 2024

City of Pacifica
Treasurer's Report
June 30,2024
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
Tri Counties Bank-General Account 22,542,716 $ 22,542,716 $ 22,542,716 $ 31.18% Tri Counties Bank-Payroll Account (4,095) (4,095) (4,095) -0.01% Tri Counties Bank-Workers Compensation Account - - - 0.00%Tri Counties Bank-Senior Services Account - - - 0.00%Tri Counties Bank-Turbo Data 10,470 10,470 10,470 0.01% City National Bank-Roy Davies Trust 2,702,353 2,702,353 2,702,353 3.74%Petty Cash - Held by various Departments 3,445 3,445 3,445 0.00% Total Cash $ 25,254,889 $ 25,254,889 $ 25,254,889 34.94% Investments
California Local Agency Investment Fund (LAIF)* $ 16,544,627 $ 16,483,677 $ 16,544,627 22.89% Bank of New York Mellon-RDA 2004 Bonds 242,887 242,887 242,887 0.34% US Bank - Money Market Fund 29,872,384 29,872,384 29,872,384 41.32% PARS PENSION** 375,291 375,291 375,291 0.52%
Total Investments $ 47,035,188 $ 46,974,239 $ 47,035,188 65.06% Total Cash and Investments $ 72,290,077 $ 72,229,128 $ 72,290,077 100.00% Date
Yulia Carter, Assistant City Manager* LAIF FAIR VAUE RATE 0.996316042 https://www.treasurer.ca.gov/pmia-laif/reports/valuation.asp The above investments are consistent with the City's Investment Policy and are allowable under current legislation of the State of California. Investments are selecte using safety, liquidity, and yield as the criteria. The City has sufficient cash flow to cover anticipated expenditures through the next six months. * PARS TRUST - PUBLIC AGENCY RETIREMENT SERVICES - INVESTS IN CAPITAL APPRECIATION FUNDS FOR THE CITY'S OPEB TRUSTAND MODERATE INDEX FUNDS 10/8/2024
City of Pacifica
Treasurer's Report
June 30,2024
Reconciliation to General Ledger
Description Bank Account # Bank Amount
TRI COUNTIES GENERAL CHECKING ACCOUNT xx0541 23,393,017 TRI COUNTIES CDARS ACCOUNT xx0424 -
TRI COUNTIES PAYROLL ACCOUNT xx6915 -
TRI COUNTIES WORKERS COMP ACCOUNT xx1341 -
TRI COUNTIES SENIOR SERVICES ACCOUNT xx5996 -
TRI COUNTIES TURBO DATA ACCOUNT xx9758 10,470
CITY NATIONAL BANK ROY DAVIES TRUST-PRINCIPAL xx5367 2,702,353 LOCAL AGENCY INVESTMENT FUND (LAIF) xx1614/xx1007 16,544,627 BNY- RDA xx0166/xx0167 242,887
US BANK - 2014 WASTEWATER BONDS 2126700 90
US BANK - 2016 REFUNDING 24952500 264,993
US BANK - 2017 WASTEWATER REVENUE BOND-PROJECT FUND 27843200 4,361,874 US BANK - 2019 TAXABLE PENSION OBLIGATION BOND 267004000-3 1 US BANK - 2021 CIVIC CENTER BONDS 249299000 4,132,923
US BANK - 2023 WW IBANK LOAN 207877539 21,112,503
PARS- PENSION&OPEB PACIFICA 375,291
PETTY CASH PETTY CASH 3,445
DEPOSIT IN TRANSIT 293,888
OUTSTANDING AP CHECKS at 3/31/24 (1,099,516)
OUTSTANDING PAYROLL WIRE (44,673)
OUTSTANDING PR CHECKS at 3/31/24 (4,095)
TOTAL ADJUSTED BANK BALANCE 72,290,077
Description GL Account # BooK Amount
CASH IN GENERAL ACCOUNT xx.xxxxxx.11000.xxxx.xxx 22,581,617 CASH IN BANK - TURBO 01.000000.11001.0000.000 10,470
CASH IN BANK - PAYROLL 01.000000.11002.0000.000 (4,095) BNY- RDA DEBT SERVICE RESERVE FUND - 2004 TAB 91.960000.11019.0000.000 133,294 BNY-RDA CASH WITH FISCAL AGENT 91.960000.11020.0000.000 109,593 CITY OF PACIFICA 2021 PROJECT FUND 22.900000.11022.0000.000 4,132,923 CASH RESERVE - 2016 LEASE PAYMENT 40.880000.11026.0000.000 264,993 RESERVE CASH-2014 WASTEWATER REVENUE REFUNDING 18.940000.11032.0000.000 90 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING PROJECT 18.940000.11033.0000.000 4,360,642 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING INTEREST 18.940000.11034.0000.000 1,232 RESERVE CASH-2019 POB BONDS 40.880000.11036.0000.000 1
US BANK-2023 WASTE WATER BANK LOAN 18.940000.11040.0000.000 21,112,503 PETTY CASH xx.xxxxxx.11100.xxxx.xxx 3,445
INVESTMENTS - LAIF 01.000000.11290.0000.000 16,544,627
R DAVIES TRUST 27.900000.11293.0000.000 2,702,353
PARS TRUSTS-PENSION 01.000000.11297.0000.000 375,291
evan Hu manual check#1121 on 7/5/24 (790)
ACH on 6/24/24 cafeteria cash on 7/5/24 (38,111)
TOTAL ADJUSTED BOOK BALANCE 72,290,077