+ Reply to Thread
Results 1 to 5 of 5

Function/Formula to display minimal sell price for profit

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MAC Excel 2011 / Numbers 09
    Posts
    3

    Question Function/Formula to display minimal sell price for profit

    Hi everyone,

    I'm Dan, its nice to be part of this community.

    I'm trying to build a function that will give the minimal price sell for market stocks.

    I will try to be as most simple and direct in the formula:

    ((Buy Price*Quantity)+Commission) = Total Buy

    ((Sell Price*Quantity)-Commission) = Total Sell

    Total Sell - Total Buy = Result


    What I wish, is to generate the "Sell Price" automatically.

    The info I will feed to the function would be the Buy price, Quantity and Result. Than make the function generate the minimal Sell price for that the Result be bigger than 0.

    I hope I could explain well what I'm looking for.

    Thanks and nice to meet you all.

    Kind Regards,
    Dan

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: Function/Formula to display minimal sell price for profit

    Minimum Sale Price = Buy Price + (2 * Commission/quantity)

    assuming buy and sale commission is the same and sell quantity = buy quantity
    Regards,
    Vandan

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MAC Excel 2011 / Numbers 09
    Posts
    3

    Re: Function/Formula to display minimal sell price for profit

    Awesome thanks!

    But in the case that the commission aren't equal?

    For example:

    (Stock Price*Quantity)*1.5% = Commission.

    Thus making the sell commission a little higher than the buying.

    Thanks again for the quick reply.

  4. #4
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: Function/Formula to display minimal sell price for profit

    With that formula for commission


    At Purchase, you pay Price*Qty*1.015
    At sale you get Price*Qty*0.985

    Therefore, breakeven price is PurchasePrice * 1.015 / 0.985

  5. #5
    Registered User
    Join Date
    08-17-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MAC Excel 2011 / Numbers 09
    Posts
    3

    Re: Function/Formula to display minimal sell price for profit

    Thanks, all solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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