M E M O R A N D U M
August 21, 2024
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, May 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 May 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: 499C670F-6AB3-4BF6-B0DD-A35B2188D08C
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 2,318,758.77 $ 72,884,311.53 $ 71,522,068.06 $ 3,681,002.24 Deposits in Transit 2,846,561.06 2,105,882.15 2,846,561.06 2,105,882.15 Outstanding Checks (1,026,913.20) 1,026,913.20 1,008,895.57 (1,008,895.57) Fiscal Agents 54,058,342.94 21,195,981.39 47,404,160.71 27,850,163.62 Investments
Chandler Investment- City Account 470,771,843.09 94,411,456.35 89,996,843.22 475,186,456.22 Chandler Investment -Pension Trust Fund 39,484,441.40 22,979.09 39,507,420.49 LAIF 29,522,134.61 29,522,134.61
Investments Subtotal 539,778,419.10 94,434,435.44 89,996,843.22 544,216,011.32 Change Fund 10,248.00 10,248.00
Returned Checks 3,094.43 13,778.41 12,315.38 4,557.46
Credit Card Reconciling Items- Fees (2,338.11) 2,338.11 2,690.00 (2,690.00) TOTAL $ 597,986,172.99 $ 191,663,640.23 $ 212,793,534.00 $ 576,856,279.22 * For informational purpose only
May 31, 2024
CITY OF CORONA
Receipts and Disbursements*
Docusign Envelope ID: 499C670F-6AB3-4BF6-B0DD-A35B2188D08C
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 29,522,134.61 $ 29,522,134.61
Chandler Investment- City Account $ 475,186,456.22 $ 475,186,456.22 Chandler Investment -Pension Trust Fund $ 39,507,420.49 $ 39,507,420.49 Investment Total 544,216,011.32 544,216,011.32
General Account - Bank of America 3,371,356.01 1,757,083.82 (850,451.01) 1,867.46 4,279,856.28 Worker's Comp Account - Bank of America 309,646.23 348,798.33 (158,444.56) 500,000.00 Fiscal Agent Accounts 27,850,163.62 27,850,163.62
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 575,757,425.18 $ 2,105,882.15 $ (1,008,895.57) $ 1,867.46 $ 576,856,279.22 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
May 31, 2024
Docusign Envelope ID: 499C670F-6AB3-4BF6-B0DD-A35B2188D08C General Fund $ 209,127,438.87
Special Revenue Funds
Gas Tax 12,580,666.36
Measure A 16,696,945.01
Trip Reduction 1,898,751.37
Asset Forfeiture 338,399.96
Development 34,864,545.38
Residential Refuse/Recycling 182,894.78
Landscape and Streetlight Maintenance 28,545,269.93
Other Grants and Endowments 29,855,827.59 124,963,300.38 Debt Service Funds
Public Financing Authority 948.31 948.31
Capital Project Funds
Housing/Community Development 423,230.84
Planned Local Drainage (48,795.75)
Other Grants 4,514,294.23
Public Facility Project (3,875,769.61)
Corona Housing Authority 28,809,882.45 29,822,842.16
Enterprise Funds
Water Utility 46,687,276.71
Water Reclamation Utility 69,876,196.38
Transit 1,446,714.95
Electric Utility 23,833,127.81
Airport 1,937,355.73 143,780,671.58
Internal Service Funds
Fleet Operations 3,160,970.97
Workers' Compensation 23,420,099.35
Liability Risk (105,650.14)
Warehouse Services 1,045,153.92
Information Technology 9,146,368.63 36,666,942.73
Fiduciary Funds
AD & CFD Bond Funds 25,631,581.68
AB109 PACT -
Successor Agency 6,862,553.51 32,494,135.19
Total All Funds $ 576,856,279.22
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
May 31, 2024
Docusign Envelope ID: 499C670F-6AB3-4BF6-B0DD-A35B2188D08C
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 46,205,000.00 33,899,890.06 34,125,132.47 6.27%
Agency 71,245,000.00 68,720,434.75 71,691,626.40 13.17% CMO 54,755,000.00 51,269,214.20 51,956,460.46 9.55%
Pension Trust 513,428.29 46,134,571.59 39,507,420.49 7.26% Receivable (3,902,993.91) (3,902,993.91) (3,902,993.91) -0.72% Corporate 107,333,000.00 103,418,035.19 106,022,923.77 19.48% LAIF 29,522,134.61 29,522,134.61 29,522,134.61 5.42%
Money Market Fund FI 27,611,143.68 27,611,143.68 27,611,143.68 5.07% Municipal Bonds 3,385,000.00 3,350,879.20 3,462,753.45 0.64% Supranational 12,690,000.00 11,831,629.27 12,633,094.65 2.32% US Treasury 173,095,000.00 168,739,046.11 171,586,315.25 31.53% TOTAL PORTFOLIO $ 522,451,712.67 540,593,984.75 $ 544,216,011.32 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
May 31, 2024
Docusign Envelope ID: 499C670F-6AB3-4BF6-B0DD-A35B2188D08C