If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
maintaining constant percentage
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares.
--- frmsrcurl: http://msgroups.net/microsoft.public...heet.functions |
#2
|
|||
|
|||
maintaining constant percentage
Try thinking backwards, If company 1 has 90% of the shares and company 2 has
10%. Then all you do is divide 1000 by 90 and then multiply by 10 =111.11 Or just to make life easier divide 1000 by 9. If company 3 buys shares then all you do is add the shares of company 1 and company 3 and divide by 9 that gives company 2 10% of the total. Regards Steve "SF123" wrote: Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares. --- frmsrcurl: http://msgroups.net/microsoft.public...heet.functions . |
#3
|
|||
|
|||
Quote:
|
Thread Tools | |
Display Modes | |
|
|