M E M O R A N D U M
November 20, 2024
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, September 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 September 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: 0D317CC0-4990-4B2C-BB7E-80CD07EFCBAD
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 4,200,863.38 $ 49,656,316.45 $ 51,560,026.06 $ 2,297,153.77 Deposits in Transit 802,937.16 1,373,495.54 802,937.16 1,373,495.54 Outstanding Checks (1,454,563.69) 1,454,563.69 1,071,161.65 (1,071,161.65) Fiscal Agents 34,123,353.04 11,777,412.53 23,552,468.93 22,348,296.64 Investments
Chandler Investment- City Account 469,092,622.30 55,001,923.23 63,860,513.28 460,234,032.25 Chandler Investment -Pension Trust Fund 39,756,866.11 190,082.05 39,946,948.16 LAIF 18,531,358.66 17,800,000.00 15,800,000.00 20,531,358.66 Investments Subtotal 527,380,847.07 72,992,005.28 79,660,513.28 520,712,339.07 Change Fund 10,248.00 10,248.00
Returned Checks 101,194.01 93,891.17 7,302.84
Credit Card Reconciling Items- Fees (2,523.27) 2,523.27 2,986.66 (2,986.66) TOTAL $ 565,061,161.69 $ 137,357,510.77 $ 156,743,984.91 $ 545,674,687.55 * For informational purpose only
CITY OF CORONA
Receipts and Disbursements*
September 30, 2024
Docusign Envelope ID: 0D317CC0-4990-4B2C-BB7E-80CD07EFCBAD
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 20,531,358.66 $ $ 20,531,358.66
Chandler Investment- City Account 460,234,032.25 $ $ 460,234,032.25 Chandler Investment -Pension Trust Fund 39,946,948.16 $ $ 39,946,948.16 Investment Total 520,712,339.07 520,712,339.07
General Account - Bank of America 1,942,439.66 1,132,701.29 (975,653.29) 4,316.18 2,103,803.84 Worker's Comp Account - Bank of America 354,714.11 240,794.25 (95,508.36) 500,000.00 Fiscal Agent Accounts 22,348,296.64 22,348,296.64
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 545,368,037.48 $ 1,373,495.54 $ (1,071,161.65) $ 4,316.18 $ 545,674,687.55 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
September 30, 2024
Docusign Envelope ID: 0D317CC0-4990-4B2C-BB7E-80CD07EFCBAD General Fund $ 208,040,746.58
Special Revenue Funds
Gas Tax 12,954,912.31
Measure A 14,329,719.61
Trip Reduction 2,002,228.96
Asset Forfeiture 385,404.08
Development 33,203,381.61
Residential Refuse/Recycling (266,830.01)
Landscape and Streetlight Maintenance 26,641,188.75
Other Grants and Endowments 116,090,201.24 26,840,195.93 Debt Service Funds
Public Financing Authority 965.01 965.01
Capital Project Funds
Housing/Community Development (262,971.36)
Planned Local Drainage 905,331.80
Other Grants (5,574,925.96)
Public Facility Project (3,875,769.61)
Corona Housing Authority 20,907,994.60 29,716,329.73
Enterprise Funds
Water Utility 39,387,196.71
Water Reclamation Utility 65,894,352.66
Transit 1,230,057.69
Electric Utility 25,640,215.24
Airport 2,015,813.26 134,167,635.56
Internal Service Funds
Fleet Operations 3,048,120.69
Workers' Compensation 22,437,244.10
Liability Risk (638,522.91)
Warehouse Services 1,253,823.45
Information Technology 38,504,285.25 12,403,619.92
Fiduciary Funds
AD & CFD Bond Funds 21,559,601.08
AB109 PACT -
Successor Agency 27,962,859.31 6,403,258.23
Total All Funds $ 545,674,687.55
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
September 30, 2024
Docusign Envelope ID: 0D317CC0-4990-4B2C-BB7E-80CD07EFCBAD
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 44,755,000.00 38,629,498.49 38,076,882.42 7.31%
Agency 51,995,000.00 50,886,310.42 51,934,887.50 9.97%
CMO 54,755,000.00 53,311,454.13 51,956,460.46 9.98%
Pension Trust 804,336.16 50,023,515.51 39,946,948.16 7.67% Receivable (3,659,917.86) (3,659,917.86) (3,659,917.86) -0.70% Corporate 114,203,000.00 114,310,410.50 113,038,932.46 21.71% LAIF 20,531,358.66 20,531,358.66 20,531,358.66 3.94%
Money Market Fund FI 26,077,658.99 26,077,658.99 26,077,658.99 5.01% Municipal Bonds 3,385,000.00 3,385,000.00 3,462,753.45 0.67% Supranational 12,690,000.00 12,170,656.13 12,633,094.65 2.43% US Treasury 167,495,000.00 167,963,793.14 166,713,280.18 32.02% TOTAL PORTFOLIO $ 493,031,435.95 533,629,738.11 $ 100.00% 520,712,339.07 Subject to final audit
CITY OF CORONA
Investment Portfolio Report
September 30, 2024
Docusign Envelope ID: 0D317CC0-4990-4B2C-BB7E-80CD07EFCBAD