SkzDaLimit
Board Regular
- Joined
- Dec 1, 2002
- Messages
- 54
Hi everyone! Haven't been around in quite a while but I have been working on a project recently. I have been working on a spreadsheet to determine my profits/losses on my eBay store. Searching the forums, I found a couple of threads regarding formulas to determine FVF (final value fees). I modified the formulas to match the current fee structure for certain fixed price auctions, which can be found here: http://pages.ebay.com/help/sell/fees.html#fvf_fixed
For a fixed price listing in the "All Other" category on eBay, I am using this formula (which I found here on the forums):
=IF($A1<=50,$A1*11%,IF($A1<=1000,($A1-50)*6%+6,($A1-1000)*2%+63))
The fee schedule according to eBay is 11.0% of the initial $50.00, plus 6.0% of the next $50.01–$1,000.00, plus 2.0% of the remaining balance ($1,000.01–total cost to buyer)
Using eBay's Fee Calculator: http://pages.ebay.com/sellerinformation/news/Feecalculator.html# and using an example selling price of $12.99, the formula accurately calculated the FVF at $1.30.
When I used a selling price of $100, the formula gave me a FVF of $9.00 while eBay's calculator gave me a FVF of $8.50. $999.99 was $63.00 and eBay was $62.50.
It appears the Excel formula is accurate to $50.00 but for whatever reason is rounding to the next highest dollar for values higher than $50.01.
Can the formula be modified to fix this error? Once I have this straightened out, I'll have another question I will address in another thread. Thanks in advance!
Michael
For a fixed price listing in the "All Other" category on eBay, I am using this formula (which I found here on the forums):
=IF($A1<=50,$A1*11%,IF($A1<=1000,($A1-50)*6%+6,($A1-1000)*2%+63))
The fee schedule according to eBay is 11.0% of the initial $50.00, plus 6.0% of the next $50.01–$1,000.00, plus 2.0% of the remaining balance ($1,000.01–total cost to buyer)
Using eBay's Fee Calculator: http://pages.ebay.com/sellerinformation/news/Feecalculator.html# and using an example selling price of $12.99, the formula accurately calculated the FVF at $1.30.
When I used a selling price of $100, the formula gave me a FVF of $9.00 while eBay's calculator gave me a FVF of $8.50. $999.99 was $63.00 and eBay was $62.50.
It appears the Excel formula is accurate to $50.00 but for whatever reason is rounding to the next highest dollar for values higher than $50.01.
Can the formula be modified to fix this error? Once I have this straightened out, I'll have another question I will address in another thread. Thanks in advance!
Michael
