M E M O R A N D U M
January 4, 2022
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, November 2021
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 2021, 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: CB70287C-9824-468F-8A29-FBAB032DFE53
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 9,406,922.56 $ 33,902,137.70 $ 36,572,270.47 $ 6,736,789.79 $ Deposits in Transit 317,582.21 1,439,906.18 317,582.21 1,439,906.18 Outstanding Checks (7,076,092.54) 7,076,092.54 4,736,527.21 (4,736,527.21) Fiscal Agents 12,746,159.56 3,078,446.51 6,803,400.02 9,021,206.05 Investments 377,010,401.94 27,383,369.49 24,043,256.36 380,350,515.07 Change Fund 10,148.00 0.00 0.00 10,148.00
Returned Checks 134.24 73,551.04 71,097.82 2,587.46
Credit Card Reconciling Items- Fees (2,363.64) 2,363.64 2,070.79 (2,070.79) TOTAL $ 72,955,867.10 392,412,892.33 $ 72,546,204.88 $ 392,822,554.55 $ *For information purposes only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements
NOVEMBER 30, 2021
DocuSign Envelope ID: CB70287C-9824-468F-8A29-FBAB032DFE53
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 71,473,420.92 $ - $ $ - $ 71,473,420.92 - $
Investment Account 308,877,094.15 308,877,094.15
Investment Total 380,350,515.07 380,350,515.07
General Account - Bank of America 6,268,858.14 1,321,999.26 (4,650,688.64) 516.67 2,940,685.43 Worker's Comp Account - Bank of America 467,931.65 117,906.92 (85,838.57) 500,000.00 Fiscal Agent Accounts 9,021,206.05 9,021,206.05
Petty Cash 10,148.00 10,148.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 396,118,658.91 $ 1,439,906.18 $ (4,736,527.21) $ 516.67 $ 392,822,554.55 GENERAL LEDGER GRAND TOTAL $ 392,822,554.55
Subject to final audit
CITY OF CORONA
Cash Status Report
NOVEMBER 30, 2021
DocuSign Envelope ID: CB70287C-9824-468F-8A29-FBAB032DFE53 General Fund $ 101,068,742.79
Special Revenue Funds
Gas Tax 8,721,446.34
Measure A 18,395,079.72
Trip Reduction 1,358,442.38
Asset Forfeiture 529,939.74
Development 26,705,926.05
Residential Refuse/Recycling 32,380.90
Landscape and Streetlight Maintenance 20,928,674.04
Other Grants and Endowments 15,633,305.09 92,305,194.26 Debt Service Funds
Public Financing Authority 20.40 20.40
Capital Project Funds
Housing/Community Development 91,481.11
Planned Local Drainage 341,931.50
Other Grants (2,029,485.70)
Public Facility Project (4,273,280.03)
Corona Housing Authority 19,237,257.42 13,367,904.30
Enterprise Funds
Water Utility 31,523,036.47
Water Reclamation Utility 78,054,775.37
Transit 641,036.10
Electric Utility 25,393,213.78
Airport 1,306,890.44 136,918,952.16
Internal Service Funds
Fleet Operations 5,440,998.87
Workers' Compensation 24,959,949.77
Liability Risk 286,083.56
Warehouse Services 478,459.09
Information Technology 4,579,130.86 35,744,622.15
Fiduciary Funds
AD & CFD Bond Funds 9,274,384.43
AB109 PACT 24,840.15
Successor Agency 4,117,893.91 13,417,118.49
Total All Funds 392,822,554.55 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
NOVEMBER 30, 2021
DocuSign Envelope ID: CB70287C-9824-468F-8A29-FBAB032DFE53
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 31,752,772.72 31,713,400.08 31,765,686.72 8.35%
Agency 78,995,000.00 79,745,872.90 79,509,058.90 20.90% CMO 19,454,693.60 20,126,882.38 19,973,238.68 5.25%
Commercial Paper - - - 0.00%
Corporate 77,970,000.00 79,104,383.44 78,107,060.30 20.54% LAIF 71,473,420.92 71,473,420.92 71,473,420.92 18.79%
Money Market Fund FI 644,765.91 644,765.91 644,765.95 0.17% Municipal Bonds 3,385,000.00 3,530,284.20 3,462,753.45 0.91% Negotiable CD 500,000.00 500,019.50 499,999.98 0.13%
Supranational 20,290,000.00 20,116,946.55 20,154,267.65 5.30% US Treasury 74,720,000.00 75,440,390.32 74,760,262.52 19.66% TOTAL PORTFOLIO $ 382,396,366.20 379,185,653.15 $ 380,350,515.07 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
NOVEMBER 30, 2021
DocuSign Envelope ID: CB70287C-9824-468F-8A29-FBAB032DFE53