Boat Dealership Acquisition, Floorplan and DSCR Model   Excel template (XLSX)
$99.00

Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Boat Dealership Acquisition, Floorplan and DSCR Model (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

Boat Dealership Acquisition, Floorplan and DSCR Model – Excel XLSX

Excel (XLSX) + supplemental PDF

$99.00
A boat dealership is four businesses under one roof: new and used iron makes 79% of revenue while F&I and fixed ops make 48% of the gross, and a normal unit down-cycle takes DSCR from 1.55x to 0.89x.
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, new boats, used boats, F&I per deal times finance penetration, parts and service, so the mix shows that about 48% of the gross comes from F&I and fixed ops.
  2. Floorplan interest is a real engine, not a plug: average inventory at cost times advance rate times floorplan rate, with days-in-stock and the rate as stressable drivers in a dedicated DSCR grid.
  3. A normal marine down-cycle of minus 20% units is pushed through fixed overhead: SDE falls about 30% and a comfortable 1.55x DSCR breaks to 0.89x, the test a good-year P&L never runs.

MARINE & BOATING EXCEL DESCRIPTION

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

This is a lender-ready five-year model for buying a single-store boat or marine dealership with an SBA 7(a) loan. It is built around the two lines most dealership templates leave out: the boat floorplan interest and the fixed-operations absorption ratio. The premise is that a dealership is four businesses under one roof, and the iron is not where the money is.

Revenue and gross profit are built bottom-up by department: new boats, used boats, F&I priced per deal times finance penetration, and parts and service. Each department carries its own margin, so gross profit falls out of the mix rather than being assumed. In the base case the new and used iron make about 79% of revenue while the F&I and service departments make about 48% of the gross profit. That is the honest dealership thesis, and the model prices it. The revenue split tracks the public marine consolidators, with OneWater FY2025 at 62% new, 19% used, 16% service and parts, and 3% F&I.

The floorplan is modelled explicitly and kept separate from the acquisition loan, because it is a different facility carrying a different risk. Boat inventory is financed on a revolving line at roughly 100% of invoice at about 5-8%. Floorplan interest is computed as average inventory at cost times the advance rate times the floorplan rate, where average inventory equals unit cost times days-in-stock divided by 365. Days-in-stock and the floorplan rate are stressable drivers, since that is the carrying cost that explodes when rates rise and boats stop moving. Marine inventory turn averages roughly 1.0x, while a healthy dealer runs about 2.3x.

The headline is the down-cycle rather than the base case. Base-case DSCR looks comfortable at 1.55x, because the acquisition loan is small relative to cash flow and the inventory risk sits in the floorplan instead. So the model runs the test a seller's good-year P&L never will: a normal marine unit down-cycle of minus 20% volumes, and boat sales fell about 20% in 2009, pushed through fixed overhead. SDE falls by roughly 30% and DSCR drops to 0.89x. Boats are discretionary and cyclical, so the bankable story is fixed-ops absorption, floorplan discipline and the down-cycle, not a leverage-amplified cash-on-cash.

You get 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 (outboard and pontoon, full-line and cruiser, 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 73.6%, floorplan interest coverage at 10.5x, a DSCR stress grid across days-in-stock and floorplan rate, and a conservative five-year exit. Every formula is recomputed by three independent engines, 67 checks in total.

SDE margin is held at a realistic 5%, because boat dealers run thin. Units-per-store and the revenue split are industry-representative estimates drawn from OneWater and MarineMax public filings. The cash-on-cash and the 4.19x 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: verify the seller's tax returns, the floorplan agreement and your SBA term sheet before relying on any number.

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 Marine & Boating, Integrated Financial Model Excel: Boat Dealership Acquisition, Floorplan and DSCR Model Excel (XLSX) Spreadsheet, ProformaWorks


$99.00
A boat dealership is four businesses under one roof: new and used iron makes 79% of revenue while F&I and fixed ops make 48% of the gross, and a normal unit down-cycle takes DSCR from 1.55x to 0.89x.
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

 
"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting
 
"[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
 
"I am extremely grateful for the proactiveness and eagerness to help and I would gladly recommend the Flevy team if you are looking for data and toolkits to help you work through business solutions."

– Trevor Booth, Partner, Fast Forward Consulting
 
"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
 
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
 
"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Senior Executive Director at Technology Transformation Advisory
 
"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 a small business owner, the resource material available from FlevyPro has proven to be invaluable. The ability to search for material on demand based our project events and client requirements was great for me and proved very beneficial to my clients. Importantly, being able to easily edit and tailor "

– Michael Duff, Managing Director at Change Strategy (UK)



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.