Prototype. Every figure on this page is illustrative. The register holds 8 sample assets from the MoPED data-model workbook and 112 generated to match its schema — no real asset, valuation or coordinate.
Scenarios
Assumptions sandbox
The workbook describes its benchmark rates as illustrative placeholders to be replaced with MoPED-agreed figures, and expects the renovation rates to change per governorate and asset class. Move them here and the whole register recalculates through the same formulas the sheet uses.
Assumptions
The workbook's own value is shown in grey once a slider moves.
Annual revenue gap
EGP 553m
0.0% vs the workbook
Net operating income
EGP 576.7m
0.0% vs the workbook
CapEx to activate
EGP 2.7bn
0.0% vs the workbook
Assets clearing hurdle
36
at 12.0% — 36 at the workbook's rate
Scenario against the workbook
Portfolio totals recomputed through lib/formulas.ts, the same port of the sheet the register uses.
- Workbook
- Scenario
| Measure | Workbook | Scenario | Change |
|---|---|---|---|
| Market value | EGP 9.7bn | EGP 9.7bn | — |
| Post-renovation value | EGP 10.8bn | EGP 10.8bn | — |
| CapEx to activate | EGP 2.7bn | EGP 2.7bn | — |
| Net operating income | EGP 576.7m | EGP 576.7m | — |
| Revenue gap | EGP 553m | EGP 553m | — |