Distributing over 4 People equally - on non equal cases each share will roll over

Hello Everyone!
I have basic skill on excel, I am trying to make a formula in excel with the following case :

So basically I am trying to split multiple contracts into 4 People (N.B They all should have equal splits but some cases they agree not to and the remaining share is reserved for future contract as credit) :
For example a contract of value 1000 USD needs to split into 4 People A,B,C and D : 250, 200,400,150
The equal split for each must be 250 the I need an equation that company C is 60% more than the equal split and individual D is -60 % , Person A and B is 0%
This means for the next contract companies A,B and D should take from individual C so they all can be equal.

For the second contract of 1000 USD for the 4 companies the split value should be 250 USD to make everyone equals the distribution should be for A,B,C and D : 250,300,100,350 and so on unless the distribution is changes manually then it will take a note for the third contract.
Every time we input manually the share for everone then a formula shows what's the balance of each person and note future share for each one based on the next contract.

Please find attached, I need a formula for predicted shares according to the predicted award value based on the previous split.

Thank you so much I really appreciate your work. but I do have couple of concerns to make it better.
The predicted value from Columns O to R should be absolute not minus every split should be in positive or minimum Zero , for example in the last row the predicted award value is 4,000 $ this means each split should be 1,000 $ when adding the current balance this will come up to 1475 $ , 1425 $ , 1125 $ and -25 $ for A,B,C and D respectively the value of -25 should be zero because and the -25 should be subtracted from the remining three people A,B and C this means -25/3 = -8.333333 $ therefore the values should be 1466.67 $, 1416.67 $, 1116.67 $ and zero.

could you please make sure that the sum of columns O to R should equal to S otherwise it will get an error. this also applies to the sum of columns G to J must equal to E.

Many thanks,

Thank you again for your help
I am testing some number in the spread sheet I have realized that some numbers doesn't add right, for example please see attached columns O to R in row 10 must equal to column S in row 10. where the sum predicted of each share must equal to the predicted award value.
in this spread sheet the predicted award value for example if 94500 , where the adds of the predicted share is 106750.

Cheers,
Hashem AS

Thank you so much. this what I needed.

Thank you so much. this what I needed.

sorry for the confusion, the rows 8 to 11 are working well when I have 12 reached row of columns O to R the sum is not the same as S12. in the attached file the sum is 62850 where it should be 59000

Please use this attached file, not the previous.