Results 1 to 2 of 2

Thread: How to calculate selling price in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    62

    How to calculate selling price in Excel

    We have a pub, and we really need to keep a close watch on profit margins. I have a formula for calculating the GP from net cost and selling prices [which is 1-(cost price/sales price) ] but my math lessons are nearly 50 years back, and I can't work out how to calculate the price we need to charge in order to make the right margins. So if you guys have any idea then let me know. Any of the help from you guys will be appreciated

  2. #2
    Join Date
    Aug 2011
    Posts
    566

    Re: How to calculate selling price in Excel

    According to my information you can try this out May it will help you out.
    Rearranging GP = 1-(cost price/selling price) gives selling price = cost price / (1- GP)

Similar Threads

  1. Calculate IRR in Excel
    By superdave1984 in forum Windows Software
    Replies: 3
    Last Post: 01-12-2009, 12:46 PM
  2. How to calculate GPA in Excel worksheet
    By Lambard in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 09:29 PM
  3. How to calculate two dates in Excel
    By Ektaa in forum Windows Software
    Replies: 5
    Last Post: 03-03-2009, 05:50 PM

Tags for this Thread

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
  •  
Page generated in 1,714,035,795.80608 seconds with 17 queries