View Single Post
  #3  
Old February 5th, 2011, 12:01 AM
Azrael Azrael is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2005
Location: New York
Posts: 10
Default

Quote:
Originally Posted by SF123 View Post
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
It doesn't matter what company 3 does, as long as company 1 doesn't issue any new shares, or they don't sell any then their initial purchase of 10% of the shares will remain the same.