+ Reply to Thread
Results 1 to 3 of 3

Ebay / Amazon Profit Calculator - Making a Specific Margin after fees

Hybrid View

  1. #1
    Registered User
    Join Date
    03-05-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2016
    Posts
    79

    Ebay / Amazon Profit Calculator - Making a Specific Margin after fees

    Hi all,
    I have just started selling on eBay and find it confusing to know how much I'm making. I don't want to appear too expensive or give my products away. If I have a part that costs me £20.00 plus vat i.e £24.00. I have to include carriage £5.00 plus vat i.e £6.00. Ebay fees for car parts including PayPal is 10%. How much would I charge to retain 20% percent after all fees and charges and what formula would I use to make the calculator. Any help would be, as always appreciated.
    Best regards
    Jason

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Ebay / Amazon Profit Calculator - Making a Specific Margin after fees

    Total cost to You say:- £33
    Profit required + 20%

    33 x 1.2 = 39.6 = Price to charge

    Check
    39.6-33/33 = 20%

  3. #3
    Registered User
    Join Date
    03-05-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2016
    Posts
    79

    Re: Ebay / Amazon Profit Calculator - Making a Specific Margin after fees

    Quote Originally Posted by MickG View Post
    Total cost to You say:- £33
    Profit required + 20%

    33 x 1.2 = 39.6 = Price to charge

    Check
    39.6-33/33 = 20%
    Hi Mick,
    Thanks for that but I need to calculate all eBay charges etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  2. Spreadsheet for Fees, Shipping, Profit, ETC for selling on EBAY
    By sandysmith in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-22-2013, 10:13 AM
  3. Replies: 6
    Last Post: 06-08-2012, 11:28 AM
  4. I need a Sum formula for ebay fees
    By bshore2222 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2009, 06:48 AM
  5. quite complicated functions(ebay fees)
    By macwillis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-04-2007, 02:08 AM

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