Laserfiche WebLink
Proposed Analysis Statement <br />City of Ramsey RFP <br />KOF <br />TE <br />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 />Miscellaneous Services <br />Checks Paid <br />Deposits Processed <br />Branch Currency Deposited <br />Returned Items (Checks) <br />Interest on Uncollected Funds <br />Deposit Administration Fee <br />Monthly Account Maintenance <br />On Us Check Deposited <br />Not on Us Check Deposited <br />Incoming ACH Credits & Debits <br />Subtotal <br />Information Reporting Services <br />WebDirect Mid -Market Pkg (1-5 Accounts) <br />Additional Accounts <br />Previous Day Information Reporting (1-500 Items) <br />Current Day Information Reporting (1-500 Items) <br />Current Day/Previous Information Reporting (501 - 1000 Items) <br />Account Transfers <br />Stop Payment 6 Month <br />Stop Payment 12 Month <br />Deposit Statements via WebDirect <br />Analysis Statements via WebDirect <br />One Time Set Up Fee <br />Subtotal <br />WebDirect ACH Transfer <br />WebDirect ACH Transfer Base Fee <br />WebDirect ACH Items (item includes utility payment averages) <br />ACH Returned Item <br />ACH Special Reports (Return / NOC) <br />Subtotal <br />WebDirect Money Transfer <br />Incoming Wires <br />WebDirect Wire Transfer Base Fee <br />Book Transfer (Wire to another BOTW Account) <br />Domestic Wire Trasnfer <br />International Wires <br />Subtotal <br />$2,000,000.00 <br />$100,000.00 <br />$1,900,000.00 <br />$190,000.00 <br />$1,710,000.00 <br />ECR Fee Basis Balance Basis <br />0.46% $666.25 $1,710,000.00 <br />$616.72 $1,758,762.04 <br />-$49.53 <br />$276.10 <br />$226.57 <br />Volume Unit Price Charge <br />250 <br />20 <br />0 <br />1 <br />0 <br />2,000 <br />1 <br />0 <br />200 <br />20 <br />1 <br />0 <br />500 <br />500 <br />0 <br />0 <br />0 <br />0 <br />1 <br />1 <br />0 <br />1 <br />516 <br />1.67 <br />1.67 <br />5 <br />1 <br />0 <br />5 <br />0 <br />0.120 <br />0.500 <br />0.0009 <br />7.5000 <br />0.0725 <br />0.1500 <br />10.000 <br />0.080 <br />0.120 <br />0.0800 <br />40.000 <br />10.000 <br />0.000 <br />0.000 <br />0.100 <br />1.000 <br />8.000 <br />16.000 <br />1.000 <br />1.000 <br />100.000 <br />20.000 <br />0.100 <br />5.000 <br />1.000 <br />9.000 <br />20.000 <br />7.000 <br />9.000 <br />15.000 <br />$30.00 <br />$10.00 <br />$0.00 <br />$7.50 <br />$0.00 <br />$300.00 <br />$10.00 <br />$0.00 <br />$24.00 <br />$1.60 <br />$383.10 <br />$40.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$1.00 <br />$1.00 <br />One Time <br />$42.00 <br />$20.00 <br />$51.60 <br />$8.35 <br />$1.67 <br />$81.62 <br />$45.00 <br />$20.00 <br />$0.00 <br />$45.00 <br />$0.00 <br />$110.00 <br />-$48,762.04 <br />$787,381.95 <br />$646,143.99 <br />Compensating <br />Balance <br />85,554.00 <br />28,518.00 <br />0.00 <br />21,388.50 <br />0.00 <br />855,539.97 <br />28,518.00 <br />0.00 <br />68,443.20 <br />4,562.88 <br />1,092,524.54 <br />114,072.00 <br />0.00 <br />0.00 <br />0.00 <br />0.00 <br />0.00 <br />0.00 <br />0.00 <br />2,851.80 <br />2,851.80 <br />0.00 <br />119,775.60 <br />57,036.00 <br />147,152.88 <br />23,812.53 <br />4,762.51 <br />232,763.91 <br />128,331.00 <br />0.00 <br />0.00 <br />128,331.00 <br />0.00 <br />256,661.99 <br />Bank of the West Confidential Page 1 <br />