Free early accessis open for residential development teams. Start modelling today.

Start modelling
Investment model · Register interest

Stabilised value, computed end to end.

Forward NOI capitalised at the exit cap rate, with value uplift and downside spread. The valuation the investment committee will sign off.

  • Inputs7 blocks
  • Outputs8 metrics
  • CashflowMonthly
  • ScenariosPlanned

What this model does

Stabilised value investment model, end to end.

Value the stabilised asset cleanly. Forward NOI capitalised at the exit cap rate, with value uplift relative to cost and downside spread on cap rate movement.

Calculation flow05 steps
  1. 01

    Asset position

    Cost basis, stabilised NOI and stabilisation date captured.

  2. 02

    Forward NOI

    NOI projected forward with rent growth, capex and vacancy reserve.

  3. 03

    Capitalisation

    Exit cap rate applied to forward NOI; gross value returned.

  4. 04

    Value uplift

    Value uplift over cost basis returned, with selling costs netted.

  5. 05

    Sensitivity

    Cap rate range and rent growth scenarios produce a valuation band.

Schema

Every input. Every output. In one view.

The full stabilised value investment model schema. 7 input blocks feeding 8 output metrics, with the calculation engine in between.

Inputs07 blocks
  1. 01

    Asset position

    Cost basisStabilisation dateSectorQuality grade
  2. 02

    Stabilised NOI

    Effective rentRecoveriesOperating costCapex reserve
  3. 03

    Forward income

    Rent growthVacancy reserveCapex drawInflation
  4. 04

    Capitalisation

    Exit cap rateCap rate rangeSelling costDiscount
  5. 05

    Capital stack

    LVRCouponEquity tranchePromote
  6. 06

    Comparable evidence

    Comparable cap ratesRecent salesYield bandsQuality adjustment
  7. 07

    Sensitivity

    Cap rate stressRent growth rangeVacancy stressCapex stress
Outputs08 metrics
Primary outputAt base case
Stabilised value$208.0M
MetricValue
  • Forward NOI$11.4M
  • Exit cap rate5.4%
  • Value uplift$33.0M
  • Uplift ratio19%
  • Downside value$182.0M
  • Upside value$232.0M
  • Valuation band±12.5%

Engine logic

Two engines. Scenarios and cashflow.

The two pieces that separate the stabilised value investment model from a spreadsheet. Scenarios that share one project, and a monthly cashflow wired to every input.

Scenarios01 / 02

Multiple scenarios, one project

Switchable in a click. No copied files.

  1. 01

    Cap rate range and rent growth as scenario levers.

  2. 02

    Vacancy and capex stress per scenario.

  3. 03

    Comparable evidence captured per scenario.

  4. 04

    Each scenario returns its own valuation band.

Cashflow02 / 02

Monthly cashflow, fully connected

Every input touches the schedule.

  1. 01

    Forward NOI projected annually, with stabilised year as the base.

  2. 02

    Rent growth, vacancy reserve and capex draw applied year by year.

  3. 03

    Capitalisation at the exit cap rate on stabilised year forward NOI.

  4. 04

    Selling costs netted from gross value to return net value.

Excel replacement

Where the workbook quietly fails.

Every row is a recurring failure mode of the stabilised value investment workbook, and how the model handles it once.

SpreadsheetPopurise model
  • 01Valuation as a single numberValuation band with downside and upside
  • 02Cap rate range buriedCap rate range as a live scenario
  • 03Comparable evidence in a separate fileComparable cap rates captured alongside the model

Use and verify

What it decides. What to check first.

The decisions the stabilised value investment model is built to support, alongside the things to verify before you trust it on a live deal.

What it decidesUse cases
  1. 01

    Value the stabilised asset

    Forward NOI capitalised at the exit cap rate. Value falls out.

  2. 02

    Brief the valuer

    Comparable cap rates, recent sales and quality adjustments captured cleanly.

  3. 03

    Stress-test the cap rate

    Cap rate range as a scenario. Valuation band falls out.

  4. 04

    Brief the IC

    Valuation, uplift over cost and downside spread on one page.

Pre-flight checklist05 checks

  • Forward NOI projected, not just year one.

  • Cap rate range as a live scenario.

  • Valuation band with downside and upside.

  • Comparable evidence captured alongside the model.

  • Selling costs netted from gross value.

Worth checking before you stake a live deal on the stabilised value investment model.Register interest
Related models

Hold/sell analysis model

Open

Yield on cost model

Open

Debt and equity funding model

Open

Questions

Stabilised value investment model, answered.

How Popurise handles the stabilised value investment model.

Is the stabilised value model live today?

Not yet. Popurise is live for residential feasibility. Investment models are on the expansion roadmap.

How is value uplift calculated?

Stabilised value minus cost basis, with selling costs netted from the gross value.

Does it produce a valuation band?

Yes. Downside and upside cases run alongside the base case.

Can I capture comparable evidence?

Yes. Comparable cap rates and recent sales sit as live inputs alongside the model.

Shape the stabilised value model in Popurise.

Tell us how your team makes this decision today. We are building investment models with capital allocators and investment committees.

Register interest View investment models