Percentage based allocation with Excel Sheet (need help)

Greetings ,

since I can't manage a PAMM account without a money manager license in my country I want to open a joint account (me + 1 other person) but I want to setup a PAMM-like allocation so we can identify how much of the money belongs to who of us and I thought about making an excel sheet for it.

I will be the only person trading it but both of us will fund the account. I will get 100% of the profit of my own capital and a 50% share of the profits on his capital , but I'm not sure how to change the percantage shares of each person when losses occur and I don't know how to set up all the formulas in excel in a simple way. Since I'm not very experienced with excel I hope someone in this forum can help me set up a sheet where I can simply put in the current balance (including profits & losses) & deposits / withdrawals on the first day of each month while the sheet automatically calculates the % share of the balance for each person.

I really hope someone can help me set up the sheet or maybe give me a better idea to create a fair allocation method without being able to open a pamm account

Best regards

It isn't very clear what you require but check the attached.

sorry for not being 100% clear but the sheet you made was exactly what I was looking for , thanks a lot mate

Glad I could help