Hi DILIPandley,

Please let me explain. The values on X are the client deposit. The values on Y are the client net profit. The gross client profit is (deposit X performance%), e.g. 550 x 10%. From the gross profit we deduct the service cost, and we get the values of y-axis (client net profit). What i am trying to do i calculate the deposit amount required for a client just to break-even after any service costs, for a specific performance value i input somewhere (the above calculations are based on the performance rate).

In my sheet:

Axis X: Cells A4:A103 contain the deposit amounts (100, 200, 300 etc)
Axis Y: Cells M4:M103 contain the net client profit automatically calculated like this:

(formulas copied down between cells 04 to 103 in all cases):

(Net profit) M4 = E4-J4 (gross profit - total cost)
based on these:
(gross profit) E4 = A4*D$3/100 (deposit X performance % variable defined in D$3)
(total cost) J4 = B4+H4 (service cost + performance fee), where H4 = 25% (if positive, else = 0)

My sheet calculates (for a give performance %), what the net client profit is per deposit level (e.g. for deposit 100 the net profit = e.g. -135, for deposit 200 the net profit = e.g. -42, the for deposit 300 the net profit is positive, e.g. = +102 etc.

What i need is a cell that tells me: the client need to deposit e.g. 278 in order to break even (net profit y=0).

I would be grateful if you could provide the calculation! Thank you so much