1. I don't use Excel but with your problems you only need a simple calculator:
to #2: I assume that the partners participate in the profit according to their investment.
Let p be the total profit then you know:
Solve for p. I've got 17390.
Unfortunately I can't help you with #4 and #5.