Revise Apportionment on Relative Basis

Not sure how to solve this in Excel. A 20% shareholder is killed by a bus. How to distribute the dead man's shares proportionally according to the surviving two shareholders, one of whom already has 70% and the other 10%? Thanks in advance, J

Title not ideal - I've revised on this occasion.

The resulting apportionment would be along the lines of:

original+new*(original/(total-new))

70%+20%*(70%/80%)

and

10%+20%*(10%/80%)

in the above (total-new) is condensed to 80%

The above will give you the % each person should get of the 20%

The earlier examples give you the final % amounts for each individual (ie their original stake plus their portion of the additional 20%)

Whether or not you need that is unclear from the original post.

DO's formula, rearranged to use number of shares rather than percentages:

Please Login or Register  to view this content.