John C,
Thank you vey much for your help and such a quick response. Your thought was
right on. The Partners will not be equal share holders. I have tried your
formula and am having a problem. Could I ask for a little more help?
Following are the actual percentages that the potential partners want to
contribute.
Purhcase price is $386,450. there are 9 potential partners their
contribution amounts are as follows.
20%
9%
18%
3%
3%
26%
11%
3%
8%

I can not seem to make your formula work
Thanks again
Bill







--
Thank you for your help.
Bill Booth


"John C" wrote:

If you want to get a little fancier, say, for example, some people didn't
want a 'full share' only 50% share, etc. You could do the following:
A1: Purchase Price
B1*: Shares
C1: =IF(OR(A1="",B1=""),"",A1/B1)

Shares is equal to the number of partners you have, however, say you have 6
people that want to be full partnes, and 2 people that wanted to be less than
a full partner, say one is 75%, and one is 50%. Then the subsequent shares
would be equal to 6*1+.75*1+.5*1 = 7.25
A Share price is equal to: $386,450/7.25 = $53,303.45
All full partners would pay the $53,303.45
The 75% partner would pay 75% of 53,303.45 = $39,977.59
The 50% partner would pay 50% of 53,303.45 = $26,651.72

--
John C


"Mike H" wrote:

There are several ways and this is probably the simplest

Put the purchase price in a1
Put this formula in b1
=IF(C1="","",A1/C1)

enter different numbers in c1 to get the amount depending on partners.

Mike

"Bill Booth" wrote:

I am buying a new business with partners. The cost is $386,450. We may have
up to 10 partners, so each would contribute $38,645. I would like to build a
table that allows "what if" scenario. For example if we only get 8 partners
how much do the 8 need to contribute, or 6, 9, 7 and so on. How can I develop
a formula that will allow me add to remove partner contribution levels and
still keeping the total amount $386,450? I would like to do this real time
during a presentation with the partners present.
--
Thank you for your help.
Bill