Blog · Finance metrics and formulas · Finance and FP&A teams
Auto dealership financial statement analysis connects department profit with vehicle inventory, floorplan borrowing and cash. Follow a worked monthly statement, spreadsheet formulas and the reconciliations that explain why profit can rise while cash falls.
Auto dealership financial statement analysis starts with departmental gross profit, then follows vehicle inventory and floorplan debt through to cash. Compare new vehicles, used vehicles, parts and service separately before reading the dealership total. The final check is whether the reported profit and balance-sheet movements explain the change in cash.
Use a closed monthly dealer statement, the trial balance, department sales and cost exports, inventory listings and floorplan statements. Choose the same store, reporting period and accounting basis throughout. Preserve account numbers and department codes so a reviewer can trace each subtotal.
Distinguish customer-pay, warranty and internal repair orders. Internal work transferred into vehicle inventory must not also become an external dealership sale. Keep finance-and-insurance, or F&I, net fees separate from vehicle selling prices and from customer loan principal.
The link between reports matters: NADA's fixed-operations training uses dealer financial statements and dealership management system reports together to examine service and parts performance. A statement identifies the movement; repair orders and inventory records help explain it. For the broader reporting package, use the monthly financial report layout.
Consider an illustrative Ohio dealership for September 2026. These are simplified external sales after internal eliminations. F&I is presented as net fee revenue; its payroll and other selling expenses sit below gross profit. The zero direct-cost row therefore does not mean F&I has no operating costs.
| Department | Revenue (USD) | Cost of sales (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|
| New vehicles | 4,000,000 | 3,760,000 | 240,000 | 6.0% |
| Used vehicles | 2,000,000 | 1,760,000 | 240,000 | 12.0% |
| Parts | 400,000 | 240,000 | 160,000 | 40.0% |
| Service | 600,000 | 180,000 | 420,000 | 70.0% |
| F&I net fees | 200,000 | 0 | 200,000 | 100.0% |
| Total | 7,200,000 | 5,940,000 | 1,260,000 | 17.5% |
With headings in row 1 and departments in rows 2 through 6, calculate columns D and E and fill down:
=B2-C2
=IF(B2=0,"",D2/B2)
The total margin is weighted by revenue:
=SUM(D2:D6)/SUM(B2:B6)
It is $1,260,000 divided by $7,200,000, or 17.5%. Do not average the five department percentages. The gross profit margin method explains that denominator in detail.
Tie revenue and cost totals back to the trial balance before assigning causes. Compare each department with its own budget and prior month under the same account mapping. Higher service margin alone does not establish that the service department earns more final profit; payroll and allocated overhead still matter.
Keep floorplan interest visible rather than burying it inside a vehicle margin without explanation. This example uses the following statement presentation:
| Earnings bridge | Amount (USD) | Calculation |
|---|---|---|
| Gross profit | 1,260,000 | Department total above |
| Operating expenses, including depreciation of 40,000 | 1,000,000 | Expense export |
| Operating income | 260,000 | 1,260,000 - 1,000,000 |
| Floorplan interest expense | 60,000 | Lender and accrual schedule |
| Other interest expense | 10,000 | Debt schedule |
| Pretax income | 190,000 | 260,000 - 60,000 - 10,000 |
| Income tax expense | 50,000 | Supplied tax provision |
| Net income | 140,000 | 190,000 - 50,000 |
The tax provision is a supplied accounting amount, not a tax-rate estimate. Review manufacturer assistance and incentives under the controller's policy before comparing stores. For example, AutoNation's inventory and floorplan note describes inventory cost reductions for certain manufacturer amounts and explains why floorplan liabilities can differ from inventory costs.
Use inventory carrying values, not advertised retail prices. Assume no acquisitions, write-downs or noncash inventory adjustments in this example.
| Inventory | Opening (USD) | Closing (USD) | September cost of sales (USD) | Increase (USD) | Closing days at September cost rate |
|---|---|---|---|---|---|
| New vehicles | 3,600,000 | 4,000,000 | 3,760,000 | 400,000 | 31.9 |
| Used vehicles | 1,400,000 | 1,600,000 | 1,760,000 | 200,000 | 27.3 |
| Parts | 300,000 | 360,000 | 240,000 | 60,000 | 45.0 |
| Total inventory | 5,300,000 | 5,960,000 | 5,760,000 | 660,000 | — |
Service labor is excluded from inventory cost of sales. For this table, with opening in B, closing in C and cost of sales in D:
=C2-B2
=IF(D2=0,"",C2/D2*30)
Days use September's 30 calendar days, rounded to one decimal; they measure supply at the current cost rate. NADA's formula guide also describes used-vehicle supply in dollars, but uses working days. Keep the day basis explicit when comparing reports.
Floorplan debt rises from $3,800,000 to $4,250,000, an increase of $450,000. Closing vehicle inventory is $5,600,000, leaving $1,350,000 above that debt balance. This difference is a funding observation, not a lender compliance test. Match vehicles to lender records and inspect sold vehicles awaiting repayment, unfunded units and aging separately.
Assume all floorplan borrowing here is non-trade borrowing classified as financing, with no other cash movements. AutoNation's cited note distinguishes operating cash flows for trade floorplan changes from financing cash flows for non-trade changes; follow the actual arrangement and statement policy.
| Cash bridge | Change (USD) |
|---|---|
| Net income | 140,000 |
| Add back depreciation | 40,000 |
| Increase in inventory | -660,000 |
| Increase in operating receivables | -30,000 |
| Increase in operating payables and accruals | 80,000 |
| Operating cash flow | -430,000 |
| Cash capital spending | -100,000 |
| Net floorplan borrowing | 450,000 |
| Cash change | -80,000 |
| Opening cash | 500,000 |
| Closing cash | 420,000 |
The bridge reconciles $500,000 less $80,000 to $420,000 at the bank. Avoid counting a floorplan movement in both operating and financing cash flows. A full financial analysis should keep profitability and funding conclusions connected.
The general manager owns the action list; department managers own pricing, aging and expense follow-up, while the controller owns reconciliation. Assign each material movement an owner and a date for checking its effect.
Bring your department statement, inventory schedule and floorplan workbook to Covirage: it maps the columns, and its tools compute and check the supplied margins and balance movements. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for finance teams for the supporting reporting use case.
The departments have different acquisition costs, reconditioning needs and selling patterns. Separate revenue and cost of sales before comparing margins, and keep manufacturer incentives on consistent lines. A combined vehicle margin can conceal a weaker used-car result behind stronger new-car volume.
No. Floorplan borrowing finances inventory and creates a liability. Vehicle sales create revenue under the company's accounting policy. Review borrowing, repayments and interest separately so that additional financing does not appear to improve sales or departmental gross profit.
Profit includes sales that have not yet been collected and excludes unsold inventory purchases from current cost of sales. Inventory growth, receivable growth, capital spending and loan repayments can consume cash even when the income statement reports a profit.
Bring the inventory listing by vehicle identification number, floorplan lender statements, deal and repair-order summaries, receivable aging and bank reconciliation. They let the controller test statement totals against the underlying vehicles, customer balances and borrowing rather than relying on a summary alone.