M E M O R A N D U M
March 16, 2022
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, January 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 January 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: D800E6F5-A902-4D7C-BF9E-AD83E59BB00B
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 5,237,235.82 $ 55,928,176.07 $ 57,460,340.86 $ 3,705,071.03 $ Deposits in Transit 154,298.33 1,834,907.89 154,298.33 1,834,907.89 Outstanding Checks (3,124,211.47) 3,124,211.47 2,321,449.21 (2,321,449.21) Fiscal Agents 9,022,748.51 33,276.51 50,825.13 9,005,199.89 Investments 388,055,926.19 61,496,467.90 35,789,775.87 413,762,618.22 Change Fund 10,148.00 0.00 0.00 10,148.00
Returned Checks 8,291.60 14,319.26 22,001.27 609.59
Credit Card Reconciling Items- Fees (2,233.70) 2,233.70 1,786.08 (1,786.08) TOTAL $ 122,433,592.80 399,362,203.28 $ 95,800,476.75 $ 425,995,319.33 $ *For information purposes only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements
JANUARY 31, 2022
DocuSign Envelope ID: D800E6F5-A902-4D7C-BF9E-AD83E59BB00B
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 103,514,016.68 $ - $ $ - $ 103,514,016.68 - $
Investment Account 310,248,601.54 310,248,601.54
Investment Total 413,762,618.22 413,762,618.22
General Account - Bank of America 3,266,135.16 1,691,103.76 (2,238,709.21) (1,176.49) 2,717,353.22 Worker's Comp Account - Bank of America 438,935.87 143,804.13 (82,740.00) 500,000.00 Fiscal Agent Accounts 9,005,199.89 9,005,199.89
Petty Cash 10,148.00 10,148.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 426,483,037.14 $ 1,834,907.89 $ (2,321,449.21) $ (1,176.49) $ 425,995,319.33 GENERAL LEDGER GRAND TOTAL $ 425,995,319.33
Subject to final audit
CITY OF CORONA
Cash Status Report
JANUARY 31, 2022
DocuSign Envelope ID: D800E6F5-A902-4D7C-BF9E-AD83E59BB00B General Fund $ 119,716,251.61
Special Revenue Funds
Gas Tax 8,878,597.50
Measure A 18,649,028.32
Trip Reduction 1,416,760.25
Asset Forfeiture 474,840.69
Development 27,067,817.35
Residential Refuse/Recycling 64,863.29
Landscape and Streetlight Maintenance 25,029,177.53
Other Grants and Endowments 15,514,309.26 97,095,394.19 Debt Service Funds
Public Financing Authority 20.40 20.40
Capital Project Funds
Housing/Community Development 52,804.76
Planned Local Drainage 234,078.40
Other Grants (5,812,543.74)
Public Facility Project (4,273,280.03)
Corona Housing Authority 19,327,204.77 9,528,264.16
Enterprise Funds
Water Utility 32,016,872.73
Water Reclamation Utility 77,867,801.01
Transit 436,081.65
Electric Utility 25,826,281.79
Airport 1,354,893.14 137,501,930.32
Internal Service Funds
Fleet Operations 8,881,024.35
Workers' Compensation 24,758,494.54
Liability Risk 342,454.21
Warehouse Services 520,216.60
Information Technology 6,566,198.82 41,068,388.52
Fiduciary Funds
AD & CFD Bond Funds 13,389,109.23
AB109 PACT 24,913.04
Successor Agency 7,671,047.86 21,085,070.13
Total All Funds 425,995,319.33 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
JANUARY 31, 2022
DocuSign Envelope ID: D800E6F5-A902-4D7C-BF9E-AD83E59BB00B
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 32,938,684.70 32,735,713.05 32,946,498.00 7.96%
Agency 83,295,000.00 82,866,896.80 83,806,263.90 20.25% CMO 18,964,086.68 19,451,726.45 19,465,619.08 4.70%
Commercial Paper - - - 0.00%
Corporate 87,170,000.00 86,885,673.26 87,151,385.30 21.06% LAIF 103,514,016.68 103,514,016.68 103,514,016.68 25.02% Money Market Fund FI 1,966,585.95 1,966,585.95 1,966,585.99 0.48% Municipal Bonds 3,385,000.00 3,471,960.65 3,462,753.45 0.84% Negotiable CD 500,000.00 500,033.00 499,999.98 0.12%
Supranational 12,690,000.00 12,232,670.32 12,633,094.65 3.05% US Treasury 68,170,000.00 67,681,721.35 68,316,401.19 16.51% TOTAL PORTFOLIO $ 411,306,997.51 412,593,374.01 $ 413,762,618.22 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
JANUARY 31, 2022
DocuSign Envelope ID: D800E6F5-A902-4D7C-BF9E-AD83E59BB00B