In the attached I have a series of Cash Flows and corresponding months; some are positive, some negative. I'm trying to distribute positive cash flows when they occur, assuming the negative amounts can be covered in the running total.
For example, columns B and C would assume a distribution each month as they are obviously positive, however, that distribution in column C ($54,422) would need to cover the negative $46,891 to the right; a net effect of $7,531. From there, the running balance would reset at zero and continue in the same manner, only distributing when the cumulative cash flow is positive but never allowing the running balance to fall below zero.
Any help is greatly appreciated.
Bookmarks