M E M O R A N D U M
April 19, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, February 2023
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 February 2023, subject to final audit.
Prepared By: Reviewed By:
_______________________________ _______________________________ Financial Analyst Accounting Manager
Respectfully submitted:
_______________________________ _______________________________ Finance Director City Manager
_______________________________
City Treasurer
Attachment
DocuSign Envelope ID: D6279BCA-AC5C-44D2-8F98-5BD4EC772EA3
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 5,822,855.76 $ 90,461,603.38 $ 91,386,717.84 $ 4,897,741.30 Deposits in Transit 834,805.91 1,012,168.26 834,805.91 1,012,168.26 Outstanding Checks (3,859,469.66) 3,859,469.66 3,267,295.09 (3,267,295.09) Fiscal Agents 24,277,880.26 11,686,988.31 755,087.03 35,209,781.54 Investments
Chandler Investment- City Account 315,123,684.62 22,227,976.02 21,861,129.37 315,490,531.27 Chandler Investment -Pension Trust Fund 30,297,348.21 2,124,634.78 32,421,982.99 LAIF 146,062,723.71 52,430,000.00 24,700,000.00 173,792,723.71 Investments Subtotal 491,483,756.54 76,782,610.80 46,561,129.37 521,705,237.97 Change Fund 10,248.00 10,248.00
Returned Checks 19,798.03 27,955.21 29,752.30 18,000.94 Credit Card Reconciling Items- Fees (2,787.55) 2,787.55 3,645.36 (3,645.36) TOTAL $ 518,587,087.29 $ 183,833,583.17 $ 142,838,432.90 $ 559,582,237.56 * For informational purpose only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements*
February 28, 2023
DocuSign Envelope ID: D6279BCA-AC5C-44D2-8F98-5BD4EC772EA3
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 173,792,723.71 $ $ 173,792,723.71
Chandler Investment- City Account 315,490,531.27 $ $ 315,490,531.27 Chandler Investment -Pension Trust Fund 32,421,982.99 $ $ 32,421,982.99 Investment Total 521,705,237.97 521,705,237.97
General Account - Bank of America 4,406,842.89 927,667.73 (3,191,896.15) 14,355.58 2,156,970.05 Worker's Comp Account - Bank of America 490,898.41 84,500.53 (75,398.94) 500,000.00 Fiscal Agent Accounts 35,209,781.54 35,209,781.54
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 561,823,008.81 $ 1,012,168.26 $ (3,267,295.09) $ 14,355.58 $ 559,582,237.56 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
February 28, 2023
DocuSign Envelope ID: D6279BCA-AC5C-44D2-8F98-5BD4EC772EA3 General Fund $ 167,507,205.67
Special Revenue Funds
Gas Tax 8,775,653.18
Measure A 19,993,836.61
Trip Reduction 1,669,627.97
Asset Forfeiture 340,028.21
Development 28,802,481.19
Residential Refuse/Recycling (109,042.24)
Landscape and Streetlight Maintenance 26,398,002.68
Other Grants and Endowments 29,241,977.41 115,112,565.01 Debt Service Funds
Public Financing Authority 2,527.06 2,527.06
Capital Project Funds
Housing/Community Development 313,167.20
Planned Local Drainage 353,876.90
Other Grants 20,125,144.35
Public Facility Project (3,498,269.60)
Corona Housing Authority 28,043,130.41 45,337,049.26
Enterprise Funds
Water Utility 49,549,737.86
Water Reclamation Utility 78,139,995.43
Transit 686,301.88
Electric Utility 24,891,429.89
Airport 1,498,545.26 154,766,010.32
Internal Service Funds
Fleet Operations 8,609,146.93
Workers' Compensation 24,413,852.65
Liability Risk (1,216,813.14)
Warehouse Services 725,933.50
Information Technology 7,853,063.32 40,385,183.26
Fiduciary Funds
AD & CFD Bond Funds 28,818,323.89
AB109 PACT 25,286.58
Successor Agency 7,628,086.51 36,471,696.98
Total All Funds $ 559,582,237.56
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
February 28, 2023
DocuSign Envelope ID: D6279BCA-AC5C-44D2-8F98-5BD4EC772EA3
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 32,661,936.67 31,618,314.56 32,658,692.95 6.26%
Agency 64,745,000.00 59,790,746.33 65,211,511.40 12.50% CMO 16,983,021.20 16,447,126.71 17,246,251.60 3.31%
Pension Trust 2,756,391.01 33,673,291.71 32,421,982.99 6.21% Corporate 90,581,000.00 84,294,709.03 90,198,470.19 17.29% LAIF 143,792,723.71 143,792,723.71 143,792,723.71 27.56% 14,702,103.80 14,702,103.80 14,702,103.80 2.82%
3,385,000.00 3,257,013.15 3,462,753.45 0.66%
12,690,000.00 11,359,267.29 12,633,094.65 2.42%
Money Market Fund FI
Municipal Bonds
Supranational
US Treasury 109,620,000.00 103,731,242.15 109,377,653.23 20.97% TOTAL PORTFOLIO $ 491,917,176.39 $ 502,666,538.44 $ 521,705,237.97 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
February 28, 2023
DocuSign Envelope ID: D6279BCA-AC5C-44D2-8F98-5BD4EC772EA3