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 is a Net Earnings Chart exhibit for a banking services Request for Proposals (RFP #25-P-131TF) issued by Volusia County, Florida, covering the County and four Constitutional Officer entities: the Property Appraiser, Supervisor of Elections, and Tax Collector. The exhibit establishes estimated average monthly balances and required interest rate submissions across four separate charts, one for each entity. Bidders must complete two sections for each entity: Section A requesting annual rates at contract start (including interest rates, earnings credit rates, or overnight investment process rates), and Section B requesting guaranteed minimum and maximum rates. The form requires disclosure of variable rate calculation methodologies where applicable and specifically mandates that FDIC Recoupment Fees or similar balance-based fees be reported only on this exhibit and not duplicated on other pricing exhibits. The estimated average monthly balances are $7,800,000 for the County, $4,800,000 for the Property Appraiser, $1,800,000 for the Supervisor of Elections, and $9,100,000 for the Tax Collector, totaling $23,500,000 across all entities. The form requires electronic submission of information in Excel format and requests confirmation that the firm agrees to hold FDIC recoupment fee pricing for the contract term.

The exhibit serves as the mechanism for capturing interest earnings and fee information that must align with responses provided in other contract exhibits, specifically noting that net annual earnings information should correspond with Section III responses regarding interest, overnight sweep, and earnings credit submissions. Currently, all rate fields are populated with zero percentages and zero annual amounts, representing template baseline figures rather than actual bid submissions. The form emphasizes that all amounts are estimated and do not constitute guaranteed minimums or maximums, placing the responsibility on bidding banks to propose competitive rates and fee structures while maintaining transparent reporting of any variable rate methodologies employed during the contract term.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services.pdf PDF
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.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
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
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 .