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!!!!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Scott R

Active Member
Joined
Feb 20, 2002
Messages
444
Office Version
  1. 365
Platform
  1. Windows
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
642
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!!!!!!!!!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,037
Messages
5,856,966
Members
431,841
Latest member
jaybeem

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