Assumptions & risks

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.

Sensitivity

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.

O3 operator NPV under eight scenarios, mid fit-out, by market (EGP M per unit).

Per unit, EGP nominal, 10-year term.

Even the best scenario stays negative

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).

VAT

0% vs 14% on short stays

Whether short-term stays attract VAT is an unresolved legal question. The model runs both ways.

O3 operator NPV with VAT at 0% vs 14%, mid fit-out (EGP M per unit).
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.

Unverified calibrations

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.

All unverified calibrations in the model.
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.
Inputs to verify

What needs real data before this is anything but a model

These are the inputs that would most change the answer once verified.

  1. 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.
  2. VAT on short-term accommodation — modelled at 0 or 14%, costs ~0.03–0.05M per unit NPV.
  3. Fit-out EGP/m² — mid 8,300 (DeepSeek’s 7,900–8,700), premium 12,500 is a guess.
  4. Hurdle — T-bill path + 8pt. A lower hurdle (cheaper capital) is the biggest lever after yield.
  5. Unit values, areas, fixed opex per m², resale discount (30%), residual value of fit-out (10%).
  6. Legal — usufruct vs registered lease, 8+ unit licensing, Law 230 for foreign owners.
Unresolved legal items
  • 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.
v3b · Next scenarios

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

Operator NPV (EGP M per unit) at three hurdle cuts, base yield, mid. Negative cut = points off the hurdle.
Option Hurdle cut Cairo North Coast Red Sea
O30pt-0.37M-0.38M-0.19M
-10pt-0.23M-0.22M-0.10M
-20pt0.01M0.05M0.05M
O20pt-0.08M-0.07M-0.03M
-10pt0.01M0.04M0.04M
-20pt0.17M0.22M0.15M
O10pt0.20M0.23M0.14M
-10pt0.25M0.30M0.18M
-20pt0.35M0.43M0.25M
A 10-point cheaper hurdle flips O2, but O3 needs ~20

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

These do not fix the problem

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.