Waterfall allocation in excel

D5:D5 indicates how much money is available for any required financing.  D7:D16 indicates debts that qualify under the financing - that require financing.  D18:D27 indicates how the above loan was allocated going from top to bottom in range.  For example D18 would be 18 because there is 140 available, Then D19 would be 140 - 37 used, and on for this column.  There are many columns, so a good formula would be great.  
Thanks, JP.

Waterfall-allocation.xls
SSS.jpg
easycapitalAsked:
Who is Participating?
 
TracyVBA DeveloperCommented:
Yeah, this looks right.
0
 
easycapitalAuthor Commented:
I think I got it.  Can any one vouch?

Thanks,
JP
Waterfall-allocation-ANS.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.