Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increased percentage question
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. -- Confused Law Student |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increased percentage question
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! -- Gary''s Student - gsnu200852 "Brian" wrote: 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. -- Confused Law Student |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increased percentage question
Thanks Gary that makes sense now.
-- Confused Law Student "Gary''s Student" wrote: 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! -- Gary''s Student - gsnu200852 "Brian" wrote: 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. -- Confused Law Student |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increased percentage question
You are quite welcome!
-- Gary''s Student - gsnu200852 "Brian" wrote: Thanks Gary that makes sense now. -- Confused Law Student "Gary''s Student" wrote: 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! -- Gary''s Student - gsnu200852 "Brian" wrote: 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. -- Confused Law Student |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage - How silly I feel asking this question !!! | Excel Discussion (Misc queries) | |||
Sales comparison percentage question | Excel Discussion (Misc queries) | |||
percentage question | Excel Discussion (Misc queries) | |||
Extract data that has increased by a percentage | Excel Discussion (Misc queries) | |||
Percentage Question | Excel Discussion (Misc queries) |