M E M O R A N D U M
February 5, 2025
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, November 2024
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 2024, 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: BEDCE180-6EC0-4D0A-A308-5DE1AC8A83F0
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 3,377,888.03 $ 39,769,421.53 $ 38,969,641.45 $ 4,177,668.11 Deposits in Transit 1,002,250.91 926,089.61 1,002,250.91 926,089.61 Outstanding Checks (1,734,739.97) 1,734,739.97 1,987,499.09 (1,987,499.09) Fiscal Agents 53,751,080.15 5,546,978.04 10,701,059.86 48,596,998.33 Developer Escrow Accounts 1,736,590.18 1,736,590.18
Investments
Chandler Investment- City Account 445,834,534.32 1,937,675.25 656,558.93 447,115,650.64 Chandler Investment -Pension Trust Fund 39,972,067.26 25,766.98 39,997,834.24 LAIF 23,042,026.35 16,400,000.00 13,200,000.00 26,242,026.35 Investments Subtotal 508,848,627.93 18,363,442.23 13,856,558.93 513,355,511.23 Change Fund 10,248.00 10,248.00
Returned Checks (2,093.01) 30,253.40 27,235.72 924.67
Credit Card Reconciling Items- Fees (2,565.45) 2,565.45 2,314.59 (2,314.59) TOTAL $ 566,987,286.77 $ 66,373,490.23 $ 66,546,560.55 $ 566,814,216.45 * For informational purpose only
CITY OF CORONA
Receipts and Disbursements*
November 30, 2024
Docusign Envelope ID: BEDCE180-6EC0-4D0A-A308-5DE1AC8A83F0
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 26,242,026.35 $ 26,242,026.35
Chandler Investment- City Account $ 447,115,650.64 $ 447,115,650.64 Chandler Investment -Pension Trust Fund $ 39,997,834.24 $ 39,997,834.24 Investment Total 513,355,511.23 513,355,511.23
General Account - Bank of America 4,063,150.44 423,847.86 (1,870,739.67) (1,389.92) 2,614,868.71 Worker's Comp Account - Bank of America 114,517.67 502,241.75 (116,759.42) 500,000.00 Fiscal Agent Accounts 48,596,998.33 48,596,998.33
Escrow Account 1,736,590.18 1,736,590.18
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 567,877,015.85 $ 926,089.61 $ (1,987,499.09) $ (1,389.92) $ 566,814,216.45 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
November 30, 2024
Docusign Envelope ID: BEDCE180-6EC0-4D0A-A308-5DE1AC8A83F0 General Fund $ 209,402,860.65
Special Revenue Funds
Gas Tax 13,083,321.78
Measure A 14,824,260.30
Trip Reduction 2,017,571.29
Asset Forfeiture 387,996.53
Development 34,304,268.96
Residential Refuse/Recycling (925,127.77)
Landscape and Streetlight Maintenance 26,068,325.25
Other Grants and Endowments 109,595,263.26 19,834,646.92 Debt Service Funds
Public Financing Authority 5,281.07 5,281.07
Capital Project Funds
Housing/Community Development (620,610.75)
Planned Local Drainage 803,069.26
Other Grants (4,824,241.12)
Public Facility Project (3,875,769.61)
Corona Housing Authority 29,944,859.35 21,427,307.13
Enterprise Funds
Water Utility 41,856,127.96
Water Reclamation Utility 63,952,360.71
Transit 939,764.63
Electric Utility 27,645,535.99
Airport 136,486,182.30 2,092,393.01
Internal Service Funds
Fleet Operations 1,628,649.57
Workers' Compensation 22,615,809.84
Liability Risk 590,595.27
Warehouse Services 1,218,933.12
Information Technology 10,218,783.56 36,272,771.36
Fiduciary Funds
AD & CFD Bond Funds 48,934,242.22
AB109 PACT -
Successor Agency 4,690,308.46 53,624,550.68
Total All Funds $ 566,814,216.45
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
November 30, 2024
Docusign Envelope ID: BEDCE180-6EC0-4D0A-A308-5DE1AC8A83F0
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 47,085,000.00 39,800,308.40 39,497,951.60 7.69%
Agency 48,195,000.00 47,167,912.41 48,137,813.50 9.38%
CMO 54,755,000.00 52,493,540.74 51,956,460.46 10.12%
Pension Trust 536,920.84 51,845,836.59 39,997,834.24 7.79% Receivable 702,323.17 702,323.17 702,323.17 0.14%
Corporate 114,203,000.00 112,864,925.49 113,038,932.46 22.02% LAIF 26,242,026.35 26,242,026.35 26,242,026.35 5.11%
Money Market Fund FI 21,334,955.28 21,334,955.28 21,334,955.29 4.16% Municipal Bonds 4,395,000.00 4,430,731.35 4,418,161.65 0.86% Supranational 12,690,000.00 12,180,394.10 12,633,094.65 2.46% US Treasury 156,245,000.00 154,374,079.37 155,395,957.86 30.27% TOTAL PORTFOLIO $ 486,384,225.64 523,437,033.25 $ 100.00% 513,355,511.23 Subject to final audit
CITY OF CORONA
Investment Portfolio Report
November 30, 2024
Docusign Envelope ID: BEDCE180-6EC0-4D0A-A308-5DE1AC8A83F0