Oh yea, one other thing just to clarify. If one of the partners drops out the
others will need to add to their contribution proportionately to make up the
difference. The total price needs to be $386,450.
--
Thank you for your help.
Bill Booth


"Bill Booth" wrote:

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