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

The image is a standard Adobe PDF portfolio opening screen with the Adobe PDF logo and instructions recommending users open the document in Acrobat X or Adobe Reader X or later versions. The screen includes a "Get Adobe Reader Now!" button and displays a stylized PDF document icon in red and white colors. The purpose appears to be a technical recommendation for optimal PDF viewing experience.

Since no actual contract details are visible in this image, I cannot provide a substantive summary of the banking services RFP for Cooper City, Florida. The context provided suggests this is an initial loading screen for a PDF portfolio related to a banking services procurement, but the specific document contents are not yet accessible.

View the file

Other files for this state and local contract opportunity

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 0042 8117 3553 01 0042 8117 3553

BANK AND COST CENTER NUMBER 075 0001166 075

DATE PREPARED 01-06-25

CITY OF COOPER CITY MONTH ENDING 12-31-24

DEVELOPMENT IMPACT FEES 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 $ 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 __________________

AVG NEGATIVE COLL BALANCE .00

__________________ PERIOD TO DATE EXCESS ALLOWANCE 332.48

AVG POSITIVE COLL BALANCE 606,560.51 __________________

LESS RESERVES 00% .00 __________________

AVAIL BAL FOR EARNINGS CREDIT 606,560.51

AVAILABLE BALANCE REQUIRED 223,585.39

NET AVAILABLE BALANCE 382,975.12

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 606,560 101.11 116,463.44

DEPOSITORY SERVICES

ACCOUNT MAINTENANCE 1 27.0000 27.00 31,099.92

GENERAL ACH SERVICES

ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,151.85

ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 25,340.68

ACCOUNT RECONCILIATION

ARP PPAY MAINT-NO RECON 1 43.0000 43.00 49,529.50

IMAGE

CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00

TOTAL SERVICE CHARGES 194.11 223,585.39

THIS ACCOUNT IS ANALYZED AT THE GROUP LEVEL.

GROUP NUMBER IS 075 0048 4089 8611.

TWhite

Stamp

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

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

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 __________________

__________________ PERIOD TO DATE EXCESS ALLOWANCE 16,814.30

AVG POSITIVE COLL BALANCE 28,479,921.42 __________________

AVAIL BAL FOR EARNINGS CREDIT 28,479,921.42

AVAILABLE BALANCE REQUIRED 9,112,380.61

NET AVAILABLE BALANCE 19,367,540.81

BALANCE RELATED SERVICES

DEPOSIT BANK ASSESSMENT 28,538,308 4,757.33 5,479,725.51

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

ACH REPORTS-ELECTRONIC 18 2.0000 36.00 41,466.56

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

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 ARCHIVE 169 .0253 4.28 4,929.91

CASHPRO ONLINE IMAGE RETRIEVAL 2 .0000 .00 0.00

TOTAL SERVICE CHARGES 7,911.09 9,112,380.61

File details come from the government source that posted it. Updated .