What is the breaak-even point based on this data?


Joined
Aug 23, 2018
Messages
3
Reaction score
0
Country
Algeria
Hey there,
I need to calculate break-even point $ using excel spreadsheet based on this data

Here is the date:
Item Cost: 19.95$
PayPal fees: (4.9% of the selling price)+0.3$
ebay fees: 10% (of the selling price)
fixed tax: 8% of the total cost

thank you
 

Steve-LevelUp

VIP Member
Joined
Jul 18, 2016
Messages
308
Reaction score
42
Country
Canada
What do you think the excel worksheet would look like. Feel free to open excel and put in the calculations that you feel are appropriate. If you then re-post it here, we can help confirm if your calculations in excel are correct.
 
Ad

Advertisements

Steve-LevelUp

VIP Member
Joined
Jul 18, 2016
Messages
308
Reaction score
42
Country
Canada
It looks like you are close. The total cost needs to be divided by 100% - 10% - 4.9%. This should give you the number you are looking for. You can verify this by calculating the fees from the sale price that you calculated.
 
Joined
Aug 23, 2018
Messages
3
Reaction score
0
Country
Algeria
It looks like you are close. The total cost needs to be divided by 100% - 10% - 4.9%. This should give you the number you are looking for. You can verify this by calculating the fees from the sale price that you calculated.
It did not work!

When I tried to apply the formula, it did not work.

Cost: $19.95

Shipping: $0

eBay fees: 10%

PayPal fees: 4.9%

Tax (fixed): 8%

Other fixed fees: $0.3
I calculated the breakeven as fillowing: (19.95+0.3/1-10%-4.9%-8%=0.771)
I took this method from this guy here: https://www.quora.com/What-is-the-formula-to-calculate-the-break-even-price-for-an-eBay-listing-based-on-acquisition-cost
*Calculated breakeven price is: $26.26 **which is not accurate** I don't know why!!!

Price: $26.26

Cost: $19.95

Shipping: $0

eBay: $2.63 (10% of $26.26)

PayPal: $1.59 (4.9% of $26.26 + $0.3)

Tax: $1.6 (8% of $19.95)

Profit: $0.50 ***it should be $0***

Can you clarify this to me, please!
 
Ad

Advertisements

Steve-LevelUp

VIP Member
Joined
Jul 18, 2016
Messages
308
Reaction score
42
Country
Canada
The sales tax (8%) that you are calculating should be on the sale price, not on the cost. Try the math again but use the Sales price when calculating the sales tax.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top