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

[happydz]

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]

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.

 

[happydz]

yeah, I already created a spreadsheet, but I failed as the calculations was not right.
here it is the spreadsheet
https://drive.google.com/file/d/1NBe_esEOzA6jdfMMvzcE3kRX7ensjZd2/view?usp=sharing

 

[Steve-LevelUp]

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.

 

[happydz]

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-f...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!

 

[Steve-LevelUp]

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.