Quantitative finance · 2026
Healthcare Fund Modelling
Connect the economics of one clinic to a whole portfolio.
This work began with the economics of individual healthcare businesses and grew into a model of how they fit together. A consistent structure for operations, funding, ownership and distributions connects portfolio results to their assumptions and shows which decisions change the outcome.
- Status
- Built
- Domain
- Financial modelling · Scenario analysis
- Role
- Model architecture, research, workbook development & reconciliation
- Year
- 2026
Explore the workflow with illustrative content.
Set a starting point
A reference series provides a common starting point. The curves are illustrative, so this view demonstrates comparison rather than forecasting a result.
Change the assumption
Choose a scenario below. Its path and uncertainty band change together while the original reference stays visible.
Review the difference
The foreground markers show where the selected scenario separates from the reference. Use the layer controls to isolate each part.
Illustrative content · no live data
See how an assumption travels through a model
Stack
- Excel
- Driver-based models
- Cash-flow modelling
- Scenario analysis
- Source registers
A family of linked analytical workbooks for exploring healthcare operations, deployment timing, financing and portfolio cash flows.
Build up from operations
Each business model uses a shared structure for revenue, labour, occupancy, equipment and cash flow.
Sector-specific assumptions remain separate from that structure. This makes different healthcare activities easier to compare and allows the portfolio model to consolidate them consistently.
Keep the financing visible
Operating performance, ownership and financing sit in separate layers.
Deployment timing, working capital, distributions and the choice to hold or exit can then be explored explicitly. A change in funding assumptions remains distinguishable from a change in the underlying business.
Challenge the starting assumptions
Companion research compares operating benchmarks with sourced equipment, staffing and service costs.
Variances are documented so reviewers can see where an assumption has support and where it remains indicative. Sensitivity workbooks then test alternative timing and portfolio mixes.
May–July 2026: from unit economics to lifecycle models
The work developed from sector operating models into a consolidated lifecycle workbook, with later versions adding review schedules and scenario comparisons.
The public description focuses on the modelling structure. Investment terms, deal assumptions and financial results stay within the private workbooks.
Behind the work
The skills
that came together.
Model architecture
- Consistent operating and cash-flow structures
- Acquisition and greenfield scenarios
- Portfolio consolidation and financing layers
Research & review
- Sourced assumptions and confidence grading
- Operating-cost reconciliation
- Sensitivity analysis and audit schedules
Project highlights
-
Consistent foundations
Comparable operating models across sectors
-
Traceable assumptions
Research and reconciliation support the inputs
-
Explore the lifecycle
Deployment, operations, financing and distributions