DocuSign Envelope ID: 36C69E47-72B3-49DD-9EF9-0AF12DDCE164 CORONA
THE CIRCLE CITY
MEMORANDUM
October 18, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, August 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 August 2023, subject to final audit.
Prepared By: Reviewed By:
- DocuSigned by: - DS -DocuSigned by:
Lillian Davis EN (Cristine thompson
6343B2A43E4243A.. -6477487B2FB3438.
Financial Analyst Accounting Manager
Respectfully submitted:
- DocuSigned by: - DocuSigned by:
Kin Stor Brett Channing
-AEGAA40B08D44E7.. -B6776054CB5E5409..
Finance Director Assistant City Manager
•DocuSigned by:
| Chad Wilardson
AG0F9B8DEG2B4FG.
City Treasurer
Attachment
DocuSign Envelope ID: 36C69E47-72B3-49DD-9EF9-0AF12DDCE164
CITY OF CORONA
Receipts and Disbursements*
CORONA: August 31, 2023
HE CIRCLE CITY
fart. hed
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 3,797,693.63 $ 56,240,075.59 $ 51,985,024.79 $ 8,052,744.43 Deposits in Transit 1,870,840.33 2,147,079.11 1,870,840.33 2,147,079.11 Outstanding Checks (2,551,026.63) 2,551,026.63 2,741,716.72 (2,741,716.72) Fiscal Agents 13,277,755.69 3,389,638.16 606.84 16,666,787.01 Investments
Chandler Investment- City Account 467,951,739.80 52,882,300.72 52,196,370.87 468,637,669.65 Chandler Investment -Pension Trust Fund 32,766,093.93 16,852.22 32,782,946.15 LAIF 49,776,879.56 15,750,000.00 27,000,000.00 38,526,879.68 Investments Subtotal 550,494,713.29 68,649,152.94 79,196,370.87 539,947,495.48 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 11,348.51 44,562.70 54,033.52 1,877.69
Credit Card Reconciling Items- Fees (2,220.87) 2,220.87 2,423.39 (2,423.39) TOTAL $ 566,909,351.95 $ 133,023,756.00 $ 135,851,016.46 $ 564,082,091.61 * For informational purpose only
DocuSign Envelope ID: 36C69E47-72B3-49DD-9EF9-0AF12DDCE164
CORONA CITY OF CORONA
THE CIRCLE CITY Cash and Investment Status Report
Kanki thed August 31, 2023
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF $ 38,526,879.68 $ 38,526,879.68
Chandler Investment- City Account S 468,637,669.65 $ 468,637,669.65 Chandler Investment -Pension Trust Fund $ 32,782,946.15 $ 32,782,946.15 Investment Total 539,947,495.48 539,947,495.48
General Account - Bank of America 7,632,317.46 1,913,989.35 (2,588,199.99) (545.70) 6,957,561.12 Worker's Comp Account - Bank of America 420,426.97 233,089.76 (153,516.73) 500,000.00 Fiscal Agent Accounts 16,666,787.01 16,666,787.01
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR $ 564,677,274.92 $ 2,147,079.11 $ (2,741,716.72) $ (545.70) $ 564,082,091.61 Subject to final audit
DocuSign Envelope ID: 36C69E47-72B3-49DD-9EF9-0AF12DDCE164 CORONA g CITY OF CORONA
THE CIRCLE CITY
Cash Balance By Fund
August 31, 2023
General Fund $ 169,795,825.72
Special Revenue Funds
Gas Tax 10,377,511.07
Measure A 18,037,257.29
Trip Reduction 1,778,125.98
Asset Forfeiture 355,523.23
Development 30,475,140.84
Residential Refuse/Recycling 76,163.89
Landscape and Streetlight Maintenance 25,472,108.26
Other Grants and Endowments 29,344,580.79 115,916,411.35 Debt Service Funds
Public Financing Authority 19.79 19.79
Capital Project Funds
Housing/Community Development 187,877.35
Planned Local Drainage 490,821.87
Other Grants 21,132,894.37
Public Facility Project (3,875,769.61)
Corona Housing Authority 28,184,903.15 46,120,727.13
Enterprise Funds
Water Utility 52,401,552.94
Water Reclamation Utility 76,823,029.40
Transit 764,026.73
Electric Utility 20,089,495.16
Airport 1,645,859.20 151,723,963.43
Internal Service Funds
Fleet Operations 6,202,423.29
Workers' Compensation 24,276,338.73
Liability Risk (469,265.20)
Warehouse Services 835,153.06
Information Technology 9,109,576.51 39,954,226.39
Fiduciary Funds
AD & CFD Bond Funds 30,571,146.44
AB109 PACT
Successor Agency 9,999,771.36 40,570,917.80
Total All Funds $ 564,082,091.61
Subject to final audit
DocuSign Envelope ID: 36C69E47-72B3-49DD-9EF9-0AF12DDCE164
CITY OF CORONA
THE CIRCLE CITY Investment Portfolio Report
LOUR • TO PIEC August 31, 2023
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 26,113,978.25 25,497,198.73 26,110,825.32 4.84%
Agency 71,245,000.00 67,051,533.92 71,691,626.40 13.28% CMO 28,644,843.24 27,158,083.75 27,975,062.11 5.18%
Pension Trust 750,025.31 32,766,093.93 32,782,946.15 6.07% Corporate 93,276,000.00 88,064,531.64 92,819,062.39 17.19% LAIF 38,526,879.61 38,526,879.61 38,526,879.73 7.14%
Money Market Fund FI 1,827,589.03 1,827,589.03 1,827,589.03 0.34% Municipal Bonds 3,385,000.00 3,275,495.25 3,462,753.45 0.64% Supranational 12,690,000.00 11,537,954.73 12,633,094.65 2.34% US Treasury 234,820,000.00 227,407,398.80 232,117,656.25 42.99% TOTAL PORTFOLIO $ 511,279,315.44$ 523,112,759.39 $ 539,947,495.48 100.00% Average Daily Balance
Subject to final audit
DocuSign
Certificate Of Completion
Envelope Id: 36C69E4772B349DD9EF90AF12DDCE164 Status: Completed Subject: Complete with DocuSign: Monthly Fiscal Report August 2023 unsigned.pdf, Aug backup.pdf Source Envelope:
Document Pages: 5 Signatures: 5 Envelope Originator:
Certificate Pages: 2 Initials: 1 Lillian Davis
AutoNav: Enabled 400 S Vicentia Ave
Envelopeld Stamping: Enabled Corona, CA 92882
Time Zone: (UTC-08:00) Pacific Time (US & Canada) Lillian. [email protected] IP Address: 64.29.226.10
Record Tracking
Status: Original Holder: Lillian Davis Location: DocuSign 10/9/20235:13:31 PM [email protected]
Security Appliance Status: Connected Pool: StateLocal
Storage Appliance Status: Connected Pool: City of Corona, CA Location: DocuSign Signer Events Signature Timestamp
Lillian Davis - DocuSigned by: Sent: 10/9/2023 5:16:20 PM [email protected] Lillian Davis Viewed: 10/9/2023 5:16:27 PM Financial Analyst I - 631382A434243... Signed: 10/9/2023 5:16:46 PM City of Corona, CA Signature Adoption: Pre-selected Style Security Level: Email, Account Authentication
(None) Using IP Address: 64.29.226.10
ectronic Record and Signature Disclosur
ot Offered via DocuSig
- DS Sent: 10/9/2023 5:16:47 PM
Eliana Nguyen
[email protected] EN Viewed: 10/9/2023 5:36:32 PM Security Level: Email, Account Authentication Signed: 10/9/2023 5:37:32 PM (None)
Signature Adoption: Pre-selected Style
Using IP Address: 64.29.226.10
Electronic Record and Signature Disclosure:
Not Offered via DocuSign
Christine Thompson - DocuSigned by: Sent: 10/9/2023 5:37:33 PM Christine. [email protected] Cluristine thompson Viewed: 10/10/2023 1:32:44 PM Accounting Manager C477487B2FB3438... Signed: 10/10/2023 1:33:00 PM Security Level: Email, Account Authentication Signature Adoption: Pre-selected Style (None)
Using IP Address: 64.29.226.10
Electronic Record and Signature Disclosure:
Not Offered via DocuSign
Kim Sitton —DocuSigned by: Sent: 10/10/2023 1:33:02 PM
Kim. [email protected] Kin Stor Viewed: 10/10/2023 4:36:05 PM - AEGAA49BOBD44E...
Finance Director Signed: 10/10/2023 4:37:20 PM
City of Corona, CA
Security Level: Email, Account Authentication Signature Adoption: Pre-selected Style (None) Using IP Address: 64.29.226.10
Electronic Record and Signature Disclosure:
Not Offered via DocuSign
Signer Events Signature Timestamp
Brett Channing - DocuSigned by: Sent: 10/10/2023 4:37:22 PM Brett. [email protected] Brett Canning Viewed: 10/11/2023 11:10:27 AM Security Level: Email, Account Authentication - B677651CB5E54C9...
Signed: 10/11/2023 11:10:55 AM
(None)
Signature Adoption: Pre-selected Style
Using IP Address: 64.29.226.10
Electronic Record and Signature Disclosure:
Not Offered via DocuSign
Chad Willardson DocuSigned by: Sent: 10/11/2023 11:10:56 AM [email protected] Chad Willardson Viewed: 10/11/2023 2:28:06 PM -ACOF9B8DE6284FC...
Security Level: Email, Account Authentication Signed: 10/11/2023 2:28:14 PM (None)
Signature Adoption: Pre-selected Style
Using IP Address: 174.211.100.3
Signed using mobile
Electronic Record and Signature Disclosure:
Not Offered via DocuSign
In Person Signer Events Signature Timestamp
Editor Delivery Events Status Timestamp
Agent Delivery Events Status Timestamp
Intermediary Delivery Events Status Timestamp
Certified Delivery Events Status Timestamp
Carbon Copy Events Status Timestamp
Witness Events Signature Timestamp
Notary Events Signature Timestamp
Envelope Summary Events Status Timestamps
Envelope Sent Hashed/Encrypted 10/9/20235:16:20 PM
Certified Delivered Security Checked 10/11/20232:28:06 PM Signing Complete Security Checked 10/11/2023 2:28:14 PM Completed Security Checked 10/11/20232:28:14 PM
Payment Events Status Timestamps