Full report · v3

What the model says

Per unit, EGP nominal, 10 years. Full tables are below; the modelling code is za_model_v3.py, with six passing tests (ledger conservation, closed-form recoup check, limiting cases, monotonicity, O2 reduces to O1/O3, hand calc).

Headline findings

Operator fails

1. O3 does not clear an investor hurdle at base yields

O3 (repay 100% from ops income) does not clear an investor hurdle at base yields, in any market or fit-out tier. Even if the operator took ~100% of NOI for all 10 years, the present value of that NOI at the hurdle (T-bill path + 8pt) is below capex: Cairo 0.60M vs 0.83M, NC 0.75M vs 0.91M, RS 0.44M vs 0.50M. Raising the markup does not help, because recoup is capped by NOI, not by the balance. Operator IRR on O3 is only 8–10% (mid) against T-bills near 25%.

Mixed

2. O1 works for the operator, but owners lose

O1 (cash upfront) works for the operator (positive NPV, zero capital at risk, ~88–92% positive in Monte Carlo) but owners lose against self-finishing with a standard manager. The owner pays +15% markup and a ~16% fee for roughly what a 17.5% manager gives. Owner surplus is -0.5M to -1.5M mid-tier, so O1 only sells as a convenience or turnkey service.

Mixed

3. O2’s band opens once yields step up (~1.2× base)

O2 is the only structure with an agreement band, and it needs realised yields of about 1.2× base to open one in every market at every cash share (v3b). At ~1.5× the bands are wide (e.g. mid, O2: s_op 12–48% of NOI). At base yields no O2 band exists except a thin one in the Red Sea (p 70–80%).

Swing factor

4. Everything turns on realised gross yield

Everything turns on realised gross yield. I calibrated base gross yield to 9–11% of unit value (Cairo 10%, NC 9%, RS 11%) est. DeepSeek’s implied yields were ~1.5× higher; Gemini gave no realised figures. Break-even revenue for O3 is 2.0–2.5× base; for O2 it is 1.2–1.4×.

Premium worse

5. Premium fit-out is worse than mid everywhere

Premium fit-out is worse than mid everywhere unless it earns well beyond my +18% revenue uplift est. Premium raises capex ~50% and the operator bears the overrun risk.

Owner benefit

6. Where the owner benefit comes from

Under O3 owners do beat hold/sell (surplus +0.6–1.0M), because they get a finished, managed unit with no cash. That is the real value to the owner, but the operator cannot afford it at current rates.

What this implies for the design (not yet modelled)

  • Shrink the operator’s capital need: cap the fit-out at a fixed budget per m², keep cash-in (O2 with p ≥ 50–60%), or find third-party capital at below-hurdle cost (a fund or developer-backed line).
  • Bring a time-based minimum: the operator needs a floor on its recoup (a minimum monthly NOI draw or a longer term), or an end-of-term shortfall paid by the owner. The v3 base forgives any shortfall; set shortfall="owner_pays" to test it.
  • The deferral markup must be fixed at signing (murabaha-style). An accruing interest on the deferred part raises Sharia and FRA 18/2020 questions that need a lawyer.
  • Test a hybrid: O2 with p≈60% in the Red Sea first, where the band is thinnest-to-widest at the lowest capital per unit (0.24M/unit at p=50%).

Inputs to verify before relying on any number

  • 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 est (DeepSeek’s 7,900–8,700), premium 12,500 est is my 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.

Not in v3

Master lease (dropped on purpose), early-exit and owner-default modelling, portfolio effects (shared overhead, occupancy correlation), and scale-up beyond peak capital.

v3b: O2 up-scaling and hybrid scenarios

v3b keeps the v3 model and adds two levers: min_draw (a guaranteed annual recoup as a % of plan cost, with the owner topping up any NOI shortfall) and hur_shift (cheaper capital, in points off the hurdle). It also sweeps the O2 cash share p from 40% to 80% and tests scale-up with a central team. The two model files are za_model_v3.py and run_v3b.py; full tables are t9–t15.

Mixed

7. Cash share is the strongest structural lever

At base yield, O2 operator NPV turns positive at p=70% (Cairo +0.02M, NC +0.04M, RS +0.03M per unit). But owner surplus falls as p rises (Cairo −0.79M at p=70%) because the owner funds more cash against deposit rates of 20%+. At base yield an agreement band exists only in the Red Sea at p 70–80%.

Mixed

8. A modest yield improvement opens bands everywhere

At yield ×1.2 an O2 band exists in all three markets at every p from 50% to 80% (e.g. RS p=60%: operator share 22–47% of NOI). At ×1.5 the bands are wide. The yield estimate decides the case, so the pilot should measure it first.

Mixed

9. Cheaper capital also works

Cutting the operator’s hurdle by 10 points makes O2 positive in all markets at p=50% (Cairo +0.01M, NC +0.04M, RS +0.04M); O3 needs a ~20 point cut. A fund, developer line or family-office capital at that cost is worth more than structural tweaks.

Not the fix

10. Minimum draw and owner-paid shortfall are not the fix

At base yield the deferred balance clears within 10 years in every case, so a shortfall rule never triggers. The problem is time value (the operator is repaid slowly at no interest), not default. A minimum draw lifts operator NPV (O3 premium, draw 40%/yr: Cairo −0.63M to −0.37M) but wipes out the owner’s surplus, and the operator is still negative.

Scale-up

11. Scale-up does not rescue the economics by itself

An equal mix at O2 p=60% needs ~14M EGP peak capital for 50 units and 56M for 200. The unit-level NPV sum is ~0 to +2.7M at base yield. With a 6M EGP/yr central team est (placeholder) the business only covers its central cost at 150–180 units and yield ×1.5 (net +6.2M at 200 units). At base yield it never does.

Recommendation

  1. Pilot: Red Sea, O2 with p=60–70%, 3–5 units, to measure realised gross yield and actual fit-out cost.
  2. Price the product around a cash share of 60–70% and a fixed deferral markup, not O3.
  3. In parallel, find capital at a hurdle 10+ points below T-bill plus 8.
  4. Replace the placeholder central cost and overhead scale economies with real numbers before showing scale-up to investors.

Full tables

All figures are per unit, EGP nominal, 10-year term. Values marked est are unverified calibrations. Geo labels: Cairo = Greater Cairo, NC = North Coast (Sahel), RS = Red Sea. Options: O1 (100% cash + markup), O2 (part cash, rest from income), O3 (100% from income).

1. Base case (s_op=30% of NOI after recoup, m=15%, m_def=25%, p=50%, k=0.5, r=100%)

Mid fit-out

Base case, mid fit-out — operator and owner outcome per market and option.
MarketOpt CapexOp NPVOp IRR Payback yrPeak exposure Recoup clears yrOwner surplus vs best altYr-8 fee %gross
CairoO10.83M0.20Mn/a0-0.00M0-1.48M16%
O20.83M-0.08M19%30.40M3-0.42M16%
O30.83M-0.37M8%60.83M60.64M16%
North CoastO10.91M0.23Mn/a0-0.00M0-1.44M15%
O20.91M-0.07M21%30.44M3-0.29M15%
O30.91M-0.38M9%50.91M50.82M15%
Red SeaO10.50M0.14Mn/a0-0.00M0-0.55M16%
O20.50M-0.03M23%30.24M30.07M16%
O30.50M-0.19M10%40.50M40.67M16%

Premium fit-out

Base case, premium fit-out — operator and owner outcome per market and option.
MarketOpt CapexOp NPVOp IRR Payback yrPeak exposure Recoup clears yrOwner surplus vs best altYr-8 fee %gross
CairoO11.25M0.27Mn/a0-0.00M0-2.59M17%
O21.25M-0.16M16%30.60M4-0.95M17%
O31.25M-0.63M6%61.25M70.72M17%
North CoastO11.38M0.33Mn/a0-0.00M0-2.48M16%
O21.38M-0.14M18%30.66M3-0.71M16%
O31.38M-0.63M7%61.38M61.04M16%
Red SeaO10.75M0.19Mn/a0-0.00M0-1.10M17%
O20.75M-0.07M20%30.36M3-0.15M17%
O30.75M-0.33M8%60.75M60.79M17%

Gross revenue yr1/yr5 (mid): Cairo 270k/505k, NC 371k/695k, RS 206k/386k.

2. Owner alternatives (terminal wealth yr10, mid, O3 base)

Hold shell 8.49M; sell now & deposit 9.19M; self-finish + manager 7.68M; deal O3 9.82M.

Owner terminal wealth at year 10 under each choice (EGP M, mid fit-out).
MarketHold shellSell now & depositSelf-finish + managerDeal O3Deal O1
Cairo8.49M9.19M7.68M9.82M7.71M
North Coast12.97M14.04M12.44M14.86M12.60M
Red Sea5.90M6.38M5.79M7.05M5.84M

O2 is not reported in the v3 source. “Best alternative” is the wealth-maximising choice without the deal — sell now in every market; self-finish with a manager is the closest like-for-like (keep-and-rent) comparator.

3. Agreement band (operator NPV ≥ 0 and owner beats best alternative) on operator NOI share s_op

Mid, revenue base

Agreement band, mid fit-out, base revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO10%n/ano0%n/a
O254%13%no29%7%
O3n/a69%non/a37%
North CoastO12%n/ano1%n/a
O244%21%no22%11%
O3n/a64%non/a32%
Red SeaO12%10%YES1%5%
O239%34%no21%18%
O3n/a75%non/a40%

Mid, revenue DeepSeek-yield ×1.5

Agreement band, mid fit-out, DeepSeek-level (1.5×) revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO13%28%YES2%17%
O226%48%YES16%29%
O372%87%YES43%52%
North CoastO15%30%YES3%17%
O223%45%YES13%26%
O354%85%YES31%49%
Red SeaO15%29%YES3%17%
O221%43%YES13%26%
O350%89%YES30%53%

Mid, revenue low ×0.75

Agreement band, mid fit-out, low (0.75×) revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO10%n/ano0%n/a
O2n/an/anon/an/a
O3n/a15%non/a20%
North CoastO10%n/ano0%n/a
O2n/an/anon/an/a
O3n/a8%non/a3%
Red SeaO10%n/ano0%n/a
O278%n/ano36%n/a
O3n/a43%non/a20%

Premium, revenue base

Agreement band, premium fit-out, base revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO10%n/ano0%n/a
O274%n/ano42%n/a
O3n/a75%non/a42%
North CoastO10%n/ano0%n/a
O256%12%no30%6%
O3n/a71%non/a38%
Red SeaO10%n/ano0%n/a
O250%24%no28%13%
O3n/a80%non/a45%

Premium, revenue DeepSeek-yield ×1.5

Agreement band, premium fit-out, DeepSeek-level (1.5×) revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO11%24%YES1%15%
O233%49%YES20%30%
O3n/a90%non/a56%
North CoastO13%28%YES2%17%
O227%49%YES16%29%
O375%88%YES45%53%
Red SeaO13%27%YES2%17%
O225%47%YES15%28%
O369%92%YES42%56%

Premium, revenue low ×0.75

Agreement band, premium fit-out, low (0.75×) revenue.
MarketOpts_mins_maxBand existsFee%gross at minat max
CairoO10%n/ano0%n/a
O2n/an/anon/an/a
O3n/a5%non/a51%
North CoastO10%n/ano0%n/a
O2n/an/anon/an/a
O3n/a16%non/a26%
Red SeaO10%n/ano0%n/a
O2n/an/anon/an/a
O3n/a51%non/a27%

4. Sensitivity (operator NPV of O3 mid, EGP M, under VAT / revenue / overrun / rates)

Operator NPV of O3 (mid) under each stress (EGP M).
MarketbaseVAT 14%rev ×0.75rev ×1.5overrun +25%infl +3ptpass-thru 0.6s_op 40%
Cairo-0.37M-0.42M-0.49M-0.23M-0.57M-0.40M-0.39M-0.35M
North Coast-0.38M-0.43M-0.51M-0.20M-0.58M-0.40M-0.40M-0.35M
Red Sea-0.19M-0.22M-0.26M-0.10M-0.30M-0.21M-0.20M-0.17M

5. Break-even revenue multiplier (operator NPV=0 at s_op=30%, mid)

Revenue multiplier at which each option breaks even for the operator.
MarketO1O2O3
Cairo×0.20×1.36×2.49
North Coast×0.20×1.22×2.13
Red Sea×0.20×1.16×2.05

6. Monte Carlo (2,000 draws; rev lognormal sd25% mean-5%, overrun tri(0,10%,35%), infl ±2pt, VAT 50/50, pass-thru 0.6–1.0, ramp 0.5–0.9), mid, s_op 30%

Monte Carlo distribution of operator NPV and owner outcome.
MarketOptP(op NPV>0)P5MedianP95P(owner beats best alt)
CairoO188%-0.03M0.09M0.19M0%
O20%-0.36M-0.22M-0.08M18%
O30%-0.74M-0.54M-0.35M67%
North CoastO189%-0.03M0.10M0.24M4%
O22%-0.40M-0.22M-0.05M23%
O30%-0.81M-0.56M-0.34M63%
Red SeaO192%-0.01M0.06M0.14M0%
O22%-0.20M-0.11M-0.02M35%
O30%-0.42M-0.29M-0.17M80%

7. Scale-up (peak operator capital, mid, base)

Peak operator capital at one, 50 and 200 units (EGP M).
MarketOptper unit50 units200 units
CairoO1-0.00M-0M-0M
O20.40M20M80M
O30.83M42M166M
North CoastO1-0.00M-0M-0M
O20.44M22M88M
O30.91M46M183M
Red SeaO1-0.00M-0M-0M
O20.24M12M48M
O30.50M25M100M

8. Markup needed to clear the hurdle (s_op fixed), and what the owner still gets

Fixed deferral markup (murabaha-style, set at signing, no accruing interest). Hurdle = T-bill path + 8pt.

Markup required on the deferred part for the operator to clear its hurdle, and the owner surplus at that markup.
MarketTierOpts_opRequired markup on deferred partOwner surplus at that markup (EGP M)
CairomidO330%none up to 600%–
O230%143%-0.97
O320%none up to 600%–
O220%180%-0.96
premiumO330%none up to 600%–
O230%267%-2.29
O320%none up to 600%–
O220%286%-2.30
North CoastmidO330%none up to 600%–
O230%102%-0.72
O320%none up to 600%–
O220%142%-0.69
premiumO330%none up to 600%–
O230%158%-1.70
O320%none up to 600%–
O220%191%-1.69
Red SeamidO330%none up to 600%–
O230%76%-0.09
O320%none up to 600%–
O220%123%-0.07
premiumO330%none up to 600%–
O230%123%-0.58
O320%none up to 600%–
O220%162%-0.57

O2 at p=50%: cash part markup stays at m=15%×k; O1 needs no solve (cash upfront).

9. O2 cash-share sweep (v3b, operator NPV | owner surplus | peak capital, base yield, mid, EGP M)

O2 cash-share sweep, base yield, mid fit-out. p = owner’s cash share of fit-out.
p Cairo NPVCairo ownerCairo capital NC NPVNC ownerNC capital RS NPVRS ownerRS capital
40%-0.14M-0.22M0.49M-0.13M-0.08M0.53M-0.06M0.19M0.29M
50%-0.08M-0.42M0.40M-0.07M-0.29M0.44M-0.03M0.07M0.24M
60%-0.03M-0.61M0.31M-0.01M-0.50M0.34M0.00M-0.04M0.19M
70%0.02M-0.79M0.22M0.04M-0.68M0.24M0.03M-0.14M0.13M
80%0.07M-0.96M0.13M0.09M-0.87M0.15M0.06M-0.24M0.08M

10. O2 agreement band by cash share and yield (v3b, s_min–s_max of NOI)

O2 agreement band by cash share and yield. “Yes” = a band exists with s_min–s_max; “No” = no band (operator needs s_min%, owner can give s_max%).
YieldpCairoNorth CoastRed Sea
×1.050%No 54–13%No 44–21%No 39–34%
60%No 37–7%No 32–16%No 29–28%
70%No 25–2%No 23–12%Yes 21–24%
80%No 16–n/aNo 16–9%Yes 15–20%
×1.250%Yes 37–38%Yes 31–44%Yes 28–52%
60%Yes 27–32%Yes 24–40%Yes 22–47%
70%Yes 20–28%Yes 18–36%Yes 17–43%
80%Yes 13–24%Yes 14–32%Yes 13–40%
×1.550%Yes 26–48%Yes 23–45%Yes 21–43%
60%Yes 21–44%Yes 18–42%Yes 17–40%
70%Yes 16–40%Yes 15–39%Yes 14–38%
80%Yes 12–37%Yes 12–37%Yes 12–35%

11. Minimum draw and owner-paid shortfall, base yield (v3b, operator NPV | owner surplus, mid, EGP M)

Minimum draw and owner-paid shortfall, base yield, mid. The shortfall rule never triggers (deferred balance clears within 10 years).
OptionRuleCairoNorth CoastRed Sea
O3none-0.37 / 0.64-0.38 / 0.82-0.19 / 0.67
owner pays shortfall-0.37 / 0.64-0.38 / 0.82-0.19 / 0.67
draw 8%/yr-0.37 / 0.63-0.38 / 0.82-0.19 / 0.67
draw 8% + owner-0.37 / 0.63-0.38 / 0.82-0.19 / 0.67
draw 12% + owner-0.37 / 0.59-0.38 / 0.82-0.19 / 0.67
draw 16% + owner-0.36 / 0.56-0.38 / 0.82-0.19 / 0.67
O2 (p=50%)none-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07
owner pays shortfall-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07
draw 8%/yr-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07
draw 8% + owner-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07
draw 12% + owner-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07
draw 16% + owner-0.08 / -0.42-0.07 / -0.29-0.03 / 0.07

12. Minimum draw at premium and low yield (v3b, O3, operator NPV | owner surplus, EGP M)

The unrecouped balance at year 10 is 0.00M in every row — the deferred balance always clears within 10 years, so the owner-pays-shortfall rule never triggers.

Minimum draw at premium tier and low yield (×0.75), O3 (operator NPV | owner surplus, EGP M).
Tier · yieldRuleCairoNorth CoastRed Sea
premium · basenone (forgive)-0.63 / 0.72-0.63 / 1.04-0.33 / 0.79
owner pays-0.63 / 0.72-0.63 / 1.04-0.33 / 0.79
draw 30% + owner-0.45 / -0.16-0.49 / 0.33-0.26 / 0.46
draw 40% + owner-0.37 / -0.62-0.40 / -0.16-0.21 / 0.19
mid · ×0.75none (forgive)-0.49 / -0.09-0.51 / -0.21-0.26 / 0.08
owner pays-0.49 / -0.09-0.51 / -0.21-0.26 / 0.08
draw 30% + owner-0.31 / -0.88-0.35 / -0.96-0.19 / -0.27
draw 40% + owner-0.27 / -1.17-0.30 / -1.29-0.16 / -0.45
premium · ×0.75none (forgive)-0.78 / -0.13-0.82 / -0.13-0.42 / 0.13
owner pays-0.78 / -0.13-0.82 / -0.13-0.42 / 0.13
draw 30% + owner-0.46 / -1.55-0.52 / -1.49-0.28 / -0.54
draw 40% + owner-0.40 / -1.94-0.44 / -1.95-0.24 / -0.80

13. Cheaper capital (v3b, operator NPV when the hurdle falls by x points, base yield, mid, EGP M)

Operator NPV (EGP M per unit) when the hurdle falls by x points, base yield, mid fit-out.
OptionHurdle cutCairoNorth CoastRed Sea
O30pt-0.37M-0.38M-0.19M
-5pt-0.31M-0.31M-0.15M
-10pt-0.23M-0.22M-0.10M
-15pt-0.13M-0.10M-0.04M
-20pt0.01M0.05M0.05M
O20pt-0.08M-0.07M-0.03M
-5pt-0.04M-0.02M0.00M
-10pt0.01M0.04M0.04M
-15pt0.08M0.12M0.08M
-20pt0.17M0.22M0.15M
O10pt0.20M0.23M0.14M
-5pt0.22M0.26M0.15M
-10pt0.25M0.30M0.18M
-15pt0.29M0.35M0.21M
-20pt0.35M0.43M0.25M

14. Hybrid band (v3b, O2 p=60% + draw 8%/yr + owner pays shortfall, s_min–s_max of NOI)

Hybrid O2 p=60% + draw 8%/yr + owner pays shortfall, agreement band by yield.
YieldCairoNorth CoastRed Sea
×1.0No 37–7%No 32–16%No 29–28%
×1.2Yes 27–32%Yes 24–40%Yes 22–47%
×1.5Yes 21–44%Yes 18–42%Yes 17–40%

15. Scale-up (v3b, O2 p=60% equal mix, mid; central team EGP 6M/yr [est, placeholder])

Scale-up at O2 p=60%, equal mix of three markets, mid (EGP M). Central cost PV is 20.0M in every scenario.
YieldUnitsPeak capitalUnit NPV sumCentral cost PVNet NPVBreak-even units
×1.05014.0M0.0M20.0M-20.0M22,696
20056.0M2.7M20.0M-17.3M1,493
×1.25014.0M2.3M20.0M-17.7M426
20056.0M12.3M20.0M-7.7M325
×1.55014.0M5.7M20.0M-14.4M177
20056.0M26.3M20.0M6.2M153

The 6M EGP/yr central team is a placeholder est, not a real budget; unit overhead falls 6%→5% (50u) / 4% (200u) of net revenue. Replace both before showing scale-up to investors.