View Single Post
  #2  
Old June 6th, 2010, 04:41 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default 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
.