Powersports Dealership Acquisition & SBA Underwriting Financial Model (Excel + Google Sheets)

Revenue is built by line — new units, used units, parts & accessories (PG&A), F&I and rental — each carried at its own gross margin, so blended gross profit falls out of the mix. The differentiator no template shows: the floorplan interest engine (average inventory at cost x advance x rate, where inventory = unit COGS x days-in-stock/365) and the fixed-ops absorption ratio (parts & service gross over fixed overhead) — with TWO distinct debts modelled separately: the SBA 7(a) acquisition loan and the floorplan line.

The honest headline is the down-cycle DSCR. Because the acquisition loan is small relative to cash flow, the base DSCR looks comfortable (1.65x) — but a normal volume down-cycle (-20%) drives SDE down 34% through the fixed overhead and pushes coverage to 0.88x, below the lender's floor. That, not a rosy cash-on-cash, is what a buyer must survive. Includes a 3-part SBA 7(a) capital stack with a full-standby vs amortizing seller-note toggle, three store profiles, a 5-year P&L, returns and a dashboard. 11 sheets, machine-verified across three engines, Excel and Google Sheets, with a 24-page PDF guide. SDE margin held at an honest 7.9%. Educational planning tool, not financial advice.