M E M O R A N D U M
January 18, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, November 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 November 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: 858AA328-B3D9-49D8-91A6-75935CF5F7A5
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
$ 4,902,057.28 $ 48,055,056.46 $ 47,342,564.57 $ 5,614,549.17 1,168,785.72 679,204.10 1,168,785.72 679,204.10
(3,756,687.03) 3,756,687.03 3,081,969.32 (3,081,969.32) Balance Per Bank - Bank of America
Deposits in Transit
Outstanding Checks
Fiscal Agents 29,468,685.07 5,435,402.04 10,763,517.17 24,140,569.94 Investments
Chandler Investment- City Account 314,058,780.03 7,914,997.81 7,630,125.05 314,343,652.79 Chandler Investment -Pension Trust Fund 30,093,224.49 13,969.06 30,107,193.55 LAIF 110,724,075.47 21,700,000.00 16,550,000.00 115,874,075.47 Investments Subtotal 454,876,079.99 29,628,966.87 24,180,125.05 460,324,921.81 Change Fund 10,248.00 10,248.00
Returned Checks 617.97 27,542.43 22,141.31 6,019.09
Credit Card Reconciling Items- Fees (2,550.71) 2,550.71 2,080.55 (2,080.55) TOTAL $ 486,667,236.29 $ 87,585,409.64 $ 86,561,183.69 $ 487,691,462.24 * For informational purpose only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements*
November 30, 2022
DocuSign Envelope ID: 858AA328-B3D9-49D8-91A6-75935CF5F7A5
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF
Chandler Investment- City Account
Chandler Investment -Pension Trust Fund
$ 115,874,075.47
$ 314,343,652.79
$ 30,107,193.55
$ 115,874,075.47
$ 314,343,652.79
$ 30,107,193.55
Investment Total 460,324,921.81 460,324,921.81
General Account - Bank of America 5,155,636.60 524,385.17 (2,968,237.82) 3,938.54 2,715,722.49 Worker's Comp Account - Bank of America 458,912.57 154,818.93 (113,731.50) 500,000.00 Fiscal Agent Accounts 24,140,569.94 24,140,569.94
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 490,090,288.92 $ 679,204.10 $ (3,081,969.32) $ 3,938.54 $ 487,691,462.24
CITY OF CORONA
Cash and Investment Status Report
November 30, 2022
Subject to final audit
DocuSign Envelope ID: 858AA328-B3D9-49D8-91A6-75935CF5F7A5 General Fund $ 135,178,645.69
Special Revenue Funds
Gas Tax 7,759,689.51
Measure A 19,742,631.60
Trip Reduction 1,567,074.30
Asset Forfeiture 384,591.71
Development 28,720,995.31
Residential Refuse/Recycling 20,530.02
Landscape and Streetlight Maintenance 22,425,445.14
Other Grants and Endowments 30,417,748.32 111,038,705.91 Debt Service Funds
Public Financing Authority 2,503.29 2,503.29
Capital Project Funds
Housing/Community Development (5,493.31)
Planned Local Drainage 472,805.54
Other Grants (5,663,924.96)
Public Facility Project (4,273,280.03)
Corona Housing Authority 18,210,652.56 27,680,545.32
Enterprise Funds
Water Utility 48,025,683.03
Water Reclamation Utility 78,517,520.42
Transit 1,023,653.70
Electric Utility 27,796,669.50
Airport 1,416,350.72 156,779,877.37
Internal Service Funds
Fleet Operations 4,799,842.58
Workers' Compensation 24,154,212.73
Liability Risk (1,152,350.84)
Warehouse Services 669,136.26
Information Technology 35,899,627.73 7,428,787.00
Fiduciary Funds
AD & CFD Bond Funds 24,849,270.33
AB109 PACT 25,245.60
Successor Agency 5,706,933.76 30,581,449.69
Total All Funds $ 487,691,462.24
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
November 30, 2022
DocuSign Envelope ID: 858AA328-B3D9-49D8-91A6-75935CF5F7A5
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 36,365,274.48 35,071,027.90 36,362,060.04 7.90%
Agency 68,745,000.00 63,779,692.39 69,211,791.40 15.04% CMO 18,008,918.31 17,476,735.75 18,293,872.86 3.97%
Pension Trust 441,601.58 31,612,581.38 30,107,193.56 6.54% Corporate 84,131,000.00 78,217,033.63 83,832,694.69 18.21% LAIF 115,874,075.47 115,874,075.47 115,874,075.47 25.17% Money Market Fund FI 1,610,357.46 1,610,357.46 1,610,357.46 0.35% Municipal Bonds 3,385,000.00 3,268,623.70 3,462,753.52 0.75% Negotiable CD 500,000.00 496,544.00 500,000.00 0.11%
Supranational 12,690,000.00 11,406,222.99 12,633,094.65 2.74% US Treasury 88,520,000.00 83,412,784.58 88,437,028.16 19.21% TOTAL PORTFOLIO $ 430,271,227.30 $ 442,225,679.25 $ 460,324,921.81 100.00% Subject to final audit
CITY OF CORONA
Investment Portfolio Report
November 30, 2022
DocuSign Envelope ID: 858AA328-B3D9-49D8-91A6-75935CF5F7A5