Splitting cost (based on percentages)

I'm trying to produce an Excel spreadsheet to split cost with my room mate. I can't figure out the two formulas I need in order to get some totals (see below).
Here's how the data is structured:

Item | Price | Paid By | Percentage (to cover)
Phone | 200.00$ | Marc Marina | 25%
Coffee | 10.00$ | Patrick Lid | 50%
Gas | 20.00$ | Marc Marina | 75%


Firstly, I want to be able to get the total paid by each individual (We are only two by the way).
Based on the data above, I would like to get this:

Marc Marina : 220.00$
Patrick Lid: 10.00$


Secondly, I would also like to be able to know what amount is owed by each individual.
Based on the data above, I would like to get this:

Marc Marina : + 150.00$
Patrick Lid: - 150.00$

Any help would be greatly appreciated.

Hi,

Welcome to the forums .

I don't understand how you get the +$150 and the -$150?

Here is what I have so far.

Thanks

Danny

Ok then. My spreadsheet is pretty close. The decimal places I used should be the other way around basically. I will attach it to this post in a minute .

I know there is ab it more you want but I have to head home. WIll do it when I geti n.

Danny