Wholesale Auction Value Analyzer
Analyze wholesale auction vehicles against market comps and defend acquisition decisions
What You Can Do
You can systematically analyze wholesale auction vehicles by comparing them against current market comps, calculating realistic profit margins after reconditioning, and generating documented appraisals that withstand dealer principal and auction house review. The skill accelerates your valuation process by building competitive intelligence into pricing recommendations and creating audit-ready justifications for acquisition decisions in volatile market conditions.
Features
automatically identifies and weighs comparable sales data to establish baseline valuations
factors reconditioning costs and timeline-to-sale to project dealer return potential
applies systematic deductions for mileage, title status, accident history, and mechanical defects
accounts for local market preferences and seasonal inventory patterns affecting resale velocity
handles fleet purchases and multi-unit lots with consistent methodology across vehicles
generates defense-ready justifications and condition assessments for dealership reconciliation
flags when comp freshness drops below reliability thresholds for reanalysis
synthesizes profit potential, holding risk, and market demand into prioritized acquisition guidance
Example Output
Vehicle: 2021 Honda Accord EX, 48K miles, Clean title
Market Analysis:
- Current comp average: $22,400 (3 comps within 250 miles, <30 days old)
- Your evaluation: $21,800
- Adjustment: -$600 (interior wear vs. comp average)
Profit Projection:
- Estimated reconditioning: $1,200
- Projected retail price: $24,500
- Gross profit margin: $1,500 (6.1%)
- Holding period: 18-22 days (local market demand: moderate)
Recommendation: ACQUIRE — Profit margin meets dealer threshold with acceptable holding risk
Vehicle: 2019 Ford F-150, 78K miles, Branded title (previous flood)
Market Analysis:
- Clean title comp average: $26,800
- Branded title adjustment: -$3,400 (35% discount standard for flood-branded trucks)
- Your evaluation: $23,200
Profit Projection:
- Estimated reconditioning: $2,800 (mechanical/interior drying)
- Projected retail price: $25,900
- Gross profit margin: $300 (1.2%)
- Holding period: 28-35 days (branded title extends holding period)
Recommendation: PASS — Profit margin below dealer minimum; holding risk elevated due to title status and reconditioning uncertainty
What's Included
- SKILL.md instruction file with complete wholesale valuation workflow:
- Market Comp Analysis Template: structured form for documenting comparable vehicles and adjustment methodology
- Profit Margin Worksheet: spreadsheet-style framework for calculating acquisition price targets and holding period projections
- Condition Adjustment Checklist: systematic deduction grid for mileage, title status, mechanical defects, and cosmetic damage
- Batch Appraisal Log: multi-vehicle tracking sheet for fleet purchases with consistency controls
- Dealer Reconciliation Report Format: defense-ready documentation structure for internal and auction house review
Who It's For
- Wholesale appraisers managing high-velocity vehicle acquisitions at auctions
- Dealer acquisition managers evaluating trade-in pricing and floor plan decisions
- Used car dealership managers defending valuation decisions to ownership
- Auto auction procurement specialists analyzing batch lots and fleet purchases
- Finance managers modeling acquisition costs and profit margins across inventory
Best For
- Rapid pre-bid appraisals before live or online auction participation
- Dealer trade-in acquisition pricing with internal profit margin targets
- Multi-unit fleet purchases requiring consistent methodology across vehicles
- Market volatility analysis when comp data freshness impacts valuation confidence
- Documentation-heavy appraisals requiring dealer principal or auction house defense
You might also like
You create professional, audit-ready Excel financial models with structured layers, documented assumptions, and traceable formulas. Claude helps you architect transparent models, build comprehensive assumption logs, design scenario analyses, and verify accuracy through systematic checklists. Your models will be immediately understood by auditors, stakeholders, and collaborators.
You can evaluate wholesale acquisition opportunities, benchmark your inventory against competitor pricing, and establish margin-protected selling prices across your used vehicle lot. Claude analyzes market conditions, comparable sales, and your profitability targets to generate acquisition recommendations and pricing strategies that prevent leaving 15-25% margin on the table through reactive or uninformed decisions.
This skill analyzes your new vehicle inventory metrics—including turn rates, days inventory outstanding (DIO), gross profit per unit, and market demand signals—to recommend specific stock adjustments. You'll get actionable guidance on which vehicle segments and trim levels to prioritize, how many units to carry by model, and when to shift from stock inventory to special orders based on manufacturer constraints and seasonal trends.
This skill analyzes your warranty claims data to catch documentation gaps and compliance issues before manufacturer submission, identify systemic denial patterns across repair types or technicians, and recover lost reimbursement revenue. You'll increase first-pass acceptance rates, reduce administrative overhead managing rejections, and coach your team on claim submission best practices aligned with your OEM's specific requirements.
You'll structure your auction appraisal process to account for comparable market analysis, vehicle condition assessment, regional demand timing, and dealer-specific acquisition strategy. This skill transforms auction floor decisions from intuition-based bidding into data-informed positioning that protects margins, identifies genuine opportunities in high-velocity auction environments, and creates documented justification for bid limits and acquisition parameters.
You can analyze your parts consumption history to identify demand patterns, forecast future needs by season and service category, and calculate the ideal stock levels that balance carrying costs against service disruption. The skill helps you eliminate slow movers, set reorder triggers for high-demand items, and generate purchasing recommendations backed by actual service data—so you're not guessing at inventory levels.
You can design compliant F&I menus, evaluate protection products against regulatory standards, create disclosure documentation that meets TILA-RESPA requirements, and develop training materials that ensure your sales team presents products legally. This skill helps you balance aggressive F&I penetration with regulatory safety, reducing CFPB and state attorney general exposure while maintaining healthy profit per vehicle.
You can systematically analyze warranty disputes by evaluating claim legitimacy, identifying gray-area coverage decisions, and negotiating settlements that balance manufacturer guidelines with customer retention. The framework helps you document decisions defensively, prepare escalation responses, and communicate warranty denials in ways that reduce customer friction while protecting your dealership's warranty budget and reputation.