Calculating Sale price from cost and Margin

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Calculating Sale price from cost and Margin

  1. #1
    New Member
    Join Date
    Jul 2003
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

  7. #7
    Board Regular
    Join Date
    Jul 2014
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculating Sale price from cost and Margin

    Quote Originally Posted by capchica85 View Post
    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.



    I'm sorry but Sell Price = Cost * (1+ Margin %) DOES work and shows the correct value. For example:

    5 * (1+20%) = 6
    20% of 5 = 1

  8. #8
    New Member
    Join Date
    Oct 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculating Sale price from cost and Margin

    Quote Originally Posted by CRUTHERFORD View Post
    I'm sorry but Sell Price = Cost * (1+ Margin %) DOES work and shows the correct value. For example:

    5 * (1+20%) = 6
    20% of 5 = 1
    You bloody better be sorry, because you're WRONG.

    Thanks for wasting 15 mins of my time with your confusion.

    This is profit % not margin %

User Tag List

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