5-Year Financial Analysis

Interactive P&L model with real-time ROI calculations

Input Parameters

Adjust the parameters above to see real-time impact on revenue and ROI metrics below.

Revenue Projections

Daily Revenue
EGP 11,920,000
Monthly Revenue
EGP 357,600,000
Annual Revenue
EGP 4,350,800,000
5-Year Gross Revenue
EGP 21,754,000,000

Profitability & ROI

5-Year EBITDA
EGP 20,859,713,875

Revenue - (OPEX × 5 years)

Payback Period
3.3 months

CAPEX / Monthly EBITDA

5-Year IRR
450.25%

Internal Rate of Return

Investment Overview

CAPEX Breakdown

EGP 894,286,125 Total

  • LED Mesh System: EGP 528,000,000
  • Control & Processing: EGP 85,000,000
  • Creative Studio: EGP 45,000,000
  • Interactive Experiences: EGP 120,000,000
  • Infrastructure (Power, HVAC, Fire): EGP 90,000,000
  • Installation & Integration: EGP 26,286,125

Annual OPEX Breakdown

EGP 87,000,000 / year

  • Electricity: EGP 36,000,000
  • Staffing (18 FTE): EGP 21,600,000
  • Maintenance & Parts: EGP 15,000,000
  • Software Licenses: EGP 4,800,000
  • Insurance: EGP 3,600,000
  • Marketing & Sales: EGP 6,000,000

5-Year Summary

  • Total Investment: EGP 894.3M (upfront)
  • Total OPEX: EGP 435M (5 years)
  • Gross Revenue: EGP 21.75B
  • Net Profit: EGP 20.43B
  • ROI: 2,285%
  • Payback: ~3.3 months

Annual Revenue vs OPEX

Sensitivity Analysis

How changes in key variables impact profitability

Scenario Fill Rate Avg Spot Price Annual Revenue Payback (months) 5-Year EBITDA
Conservative 60% EGP 25,000 EGP 2.4B 5.4 EGP 11.6B
Moderate 70% EGP 30,000 EGP 3.2B 3.9 EGP 15.6B
Base Case 80% EGP 35,000 EGP 4.3B 3.3 EGP 20.9B
Optimistic 90% EGP 40,000 EGP 5.5B 2.7 EGP 27.1B
Aggressive 95% EGP 45,000 EGP 6.5B 2.3 EGP 32.2B

Risk Factors & Mitigations

Market Risk

Risk: Lower-than-expected demand for premium outdoor advertising

Mitigation:

  • Pre-sell 30% of Year 1 inventory before launch
  • Flexible pricing tiers to capture all market segments
  • Diversified revenue (VR, AR, events) beyond advertising
  • Long-term contracts lock in baseline revenue

Technical Risk

Risk: LED system failures, weather damage, or downtime

Mitigation:

  • 99.5% uptime SLA with redundant systems
  • IP68 weatherproofing + lightning protection
  • 10% spare module inventory for hot-swap repairs
  • Comprehensive insurance coverage (property + BI)

Regulatory Risk

Risk: Content restrictions, brightness limits, or operating hours

Mitigation:

  • Pre-approval from Cairo Tourism Authority
  • Auto-dimming based on ambient light sensors
  • Content moderation system (automated + manual)
  • Partnership with Ministry of Culture for PSAs

Funding Strategy

Recommended Capital Structure

Equity (40%)

EGP 357,714,450

  • Sponsor equity: EGP 200M
  • Strategic partner (ad agency): EGP 100M
  • Tower management stake: EGP 57.7M

Debt (60%)

EGP 536,571,675

  • Senior bank loan (5yr, 8%): EGP 400M
  • Mezzanine financing (7yr, 12%): EGP 136.6M
  • Equipment leasing: Included in loan

With 3.3-month payback on EBITDA, debt service coverage ratio exceeds 15×, making this extremely attractive to lenders.

Next Steps

Ready to Move Forward?

This financial model demonstrates exceptional ROI with rapid payback. The combination of premium location, cutting-edge technology, and diversified revenue streams creates a compelling investment opportunity.

Review Technology Review Operations Review Ad Matrix