Methodology: twenty acquisition-cash scenarios
On this page
Version: 1.0. Calculation date: September 17, 2026. Type: Original illustrative model, not observed transactions.
Read the reader-facing article for the comparisons, or follow the inputs and calculations below to audit the model.
What M1–M5 mean
- M1 — Buyer-funded baseline. The buyer supplies 10% of project uses. There is no seller debt, and retained liquidity equals 4% of purchase price.
- M2 — Qualifying standby seller contribution. Required contribution stays at 10% of project uses, but a qualifying seller note supplies half of it. Buyer contribution falls; senior principal and current senior payments stay the same as M1. The model assumes the note qualifies and includes no current payments on it.
- M3 — More buyer equity. The buyer supplies 15% of project uses, with no seller debt. More cash goes into the project and less senior debt needs servicing. This is a model choice, not an asserted SBA minimum.
- M4 — More working capital and project costs. Working capital rises to 12.5% and eligible project costs to 4% of purchase price. The buyer still supplies 10% of the larger project, so both the contribution and senior debt increase.
- M5 — Paying seller debt and a larger cash buffer. Ordinary seller debt funds 10% of project uses, alongside the buyer’s 10% contribution. It reduces senior debt but adds its own payments. Retained liquidity rises to 8% of purchase price; the seller debt does not replace the buyer contribution.
Assumptions
All percentages below are selected modeling assumptions. Only the explanation of permitted SBA source treatment is grounded in the linked policy; the model does not approve eligibility.
Each row names the base used for its percentage. On a narrow screen, scroll within the table to compare M1–M5; keyboard users can focus the table region and use arrow keys.
| Input and percentage base | M1 | M2 | M3 | M4 | M5 |
|---|---|---|---|---|---|
| Working capital / price | 7.5% | 7.5% | 7.5% | 12.5% | 7.5% |
| Eligible project costs / price | 2.5% | 2.5% | 2.5% | 4% | 2.5% |
| Contribution / project | 10% | 10% | 15% | 10% | 10% |
| Qualifying standby seller / required contribution | 0% | 50% | 0% | 0% | 0% |
| Ordinary seller debt / project | 0% | 0% | 0% | 0% | 10% |
| Separate closing costs / price | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% |
| Separate already-paid costs / price | 1% | 1% | 1% | 1% | 1% |
| Retained buyer liquidity / price | 4% | 4% | 4% | 4% | 8% |
| Modeled cash flow / price | 20% | 20% | 20% | 20% | 20% |
Senior debt: fixed nominal 10% annual rate, monthly payments, ten-year fully amortizing schedule. Ordinary seller debt: 8%, monthly payments, ten-year amortization. Qualifying standby seller debt: no current payments included. Its eventual repayment/accrual economics are not modeled.
Rates are examples, not current quotes. Assumed cash flow is a model input, not lender-accepted EBITDA, a valuation conclusion, or a business listing’s SDE.
Formulas
- Build project uses
Project = purchase price + incremental working capital + eligible project costs.
- Calculate the required contribution
Required contribution = project × contribution percentage. Qualifying standby seller amount = required contribution × standby share.
- Separate the funding sources
Buyer contribution = required contribution − qualifying standby seller amount. Ordinary seller debt = project × ordinary seller percentage. Senior principal = project − buyer contribution − qualifying standby seller amount − ordinary seller debt.
- Find cash due at closing
Cash due at closing = buyer contribution + separate closing costs.
- Include the full buyer resource budget
Total buyer resources = cash due at closing + separate costs already paid + retained liquidity. Retained liquidity stays with the buyer; it is not a project funding source.
- Calculate monthly payments
For each paying loan: monthly payment = principal × r ÷ [1 − (1 + r)⁻ⁿ], where r is the nominal annual rate divided by 12 and n is 120 monthly payments. At a zero rate, payment = principal ÷ n.
- Test annual coverage
Annual debt service = 12 × (senior monthly payment + ordinary seller monthly payment). Assumed annual cash flow = purchase price × 20%. Debt service coverage ratio (DSCR) = assumed annual cash flow ÷ annual debt service.
Internal calculations use unrounded amounts. Displayed cash and annual debt-service figures use whole dollars, and coverage uses three decimals unless stated otherwise. CSV and JSON retain the script’s unrounded numerical outputs; recompute from those values rather than from rounded figures on this page.
Worked example: $1 million purchase, M1
The downloadable row is 1000K-M1. Its buyer resource budget is $175,000, of which $125,000 is due at closing.
- Project uses: $1,000,000 purchase price + $75,000 working capital + $25,000 eligible project costs = $1,100,000.
- Funding: 10% × $1,100,000 = $110,000 buyer contribution. With no seller debt, senior principal is $1,100,000 − $110,000 = $990,000. These sources exactly fund project uses.
- Closing cash: $110,000 buyer contribution + $15,000 separate closing costs = $125,000.
- Total resources: $125,000 + $10,000 previously paid costs + $40,000 retained liquidity = $175,000. The retained $40,000 is not paid into the project.
- Debt service: $990,000 at the modeled 10% nominal annual rate over 120 monthly payments produces $13,082.92 per month (displayed to cents). Using the unrounded payment, annual debt service is $156,995 (whole-dollar display; download: 156995.07541553315).
- Coverage: assumed annual cash flow of $200,000 ÷ unrounded annual debt service = 1.274× DSCR (download: 1.2739253092534386). Multiplying the displayed monthly payment by 12 can differ slightly from the unrounded annual result.
No credit toward contribution is assumed for the separate previously paid costs. This is a modeling choice, not a claim that paid diligence expenses cannot qualify. An actual accepted credit must reduce the remaining contribution consistently rather than be double-counted.
Sensitivity tests
The earnings downside reduces modeled cash flow by 10%, leaving payments unchanged. The rate sensitivity increases only the senior rate from 10% to 12%; seller pricing and other assumptions stay unchanged. These tests are separate and do not represent a combined stress or assigned probability.
For the $1 million M1 example, the earnings test lowers annual cash flow from $200,000 to $180,000 and DSCR from 1.274× to 1.147×. The separate senior-rate test produces 1.173× coverage. A lower ratio means less modeled cash flow is available per dollar of annual debt service; neither result predicts default or approval.
M1 vs. M2 isolates qualifying standby contribution. M1 vs. M3 isolates higher buyer contribution. M1 vs. M4 changes working capital and project costs together. M1 vs. M5 changes both the debt mix and retained liquidity; do not describe it as a single-factor experiment.
Limitations and interpretation
The twenty rows are a deterministic grid, not a sample of acquisitions. Costs, cash flow and funding all scale with purchase price, so each configuration has the same DSCR at every price. That is a property of the model, not evidence that business size has no effect on lending risk.
The model omits business valuation, taxes, investor ownership economics, changing rates over time, irregular disbursement periods and company-specific working-capital forecasts. It does not model the eventual repayment or interest accrual economics of the standby seller note. Actual expenses may not scale with price, and a retained cash buffer is not proof of operating adequacy.
The sensitivity tests change one stated input at a time. They do not combine weaker earnings with higher rates, assign probabilities, or establish a sufficient stress test for every business. Replace assumptions with transaction-specific evidence before using the arithmetic in a financing decision.
Policy context
SOP 50 10 8.1, Appendix 15 supplies the current Initial Acquisition contribution and coverage context. Information Notice 5000-880695 defines the October 1, 2026 loan-number applicability trigger. These are distinct from modeled assumptions. The October technical update was checked on October 5, 2026; the scenarios remain hypothetical business-only acquisitions and do not model the qualifying owner-occupied Special Purpose Property exceptions.
Passing a mathematical threshold does not establish loan eligibility. In particular, valuation, accepted earnings adjustments, working-capital adequacy, source terms, and all lender conditions remain outside this model. No scenario is represented as approved. M4 falls below a 1.25× reference even with the full modeled buyer resources.
Reproduce and inspect
The script requires Python 3 and uses only its standard library; no package installation is needed.
- Download
reproduce_cash_scenarios.pyinto a new folder. Keep any original CSV and JSON downloads in a separate folder if you want to compare them. - Open a terminal in the folder containing the script and run
python3 reproduce_cash_scenarios.py. - Expect the message: “Generated 20 illustrative scenarios; all sources equal uses.”
- Find
cash-scenarios.csvandcash-scenarios.jsonbeside the script. The script resolves its own location, so output goes there even if you invoke it from another working directory. Existing files with those names in that folder are overwritten.
The script checks that funding sources equal project uses for every row, confirms twenty scenarios and tests zero-rate payment behavior. Its payment function rejects negative principal or rates and nonpositive terms. These checks establish arithmetic consistency, not eligibility or the realism of assumptions. It does not access financial accounts or external APIs.
License and attribution
Duneland Financial’s original twenty-scenario dataset is available under Creative Commons Attribution 4.0 International (CC BY 4.0). When sharing or adapting it, credit Duneland Financial, link to this methodology and the license, and indicate any changes.
Suggested attribution: “Twenty modeled acquisition-cash scenarios, Duneland Financial, version 1.0, calculated September 17, 2026. CC BY 4.0.” The October 19, 2026 editorial update improves the explanation and presentation; it does not change the calculation date or model inputs. The SBA policy documents linked above remain external sources; this attribution and license do not claim ownership of them.
