Fee_Change_Calculator
Save As Excel
|
Full Screen View
Exit Full Screen View
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
Fee_Change_Calculator
by
auctionbytes
1 view
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
2008 eBay Fee Changes - Simple Analysis Tool
- assumes Gallery Fee, but no other add-ons (since price is unchanged for those)
- model works for eBay US site, not eBay Motors or international sites
-You get what you pay for! Use at your own risk and double-check all your assumptions
Part 1: Individual Item Analysis
Start Price
End Price
Listing
Gallery
FVF
Total Fee
1
Old Fee Structure
$9.00
$1,000.00
$0.40
$0.35
$33.00
$33.75
2
New Fee Structure
$9.00
$1,000.00
$0.35
$-
$36.32
$36.67
3
Difference $
$2.92
4
Difference %
8.6%
5
New DSR 4.6 - 5% FVF Discount
$9.00
$1,000.00
$0.35
$-
$34.50
$34.85
3.3%
6
New DSR 4.8 - 15% FVF Discount
$9.00
$1,000.00
$0.35
$-
$30.87
$31.22
-7.5%
Part 2: Monthly Overall Impact
Old Fees
New Fees
New Fees
New Fees
4.6 DSR
4.8 DSR
7
# Listings/Month
100
8
Listing/Gallery Fee
$75.00
$35.00
$35.00
$35.00
9
Sell Through Rate
100%
10
Total Monthly Sales
$100,000.00
11
FVF Fees
$3,299.75
$3,631.50
$3,449.93
$3,086.78
12
Total Fees
$3,374.75
$3,666.50
$3,484.93
$3,121.78
13
Total Net Fee Change $
$291.75
$110.18
$(252.98)
14
Total Net Fee Change %
8.6%
3.0%
-7.3%
15
Total Fee Change as % of Sales
0.3%
0.1%
-0.3%
Sheet1
0
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
powered by
Z
O
H
O
Sheet
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More