Computing.Net > Forums > Office Software > Calculating discounted $ value

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Calculating discounted $ value

Reply to Message Icon

Name: Lawless_62
Date: October 14, 2009 at 20:47:35 Pacific
OS: Windows Vista
Product: Microsoft Excel 2007
Subcategory: Microsoft Office
Comment:

If I know that 5% of whatever I charge for a product is taken from the bottom line, then how do I do the calculation to tell me how much I should list the product for to ensure I recieve the original amount I wanted. e.g. product value is $100, I know that 5% will be taken, so I put 5% on , price is now $105, but when the 5% is now taken the price becomes $99.75. How do I do the calculation to tell me how much I should list it for to ensure I recieve $100 after the 5% is taken?



Sponsored Link
Ads by Google

Response Number 1
Name: RTAdams89
Date: October 14, 2009 at 21:12:29 Pacific
Reply:

S is the original price (in your case $100)
D is deduction (in your case 5% or $5)
L is list price (what you are looking for)

L - (D * L) = S

Solve for L:

L - (D * L) = S
L * (1 - D) = S
L = S / (1 - D)

There you go. Plugging in the original numbers you gave, we get:

L = 100 / (1 - .05)
L = 100 / 0.95
L = 105.26315789473684210526315789474

So sell it for $105.27

-Ryan Adams

Free Computer Tips and more:http://RyanTAdams.com
Paid Tech Support: Black Diamond


0

Response Number 2
Name: wizard-fred
Date: October 16, 2009 at 17:58:30 Pacific
Reply:

Ryan is correct except in the case of a tax rate (ex. sales tax)
where you would have to round down.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More






Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Calculating discounted $ value

Excel Formula for calculating point values www.computing.net/answers/office/excel-formula-for-calculating-point-values/8914.html

Query question www.computing.net/answers/office/query-question/4341.html

Excel 2003 sorting www.computing.net/answers/office/excel-2003-sorting/7607.html