Information:
5,000-10,000- .05%
10,000-20,000-.575%
20,000-50,000-1.0%
50,000-100,000-1.5%
100,000-200,000-1.75%
200,000-500,000-2.0%
above 500,000-2.5%

june 30 balance 6000
july 7 deposit 12000
july16 deposit 6000
july 16 withdraw 2000
july 18 deposit 100000
july 18 withdraw 47000
july 25 deposit 300000
july 25 withdraw 95000
july 29 deposit 720000

pls.. help me compute the tiered interest with the given information..
also i need the formula for the computation in excel thanks!!!!