Laundromat Acquisition and SBA Underwriting Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Underwrites an existing laundromat the way an SBA 7(a) lender does, testing cash flow available for debt service against the 1.25x coverage gate.
2. Sizes the capital expenditure reserve from the age of the actual machine fleet, exposing the replacement bill that a flat percentage of revenue hides.
3. Reconstructs Seller's Discretionary Earnings from the P&L and prices the deal against the market multiple band, with cash-on-cash and a five-year IRR.

M&A (MERGERS & ACQUISITIONS) EXCEL DESCRIPTION

Laundromat Acquisition and SBA Underwriting Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

You found a laundromat for sale. The seller has a price. The SBA lender has questions. This workbook is how you answer them before you sign anything.

This is not a generic laundromat calculator. It is an acquisition underwriting model, built around the logic a lender applies to a 7(a) loan on an existing store.

Revenue is built machine by machine. You enter washer and dryer groups with their counts, vend prices and turns per day, rather than one invented monthly average. That structure matters, because it also drives the part most models hide: the age-based capital expenditure reserve. Each equipment group carries its remaining useful life and its replacement cost, so an aging fleet shows the bill it will hand you in years three to seven, instead of disappearing inside a flat percentage of revenue.

From there the workbook reconstructs Seller's Discretionary Earnings from the profit and loss statement, shows the implied multiple you are paying against the market band, and applies the test that decides the deal: debt service coverage. Cash flow available for debt service is calculated as SDE less owner compensation and reserves, divided by annual debt service, then compared with the 1.25x threshold, returning a clear bankable or not bankable verdict. Cash-on-cash return and a five-year internal rate of return follow, with an exit at a multiple you choose.

Two sensitivity grids show where the deal breaks: coverage under revenue and utility-cost shocks, and cash-on-cash under revenue and equity-injection shocks.

The file is a ten-sheet Excel workbook with no macros, no add-ins and no external links, so it also opens in Google Sheets. A START HERE sheet walks you through your first underwrite in about ten minutes, with only the input cells unlocked. A benchmarks sheet carries sourced market multiples, operating-cost ratios, equipment pricing and current SBA terms, each with its reference, so you can see which assumptions are documented and which are yours to set.

The second document included with this purchase is a sixteen-page PDF user guide: quick start, a sheet-by-sheet walkthrough, how a lender reads your coverage ratio, how the age-based reserve works, and where to find the real numbers for the deal in front of you.

Source: Best Practices in M&A (Mergers & Acquisitions), Laundromat, Integrated Financial Model Excel: Laundromat Acquisition and SBA Underwriting Model Excel (XLSX) Spreadsheet, ProformaWorks