Calculation Gain Percentage

[anilativy]

Hi,

Need help in calculation the gain percentage.
Suppose for example I have brought an item for which the vendor list price (quote price) is $100 but on negotiation, he agrees to sell at $80. Hence what shall be the gain and the gain percentage.

Quoted Price $100
Negotiated Price $80.
Gain ?
Gain Percentage.

[teylyn]

Hello and welcome to the forum


try this

Please Login or Register  to view this content.

[anilativy]

Thanks a lot teylyn.
Just another small dout, what will the following calculation result.

Quoted Price $100 100 100
Negotiated Price $80. 80 80
Gain =B2-B3 20

Gain % = B3/B2 ?
Is this calculation of Gain Percentage correct.

[anilativy]

Thanks a lot teylyn.
Just another small dout, what will the following calculation result.

Sorry Typo error, find below my second query.

Quoted Price $100 100 100
Negotiated Price $80. 80 80
Gain =B2-B3 20

Gain % = B4/B3 ?
Is this calculation of Gain Percentage correct.

[teylyn]

depends on what you want to base your percentage on. Can you put it in words?

[anilativy]

Hi,
Is Profit / Quote Price correct way of having gain %
or
Profit / Negotiated Price correct way of having gain %

[teylyn]

No, I meant: can you put into words what you want to calculate, i.e. can you describe what the calculation should be? You do the logic, I do the formula based on your logic.

[anilativy]

Hi,
I want to calculate the gain %.
Example:
Quoted Price $100
Negotiated Price $90
Profit/Gain $10.
In this case what shall be the gain percentage achived.
(Is the logic = Gain divided by Quoted Price or Gain divided by Negotiated Price)

[teylyn]

(Is the logic = Gain divided by Quoted Price or Gain divided by Negotiated Price)

That is exactly what I'd like to learn from you. This is a maths question, not an Excel problem.

I'd go for Gain divided by Quoted Price.

[anilativy]

Thank you very much, even i feel the same. Your calculation is correct.
This link has gain/loss calculator.
http://www.calculatorcat.com/free_ca...ent_gain.phtml

Thanks a lot for the time and pains taken in solving my problem.