F&I
Granite Subaru · August 2025 · vs July 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 41 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
$12,280Deal date
An amount, never a rate. Zero on cash and lease deliveries.
KPI-FNI-001Reserve per retail unit
$300Deal date
Cash deliveries are inside this denominator and cannot earn reserve.
KPI-FNI-002Reserve against product
| Component | Deal-date gross | Share |
|---|---|---|
| Finance reserve | $12,280 | 29.5% |
| Original product gross | $29,312 | 70.5% |
| Other F&I income | $0 | 0.0% |
| Back-end gross | $41,592 | 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) | $41,592 |
|---|---|
| Cumulative product adjustments through 2025-12-31 | $1,657 |
| Retained F&I gross (as of 2025-12-31) | $39,935 |
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 August 2025. Shares are computed from summed counts, never averaged from store percentages.
Cash 7 deliveries, 17.1%; Retail Finance 29 deliveries, 70.7%; Lease 5 deliveries, 12.2%.
- Cash
- 17.1%7
- Retail Finance
- 70.7%29
- Lease
- 12.2%5
Read finance structure mix as a table
| Structure | Deliveries | Share of retail deliveries |
|---|---|---|
| Cash | 7 | 17.1% |
| Retail Finance | 29 | 70.7% |
| Lease | 5 | 12.2% |
| All retail deliveries | 41 | 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, August 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 36.6%, 15 of 41 eligible deals; GAP 34.5%, 10 of 29 eligible deals; Tire & Wheel 19.5%, 8 of 41 eligible deals; Prepaid Maintenance 23.1%, 6 of 26 eligible deals; Appearance Protection 12.2%, 5 of 41 eligible deals; Paintless Dent Protection 9.8%, 4 of 41 eligible deals; Theft or Security Product 12.2%, 5 of 41 eligible deals; Key Replacement 14.6%, 6 of 41 eligible deals; Lease Wear Protection 20.0%, 1 of 5 eligible deals; Other Aftermarket Product 12.2%, 5 of 41 eligible deals.
Vehicle Service Contract36.6%15 of 41
ELIG-VSC All retail deliveries
GAP34.5%10 of 29
ELIG-GAP Financed retail deliveries only
Tire & Wheel19.5%8 of 41
ELIG-TW All retail deliveries
Prepaid Maintenance23.1%6 of 26
ELIG-PPM New and certified retail deliveries only
Appearance Protection12.2%5 of 41
ELIG-OTH All retail deliveries
Paintless Dent Protection9.8%4 of 41
ELIG-OTH All retail deliveries
Theft or Security Product12.2%5 of 41
ELIG-OTH All retail deliveries
Key Replacement14.6%6 of 41
ELIG-OTH All retail deliveries
Lease Wear Protection20.0%1 of 5
ELIG-LWP Lease deliveries only
Other Aftermarket Product12.2%5 of 41
ELIG-OTH All retail deliveries
Read penetration by category as a table
| Category | Contracts | Deals with product | Eligible deals | Penetration | July 2025 | Change |
|---|---|---|---|---|---|---|
| Vehicle Service Contract | 15 | 15 | 41 | 36.6% | 48.6% | -12.1 percentage points |
| GAP | 10 | 10 | 29 | 34.5% | 46.4% | -11.9 percentage points |
| Tire & Wheel | 8 | 8 | 41 | 19.5% | 27.0% | -7.5 percentage points |
| Prepaid Maintenance | 6 | 6 | 26 | 23.1% | 7.7% | +15.4 percentage points |
| Appearance Protection | 5 | 5 | 41 | 12.2% | 8.1% | +4.1 percentage points |
| Paintless Dent Protection | 4 | 4 | 41 | 9.8% | 13.5% | -3.8 percentage points |
| Theft or Security Product | 5 | 5 | 41 | 12.2% | 16.2% | -4.0 percentage points |
| Key Replacement | 6 | 6 | 41 | 14.6% | 16.2% | -1.6 percentage points |
| Lease Wear Protection | 1 | 1 | 5 | 20.0% | 50.0% | -30.0 percentage points |
| Other Aftermarket Product | 7 | 5 | 41 | 12.2% | 16.2% | -4.0 percentage points |
Distinct deals, never contracts: one deal may carry two products in one category.
Adjustments
What came back, and when it posted
Adjustment events grouped by the day they posted, over August 2025. A positive amount reduced retained gross; a negative amount restored it.
Chargeback $976 over 1 events; Cancellation $301 over 1 events.
Chargeback$976reduces retained gross1 events
Cancellation$301reduces retained gross1 events
Adjustment-period basis. These amounts are not deal-date production and are never netted into it: the contracts charged back in a month are mostly not the ones written in it.
Events, contracts affected and the period proxy rate
| Event type | Events | Contracts affected | Amount | Period proxy rate |
|---|---|---|---|---|
| Chargeback | 1 | 1 | $976 | 3.33% |
| Cancellation | 1 | 1 | $301 | 1.03% |
| Net effect on retained gross | 2 | $1,277 |
A positive amount reduces retained gross; a negative one restores it, which is why reinstatements are negative and the four types sum to a net effect. Events are grouped by the date they posted: a chargeback in August against a contract written in June is an August event here, and the June contract keeps June’s gross.
The period proxy rate is not a loss rate. mixed-basis period proxy, not a contract-cohort loss rate
Adjustments by product category
| Product category | Events | Amount |
|---|---|---|
| Vehicle Service Contract | 2 | $1,277 |
What each category earned
| Product category | Contracts | Retail | Dealer cost | Original gross | Adjustments | Net gross | Gross per contract | Share of gross |
|---|---|---|---|---|---|---|---|---|
| Vehicle Service Contract | 15 | $20,416 | $10,748 | $9,668 | $301 | $9,367 | $645 | 33.0% |
| GAP | 10 | $6,704 | $2,071 | $4,633 | $1,287 | $3,346 | $463 | 15.8% |
| Tire & Wheel | 8 | $6,749 | $3,002 | $3,747 | None | $3,747 | $468 | 12.8% |
| Prepaid Maintenance | 6 | $2,393 | $1,362 | $1,032 | $69 | $963 | $172 | 3.5% |
| Appearance Protection | 5 | $3,310 | $1,172 | $2,138 | None | $2,138 | $428 | 7.3% |
| Paintless Dent Protection | 4 | $3,192 | $1,169 | $2,022 | None | $2,022 | $506 | 6.9% |
| Theft or Security Product | 5 | $1,318 | $424 | $893 | None | $893 | $179 | 3.0% |
| Key Replacement | 6 | $3,941 | $1,566 | $2,375 | None | $2,375 | $396 | 8.1% |
| Lease Wear Protection | 1 | $530 | $210 | $320 | None | $320 | $320 | 1.1% |
| Other Aftermarket Product | 7 | $3,984 | $1,501 | $2,483 | None | $2,483 | $355 | 8.5% |
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-00017 | Granite Subaru | 38 | 62 | $309 | $721 | 1.63 | $1,002 |
| No finance manager creditedInsufficient sample (n = 3) | Granite Subaru | 3 | 5 | — | — | — | — |
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.