Hello,

1. I don't use Excel but with your problems you only need a simple calculator:

to #1:

to #2: I assume that the partners participate in the profit according to their investment.

Total investment:

Let p be the total profit then you know:

Solve for p. I've got 17390.

to #3:

Unfortunately I can't help you with #4 and #5.