F&I
All three stores · September 2025 · vs August 2025
Granite Auto Group is fictional. Operating figures are synthetic.· data and methodology
Every warehouse record in this project is synthetic. Granite Auto Group and its three stores are fictional. No real dealership, customer, employee or lending data exists anywhere in the project.
Real-engine validation pending. Neither accepted ADR-0008 path has recorded a result, so nothing on this page may be read as evidence that the Power BI semantic model has been validated. This console renders exported SQL figures; rendering a number in HTML proves nothing about a DAX measure.
Filters and controls2 applied
Every lender, product and provider on this page is invented. Prices, costs and eligibility rules are synthetic analytical rules for a fictional dealer group. No figure here is an industry benchmark, and ARPI models no APR, payment, buy rate, sell rate, rate spread, credit score or lending decision of any kind.
Production
Every per-unit figure divides by 15 retail deliveries, including cash deliveries that cannot earn reserve. A rate with no denominator is stated as such rather than shown as zero.
Every governed production figure, with its basis
Finance reserve
$2,963Deal date
An amount, never a rate. Zero on cash and lease deliveries.
KPI-FNI-001Reserve per retail unit
$198Deal date
Cash deliveries are inside this denominator and cannot earn reserve.
KPI-FNI-002Reserve against product
| Component | Deal-date gross | Share |
|---|---|---|
| Finance reserve | $2,963 | 19.3% |
| Original product gross | $12,408 | 80.7% |
| Other F&I income | $0 | 0.0% |
| Back-end gross | $15,371 | 100.0% |
Produced against retained — why these are two different numbers
Original product gross is what the finance office produced, attributed to the day each deal was struck. It is never rewritten when a cancellation or chargeback posts later. Net product gross is what the store retained as at 2025-12-31, after every adjustment posted on or before that date.
| Original F&I gross (deal date) | $15,371 |
|---|---|
| Cumulative product adjustments through 2025-12-31 | $546 |
| Retained F&I gross (as of 2025-12-31) | $14,825 |
A difference between the two is expected wherever adjustments posted. It is not an error in either figure, and neither is a correction of the other.
Deal structure
How the deliveries were funded
Retail deliveries by finance structure over September 2025. Shares are computed from summed counts, never averaged from store percentages.
Cash 7 deliveries, 46.7%; Retail Finance 8 deliveries, 53.3%; Lease 0 deliveries, 0.0%.
- Cash
- 46.7%7
- Retail Finance
- 53.3%8
- Lease
- 0.0%0
Read finance structure mix as a table
| Structure | Deliveries | Share of retail deliveries |
|---|---|---|
| Cash | 7 | 46.7% |
| Retail Finance | 8 | 53.3% |
| Lease | 0 | 0.0% |
| All retail deliveries | 15 | 100.0% |
Wholesale and dealer-trade disposals are not retail structures and are not part of this mix: a disposal has no consumer, so it carries no finance product and no consumer lender. Shares are computed from summed counts, never averaged from store percentages. KPI-FNI-019
Which date a figure is on
Three bases, never collapsed into one. Every figure on this page carries the one it is measured on.
- Deal date
- What the office produced. Never rewritten by a later event.
- As of 2025-12-31
- What the store retained, after every adjustment posted by that date.
- Adjustment period, September 2025
- Events grouped by the day they posted.
Penetration
What was sold, against what could have been
Distinct deals carrying at least one contract in the category, over the deals eligible for that category. Each bar runs from zero to full eligibility, so lengths compare directly.
Vehicle Service Contract 20.0%, 3 of 15 eligible deals; GAP 75.0%, 6 of 8 eligible deals; Tire & Wheel 26.7%, 4 of 15 eligible deals; Prepaid Maintenance no eligible deals; Appearance Protection 0.0%, 0 of 15 eligible deals; Paintless Dent Protection 20.0%, 3 of 15 eligible deals; Theft or Security Product 13.3%, 2 of 15 eligible deals; Key Replacement 0.0%, 0 of 15 eligible deals; Lease Wear Protection no eligible deals; Other Aftermarket Product 6.7%, 1 of 15 eligible deals.
Vehicle Service Contract20.0%3 of 15
ELIG-VSC All retail deliveries
GAP75.0%6 of 8
ELIG-GAP Financed retail deliveries only
Tire & Wheel26.7%4 of 15
ELIG-TW All retail deliveries
Prepaid MaintenanceNo eligible deals0 of 0
Appearance Protection0.0%0 of 15
ELIG-OTH All retail deliveries
Paintless Dent Protection20.0%3 of 15
ELIG-OTH All retail deliveries
Theft or Security Product13.3%2 of 15
ELIG-OTH All retail deliveries
Key Replacement0.0%0 of 15
ELIG-OTH All retail deliveries
Lease Wear ProtectionNo eligible deals0 of 0
Other Aftermarket Product6.7%1 of 15
ELIG-OTH All retail deliveries
Read penetration by category as a table
| Category | Contracts | Deals with product | Eligible deals | Penetration | August 2025 | Change |
|---|---|---|---|---|---|---|
| Vehicle Service Contract | 3 | 3 | 15 | 20.0% | 43.3% | -23.3 percentage points |
| GAP | 6 | 6 | 8 | 75.0% | 53.6% | +21.4 percentage points |
| Tire & Wheel | 4 | 4 | 15 | 26.7% | 23.3% | +3.3 percentage points |
| Prepaid Maintenance | 0 | 0 | None eligible | No eligible deals | Not available | Not comparable |
| Appearance Protection | 0 | 0 | 15 | 0.0% | 23.3% | -23.3 percentage points |
| Paintless Dent Protection | 3 | 3 | 15 | 20.0% | 0.0% | +20.0 percentage points |
| Theft or Security Product | 2 | 2 | 15 | 13.3% | 6.7% | +6.7 percentage points |
| Key Replacement | 0 | 0 | 15 | 0.0% | 3.3% | -3.3 percentage points |
| Lease Wear Protection | 0 | 0 | None eligible | No eligible deals | Not available | Not comparable |
| Other Aftermarket Product | 1 | 1 | 15 | 6.7% | 10.0% | -3.3 percentage points |
Distinct deals, never contracts: one deal may carry two products in one category.
Adjustments
No adjustment posted in September 2025. That is a genuine absence of events rather than a zero: cancellations and chargebacks are grouped by the date they posted, and the reporting window truncates the tail of the lag distribution, so the most recent sale months carry structurally fewer of them.
What each category earned
| Product category | Contracts | Retail | Dealer cost | Original gross | Adjustments | Net gross | Gross per contract | Share of gross |
|---|---|---|---|---|---|---|---|---|
| Vehicle Service Contract | 3 | $4,746 | $2,416 | $2,330 | $83 | $2,248 | $777 | 18.8% |
| GAP | 6 | $4,797 | $1,446 | $3,351 | $463 | $2,888 | $558 | 27.0% |
| Tire & Wheel | 4 | $4,499 | $2,038 | $2,462 | None | $2,462 | $615 | 19.8% |
| Prepaid Maintenance | 0 | $0 | $0 | $0 | None | $0 | No contracts | 0.0% |
| Appearance Protection | 0 | $0 | $0 | $0 | None | $0 | No contracts | 0.0% |
| Paintless Dent Protection | 3 | $3,845 | $1,368 | $2,476 | None | $2,476 | $825 | 20.0% |
| Theft or Security Product | 2 | $1,847 | $572 | $1,275 | None | $1,275 | $637 | 10.3% |
| Key Replacement | 0 | $0 | $0 | $0 | None | $0 | No contracts | 0.0% |
| Lease Wear Protection | 0 | $0 | $0 | $0 | None | $0 | No contracts | 0.0% |
| Other Aftermarket Product | 1 | $800 | $286 | $514 | None | $514 | $514 | 4.1% |
Original gross is the deal-date figure; net gross is what remained as at 2025-12-31. Share of gross is each category’s original gross over every category’s, at the same grain and the same basis. Finance reserve and retail units are deliberately absent from this table: both are properties of a deal, and repeating them on ten category rows would multiply them for anything that summed the result. KPI-FNI-020
The same measures, by desk, with their context
| Finance manager | Store | Retail units | Contracts | Reserve PVR | Product gross PVR | Products per unit | Retained F&I PVR |
|---|---|---|---|---|---|---|---|
| EMP-00028 | Granite Pre-Owned | 15 | 19 | $198 | $827 | 1.26 | $988 |
Ordered by store and synthetic identifier — never by a metric. These figures inherit each store’s vehicle mix, finance-structure mix and product-eligibility mix, so a difference between two rows is not a difference in skill. Every ratio uses that manager’s own denominator, never the store’s. Below 10 retail units a ratio is withheld and the counts are shown instead. KPI-FNI-021 KPI-FNI-022
How to read this page
The three date bases, and why they are not interchangeable
Deal date. What the finance office produced, attributed to the day the deal was struck. Reserve, original product gross and back-end gross are on this basis and are never rewritten when a later event posts.
As of 2025-12-31. What the store retained: original gross less every adjustment posted on or before that date. The as-of date is the last day anything measured happened in the export, never today’s date.
Adjustment period. Events grouped by the day they posted. The adjustment module is on this basis alone.
Why the period proxy rates are not loss rates
A chargeback rate on this page divides an amount posted in the selected period by the original gross of contracts sold in the selected period. Those are two different populations: the contracts charged back in a month are mostly not the ones written in it. The result is a period proxy, useful for watching the direction of travel, and it is not a contract-cohort loss rate. Computing a true cohort rate would need the full life of each cohort, and the reporting window truncates the tail of the adjustment lag distribution — which is also why the most recent sale months carry structurally fewer adjustments than the earliest ones.
Why each category has its own denominator
Penetration is only meaningful beside the population it was computed over. A GAP rate over all retail deliveries would count cash buyers who have no loan for GAP to cover, and would make every store with a heavier cash mix look worse for a reason that has nothing to do with its finance office. Each category is therefore measured against the deals eligible for it under one governed rule, the rule identifier is on every row, and both sides of the ratio are published. A category with no eligible deals shows “No eligible deals” rather than 0%, because a rate with no denominator is undefined and not zero.
What this page will not tell you
There is no benchmark and no target. ARPI publishes no industry F&I figures, so nothing here is good, bad, healthy or standard. A penetration of 40.7% is stated as 40.7%.
There is no recommendation. Nothing here suggests a product to sell, a price to charge, a customer to approach or a lender to use. ARPI approves nothing, declines nothing and tiers nobody.
There is no menu and no offer history. The model records what was sold, not what was offered and declined, so no closing rate is computable from it.
Manager rows are comparisons, not evaluations. They carry no ranking and no label, and below the governed minimum-deal floor a ratio is withheld: a one-deal penetration of 100% is a number that will be repeated and cannot be defended.