Excel/Google Sheet Calculating App

Hello,

I would like to have an automated sheet that is calculation deposit values, profit/loss values, portfolio value, ..

2 people A and B, deposited 200€ each in September, total will be 400€.
They both possess 50% of the portfolio value.

If the portfolio value doubles up to 800€, the profit will be 200€ each as a distributed profit based on percentages in investment.

Another person C is joining A and B in October and made a deposit of 200€.
Now the new portfolio value is 1000€.

At that moment

A will get 40% -> 400€
B will get 40% -> 400€
And C will get 20% -> his 200€

The portfolio value will be changed manually, so does the deposit value each month. The rest should be automated.

Also, there should be an withdraw table to re-calculate the values/percentages if someone is withdrawing it.