M E M O R A N D U M
May 17, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, March 2023
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 2023, subject to final audit.
Prepared By: Reviewed By:
_______________________________ _______________________________ Financial Analyst Accounting Manager
Respectfully submitted:
_______________________________ _______________________________ Finance Director City Manager
_______________________________
City Treasurer
Attachment
DocuSign Envelope ID: 36A84260-A026-4C5D-B2F7-45C62991D61C
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America $ 4,897,741.30 $ 40,648,115.51 $ 42,247,678.29 $ 3,298,178.52 Deposits in Transit 1,017,738.66 157,561.00 1,017,738.66 157,561.00 Outstanding Checks (3,267,295.09) 3,267,295.09 1,271,858.18 (1,271,858.18) Fiscal Agents 35,209,781.54 3,329,837.18 6,170,684.60 32,368,934.12 Investments
Chandler Investment- City Account 315,490,531.27 (25,439,646.14) 9,854,519.08 280,196,366.05 Chandler Investment -Pension Trust Fund 32,421,982.99 2,124,634.78 34,546,617.77 LAIF 173,792,723.71 52,430,000.00 24,700,000.00 201,522,723.71 Investments Subtotal 521,705,237.97 29,114,988.64 34,554,519.08 516,265,707.53 Change Fund 10,248.00 10,248.00
Returned Checks 18,000.94 19,668.53 33,842.25 3,827.22
Credit Card Reconciling Items- Fees (3,645.36) 3,645.36 3,816.19 (3,816.19) TOTAL $ 559,587,807.96 $ 76,541,111.31 $ 85,300,137.25 $ 550,828,782.02 * For informational purpose only
Subject to final audit
CITY OF CORONA
Receipts and Disbursements
March 31, 2023
DocuSign Envelope ID: 36A84260-A026-4C5D-B2F7-45C62991D61C
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 201,522,723.71 $ $ 201,522,723.71
Chandler Investment- City Account 280,196,366.05 $ $ 280,196,366.05 Chandler Investment -Pension Trust Fund 34,546,617.77 $ $ 34,546,617.77 Investment Total 516,265,707.53 516,265,707.53
General Account - Bank of America 2,967,355.51 (145,640.28) (1,137,833.89) 11.03 1,683,892.37 Worker's Comp Account - Bank of America 330,823.01 303,201.28 (134,024.29) 500,000.00 Fiscal Agent Accounts 32,368,934.12 32,368,934.12
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 551,943,068.17 $ 157,561.00 $ (1,271,858.18) $ 11.03 $ 550,828,782.02
CITY OF CORONA
Cash and Investment Status Report
March 31, 2023
Subject to final audit
DocuSign Envelope ID: 36A84260-A026-4C5D-B2F7-45C62991D61C General Fund $ 167,627,073.45
Special Revenue Funds
Gas Tax 8,537,870.00
Measure A 17,064,412.04
Trip Reduction 1,672,761.08
Asset Forfeiture 343,624.05
Development 29,166,804.68
Residential Refuse/Recycling (87,048.43)
Landscape and Streetlight Maintenance 23,557,708.03
Other Grants and Endowments 29,344,877.96 109,601,009.41 Debt Service Funds
Public Financing Authority 2,535.51 2,535.51
Capital Project Funds
Housing/Community Development 271,694.55
Planned Local Drainage 348,928.17
Other Grants 19,151,725.08
Public Facility Project (3,875,769.60)
Corona Housing Authority 44,013,192.08 28,116,613.88
Enterprise Funds
Water Utility 48,659,808.53
Water Reclamation Utility 77,290,403.84
Transit 578,500.35
Electric Utility 24,536,298.02
Airport 1,471,202.89 152,536,213.63
Internal Service Funds
Fleet Operations 8,115,321.99
Workers' Compensation 24,567,624.21
Liability Risk (1,242,761.67)
Warehouse Services 819,665.73
Information Technology 43,087,084.09 10,827,233.83
Fiduciary Funds
AD & CFD Bond Funds 26,998,190.62
AB109 PACT 25,286.58
Successor Agency 33,961,673.85 6,938,196.65
Total All Funds $ 550,828,782.02
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
March 31, 2023
DocuSign Envelope ID: 36A84260-A026-4C5D-B2F7-45C62991D61C
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 33,289,770.51 32,410,850.87 33,286,209.37 6.45%
Agency 64,745,000.00 60,737,770.60 65,211,511.40 12.63% CMO 24,531,880.44 23,856,044.21 24,441,213.86 4.73%
Pension Trust 552,814.80 33,798,685.90 32,553,232.17 6.31% Corporate 92,671,000.00 87,490,320.13 92,286,442.89 17.88% LAIF 137,892,723.71 137,892,723.71 137,892,723.71 26.71% Money Market Fund FI 626,497.80 626,497.80 626,497.80 0.12% Municipal Bonds 3,385,000.00 3,282,197.55 3,462,753.45 0.67% Supranational 12,690,000.00 11,610,256.32 12,633,094.65 2.45% US Treasury 114,120,000.00 110,191,476.10 113,872,028.23 22.06% TOTAL PORTFOLIO $ 484,504,687.26 $ 501,896,823.19 $ 516,265,707.53 100.00%
CITY OF CORONA
Investment Portfolio Report
March 31, 2023
Subject to final audit
DocuSign Envelope ID: 36A84260-A026-4C5D-B2F7-45C62991D61C