Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to equalise loans by ditributing funds
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loans aren't always an even number of years | Excel Discussion (Misc queries) |