For Automotive F&I Managers ·
What you'll accomplish
You'll use Claude to analyze your historical deal data and identify which lenders give you the most reserve flexibility for which customer profiles — turning informal hunches ("I always get better rates from Ally on prime credit") into data-backed submission strategy. This helps you optimize reserve income without violating rate mark-up limits.
What you'll need
Before Claude can analyze your lender performance, you need to get your data into a readable format. Create a simple table in any text editor, Google Sheets, or even on paper. You need 6 columns:
Deal# | Lender | FICO Range | Term (months) | Finance Amount | Reserve Earned ($)
001 | Ally | 700-749 | 72 | $28,000 | $840
002 | Cap One | 640-679 | 84 | $22,000 | $550
You don't need exact FICO scores — ranges are fine (640-679, 680-719, 720-759, 760+). You also don't need perfect data — estimate reserve if you have to.
What you should see: A 20-30 row table covering your recent deals. Troubleshooting: If you can't pull this from your DMS, rough estimates from memory for the last 20 deals will still show patterns.
Go to claude.ai, sign in, and make sure you're on the Pro plan (check in Settings).
What you should see: The chat interface — Pro gives you a higher message limit and longer context window for bigger data sets.
Start a new conversation and paste your deal table, then ask:
"This is my F&I deal data for the past [X months]. Analyze it and tell me: (1) Which lender gives me the highest average reserve per deal? (2) Is there a FICO tier or loan term where a specific lender consistently outperforms others on reserve? (3) Are there any patterns that suggest I should route certain deals differently? I want actionable insights, not just descriptions of the data."
What you should see: Claude analyzes the table and returns specific findings — e.g., "Ally consistently outperforms on reserve for 700+ FICO buyers financing $25K–$35K, while Westlake shows better performance on 640–680 FICO buyers at 84-month terms."
Push deeper on any insight:
What you should see: Specific, actionable recommendations for deal routing.
At the end of each month, add your new deals to your table and run the same analysis. Look for shifts — a lender that was generous last quarter may have tightened their program.
Monthly lender performance check:
Here's my updated deal data for [month]. Compared to last month, has any lender's reserve performance shifted significantly? What does this suggest for my routing strategy next month?
[paste data]
Deal routing decision:
I have a buyer with approximately [FICO range] FICO, [loan amount] financed, [term] months. Based on my historical data, which lender should I submit to first to maximize reserve within ECOA and rate markup compliance?
Identify under-used lenders:
Looking at my lender mix, are there any lenders I'm submitting to infrequently that show higher reserve performance in my data? Am I leaving relationships underutilized?