Is an Untested Camera Lot Worth It? eBay Max Bid Math + Example
A step-by-step way to set one hard max bid on an untested lot of digital cameras before you resell on eBay. It includes the formula, a worked example, a stress test and a pre-bid checklist.
Untested lots of old compact cameras look cheap because the seller has passed the risk to you. The lot is worth buying only if the few cameras that work can pay for all the ones that don't.
This method gives you one number to enter as your max bid, worked out before the auction gets exciting. All dollar figures in the example are made up to show the math. Replace them with your own.
What you need before you start
- The exact model of every camera you can read in the photos
- A signed-in eBay account, so you can use the Sold Items filter
- The lot's shipping cost and your sales tax rate
- The profit you need to make the job worth your time
Step 1: Count only what you can identify
Go through the photos and list each camera by model. If a camera is hidden, blurry or unreadable, count it as worth $0. Do the same for anything with:
- A lens stuck out or visibly bent
- Green or white corrosion in the battery compartment
- A cracked screen
- A missing battery door
- Water damage or heavy grime
Never pay for the cameras the title promises. Pay for the cameras the photos prove.
Step 2: Pull real sold prices for each model
Search the exact model on eBay, then turn on the Sold Items filter. Stored or active listings tell you what sellers hope for, not what buyers pay. Then apply these rules:
- Get at least 3 sold results for each model. If you can't, treat that model as worth $0 or use a clearly lower number.
- Match the condition. Use only sales described as tested or working. Ignore "for parts" sales when pricing a working camera.
- Match the bundle. A camera sold with its box, case, charger and card is not a comp for a bare body.
- Add shipping to the price. Use what the buyer paid in total.
- Skip struck-through prices. They usually mean a Best Offer was accepted, and the real price may be lower.
- Use the median or lower. Your best single sale is a ceiling, not a plan.
Also note how many sold recently. If a model sold twice in 90 days and you may have three to list, expect to wait or cut the price.
Step 3: Work out net profit per working camera
Assuming you offer free shipping, so your sold comp includes postage:
Net per camera = sold comp − eBay fee − postage and packing − battery and charger cost
eBay's fee is usually quoted at about 13.6% of the total sale plus a per-order fee of about $0.40. Rates vary by category, account and date, so check eBay's current fee page.
Budget for what each camera needs to sell as working:
- Many Canon ELPH/IXUS models need a proprietary lithium battery and charger. The SD790 IS and SD890 IS use the NB-5L, for example. Lots rarely include one per camera.
- Many PowerShot A-series models run on AA cells, so they often cost less to get running.
- Some older cameras use CompactFlash instead of SD. The PowerShot A60 is one. You'll need one of each card type to test them.
Step 4: Choose a working rate and round down
Nobody publishes a reliable working rate for untested camera lots, and it varies by seller. It's a planning assumption, so be pessimistic.
A starting point is 35%. Go lower if the listing says "for parts", or if the photos show obvious damage or corrosion. Go slightly higher only when the seller gives a real reason, such as "powered on when last used."
Apply the rate to each model group separately and round down to a whole camera. You can't sell 1.4 cameras.
After your first lot, replace the assumption with your own result.
Step 5: Calculate the max bid
- Expected net = the total of net per camera × expected working cameras
- Maximum landed cost = expected net − your profit target
- Max bid = (maximum landed cost ÷ (1 + sales tax rate)) − lot shipping
Value dead cameras at $0 here. Selling them for parts is a bonus, not part of the plan. If your state's tax isn't charged on shipping, adjust step 3.
Worked example
A hypothetical lot has 10 cameras, with $15 shipping and 8% sales tax. The profit target is $40.
The contents, from the photos:
- 4 × Model A: $100 sold comp, needs an $8 battery and charger
- 6 × Model B: $40 sold comp, takes AA cells
Postage and packing are budgeted at $7.50 per camera.
Net per working camera:
- Model A: $100 − $13.60 − $0.40 − $7.50 − $8.00 = $70.50
- Model B: $40 − $5.44 − $0.40 − $7.50 = $26.66
Expected working cameras at 35%, rounded down:
- Model A: 4 × 0.35 = 1.4, so 1
- Model B: 6 × 0.35 = 2.1, so 2
Expected net: $70.50 + (2 × $26.66) = $123.82
Max bid:
- Maximum landed cost: $123.82 − $40 = $83.82
- Remove tax: $83.82 ÷ 1.08 = $77.61
- Remove shipping: $77.61 − $15 = $62.61
- Round down: max bid $62
At $62, your landed cost is ($62 + $15) × 1.08 = $83.16.
Step 6: Stress-test the number
Run the same lot through a good, a bad and a soft-market scenario:
- As expected (1 Model A, 2 Model B working): $123.82 − $83.16 = $40.66 profit
- One extra Model A works (2 and 2): $194.32 − $83.16 = $111.16 profit
- No Model A works (0 and 2): $53.32 − $83.16 = $29.84 loss
- Same cameras work, prices 20% lower ($80 and $32 comps): $92.72 − $83.16 = $9.56 profit
This example shows the main danger with camera lots: one camera carries the result. If losing your best camera creates a loss you can't accept, lower the bid until you can live with it, or skip the lot.
Check the time too. Testing, cleaning, photographing, listing and packing every camera, including the dead ones, may take hours. If the "as expected" profit would make that feel like a bad trade, raise your profit target.
Pre-bid checklist
- [ ] Every camera I'm paying for is identified from the photos
- [ ] I have at least 3 relevant sold comps per model, or valued it at $0
- [ ] Comps include shipping and match the condition and accessories I'd sell
- [ ] Battery, charger and test card costs are included
- [ ] The working rate is written down and each group is rounded down
- [ ] Lot shipping and sales tax are in the math
- [ ] I read the description for "no returns", "as-is" or "for parts"
- [ ] I've checked the seller's feedback and shipping location
- [ ] The "no best camera" scenario is a loss I can accept
Treat "untested, no returns" as final. Don't build a return into your plan.
On auction day
Enter your max bid once. eBay's automatic bidding only raises your bid as far as needed, so you may pay less than your limit. You can also place the same number in the final seconds if you prefer not to show interest early.
If you get outbid, stop. Raising the number means changing the assumptions after you've already done the math, and there will be another lot.
When to walk away
Skip the lot if any of these are true:
- The value depends on one camera you can't clearly see
- You can't find sold comps for the best models
- The max bid is already below the current price
- Shipping and tax use up most of the expected profit
- Too many of one model would flood a slow market
Common mistakes
- Pricing dead cameras as parts to justify a higher bid
- Using asking prices, especially on trendy "Y2K digicam" listings
- Forgetting batteries, which can erase the profit on a lower-priced body
- Assuming tested prices apply to untested cameras, when a working sale requires you to test and show it
- Comparing per-camera lot price with a single sale, instead of counting only the working units
The result is an estimate, not a promise of profit. Old cameras can fail after you buy them, and sold prices shift quickly. A written max bid won't remove the risk, but it does mean you decide how much of it to take before bidding starts.
PowerShot Lot Flip Kit: Bid Calculator, Test Cards and eBay Listing Templates for Canon Di · $19.00
Get it on Gumroad