Results 1 to 6 of 6
Like Tree1Likes
  • 1 Post By duplinguy

Calculating Sale price from cost and Margin

This is a discussion on Calculating Sale price from cost and Margin within the Excel Questions forums, part of the Question Forums category; Hi all, I need to calculate some sale prices based on original cost 24.9 and margin 85%. I know this ...

  1. #1
    New Member
    Join Date
    Jul 2003
    Posts
    4

    Default Calculating Sale price from cost and Margin

    Hi all,
    I need to calculate some sale prices based on original cost 24.9 and margin 85%. I know this is really simple but i am having a monday mental block

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,085

    Default Re: Calculating Sale price from cost and Margin

    Is it 100/15 times original cost?

  3. #3
    New Member
    Join Date
    Jul 2003
    Posts
    4

    Default Re: Calculating Sale price from cost and Margin

    Thank you this seems to be correct

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    93

    Default Re: Calculating Sale price from cost and Margin

    Formula is Cost/(1-Pecent Margin).
    In your example, 24.9/(1-.85) will give you a selling price of 166.
    Number4 likes this.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    197

    Default Re: Calculating Sale price from cost and Margin

    =D11*(1+F11)

    D11 = Cost Price
    F11 = %

  6. #6
    New Member
    Join Date
    Oct 2015
    Posts
    1

    Lightbulb Re: Calculating Sale price from cost and Margin

    This is the correct answer above:

    Formula is:
    Sell Price = Cost / (1- Margin %).
    In your example, 24.9/(1-.85) will give you a selling price of 166.

    Here is the excel function: =A2/(1-B2) where A2=cost and B2=margin% (in decimal form)


    (isn't that a high margin Mr. T? you're lucky to be able to do that)

    100/15 * cost is the same as 24.9 * 100/(100-85) which works but is complicated.

    Sell Price = Cost * (1+ Margin %) does not work.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com