Hi, new to this forum and in need of some help. I am looking for a formula that will calculate variable interest based on an amount. It is a savings calculator. Here are the parameters:

Interest is calculated daily but added once a month (simple interest)
Interest rates are APY :
Balances of
0 - 999 = .2%
1000 - 4999 = .25%
5000 - 9999 = .3%
10,000 - 24,999 = .35
25,000 + = .4%

I plan on adding a deposit 2x a month (1st and 15th) in the amount of $300.

Please help me with a formula that will calculate the end of month balance for each month.

Thanks for any help you experts can provide.