M E M O R A N D U M
January 17, 2024
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, November 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 November 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: E2B667DC-7D47-4108-B8D0-98255A3433DA
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 5,628,132.15 $ 45,346,203.62 $ 43,984,799.23 $ 6,989,536.54 Deposits in Transit 1,397,878.64 1,310,179.91 1,397,878.64 1,310,179.91 Outstanding Checks (2,576,418.24) 2,576,418.24 4,260,835.42 (4,260,835.42) Fiscal Agents 30,524,989.49 5,600,062.69 10,849,281.63 25,275,770.55 Investments
Chandler Investment- City Account 470,043,414.66 53,265,371.35 52,508,648.83 470,800,137.18 Chandler Investment -Pension Trust Fund 32,960,101.38 17,464.46 32,977,565.84 LAIF 28,997,356.57 19,100,000.00 18,500,000.00 29,597,356.57 Investments Subtotal 532,000,872.61 72,382,835.81 71,008,648.83 533,375,059.59 Change Fund 10,248.00 10,248.00
Returned Checks 3,912.91 72,069.97 76,091.73 (108.85)
Credit Card Reconciling Items- Fees (2,376.25) 2,376.25 2,237.84 (2,237.84) TOTAL $ 566,987,239.31 $ 127,290,146.49 $ 131,579,773.32 $ 562,697,612.48 * For informational purpose only
November 30, 2023
CITY OF CORONA
Receipts and Disbursements*
DocuSign Envelope ID: E2B667DC-7D47-4108-B8D0-98255A3433DA
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 29,597,356.57 $ $ 29,597,356.57
Chandler Investment- City Account 470,800,137.18 $ $ 470,800,137.18 Chandler Investment -Pension Trust Fund 32,977,565.84 $ $ 32,977,565.84 Investment Total 533,375,059.59 533,375,059.59
General Account - Bank of America 6,537,278.94 1,030,628.98 (4,029,026.89) (2,346.69) 3,536,534.34 Worker's Comp Account - Bank of America 452,257.60 279,550.93 (231,808.53) 500,000.00 Fiscal Agent Accounts 25,275,770.55 25,275,770.55
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 565,650,614.68 $ 1,310,179.91 $ (4,260,835.42) $ (2,346.69) $ 562,697,612.48 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
November 30, 2023
DocuSign Envelope ID: E2B667DC-7D47-4108-B8D0-98255A3433DA General Fund $ 186,223,498.12
Special Revenue Funds
Gas Tax 11,359,501.38
Measure A 19,420,238.18
Trip Reduction 1,775,544.88
Asset Forfeiture 343,169.71
Development 30,867,990.58
Residential Refuse/Recycling (77,763.65)
Landscape and Streetlight Maintenance 23,744,447.62
Other Grants and Endowments 28,534,483.74 115,967,612.44 Debt Service Funds
Public Financing Authority 4,953.93 4,953.93
Capital Project Funds
Housing/Community Development 347,817.08
Planned Local Drainage 385,392.93
Other Grants 17,629,487.64
Public Facility Project (3,875,769.61)
Corona Housing Authority 42,689,008.57 28,202,080.53
Enterprise Funds
Water Utility 50,233,937.45
Water Reclamation Utility 74,889,983.99
Transit 1,153,293.93
Electric Utility 21,377,966.57
Airport 1,744,244.33 149,399,426.27
Internal Service Funds
Fleet Operations 4,982,779.28
Workers' Compensation 24,002,767.48
Liability Risk (572,689.47)
Warehouse Services 915,300.96
Information Technology 38,923,922.97 9,595,764.72
Fiduciary Funds
AD & CFD Bond Funds 25,160,238.36
AB109 PACT -
Successor Agency 29,489,190.18 4,328,951.82
Total All Funds $ 562,697,612.48
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
November 30, 2023
DocuSign Envelope ID: E2B667DC-7D47-4108-B8D0-98255A3433DA
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 24,352,820.94 23,955,808.89 24,349,208.84 4.57%
Agency 71,245,000.00 67,697,260.35 71,691,626.40 13.44% CMO 31,305,000.00 29,793,081.25 30,483,886.23 5.72%
Pension Trust 944,645.00 35,510,367.70 32,977,565.84 6.18% Corporate 96,176,000.00 91,602,241.66 95,480,879.39 17.90% LAIF 29,597,356.57 29,597,356.57 29,597,356.69 5.55%
Money Market Fund FI 3,082,456.15 3,082,456.15 3,082,456.15 0.58% Municipal Bonds 3,385,000.00 3,301,559.75 3,462,753.45 0.65% Supranational 12,690,000.00 11,659,518.46 12,633,094.65 2.37% US Treasury 233,570,000.00 226,030,549.37 229,616,231.95 43.05% TOTAL PORTFOLIO $ 506,348,278.66 $ 522,230,200.15 $ 533,375,059.59 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
November 30, 2023
DocuSign Envelope ID: E2B667DC-7D47-4108-B8D0-98255A3433DA