Reset Fields
Print Worksheet
Row
Gold
Sold-Comp & Net Pricing Worksheet
Used OEM Auto Parts Pre-Listing Valuation Planner
1. Comp Identity Card
Record exact part specifications prior to searching comps
Exact OEM Part Number (w/ Revision Suffix)
Donor Vehicle (Year, Make, Model, Generation)
Position & Orientation
Driver/Left
Pass/Right
Front
Rear
Upper
Lower
Configuration (Engine / Drivetrain / Trans / Body)
Shipping Profile (Box Dimensions, Packed Weight, Fragility)
Options & Electronics Package
Heated
Power-Fold
Camera
HID/LED
Navigation
Premium Audio
Memory
BSM/Sensors
Included Pieces / Assemblies
Condition & Test Status
2. Sold Comparable Log (8 Blank Comps)
Log completed 30-90 day sales
Sale Date
Part No. / Fitment
Exact?
Condition
Included Items
Sale Price ($)
Ship Charged ($)
Notes
Why Comparable?
Sold-Cluster Midpoint ($)
Chosen List Price ($)
Pricing Strategy Note
3. Net Profit Calculator
Interactive dynamic running totals when filled online
Cost / Expense Item
Note / Method
Amount ($)
Gross List / Sale Price
Total price paid by buyer including shipping
Target gross revenue
Yard Acquisition Cost
Base part cost paid at the salvage yard
Outlay before tax
Sales Tax (Yard Purchase)
Local sales tax on yard outlay (Guide default: 9%)
Tax paid at yard register
Unrecovered Core Deposit
Sunk core charge not returned to yard
Non-recovered deposit
Platform Final Value Fee
eBay Motors category fee (Guide rate: 13.6%)
Calculated on gross total
Platform Per-Order Fixed Fee
$0.30 if ≤ $10; $0.40 if > $10
Order transaction fee
Outbound Shipping Cost
Postage cost (Scale or Dim Weight rate)
Carrier label cost
Packaging Materials
Box, bubble wrap, tape, dunnage
Packing supplies cost
Return & Problem Reserve
3% to 5% reserve for returns or shipping damage
Risk reserve pool
Minimum Acceptable Net Profit
Your profit floor required for this pull
Target baseline profit
Resulting Estimated Net Profit
Gross Revenue minus All Total Outlays
Estimated Return
4. Best Offer Planner
Automate negotiation boundaries
Listing Asking Price ($)
Auto-Accept Floor ($)
Auto-Decline Floor ($)
30-Day Price Review Date
Counteroffer Rule / Strategy