Free Tool

Is This Pro Forma Actually Realistic?

Paste the seller's numbers. We check every claim against ICA, Ad Astra Equity, and Car Wash Advisory benchmarks — and flag what doesn't add up.

Enter the Seller's Claimed Figures

Use the numbers from the seller's pro forma, offering memo, or broker summary.

Monthly Churn Rate Benchmark: 7.6%
% / mo
% of members who cancel each month
Member Penetration Typical: 20–40%
%
Members ÷ monthly car count
Member ARPU Benchmark: $20–30
$ / mo
Avg revenue per active member per month
EBITDA Margin Benchmark: 30–45%
%
EBITDA ÷ total revenue
Asking EBITDA Multiple Typical: 5–8.5×
× EBITDA
Purchase price ÷ annual EBITDA (from OM or broker materials)
Score
0 passed
0 caution
0 flagged
Detailed Findings

Ready to model the full deal?

The free checker scores five inputs. The full underwriting model builds a 10-year levered IRR, SBA debt waterfall, DSCR, and stress-tests your churn and penetration assumptions against the same benchmarks — in a lender-ready Excel workbook.

Using Google Sheets instead of Excel?

The full model (.xlsx) imports cleanly into Google Sheets — all core formulas (PMT, IRR, CUMPRINC, SUMPRODUCT) are supported natively.

  • 1 Download the .xlsx model via the button above
  • 2 In Google Sheets, open File → Import, select Upload, and drop the file — choose "Replace spreadsheet"
  • 3 All formulas recalculate automatically. Edit the yellow Inputs cells to update every tab.
✓ PMT supported ✓ IRR supported ✓ CUMPRINC supported ✓ SUMPRODUCT supported ✓ Nested IF supported