M E M O R A N D U M
June 15, 2022
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, April 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 April 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: 52331100-37E7-444E-ACB8-1A0E091B54C2
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 11,184,221.56 $ 60,868,590.56 $ 61,475,702.21 $ 10,577,109.91 $ Deposits in Transit 641,083.05 599,230.15 641,083.05 599,230.15 Outstanding Checks (6,535,340.38) 6,535,340.38 4,514,237.23 (4,514,237.23) Fiscal Agents 16,432,031.68 20,209,505.30 0.00 36,641,536.98 Investments 421,580,866.60 32,302,940.07 52,649,693.49 401,234,113.18 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 3,712.88 37,156.49 9,161.68 31,707.69
Pcard Reconcling Items 0.00 0.00 0.00 0.00
Credit Card Reconciling Items- Fees (2,689.92) 2,689.92 2,577.59 (2,577.59) TOTAL $ 120,555,452.87 443,314,033.47 $ 119,292,455.25 $ 444,577,031.09 $ *For information purposes only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements
April 30, 2022
DocuSign Envelope ID: 52331100-37E7-444E-ACB8-1A0E091B54C2
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 89,194,697.40 $ - $ $ - $ 89,194,697.40 - $
Investment Account 312,039,415.78 312,039,415.78
Investment Total 401,234,113.18 401,234,113.18
General Account - Bank of America 10,109,708.46 464,635.31 (4,412,240.94) 29,130.10 6,191,232.93 Worker's Comp Account - Bank of America 467,401.45 134,594.84 (101,996.29) 500,000.00 Fiscal Agent Accounts 36,641,536.98 36,641,536.98
Petty Cash 10,148.00 10,148.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 448,462,908.07 $ 599,230.15 $ (4,514,237.23) $ 29,130.10 $ 444,577,031.09 GENERAL LEDGER GRAND TOTAL $ 444,577,031.09
Subject to final audit
CITY OF CORONA
Cash Status Report
April 30, 2022
DocuSign Envelope ID: 52331100-37E7-444E-ACB8-1A0E091B54C2 General Fund $ 132,013,511.13
Special Revenue Funds
Gas Tax 9,891,875.50
Measure A 19,392,102.17
Trip Reduction 1,451,570.39
Asset Forfeiture 464,568.70
Development 29,204,465.50
Residential Refuse/Recycling (35,759.61)
Landscape and Streetlight Maintenance 21,650,576.84
Other Grants and Endowments 15,516,450.66 97,535,850.15 Debt Service Funds
Public Financing Authority 363,025.00 363,025.00
Capital Project Funds
Housing/Community Development 221,158.40
Planned Local Drainage 504,310.90
Other Grants (7,870,147.32)
Public Facility Project (4,273,280.03)
Corona Housing Authority 16,002,398.29 27,420,356.34
Enterprise Funds
Water Utility 32,246,388.09
Water Reclamation Utility 79,660,052.00
Transit 793,776.08
Electric Utility 25,821,742.69
Airport 1,416,383.18 139,938,342.04
Internal Service Funds
Fleet Operations 7,755,860.79
Workers' Compensation 24,915,106.55
Liability Risk 323,927.74
Warehouse Services 570,240.82
Information Technology 40,450,836.84 6,885,700.94
Fiduciary Funds
AD & CFD Bond Funds 11,828,221.41
AB109 PACT 25,014.17
Successor Agency 18,273,067.64 6,419,832.06
Total All Funds $ 444,577,031.09
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
April 30, 2022
DocuSign Envelope ID: 52331100-37E7-444E-ACB8-1A0E091B54C2
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 38,897,992.81 38,043,253.50 38,898,448.64 9.69%
Agency 75,045,000.00 71,643,326.32 75,650,330.40 18.85% CMO 20,588,270.64 20,609,906.07 21,170,278.30 5.28%
Commercial Paper 0.00%
Corporate 83,435,000.00 79,567,923.55 83,544,171.85 20.82% LAIF 89,194,697.40 89,194,697.40 89,194,697.40 22.23%
Money Market Fund FI 3,201,234.10 3,201,234.10 3,201,234.17 0.80% Municipal Bonds 3,385,000.00 3,331,144.65 3,462,753.45 0.86% Negotiable CD 500,000.00 495,652.50 500,000.00 0.12%
Supranational 12,690,000.00 11,660,706.90 12,633,094.65 3.15% US Treasury 72,970,000.00 69,755,033.97 72,979,104.32 18.19% TOTAL PORTFOLIO $ 387,502,878.96 399,907,194.95 $ 401,234,113.18 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
April 30, 2022
DocuSign Envelope ID: 52331100-37E7-444E-ACB8-1A0E091B54C2