Mixed-Use Development

A large mixed-use scheme combined residential units, retail space and offices, each with different revenue timing and operating assumptions. The sponsor needed to understand the project as one funding requirement while retaining enough detail to review the economics of each component separately.

The central modelling challenge was allocation. Shared infrastructure, construction and financing costs could not be assessed sensibly if each use was modelled in isolation, yet a single blended revenue assumption would hide which element created or absorbed value.

The model created separate operating schedules for residential sales, retail leasing and office leasing. Each module used its own areas, pricing or rent, absorption, incentives, occupancy and stabilisation profile. These schedules rolled into a consolidated development cash flow aligned to the phase programme.

Direct costs were assigned to the relevant use, while shared costs were allocated through documented drivers. The financing module measured the resulting equity and debt requirement over time. Returns were calculated at component and consolidated levels so the sponsor could distinguish operating performance from the effect of financing and phasing.

Scenario controls compared changes in build timing, lease-up, sales absorption, rental growth and exit assumptions. This allowed the team to evaluate sequencing choices without maintaining multiple disconnected workbooks.

The combined model established a common analytical base for development, finance and capital-raising discussions. It highlighted how the timing of one component could affect peak funding and the returns of the overall scheme, even where that component looked attractive on a standalone basis.

The output supported capital-structure and phasing decisions by making cross-subsidies and shared-cost assumptions visible. Outcomes are described as decision support only; no funding amount, achieved return or client identity is claimed.

Because every use remained identifiable inside the consolidated cash flow, the sponsor could discuss changes with the relevant commercial team without losing the whole-project view. The structure also left a clear path for replacing early assumptions with leasing, sales and cost information as the scheme progressed.