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 
Ads 
#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  

