10-year Financial Projections, 5-year Financial Projections, Accounting, Annual Recurring Revenue (ARR), Business Plans, Business Valuation, Cap Table, Cash Flow Analysis, Cash Flow Projections, CFO, Chart, DCF Model, Debt Amortization, Debt Schedule, Debt Service Coverage, Developers, Discount Rate, Excel, Financial Analysis, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Statements, Forecast, Forecasting, Franchise Model, Income Statement, Investing Cash Flows, Investor Cash Flows, Investors, IRR (Internal Rate of Return), Joint Venture, Know-How, Mortgage, NPV (Net Present Value), Pricing, Pricing Analysis, Private Equity, Pro-Forma, Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Terminal Value, Three Statement Model | Three Financial Statements, Venture Capital

Video Overview:

Plan, finance, and scale new developments and acquisitions over up to 10 years—month by month.

What this model does

This spreadsheet is built to analyze the rollout of multiple car washes over time. You can configure two location types—New Developments and Acquisitions—and scale as fast or as cautiously as you like. It’s designed to answer the questions banks and investors ask: How much capital is required and when? What returns are achievable under the plan? How will debt be drawn, serviced, and repaid?

To do that, the model uses precise timing assumptions that show:

How much cash and/or debt you’ll need and exactly when you’ll need it,
How locations ramp and contribute cash over time, and
What returns (IRR, ROI, equity multiple) are possible under your assumptions.

Who it’s for

Owner‑operators planning greenfield builds or roll‑up strategies
Investors & lenders underwriting a growth plan with staged openings
Finance teams needing a bank‑ready, fully integrated 3‑statement model

Key features (at a glance)

Up to 10‑year model period with monthly granularity and annual roll‑ups.
Two scalable location types: New Developments and Acquisitions.
Expansion schedule by cohort: define the number of new locations starting each month for each type.
Dynamic financing:
- New developments: construction/interest‑only loan with automatic conversion to permanent financing.
- Acquisitions: mortgage‑style amortizing loan.
Capex schedules by cohort: split financed vs. non‑financed costs; timing aligns with each monthly start.
Revenue engine for single‑use washes and membership washes (price, mix, and volume‑driven).
Operating costs: variable cost per car plus fixed costs per location that scale automatically as counts grow.
Investor/owner returns: IRR, ROI, equity multiple with clear cash waterfall logic.
KPIs & charts: track cars per site, average revenue and cost per car, per‑location metrics, growth curves, and more.
Debt Service Coverage Ratio (DSCR): monthly and annual views to support lender diligence.
Fully integrated 3‑statement model: live‑linked Income Statement, Balance Sheet, and Cash Flow that update as assumptions change.

How the model works (methodology)

1) Monthly cohort build

Each month’s openings (for both New Developments and Acquisitions) form a cohort. Every cohort has its own capex timing, financing draws, revenue ramp, and cost structure. This approach lets you see exactly how the opening cadence drives capital needs and cash generation.

2) Financing logic

New Developments:
- Interest‑only (I/O) / construction phase during build.
- Automatic conversion to a permanent loan upon stabilization or at the scheduled conversion date.
- Financed vs. non‑financed capex is configurable; interest accrues only on financed draws.
Acquisitions:
- Mortgage‑style amortization (principal + interest) from day one.

3) Revenue & costs

Revenue is driven by single‑use tickets and memberships. Assumptions can include volumes, pricing, and mix by location type (and can differ for developments vs. acquisitions).
Variable costs are modeled per car, while fixed costs per site (labor, utilities, rent/ground lease, etc.) scale automatically with total open locations.

4) Monthly cash‑flow build‑up

A detailed cash build shows how much of your expansion can be funded from operating cash vs. new debt/equity. The timing of new starts relative to the maturity of cash‑producing cohorts makes the trade‑off clear: grow faster with more external funding or pace openings to self‑fund.

5) Minimum equity solve + distribution logic

The model solves for the minimum upfront investment based on the absolute lowest cumulative cash position reached across the timeline.

IRR is then calculated assuming that minimum equity is invested up front,
and only positive cash flows beyond that minimum cash trough are treated as distributable to equity.
This mirrors how operators and lenders think about cash floors and ensures returns reflect the true peak funding need.

6) Returns & lender metrics

Equity Returns: IRR, ROI, and equity multiple produced on a consolidated basis.
DSCR: Cash available for debt service vs. scheduled debt service by period, with flags when coverage tightens.
Bankability: Clean schedules for sources & uses, debt balances, interest, and amortization.

What you can configure (inputs)

Timeline & growth

Model length (up to 10 years, monthly)
Monthly start counts for New Developments and Acquisitions

Capex & project costs

All‑in cost per location (by type)
Financed vs. non‑financed percentages
Capex timing by cohort (draw curve)

Financing terms

For developments: I/O period, rate, fees, and conversion to permanent (rate, amortization, term)
For acquisitions: mortgage rate, amortization, term
Optional leverage and equity share assumptions

Revenue & operations

Ticket price and volume for single‑use
Membership price and membership mix
Variable cost per car; fixed cost per location
Opening/ramp assumptions (if applicable)

Other

Taxes, inflation/escalators, working capital ideas (if applicable to your use case)

Note: You can keep it simple at first—enter a few core drivers—and then layer in detail as you refine the plan.

Core outputs & dashboards

Cash needs & sources over time (equity, construction debt, permanent debt)
Cumulative cash position chart highlighting the minimum cash trough
Location count over time by type; cars per site and aggregate volumes
Revenue & margin per car and per location
3‑Statement financials (Monthly & Annual)
Debt schedules: draws, accrued interest, conversions, amortization
Returns: IRR, ROI, equity multiple (equity view)
Covenants: DSCR trajectory with visual alerts

Questions this model helps you answer

How many sites can we open each quarter without raising more equity?
If we finance X% of development costs, what is the minimum equity required?
How does switching from 2 to 4 openings per quarter affect DSCR, cash trough, and IRR?
What mix of memberships vs. single‑use gets us to our target per‑site EBITDA?
When does operating cash start to fund the next cohort (vs. requiring debt)?

Why lenders and investors like it

Timing‑accurate cash view: funding, drawdowns, conversions, and paydowns are explicit.
Cohort transparency: each month’s openings have their own economics and capex timing.
Bankability: DSCR, fully linked 3‑statements, and an unambiguous return framework.

How to get value fast (suggested workflow)

Enter a simple expansion plan (e.g., 1–2 openings per quarter by type).
Plug in round‑number capex and baseline financing terms.
Add revenue & cost assumptions (ticket prices, membership mix, variable cost/car, fixed/site).
Review the Cash Trough and Minimum Equity.
Iterate on pace, financing percentages, and membership strategy until returns and DSCR meet your targets.

Notes on IRR & distributions (important)

The model treats the single largest cumulative cash deficit as the required equity (invested up front for return calculations).
Distributions only occur once the model is above that minimum cash threshold, ensuring IRR reflects a realistic cash floor.
If future periods dip again below that threshold, the logic treats that as part of the original equity requirement rather than new re‑ups (consistent with the minimum‑equity approach).

Deliverable

A professional, Excel‑compatible financial model with instructions and clearly labeled inputs/outputs. Built for transparency, auditability, and lender/investor review.

You must log in to submit a review.