M E M O R A N D U M
August 6, 2025
TO:
FROM:
SUBJECT:
City Clerk
Julie Kennicutt
Deputy Finance Director
Monthly Fiscal Report, May 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 May 2025, subject to final audit.
Prepared By: Reviewed By:
_______________________________ _______________________________ Financial Analyst Accounting Manager
Respectfully submitted:
_______________________________ _______________________________ Deputy Finance Director Assistant City Manager
_______________________________
City Treasurer
Attachment
Docusign Envelope ID: 5EDF64A9-0746-4A9A-9F57-6918EAF20874
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 5,348,884.18 $ 64,787,271.91 $ 65,447,007.36 $ 4,689,148.73 Deposits in Transit (494,153.41) (461,242.31) (494,153.41) (461,242.31) Outstanding Checks (891,525.05) 2,430,680.63 (2,430,680.63) Fiscal Agents 73,411,920.11 43,360,663.04 51,905,788.68 Developer Escrow Accounts 2,231,086.08
891,525.05
21,854,531.61
2,231,086.08
Investments
Chandler Investment- City Account 408,783,987.55 30,820,520.03 29,705,246.03 409,899,261.55 Chandler Investment -Pension Trust Fund 42,597,582.38 124,783.48 42,722,365.86 LAIF 19,701,691.86 36,700,000.00 18,400,000.00 38,001,691.86 Investments Subtotal 471,083,261.79 67,645,303.51 48,105,246.03 490,623,319.27 Change Fund 10,248.00 10,248.00
Returned Checks 13,363.24 22,712.83 23,929.68 12,146.39 Credit Card Reconciling Items- Fees (2,427.28) 2,427.28 2,797.79 (2,797.79) TOTAL $ 550,710,657.66 $ 154,742,529.88 $ 158,876,171.12 $ 546,577,016.42 * For informational purpose only
May 31, 2025
CITY OF CORONA
Receipts and Disbursements*
Docusign Envelope ID: 5EDF64A9-0746-4A9A-9F57-6918EAF20874
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 38,001,691.86 $ 38,001,691.86
Chandler Investment- City Account $ 409,899,261.55 $ 409,899,261.55 Chandler Investment -Pension Trust Fund $ 42,722,365.86 $ 42,722,365.86 Investment Total 490,623,319.27 490,623,319.27
General Account - Bank of America 4,241,125.20 (740,362.60) (2,203,536.81) 9,348.60 1,306,574.39 Worker's Comp Account - Bank of America 416,977.29 203,419.31 (120,396.60) 500,000.00 Fiscal Agent Accounts 51,905,788.68 51,905,788.68
Escrow Account 2,231,086.08 2,231,086.08
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 549,428,544.52 $ (536,943.29) $ (2,323,933.41) $ 9,348.60 $ 546,577,016.42 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
May 31, 2025
Docusign Envelope ID: 5EDF64A9-0746-4A9A-9F57-6918EAF20874 General Fund $ 214,624,290.05
Special Revenue Funds
4.09E+08 14,251,955.51
42597582 18,048,265.67
Trip Reduction 2,151,555.41
Asset Forfeiture 373,808.24
Development 34,275,296.42
Residential Refuse/Recycling (840,457.25)
Landscape and Streetlight Maintenance 30,235,704.34
Other Grants and Endowments 13,922,984.39 112,419,112.73 Debt Service Funds
Public Financing Authority 691.39 691.39
Capital Project Funds
Housing/Community Development (957,230.90)
Planned Local Drainage 702,583.42
Other Grants (21,682,071.18)
Public Facility Project (4,340,412.67)
Corona Housing Authority 22,290,613.83 (3,986,517.50)
Enterprise Funds
Water Utility 42,012,373.81
Water Reclamation Utility 59,012,740.00
Transit (55,281.83)
Electric Utility 30,173,349.42
Airport 2,086,240.63 133,229,422.03
Internal Service Funds
Fleet Operations (14,815.96)
Workers' Compensation 22,212,334.92
Liability Risk 497,014.64
Warehouse Services 1,190,239.24
Information Technology 9,652,252.28 33,537,025.12
Fiduciary Funds
AD & CFD Bond Funds 49,340,554.43
AB109 PACT -
Successor Agency 7,412,438.17 56,752,992.60
Total All Funds 546,577,016.42 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
May 31, 2025
Docusign Envelope ID: 5EDF64A9-0746-4A9A-9F57-6918EAF20874
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 50,495,000.00 44,447,848.22 44,143,204.85 9.00%
Agency 33,180,000.00 32,913,907.35 33,076,554.85 6.74%
CMO 47,415,000.00 45,927,870.90 45,002,979.99 9.17%
Pension Trust 620,079.03 52,993,478.73 43,722,365.86 8.91% Receivable 656,726.88 656,726.88 656,726.88 0.13%
Corporate 110,662,000.00 110,372,061.78 109,441,677.34 22.31% LAIF 38,001,691.86 408,783,987.55 38,001,691.86 7.75%
Money Market Fund FI 1,764,850.19 42,597,582.38 1,764,850.19 0.36% Municipal Bonds 4,395,000.00 4,438,862.10 4,418,161.65 0.90% Supranational 21,690,000.00 21,408,272.18 21,544,534.65 4.39% US Treasury 149,620,000.00 149,481,522.24 148,850,571.15 30.34% TOTAL PORTFOLIO $ 458,500,347.96 914,022,120.32 $ 100.00% 490,623,319.27 Subject to final audit
CITY OF CORONA
Investment Portfolio Report
May 31, 2025
Docusign Envelope ID: 5EDF64A9-0746-4A9A-9F57-6918EAF20874