Increased percentage question

[Brian]

I am trying to determine how to go about generating a formmula for Excel
which will assit in working out a percentage increase.

The scenario is as follows:

An amount of $100 000 is to be distributed between 6 individuals at the rate
of 15% each. Another individual is to receive 10% of the $100 000. One of the
6 individuals has withdrawn from the scheme and their 15% share is now to be
distributed between the remainder of the individuals in proportion to the
share that they would receive. For example each individual who is entitled to
15% would get a proportionately greater share then the one who is entitled to
10%.


In essence I have a situtation where 85% of the available funds can be
distributed as planned and I now need to determine the additional percentage
that each individual will receive (based on whether they were to get 10% or
15%) due to the withdrawal of one party. What I need is a formula in which I
can substitute the money values and percentage values as required on a case
by case basis.

Any help would be greatly appreciated.

 

[Gary''s Student]

Apply the same percentage. For example:
in A1 thru A6 enter 15
In A7 enter 10


Since one person is removed, in B1 enter 0
In B2 enter: =(A2/SUM(A$2:A$7))*100 and copy down thru B7

What we see is:

15 0
15 17.64705882
15 17.64705882
15 17.64705882
15 17.64705882
15 17.64705882
10 11.76470588

So the people the previously received 15% now receive 17.647%.
The person who previously received 10% now receives 11.7647%

Note that this procedure will work for any arbitrary initial distribution.

Have a good day!

 

[Brian]

Thanks Gary that makes sense now.

 

[Gary''s Student]

You are quite welcome!