To get the exact count of Debits and also the Date of the Balance in the Savings Acct

[e4excel]

I need to know how many debits can take place in my Savings Account if I provide the Current Balance and the No of Debits,Amount of Debits,Frequency of Each Debit.

Lets say, I have Rs 42978/- in my savings account at this moment and I have 2 different Debits taking place on different dates of the Month.
First Debit of Rs 750/- (12th of Month)
Second Debit of Rs 584/- ( 27th of Month)

I am also planning to add one more debit EMI (Equated Onthly Installments)for Rs 1127/- every month.
I need to know the No of Months I can go without paying my Savings Account as well as the Month and the year.

I have tried doing it the regular way but it becomes quite cumbersome, I am looking for help in terms of a better design or a Template as some single-cell (hopefully) formula which can incorporate the number of Debits,Amounts etc.

One very important thing is to also keep a track of the Balance not going below an "X" amount and that is Rs 1500/- as thats the Bank's Minimum Balance requirement..


The no of Installments are as mentioned below:
Debit--- Amount--- Start Month--- No of Installments

I Debit--- 750--- Jan-09--- 36
II Debit--- 584--- Feb-09--- 27
III Debit--- 1127--- Mar-09--- 60