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
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%.
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.
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%).
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×.
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.
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.
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%.
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.
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.
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.
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
- Pilot: Red Sea, O2 with p=60–70%, 3–5 units, to measure realised gross yield and actual fit-out cost.
- Price the product around a cash share of 60–70% and a fixed deferral markup, not O3.
- In parallel, find capital at a hurdle 10+ points below T-bill plus 8.
- 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
| Market | Opt | Capex | Op NPV | Op IRR | Payback yr | Peak exposure | Recoup clears yr | Owner surplus vs best alt | Yr-8 fee %gross |
|---|---|---|---|---|---|---|---|---|---|
| Cairo | O1 | 0.83M | 0.20M | n/a | 0 | -0.00M | 0 | -1.48M | 16% |
| O2 | 0.83M | -0.08M | 19% | 3 | 0.40M | 3 | -0.42M | 16% | |
| O3 | 0.83M | -0.37M | 8% | 6 | 0.83M | 6 | 0.64M | 16% | |
| North Coast | O1 | 0.91M | 0.23M | n/a | 0 | -0.00M | 0 | -1.44M | 15% |
| O2 | 0.91M | -0.07M | 21% | 3 | 0.44M | 3 | -0.29M | 15% | |
| O3 | 0.91M | -0.38M | 9% | 5 | 0.91M | 5 | 0.82M | 15% | |
| Red Sea | O1 | 0.50M | 0.14M | n/a | 0 | -0.00M | 0 | -0.55M | 16% |
| O2 | 0.50M | -0.03M | 23% | 3 | 0.24M | 3 | 0.07M | 16% | |
| O3 | 0.50M | -0.19M | 10% | 4 | 0.50M | 4 | 0.67M | 16% |
Premium fit-out
| Market | Opt | Capex | Op NPV | Op IRR | Payback yr | Peak exposure | Recoup clears yr | Owner surplus vs best alt | Yr-8 fee %gross |
|---|---|---|---|---|---|---|---|---|---|
| Cairo | O1 | 1.25M | 0.27M | n/a | 0 | -0.00M | 0 | -2.59M | 17% |
| O2 | 1.25M | -0.16M | 16% | 3 | 0.60M | 4 | -0.95M | 17% | |
| O3 | 1.25M | -0.63M | 6% | 6 | 1.25M | 7 | 0.72M | 17% | |
| North Coast | O1 | 1.38M | 0.33M | n/a | 0 | -0.00M | 0 | -2.48M | 16% |
| O2 | 1.38M | -0.14M | 18% | 3 | 0.66M | 3 | -0.71M | 16% | |
| O3 | 1.38M | -0.63M | 7% | 6 | 1.38M | 6 | 1.04M | 16% | |
| Red Sea | O1 | 0.75M | 0.19M | n/a | 0 | -0.00M | 0 | -1.10M | 17% |
| O2 | 0.75M | -0.07M | 20% | 3 | 0.36M | 3 | -0.15M | 17% | |
| O3 | 0.75M | -0.33M | 8% | 6 | 0.75M | 6 | 0.79M | 17% |
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.
| Market | Hold shell | Sell now & deposit | Self-finish + manager | Deal O3 | Deal O1 |
|---|---|---|---|---|---|
| Cairo | 8.49M | 9.19M | 7.68M | 9.82M | 7.71M |
| North Coast | 12.97M | 14.04M | 12.44M | 14.86M | 12.60M |
| Red Sea | 5.90M | 6.38M | 5.79M | 7.05M | 5.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
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 0% | n/a | no | 0% | n/a |
| O2 | 54% | 13% | no | 29% | 7% | |
| O3 | n/a | 69% | no | n/a | 37% | |
| North Coast | O1 | 2% | n/a | no | 1% | n/a |
| O2 | 44% | 21% | no | 22% | 11% | |
| O3 | n/a | 64% | no | n/a | 32% | |
| Red Sea | O1 | 2% | 10% | YES | 1% | 5% |
| O2 | 39% | 34% | no | 21% | 18% | |
| O3 | n/a | 75% | no | n/a | 40% |
Mid, revenue DeepSeek-yield ×1.5
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 3% | 28% | YES | 2% | 17% |
| O2 | 26% | 48% | YES | 16% | 29% | |
| O3 | 72% | 87% | YES | 43% | 52% | |
| North Coast | O1 | 5% | 30% | YES | 3% | 17% |
| O2 | 23% | 45% | YES | 13% | 26% | |
| O3 | 54% | 85% | YES | 31% | 49% | |
| Red Sea | O1 | 5% | 29% | YES | 3% | 17% |
| O2 | 21% | 43% | YES | 13% | 26% | |
| O3 | 50% | 89% | YES | 30% | 53% |
Mid, revenue low ×0.75
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 0% | n/a | no | 0% | n/a |
| O2 | n/a | n/a | no | n/a | n/a | |
| O3 | n/a | 15% | no | n/a | 20% | |
| North Coast | O1 | 0% | n/a | no | 0% | n/a |
| O2 | n/a | n/a | no | n/a | n/a | |
| O3 | n/a | 8% | no | n/a | 3% | |
| Red Sea | O1 | 0% | n/a | no | 0% | n/a |
| O2 | 78% | n/a | no | 36% | n/a | |
| O3 | n/a | 43% | no | n/a | 20% |
Premium, revenue base
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 0% | n/a | no | 0% | n/a |
| O2 | 74% | n/a | no | 42% | n/a | |
| O3 | n/a | 75% | no | n/a | 42% | |
| North Coast | O1 | 0% | n/a | no | 0% | n/a |
| O2 | 56% | 12% | no | 30% | 6% | |
| O3 | n/a | 71% | no | n/a | 38% | |
| Red Sea | O1 | 0% | n/a | no | 0% | n/a |
| O2 | 50% | 24% | no | 28% | 13% | |
| O3 | n/a | 80% | no | n/a | 45% |
Premium, revenue DeepSeek-yield ×1.5
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 1% | 24% | YES | 1% | 15% |
| O2 | 33% | 49% | YES | 20% | 30% | |
| O3 | n/a | 90% | no | n/a | 56% | |
| North Coast | O1 | 3% | 28% | YES | 2% | 17% |
| O2 | 27% | 49% | YES | 16% | 29% | |
| O3 | 75% | 88% | YES | 45% | 53% | |
| Red Sea | O1 | 3% | 27% | YES | 2% | 17% |
| O2 | 25% | 47% | YES | 15% | 28% | |
| O3 | 69% | 92% | YES | 42% | 56% |
Premium, revenue low ×0.75
| Market | Opt | s_min | s_max | Band exists | Fee%gross at min | at max |
|---|---|---|---|---|---|---|
| Cairo | O1 | 0% | n/a | no | 0% | n/a |
| O2 | n/a | n/a | no | n/a | n/a | |
| O3 | n/a | 5% | no | n/a | 51% | |
| North Coast | O1 | 0% | n/a | no | 0% | n/a |
| O2 | n/a | n/a | no | n/a | n/a | |
| O3 | n/a | 16% | no | n/a | 26% | |
| Red Sea | O1 | 0% | n/a | no | 0% | n/a |
| O2 | n/a | n/a | no | n/a | n/a | |
| O3 | n/a | 51% | no | n/a | 27% |
4. Sensitivity (operator NPV of O3 mid, EGP M, under VAT / revenue / overrun / rates)
| Market | base | VAT 14% | rev ×0.75 | rev ×1.5 | overrun +25% | infl +3pt | pass-thru 0.6 | s_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)
| Market | O1 | O2 | O3 |
|---|---|---|---|
| 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%
| Market | Opt | P(op NPV>0) | P5 | Median | P95 | P(owner beats best alt) |
|---|---|---|---|---|---|---|
| Cairo | O1 | 88% | -0.03M | 0.09M | 0.19M | 0% |
| O2 | 0% | -0.36M | -0.22M | -0.08M | 18% | |
| O3 | 0% | -0.74M | -0.54M | -0.35M | 67% | |
| North Coast | O1 | 89% | -0.03M | 0.10M | 0.24M | 4% |
| O2 | 2% | -0.40M | -0.22M | -0.05M | 23% | |
| O3 | 0% | -0.81M | -0.56M | -0.34M | 63% | |
| Red Sea | O1 | 92% | -0.01M | 0.06M | 0.14M | 0% |
| O2 | 2% | -0.20M | -0.11M | -0.02M | 35% | |
| O3 | 0% | -0.42M | -0.29M | -0.17M | 80% |
7. Scale-up (peak operator capital, mid, base)
| Market | Opt | per unit | 50 units | 200 units |
|---|---|---|---|---|
| Cairo | O1 | -0.00M | -0M | -0M |
| O2 | 0.40M | 20M | 80M | |
| O3 | 0.83M | 42M | 166M | |
| North Coast | O1 | -0.00M | -0M | -0M |
| O2 | 0.44M | 22M | 88M | |
| O3 | 0.91M | 46M | 183M | |
| Red Sea | O1 | -0.00M | -0M | -0M |
| O2 | 0.24M | 12M | 48M | |
| O3 | 0.50M | 25M | 100M |
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.
| Market | Tier | Opt | s_op | Required markup on deferred part | Owner surplus at that markup (EGP M) |
|---|---|---|---|---|---|
| Cairo | mid | O3 | 30% | none up to 600% | – |
| O2 | 30% | 143% | -0.97 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 180% | -0.96 | ||
| premium | O3 | 30% | none up to 600% | – | |
| O2 | 30% | 267% | -2.29 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 286% | -2.30 | ||
| North Coast | mid | O3 | 30% | none up to 600% | – |
| O2 | 30% | 102% | -0.72 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 142% | -0.69 | ||
| premium | O3 | 30% | none up to 600% | – | |
| O2 | 30% | 158% | -1.70 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 191% | -1.69 | ||
| Red Sea | mid | O3 | 30% | none up to 600% | – |
| O2 | 30% | 76% | -0.09 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 123% | -0.07 | ||
| premium | O3 | 30% | none up to 600% | – | |
| O2 | 30% | 123% | -0.58 | ||
| O3 | 20% | none up to 600% | – | ||
| O2 | 20% | 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)
| p | Cairo NPV | Cairo owner | Cairo capital | NC NPV | NC owner | NC capital | RS NPV | RS owner | RS capital |
|---|---|---|---|---|---|---|---|---|---|
| 40% | -0.14M | -0.22M | 0.49M | -0.13M | -0.08M | 0.53M | -0.06M | 0.19M | 0.29M |
| 50% | -0.08M | -0.42M | 0.40M | -0.07M | -0.29M | 0.44M | -0.03M | 0.07M | 0.24M |
| 60% | -0.03M | -0.61M | 0.31M | -0.01M | -0.50M | 0.34M | 0.00M | -0.04M | 0.19M |
| 70% | 0.02M | -0.79M | 0.22M | 0.04M | -0.68M | 0.24M | 0.03M | -0.14M | 0.13M |
| 80% | 0.07M | -0.96M | 0.13M | 0.09M | -0.87M | 0.15M | 0.06M | -0.24M | 0.08M |
10. O2 agreement band by cash share and yield (v3b, s_min–s_max of NOI)
| Yield | p | Cairo | North Coast | Red Sea |
|---|---|---|---|---|
| ×1.0 | 50% | 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/a | No 16–9% | Yes 15–20% | |
| ×1.2 | 50% | 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.5 | 50% | 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)
| Option | Rule | Cairo | North Coast | Red Sea |
|---|---|---|---|---|
| O3 | none | -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.
| Tier · yield | Rule | Cairo | North Coast | Red Sea |
|---|---|---|---|---|
| premium · base | none (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.75 | none (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.75 | none (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)
| Option | Hurdle cut | Cairo | North Coast | Red Sea |
|---|---|---|---|---|
| O3 | 0pt | -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 | |
| -20pt | 0.01M | 0.05M | 0.05M | |
| O2 | 0pt | -0.08M | -0.07M | -0.03M |
| -5pt | -0.04M | -0.02M | 0.00M | |
| -10pt | 0.01M | 0.04M | 0.04M | |
| -15pt | 0.08M | 0.12M | 0.08M | |
| -20pt | 0.17M | 0.22M | 0.15M | |
| O1 | 0pt | 0.20M | 0.23M | 0.14M |
| -5pt | 0.22M | 0.26M | 0.15M | |
| -10pt | 0.25M | 0.30M | 0.18M | |
| -15pt | 0.29M | 0.35M | 0.21M | |
| -20pt | 0.35M | 0.43M | 0.25M |
14. Hybrid band (v3b, O2 p=60% + draw 8%/yr + owner pays shortfall, s_min–s_max of NOI)
| Yield | Cairo | North Coast | Red Sea |
|---|---|---|---|
| ×1.0 | No 37–7% | No 32–16% | No 29–28% |
| ×1.2 | Yes 27–32% | Yes 24–40% | Yes 22–47% |
| ×1.5 | Yes 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])
| Yield | Units | Peak capital | Unit NPV sum | Central cost PV | Net NPV | Break-even units |
|---|---|---|---|---|---|---|
| ×1.0 | 50 | 14.0M | 0.0M | 20.0M | -20.0M | 22,696 |
| 200 | 56.0M | 2.7M | 20.0M | -17.3M | 1,493 | |
| ×1.2 | 50 | 14.0M | 2.3M | 20.0M | -17.7M | 426 |
| 200 | 56.0M | 12.3M | 20.0M | -7.7M | 325 | |
| ×1.5 | 50 | 14.0M | 5.7M | 20.0M | -14.4M | 177 |
| 200 | 56.0M | 26.3M | 20.0M | 6.2M | 153 |
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.