LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pension contribution owen.cxy Excel Programming 7 June 26th 09 11:18 AM
Percent Contribution JR573PUTT Excel Discussion (Misc queries) 2 August 17th 06 06:35 PM
How to calculate pension contribution on salary? pgruening Excel Discussion (Misc queries) 4 September 7th 05 09:28 PM
Code Contribution DennisE Excel Programming 5 May 2nd 04 08:43 PM
Question AND my 1st positive contribution rju Excel Programming 1 January 21st 04 05:08 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"