RFP2025-2_-_Exhibit_B_-_Jan_2025_Analysis_Statements.pdf
PDF 131 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 analysis statement for the City of Cooper City, Florida's business checking account for the month ending January 31, 2025. The statement reflects the City's current banking relationship and account performance metrics as they relate to the RFP 2025-2 banking services procurement. The account maintained an average positive ledger balance of $36,381,249.41 during the period, with an available balance for earnings credit of $36,309,477.08. The City earned $28,525.32 in earnings credits during the month, which were applied against total service charges of $8,766.05, resulting in an excess allowance of $19,759.27. The current month's earnings credit rate was 0.92%, with a monthly multiple of $1,279.80. Primary service charges included bank assessment fees of $7,719,734.09 based on 36,381,249 units, account maintenance of $27.00, banking center deposits totaling $566.10 (111 transactions at $5.10 per deposit), ZBA depository master maintenance of $41.00, and various transaction-based fees for returns and chargebacks totaling $20.40.
The analysis statement demonstrates the City's substantial account activity and balance levels that would be relevant to any financial institution submitting a proposal under RFP 2025-2. The earnings credit methodology employed by Bank of America illustrates the compensation structure typical for municipal banking services, wherein the City's account balances generate earnings credits that offset service charges rather than requiring direct monetary payments. This statement serves as a baseline reference for the current banking environment and can inform proposing institutions regarding account volume, balance characteristics, and service requirements for the anticipated five-year contract term with optional renewal.
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_B_-_Jan_2025_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_C_-_Feb_2025_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_A_-_Dec_2024_Analysis_Statements.pdf | ||
| RFP2025-2_-_Exhibit_A_-_Dec_2024_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 02-07-25
CITY OF COOPER CITY MONTH ENDING 01-31-25
BUSINESS CHECKING MONTHLY SETTLEMENT 01-31-25
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 $ 36,381,249.41 AVAIL BAL FOR EARNINGS CREDIT $ 36,309,477.08
__________________ EARNINGS ON AVAILABLE BALANCE 28,525.32
LESS TOTAL SERVICE CHARGES 8,766.05
AVG LEDGER BALANCE 36,381,249.41 __________________
LESS AVG FLOAT 71,772.33
__________________ EXCESS ALLOWANCE 19,759.27
AVG COLLECTED BALANCE 36,309,477.08 __________________
AVG NEGATIVE COLL BALANCE .00
__________________ PERIOD TO DATE EXCESS ALLOWANCE 19,759.27
AVG POSITIVE COLL BALANCE 36,309,477.08 __________________
LESS RESERVES 00% .00 __________________
AVAIL BAL FOR EARNINGS CREDIT 36,309,477.08
AVAILABLE BALANCE REQUIRED 11,158,180.47
NET AVAILABLE BALANCE 25,151,296.61
CURRENT MONTH'S EARNINGS CREDIT RATE = 0.92% CURRENT MONTH'S MULTIPLE = $1,279.80
NUMBER OF UNIT SERVICE BALANCE
SERVICE UNITS PRICE CHARGE REQUIRED
BALANCE RELATED SERVICES
DEPOSIT BANK ASSESSMENT 36,381,249 6,064.75 7,719,734.09
DEPOSITORY SERVICES
ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.91
BANKING CENTER DEPOSIT 111 5.1000 566.10 720,580.64
DEPOSIT CORRECTION-NONCASH-RDS 1 5.3000 5.30 6,746.29
ZBA-DEPOSITORY+ MASTER MAINT 1 41.0000 41.00 52,188.32
ZBA PER TRANSACTION 21 .0200 .42 534.61
RETURNS-CHARGEBACK 4 5.1000 20.40 25,966.87
CHECKS DEPOSITED-BKG CENTER 151 .2200 33.22 42,285.27
STOP PAY AUTOMATED<=12 MONTHS 4 15.0000 60.00 76,373.15
DEBITS POSTED-ELECTRONIC 31 .1600 4.96 6,313.51
CREDITS POSTED-ELECTRONIC 234 .1600 37.44 47,656.84
CHECK DEPOSIT-ICL OR RDSO 81 .8000 64.80 82,483.00
IMAGE DEPOSITED ITEMS-RDSO 2,277 .0600 136.62 173,901.66
COMMERCIAL DEPS-CASH VAULT
CURR-COIN DEP-$100-BKG CTR 438 .2200 96.36 122,655.28
GENERAL ACH SERVICES
ACH REPORTS-ELECTRONIC 16 2.0000 32.00 40,732.34
ACH REPORTS-FAX 6 5.0000 30.00 38,186.57
EXHIBIT B
JANUARY 2025 ANALYSIS STATEMENT
FULL ANALYSIS BUSINESS CKG 01 0048 4090 0476 01 0048 4090 0476
BANK AND COST CENTER NUMBER 075 0001166 075
BUSINESS CHECKING MONTHLY SETTLEMENT 01-31-25
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
ACH RETURN ITEM 13 3.5000 45.50 57,916.31
ACH MONTHLY MAINTENANCE 2 35.0000 70.00 89,102.00
ACH INPUT-FILE 8 20.0000 160.00 203,661.73
ACH BLOCKS AUTH INSTRUCTIONS 49 1.0000 49.00 62,371.40
ACH NOTIF OF CHANGE (NOC) 4 3.5000 14.00 17,820.40
ACH ON US DEBITS 2 .1100 .22 280.04
ACH OFF US DEBITS 1,985 .1100 218.35 277,934.61
ACH ON US DEBITS-SAME DAY 677 .1100 74.47 94,791.81
ACH CREDIT RECEIVED ITEM 234 .0100 2.34 2,978.55
ACH DEBIT RECEIVED ITEM 32 .0200 .64 814.65
ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 50,915.43
WIRE TRANSFER
WIRE MONTHLY SUBSCRIPTION 1 38.0000 38.00 48,369.66
PH OR STND ORDER TMPLT STORG 8 .1000 .80 1,018.31
ELEC WIRE OUT-DOMESTIC 10 10.0000 100.00 127,288.58
ELEC WIRE OUT-BOOK DB 3 4.0000 12.00 15,274.63
CASHPRO GP CUST MNT TMPLT STRG 9 .0000 .00 0.00
ACCOUNT RECONCILIATION
POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 54,734.09
INFORMATION SERVICES
CASHPRO ARP REPORTS 2 25.0000 50.00 63,644.29
CASHPRO ONLINE SUBSCRIPTION 1 55.0000 55.00 70,008.72
CASHPRO REPORTING SUBSCRIPTION 1 7.0000 7.00 8,910.20
CASHPRO ONLINE PDR ACCOUNT 4 16.0000 64.00 81,464.69
CASHPRO ONLINE PDR ITEM 1,571 .1000 157.10 199,970.36
CASHPRO ONLINE CDR ACCOUNT 1 16.0000 16.00 20,366.17
CASHPRO ONLINE CDR ITEM 726 .1000 72.60 92,411.51
GCS TRANSACTION HISTORY 1 .0000 .00 0.00
REMOTE DEPOSIT SERVICES
REMOTE DEPOSIT ACCOUNT MAINT 1 225.0000 225.00 286,399.30
REMOTE DEPOSIT CHK IMAGE PROC 2,278 .0100 22.78 28,996.34
REMOTE DEPOSIT FOREIGN ITEM 1 3.0000 3.00 3,818.66
REMOTE DEPOSIT ITEM STORAGE 104,966 .0000 .00 0.00
IMAGE
IMAGE ARCHIVE 193 .0253 4.88 6,211.68
CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00
CASHPRO ONLINE IMAGE RETRIEVAL 18 .0000 .00 0.00
TOTAL SERVICE CHARGES 8,766.05 11,158,180.47
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 01-31-25
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 476.52
LESS TOTAL SERVICE CHARGES 194.11
AVG LEDGER BALANCE 606,560.51 __________________
LESS AVG FLOAT .00
__________________ EXCESS ALLOWANCE 282.41
AVG COLLECTED BALANCE 606,560.51 __________________
__________________ PERIOD TO DATE EXCESS ALLOWANCE 282.41
AVG POSITIVE COLL BALANCE 606,560.51 __________________
AVAIL BAL FOR EARNINGS CREDIT 606,560.51
AVAILABLE BALANCE REQUIRED 247,079.86
NET AVAILABLE BALANCE 359,480.65
BALANCE RELATED SERVICES
DEPOSIT BANK ASSESSMENT 606,560 101.11 128,701.49
ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.91
ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,272.89
ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 28,003.48
POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 54,734.09
TOTAL SERVICE CHARGES 194.11 247,079.86
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 01-31-25
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 646.34
AVG LEDGER BALANCE .00 __________________
__________________ DEFICIT 646.34
AVG COLLECTED BALANCE .00 __________________
__________________ PERIOD TO DATE DEFICIT 646.34
AVG POSITIVE COLL BALANCE .00 __________________
AVAIL BAL FOR EARNINGS CREDIT .00
AVAILABLE BALANCE REQUIRED 822,717.00
NET AVAILABLE BALANCE 822,717.00-
REQ RESERVES ON NET AVAIL BAL .00
DEFICIT COLLECTED BALANCE 822,717.00
ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.92
ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 26,730.60
RETURNS-RECLEAR SERVICES 1 .2000 .20 254.58
DEBITS POSTED-ELECTRONIC 32 .1600 5.12 6,517.18
GENERAL DISB CKS PAID-IMAGE 204 .1700 34.68 44,143.67
ACH REPORTS-ELECTRONIC 6 2.0000 12.00 15,274.63
ACH MONTHLY MAINTENANCE 1 35.0000 35.00 44,551.00
ACH BLOCKS AUTH INSTRUCTIONS 8 1.0000 8.00 10,183.09
ACH OFF US CREDITS 6 .1000 .60 763.73
ACH ON US CREDITS-SAME DAY 11 .1000 1.10 1,400.17
ACH OFF US CREDITS-SAME DAY 35 .5000 17.50 22,275.51
ACH DEBIT RECEIVED ITEM 39 .0200 .78 992.85
ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 50,915.43
POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 82,737.58
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8611 01 0048 4089 8611
BANK AND COST CENTER NUMBER 075 0001166 075
OPERATING ACCOUNT MONTHLY SETTLEMENT 01-31-25
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
POSITIVE PAY ITEMS-PARTIAL 204 .0400 8.16 10,386.75
PAYEE POSITIVE PAY ISSUE MATCH 237 .0200 4.74 6,033.47
PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,272.89
EDI SERVICES
PAYMODE CON MTHLY LICENSE 1 100.0000 100.00 127,288.58
PAYMODE CON TRANSACTION 2,443 .1000 244.30 310,966.00
IMAGE ARCHIVE 204 .0253 5.16 6,568.09
MISCELLANEOUS
PHOTOCOPY-MANUAL 1 15.0000 15.00 19,093.28
TOTAL SERVICE CHARGES 646.34 822,717.00
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629
BANK AND COST CENTER NUMBER 075 0001166 075
PAYROLL ACCOUNT MONTHLY SETTLEMENT 01-31-25
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 __________________
__________________ DEFICIT 172.20
AVG COLLECTED BALANCE .00 __________________
__________________ PERIOD TO DATE DEFICIT 172.20
AVG POSITIVE COLL BALANCE .00 __________________
AVAIL BAL FOR EARNINGS CREDIT .00
AVAILABLE BALANCE REQUIRED 219,190.93
NET AVAILABLE BALANCE 219,190.93-
REQ RESERVES ON NET AVAIL BAL .00
DEFICIT COLLECTED BALANCE 219,190.93
ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.92
ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 26,730.60
RETURNS-RECLEAR SERVICES 1 .2000 .20 254.57
ACH MONTHLY MAINTENANCE 1 35.0000 35.00 44,551.00
ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,272.89
ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 28,003.49
POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 82,737.58
PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,272.88
FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629
BANK AND COST CENTER NUMBER 075 0001166 075
PAYROLL ACCOUNT MONTHLY SETTLEMENT 01-31-25
COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC
TOTAL SERVICE CHARGES 172.20 219,190.93
File details come from the government source that posted it. Updated .