This workbook was made to compare cases without mixing assumptions and outputs in the same place.
The structure lets a reader move from assumptions to scenarios and then to grant coverage, so the logic stays visible.
Workbook: 03_Funding_Plan_Scenarios.xlsx
Download original
Scenario Model
A scenario workbook that shows how funding and delivery assumptions change the plan.
- Scenario planning
- Assumption testing
- Funding coverage
Overview
Source sheet: 00_Read_Me
Scroll sideways to inspect the full sheet.
| xTend — Funding Plan Scenarios | ||||
| Forward-looking. All inputs derived from confirmed source figures. | ||||
| This workbook answers: 'What does it cost xTend to deliver N arms, and what funding does it need to raise?' All cost inputs come from the P2 file (£91/arm basic, £158/arm bionic, £1,046 Phase 1 equipment, £3,378 Capacity Build). Arm-count targets are scenario inputs — edit cells in '02_Scenarios' to model alternative plans. | ||||
Assumptions
Source sheet: 01_Assumptions
Scroll sideways to inspect the full sheet.
| Confirmed-source Assumptions | ||
|---|---|---|
| Input | Value (£) | Source |
| Cost per basic arm (materials + delivery) | £91 | P2 file, Phase 1 sheet: £46 + £45 |
| of which materials | £46 | P2 file, Phase 1 sheet, R19 |
| of which delivery | £45 | P2 file, Phase 1 sheet, R23 |
| Cost per bionic arm (components + delivery) | £158 | P2 file, Phase 2 sheet, R27 |
| of which components | £130 | P2 file, Phase 2 sheet, R20 line total |
| of which delivery | £40 | P2 file, Phase 2 sheet, R24 |
| Phase 1 equipment (one-time) | £1,046 | P2 file, Phase 1 sheet, R11 |
| Capacity build — equipment (one-time) | £2,463 | P2 file, Capacity sheet, R11 |
| Capacity build — prototyping (one rotation) | £915 | P2 file, Capacity sheet, R18 |
| Capacity build total | £3,378 | P2 file, Capacity sheet, R20 |
| Phase 2 operational tooling | £133 | P2 file, Phase 2 sheet (sum of itemised lines) |
| NHS comparator per arm | £2,600 | HY CV, Abstract paragraph 2 |
| Arms delivered to date | £1 | CV: 1 arm to Ksar el Kebir, Morocco within ~6 months of founding |
Scenarios
Source sheet: 02_Scenarios
Scroll sideways to inspect the full sheet.
| Funding Plan — Scenarios (editable arm counts) | ||||
|---|---|---|---|---|
| Line | A: 'Steady' | B: 'Capacity Build' | C: 'Wolfson + Capacity' | D: 'Stretch' |
| Basic arms delivered | 10 | 30 | 50 | 100 |
| Bionic arms delivered | 0 | 5 | 10 | 20 |
| Equipment plan (one-time £) | £1,046 | £3,378 | £3,378 | £3,378 |
| Phase 1 equipment | £1,046 | £1,046 | £1,046 | £1,046 |
| Capacity build (add'l) | 0 | 2332 | 2332 | 2332 |
| Basic arms cash (basic × £91) | £910 | £2,730 | £4,550 | £9,100 |
| Bionic arms cash (bionic × £158) | £0 | £790 | £1,580 | £3,160 |
| Phase 2 tooling (if any bionic) | £0 | £133 | £133 | £133 |
| TOTAL FUNDING REQUIRED (£) | £1,956 | £7,031 | £9,641 | £15,771 |
| Arms total | 10 | 35 | 60 | 120 |
| Avg cost per arm (incl. equipment) | £196 | £201 | £161 | £131 |
| Equivalent NHS cost saved (£) | £24,044 | £83,969 | £146,359 | £296,229 |
| Funding gap vs known cash on hand (placeholder) | TBD — fill cash-on-hand | TBD — fill cash-on-hand | TBD — fill cash-on-hand | TBD — fill cash-on-hand |
Grant Coverage
Source sheet: 03_Grant_Coverage
Scroll sideways to inspect the full sheet.
| Which Grants Would Close Each Funding Need | |||||
|---|---|---|---|---|---|
| Scenario | Funding required | Weighted pipeline (per 02_Grant_Pipeline) | Headline grants needed | Coverage ratio (weighted) | Comment |
| A: 'Steady' — 10 basic arms | £1,956 | £8,500 | Ann Rylands + 1 small trust covers this | 435% | Phase 1 only — no new equipment needed if already purchased |
| B: 'Capacity Build' — 30 basic + 5 bionic | £7,031 | £8,500 | Bailey Thomas + Anton Jurgens + Westham House | 121% | Adds 2× Cr-10, 3× Bamboo, prototyping |
| C: 'Wolfson + Capacity' — 50 basic + 10 bionic | £9,641 | £33,500 | Wolfson £25k + 2–3 mid-size trusts | 347% | Wolfson opens up the model |
| D: 'Stretch' — 100 basic + 20 bionic | £15,771 | £33,500 | Wolfson + James Tutor + Anton Jurgens + corporate top-up | 212% | Multi-funder coordination required |