What could change the answer — and what is still unknown
Every conclusion rests on unverified calibrations and a few unresolved legal questions. Here they are, stated plainly, so nothing is hidden.
Which lever moves O3 the most?
Holding everything else at base, each scenario perturbs one input. The chart shows O3 operator NPV under each shock, per market. No scenario turns O3 positive.
Per unit, EGP nominal, 10-year term.
| Scenario | Cairo | North Coast | Red Sea |
|---|---|---|---|
| Base | -0.37M | -0.38M | -0.19M |
| VAT 14% | -0.42M | -0.43M | -0.22M |
| Revenue ×0.75 | -0.49M | -0.51M | -0.26M |
| Revenue ×1.5 | -0.23M | -0.20M | -0.10M |
| Overrun +25% | -0.57M | -0.58M | -0.30M |
| Inflation +3pt | -0.40M | -0.40M | -0.21M |
| Pass-thru 0.6 | -0.39M | -0.40M | -0.20M |
| s_op 40% | -0.35M | -0.35M | -0.17M |
The most favourable single lever — revenue ×1.5 — still leaves O3 negative in all three markets (Cairo −0.23M, North Coast −0.20M, Red Sea −0.10M). Overrun is the worst: a +25% cost overrun pushes O3 to around −0.6M on the North Coast (Sahel).
0% vs 14% on short stays
Whether short-term stays attract VAT is an unresolved legal question. The model runs both ways.
| Market | VAT 0% | VAT 14% | Cost of VAT |
|---|---|---|---|
| Cairo | -0.37M | -0.42M | -0.05M |
| North Coast | -0.38M | -0.43M | -0.05M |
| Red Sea | -0.19M | -0.22M | -0.03M |
VAT at 14% costs roughly 0.03–0.05M per unit NPV. Per unit, EGP nominal, 10-year term.
Every number that carries an [est]
These are the estimates that feed the headline numbers, none yet verified against real operator data. Each badge carries the reason it matters.
| Calibration | Value | Why it matters |
|---|---|---|
| Base gross yield est | 9–11% | Cairo 10%, North Coast (Sahel) 9%, Red Sea 11%. The single largest driver of every result. |
| Premium revenue uplift est | +18% | Assumed revenue uplift for premium fit-out. If premium earns less than this, premium is worse than mid everywhere. |
| Mid fit-out cost est | EGP 8,300 / m² | DeepSeek’s range was 7,900–8,700. Unverified calibration. |
| Premium fit-out cost est | EGP 12,500 / m² | Analyst guess, unverified. Raises capex ~50% vs mid. |
| Resale discount (unfinished) est | 30% | Discount of a core-and-shell unit vs a finished unit. Unverified calibration. |
| Residual fit-out value est | 10% | Residual value of the fit-out at end of term. Unverified calibration. |
| Operator hurdle est | T-bill + 8pt | Discount rate for operator NPV. T-bills near 25%; a lower (cheaper-capital) hurdle is the biggest lever after yield. |
| VAT on short stays est | 0 or 14% | Modelled at 0 or 14%; costs ~0.03–0.05M per unit NPV. Unresolved legal question. |
What needs real data before this is anything but a model
These are the inputs that would most change the answer once verified.
- Realised gross yield per market — the single largest driver. Needs actual operator data (Nawy Unlocked, Prime, Brassbell, or AirDNA-type data) or a 3-unit pilot.
- VAT on short-term accommodation — modelled at 0 or 14%, costs ~0.03–0.05M per unit NPV.
- Fit-out EGP/m² — mid 8,300 (DeepSeek’s 7,900–8,700), premium 12,500 is a guess.
- Hurdle — T-bill path + 8pt. A lower hurdle (cheaper capital) is the biggest lever after yield.
- Unit values, areas, fixed opex per m², resale discount (30%), residual value of fit-out (10%).
- Legal — usufruct vs registered lease, 8+ unit licensing, Law 230 for foreign owners.
- Usufruct vs registered lease — which legal form the owner-operator relationship takes.
- 8+ unit licensing — whether a multi-unit operation triggers a hospitality licence.
- Law 230 — foreign ownership restrictions for non-Egyptian owners.
- FRA Law 18/2020 — whether the deferral markup falls under consumer-finance regulation.
- VAT on short-term stays — 0% or 14%, unresolved.
None of these legal items is modelled — they are treated as open questions, not assumptions. Each could change the structure: the usufruct vs lease question changes who can operate; the 8+ unit licensing question changes the operating model; Law 230 changes who can be an owner; FRA Law 18/2020 changes whether the deferral markup must be fixed at signing (murabaha-style) rather than accruing; and VAT changes the cost side. Until they are resolved by a lawyer, treat the deal as a structure, not a product.
Two more levers we tested — neither fixes O3
v3b tested cheaper capital and a minimum draw with owner-paid shortfall. Cheaper capital helps O2 but not O3; the minimum draw does not help at all.
Cheaper capital: helps O2, still not O3
| Option | Hurdle cut | Cairo | North Coast | Red Sea |
|---|---|---|---|---|
| O3 | 0pt | -0.37M | -0.38M | -0.19M |
| -10pt | -0.23M | -0.22M | -0.10M | |
| -20pt | 0.01M | 0.05M | 0.05M | |
| O2 | 0pt | -0.08M | -0.07M | -0.03M |
| -10pt | 0.01M | 0.04M | 0.04M | |
| -20pt | 0.17M | 0.22M | 0.15M | |
| O1 | 0pt | 0.20M | 0.23M | 0.14M |
| -10pt | 0.25M | 0.30M | 0.18M | |
| -20pt | 0.35M | 0.43M | 0.25M |
Cutting the operator’s hurdle by 10 points makes O2 positive in all markets at p=50% (Cairo +0.01M, North Coast +0.04M, Red Sea +0.04M). O3 needs a ~20-point cut to turn positive — a deeper discount than O2, because O3 must recover the entire fit-out from income alone. Finding capital 10+ points below T-bill+8 is worth more than re-pricing the structure.
Minimum draw and owner-paid shortfall: no help
A guaranteed annual recoup looks protective, but at base yield the deferred balance already clears within 10 years in every case — so a shortfall rule never triggers. The unrecouped balance at year 10 is 0.00M in every scenario tested. The real problem is time value (the operator is repaid slowly at no interest), not default. A minimum draw lifts O3 operator NPV slightly (O3 premium, draw 40%/yr: Cairo −0.63M → −0.37M) but the operator is still negative, and it wipes out the owner’s surplus (Cairo +0.72M → −0.62M). Minimum draw and shortfall rules transfer value from the owner to the operator without making the operator viable.
Full tables: minimum draw and cheaper capital.