Re: Percentage of Ownership Formula
- From: Glenn <address@xxxxxxxxx>
- Date: Thu, 07 Aug 2008 11:08:44 -0500
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.
The cost per share of the new business is $386,450/n with n being the number of shares. Put $386,450 in cell A1 and the following in B1 and C1, copying down as far as necessary:
B1=ROW()
C1=$A$1/ROW()
.
- References:
- Percentage of Ownership Formula
- From: Bill Booth
- Percentage of Ownership Formula
- Prev by Date: Automatic Selection of Multiple Rows
- Next by Date: Re: Difficult Formula
- Previous by thread: Percentage of Ownership Formula
- Next by thread: Automatic Selection of Multiple Rows
- Index(es):
Relevant Pages
|
