The mandate
A proposed UK fund focused on sustainable real estate investments needed a financial model for portfolio planning and investor materials. The challenge was to show fund economics before the complete asset portfolio was known, while avoiding the false precision of treating every future investment as identical.
The mandate covered portfolio benchmarking, investor-return structuring and projections across different sustainable property categories. It did not include independent verification of environmental claims or legal interpretation of fund documents.
How the model was structured
The model used representative asset cohorts with separate acquisition timing, operating assumptions, financing and exit profiles. These cohorts rolled into a deployment schedule and portfolio cash flow, making it possible to test investment pace, concentration and diversification without inventing named assets.
Fund-level schedules incorporated commitments, capital calls, management costs, reserves and distributions. Gross asset performance reconciled to net investor cash flow through the fund expenses and distribution logic. Scenario analysis compared deployment pace, operating performance and exit timing.
ESG-related property categories were visible within the portfolio structure so the manager could compare allocation and financial performance, but the model did not assign unsupported sustainability scores or certification outcomes.
How the model supported the decision
The workbook created a consistent financial base for initial fundraising materials and internal portfolio planning. It showed how deployment, asset mix, fees and distribution timing interacted, and it allowed the manager to update the portfolio as opportunities progressed.
The model supported explanation and scenario analysis rather than guaranteeing fundraising or investment performance. No fund name, commitment amount, achieved return or investor identity is disclosed.
The cohort approach also provided a practical bridge between an initial strategy and a future identified portfolio. As potential acquisitions moved forward, representative assumptions could be replaced with asset-specific schedules while the commitment, capital-call, expense and distribution framework remained consistent at fund level. This preserved comparability between the early fundraising case and later portfolio updates.
Confidentiality note
This case study uses only previously published, non-confidential facts. Names, precise locations, deal values and realised results are withheld.