Powersports Dealership Acquisition and Floorplan Model   Excel template (XLSX)
$99.00

Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Log in to unlock full preview.
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Powersports Dealership Acquisition and Floorplan Model (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen. Unlock all 9 preview images:   Login Register

Powersports Dealership Acquisition and Floorplan Model – Excel XLSX

Excel (XLSX) + supplemental PDF

$99.00
Gross is split across new units, used, F&I and fixed ops, with floorplan interest carried on days-in-stock: a comfortable 1.65x DSCR breaks to 0.88x when a normal down-cycle takes 20% of unit volume.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

  1. Gross profit is built department by department, which is how the base case shows new and used units making about 72% of revenue while F&I and fixed operations produce roughly 60% of the gross profit.
  2. Floorplan interest is modelled explicitly from unit cost, days-in-stock and the advance rate, kept separate from the acquisition loan, with a DSCR stress grid across days-in-stock and floorplan rate.
  3. A 20% unit-volume down-cycle pushed through fixed overhead cuts SDE by about 34% and takes DSCR from 1.65x to 0.88x, which is the test a seller's good-year P&L never runs.

INTEGRATED FINANCIAL MODEL EXCEL DESCRIPTION

Powersports Dealership Acquisition and Floorplan Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This is a five-year acquisition underwrite for buying a single-store powersports dealership, motorcycle, ATV, UTV, personal watercraft or snowmobile, with an SBA 7(a) loan. The template market has plenty of operating forecasts for starting a dealership; this one prices a purchase.

The valuation error it intercepts is treating a dealership as one revenue blob. A dealership is four businesses under one roof, and the iron is not where the money is. Revenue and gross are built bottom-up by department, new units, used units, F&I (gross per deal times finance penetration) and parts, gear and service, each at its own margin, so gross profit falls out of the mix. In the base case the new and used iron account for about 72% of the revenue while F&I and fixed operations produce about 60% of the gross profit. The revenue split tracks the public powersports consolidators, with RideNow in Q2 2025 running roughly 52% new, 20% used, 18% parts and service and 9% F&I, against a thin new-unit gross margin of about 13%.

The second thing the model makes explicit is the floorplan. Unit inventory is financed on a revolving floorplan line, separate from the acquisition loan, at roughly 100% of invoice and around 7% to 10%. Floorplan interest is computed as average inventory at cost times the advance rate times the floorplan rate, where average inventory is unit cost times days-in-stock divided by 365. Powersports turns fast, motorcycles roughly 6 to 10 times and ATV/UTV roughly 6 to 8 times, so in a good year the carrying cost is small, but days-in-stock and the floorplan rate are stressable drivers, and aging inventory in a soft market is what turns a profitable lot into a loss.

The honest headline is the down-cycle. Base-case DSCR looks comfortable at 1.65x because the acquisition loan is small relative to cash flow; the inventory risk sits in the floorplan, not the loan. So the model runs the test the seller's good-year P&L never will: a 20% drop in unit volumes pushed through fixed overhead cuts SDE by about 34% and drops DSCR to 0.88x. For reference, in 2008-09 on-road units fell as much as 44% and units, parts and service fell more than 20%, and motorcycles fell about 8% in 2025.

Inside: an 11-sheet Excel workbook that works in Google Sheets with no macros, add-ins or external links, a PDF user guide, a three-way profile toggle (off-road and ATV/UTV, on-road and V-twin, used and fixed-ops heavy), an SBA 7(a) capital stack with the 10% injection and $5M cap checks, a real amortisation schedule, the fixed-ops absorption ratio at 62.1% in the base case against the roughly 64% average that is the buyer's value-add lever, floorplan interest coverage, a DSCR stress grid across days-in-stock and floorplan rate, and a conservative five-year exit with the equity multiple. Every formula is recomputed by three independent engines, 67 of 67 checks passing.

What the model does not claim: SDE margin is held at about 7.9% because powersports dealers run thin; units per store and the revenue split are industry-representative estimates drawn from public filings and real listings; cash-on-cash and the equity multiple are stated as leverage-amplified and cyclical; and there is deliberately no IRR. Educational planning tool, not financial, investment, tax or lending advice.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Integrated Financial Model Excel: Powersports Dealership Acquisition and Floorplan Model Excel (XLSX) Spreadsheet, ProformaWorks


$99.00
Gross is split across new units, used, F&I and fixed ops, with floorplan interest carried on days-in-stock: a comfortable 1.65x DSCR breaks to 0.88x when a normal down-cycle takes 20% of unit volume.
Add to Cart
  

ABOUT THE AUTHOR

Author image
Author: ProformaWorks
Additional documents from author: 43

ProformaWorks builds acquisition-grade financial models for Main Street and lower-middle-market businesses - the kind of deal financed with an SBA 7(a) loan or a small commercial facility.

Every model answers one question: does this deal pencil at the bank? That means SDE or NOI rebuilt from the seller's own numbers, the add-backs a lender will and will not accept, a debt-service ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
 
"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I "

– Nishi Singh, Strategist and MD at NSP Consultants
 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"Flevy.com has proven to be an invaluable resource library to our Independent Management Consultancy, supporting and enabling us to better serve our enterprise clients.

The value derived from our [FlevyPro] subscription in terms of the business it has helped to gain far exceeds the investment made, making a subscription a no-brainer for any growing consultancy – or in-house strategy team."

– Dean Carlton, Chief Transformation Officer, Global Village Transformations Pty Ltd.
 
"[Flevy] produces some great work that has been/continues to be of immense help not only to myself, but as I seek to provide professional services to my clients, it gives me a large "tool box" of resources that are critical to provide them with the quality of service and outcomes they are expecting."

– Royston Knowles, Executive with 50+ Years of Board Level Experience
 
"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me "

– Bill Branson, Founder at Strategic Business Architects
 
"As a consulting firm, we had been creating subject matter training materials for our people and found the excellent materials on Flevy, which saved us 100's of hours of re-creating what already exists on the Flevy materials we purchased."

– Michael Evans, Managing Director at Newport LLC
 
"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for "

– Jim Schoen, Principal at FRC Group



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.