Healthcare Facility

A specialist healthcare facility required a projection that treated the real estate and the operating business as connected parts of the same financing question. A property-only rent schedule would not show whether clinical activity could support the facility's fixed costs and future capital needs.

The model therefore needed a long enough horizon to show operational ramp-up, recurring expenditure, asset maintenance and funding requirements while keeping the major assumptions accessible to non-modellers.

Revenue schedules were built from operating activity and pricing assumptions supplied for the engagement. Staffing and other operating costs were separated into fixed and activity-linked categories so the facility's operating leverage could be understood. These schedules produced an integrated operating cash flow rather than a top-down growth forecast.

The property and capital module tracked facility costs, equipment or improvement expenditure and the timing of longer-term investment. Funding requirements were calculated from the resulting cash profile. Scenario analysis tested slower activity growth, cost pressure and changes in capital timing.

Outputs focused on cash requirement, operating sustainability and the relationship between activity and fixed commitments. Assumption and check sections made it possible to trace the model from operational inputs through to the funding view.

The model provided a structured basis for a project-financing review over a ten-year projection horizon. It helped the team distinguish short-term ramp-up needs from recurring operating performance and planned capital expenditure.

The output was designed to support internal and financing conversations, not to provide clinical, legal, tax or property valuation advice. No client identity, financing amount or realised performance is disclosed.

By separating activity drivers from fixed commitments, the workbook also made management conversations more specific. Reviewers could identify whether a funding gap arose from the speed of operating ramp-up, the underlying cost base or the timing of planned capital work, then test those factors without disturbing unrelated assumptions.