M E M O R A N D U M
July 3, 2024
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, April 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 April 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: 1E73A628-F33F-40BC-BF6C-38C587BAB684
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 5,693,452.31 $ 63,438,720.77 $ 66,813,414.31 $ 2,318,758.77 Deposits in Transit 2,015,789.59 2,911,891.44 2,911,891.44 Outstanding Checks (3,783,461.08) 3,783,461.08 (1,026,913.20) Fiscal Agents 33,417,579.60 20,640,763.34
2,015,789.59
1,026,913.20
54,058,342.94
Investments
Chandler Investment- City Account 475,511,898.91 44,361,457.83 43,301,513.65 476,571,843.09 Chandler Investment -Pension Trust Fund 39,461,568.53 22,872.87 39,484,441.40 LAIF 39,293,518.58 16,128,616.03 31,700,000.00 23,722,134.61 Investments Subtotal 554,266,986.02 60,512,946.73 75,001,513.65 539,778,419.10 Change Fund 10,248.00 10,248.00
Returned Checks 213.84 32,054.49 29,173.90 3,094.43
Credit Card Reconciling Items- Fees (2,412.19) 2,412.19 2,338.11 (2,338.11) TOTAL $ 591,618,396.09 $ 151,322,250.04 $ 144,889,142.76 $ 598,051,503.37 * For informational purpose only
April 30, 2024
CITY OF CORONA
Receipts and Disbursements*
DocuSign Envelope ID: 1E73A628-F33F-40BC-BF6C-38C587BAB684
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 23,722,134.61 $ 23,722,134.61
Chandler Investment- City Account $ 476,571,843.09 $ 476,571,843.09 Chandler Investment -Pension Trust Fund $ 39,484,441.40 $ 39,484,441.40 Investment Total 539,778,419.10 539,778,419.10
General Account - Bank of America 1,993,915.35 2,598,233.60 (888,411.94) 756.32 3,704,493.33 Worker's Comp Account - Bank of America 324,843.42 313,657.84 (138,501.26) 500,000.00 Fiscal Agent Accounts 54,058,342.94 54,058,342.94
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 596,165,768.81 $ 2,911,891.44 $ (1,026,913.20) $ 756.32 $ 598,051,503.37 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
April 30, 2024
DocuSign Envelope ID: 1E73A628-F33F-40BC-BF6C-38C587BAB684 General Fund $ 216,853,107.83
Special Revenue Funds
Gas Tax 12,217,001.94
Measure A 22,404,112.55
Trip Reduction 1,888,051.84
Asset Forfeiture 339,431.95
Development 34,596,556.03
Residential Refuse/Recycling (220,163.67)
Landscape and Streetlight Maintenance 24,715,956.92
Other Grants and Endowments 29,894,456.93 125,835,404.49 Debt Service Funds
Public Financing Authority 305,257.02 305,257.02
Capital Project Funds
Housing/Community Development 436,316.82
Planned Local Drainage 108,521.42
Other Grants 8,364,548.05
Public Facility Project (3,875,769.61)
Corona Housing Authority 28,652,586.60 33,686,203.28
Enterprise Funds
Water Utility 48,743,888.72
Water Reclamation Utility 72,179,427.55
Transit 1,390,938.37
Electric Utility 23,199,290.46
Airport 1,893,436.20 147,406,981.30
Internal Service Funds
Fleet Operations 3,995,424.38
Workers' Compensation 23,533,722.46
Liability Risk (64,612.51)
Warehouse Services 1,088,325.50
Information Technology 10,723,895.99 39,276,755.82
Fiduciary Funds
AD & CFD Bond Funds 27,621,401.74
AB109 PACT -
Successor Agency 7,066,391.89 34,687,793.63
Total All Funds 598,051,503.37 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
April 30, 2024
DocuSign Envelope ID: 1E73A628-F33F-40BC-BF6C-38C587BAB684
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 42,700,000.00 29,248,724.85 29,575,809.64 5.48%
Agency 71,245,000.00 68,420,333.67 71,691,626.40 13.28% CMO 49,805,000.00 46,231,186.12 47,319,315.93 8.77%
Pension Trust 946,346.50 44,339,123.00 39,484,441.40 7.31% Receivable 174,009.72 174,009.72 174,009.72 0.03%
Corporate 109,186,000.00 104,606,853.63 108,159,897.65 20.04% LAIF 23,722,134.61 23,722,134.61 23,722,134.61 4.39%
Money Market Fund FI 13,756,536.42 13,756,536.42 13,756,536.42 2.55% Municipal Bonds 3,385,000.00 3,341,062.70 3,462,753.45 0.64% Supranational 12,690,000.00 11,760,811.49 12,633,094.65 2.34% US Treasury 192,095,000.00 186,530,222.82 189,798,799.23 35.16% TOTAL PORTFOLIO $ 519,705,027.25 532,130,999.03 $ 100.00% 539,778,419.10 Subject to final audit
CITY OF CORONA
Investment Portfolio Report
April 30, 2024
DocuSign Envelope ID: 1E73A628-F33F-40BC-BF6C-38C587BAB684