How do you model acquisition debt service after client losses?

What question should the downside model answer?

It should show whether a proposed acquisition can continue operating and meet required payments when important assumptions worsen. The valuation hub helps distinguish affordable price from headline price. A debt-service model connects earnings, financing terms, and liquidity; it does not approve a loan or establish the practice’s value by itself.

Start with the buyer’s intended operating structure. If the seller’s earnings depend on unpaid owner work, the buyer’s repayment case needs the replacement plan or clearly stated buyer participation. Use the owner-hours recast before treating the seller’s reported profit as available cash for debt.

Keep the base case auditable. Tie revenue to client and service evidence, costs to payroll and contracts, and debt to the lender’s proposed schedule. If the starting case is unsupported, adding downside percentages gives the appearance of rigor without a reliable foundation. Mark unresolved amounts rather than hiding them in a miscellaneous reserve.

Which current financing requirements must be identified?

The SBA 7(a) overview includes ownership changes among program uses. Eligibility and underwriting depend on the actual request and current policy. Ask the lender to identify the change-of-ownership category, required equity, permitted seller debt, financial due diligence, repayment calculation, and any additional lender conditions.

Current SOP 50 10 8.1, effective October 1, 2026, distinguishes initial acquisitions and business expansions. Its stated minimum debt-service coverage is 1.25 for initial acquisitions and 1.15 for business expansions, with category-specific requirements. Other acquisition categories have their own provisions. Do not treat either number as universal loan approval.

The lender may require stronger coverage or additional analysis. It must also apply the relevant measurement periods and definitions. Record those assumptions in the model. A ratio calculated from a broker’s preferred earnings subtotal cannot be assumed to match the lender’s required cash-flow measure merely because both are called coverage.

How should the financing schedule be assembled?

List acquisition debt, any continuing business debt, permitted seller-note payments, and other required financing obligations. Record principal, interest structure, amortization, maturity, payment frequency, fees where relevant, and any balloon. Keep debt principal and interest cash payments visible even when the earnings subtotal treats them differently.

If seller debt is on standby or subordinated, use the actual restrictions. A qualifying seller-debt injection under current SBA policy has specific full-term standby and subordination conditions; it should not be modeled as freely payable cash debt during that restricted period. Confirm the structure with the lender instead of relying on a generic seller-financing assumption.

Stress variable-rate exposure using explicit illustrative changes, without presenting a hypothetical rate as a current quote. Recalculate payments under the actual amortization and reset terms. If a loan has a balloon, include a separate maturity-funding analysis; refinancing should remain an assumption until there is evidence supporting it.

How can client losses be translated into earnings?

Identify the clients or cohorts at risk, their fees, direct service effort, and contribution after relevant costs. A loss of low-contribution work differs from a loss of high-contribution recurring clients. Separate client departure from reduced scope, delayed collections, and fee changes. They can have different effects on profit and cash.

Do not assume staff expense falls immediately with lost revenue. Employment arrangements, service commitments, and minimum operating capacity can delay any savings. Show the specific cost reduction and its effective date. If the buyer expects to replace lost clients, model that as a separate recovery case with a supported acquisition timetable.

What does an illustrative annual sensitivity show?

Assume reconciled operating cash capacity of $200,000 under a defined illustrative measure, with $140,000 of annual required debt service. Coverage is about 1.43. This simplified ratio is not a lender definition or an approved financing case; the amounts are invented for demonstrating sensitivity.

Now assume a client-loss case reduces annual fees by $50,000 and produces only $10,000 of supportable annual cost savings. Cash capacity falls by $40,000 to $160,000, and coverage falls to about 1.14. If required payments also rise to $150,000 under a separate rate case, combined coverage is about 1.07.

The example does not predict retention or rate movements. It shows why a revenue loss can consume much of the margin above debt payments. Compare the result with the actual lender’s definition and requirements. Then examine cash timing: a positive annual surplus may arrive after the period when payroll and loan payments must be made.

Use a consistent treatment of taxes, owner compensation, capital needs, and add-backs across cases. Do not improve the stressed case by dropping an expense included in the base case unless the underlying operating change supports it. Every scenario should be traceable to the same starting financial reconciliation.

Why is collection timing a separate test?

The IRS accounting-method guidance explains cash and accrual timing distinctions. A debt payment requires cash, regardless of when the related service revenue is recognized. Use the cash-to-accrual bridge to understand the historical reports, then build a receipt schedule for the buyer’s actual operating cycle.

Forecast opening cash, client collections, payroll, vendor obligations, taxes, integration costs, and financing payments by month or week. Identify the lowest cash balance under each case. A loan-funded reserve, buyer equity reserve, and transferred working capital are different sources and should not be counted twice.

The working-capital peg guide explains the closing-balance mechanism. Receiving the agreed working capital does not prove that collections will arrive before obligations. Reconcile the peg and the liquidity forecast so a purchase-price credit is not mistaken for usable bank cash at the required time.

Which combined stresses deserve attention?

Choose combinations that could plausibly occur together in this practice. A reviewer departure may delay work and billing while raising temporary staffing expense. A client communication failure may reduce renewals and extend collection time. Those interactions can matter more than testing each variable in isolation.

Avoid stacking unrelated worst cases without explanation. An extreme scenario can be useful, but it should be labeled as an extreme stress rather than a forecast. Show which assumptions are linked and which are independent. The buyer and lender need to understand the mechanism producing the cash deficit, not just the final alarming number.

What should the buyer do with a failed case?

Identify the cause and potential response: lower acquisition debt, more equity, a reserve, phased hiring, revised terms permitted by the financing, or improved transition planning. Test the response in the same model. Do not assume an unavailable credit line or prohibited earnout fixes the problem.

The completed record should include lender definitions, reconciled inputs, dated payments, scenario assumptions, coverage results, minimum cash, and unresolved conditions. That evidence supports a practical financing discussion. A green spreadsheet cell is useful only when the practice can deliver the modeled work and cash under the stated ownership plan.