M E M O R A N D U M
May 21, 2025
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, March 2025
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 March 2025, 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: B0909C80-26DA-4667-A515-BC23D18EAE4D
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 6,632,949.32 $ 49,031,916.98 $ 51,803,136.17 $ 3,861,730.13 Deposits in Transit 1,002,457.18 1,593,861.31 1,002,457.18 1,593,861.31 Outstanding Checks (2,163,706.03) 2,163,706.03 1,029,290.37 (1,029,290.37) Fiscal Agents 56,671,200.85 3,095,962.72 6,159,104.95 53,608,058.62 Developer Escrow Accounts 1,845,026.00 386,060.08 2,231,086.08 Investments
Chandler Investment- City Account 430,706,018.48 20,310,508.08 19,067,552.82 431,948,973.74 Chandler Investment -Pension Trust Fund 40,641,783.06 2,922,062.53 43,563,845.59 LAIF 33,353,884.12 16,800,000.00 25,200,000.00 24,953,884.12 Investments Subtotal 504,701,685.66 40,032,570.61 44,267,552.82 500,466,703.45 Change Fund 10,248.00 10,248.00
Returned Checks 802.15 38,541.52 37,426.25 1,917.42
Credit Card Reconciling Items- Fees (2,199.42) 2,199.42 2,440.60 (2,440.60) TOTAL $ 568,698,463.71 $ 96,344,818.67 $ 104,301,408.34 $ 560,741,874.04 * For informational purpose only
CITY OF CORONA
Receipts and Disbursements*
March 31, 2025
Docusign Envelope ID: B0909C80-26DA-4667-A515-BC23D18EAE4D
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 24,953,884.12 $ 24,953,884.12
Chandler Investment- City Account $ 431,948,973.74 $ 431,948,973.74 Chandler Investment -Pension Trust Fund $ 43,563,845.59 $ 43,563,845.59 Investment Total 500,466,703.45 500,466,703.45
General Account - Bank of America 3,455,738.47 1,413,048.04 (942,485.44) (523.18) 3,925,777.89 Worker's Comp Account - Bank of America 405,991.66 180,813.27 (86,804.93) 500,000.00 Fiscal Agent Accounts 53,608,058.62 53,608,058.62
Escrow Account 1,845,026.00 386,060.08 2,231,086.08
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 559,791,766.20 $ 1,979,921.39 $ (1,029,290.37) $ (523.18) $ 560,741,874.04 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
March 31, 2025
Docusign Envelope ID: B0909C80-26DA-4667-A515-BC23D18EAE4D General Fund $ 217,619,131.92
Special Revenue Funds
Gas Tax 13,757,115.53
Measure A 17,099,711.16
Trip Reduction 2,144,843.26
Asset Forfeiture 378,539.80
Development 33,884,814.39
Residential Refuse/Recycling (979,370.31)
Landscape and Streetlight Maintenance 27,203,690.96
Other Grants and Endowments 112,012,792.09 18,523,447.30 Debt Service Funds
Public Financing Authority 5,355.54 5,355.54
Capital Project Funds
Housing/Community Development (2,035,042.73)
Planned Local Drainage 565,281.91
Other Grants (16,948,931.75)
Public Facility Project (4,075,089.61)
Corona Housing Authority 2,515,374.33 25,009,156.51
Enterprise Funds
Water Utility 42,866,263.05
Water Reclamation Utility 60,573,970.93
Transit 136,668.07
Electric Utility 29,505,363.14
Airport 2,028,442.46 135,110,707.65
Internal Service Funds
Fleet Operations 1,720,443.08
Workers' Compensation 22,052,817.86
Liability Risk 542,415.32
Warehouse Services 1,379,983.24
Information Technology 38,054,840.13 12,359,180.63
Fiduciary Funds
AD & CFD Bond Funds 47,395,723.75
AB109 PACT -
Successor Agency 55,423,672.38 8,027,948.63
Total All Funds $ 560,741,874.04
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
March 31, 2025
Docusign Envelope ID: B0909C80-26DA-4667-A515-BC23D18EAE4D
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 53,150,000.00 44,728,986.76 44,392,190.30 8.87%
Agency 37,880,000.00 37,397,628.66 37,771,426.75 7.55%
CMO 54,755,000.00 52,993,808.60 51,956,460.46 10.38%
Pension Trust 593,501.19 51,184,241.19 43,563,845.60 8.70% Receivable 375,227.65 375,227.65 375,227.65 0.07%
Corporate 121,803,000.00 121,161,237.65 120,605,127.10 24.10% LAIF 24,953,884.12 24,953,884.12 24,953,884.12 4.99%
Money Market Fund FI 1,274,015.03 1,274,015.03 1,274,015.03 0.25% Municipal Bonds 4,395,000.00 4,437,231.56 4,418,161.65 0.88% Supranational 21,690,000.00 21,321,686.73 21,544,534.65 4.30% US Treasury 150,450,000.00 150,069,822.53 149,611,830.13 29.89% TOTAL PORTFOLIO $ 471,319,627.99 509,897,770.47 $ 100.00% 500,466,703.45 Subject to final audit
CITY OF CORONA
Investment Portfolio Report
March 31, 2025
Docusign Envelope ID: B0909C80-26DA-4667-A515-BC23D18EAE4D