Build the downside from operating drivers rather than applying an unexplained haircut to revenue. Define patients, visit frequency, attended volume, realized prices, service mix, capacity, costs, obligations, and cash timing. Reconcile the base to actual records, then test explicit alternatives without claiming they are forecasts. The useful result shows what changes, what costs remain, and which resources the practice needs.
What question should the downside model answer?
Decide whether the owner is testing continued operation, a new acquisition, financing, staffing, a price change, or a service interruption. State the entity, period, earnings basis, and cash scope. A model can be mathematically sound while answering the wrong question.
A downside sensitivity changes explicit operating or financing assumptions to show their consequences. It is not a prediction or a probability assessment unless supported by an appropriate forecasting method. The assumptions and omitted items should remain visible.
Begin with a small number of material drivers that the team understands. A complex workbook with dozens of unsupported inputs can create false confidence. The model should help identify evidence, constraints, and decisions rather than produce a preferred acquisition price.
How should the historical base be reconciled?
Use delivered activity, earned revenue, refunds, discounts, labor, product, operating expenses, obligations, and cash records for comparable periods. Explain seasonality, provider changes, service launches, promotions, and reporting differences. A seller’s projected peak month should not quietly become the established base.
IRS recordkeeping guidance describes supporting business records. Connect the model to scheduling, service records, ledgers, payroll, purchasing, merchant activity, and bank evidence as appropriate. Preserve the reconciliation and definitions so another reviewer can reproduce the starting case.
Identify missing information and estimated allocations. A useful model can contain uncertainty if it is explicit. Do not fill a gap with an industry average and later describe the result as the target’s demonstrated performance.
Which demand drivers should remain distinct?
Separate active patients, new patients, observed retention, visit frequency, bookings, attendance, cancellations, service mix, and realized price. The same revenue decline can arise through different combinations. Those combinations can create different staffing, product, scheduling, and cash effects.
Avoid double counting. If lower retention already reduces the patient population and visit count, do not apply the same assumed loss again as an unexplained revenue haircut. Define how each driver enters the formula and which factors are held constant.
Use comparable observation windows for retention and frequency. New patients have not had the same time to return as mature cohorts. Qualified clinical judgment and patient choice should guide appropriate service patterns, rather than a model requiring unnecessary visits to meet an earnings target.
How should capacity limit the result?
Compare modeled attended demand with available qualified professionals, appointment time, equipment, rooms, support, and lawful professional infrastructure. A growth case cannot deliver unlimited visits merely because the spreadsheet projects more inquiries.
A downside can also reduce capacity if a provider leaves or a critical input becomes unavailable. Distinguish demand the practice cannot serve from demand that has disappeared. Recovery may require recruiting, training, supply, or another supported operating action.
Identify the resources needed to change capacity and the time before they contribute. Do not assume staff can work more hours, provide different services, or reduce professional coverage without qualified review. The model should reflect a lawful and clinically responsible operation.
What does an illustrative operating case show?
The following invented monthly example treats all modeled visits as attended and earned, assumes a constant defined variable-cost ratio, and excludes debt, taxes, capital spending, and working-capital timing. Its percentages and prices are not med spa benchmarks.
| Item | Base assumption | Downside assumption |
|---|---|---|
| Attended visits | 500 | 425 |
| Realized revenue per visit | $200 | $190 |
| Earned revenue | $100,000 | $80,750 |
| Defined variable costs at 35% | $35,000 | $28,262.50 |
| Defined fixed operating costs | $45,000 | $45,000 |
| Residual before excluded items | $20,000 | $7,487.50 |
The downside combines fewer visits and lower realized price. Fixed costs remain unchanged by assumption, so the residual falls more sharply than revenue. Actual costs may respond differently; test the practice’s contracts, staffing, service mix, and resources rather than copying this ratio.
How should variable and fixed costs be tested?
Classify costs based on their actual behavior and the model period. Product may move with delivered services, while staffing, rent, systems, professional coverage, and service contracts can remain committed. Some costs are mixed, stepped, or delayed rather than simply fixed or variable.
Show the evidence and timing behind an assumed reduction. A contract may not end immediately, a staff change can require legal and operational review, and necessary care resources cannot be omitted to make the model balance. Separate feasible action from hypothetical savings.
Distinguish a lower expense caused by underinvestment from a durable operating improvement. Deferred maintenance, missing replacement labor, or reduced professional support can make near-term cash look stronger while weakening the actual operation. The supported case should recognize required resources.
Why does revenue need a separate cash schedule?
FASB’s January 2020 revenue-recognition educational Q&As illustrate customer-contract recognition issues. Have the accountant apply current authoritative requirements to the actual promises and reporting basis. Collections, earned revenue, future benefits, refunds, and service costs can occur at different times.
A promotion can create cash before delivery, while later redemptions consume capacity without the same new collections. Merchant timing, inventory purchases, payroll, taxes, and refunds also affect liquidity. A profitable month on the chosen earnings basis can still require cash support.
Build a monthly cash schedule where timing matters. State opening cash, collections, payments, financing, required reserves, and ending cash. Do not assume a positive annual subtotal prevents a short-term funding gap during a seasonal or transitional period.
How should debt and capital obligations be added?
Reconcile interest, principal, leases, required capital, taxes, and working-capital changes according to the starting measure. Avoid deducting an expense already included or ignoring a cash payment absent from the P&L. Identify actual contract terms and clearly labeled hypothetical financing.
In the invented table, adding a hypothetical $8,000 monthly debt payment would leave $12,000 in the base and negative $512.50 in the downside before other excluded items. That is a teaching consequence, not a loan quote, debt-service coverage calculation, or financing recommendation.
SBA’s 7(a) overview describes lender review and program context. The actual lender must evaluate the borrower, transaction, current requirements, and underwriting definitions. A sensitivity workbook does not establish approval or the amount of debt a buyer can obtain.
Which scenarios are worth presenting?
Select alternatives connected to actual risks: lower attendance, weaker retention, pricing pressure, provider absence, delayed hiring, supply interruption, higher costs, or financing change. Test important drivers separately before combining them so the reader can understand the source of the result.
Do not assign probabilities without a defensible method. A severe scenario can be useful even if it is not the most likely outcome, but explain its purpose. Avoid presenting a worst case as inevitable or a modest downside as proof that the operation is safe under every circumstance.
Use the market hub, demand-metrics guide, earnings-to-cash guide, and Four-Number Med Spa Valuation Screen. The model should identify the assumptions that deserve verification before the parties commit.
What should the final decision record contain?
- Define the question and scope.
- Reconcile the historical base.
- Separate demand and capacity drivers.
- Model actual cost behavior and obligations.
- Test explicit alternatives without invented probabilities.
- Identify resources, actions, and unresolved evidence.
Keep formulas, sources, versions, and limitations available. Update the case when actual results or terms change, and explain the movement. A useful downside model supports a decision about price, funding, reserves, preparation, or whether to proceed; it should not merely decorate an investment memo with a negative percentage.
What else do owners and buyers ask?
Is a 10% revenue haircut enough for a downside model?
An unexplained haircut can hide the real drivers. Define what changes in patients, frequency, attendance, realized price, service mix, capacity, and costs, then calculate the effect. A simple sensitivity can be useful when its assumptions are clear. The appropriate severity depends on the actual question and evidence, not a universal percentage.
Why can earnings fall faster than revenue?
Some costs remain committed while delivered activity or realized prices decline. The actual effect depends on staffing, product, leases, professional resources, systems, and other obligations. Review timing and cost behavior rather than assuming every expense falls proportionately. A lower revenue month can therefore create a much larger earnings or cash change.
Does a downside scenario predict what will happen?
Not by itself. A sensitivity shows consequences of explicit assumptions; forecasting and probability require additional methods and evidence. Label scenarios accurately and explain their purpose. Use them to identify constraints, resources, and decisions rather than presenting a hypothetical path as measured demand, a likely outcome, or proof of safety.
Can a positive earnings result still need additional cash?
Yes. Collections, redemptions, inventory, payroll, debt principal, capital spending, taxes, and other payments can differ from the earnings measure and occur at different times. Build a defined cash schedule and reconcile included items. A positive annual subtotal does not establish monthly liquidity or substitute for transaction-specific lender review.
Which sources support this guide?
Sources were checked during research. Regulations, lender policies, and market conditions can change. Use the linked primary material and your advisors to confirm applicability.
- Recordkeeping — Internal Revenue Service
- Revenue Recognition Implementation Q&As (January 2020) — Financial Accounting Standards Board
- 7(a) loans — U.S. Small Business Administration
Educational analysis prepared with AI-assisted research for The Med Spa Broker. “Last reviewed” records the source and editorial check date; it does not imply review by an attorney, clinician, or independent appraiser. Read our editorial standards.