I Analyzed a $900k Car Wash for Sale: Here's What It's Worth

One of the new services I'm offering at SmartHelping is a deal screener for buyers of $500k to $10M small businesses. I'll walk through a potential deal with buyers and run all the data through a template like you see below. Note, in the video there are many variables and parts that I can't complete unless it was an actually real-world engagement where there was more due diligence available from the seller and NDAs were signed. However, you can see the detailed process.

Here's a pre-built financial model for car wash startups to work from and here are more templates for the automotive industry in general.

In the above deal, there was $325k of gross revenue and $180k in annual adjusted net income. The listing also labels that $180k as EBITDA so if I were actually doing pre-diligence work on this it is important to understand what the seller's adjustments are as that can dramatically effect the potential valuation. The real estate was included in the purchase.

It was labeled as an 'absentee ownership' situation (the owner was not involved in doing any work that involves a salary) so the $180k figure may be close to the actual cash the buyer can expect as a return per year if nothing changes. In the video I put in some fictional 'earnings adjustments' to show how that may effect the deal metrics.

At a purchase price of $900k, that means you are buying in at roughly a 2.76x multiple of revenue and 5x EBITDA. Without knowing much else as far as required renovations / repairs or other things that could raise initial costs or effect ongoing operations, the purchase price needs to come down to $700/800k. 

That price suggestion is only my opinion and some things that may make the original purchase price make sense is if the buyer thinks they can raise sales and EBITDA substantially over a few years. Big factors include the feasibility of growing memberships, improving equipment / parking lot / features / POS upgrades / marketing and so forth. If you can double sales, that means your stabilized going-in revenue multiple may get down to 1.38x instead of 2.76x.

At the end of the day you want to know the hassle you are taking on, the expected amount of time it will take to pay off the initial investment with earnings, and if sales are trending in the right direction or there is clear opportunity to be able to make that happen.

The risk is in the leverage. If you only put down 20/25%, it could mean larger returns on the actual invested capital, but if operations are slow to start and your debt coverage is getting close to 1 or negative, there is risk of losing it. That just speaks to the durability of revenues and any unforeseen costs.

In the analyze process, I also look at many qualitative and risk factors that are more of a judgement call rather than directly related to the numbers. This gives a more comprehensive view of the target business for the buyer as they try to get a feel for the potential acquisition.

In my analysis process, there will be an overall deal score, and individual deal scores for:
  • Financial Performance
  • Valuation & Returns
  • Debt & Downside Protection
  • Revenue / Customer Quality
  • Operational Quality
  • Management / Owner Dependence
  • Market & Competitive Position
  • Deal / Diligence Risk
If you are looking at potential car washes to buy and what pre-diligence insights, check out my deal analysis services.

10-Year Cellphone Network Provider Financial Model

SmartHelping / Telecom / Excel

Cellphone Network Provider Financial Model

Forecast site deployment, subscriber cohorts, ARPU, churn, network costs, capital investment, financing and enterprise value across a complete 120-month operating plan.

10-year forecast Monthly subscriber cohorts Connected 3 statements DCF and football field
Cellphone network provider financial model
$110 One-time purchase / Excel download
Add Cellphone Network Provider Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

See the model in action

Walk through the subscriber engine, network rollout and financial outputs.

See how operating assumptions move through subscriber cohorts, capacity, infrastructure spending, financing, connected financial statements and valuation.

Open the model overview presentation

Use the presentation alongside the video for an overview of the model's structure, primary drivers and key outputs.

Subscriber economics

Build recurring revenue from customer-level drivers.

Connect acquisition channels, installed capacity, retention, ARPU and usage costs to the lifetime economics of the subscriber base.

01 / ACQUISITION CHANNELS

Model three sources of new subscribers

Forecast paid, organic or referral, and partner-generated subscriber additions separately, with paid additions driven by marketing spend and customer acquisition cost.

02 / COHORT RETENTION

Build monthly subscriber cohorts

Treat each month's new subscribers as a separate cohort with churn driven by customer age and retention behavior instead of applying one churn rate to the entire base.

03 / CAPACITY CONSTRAINTS

Connect activations to the network

Calculate subscriber demand first, then limit actual new activations to the installed capacity available from the network rollout.

04 / RECURRING REVENUE

Forecast ARPU-driven service revenue

Use average active subscribers and average revenue per user to calculate recurring service revenue throughout the 120-month forecast.

05 / VARIABLE COSTS

Follow the cost of serving each subscriber

Model data usage and cost per gigabyte, roaming, interconnection, billing, payment processing, regulatory charges, support, bad debt, refunds, SIMs and activation fulfillment.

06 / CONNECTED FINANCIALS

Move monthly operations into three statements

Aggregate the monthly operating forecast into connected annual income statements, balance sheets and cash flow statements across all 10 years.

07 / FUNDING AND DEBT

Test the capital structure

Model scheduled equity, capped backstop equity, a construction facility, term debt and a revolving credit facility with interest, fees and principal repayment.

08 / VALUE AND KPIs

Evaluate performance and enterprise value

Review subscriber, utilization, margin and leverage KPIs alongside DCF valuation, a football field, sensitivity analyses and integrated model checks.

Network deployment

Connect subscriber demand to installed capacity.

The rollout schedule determines how quickly the network can activate users, how intensively the infrastructure is used and when additional capital investment is required.

Site rollout

Schedule network sites over time and translate each deployment into installed subscriber capacity available to support new activations.

Capacity utilization

Compare active subscribers and attempted activations with installed capacity to identify constraints and the timing of future expansion.

Infrastructure capex

Model spectrum, sites, core systems, maintenance and other network investments, then connect their timing to depreciation and amortization schedules.

Fixed operating costs

Layer network and corporate operating expenses onto subscriber contribution to see when scale begins to cover the company's fixed cost base.

How to use it

Move from rollout assumptions to enterprise value.

  1. Set the commercial assumptions

    Enter acquisition spending, CAC, organic and partner additions, ARPU, churn, data usage and the variable costs required to serve subscribers.

  2. Plan the network rollout

    Schedule site deployments, installed capacity, infrastructure spending, maintenance and fixed network operating expenses.

  3. Structure the financing

    Configure equity, construction debt, term financing, revolving credit, minimum liquidity and the limits available for each funding source.

  4. Review the economics and value

    Analyze statements, subscriber KPIs, funding requirements, CFADS, DSCR, leverage, sensitivities and enterprise value under alternative assumptions.

Funding, debt capacity and valuation

See what the rollout requires—and what the completed network may be worth.

The model separates financing sources, identifies unsupported cash shortfalls and evaluates the operating business independently of its capital structure.

01 / EQUITY

Schedule planned and backstop funding

Enter scheduled equity contributions and include a capped contingency equity backstop when the business needs additional liquidity.

02 / CONSTRUCTION FACILITY

Fund the network as it is deployed

Draw construction financing alongside eligible investment and calculate outstanding balances, available capacity, interest and facility fees.

03 / TERM DEBT AND REVOLVER

Model refinancing and operating liquidity

Forecast term-debt principal repayment, refinancing and revolver use while maintaining the selected minimum cash balance.

04 / CREDIT METRICS

Review debt-service capacity

Track CFADS, DSCR, leverage, facility utilization and headroom to identify periods of potential financing pressure.

05 / UNLEVERED DCF

Value operations before financing

Calculate enterprise value from unlevered free cash flow using WACC, midyear discounting and formula-driven terminal value assumptions.

06 / TERMINAL VALUE

Compare two terminal approaches

Evaluate both perpetual-growth and exit-EBITDA-multiple terminal values within the discounted cash flow analysis.

07 / FOOTBALL FIELD

Cross-check value from several perspectives

Compare DCF, exit multiple, revenue, subscriber and replacement-cost valuation methods in one summary.

08 / SENSITIVITIES

Test the assumptions that matter

Measure how WACC, terminal growth, ARPU and variable network costs affect enterprise value and long-term profitability.

Who gets value from it

Built for facilities-based mobile network analysis.

Network founders

Plan deployment, subscriber growth, operating scale, financing needs and the total capital required before the network becomes self-funding.

Telecom investors

Evaluate subscriber economics, infrastructure requirements, downside cases, capital structure and enterprise value.

Lenders

Review facility utilization, CFADS, DSCR, leverage, principal repayment, refinancing needs and financing headroom.

Management and advisors

Support strategic planning, business plans, fundraising materials, lender presentations and investor diligence with one connected forecast.

Also available in these bundles

Need models for more than one business?

This cellphone network provider model is included in the following collections. Compare the bundles if you want a broader set of financial modeling tools.

Related financial models

Questions before you choose

A few useful details.

What type of mobile network does the model cover?

It is designed around a facilities-based mobile network operator with site rollout, installed capacity, infrastructure investment and financing requirements.

How is subscriber churn modeled?

Each month's new subscribers form a separate retention cohort with churn driven by customer age and retention behavior.

Can subscriber growth exceed network capacity?

No. Subscriber demand is calculated first, but actual activations are constrained by installed network capacity.

How does the model handle financing shortfalls?

It uses operating cash flow, debt and scheduled equity before calculating a capped equity backstop. Any remaining gap produces a funding-shortfall warning instead of allowing cash to remain unsupported.

Which valuation methods are included?

The model includes an unlevered DCF, perpetual-growth and exit-multiple terminal values, revenue and subscriber multiples, replacement cost, sensitivities and a football-field summary.

Put the complete network plan in one model

Connect subscribers, capacity, financing and value.

Editable Excel model with an integrated 10-year forecast. One-time purchase for $110.

Get the Cellphone Network Model

10-Year Joint Venture Preferred Return and Promote Waterfall Model

SmartHelping / Joint Venture / Excel

Joint Venture Preferred Return and Promote Model

Model LP preferred return, return of capital, GP promote, two GP entities and time-based vesting across 10 years of cash flow.

10-year waterfall LP and GP returns Two GP entities
Joint venture preferred return and promote waterfall model
$45 One-time purchase / Excel download
Add Joint Venture Preferred Return and Promote Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

8% Default LP Pref

Change the preferred-return rate as required.

No GP Catch-Up

The default structure uses a hard preferred-return hurdle.

70% / 30% Residual Split

The default split is 70% LP and 30% GP.

GP Promote Vesting

Allocate promote between two separate GP entities.

Model Preview

See how the waterfall works.

Review the capital structure, cumulative LP preferred return, return of capital, residual split, GP allocations and vesting logic.

Open the model overview presentation

Explore the model structure, assumptions, distribution outputs and GP promote vesting alongside the video walkthrough.

Inside the Model

Build a complete LP and GP distribution schedule.

Enter capital contributions and distributable cash flow, then allocate proceeds through the preferred-return and promote structure.

01 / CASH FLOW

Enter 10 years of cash flow

Input annual distributable cash flow and review the resulting allocations across the full forecast period.

02 / OWNERSHIP

Define LP and GP ownership

Configure equity contributions, ownership percentages and the amount of capital invested by each party.

03 / CONTRIBUTIONS

Include additional contributions

Add future equity contributions and incorporate them into investor capital accounts and return calculations.

04 / PREFERRED RETURN

Accrue unpaid preferred return

Calculate cumulative LP preferred return, including amounts that remain unpaid when current-period cash is insufficient.

05 / CAPITAL REPAYMENT

Return LP capital

Allocate 100% of the applicable cash flow to the LP until the defined LP capital balance has been returned.

06 / PROMOTE SPLIT

Apply the residual promote split

Divide remaining proceeds between the LP and GP according to the selected residual ownership and promote percentages.

07 / GP ALLOCATION

Allocate promote between GP entities

Divide GP promote distributions between two separate GP entities using editable allocation assumptions.

08 / VESTING

Model promote vesting

Apply an annual vesting schedule to Entity 2 and control how unvested promote is reallocated.

Distribution Waterfall

Follow available cash through each distribution tier.

The model carries unpaid obligations forward and applies each tier in sequence before allocating residual proceeds.

1. Available cash

Begin with the annual distributable cash flow available to the joint venture investors.

2. LP preferred return

Pay the cumulative LP preferred return, including any unpaid amount carried forward from prior periods.

3. Return LP capital

Allocate cash to the LP until the applicable contributed capital has been returned.

4. Residual split

Divide remaining proceeds between the LP and GP using the selected promote structure.

GP Promote and Vesting

Separate promote economics from invested capital.

Allocate GP promote between two entities and apply a customizable vesting schedule to the second entity's promote participation.

Two GP entities

Split the GP promote between Entity 1 and Entity 2 independently from their underlying invested capital.

Annual vesting schedule

Define the percentage of Entity 2's promote that becomes vested during each year of the projection.

Unvested promote treatment

Choose whether Entity 2's unvested promote is reallocated to Entity 1 or returned to the LP.

Flexible incentive structures

Model operating-partner incentives, seller rollovers and other time-based promote arrangements.

Model Workflow

Move from capital assumptions to investor returns.

Configure the joint venture terms before reviewing annual distributions, capital balances and investor outcomes.

  1. Define the capital stack

    Enter LP and GP contributions, ownership percentages and starting capital balances.

  2. Enter cash flow

    Add annual distributable cash flow and any future equity contributions across the 10-year period.

  3. Configure the waterfall

    Set the preferred return, capital-return tier, residual split, GP allocations and vesting.

  4. Review investor results

    Analyze distributions, outstanding balances, investor cash flows, IRRs and equity multiples.

Model Outputs

Review the deal from every investor perspective.

01 / DASHBOARD

Summary dashboard

Review capital contributions, distributions, return metrics and the major waterfall terms in one place.

02 / WATERFALL

Complete waterfall schedule

Audit preferred-return accruals, capital balances and distributions through every waterfall tier.

03 / RETURNS

Investor-level returns

Calculate cash flows, IRRs and equity multiples for the LP, GP and individual GP entities.

04 / REVIEW

Charts and model checks

Use distribution charts, implementation notes and automated checks to review and customize the structure.

Who It's For

Use the waterfall across multiple investment structures.

Real estate joint ventures

Allocate property cash flow between institutional capital and the sponsor or operating partner.

Business acquisitions

Model buyer, investor, seller-rollover and management-incentive economics.

Private investments

Structure preferred returns and promote participation around long-term distributable cash flow.

Sponsors and advisors

Explain, test and document the expected economics for each participating investor.

Bundle Options

Get this model within a larger collection.

Related Templates

Frequently Asked Questions

Joint venture model FAQ.

What is the model's default waterfall structure?

The default structure uses an 8% cumulative LP preferred return, followed by a 100% return of LP capital and a 70% LP / 30% GP residual split without a GP catch-up.

What happens when there is not enough cash to pay the LP pref?

The unpaid preferred return accrues and carries forward into future periods until sufficient cash becomes available.

Can I enter additional capital contributions?

Yes. The model accepts additional equity contributions across the 10-year forecast and incorporates them into the relevant capital balances and investor cash flows.

How many GP entities can receive promote distributions?

Promote distributions can be allocated between two separate GP entities using editable allocation percentages.

How does Entity 2 vesting work?

Entity 2 can use a customizable annual promote-vesting schedule. Any unvested portion can be reallocated to Entity 1 or to the LP.

What return outputs are included?

The workbook includes investor-level cash flows, distributions, IRRs, equity multiples, charts, a summary dashboard and automated checks.

Turn joint venture terms into a complete waterfall

Model every tier and investor return in one editable file.

Model LP preferred return, return of capital, GP promote, entity-level vesting and investor returns. One-time purchase for $45.

Get the Joint Venture Model