What formula do I use to determine a margin goal?
For example if my retail price has to be $99.99 and my margin has to be 45% what formula do I use to determine what my cost is?
Thanks!
What formula do I use to determine a margin goal?
For example if my retail price has to be $99.99 and my margin has to be 45% what formula do I use to determine what my cost is?
Thanks!
cost = price * (1 - margin)
=a1 * (100%-45%)
Entia non sunt multiplicanda sine necessitate
This formula should return your original base price which, when marked up 45%, results in a 99.99 price.
A1 = 99.99
B1 =A1/145%
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Margin is a percent of price, not cost, JB. You're calculating for 45% markup, not 45% margin.
Thanks shg!
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks