Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx

XLSX spreadsheet 44 KB Posted

Attached to
Banking Services
Solicitation number
25-P-131TF
Issued by
Volusia County, Florida

About this file

This document is an Excel spreadsheet (Exhibit B.2) detailing net earnings charts for the County of Volusia, Florida, specifically for four different county offices: County, Property Appraiser, Supervisor of Elections, and Tax Collector. The document is part of a comprehensive banking services Request for Proposals (RFP) seeking a full-service banking relationship that covers multiple specialized accounts for county operations and constitutional officer accounts.

The net earnings charts outline estimated average monthly balances for each office, with placeholders for interest rates, earnings credit rates, and FDIC recoupment fees. For each office, the estimated monthly balances range from $1.8 million (Supervisor of Elections) to $9.1 million (Tax Collector), with the County itself maintaining an estimated average monthly balance of $7.8 million. The charts are designed for bidders to provide their proposed rates at contract start and guaranteed minimum/maximum rates, though in this document the rates are currently set to 0.0000%. The document is part of a broader RFP that emphasizes technological requirements, secure banking services, efficient payment processing, and innovative banking solutions for government operations.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services_(Addendum_#6_Revision).pdf PDF
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
Show 40 more

50 files listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

B.2.1 County

Exhibit B.2.1 County - Net Earnings Chart
Listed below is the estimated average monthly balance the County expects to maintain in the all accounts. Amount is estimated and is not a guaranteed minimum or maximum. Please enter the annual rates in both Section A (Rates at Contract Start) and Section B (Guaranteed Mininmum / Guaranteed Maximum Rates). Use of this form is required and amounts are to be placed on this form. Additionally, the Bank is e requested to provide the information below electronically (preferably in Excel) to the County.

Please make sure the FDIC Recoupment Fee or Similar Balance Based Fee is not duplicated here and on Exhibit B.1. It should only be included on this exhibit, Exhibit B.2, Net Annual Earnings

Information presented on this form should agree to the response on Section III. Interest, Overnight Sweep, and Earnings Credit.

Section Item Est. Avg. Monthly Balance Annual Rate Monthly Rate Annual Amount

Section A
Rate at

Contract Start Interest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (1) 7,800,000 0.0000% 0.0000% - 0

Less: FDIC Recoupment Fee or Similar Balance Based Fee (2)7,800,0000.0000%0.0000%- 0
Starting Net Annual Earnings- 0
(1) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
(2) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
Est. Avg. Mnthly BalanceAnnual RateMonthly RateAnnual Amount
Section B
Guaranteed MinimumInterest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (3)7,800,0000.0000%0.0000%- 0
Guaranteed MaximumLess: FDIC Recoupment Fee or Similar Balance Based Fee (4)7,800,0000.0000%0.0000%- 0
Minimum Net Annual Earnings- 0
(3) Enter the rate that would be the guaranteed minimum floor for the applicable rate. If rate has no guaranteed minimum, enter a zero (0) for rate.
(4) Enter the rate that would be the guaranteed maximum ceiling for this fee during the term of the contract. If rate has guaranteed maximum, enter N/A for rate.

The firm agrees to hold the FDIC recoupment fee price for the term of the Agreement. YES NO

&12 &"Arial,Bold"EXHIBIT B

PRICES AND SERVICES CHART

25-P-131TF Exhibit B.2 - Net Earnings Chart

&8&Z&F &"Times New Roman,Italic"Page &P of &N

B.2.2 PA

Exhibit B.2.2 Property Appraiser - Net Earnings Chart
Listed below is the estimated average monthly balance the Property Appraiser expects to maintain in the all accounts. Amount is estimated and is not a guaranteed minimum or maximum. Please enter the annual rates in both Section A (Rates at Contract Start) and Section B (Guaranteed Mininmum / Guaranteed Maximum Rates). Use of this form is required and amounts are to be placed on this form. Additionally, the Bank is requested to provide the information below electronically (preferably in Excel) as part of this RFP.

Please make sure the FDIC Recoupment Fee or Similar Balance Based Fee is not duplicated here and on Exhibit B.1. It should only be included on this exhibit, Exhibit B.2, Net Annual Earnings

Information presented on this form should agree to the response on Exhibit A.1 Section III. Interest, Overnight Sweep, and Earnings Credit.

Section Item Est. Avg. Monthly Balance Annual Rate Monthly Rate Annual Amount

Section A
Rate at

Contract Start Interest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (1) 4,800,000 0.0000% 0.0000% - 0

Less: FDIC Recoupment Fee or Similar Balance Based Fee (2)4,800,0000.0000%0.0000%- 0
Starting Net Annual Earnings- 0
(1) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
(2) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
Est. Avg. Mnthly BalanceAnnual RateMonthly RateAnnual Amount
Section B
Guaranteed MinimumInterest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (3)4,800,0000.0000%0.0000%- 0
Guaranteed MaximumLess: FDIC Recoupment Fee or Similar Balance Based Fee (4)4,800,0000.0000%0.0000%- 0
Minimum Net Annual Earnings- 0
(3) Enter the rate that would be the guaranteed minimum floor for the applicable rate. If rate has no guaranteed minimum, enter a zero (0) for rate.
(4) Enter the rate that would be the guaranteed maximum ceiling for this fee during the term of the contract. If rate has guaranteed maximum, enter N/A for rate.

The firm agrees to hold the FDIC recoupment fee price for the term of the Agreement. YES NO

25-P-131TF Exhibit B.2 - Net Earnings Chart

B.2.3 SOE

Exhibit B.2.3 Supervisor of Elections - Net Earnings Chart
Listed below is the estimated average monthly balance the Supervisor of Elections expects to maintain in the all accounts. Amount is estimated and is not a guaranteed minimum or maximum. Please enter the annual rates in both Section A (Rates at Contract Start) and Section B (Guaranteed Mininmum / Guaranteed Maximum Rates). Use of this form is required and amounts are to be placed on this form. Additionally, the Bank is requested to provide the information below electronically (preferably in Excel) to the County.

Please make sure the FDIC Recoupment Fee or Similar Balance Based Fee is not duplicated here and on Exhibit B.1. It should only be included on this exhibit, Exhibit B.2, Net Annual Earnings

Information presented on this form should agree to the response on Exhibit A.1 Section III. Interest, Overnight Sweep, and Earnings Credit.

Section Item Est. Avg. Monthly Balance Annual Rate Monthly Rate Annual Amount

Section A
Rate at

Contract Start Interest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (1) 1,800,000 0.0000% 0.0000% - 0

Less: FDIC Recoupment Fee or Similar Balance Based Fee (2)1,800,0000.0000%0.0000%- 0
Starting Net Annual Earnings- 0
(1) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
(2) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
Est. Avg. Mnthly BalanceAnnual RateMonthly RateAnnual Amount
Section B
Guaranteed MinimumInterest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (3)1,800,0000.0000%0.0000%- 0
Guaranteed MaximumLess: FDIC Recoupment Fee or Similar Balance Based Fee (4)1,800,0000.0000%0.0000%- 0
Minimum Net Annual Earnings- 0
(3) Enter the rate that would be the guaranteed minimum floor for the applicable rate. If rate has no guaranteed minimum, enter a zero (0) for rate.
(4) Enter the rate that would be the guaranteed maximum ceiling for this fee during the term of the contract. If rate has guaranteed maximum, enter N/A for rate.

The firm agrees to hold the FDIC recoupment fee price for the term of the Agreement. YES NO

25-P-131TF Exhibit B.2 - Net Earnings Chart

B.2.4 TC

Exhibit B.2.4 Tax Collector - Net Earnings Chart
Listed below is the estimated average monthly balance the Tax Collector expects to maintain in the all accounts. Amount is estimated and is not a guaranteed minimum or maximum. Please enter the annual rates in both Section A (Rates at Contract Start) and Section B (Guaranteed Mininmum / Guaranteed Maximum Rates). Use of this form is required and amounts are to be placed on this form. Additionally, the Bank is requested to provide the information below electronically (preferably in Excel) to the County.

Please make sure the FDIC Recoupment Fee or Similar Balance Based Fee is not duplicated here and on Exhibit B.1. It should only be included on this exhibit, Exhibit B.2, Net Annual Earnings

Information presented on this form should agree to the response on Exhibit A.1 Section III. Interest, Overnight Sweep, and Earnings Credit.

Section Item Est. Avg. Monthly Balance Annual Rate Monthly Rate Annual Amount

Section A
Rate at

Contract Start Interest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (1) 9,100,000 0.0000% 0.0000% - 0

Less: FDIC Recoupment Fee or Similar Balance Based Fee (2)9,100,0000.0000%0.0000%- 0
Starting Net Annual Earnings- 0
(1) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
(2) If rate is variable, disclose method of calculation below, and enter today's rate using this methodlogy.
Variable Rate Calculation Method:
Est. Avg. Mnthly BalanceAnnual RateMonthly RateAnnual Amount
Section B
Guaranteed MinimumInterest Rate, Earnings Credit Rate or Earnings Through Overnight Investment Process (3)9,100,0000.0000%0.0000%- 0
Guaranteed MaximumLess: FDIC Recoupment Fee or Similar Balance Based Fee (4)9,100,0000.0000%0.0000%- 0
Minimum Net Annual Earnings- 0
(3) Enter the rate that would be the guaranteed minimum floor for the applicable rate. If rate has no guaranteed minimum, enter a zero (0) for rate.
(4) Enter the rate that would be the guaranteed maximum ceiling for this fee during the term of the contract. If rate has guaranteed maximum, enter N/A for rate.

The firm agrees to hold the FDIC recoupment fee price for the term of the Agreement. YES NO

25-P-131TF Exhibit B.2 - Net Earnings Chart

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