RFP2025-2_-_Exhibit_A_-_Dec_2024_Analysis_Statements.pdf
PDF 102 KB Posted
- Attached to
- Banking Services State and local contract opportunity
- Solicitation number
- RFP2025-2
- Issued by
- Broward County, Florida
About this file
This is a Bank of America business checking account analysis statement for the City of Cooper City, Florida, covering the monthly settlement period ending December 31, 2024. The statement reflects the City's primary operating account maintained at Bank of America's Wilmington, Delaware office, serving the Finance Department's banking needs. The account analysis demonstrates substantial average positive ledger balances of approximately $28.5 million, with available collected balances of $28.48 million during the reporting period. Service charges totaled $7,911.09 for the month, offset by earnings credits of $24,725.39 generated at the current month's earnings credit rate of 1.02%, resulting in a net excess allowance of $16,814.30. The statement itemizes depository services including account maintenance ($27.00), banking center deposits ($520.20), zero-balance account maintenance and transactions ($41.44), returned checks and chargebacks ($30.60), and various other banking center processing fees totaling approximately $5,479.73 in required balance support.
This analysis statement serves as an exhibit supporting the City's RFP2025-2 for Banking Services, which seeks a qualified financial institution to provide comprehensive banking services under a five-year contract with a five-year renewal option. The document evidences the existing banking relationship structure and fee arrangements that inform the scope of services sought in the current procurement, including online account access, daily balance reporting, positive pay functionality, wire transfers, remote deposit capture, and treasury management services. The compensation structure operates through earnings credits on account balances rather than direct monetary payments from the City, with the selected vendor required to manage multiple accounts including an operating account, zero-balance accounts payable account, and Development Impact Fee account. Proposals are due May 12, 2025, at 3:00 pm EST, with evaluation weighted 70% on technical criteria and 30% on pricing.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Banking_Services_(Addendum_#4_Revision).pdf | ||
| Banking_Services_(Addendum_#4_Revision).pdf | ||
| RFP2025-2_-_Draft_Agreement.pdf | ||
| RFP2025-2_-_Draft_Agreement.pdf | ||
| RFP2025-2_-_Exhibit_C_-_Feb_2025_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_C_-_Feb_2025_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_B_-_Jan_2025_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_A_-_Dec_2024_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_B_-_Jan_2025_Analysis_Statements.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
For the best experience, open this PDF portfolio in
Acrobat X or Adobe Reader X, or later.
Get Adobe Reader Now!
http://www.adobe.com/go/reader
ANALYSIS STATEMENT
BANK OF AMERICA, N.A. Member FDIC
P.O. BOX 15284
WILMINGTON DE 19850
FULL ANALYSIS BUSINESS CKG 01 0048 4090 0476 01 0048 4090 0476
BANK AND COST CENTER NUMBER 075 0001166 075
DATE PREPARED 01-06-25
CITY OF COOPER CITY MONTH ENDING 12-31-24
BUSINESS CHECKING MONTHLY SETTLEMENT 12-31-24
9090 SW 50TH PL SETTLEMENT & ACCOUNT TYPE GROUPED 507
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
BALANCE SUMMARY EARNINGS CREDIT SUMMARY
AVG POSITIVE LEDGER BALANCE $ 28,538,308.29 AVAIL BAL FOR EARNINGS CREDIT $ 28,479,921.42
__________________ EARNINGS ON AVAILABLE BALANCE 24,725.39
LESS TOTAL SERVICE CHARGES 7,911.09
AVG LEDGER BALANCE 28,538,308.29 __________________
LESS AVG FLOAT 58,386.87
__________________ EXCESS ALLOWANCE 16,814.30
AVG COLLECTED BALANCE 28,479,921.42 __________________
AVG NEGATIVE COLL BALANCE .00
__________________ PERIOD TO DATE EXCESS ALLOWANCE 16,814.30
AVG POSITIVE COLL BALANCE 28,479,921.42 __________________
LESS RESERVES 00% .00 __________________
AVAIL BAL FOR EARNINGS CREDIT 28,479,921.42
AVAILABLE BALANCE REQUIRED 9,112,380.61
NET AVAILABLE BALANCE 19,367,540.81
CURRENT MONTH'S EARNINGS CREDIT RATE = 1.02% CURRENT MONTH'S MULTIPLE = $1,157.49
NUMBER OF UNIT SERVICE BALANCE
SERVICE UNITS PRICE CHARGE REQUIRED
BALANCE RELATED SERVICES
DEPOSIT BANK ASSESSMENT 28,538,308 4,757.33 5,479,725.51
DEPOSITORY SERVICES
ACCOUNT MAINTENANCE 1 27.0000 27.00 31,099.92
BANKING CENTER DEPOSIT 102 5.1000 520.20 599,191.82
DEPOSIT CORRECTION-NONCASH-RDS 2 5.3000 10.60 12,209.60
ZBA-DEPOSITORY+ MASTER MAINT 1 41.0000 41.00 47,225.81
ZBA PER TRANSACTION 22 .0200 .44 506.81
RETURNS-CHARGEBACK 6 5.1000 30.60 35,246.58
CHECKS DEPOSITED-BKG CENTER 161 .2200 35.42 40,798.48
STOP PAY AUTOMATED<=12 MONTHS 39 15.0000 585.00 673,831.63
DEBITS POSTED-ELECTRONIC 23 .1600 3.68 4,238.81
CREDITS POSTED-ELECTRONIC 226 .1600 36.16 41,650.86
CHECK DEPOSIT-ICL OR RDSO 64 .8000 51.20 58,974.66
IMAGE DEPOSITED ITEMS-RDSO 2,374 .0600 142.44 164,069.36
COMMERCIAL DEPS-CASH VAULT
CURR-COIN DEP-$100-QBD-ND 1 .2500 .25 287.96
CURR-COIN DEP-$100-BKG CTR 403 .2200 88.66 102,122.93
GENERAL ACH SERVICES
ACH REPORTS-ELECTRONIC 18 2.0000 36.00 41,466.56
TWhite
Stamp
FULL ANALYSIS BUSINESS CKG 01 0048 4090 0476 01 0048 4090 0476
BANK AND COST CENTER NUMBER 075 0001166 075
BUSINESS CHECKING MONTHLY SETTLEMENT 12-31-24
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
ACH REPORTS-FAX 7 5.0000 35.00 40,314.72
ACH RETURN ITEM 13 3.5000 45.50 52,409.12
ACH MONTHLY MAINTENANCE 2 35.0000 70.00 80,629.43
ACH INPUT-FILE 9 20.0000 180.00 207,332.81
ACH BLOCKS AUTH INSTRUCTIONS 49 1.0000 49.00 56,440.60
ACH NOTIF OF CHANGE (NOC) 10 3.5000 35.00 40,314.71
ACH ON US DEBITS 2 .1100 .22 253.41
ACH OFF US DEBITS 1,983 .1100 218.13 251,252.81
ACH ON US DEBITS-SAME DAY 668 .1100 73.48 84,637.86
ACH CREDIT RECEIVED ITEM 226 .0100 2.26 2,603.18
ACH DEBIT RECEIVED ITEM 30 .0200 .60 691.11
ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 46,073.95
WIRE TRANSFER
WIRE MONTHLY SUBSCRIPTION 1 38.0000 38.00 43,770.26
PH OR STND ORDER TMPLT STORG 8 .1000 .80 921.48
ELEC WIRE OUT-DOMESTIC 4 10.0000 40.00 46,073.96
ELEC WIRE OUT-BOOK DB 2 4.0000 8.00 9,214.79
CASHPRO GP CUST MNT TMPLT STRG 9 .0000 .00 0.00
ACCOUNT RECONCILIATION
ARP PPAY MAINT-NO RECON 1 43.0000 43.00 49,529.50
INFORMATION SERVICES
CASHPRO ARP REPORTS 2 25.0000 50.00 57,592.44
CASHPRO ONLINE SUBSCRIPTION 1 55.0000 55.00 63,351.69
CASHPRO REPORTING SUBSCRIPTION 1 7.0000 7.00 8,062.95
CASHPRO ONLINE PDR ACCOUNT 4 16.0000 64.00 73,718.33
CASHPRO ONLINE PDR ITEM 1,547 .1000 154.70 178,191.03
CASHPRO ONLINE CDR ACCOUNT 1 16.0000 16.00 18,429.58
CASHPRO ONLINE CDR ITEM 664 .1000 66.40 76,482.77
REMOTE DEPOSIT SERVICES
REMOTE DEPOSIT ACCOUNT MAINT 1 225.0000 225.00 259,166.02
REMOTE DEPOSIT CHK IMAGE PROC 2,374 .0100 23.74 27,344.89
REMOTE DEPOSIT ITEM STORAGE 109,643 .0000 .00 0.00
IMAGE
IMAGE ARCHIVE 169 .0253 4.28 4,929.91
CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00
CASHPRO ONLINE IMAGE RETRIEVAL 2 .0000 .00 0.00
TOTAL SERVICE CHARGES 7,911.09 9,112,380.61
THIS ACCOUNT IS ANALYZED AT THE GROUP LEVEL.
GROUP NUMBER IS 075 0048 4089 8611.
FULL ANALYSIS BUSINESS CKG 01 0042 8117 3553 01 0042 8117 3553
BANK AND COST CENTER NUMBER 075 0001166 075
DEVELOPMENT IMPACT FEES MONTHLY SETTLEMENT 12-31-24
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
AVG POSITIVE LEDGER BALANCE $ 606,560.51 AVAIL BAL FOR EARNINGS CREDIT $ 606,560.51
__________________ EARNINGS ON AVAILABLE BALANCE 526.59
LESS TOTAL SERVICE CHARGES 194.11
AVG LEDGER BALANCE 606,560.51 __________________
LESS AVG FLOAT .00
__________________ EXCESS ALLOWANCE 332.48
AVG COLLECTED BALANCE 606,560.51 __________________
__________________ PERIOD TO DATE EXCESS ALLOWANCE 332.48
AVG POSITIVE COLL BALANCE 606,560.51 __________________
AVAIL BAL FOR EARNINGS CREDIT 606,560.51
AVAILABLE BALANCE REQUIRED 223,585.39
NET AVAILABLE BALANCE 382,975.12
BALANCE RELATED SERVICES
DEPOSIT BANK ASSESSMENT 606,560 101.11 116,463.44
ACCOUNT MAINTENANCE 1 27.0000 27.00 31,099.92
ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,151.85
ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 25,340.68
ARP PPAY MAINT-NO RECON 1 43.0000 43.00 49,529.50
TOTAL SERVICE CHARGES 194.11 223,585.39
01 0042 8117 3553 01 0042 8117 3553 075 075
FJSNC FJSNC
THIS PAGE INTENTIONALLY LEFT BLANK
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8611 01 0048 4089 8611
BANK AND COST CENTER NUMBER 075 0001166 075
OPERATING ACCOUNT MONTHLY SETTLEMENT 12-31-24
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
AVG POSITIVE LEDGER BALANCE $ .00 AVAIL BAL FOR EARNINGS CREDIT $ .00
__________________ EARNINGS ON AVAILABLE BALANCE .00
LESS TOTAL SERVICE CHARGES 650.93
AVG LEDGER BALANCE .00 __________________
LESS AVG FLOAT .00
__________________ DEFICIT 650.93
AVG COLLECTED BALANCE .00 __________________
__________________ PERIOD TO DATE DEFICIT 650.93
AVG POSITIVE COLL BALANCE .00 __________________
AVAIL BAL FOR EARNINGS CREDIT .00
AVAILABLE BALANCE REQUIRED 749,773.02
NET AVAILABLE BALANCE 749,773.02-
REQ RESERVES ON NET AVAIL BAL .00
DEFICIT COLLECTED BALANCE 749,773.02
ACCOUNT MAINTENANCE 1 27.0000 27.00 31,099.93
ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 24,188.82
ZBA PER TRANSACTION 1 .0200 .02 23.03
RETURNS-RECLEAR SERVICES 1 .2000 .20 230.37
DEBITS POSTED-ELECTRONIC 32 .1600 5.12 5,897.47
GENERAL DISB CKS PAID-IMAGE 249 .1700 42.33 48,757.76
ACH REPORTS-ELECTRONIC 7 2.0000 14.00 16,125.89
ACH MONTHLY MAINTENANCE 1 35.0000 35.00 40,314.71
ACH BLOCKS AUTH INSTRUCTIONS 8 1.0000 8.00 9,214.79
ACH OFF US CREDITS 20 .1000 2.00 2,303.70
ACH ON US CREDITS-SAME DAY 6 .1000 .60 691.11
ACH OFF US CREDITS-SAME DAY 21 .5000 10.50 12,094.41
ACH DEBIT RECEIVED ITEM 38 .0200 .76 875.41
ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 46,073.95
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8611 01 0048 4089 8611
BANK AND COST CENTER NUMBER 075 0001166 075
OPERATING ACCOUNT MONTHLY SETTLEMENT 12-31-24
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
ARP PARTIAL PPAY MAINTENANCE 1 65.0000 65.00 74,870.18
ARP PARTIAL PPAY ITEM 249 .0400 9.96 11,472.41
PAYEE POSITIVE PAY ISSUE MATCH 277 .0200 5.54 6,381.24
PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,151.85
EDI SERVICES
PAYMODE CON MTHLY LICENSE 1 100.0000 100.00 115,184.90
PAYMODE CON TRANSACTION 2,566 .1000 256.60 295,564.44
IMAGE ARCHIVE 249 .0253 6.30 7,256.65
TOTAL SERVICE CHARGES 650.93 749,773.02
P.O. BOX 15284
WILMINGTON DE 19850
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629
BANK AND COST CENTER NUMBER 075 0001166 075
DATE PREPARED 01-06-25
CITY OF COOPER CITY MONTH ENDING 12-31-24
PAYROLL ACCOUNT MONTHLY SETTLEMENT 12-31-24
9090 SW 50TH PL SETTLEMENT & ACCOUNT TYPE GROUPED 507
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
AVG POSITIVE LEDGER BALANCE $ .00 AVAIL BAL FOR EARNINGS CREDIT $ .00
__________________ EARNINGS ON AVAILABLE BALANCE .00
LESS TOTAL SERVICE CHARGES 172.20
AVG LEDGER BALANCE .00 __________________
LESS AVG FLOAT .00
__________________ DEFICIT 172.20
AVG COLLECTED BALANCE .00 __________________
AVG NEGATIVE COLL BALANCE .00
__________________ PERIOD TO DATE DEFICIT 172.20
AVG POSITIVE COLL BALANCE .00 __________________
LESS RESERVES 00% .00 __________________
AVAIL BAL FOR EARNINGS CREDIT .00
AVAILABLE BALANCE REQUIRED 198,348.38
NET AVAILABLE BALANCE 198,348.38-
REQ RESERVES ON NET AVAIL BAL .00
DEFICIT COLLECTED BALANCE 198,348.38
ACCOUNT MAINTENANCE 1 27.0000 27.00 31,099.93
ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 24,188.82
RETURNS-RECLEAR SERVICES 1 .2000 .20 230.36
GENERAL ACH SERVICES
ACH MONTHLY MAINTENANCE 1 35.0000 35.00 40,314.72
ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,151.85
ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 25,340.67
ACCOUNT RECONCILIATION
ARP PARTIAL PPAY MAINTENANCE 1 65.0000 65.00 74,870.18
PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,151.85
CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00
P.O. BOX 15284
WILMINGTON DE 19850
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629
BANK AND COST CENTER NUMBER 075 0001166 075
DATE PREPARED 01-06-25
CITY OF COOPER CITY MONTH ENDING 12-31-24
PAYROLL ACCOUNT MONTHLY SETTLEMENT 12-31-24
9090 SW 50TH PL SETTLEMENT & ACCOUNT TYPE GROUPED 507
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
TOTAL SERVICE CHARGES 172.20 198,348.38
File details come from the government source that posted it. Updated .