+ Reply to Thread
Results 1 to 4 of 4

Determining Margin Formula, I know cost and margin desired.

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    Texas
    MS-Off Ver
    Office 365 Business
    Posts
    2

    Determining Margin Formula, I know cost and margin desired.

    Thanks in advance for any help offered. I need an Excel formula that will tell me my sales price if I know my cost and desired margin. I have searched for hours and tried several suggested formulas, but none of them work. Here is an example of what I need:

    My cost is $11.23,
    I need to achieve a margin a 35%
    What would my sell price be?

    (Note, I know the answer is $17.28 because I have a margin calculator on my adding machine. I just can't get any formula to give me $17.28 when I plug it into Excel.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Determining Margin Formula, I know cost and margin desired.

    Cost / (1 - percentage)

    11.23 / (1 - 0.35) = 11.23 / 0.65 = 17.276923
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-13-2018
    Location
    Texas
    MS-Off Ver
    Office 365 Business
    Posts
    2

    Re: Determining Margin Formula, I know cost and margin desired.

    Special-K: Thank you for your help on this. That worked perfectly. I was making a stupid mistake on this formula and your answer cleared it up!
    Todd

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Determining Margin Formula, I know cost and margin desired.

    Quote Originally Posted by Draftdude View Post
    Special-K: Thank you for your help on this. That worked perfectly. I was making a stupid mistake on this formula and your answer cleared it up!
    Todd
    Dont hold me in too high regard.
    I had to look it up cos I couldnt see how to get 17.28 out of that sum either

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-28-2017, 09:20 AM
  2. [SOLVED] Find desired sell price after costs with target profit margin
    By Juddk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2016, 02:41 PM
  3. [SOLVED] How do I work out the sell price from cost, desired margin and success fee?
    By westnz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2016, 04:08 AM
  4. Calculate Retail Price based on desired profit margin
    By fergusga in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-12-2016, 10:59 AM
  5. Net Margin Formula Using SUM= To Calculate Gross Margin Cells
    By jezrp22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2015, 08:41 PM
  6. Margin, RRP and Cost Price Calculation assistance
    By scottmjohnson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2012, 05:55 AM
  7. [SOLVED] Textbox margin overwritten by auto-margin
    By Jess in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2005, 07:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1