Help in Calculating Percentage based on $$$

AudriGib11

New Member
Joined
Jan 27, 2005
Messages
14
I have the following:

Discount = 0.4
Actual Cost = $24.96
List Price - $70.53
Price w/ Discount - 28.21
Sell % after discount - 12%

OK - what I need to know is how much do I need to increase my List Price to make sure that my Selling % after discount is 20%

Dont know if this is possible and I have about 500 that I need to figure out! PLEASE HELP!!!!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Scott R

Active Member
Joined
Feb 20, 2002
Messages
430
Try this:
Book2
ABCD
1BEFORE
2Discount0.4
3ActualCost$24.96
4ListPrice$70.53
5Pricew/Discount$28.21
6Sell%afterDiscount12%
7
8TargetSell%20%
9NewListPrice$78.00
10
11AFTER
12Discount0.4
13ActualCost$24.96
14ListPrice$78.00
15Pricew/Discount$31.20
16Sell%afterDiscount20%
Sheet1


List Price = Cost / ((1-target sell %)*Discount)
 

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
Multiply all your actual costs by 3.125 and you'll get 20% net if you discount that price by 40%
 

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
Hi Audri,

Take your cost and divide by .8 (or 20% margin).

That will get you your new discounted sell price. Take this discounted price and divide by .4 to get your new list price.

Ron
 

AudriGib11

New Member
Joined
Jan 27, 2005
Messages
14
SCOTT R - YOU ARE A TRUE TRUE TRUE HERO!!!!! You must give me your address so that I can send you a THANK YOU!!!!!!!!

This worked and saved me life!!!!!!! I spent 4 hours trying to figure this out and you did it in 2 min - AWESOME!!!!!!!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,545
Members
414,316
Latest member
ExcelLee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top