M E M O R A N D U M
November 15, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, September 2023
Pursuant to CMC Section 2.28.010 (D) the attached report provides an accounting of all receipts, disbursements, and fund balances for the month of September 2023, subject to final audit.
Prepared By: Reviewed By:
_______________________________ _______________________________ Financial Analyst Accounting Manager
Respectfully submitted:
_______________________________ _______________________________ Finance Director Assistant City Manager
_______________________________
City Treasurer
Attachment
DocuSign Envelope ID: 73DA12FC-8E7F-4261-8038-2591E8746075
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 8,052,744.43 $ 39,960,209.07 $ 44,280,699.66 $ 3,732,253.84 $ Deposits in Transit 2,147,079.11 2,124,113.05 2,147,079.11 2,124,113.05 Outstanding Checks (2,741,716.72) 2,741,716.72 1,928,785.95 (1,928,785.95) Fiscal Agents 36,634,682.54 12,626,809.11 25,035,713.24 24,225,778.41 Investments
Chandler Investment- City Account 468,637,669.60 46,649,949.91 46,269,087.95 469,018,531.56 Chandler Investment -Pension Trust Fund 32,782,946.15 61,472.55 32,844,418.70 LAIF 38,526,879.61 13,600,000.00 16,000,000.00 36,126,879.73 Investments Subtotal 539,947,495.36 60,311,422.46 62,269,087.95 537,989,829.99 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 1,877.69 53,841.35 53,880.99 1,838.05
Credit Card Reconciling Items- Fees (2,423.39) 2,423.39 2,437.45 (2,437.45) TOTAL $ 117,820,535.15 584,049,987.02 $ 135,717,684.35 $ 566,152,837.94 $ * For informational purpose only
September 30, 2023
CITY OF CORONA
Receipts and Disbursements*
DocuSign Envelope ID: 73DA12FC-8E7F-4261-8038-2591E8746075
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 36,126,879.73 $ $ 36,126,879.73
Chandler Investment- City Account 469,018,531.56 $ $ 469,018,531.56 Chandler Investment -Pension Trust Fund 32,844,418.70 $ $ 32,844,418.70 Investment Total 537,989,829.99 537,989,829.99
General Account - Bank of America 3,419,360.15 1,774,614.61 (1,766,393.82) (599.40) 3,426,981.54 Worker's Comp Account - Bank of America 312,893.69 349,498.44 (162,392.13) 500,000.00 Fiscal Agent Accounts 24,225,778.41 24,225,778.41
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 565,958,110.24 $ 2,124,113.05 $ (1,928,785.95) $ (599.40) $ 566,152,837.94 $ Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
September 30, 2023
DocuSign Envelope ID: 73DA12FC-8E7F-4261-8038-2591E8746075 General Fund $ 185,540,043.07
Special Revenue Funds
Gas Tax 10,319,394.39
Measure A 18,866,488.14
Trip Reduction 1,777,341.07
Asset Forfeiture 352,315.23
Development 30,539,323.27
Residential Refuse/Recycling 842,135.08
Landscape and Streetlight Maintenance 24,965,329.52
Other Grants and Endowments 28,967,072.94 116,629,399.64 Debt Service Funds
Public Financing Authority 19.83 19.83
Capital Project Funds
Housing/Community Development 488,581.10
Planned Local Drainage 495,611.46
Other Grants 20,522,940.05
Public Facility Project (3,875,769.61)
Corona Housing Authority 45,821,137.98 28,189,774.98
Enterprise Funds
Water Utility 48,285,510.47
Water Reclamation Utility 74,327,925.14
Transit 641,847.19
Electric Utility 20,175,216.70
Airport 1,669,782.27 145,100,281.77
Internal Service Funds
Fleet Operations 5,747,424.06
Workers' Compensation 24,271,351.94
Liability Risk (512,562.68)
Warehouse Services 949,875.77
Information Technology 42,085,012.67 11,628,923.58
Fiduciary Funds
AD & CFD Bond Funds 24,973,338.55
AB109 PACT -
Successor Agency 30,976,942.98 6,003,604.43
Total All Funds $ 566,152,837.94
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
September 30, 2023
DocuSign Envelope ID: 73DA12FC-8E7F-4261-8038-2591E8746075
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 27,932,232.15 27,352,919.45 27,928,256.78 5.19%
Agency 71,245,000.00 66,951,382.48 71,691,626.40 13.33% CMO 31,405,853.62 29,502,893.39 30,588,671.57 5.69%
Pension Trust 811,497.86 33,842,124.01 32,844,418.70 6.11% Corporate 96,176,000.00 90,261,670.90 95,480,879.39 17.75% LAIF 36,126,879.61 36,126,879.61 36,126,879.73 6.72%
Money Market Fund FI 803,433.98 803,433.98 803,433.98 0.15% Municipal Bonds 3,385,000.00 3,280,711.54 3,462,753.45 0.64% Supranational 12,690,000.00 11,499,216.04 12,633,094.65 2.35% US Treasury 229,620,000.00 221,365,108.25 226,429,815.34 42.09% TOTAL PORTFOLIO $ 520,986,339.65 510,195,897.22 $ 537,989,829.99 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
September 30, 2023
DocuSign Envelope ID: 73DA12FC-8E7F-4261-8038-2591E8746075