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.
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.
Forecast site deployment, subscriber cohorts, ARPU, churn, network costs, capital investment, financing and enterprise value across a complete 120-month operating plan.
10-year forecastMonthly subscriber cohortsConnected 3 statementsDCF and football field
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.
01
Set the commercial assumptions
Enter acquisition spending, CAC, organic and partner additions, ARPU, churn, data usage and the variable costs required to serve subscribers.
02
Plan the network rollout
Schedule site deployments, installed capacity, infrastructure spending, maintenance and fixed network operating expenses.
03
Structure the financing
Configure equity, construction debt, term financing, revolving credit, minimum liquidity and the limits available for each funding source.
04
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.
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.