Laserfiche WebLink
Proposed Analysis Statement <br />City of Ramsey RFP <br />T1r►' ST^ <br />Prepared October 2012 <br />Balance and Compensation Information - Balance information is estimated. Our knowledge of the average deposits is around $3MM <br />For purposes of this proposal we assumed $2MM In the operating account and $1MM would be in a Savings Account © .05% <br />Average Daily Ledger Balance <br />Less Average Daily Float <br />Average Daily Collected Balance <br />Less Legal Reserve Requirement (10%) <br />Balance Available for Earnings Credit <br />Analyzed Position <br />Earnings on Available Balances <br />Less Total Monthly Service Charges <br />Analyzed Charges Due After Earnings Credit <br />Balance Shortage for the Current Period <br />Net Additional Recommended Service Charges <br />Analyzed Charges Due After Earnings Credit as Recommended <br />Service Charge Detail <br />Sweep Services <br />Investment Sweep (Investment Rate of .05%) <br />Subtotal <br />TOTAL SERVICE CHARGES <br />Additional Recommended Services <br />Electronic Deposit Service <br />EDS Monthly Maintenance - Customer Level <br />Electronic Deposit <br />EDS Items <br />Scanner Purchase <br />One Time set up fee <br />Fees Eliminated by Implementing Service <br />Deposits Processed <br />Checks Deposited -On US <br />Checks Deposited - Not on us <br />Subtotal <br />Image Clearing Service <br />Monthly Maitenance <br />Electronic Deposit <br />ICS Items (Average for last 6 months provided from Denelle) <br />One Time set up and testing fee <br />Subtotal <br />Stand Alone Positive Pay <br />Positive Pay Monthly Maintenance <br />Positive Pay Issue Input - Per Item <br />Positive Pay Exception Item with Image <br />Positive Pay Exception Return <br />Subtotal <br />ACH Block/Filter/ ACH Positive Pay Services <br />ACH Positive Pay Company Set Up <br />ACH Positive Pay Monthly Maitenance <br />ACH Block/ Filter per Account (1-5 Accounts) <br />ACH Debit Filter - Recurring <br />ACH Debit Filter Maintenance (one time) <br />Subtotal <br />Volume <br />0 <br />ECR <br />0.46% <br />Fee Basis <br />$666.25 <br />$616.72 <br />-$49.53 <br />$276.10 <br />$226.57 <br />Unit Price Charge <br />150.000 <br />0.00 <br />0.00 <br />$616.72 <br />1 40.000 40.00 <br />20 0.400 8.00 <br />200 0.060 12.00 <br />1 $400-$1200 One Time <br />1 100.000 One Time <br />0 <br />20 -0.500 <br />O -0.080 <br />200 -0.120 <br />$2,000,000.00 <br />$100,000.00 <br />$1,900,000.00 <br />$190, 000.00 <br />$1,710,000.00 <br />Balance Basis <br />$1,710,000.00 <br />$1,758,762.04 <br />-$48,762.04 <br />$787,381.95 <br />$646,143.99 <br />Compensating <br />Balance <br />0.00 <br />0.00 <br />1,758,762.04 <br />114,072.00 <br />22,814.40 <br />34,221.60 <br />(10.00) (28,518.00) <br />0.00 0.00 <br />(24.00) ,/t (68,443.20) <br />26.00 C'J 74,146.80 <br />1 40.000 40.00 114, 072.00 <br />20 0.400 8.00 22,814.40 <br />2,035 0.060 122.10 48,204.77 <br />1 100.000 One Time i <br />170.10 _ t 485,091.16 <br />1 30.000 <br />250 0.100 <br />O 1.250 <br />O 5.000 <br />$30.00 85,554.00 <br />$25.00 71,295.00 <br />$0.00 0.00 <br />$0.00 /jam 0.00 <br />$55.00 156,848.99 <br />1 25.000 One Time <br />1 20.000 $20.00 <br />1 5.000 $5.00 <br />0 1.000 $0.00 <br />0 2.500 $0.00 <br />$25.00 <br />57,036.00 <br />14,259.00 <br />0.00 <br />0.00 <br />14,259.00 <br />Bank of the West Confidential Page 2 <br />