M E M O R A N D U M
January 4, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, October 2022
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 October 2022, 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: C13BF262-8F82-410F-9F32-1E21B114F0A9
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
$ 6,796,609.88 $ 44,836,793.84 $ 46,731,346.44 $ 4,902,057.28 728,007.35 1,168,785.72 728,007.35 1,168,785.72
(4,890,284.55) 4,890,284.55 3,756,687.03 (3,756,687.03) Balance Per Bank - Bank of America
Deposits in Transit
Outstanding Checks
Fiscal Agents 25,204,089.90 4,294,488.10 29,892.93 29,468,685.07 Investments
Chandler Investment- City Account 313,580,583.52 3,828,990.48 3,022,583.20 314,386,990.80 Chandler Investment -Pension Trust Fund 30,081,278.00 11,946.49 30,093,224.49 LAIF 114,295,864.70 15,600,000.00 19,500,000.00 110,395,864.70 Investments Subtotal 457,957,726.22 19,440,936.97 22,522,583.20 454,876,079.99 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 10,273.47 39,282.17 48,937.67 617.97
Credit Card Reconciling Items- Fees (2,630.21) 2,630.21 2,550.71 (2,550.71) TOTAL $ 485,814,040.06 $ 74,673,201.56 $ 73,820,005.33 $ 486,667,236.29 * For informational purpose only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements*
October 31, 2022
DocuSign Envelope ID: C13BF262-8F82-410F-9F32-1E21B114F0A9
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF
Chandler Investment - City Account
Chandler Investment - Pension Trust Fund
$ 110,395,864.70
$ 314,386,990.80
$ 30,093,224.49
$ 110,395,864.70
$ 314,386,990.80
$ 30,093,224.49
Investment Total 454,876,079.99 454,876,079.99
General Account - Bank of America 4,488,627.05 995,404.07 (3,669,875.15) (1,932.74) 1,812,223.23 Worker's Comp Account - Bank of America 413,430.23 173,381.65 (86,811.88) 500,000.00 Fiscal Agent Accounts 29,468,685.07 29,468,685.07
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 489,257,070.34 $ 1,168,785.72 $ (3,756,687.03) $ (1,932.74) $ 486,667,236.29
CITY OF CORONA
Cash and Investment Status Report
October 31, 2022
Subject to final audit
DocuSign Envelope ID: C13BF262-8F82-410F-9F32-1E21B114F0A9 General Fund $ 133,561,882.20
Special Revenue Funds
Gas Tax 7,360,119.19
Measure A 19,973,293.30
Trip Reduction 1,572,087.03
Asset Forfeiture 379,981.45
Development 28,643,675.53
Residential Refuse/Recycling 76,316.33
Landscape and Streetlight Maintenance 22,915,430.63
Other Grants and Endowments 30,471,906.05 111,392,809.51 Debt Service Funds
Public Financing Authority 1,778,025.00 1,778,025.00
Capital Project Funds
Housing/Community Development 220,163.41
Planned Local Drainage 514,125.64
Other Grants (8,772,122.51)
Public Facility Project (4,273,280.03)
Corona Housing Authority 15,285,159.42 27,596,272.91
Enterprise Funds
Water Utility 47,286,755.92
Water Reclamation Utility 78,836,967.38
Transit 947,887.67
Electric Utility 27,406,419.36
Airport 1,370,387.23 155,848,417.56
Internal Service Funds
Fleet Operations 4,998,983.94
Workers' Compensation 24,347,226.73
Liability Risk (1,123,353.34)
Warehouse Services 683,613.75
Information Technology 37,117,755.74 8,211,284.66
Fiduciary Funds
AD & CFD Bond Funds 24,799,533.13
AB109 PACT 25,165.11
Successor Agency 31,683,186.86 6,858,488.62
Total All Funds $ 486,667,236.29
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
October 31, 2022
DocuSign Envelope ID: C13BF262-8F82-410F-9F32-1E21B114F0A9
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 37,596,498.04 36,211,748.19 37,593,426.34 8.26%
Agency 68,745,000.00 63,295,266.34 69,211,791.40 15.22% CMO 18,213,229.31 1,769,254.13 18,726,271.50 4.12%
Pension Trust 7,350,703.12 29,827,774.52 30,093,224.50 6.62% Corporate 84,131,000.00 76,977,068.27 83,832,694.76 18.43% LAIF 110,724,075.47 110,724,075.47 110,724,075.47 24.34% Money Market Fund FI 657,735.39 657,735.39 657,735.39 0.14% Municipal Bonds 3,385,000.00 3,242,694.60 3,462,753.45 0.76% Negotiable CD 500,000.00 495,250.50 500,000.00 0.11%
Supranational 12,690,000.00 11,226,800.71 12,633,094.65 2.78% US Treasury 85,720,000.00 81,589,653.90 87,441,012.53 19.22% TOTAL PORTFOLIO $ 429,713,241.33 $ 416,017,322.02 $ 454,876,079.99 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
October 31, 2022
DocuSign Envelope ID: C13BF262-8F82-410F-9F32-1E21B114F0A9