Quote:
Originally Posted by SF123
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.