Results 1 to 5 of 5

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
    70,365

    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.

  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 = %

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