maintaining constant percentage

S

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.
 
S

Steve

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First In First Out Function 3
Percentage of Weight Loss/Gain 4
Two-variable Data Table - Problem with result/output 1
Calculating percentage growth rate from a cumulative figure 4
Formula for summing purchases and sales 8
Finding the weighted average of text that have been given values 1
Percentage of Multiple Rows 2
Net Buys/Sells Conundrum: Very Small Nets Sometimes 2

Top