I need a formula for the below question:

[johnshaji]

A private limited Company has 3 share holders , total Capital is 10 M , 1st Party 6 M , 2nd party 2 Mn, 3rd party 2 Mn.
The 1st party decides to bring in 5 M additional capital , This will increase share holding %age to 73% . However 2nd and 3rd party do not wish you dilute their share holding %age , Hence they would also bring additional capital . But how much is the capital required? please note while after all parties brings in their new capital , the each party will have the same % as earlier 1st Party - 60%, 2n Party - 20%, 3rd Party - 20% , Can someone provide me the excel formula for this

 

[hagia_sofia]

Hello, this is more a math question than formula question - as those additional 5M represent 60%, 100% is equal to 5/0.6. If you multiply the result by original shares and add those to original capital you will have the result, i.e. 5/0.6 * 0.6 / 0.2 / 0.2 + 6 / 2 / 2.

 

[petertenthije]

party 1 increases his investment from 6 to 11 million. Six divided by 11 gives 45,45% increase in number one’s investment.

The other parties would have to thus increase their investment by 45,45% as well. So from 2 million to 2.909.090 each for an additional investment of 909.090 each.

 

[johnshaji]

Hello, this is more a math question than formula question - as those additional 5M represent 60%, 100% is equal to 5/0.6. If you multiply the result by original shares and add those to original capital you will have the result, i.e. 5/0.6 * 0.6 / 0.2 / 0.2 + 6 / 2 / 2.

Thanks Sofia, solving it in mathematical way , although I had the end result in , i was put it in the excel formulas, which wasn't working in this case the total would be 18.33 M , let me know any other excel formula you can think of solving this , this is for my academics

 

[johnshaji]

party 1 increases his investment from 6 to 11 million. Six divided by 11 gives 45,45% increase in number one’s investment.

The other parties would have to thus increase their investment by 45,45% as well. So from 2 million to 2.909.090 each for an additional investment of 909.090 each.

additional investment is 1.66 M

 

[hagia_sofia]

If A2:A4 is original capital (6 - 2 - 2) and B2:B4 is additional investment (5 - 0 - 0), then:

=SUM(B2:B4/(A2:A4/SUM(A2:A4)))*A2:A4/SUM(A2:A4)

 

[bebo021999]

If:
cap1 =6.000.000
cap2 = 2.000.000
cap3 = 2.000.000
cap1B = 5.000.000 (added from capital 1)

Should be
=(cap1+cap1B)+(cap1+cap1B)/(cap1/(cap1+cap2+cap3)*(cap2+cap3)/(cap1+cap2+cap3)
shortern:

=(cap1+cap1B)*(1+(cap2+cap3)/cap1)
=(6000000+5000000)*(1+(2000000+2000000)/6000000)
=18,333,333

 

[kvsrinivasamurthy]

C2=5
Formula in C3

=BYROW(B3:B5,LAMBDA(ro,ro*SUM(B2:C2)/B2-ro))

	1st share	2nd share
p1	10	5
p2	6	3
p3	2	1
p4	2	1