I Want to make a formula using following :
No of Days Total amount Loan Deduction Cumulative balance
30 4000 5000 -1000
This -1000 is then given to employee from pool of investment .
if it goes on 60 days
The balance in cumulative should be zero
and in pool of investment the amount before credited should be debited again i.e 1000
No of Days Total amount Loan Deduction Cumulative balance
30 4000 5000 -1000
This -1000 is then given to employee from pool of investment .
if it goes on 60 days
The balance in cumulative should be zero
and in pool of investment the amount before credited should be debited again i.e 1000