K
Kobus
I have three loan accounts (A, B & C) that need to be paid back but
only a limited amount of money is available. The target is to first pay
the highest loan, then the second lowest to get closer to the target of
equal loans. How do one accomplish this in Excel without VBA
programming. The formulas should be as simple as possible.
Blow are some example calculations:
A B C Totals
600 800 200 1 600 Loan amounts (given)
150 350 - 500 Amounts to be distributed (250 is available for
distribution)
450 450 200 1 100 Equalise balance without negative
distributions
A B C Totals
600 800 200 1 600 Loan amounts (given)
- 200 - 200 Amounts to be distributed (250 is available for
distribution)
600 600 200 1 400 Equalise balance without negative
distributions
A B C Totals
600 800 200 1 600 Loan amounts (given)
433 633 33 1 100 Amounts to be distributed (250 is available
for distribution)
167 167 167 500 Equalise balance without negative distributions
only a limited amount of money is available. The target is to first pay
the highest loan, then the second lowest to get closer to the target of
equal loans. How do one accomplish this in Excel without VBA
programming. The formulas should be as simple as possible.
Blow are some example calculations:
A B C Totals
600 800 200 1 600 Loan amounts (given)
150 350 - 500 Amounts to be distributed (250 is available for
distribution)
450 450 200 1 100 Equalise balance without negative
distributions
A B C Totals
600 800 200 1 600 Loan amounts (given)
- 200 - 200 Amounts to be distributed (250 is available for
distribution)
600 600 200 1 400 Equalise balance without negative
distributions
A B C Totals
600 800 200 1 600 Loan amounts (given)
433 633 33 1 100 Amounts to be distributed (250 is available
for distribution)
167 167 167 500 Equalise balance without negative distributions