# 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

VIP Member
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.

#### Steve-LevelUp

VIP Member
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-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!