A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

maintaining constant percentage



 
 
Thread Tools Display Modes
  #1  
Old June 5th, 2010, 05:43 AM posted to microsoft.public.excel.worksheet.functions
SF123
external usenet poster
 
Posts: 1
Default 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  
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
.

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




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.