Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 930
  • Last Modified:

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
0
easycapital
Asked:
easycapital
1 Solution
 
easycapitalAuthor Commented:
I think I got it.  Can any one vouch?

Thanks,
JP
Waterfall-allocation-ANS.xls
0
 
TracyVBA DeveloperCommented:
Yeah, this looks right.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now