M E M O R A N D U M
May 18, 2022
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, March 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 March 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: 35D60FEA-91E8-44FE-A73E-AA78C34C5B1C
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 2,808,564.77 $ 45,459,792.74 $ 37,084,135.95 $ 11,184,221.56 $ Deposits in Transit 976,112.45 641,083.05 976,112.45 641,083.05 Outstanding Checks (1,407,951.36) 1,407,951.36 6,535,340.38 (6,535,340.38) Fiscal Agents 19,284,193.61 3,259,448.30 6,111,584.67 16,432,057.24 Investments 429,340,673.85 25,617,997.47 33,377,804.72 421,580,866.60 Unrealized Investment Gain (Loss) 0.00 0.00 0.00 0.00
Change Fund 10,148.00 0.00 0.00 10,148.00
Returned Checks 822.54 19,163.99 16,273.65 3,712.88
Pcard Reconcling Items 0.00 0.00 0.00 0.00
Credit Card Reconciling Items- Fees (2,380.52) 2,380.52 2,689.92 (2,689.92) TOTAL $ 76,407,817.43 451,010,183.34 $ 84,103,941.74 $ 443,314,059.03 $ *For information purposes only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements
March 31, 2022
DocuSign Envelope ID: 35D60FEA-91E8-44FE-A73E-AA78C34C5B1C
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 110,214,016.68 $ - $ $ - $ 110,214,016.68 - $
Investment Account 311,366,849.92 311,366,849.92
Investment Total 421,580,866.60 421,580,866.60
General Account - Bank of America 10,733,256.11 508,434.27 (6,451,726.15) 1,022.96 4,790,987.19 Worker's Comp Account - Bank of America 450,965.45 132,648.78 (83,614.23) 500,000.00 Fiscal Agent Accounts 16,432,057.24 16,432,057.24
Petty Cash 10,148.00 10,148.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 449,207,293.40 $ 641,083.05 $ (6,535,340.38) $ 1,022.96 $ 443,314,059.03 GENERAL LEDGER GRAND TOTAL $ 443,314,059.03
Subject to final audit
CITY OF CORONA
Cash Status Report
March 31, 2022
DocuSign Envelope ID: 35D60FEA-91E8-44FE-A73E-AA78C34C5B1C General Fund $ 100,909,970.20
Special Revenue Funds
Gas Tax 9,443,306.75
Measure A 17,748,825.62
Trip Reduction 1,466,165.87
Asset Forfeiture 465,275.31
Development 28,927,261.76
Residential Refuse/Recycling 72,717.47
Landscape and Streetlight Maintenance 22,249,267.18
Other Grants and Endowments 15,512,991.66
Section 115 Trust 30,000,000.00 125,885,811.62
Debt Service Funds
Public Financing Authority (46.60) (46.60)
Capital Project Funds
Housing/Community Development 149,373.87
Planned Local Drainage 576,588.09
Other Grants (6,302,733.56)
Public Facility Project (4,273,280.03)
Corona Housing Authority 17,544,326.46 27,394,378.09
Enterprise Funds
Water Utility 31,797,333.64
Water Reclamation Utility 78,928,378.06
Transit 797,930.76
Electric Utility 25,761,981.49
Airport 1,437,814.01 138,723,437.96
Internal Service Funds
Fleet Operations 8,094,335.05
Workers' Compensation 24,782,899.99
Liability Risk 328,390.24
Warehouse Services 592,131.60
Information Technology 41,515,964.34 7,718,207.46
Fiduciary Funds
AD & CFD Bond Funds 11,835,933.98
AB109 PACT 24,988.79
Successor Agency 18,734,595.05 6,873,672.28
Total All Funds $ 443,314,059.03
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
March 31, 2022
DocuSign Envelope ID: 35D60FEA-91E8-44FE-A73E-AA78C34C5B1C
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 39,916,846.32 39,194,246.65 39,919,201.76 9.47%
Agency 78,595,000.00 75,937,004.93 79,175,541.90 18.78% CMO 21,658,167.20 21,858,143.52 22,277,636.56 5.28%
Commercial Paper 0.00%
Corporate 85,210,000.00 82,559,289.65 85,171,645.80 20.20% LAIF 110,214,016.68 110,214,016.68 110,214,016.68 26.14% Money Market Fund FI 1,570,957.37 1,570,957.37 1,570,957.44 0.37% Municipal Bonds 3,385,000.00 3,365,130.05 3,462,753.45 0.82% Negotiable CD 1,000,000.00 997,342.00 999,999.98 0.24%
Supranational 12,690,000.00 11,821,768.66 12,633,094.65 3.00% US Treasury 65,970,000.00 63,601,670.75 66,156,018.38 15.69% TOTAL PORTFOLIO $ 411,119,570.26 420,209,987.57 $ 421,580,866.60 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
March 31, 2022
DocuSign Envelope ID: 35D60FEA-91E8-44FE-A73E-AA78C34C5B1C