M E M O R A N D U M
May 15, 2024
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, March 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 March 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: F02B91FC-64B3-41F5-B529-5B17FA01247C
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 8,169,236.79 $ 41,796,614.35 $ 44,272,398.83 $ 5,693,452.31 Deposits in Transit 1,896,202.84 2,350,203.68 1,896,202.84 2,350,203.68 Outstanding Checks (3,709,871.62) 3,709,871.62 3,783,461.08 (3,783,461.08) Fiscal Agents 36,058,316.66 3,002,092.53 5,642,829.59 33,417,579.60 Investments
Chandler Investment- City Account 474,116,545.41 47,053,799.05 45,658,445.55 475,511,898.91 Chandler Investment -Pension Trust Fund 39,297,068.06 164,500.47 39,461,568.53 LAIF 40,593,518.58 14,700,000.00 16,000,000.00 39,293,518.58 Investments Subtotal 554,007,132.05 61,918,299.52 61,658,445.55 554,266,986.02 Change Fund 10,248.00 10,248.00
Returned Checks 8,228.12 30,518.73 38,533.01 213.84
Credit Card Reconciling Items- Fees (2,245.68) 2,245.68 2,412.19 (2,412.19) TOTAL $ 596,437,247.16 $ 112,809,846.11 $ 117,294,283.09 $ 591,952,810.18 * For informational purpose only
CITY OF CORONA
Receipts and Disbursements*
March 31, 2024
DocuSign Envelope ID: F02B91FC-64B3-41F5-B529-5B17FA01247C
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 39,293,518.58 $ $ 39,293,518.58
Chandler Investment- City Account 475,511,898.91 $ $ 475,511,898.91 Chandler Investment -Pension Trust Fund 39,461,568.53 $ $ 39,461,568.53 Investment Total 554,266,986.02 554,266,986.02
General Account - Bank of America 5,369,902.49 2,092,179.68 (3,701,887.26) (2,198.35) 3,757,996.56 Worker's Comp Account - Bank of America 323,549.82 258,024.00 (81,573.82) 500,000.00 Fiscal Agent Accounts 33,417,579.60 33,417,579.60
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 593,388,265.93 $ 2,350,203.68 $ (3,783,461.08) $ (2,198.35) $ 591,952,810.18 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
March 31, 2024
DocuSign Envelope ID: F02B91FC-64B3-41F5-B529-5B17FA01247C General Fund $ 214,296,059.81
Special Revenue Funds
Gas Tax 11,689,382.69
Measure A 21,913,682.49
Trip Reduction 1,885,023.20
Asset Forfeiture 337,796.55
Development 32,608,243.38
Residential Refuse/Recycling 735,129.53
Landscape and Streetlight Maintenance 25,070,007.32
Other Grants and Endowments 123,929,344.24 29,690,079.08 Debt Service Funds
Public Financing Authority 5,039.43 5,039.43
Capital Project Funds
Housing/Community Development 427,971.10
Planned Local Drainage 200,445.28
Other Grants 8,801,198.76
Public Facility Project (3,875,769.61)
Corona Housing Authority 34,163,080.11 28,609,234.58
Enterprise Funds
Water Utility 47,656,064.53
Water Reclamation Utility 70,814,812.31
Transit 612,553.85
Electric Utility 22,974,936.39
Airport 1,855,372.05 143,913,739.13
Internal Service Funds
Fleet Operations 4,490,943.85
Workers' Compensation 23,498,594.90
Liability Risk (46,574.38)
Warehouse Services 1,102,244.08
Information Technology 40,667,406.28 11,622,197.83
Fiduciary Funds
AD & CFD Bond Funds 27,491,547.05
AB109 PACT -
Successor Agency 34,978,141.18 7,486,594.13
Total All Funds $ 591,952,810.18
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
March 31, 2024
DocuSign Envelope ID: F02B91FC-64B3-41F5-B529-5B17FA01247C
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 40,835,000.00 27,747,569.46 27,940,627.11 5.04%
Agency 71,245,000.00 68,477,721.49 71,691,626.40 12.93% CMO 43,805,000.00 41,528,139.04 41,878,417.49 7.56%
Pension Trust 946,473.63 46,471,028.23 39,461,568.53 7.12% Receivable (1,806,233.42) (1,806,233.42) (1,806,233.42) -0.33% Corporate 109,186,000.00 105,692,982.92 108,159,897.65 19.51% LAIF 39,293,518.58 39,293,518.58 39,293,518.58 7.09%
Money Market Fund FI 3,221,531.98 3,221,531.98 3,221,531.98 0.58% Municipal Bonds 3,385,000.00 3,335,240.50 3,462,753.45 0.62% Supranational 12,690,000.00 11,808,730.55 12,633,094.65 2.28% US Treasury 211,095,000.00 206,951,769.77 208,330,183.60 37.59% TOTAL PORTFOLIO $ 533,896,290.78 552,721,999.10 $ 554,266,986.02 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
March 31, 2024
DocuSign Envelope ID: F02B91FC-64B3-41F5-B529-5B17FA01247C