Local scenario worksheet
Revenue concentration
What happens to your cash if one customer or platform disappears? Start with this hypothetical example, then replace it with your own monthly figures. Inputs stay in this page; no signup is required.
Monthly revenue sources
Use anonymous names. Group customers that share one platform when testing a platform loss; avoid counting the same revenue twice.
Your dependency and loss scenario
- Total monthly revenue
- $10,000
- Largest source share
- 60.0%
- Top three source share
- 100.0%
- Concentration index (0–10,000)
- 4600
- Revenue lost each month
- $6,000
- Available cash after reserve
- $20,000
- Baseline net monthly burn
- $1,000
- Loss scenario net monthly burn
- $5,800
- Baseline cash runway
- 20.0 months
- Loss scenario cash runway
- 3.4 months
- Customer A: 60.0%
- Customer B: 30.0%
- Customer C: 10.0%
Method and limitations
Shares are source revenue divided by total revenue. The concentration index adds squared percentage shares: one source is 10,000; four equal sources are 2,500. It measures concentration, not failure probability. Available cash is cash minus the protected reserve, floored at zero. Burn is expenses minus revenue after your tax reserve; the loss scenario removes selected sources and applies your expense reduction immediately. Runway is available cash divided by positive burn. All figures use the selected currency without conversion.
Revenue, taxes and costs stay constant. This excludes receivables timing, debt repayments unless included in expenses, severance, replacement sales and gradual recovery. Tax reserve is your assumption, not a tax calculation. Correlated customers can fail together; test that by selecting multiple sources. No cash depletion means income covers costs under these assumptions, not guaranteed permanent income.
Next: test a smaller revenue loss, a delayed expense reduction and a larger protected reserve. Compare with the runway calculator for household costs and buffers.