Bulk Lot Profit & Cost-Basis Calculator
It includes bulk eBay listing imports, manual card entry, estimated resale values, proportional cost allocation, individual card profit projections, and a purchase-decision dashboard.
What makes it useful: Instead of dividing a $200 lot equally across 30 cards, it allocates the cost according to each card's estimated resale value. That gives a more meaningful estimate of profitability for mixed-value collections.
It also calculates a suggested maximum all-in lot cost based on an adjustable ROI target and expected sell-through.
The workbook includes sample data, editable assumptions, and instructions. The estimates depend on the user's resale-price assumptions; it does not retrieve live sold comps.