Acquisition Financial Model for Direct Marketing and Print Communications

SmartHelping / Business Acquisitions / Excel

Direct Marketing & Print Communications Acquisition Financial Model

Evaluate whether a print and direct marketing business can support its purchase price, debt obligations, and buyer return. Connect a detailed operating forecast with acquisition funding, valuation, scenarios, and a structured deal assessment in one Excel workbook.

5 years / 60 months 6 service lines 25 connected worksheets Debt, equity & valuation

$45 One-time purchase / Excel download

Add Print Acquisition Model to Cart

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

Walkthrough & screenshots Operating forecast Acquisition funding Scenarios & synergies Reports & valuation Common questions

Video walkthrough & workbook preview

See the operating business and the acquisition in one model.

Follow the customer, production, cost, and funding assumptions through to cash flow, buyer returns, and the acquisition scorecard.

Open the model screenshots

Explore the assumptions, operating schedules, financial statements, investment outputs, and diligence framework.

A forecast built from the work the business sells

Connect customer demand with revenue and margins.

Forecast six service lines: direct mail; digital and offset print; large format and retail; fulfillment and kitting; promotional products; and data, portals, and creative services.

Customer retention & new accounts

Start with existing service accounts, annual retention, monthly account additions, and acquisition-related account losses. Optional cross-selling adds service relationships as integration progresses.

Order frequency, volume & pricing

Build demand from orders per account, units per order, and calendar-month seasonality. Set selling prices and setup fees, with growth assumptions for each forecast year.

Materials, spoilage & outsourcing

Model internal material costs, spoilage allowances, labor requirements, and outsourced production costs by service line to understand the margin behind completed work.

Historical earnings & forecast comparison

Enter the target's historical results, opening balances, and EBITDA adjustments. Review five forecast years beside historical figures and compare major operating assumptions with the last twelve months.

Production capacity & the cost of growth

Test whether the business can deliver the forecast.

The model connects demand with equipment, space, and productive labor. Completed production drives billed revenue, while outsourcing and unserved demand remain visible.

Capacity constraints

Compare equipment or space capacity with available productive labor for each service line. Review how the binding constraint affects in-house production.

Overflow production

Set the share of excess demand handled by outside suppliers. Review outsourced work, its cost, and demand that remains unserved.

Staffing & payroll

Plan production teams and administrative staff by forecast year. Payroll includes wages, wage inflation, employer burden, and the minimum operators required by installed capacity.

Equipment additions & occupancy

Add capacity modules by year. New modules bring capital spending, minimum operator payroll, floor-space rent, and depreciation into the forecast. Maintenance CapEx is modeled separately.

Postage & working-capital funding

Keep pass-through postage separate from operating revenue.

Postage is billed at cost and shown separately from net operating revenue and EBITDA. Postage advance days capture the cash required when the business pays before the customer reimburses it.

Customer collection days, material inventory days, and supplier payment days connect the operating forecast with working-capital needs. This helps reveal cash pressure that an EBITDA-only forecast can miss.

Purchase price, closing funding & ongoing liquidity

Understand the buyer's full cash commitment.

Connect normalized historical earnings and the proposed purchase price with closing costs, financing, operating cash needs, and subsequent equity contributions.

Purchase price & Sources and Uses

Set entry enterprise value from normalized LTM EBITDA and a purchase multiple. Adjust consideration for delivered operating working capital versus the agreed peg, then include transaction costs, financing fees, and opening cash.

Senior debt & seller financing

Size debt as shares of total closing uses, with buyer equity funding the remainder. Model senior amortization and interest-only periods, financing fees, and the seller note's final repayment.

Revolver & additional equity

Set a revolving-credit limit, minimum cash target, and cap on post-close operating equity. Track peak borrowing and any funding shortfall that remains after those limits are reached.

Cash sweeps & equity distributions

Apply the model's cash rules to debt repayment and investor distributions. Review debt service coverage, including a separate view of the seller-note balloon, alongside the equity cash-flow schedule.

Base / Downside / Upside / No Synergies

See how much the investment depends on the operating plan.

Four selectable cases run through the same 60-month forecast. Change the selected case to review its operating results, funding needs, debt coverage, valuation, and returns.

Operating scenarios

Vary retention, account acquisition, pricing, order frequency, material and wage inflation, production capacity, collections, and postage funding assumptions.

Integration benefits & costs

Model overhead savings, procurement discounts, and cross-selling with a start month and implementation ramp. Include one-time integration spending to capture the cost of achieving those benefits.

No Synergies case

Evaluate the acquisition without overhead savings, procurement benefits, cross-selling, or integration expense. The acquisition-related account-loss assumption remains.

Two-way sensitivity tables

Test equity XIRR across entry and exit EBITDA multiples when using the EBITDA exit method. A second table tests minimum rolling debt service coverage against demand and internal material-cost stress.

Financial reporting, valuation & decision support

Review the return, the cash path, and the supporting evidence.

Connected financial statements

Review monthly and annual income statements, balance sheets, and cash flow statements linked to the operating model, assets, taxes, working capital, and financing.

Equity return analysis

Evaluate dated equity XIRR, MOIC, and NPV. The annual equity summary separates closing investment, later contributions, operating distributions, exit cash flow, and cumulative cash flow.

Three exit valuation methods

Choose a Year 5 EBITDA multiple, continuing DCF, or net-revenue multiple. Review the enterprise-value-to-equity bridge, DCF analysis, and a chart comparing low/high valuation estimates.

LTM comparisons & visualizations

Compare historical revenue, expenses, and EBITDA with Years 1–5. Review operating KPIs, production capacity, debt, cash, and Sources and Uses charts.

Assumptions Analysis

Enter the existing business's LTM operating assumptions beside linked Year 1–5 drivers. Review Year 1 differences and calculation notes across the service lines, staffing, overhead, synergies, and working capital.

Deal scorecard & diligence

Use the weighted acquisition scorecard, financial/quality/risk dimensions, and evidence coverage to organize your review. Track requested evidence, closing conditions, responsibilities, and open risks in the diligence checklist.

Explore all 25 workbook tabs

Inputs & historical context

Summary, Assumptions, Historical, Assumptions_Analysis, Read_Me. Set the transaction and operating case, normalize past results, compare LTM drivers with the forecast, and review the model's instructions.

Demand & production

Service_Inputs, Customer_Engine, Staff_Plan, Capex_Plan, Production. Connect service accounts and orders with labor, equipment, internal production, outsourcing, and capacity limits.

Operating cash flow

Operating_Forecast, Asset_Schedule, Working_Capital, Tax_Schedule. Build revenue and expenses, depreciation and amortization, working-capital balances, and modeled business taxes.

Funding, value & returns

Sources_Uses, Debt_Cash, Valuation, Equity_Summary, Sensitivity. Follow closing funding, monthly cash priorities, debt, exit value, investor cash flows, and sensitivity results.

Financial statements & KPIs

Monthly_Statements, Annual_Financials, KPI_Visualizations. Review connected statements, annual summaries, historical comparisons, operating metrics, and charts.

Acquisition review & diagnostics

Deal_Scorecard, Diligence, Checks. Assess the deal, track evidence and closing conditions, and review model reconciliations and funding diagnostics.

A practical acquisition workflow

From seller information to an investment case.

1. 01

   Establish the historical baseline

   Replace the illustrative financials with the seller's results, opening balances, and supported EBITDA adjustments. Enter LTM operating drivers for comparison.

2. 02

   Build the operating and funding plan

   Set service volumes, retention, pricing, staffing, capacity investment, working capital, acquisition terms, and financing assumptions.

3. 03

   Test returns and document the risks

   Review scenarios, debt coverage, funding gaps, valuation, and buyer returns. Use the scorecard and diligence checklist to identify what still needs evidence.

Also included in these bundles

Get this model as part of a broader collection.

Industry-Specific Financial Model Bundle

Get this acquisition model alongside financial models for a wide range of operating businesses.

Explore the industry-specific bundle

The Super Smart Bundle

Get this model as part of the complete SmartHelping template collection.

Explore the Super Smart Bundle

Explore the acquisitions category

Financial models for SMB acquisitions

Explore Excel templates for buying small and medium-sized businesses. These models connect bottom-up assumptions for customers, pricing, staffing, capacity, and costs with acquisition funding, cash flow, valuation, and buyer returns. Evaluate the operating business behind the purchase price and test what needs to happen for the deal to work.

Bottom-up operating forecasts Acquisition funding & cash flow Valuation & buyer returns

Browse SMB Acquisition Models →

Questions before you buy

A few useful details.

Who is this model for?

It is built for evaluating the acquisition of an existing direct marketing and print communications business. Buyers, operators, and advisers can use it to connect the target's operating assumptions with acquisition funding, cash flow, valuation, and buyer returns.

Is this a startup forecast or an acquisition model?

It combines an existing-business acquisition framework with a bottom-up operating forecast. Historical results and normalized earnings inform the purchase analysis, while service accounts, production capacity, staffing, and costs drive the five-year projection.

Does it include actual results from a specific company?

No. The example financials and transaction terms are illustrative. Replace them with verified information for the business you are evaluating.

Are service accounts the same as unique customers?

No. They represent service relationships. One customer can buy several types of work, so adding accounts across all six service lines does not produce a unique customer count.

How does the model treat postage?

Postage is an at-cost pass-through, excluded from net operating revenue and EBITDA but visible in billings and funding needs. Positive advance days represent the business funding postage before reimbursement. Customer prepaid-postage deposits are not modeled.

What does the No Synergies case remove?

It removes overhead savings, procurement benefits, cross-selling, and the associated integration expense. The acquisition-related account-loss assumption remains. It is useful for reviewing the acquisition without the planned integration benefits and spending.

Do LTM entries on Assumptions Analysis change the forecast?

No. Those entries provide a comparison with the existing business. The Year 1–5 columns link to the selected case and the model's operating schedules. Change forecast assumptions on the existing input tabs.

Does a high deal score mean the evidence is verified?

No. The acquisition assessment and verified evidence coverage are separate. Record supporting information and reviewer conclusions before changing evidence statuses. Illustrative inputs do not establish that diligence or closing conditions have been satisfied.

What software should I use?

This is an Excel workbook. For the built-in two-way sensitivity tables, use Excel with calculation set to Automatic, including data tables.

How much does the model cost?

The one-time price is $45 for the Excel download, available immediately after purchase. It is also included in the Industry-Specific Financial Model Bundle and the Super Smart Bundle linked above.

Evaluate the acquisition

Connect the operating plan with the buyer's return.

Get the Direct Marketing & Print Communications Acquisition Financial Model. Have a question? Contact SmartHelping.

Get the Print Acquisition Model

How Many Clients Does a Med Spa Need to Break Even?

SmartHelping / Med Spa Planning Guide

Turn appointment demand into a break-even plan.

How many clients does a medical spa need to break even? The answer depends on what each completed visit contributes, how often clients return, and how much it costs to keep the clinic open.

In the illustrative example below, the November operating break-even threshold is approximately 209 completed appointments, assuming that month’s new-client activity, treatment economics and retail contribution. The forecast delivers about 225 appointments and earns $3,527 of EBITDA.

Explore the $45 Med Spa Excel Model

About this example: These are projections from the Base case of SmartHelping’s single-location Med Spa Financial Model, not results from an operating clinic or industry benchmarks. The example forecast starts in January 2027 and opens in March. Dollar amounts below are in actual dollars; displayed figures are rounded.

Start with visits, then translate them into clients.

A client and an appointment are different units. One person may return several times during a year, while another completes a consultation and never books a treatment. A database of 1,000 names does not tell you how many revenue-producing appointments the clinic will complete next month.

Build the forecast around first treatments and repeat treatments. Then estimate the active client pool needed to generate those visits. Keep consultations, booked treatments and completed treatments separate so that cancellations and capacity limits do not disappear from the plan.

Simple operating break-even:
Monthly fixed operating costs ÷ weighted contribution per completed appointment = completed appointments required.

Contribution is the amount left after variable costs. Deduct treatment products, consumables, variable provider incentives and relevant payment fees before using revenue to cover payroll, rent and overhead. Count scheduled provider salaries in fixed costs if they are already included there; avoid charging the same labor twice.

A worked example: the first profitable operating month.

In November 2027, the model forecasts approximately 87.9 first visits and 137.5 repeat visits. Combined with retail sales, that produces $84,525 of revenue. Recurring fixed operating costs are $45,476, and each completed repeat treatment contributes approximately $209.73 before those fixed costs.

The workbook asks a more specific question: with first-visit and retail contribution held constant, how many repeat appointments cover the remaining recurring costs?

November repeat-visit requirement:
($45,476 fixed costs − $18,080 first-visit contribution − $2,000 retail contribution − $75 prepaid-card-fee timing credit) ÷ $209.73
≈ 121 completed repeat visits

Add approximately 88 first visits and the threshold is about 209 completed appointments. The projected 225 appointments exceed it. This is a conditional threshold: changing first visits, retail sales, treatment mix or costs changes the answer. The small card-fee adjustment reconciles processing costs collected on prepaid packages with normalized treatment contribution.

Illustrative Base case: approaching operating break-even

2027 month	First visits	Repeat visits	Repeat visits needed*	EBITDA
September	79.9	95.9	130.9	−$7,340
October	83.9	115.8	125.8	−$2,111
November	87.9	137.5	120.7	$3,527
December	83.9	147.2	123.6	$4,984

*Holds each month’s first-visit and retail contribution constant. Fractional visits are forecast averages; round required appointments up when setting a whole-appointment target. Operating break-even excludes depreciation, financing costs, income taxes, working-capital changes and capital spending.

Can repeat clients cover the clinic by themselves?

Reaching positive EBITDA with new and returning clients is one milestone. Having repeat-treatment contribution cover fixed operating costs is another. In November, repeat treatments contribute $28,847 against $45,476 of recurring fixed costs: only 63.4% coverage. First visits and retail still help the clinic reach operating break-even.

By June 2028, projected repeat-treatment contribution reaches $49,036 against $47,732 of recurring fixed costs, or 102.7% coverage. That provides a different view of resilience: how much of the clinic’s cost base is supported by returning patients?

Repeat-treatment contribution as a share of fixed operating costs

Year 1

31.8%

Year 2

98.3%

Year 3

122.1%

Year 4

141.5%

Year 5

139.8%

Recreated from the workbook’s KPI dashboard. Each bar uses a 0–150% scale; the dashed line marks 100% coverage. Annual ratios divide annual repeat-treatment contribution by annual recurring fixed operating costs. They exclude debt service.

Repeat visits still require consumables, provider time and equipment. Strong retention does not make those visits costless. It improves the amount of future demand supported by an established client base.

Translate repeat appointments into an active client pool.

The Base case assumes 0.35 repeat visits per active client per month, 3.5% monthly attrition and a 6% treatment no-show or cancellation rate. These are editable planning assumptions. Visit frequency is an average across the client pool, not a recommended treatment schedule for any individual.

For a separate, simplified illustration, suppose your target is 200 completed repeat visits in a neutral-season month. With no capacity constraint, the surviving active pool would need to be approximately:

200 ÷ (0.35 visits × 94% completion) = 608 active repeat clients, rounded up.

This illustration uses the pool after attrition and is not the workbook’s November break-even output. The full forecast also accounts for seasonality, new clients joining the repeat pool and available treatment capacity. Track repeat-visit share separately from client retention: they measure different things.

Check whether the clinic can deliver the required visits.

A break-even target is useful only if the operating plan can support it. The model limits booked treatments using provider hours, room hours and device availability. Consultations consume clinician and room time before treatment activity, and booked treatments consume capacity even when no-shows reduce completed visits.

In the example, average provider booked utilization reaches 100% in Year 5, while room utilization is approximately 91.6%. The forecast shows about 2,293 appointments of capacity-unserved demand during that year. Those are demand units the model cannot schedule, not completed visits or recognized revenue.

Adding a room alone may not solve a provider bottleneck. Evaluate staffing, scheduling and equipment constraints together. Also budget the costs of expansion explicitly: additional room capacity is not a substitute for entering the associated buildout, equipment, staffing and occupancy costs.

Treatment mix changes the break-even target.

Two clinics with the same number of appointments can produce different profit. Prices, product costs, appointment length and provider requirements change the contribution earned per visit and per scarce hour.

In the model’s illustrative Year 5 mix, dermal filler contributes approximately $449 per booked provider hour, versus $159 for facial and skin-care treatments. These are scenario outputs, not market benchmarks or treatment recommendations. They show why average revenue per patient alone is insufficient.

Compare contribution within the relevant provider and device constraints. A high-margin service may require a specific clinician or machine, and different services cannot always substitute for one another. Build the plan around appropriate care and the service mix your clinic can actually deliver.

Positive EBITDA does not mean the startup is fully funded.

The example opens in March and first produces positive monthly EBITDA in November: forecast month 11 and the ninth operating month. Earlier losses still matter. Year 1 EBITDA remains negative $174,199 despite the positive November and December results.

NovemberFirst positive EBITDA month in the illustrative 2027 forecast

$308,800Total contributed equity across the Base-case forecast

$257,000Year 1 physical capital expenditures

The equity figure includes $150,000 at time zero and approximately $158,800 of later contributions. Debt also supports the example: Year 1 includes $173,500 of term and equipment loan proceeds plus $50,000 drawn on the revolver. Equity required is therefore not the same as total project spending.

Review principal payments, interest, inventory, collection timing, deposits, capital purchases and minimum cash alongside operating profit. Prepaid packages also need care: cash arrives before all services are delivered. Selling a package does not make its entire cash receipt earned treatment revenue.

Stress-test the assumptions before opening.

Use the monthly forecast to test whether the clinic remains adequately funded when repeat demand builds more slowly. Start with these questions:

• Client acquisition: What happens if leads cost more or fewer consultations become first treatments?
• Retention: How much additional funding is needed if fewer first-time clients return and monthly attrition rises?
• Capacity: Does hiring another provider unlock enough completed treatments to justify the added payroll?
• Cash: Can the clinic maintain its cash reserve while paying debt and funding inventory?

The workbook’s Downside assumptions include 6.5% monthly attrition and 0.28 repeat visits per active client, compared with 3.5% and 0.35 in Base. Switch the case and review the resulting forecast; the Base-case break-even date and funding figures above should not be carried into that downside assessment.

See how the forecast works.

The walkthrough explains the customer and treatment engines, operating costs, capacity limits and funding schedules behind this example.

Open the workbook screenshots

Build your own clinic plan

Calculate your break-even point using your assumptions.

The SmartHelping Med Spa Startup Financial Model connects patients, repeat visits, treatment capacity and costs to a 60-month forecast, integrated financial statements, funding requirements and equity returns.

View the Med Spa Model — $45

Need a different starting point? Use the Model Finder. For a forecast adapted to your clinic, explore custom financial modeling or send Jason your project details.

By Jason Varner, SmartHelping. Example source: SmartHelping Med Spa 5-Year Financial Model v1, Base case; KPI Visualizations, Monthly Operations, Summary and Assumptions. The figures illustrate how the model works and are not a forecast for a specific clinic. Calculations use unrounded values.

Med Spa Startup Financial Model Template

SmartHelping / Medical Spa / Excel

Med Spa Startup Financial Model

Plan a medical spa from opening costs to repeat-client profitability. Connect marketing, treatment demand, provider hours, rooms, and equipment to a five-year forecast of revenue, expenses, cash needs, and investment returns.

60 monthly periodsIntegrated 3 statementsTreatment capacityDebt & equity planning

$45One-time purchase / Excel download

Add Med Spa Financial Model to Cart

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

Watch the walkthroughClients and capacityRevenue and expensesFundingFinancial outputsBundlesRelated models

See the model in action

Walk through the Med Spa Financial Model.

Open the model screenshots

Build a plan around your clinic

Test the operating plan before committing capital.

A single-location startup forecast

Model one leased medical spa over 60 monthly periods, including the pre-opening period, with annual financial summaries.

Base, downside, and upside cases

Change the selected case to test a different set of operating assumptions and see the effect on the forecast.

Editable treatment and staffing inputs

Start with the clinic assumptions, treatment menu, staff plan, and capital expenditure plan. Customize the inputs around your proposed location.

A focus on repeat-client economics

Review how repeat visits contribute toward scheduled payroll, rent, equipment upkeep, and clinic overhead as the business develops.

How many clients does a med spa need to break even? See a worked example connecting repeat visits, treatment margins, staffing capacity, and startup funding.

Read the med spa break-even guide

From marketing to completed treatments

Connect customer demand to the capacity to serve it.

The forecast connects client acquisition and repeat visits with the time available from your providers, treatment rooms, and devices.

New-client funnel

Paid marketing and organic leads feed consultation bookings and treatment conversion. Consultation time uses clinician and room capacity before treatment activity is scheduled.

Repeat-client activity

Build the active repeat-client pool using completed first visits, repeat-client conversion, and attrition. Visit frequency and seasonality determine repeat-treatment demand.

Provider, room, and device limits

Device availability, provider hours, and shared room capacity constrain booked treatments. Appointment time consumes scheduled capacity, while no-shows reduce completed treatments and revenue.

Unserved demand

See appointment demand that exceeds available capacity. Unserved demand is treated as lost activity in the forecast rather than carried forward as a waiting list.

Service revenue, product sales, and operating costs

Build revenue and expenses from their underlying drivers.

Six editable treatment categories

The starting menu includes neuromodulator, dermal filler, laser hair removal, facial/skin care, microneedling, and laser skin treatments. Adjust prices, treatment mix, resource requirements, and direct costs.

New and repeat treatment revenue

Completed new-client and repeat-client treatments drive service revenue. Review the contribution of each group as the client base develops.

Retail and prepaid treatment credits

Include retail product sales and prepaid treatment credits. The model tracks advance collections, credit redemptions, and the remaining prepaid liability separately.

Treatment-level variable costs

Connect service activity to products, consumables, provider incentives, and other direct costs. Include payment processing and the cost of retail products.

Staffing and fixed overhead

Plan employee roles, hiring timing, compensation, and employer payroll burden. Include rent, marketing, medical oversight, insurance, and other clinic overhead.

Equipment, inventory, and working capital

Schedule capital purchases and depreciation, plan inventory needs, and account for collection and supplier payment timing in the cash forecast.

Startup capital and ongoing liquidity

Plan how the clinic is funded and when cash can be distributed.

Dynamic sources and uses

Review funding sources and cash requirements through the model’s peak funding point. Trace equipment, inventory, deposits, pre-opening spending, and operating cash needs into the equity funding requirement.

Term loan and equipment financing

Set operating term-loan assumptions and equipment financing terms. Follow loan draws, interest, principal repayment, and remaining balances through the forecast.

Revolver and equity support

Model a revolving credit facility and later equity contributions subject to their limits. Review remaining funding gaps when available capital is insufficient.

Cash retention and distributions

Set minimum operating cash, cash retained against prepaid liabilities, distribution timing, and the share of available cash distributed. Distributions also require the revolver to be fully repaid.

Financial statements, operating KPIs, and returns

Review the clinic from operating performance through exit value.

Integrated financial statements

Review monthly and annual income statements, balance sheets, and cash flow statements, supported by operating, asset, debt, tax, and cash schedules.

KPI dashboard and visualizations

Review new and repeat visits, client retention, capacity utilization, revenue, margins, cash, and debt-service coverage. Track repeat-client contribution against fixed operating costs.

Equity summary

Follow equity contributions, distributions, and exit proceeds. Review equity XIRR, multiple on invested capital, and NPV using the timing of those cash flows.

DCF and valuation comparisons

Review project cash flow and discounted cash flow valuation alongside a football-field comparison of valuation approaches.

Optional Year 5 exit

Include or exclude a sale at month 60. Select a continuing DCF, EBITDA multiple, or revenue multiple approach and account for sale transaction costs.

Valuation and repeat-business sensitivities

Test WACC versus growth, EBITDA multiples versus EBITDA changes, and attrition versus visit frequency. The repeat-business grid shows unconstrained steady-state coverage; the main cases include the full capacity-constrained forecast.

Also included in these collections

Explore the Med Spa model as part of a bundle.

Industry-Specific Financial Model Bundle

This Med Spa Financial Model is included in the Industry-Specific Bundle, alongside operating models built around the drivers of different businesses.

View the Industry-Specific Bundle

Super Smart Bundle

This model is also included in the Super Smart Bundle, the complete public SmartHelping collection of financial models, calculators, and trackers.

View the Super Smart Bundle

Complementary business models and planning tools

Explore related financial models.

These separate templates cover service businesses, location growth, equipment investment, payroll, and customer retention.

Hair Salon / Barbershop Financial Model

Forecast service and product revenue, operating costs, financing, and scenarios for a salon or barbershop.

View model details

Fitness Studio Scaling Model

Connect location openings, capacity, pricing, startup spending, and debt to a consolidated expansion forecast.

View model details

Gym / Fitness Center Startup Model

Plan membership growth, equipment investment, operating expenses, and financing for a fitness center.

View model details

Equipment Purchase ROI Analysis

Evaluate equipment costs, revenue gains, and labor savings with ROI, IRR, and NPV sensitivity analysis.

View model details

Payroll Tracker — Budget vs. Actual

Calculate hourly and salaried payroll and compare employee-level and total pay-period results with budget.

View model details

Customer Spend & Retention Curves

Forecast customers and revenue using monthly acquisitions and spending and retention patterns by customer age.

View model details

Questions before you start

A few useful details.

What type of business does this model cover?

A startup medical spa operating from one leased location. The forecast covers 60 months from the selected start date, including any pre-opening months.

Can I customize the treatments and staffing plan?

Yes. The workbook includes editable treatment, staff, and capital expenditure inputs so you can tailor the forecast to your clinic’s operating plan.

Does the model limit revenue based on capacity?

Yes. Completed treatments are constrained by the applicable device, provider, and room capacity. Demand above those limits remains visible as unserved demand.

How are prepaid treatment credits handled?

The model separates cash collected in advance from revenue recognized as credits are redeemed for eligible services. It tracks the remaining prepaid balance and the cash retention policy you select.

Does it include financing and investment returns?

Yes. It includes term and equipment debt, revolving credit, equity support, cash distributions, and an optional Year 5 sale, with valuation and equity return outputs.

Which bundles include this model?

The Med Spa Startup Financial Model is included in the Industry-Specific Bundle and the Super Smart Bundle linked above.

Plan your medical spa startup

Connect the clinic you want to build to the capital it needs.

Med Spa Startup Financial Model — $45, delivered as an Excel download.

Get the Med Spa Model

SmartHelping acquisition case study

Cold Email SaaS Acquisition Analysis: Is an $8M ARR Business Worth $24M?

The model projects a 58.6% base-case IRR, but only 9.7% in the downside case. Here is how revenue quality, financing, operating costs, and exit assumptions shape the $24 million decision.

By Jason Varner · Expanded September 26, 2026 · Video update September 28, 2026

Preliminary overall acquisition score

83.1 / 100

Conditional screening result. Several unverified metrics are excluded from scoring.

Financial

81.8

Quality

85.8

Risk / downside

82.0

Deal snapshot Latest video update Watch the review Revenue & earnings Financing & returns Exit sensitivity Diligence questions

The opportunity at a glance

This cold-email infrastructure SaaS was founded in 2024 and listed at $24 million, above my usual $10 million screening range. Its combination of growth, profitability, and a broad subscriber base caught my attention.

The business supplies infrastructure used for outbound sales and marketing. That makes recurring usage, service reliability, and customer retention central to the acquisition thesis.

Asking price

$24M

Reported listing price

Reported ARR

$8M

Definition requires confirmation

Reported MRR

$660K

$7.92M when multiplied by 12

Active subscribers

3,100

Reported subscriber count

Price / reported ARR

3.0x

$24M divided by $8M

Monthly revenue / subscriber

~$213

$660K divided by 3,100

Listing figures are seller-reported; calculated ratios are screening metrics. Monthly revenue per subscriber assumes MRR and subscriber count cover the same period and population.

Modeling update · September 28, 2026

Update: fixed-cost % and debt %

In this follow-up to the cold email SaaS deal review, I explain using the proper fixed-cost percentage and entering the debt percentage in the financing input. The debt % represents the portion financed with debt, not the buyer's down-payment percentage.

Watch this update alongside the original deal review below for clarification of these model inputs.

Watch the complete deal review

The original walkthrough accompanies the written analysis below. The numerical results shown in the article reflect the September 26 workbook.

01 / Revenue quality

Is $8 million ARR or actual annual revenue?

ARR expresses an annualized recurring-revenue run rate at a point in time. Trailing twelve-month revenue measures revenue earned over the preceding year. In a rapidly growing business, those figures can differ substantially.

The stated $660,000 MRR annualizes to $7.92 million, close to the reported $8 million ARR. Neither establishes that the business earned $8 million over the preceding year.

The workbook uses a reconstructed starting point of approximately $7.91 million: it compounds roughly $1 million at 9% monthly for two years. This is a screening assumption, not verified historical revenue. Monthly billing, recognized revenue, cash collections, and the actual growth period need reconciliation before relying on it.

02 / Earnings quality

The 40% versus 50% margin question matters

The listing described approximately 50% EBITDA margins. The workbook's reconstructed historical section produces $3.23 million of EBITDA and a 40.8% margin, using an 80% gross margin, $3.1 million of operating expenses, and no accepted add-backs.

That puts the $24 million price at approximately 7.43x modeled starting EBITDA. This is not verified normalized earnings. The seller's margin and the model's result need reconciliation across periods, infrastructure costs, staffing, owner compensation, and adjustments.

The base forecast then assumes a 50% EBITDA margin. That is an explicit forecast assumption, not a resolution of the historical discrepancy.

03 / Customer durability

Low concentration is encouraging. Retention still needs proof.

The reported concentration figures were attractive: no customer exceeded 2% of revenue, and the top ten represented 11%. That reduces dependence on any single account, if the figures reconcile to customer-level records.

Customers can still share exposure to deliverability, provider dependencies, and changing sales economics. Cohort data should establish retention and expansion. The workbook includes a 105% net-revenue-retention input, but the supplied file does not substantiate it with customer-level data. CAC payback, LTV-to-CAC, and gross retention remain diligence questions.

How I interpret the 83.1 score

The workbook calculates 83.1 overall: Financial 81.8, Quality 85.8, and Risk / Downside 82.0. It is conditional on the inputs and scoring treatment, not a probability of success. Higher risk scores indicate greater modeled protection.

Several retention, acquisition-cost, and technical-diligence measures are marked N/A and excluded. The remaining metrics are reweighted. The resulting score should not be read as evidence that those missing areas have been validated.

What supports further investigation

Reported recurring revenue, substantial margins, rapid growth, and low customer concentration create a promising starting point.

What could change the conclusion

Weaker normalized earnings, poor cohort retention, higher replacement costs, or fragile infrastructure dependencies could materially alter the price a buyer can support.

04 / Acquisition financing

The model requires $14.4 million of buyer equity

Assumed sources of funds for the $24M purchase

Source	Amount	Share	Modeled terms
Senior loan	$7.20M	30%	7% interest; 20-year amortization
Seller note	$2.40M	10%	2% interest; 5-year amortization
Buyer equity	$14.40M	60%	Invested at closing
Total funding	$24.00M	100%	Equals modeled uses

Both loans use monthly amortizing payments, producing approximately $1.175 million of combined annual debt service. These are modeling assumptions, not committed lending terms. Transaction fees and the opening liquidity reserve are set to zero, so the $14.4 million equity requirement excludes those additional funding needs.

Five-year base and downside forecasts

The base assumes 20% annual ARR growth, 70% gross margin, and operating expenses at 20% of revenue. The downside assumes a 10% first-year decline, followed by 2%, 1%, 1%, and 1% growth. Its EBITDA margin recovers from 30% to 44%.

Both cases equate annual revenue to ending ARR, a simplifying assumption requiring validation. Base capex is 2% of revenue; downside capex is 2.5% for three years, then 2%. Working capital uses 2% of positive revenue increases.

Base case — USD millions except DSCR

Metric	Year 1	Year 2	Year 3	Year 4	Year 5
Revenue / ending ARR	$9.49	$11.39	$13.67	$16.40	$19.69
EBITDA	$4.75	$5.70	$6.84	$8.20	$9.84
Cash to equity before exit	$3.35	$4.26	$5.34	$6.64	$8.21
Modeled DSCR	3.85x	4.62x	5.55x	6.66x	7.99x

Downside case — USD millions except DSCR

Metric	Year 1	Year 2	Year 3	Year 4	Year 5
Revenue / ending ARR	$7.12	$7.26	$7.34	$7.41	$7.48
EBITDA	$2.14	$2.18	$2.57	$2.82	$3.29
Cash to equity before exit	$0.78	$0.82	$1.21	$1.49	$1.97
Modeled DSCR	1.67x	1.70x	2.03x	2.27x	2.67x

Cash flows are pre-tax. DSCR divides EBITDA less capex and incremental working capital by combined debt service; it is a screening measure, not a confirmed lender covenant calculation. Cash to equity then deducts debt service and excludes sale proceeds.

A material cost assumption: First-year operating expenses fall from the reconstructed $3.10M starting amount to $1.90M in the base case and $1.78M in the downside. Staffing, owner replacement, infrastructure, and service quality must support that reduction. The downside is not a worst-case floor.

What the equity investor receives in each case

Modeled five-year hold at the $24M purchase price

Metric	Base	Downside
Initial buyer equity	$14.40M	$14.40M
Five-year pre-tax IRR	58.6%	9.7%
Equity multiple / MOIC	7.07x	1.52x
Minimum projected DSCR, Years 1–5	3.85x	1.67x
Year 5 exit ARR multiple	4.2x	3.0x
Exit enterprise value	$82.68M	$22.45M
Net exit proceeds to equity	$73.99M	$15.56M

Net sale proceeds deduct 3% selling costs and approximately $6.21 million of remaining debt. IRR and MOIC include the annual equity cash flows plus sale proceeds. The base relies on both operating growth and expansion from roughly 3.03x modeled entry ARR to a 4.2x exit multiple.

The downside maintains projected debt coverage, but its 9.7% pre-tax IRR falls below the workbook's 25% target. Covering debt and earning an adequate equity return are separate tests.

How purchase price and exit multiples change the return

Five-year pre-tax IRR — base operating assumptions retained

Purchase price	1.5x exit ARR	2.0x exit ARR	2.5x exit ARR
$16M	61.0%	65.5%	69.4%
$20M	48.2%	52.8%	56.9%
$24M	38.7%	43.4%	47.6%

Each cell recalculates financing and equity at the tested price. These results retain base-case growth and margins; they are not the combined operating downside. The main base case uses a 4.2x exit multiple, outside this grid.

The tested $16M–$24M prices are sensitivity inputs, not an independently established offer range. A supportable price still requires verified revenue, sustainable costs, and attainable financing.

My conclusion: The $24 million ask can produce attractive modeled returns, but the downside misses the target and material operating assumptions remain unverified. I would advance to focused diligence, with price and terms revisited if the revenue, cost reductions, or customer durability do not hold up.

My prioritized diligence questions

1. 01

   Can revenue be reconciled?

   Obtain monthly financials and billing exports. Reconcile ARR, MRR, recognized revenue, collections, refunds, and deferred revenue for matching dates.

2. 02

   What explains the margin gap?

   Bridge reported profit to normalized EBITDA. Identify owner costs, contractor expenses, infrastructure costs, and each proposed adjustment.

3. 03

   Do customers stay profitably?

   Review cohorts, gross and net retention, churn reasons, acquisition channels, fully loaded CAC, and gross-profit-based payback.

4. 04

   Will the operation transfer successfully?

   Review ownership of the technology, vendor arrangements, key-person dependencies, reliability history, and security practices with appropriate specialists.

5. 05

   Does the buyer's downside still work?

   Test slower growth, margin pressure, higher churn, financing costs, and a lower exit multiple. Establish the required cash cushion before committing.

Apply the same discipline to your deal

Understand the assumptions before committing capital.

Not ready for full underwriting? Talk through the deal with Jason first. A Deal Gut Check is a live discussion; it does not include a workbook or written report.

For a structured review, explore the $1,950 Acquisition Deal Analysis service: an underwriting workbook, downside analysis, scorecard, written findings, and review call. Confirm scope for larger or more complex transactions.

Explore full acquisition analysis Book a Deal Gut Check

Building your own forecast? Browse my SaaS and recurring-revenue financial models .

View all acquisition case studies →

Source: the original public-listing review and its accompanying SmartHelping SaaS underwriting workbook. Seller claims, reconstructed starting figures, and modeled forecasts are distinguished above. This screening analysis does not independently verify seller records and is not an audit, quality-of-earnings report, or guarantee of future performance.