🔒 Runs entirely in your browser — no data is ever sent or stored anywhere.
Loading model…
Rename the four scenarios to whatever fits your deal — the names update everywhere automatically.
| Parameter |
|---|
Copy straight from Excel, columns in this order: Use type, Unit name, Tenant, Sqm/lots, Rent per unit, Lease end date. Write "vacant" in the Tenant column for empty units. Max 300 rows — number of rows doesn't matter, column order does.
"Segment" is auto-detected from the use type. Ovr R1/R2/R3 let you override the model's own renew/vacate decision for one specific unit at roll 1, 2, or 3 — set "Yes" to force that unit to renew, "No" to force it to vacate, or leave "(auto)" to let the model decide from the scenario's rollover probability. This is the same override the Excel file exposes in columns K-M.
| # | Use type | Unit name | Tenant | Sqm/lots | Rent/unit | Lease end | Segment | Ovr R1 | Ovr R2 | Ovr R3 |
|---|
Line items per scenario. Amounts feed directly into the Cash Flow and Results. CapEx type: M = maintenance — flows into NOI and financing, reduces cash flow directly. R = refurbishment — equity-funded, excluded from NOI, tracked separately for the incremental-IRR (refurb feasibility) calculation. Recurring? (NonRecs / Marketing): Y = repeats every year from the given year onward. N = one-off cost in that year only.
Unchecked = fully equity-funded, all-cash (LTV forced to 0)
| Metric |
|---|
| Metric |
|---|
| Refurb feasibility (incremental) |
|---|