margin percentage

There is a fundamental difference between what I often call hard discount points and how that ties to Margin. Example: Product List Price is $100,000.00. I want to offer a discount of 20% (easy enough; $100,000 x 20% = $20,000 reduction) New Price is $80,000.00 This ties to using a...

Hey gang, I was unable to find what I was looking for so please forgive me if this is a repeated post. I am looking for a formula that will allow me to input the desired sales margin percent which in turn adjusts the sell price. Any help is appreciated.

I am building an Income Statement using PowerPivot. I have calculated rows for Gross Margin and Net Income. I want to add a row for Gross Margin %. i.e.: I currently have as a running total: Revenue - Costs = Gross Margin I want to add the following Percentage as a row: Gross Margin % = Gross...