M E M O R A N D U M
June 21, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, April 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 April 2023, 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: 54CCF0A5-D398-43B3-8B56-D2E5A12D6B22
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 3,298,178.52 $ 62,005,630.63 $ 59,636,090.52 $ 5,667,718.63 $ Deposits in Transit 157,561.00 634,695.08 157,561.00 634,695.08 Outstanding Checks (1,271,858.18) 1,271,858.18 3,255,428.84 (3,255,428.84) Fiscal Agents 32,368,934.12 18,948,159.07 0.00 51,317,093.19 Investments
Chandler Investment- City Account 345,819,751.58 6,716,197.49 6,297,525.28 346,238,423.79 Chandler Investment -Pension Trust Fund 32,553,232.17 15,618.97 32,568,851.14 LAIF 137,892,723.78 15,216,736.65 23,900,000.00 129,209,460.43 Investments Subtotal 516,265,707.53 21,948,553.11 30,197,525.28 508,016,735.36 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 3,827.22 22,590.17 13,354.44 13,062.95
Credit Card Reconciling Items- Fees (3,816.19) 3,816.19 3,530.74 (3,530.74) TOTAL $ 104,835,302.43 550,828,782.02 $ 93,263,490.82 $ 562,400,593.63 $ * For informational purpose only
Subject to final audit
April 30, 2023
CITY OF CORONA
Receipts and Disbursements*
DocuSign Envelope ID: 54CCF0A5-D398-43B3-8B56-D2E5A12D6B22
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 129,209,460.43 $ 129,209,460.43 $
Chandler Investment- City Account 346,238,423.79 $ 346,238,423.79 $ Chandler Investment -Pension Trust Fund 32,568,851.14 $ 32,568,851.14 $ Investment Total 508,016,735.36 508,016,735.36
General Account - Bank of America 5,200,269.48 505,267.55 (3,158,552.16) 9,532.21 2,556,517.08 Worker's Comp Account - Bank of America 467,449.15 129,427.53 (96,876.68) 500,000.00 Fiscal Agent Accounts 51,317,093.19 51,317,093.19
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 565,011,795.18 $ 634,695.08 $ (3,255,428.84) $ 9,532.21 $ 562,400,593.63 $ Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
April 30, 2023
DocuSign Envelope ID: 54CCF0A5-D398-43B3-8B56-D2E5A12D6B22 General Fund $ 172,918,662.16
Special Revenue Funds
Gas Tax 8,610,717.49
Measure A 16,906,369.52
Trip Reduction 1,674,900.32
Asset Forfeiture 359,773.96
Development 29,464,157.19
Residential Refuse/Recycling (247,153.19)
Landscape and Streetlight Maintenance 23,372,411.42
Other Grants and Endowments 29,417,977.93 109,559,154.64 Debt Service Funds
Public Financing Authority 2,545.27 2,545.27
Capital Project Funds
Housing/Community Development 422,198.40
Planned Local Drainage 722,129.20
Other Grants 24,232,084.84
Public Facility Project (3,875,769.60)
Corona Housing Authority 28,146,140.04 49,646,782.88
Enterprise Funds
Water Utility 49,919,150.73
Water Reclamation Utility 77,940,926.21
Transit 1,116,161.92
Electric Utility 24,106,336.93
Airport 1,505,070.13 154,587,645.92
Internal Service Funds
Fleet Operations 7,976,034.48
Workers' Compensation 24,442,956.92
Liability Risk (1,251,188.62)
Warehouse Services 801,572.97
Information Technology 10,090,859.89 42,060,235.64
Fiduciary Funds
AD & CFD Bond Funds 27,095,802.34
AB109 PACT 25,286.58
Successor Agency 6,504,478.20 33,625,567.12
Total All Funds 562,400,593.63 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
April 30, 2023
DocuSign Envelope ID: 54CCF0A5-D398-43B3-8B56-D2E5A12D6B22
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 31,891,579.24 31,071,464.55 31,888,068.66 6.28%
Agency 64,745,000.00 60,848,663.07 65,211,511.40 12.84% CMO 23,685,540.22 23,081,479.31 23,567,699.92 4.64%
Pension Trust 568,433.77 33,990,178.37 32,568,851.14 6.41% Corporate 92,531,000.00 87,669,710.37 92,044,922.29 18.12% LAIF 129,209,460.36 129,209,460.36 129,209,460.43 25.43% Money Market Fund FI 3,558,345.26 3,558,345.26 3,558,345.26 0.70% Municipal Bonds 3,385,000.00 3,272,580.77 3,462,753.45 0.68% Supranational 12,690,000.00 11,655,241.48 12,633,094.65 2.49% US Treasury 114,120,000.00 110,490,788.84 113,872,028.16 22.42% TOTAL PORTFOLIO $ 494,847,912.38 476,384,358.85 $ 508,016,735.36 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
April 30, 2023
DocuSign Envelope ID: 54CCF0A5-D398-43B3-8B56-D2E5A12D6B22