M E M O R A N D U M
October 19, 2022
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, August 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 August 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: 5603FC3D-E12F-4B4B-AC3B-1A7D64BBC793
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 7,144,831.71 $ 60,512,046.24 $ 62,242,981.56 $ 5,413,896.39 Deposits in Transit, as restated 500,819.99 984,089.12 500,819.99 984,089.12 Outstanding Checks (4,517,766.33) 4,517,766.33 1,176,045.78 (1,176,045.78) Fiscal Agents 33,820,175.62 3,364,856.56 0.00 37,185,032.18 Investments
Chandler Investment- City Account 312,973,333.85 12,121,697.94 11,836,698.02 313,258,333.77 Chandler Investment -Pension Trust Fund 30,001,817.92 6,495.94 30,008,313.86 LAIF 90,795,864.70 29,800,000.00 18,900,000.00 101,695,864.70 433,771,016.47 41,928,193.88 30,736,698.02 444,962,512.33 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 3,942.43 21,203.49 25,145.92 -
Credit Card Reconciling Items- Fees (2,342.02) 2,342.02 2,821.46 (2,821.46) TOTAL $ 470,730,925.87 $ 111,330,497.64 $ 94,684,512.73 $ 487,376,910.78 * For informational purpose only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements*
August 31, 2022
DocuSign Envelope ID: 5603FC3D-E12F-4B4B-AC3B-1A7D64BBC793
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 101,695,864.70 $ - $ - $ - $ 101,695,864.70
Chandler Investment- City Account $ 313,258,333.77 $ 313,258,333.77 Chandler Investment -Pension Trust Fund $ 30,008,313.86 $ 30,008,313.86 Investment Total 444,962,512.33 444,962,512.33
5,106,763.17 720,078.45 (1,104,901.89) (2,821.46) 4,719,118.27 307,133.22 264,010.67 (71,143.89) 500,000.00
37,185,032.18 37,185,032.18
10,248.00 10,248.00
General Account - Bank of America
Worker's Comp Account - Bank of America
Fiscal Agent Accounts
Cashier Change
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 487,571,688.90 $ 984,089.12 $ (1,176,045.78) $ (2,821.46) $ 487,376,910.78 Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
August 31, 2022
DocuSign Envelope ID: 5603FC3D-E12F-4B4B-AC3B-1A7D64BBC793 General Fund $ 140,282,937.09
Special Revenue Funds
Gas Tax 6,613,810.81
Measure A 18,727,294.12
Trip Reduction 1,516,431.95
Asset Forfeiture 457,754.76
Development 28,225,154.50
Residential Refuse/Recycling 187,190.97
Landscape and Streetlight Maintenance 24,141,155.39
Other Grants and Endowments 30,434,316.70 110,303,109.20 Debt Service Funds
Public Financing Authority 42.33 42.33
Capital Project Funds
Housing/Community Development 142,733.91
Planned Local Drainage 546,765.47
Other Grants (6,565,359.27)
Public Facility Project (4,273,280.03)
Corona Housing Authority 17,427,102.72 27,576,242.64
Enterprise Funds
Water Utility 32,697,107.11
Water Reclamation Utility 79,080,117.13
Transit 1,275,105.45
Electric Utility 26,365,992.74
Airport 1,325,638.09 140,743,960.52
Internal Service Funds
Fleet Operations 6,106,362.96
Workers' Compensation 24,660,029.54
Liability Risk (248,667.68)
Warehouse Services 598,332.24
Information Technology 37,423,470.28 6,307,413.22
Fiduciary Funds
AD & CFD Bond Funds 29,861,575.18
AB109 PACT 25,165.11
Successor Agency 41,196,288.64 11,309,548.35
Total All Funds $ 487,376,910.78
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
August 31, 2022
DocuSign Envelope ID: 5603FC3D-E12F-4B4B-AC3B-1A7D64BBC793
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 40,128,438.39 39,095,374.78 40,125,416.91 9.02%
Agency 69,745,000.00 65,643,346.71 70,257,201.40 15.79% CMO 18,326,143.32 18,108,757.46 18,840,013.81 4.23%
Pension Trust 15,534,548.15 30,008,313.86 30,008,313.86 6.74% Corporate 84,131,000.00 79,215,243.22 83,832,694.69 18.84% LAIF 101,695,864.70 101,695,864.70 101,695,864.70 22.85% Money Market Fund FI 308,556.42 308,556.42 308,556.49 0.07% Municipal Bonds 3,385,000.00 3,301,999.80 3,462,753.45 0.78% Negotiable CD 500,000.00 494,917.00 500,000.00 0.11%
Supranational 12,690,000.00 11,534,476.50 12,633,094.65 2.84% US Treasury 83,320,000.00 79,308,876.78 83,298,602.37 18.72% TOTAL PORTFOLIO $ 429,764,550.98 $ 428,715,727.23 $ 444,962,512.33 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
August 31, 2022
DocuSign Envelope ID: 5603FC3D-E12F-4B4B-AC3B-1A7D64BBC793