+ Reply to Thread
Results 1 to 2 of 2

Cost price calculations what one is right?

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cost price calculations what one is right?

    Hi all,
    I'm doing a Cash Flow Estemate for a business i'm starting, Now I've worked out what I can expect to make, Gross, each month, it's $186,208.00, ($786 per hour incase you're interested) I have a really good supplier and I'm going to be looking at a rough GP of 30% on average, So for the purpose of my CFE I need to work out what my buy price is. There are more than 10 different ways i've come across and each different way gives a different answer; Some are really great for me and some are really horrible. What is the right way to do this? I'm going batty!

    Thanks in advance
    BigD11213

    I'll tell you current one i'm using:
    B5= $186,208.00
    B6= 30 [representing 30%]
    B7= $55,862.40 Formula: =(B5*B6)/100
    B8= $130,345.60 Formula: =B5-B7
    End Result is $130,345.60

    I've also used:
    =B5/1.3
    End Result is $143,236.92

    B6= -30%
    =B5*(1+B6%)
    End Result is $130,345.60

    B6= 30%
    =B5/(1+B6%)
    End Reusult is $143,236.92


    So the common theme here are the 2 different numbers: $130,345.60 and $143,236.92. Which method is right and why please? My business hinges on me getting this right.
    Last edited by BigD11213; 02-12-2013 at 09:58 AM.

  2. #2
    Registered User
    Join Date
    02-12-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Going crazy here

    Admin Delete this reply please
    Last edited by BigD11213; 02-12-2013 at 09:51 AM. Reason: Consolidated into one post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1