Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Distribution of capital contribution
Lets say there are 10 investors, all contributing a different $ amount. It
is pretty simple to figure out what each individuals percentage is, however there is always a fly in the ointment. Distribution is as follows / investor/amount/% (rounded) a 400 22.73 b 40 2.27 c 35 1.99 d 100 5.68 e 25 1.42 f 50 2.84 g 10 0.57 h 400 22.73 I 400 22.73 j 300 17.05 Total = 1760 The FLY part: investor "a" gets a 15% added share increase because he has the total loan in his name. The remaining 9 (b:j) have to share their % to give "a" that increase. Question, do you just increase "a" $ investment by +15% and reduce all others by - 15% to get the resulting % distribution OR do you just add 15% to "a" and reduce the remaining investors percentage by 15%? OR??? Tx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pension contribution | Excel Programming | |||
Percent Contribution | Excel Discussion (Misc queries) | |||
How to calculate pension contribution on salary? | Excel Discussion (Misc queries) | |||
Code Contribution | Excel Programming | |||
Question AND my 1st positive contribution | Excel Programming |