- 01
Asset
ILU countMixCare optionYear stabilised - 02
Service revenue
Service feeExit feeAncillaryCare fees - 03
DMF rollover
DMF percentageTenure assumptionRollover frequencyCapital gain share - 04
Operating cost
Operator staffOutgoingsCare opexMarketing - 05
Refurb capex
Unit refurb $/unitCommon area capexCare capexReserve $/unit - 06
Hold finance
Resident loan poolBank facilityInterestCoupon - 07
Hold and exit
Hold yearsDiscount rateSelling costInflation
What this model does
Retirement operating operating model, end to end.
Run the retirement village across the long-tail horizon. Service fees, DMF rollover and care opex drive operating cashflow, with refurb capex reserved on unit turnover.
Schema
Every input. Every output. In one view.
The full retirement operating operating model schema. 7 input blocks feeding 8 output metrics, with the calculation engine in between.
- Year-one service NOI$1.2M
- DMF NPV$28.4M
- Annual rollover8 units
- Tenure assumption9 years
- Care cost ratio42%
- Refurb $/unit$28k
- Hold horizon15 years
Engine logic
Two engines. Scenarios and cashflow.
The two pieces that separate the retirement operating operating model from a spreadsheet. Scenarios that share one project, and a monthly cashflow wired to every input.
Multiple scenarios, one project
Switchable in a click. No copied files.
- 01
Rollover pace and tenure assumption as scenario levers.
- 02
DMF percentage and capital gain share per scenario.
- 03
Care opex and care utilisation per scenario.
- 04
Each scenario carries its own discount rate.
Monthly cashflow, fully connected
Every input touches the schedule.
- 01
Monthly cashflow across the long-tail horizon.
- 02
Service fees run alongside rollover inflows.
- 03
DMF accrued through tenure and realised on rollover.
- 04
Refurb capex drawn on unit turnover, with reserve sized to the cycle.
Excel replacement
Where the workbook quietly fails.
Every row is a recurring failure mode of the retirement operating operating workbook, and how the model handles it once.
Use and verify
What it decides. What to check first.
The decisions the retirement operating operating model is built to support, alongside the things to verify before you trust it on a live deal.
- 01
Forecast service NOI
Service fees, ancillary and care fees through the horizon.
- 02
Plan the rollover
Rollover pace and DMF realisation across the horizon.
- 03
Size the refurb reserve
Refurb $/unit and reserve cycle as live inputs.
- 04
Pressure-test the discount rate
Discount rate sensitivity on the DMF NPV.
Questions
Retirement operating operating model, answered.
How Popurise handles the retirement operating operating model.
How is this different from the retirement feasibility model?
Feasibility answers whether to build and sell down. Operating answers how the stabilised village runs across the rollover horizon.
How is DMF realised?
Accrued through tenure and realised on rollover. Frequency and tenure live as inputs.
Does it handle care opex?
Yes. Care opex sits alongside ILU operating cost, with its own build-up.
Can I stress rollover pace?
Yes. Rollover frequency and tenure assumption carry their own stress scenarios.
Shape the retirement operating model in Popurise.
Tell us how your team runs this asset today. We are building the operating model with the owners and operators who will use it.