excel chart and formula

Hi,

I need someone to help me set up an excel chart with formulas.
I have an investor who invests in my company we use his money for buying certain items and split the profit 50-50.
I need a chart to show me the status of his money + the profit made on the sold items (which he leaves in the company) and to know as well where is his money still invested (which items and the amount).
We will also need a column of his withdrawals as well.
I know this is a lot of work but could somebody help me please.