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
Healthcare Fund Modelling · Interactive concept

Explore the workflow with illustrative content.

Stage 03 / 03

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.

01

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.

02

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.

03

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.

04

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