Calculating the Discount from Price when you know the GP%

An item Lists for 211.52 and a 67.25% discount gives me a $69.29 selling price. The Gross Margin for this item is 20.79% based on a cost of 54.87.

So 211.52-(211.52*.6725) = 69.29
then the GP = (69.29 - 54.87)/69.29 = .2079

Is there a formula that if I key in the GP% say 25% vs 20.79% it would return the Discount%?

Hello Nander,

I am not really sure what you're after, so I will give you several different calculations relating to GMP.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Yes, thank you for the GM calculations. I understand how to arrive at the GM. However, what I want to know if what formula will provide a discount % given a different GM%. In other words solve for discount factor. If we describe the following
(L)ist = 211.52
(D)iscount = 67.25
(P)rice = 69.29
So L-(L*D) = P

Also (Price - Cost)/ Price = GM

So what if we substitute Price with L-(L*D) we have the following

(L-(L*D) - Cost)/(L-(L*D)

Given above how do you solve for D given L, Cost?