eBay
  • Daily Deals
  • Sell
  • Customer Support
  • Shop now

An MS Excel Formula Structure to Calculate Profit/Loss

akayhan
By Published by
. Views . Comments Comment . 20 Votes
Dear eBay Sellers,

If you have some experience using Microsoft Excel, I would like to share a simple outline and formula structure so that you can create an Excel file to calculate your profits/loss from a sale.

All you have to do is to create a new MS Excel file with the following formula structure.  Please feel free to personalize the cells or the formulas to suit your individual needs.

This MS Excel file is not intended to replace eBay Sales Reports but to supplement them by an interactive sales tool.  I hope you find it helpful for pricing your eBay items.

Regards,
Al Kayhan (akayhan)


2                B                           C
3    Starting bid                      0.99
4    Successful listings %        0.20
5    Closing price                    0.99
6    Shipping & handling fee    2.50
7       
8    Total price                       =SUM(C5:C6)
9    Insertion fee                     =IF(C3<=0.99, 0.2, IF(C3<=9.99, 0.4, IF(C3<=24.99, 0.6, IF(C3<=49.99, 1.2, IF(C3<=199.99, 2.4, IF(C3<=499.99, 3.6, 4.8))))))
10  Final value fee                   =C5*0.0525
11  eBay fees                          =C9/C4+C10
12  PayPal fees                        =0.3+C8*0.03
13       
14   Total eBay & PayPal fees    =SUM(C11:C12)
15   USPS postage                    1.75
16   Envelope, etc.                    0.19
17       
18   Net profit from sale            =SUM(C5:C6)-C14-C15-C16



Total fees = Insertion fee / (Successful listings %) + Closing price x (5.25 %) + 0.30 + Total price x (2.9 %)

Net profit from sale = Total price - Total fees - Postage

 
Write a guide
Explore More
Choose a template

Additional site navigation