Prototype. Every figure on this page is illustrative. The register holds 8 sample assets from the MoPED data-model workbook and 112 generated to match its schema — no real asset, valuation or coordinate.

Commercial & Residential Building — El Qawmiya

ISM-MXU-0077 · Ismailia

3 - Long term / complexIllegally occupiedCondition: FairUnder reviewConfidence: Low

Commercial & Residential Building — El Qawmiya

121 El Tahrir Street, El Qawmiya, Ismailia, Ismailia

Mixed-use · Within compound · State-Owned Enterprise

Value is in the land, not the structures.

Market value

⁦EGP 211.8m⁩

book value ⁦EGP 119.9m⁩

Value after renovation

⁦EGP 243.6m⁩

scope:

CapEx

⁦EGP 110.8m⁩

over 9 months

Net operating income

⁦EGP 24.7m⁩

on ⁦EGP 35.3m⁩ gross revenue

Gross yield

⁦11.7%⁩

below the ⁦12%⁩ hurdle — sale candidate

Revenue gap

⁦EGP 24.7m⁩

against ⁦EGP 0⁩ earned today

Recommendation

Highest & best use

Commercial / retail

Monetization route

Build-Operate-Transfer (BOT)

Payback

⁦4.5⁩yrs

Vacant

⁦2⁩yrs

Monthly rent equiv.

⁦EGP 2,942,052⁩

Assumed occupancy

⁦73%⁩

Blockers

  • Clearing informal occupants from the site

Location

Coordinates
⁦30.6025⁩, ⁦32.2921⁩
Main road / transport
⁦0.0⁩ / ⁦0.1⁩ km

Estimated valueSimulated

Back-cast from today's valuation at the Assumptions sheet's inflation rate plus governorate drift.

Condition scoreSimulated

Decay rate follows the recorded utilization status; the final point is today's rating.

A. Identification & Ownership

14
Asset IDasset_id
ISM-MXU-0077
Asset Name (EN)asset_name_en
Commercial & Residential Building — El Qawmiya
Asset Name (AR)asset_name_ar
مبنى تجاري سكني — القومية
Custodian Entitycustodian_entity
State-Owned Enterprise
Custodian Sub-Unit / Directoratecustodian_sub
Projects Sector
Ownership Typeownership_type
Joint / shared ownership
Title / Registration Statustitle_status
Registered (مسجل)
Real-Estate Registry No.registry_no
1984/8642
Asset Classasset_class
Mixed-use (متعدد الاستخدام)
Asset Sub-Typeasset_subtype
Within compound
Current Usecurrent_use
Closed
Utilization Statusutilization_status
Illegally occupied (وضع يد)
Years Vacant / Underusedvacancy_years
⁦2⁩
Occupied By / Encumbrancesoccupied_by
One government directorate, part of the floor area

B. Location & Geospatial

14
Governorategovernorate
Ismailia
City / Markazcity
Ismailia
District / Neighbourhooddistrict
El Qawmiya
Full Address (EN)address_en
121 El Tahrir Street, El Qawmiya, Ismailia, Ismailia
Full Address (AR)address_ar
١٢١ شارع التحرير، القومية، الإسماعيلية، الإسماعيلية
Latitudelatitude
⁦30.602496⁩
Longitudelongitude
⁦32.292136⁩
Zoning Classificationzoning
Commercial
Permitted Use per Detailed Planpermitted_use
Residential + ground retail, FAR 2.5
Distance to Main Road (km)dist_main_road
⁦0.01⁩
Distance to Transport Node (km)dist_transport
⁦0.10⁩
Catchment Population (000s)catchment_pop
⁦EGP 393⁩

C. Physical Characteristics

11
Land Area (m2)land_area
⁦1,800 m²⁩
Built-Up Area / BUA (m2)bua
⁦10,860 m²⁩
Gross Leasable Area (m2)gla
⁦8,820 m²⁩
Number of Floorsfloors_count
⁦6⁩
Number of Unitsunits_count
⁦27⁩
Year Builtyear_built
⁦2,000⁩
Building Age (yrs)building_ageƒ
⁦26⁩
Structure Typestructure_type
Reinforced concrete
Finishing Levelfinishing_level
Semi-finished
Utilities Connectedutilities
Electricity, Water, Sewage
Heritage-Listed?heritage_listed
No

D. Internal Division & Layout

9
Internally Divided?has_internal_division
Yes
Number of Roomsrooms_count
⁦82⁩
Number of Bathroomsbathrooms_count
⁦25⁩
Reception / Hallsreception_count
⁦20⁩
Kitchenskitchens_count
⁦13⁩
Open-Plan Area (m2)open_plan_area
⁦1,150 m²⁩
Partition Flexibilitypartition_flexibility
Low - fixed load-bearing layout
Parking Spacesparking_spaces
⁦26⁩
Layout Noteslayout_notes
Single open floor plate, core to the north; ready for partitioning.

E. Condition & Renovation

9
Physical Conditioncondition_rating
Fair
Condition Notes (EN)condition_notes_en
Structure sound; façade weathered, MEP obsolete, lifts out of service.
Condition Notes (AR)condition_notes_ar
الهيكل الإنشائي سليم؛ الواجهة متهالكة والتغذية الكهروميكانيكية قديمة والمصاعد متوقفة.
Renovation Required?renovation_required
Yes
Renovation Cost (EGP/m2)reno_cost_sqm
⁦10,200 m²⁩
Est. Renovation Cost (EGP)reno_cost_totalƒ
⁦EGP 110,772,000⁩
Renovation Duration (months)reno_duration_months
⁦9⁩
Licensing / Compliance Statuscompliance_status
Fully licensed

F. Valuation

8
Valuation Methodvaluation_method
Residual land value
Land Value (EGP/m2)land_value_sqm
⁦EGP 12,100⁩
Building Value (EGP/m2)building_value_sqm
⁦EGP 17,500⁩
Est. Market Value (EGP)market_valueƒ
⁦EGP 211,830,000⁩
Value After Renovation (EGP)value_post_renoƒ
⁦EGP 243,604,500⁩
Government Book Value (EGP)book_value
⁦EGP 119,900,000⁩
Valuation Datevaluation_date
⁦18 Sept 2026⁩
Valuation Sourcevaluation_source
Industrial land comparables 2026

G. Income & Rental Potential

11
ADR - Residential (EGP/day)adr_residential
⁦EGP 0⁩
ADR - Commercial / Retail (EGP/day)adr_commercial
⁦EGP 132,500⁩
ADR - Office (EGP/day)adr_office
⁦EGP 0⁩
ADR Applied (EGP/day)adr_applicableƒ
⁦EGP 132,500⁩
Assumed Occupancy Rateoccupancy_rate
⁦73.0%⁩
Gross Annual Revenue (EGP)gross_annual_revenueƒ
⁦EGP 35,304,625⁩
Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
⁦EGP 2,942,052⁩
Annual Operating Cost (EGP)annual_opex
⁦EGP 10,591,388⁩
Net Operating Income (EGP)noiƒ
⁦EGP 24,713,237⁩
Gross Yield (%)gross_yieldƒ
⁦11.7%⁩
Renovation Payback (yrs)reno_payback_yearsƒ
⁦4.48⁩

H. Utilization Gap & Monetization

7
Current Actual Income (EGP/yr)current_annual_income
⁦EGP 0⁩
Annual Revenue Gap (EGP)revenue_gapƒ
⁦EGP 24,713,237⁩
Highest & Best Usehighest_best_use
Commercial / retail
Recommended Monetization Routemonetization_option
Build-Operate-Transfer (BOT)
CapEx to Activate (EGP)capex_to_activateƒ
⁦EGP 110,772,000⁩
Priority Tierpriority_tier
3 - Long term / complex
Key Blockersblockers
Clearing informal occupants from the site

I. Media & Documentation

6
Number of Photosphotos_count
38
Floor Plan / Survey (URL)floorplan_link
https://drive.example.org/assets/ISM-MXU-0077/plan.pdf

J. Data Governance

7
Primary Data Sourcedata_source
Satellite / GIS
Data Confidenceconfidence_level
Low
Site Visit Datesite_visit_date
⁦13 Mar 2024⁩
Surveyor / Analystsurveyor
M. Farouk
Last Updatedlast_updated
⁦14 Jul 2024⁩
Record Statusrecord_status
Under review
General Notesnotes
Value is in the land, not the structures.

38 photographs on file

The survey's geotagged photographs live in the custodian's drive folder. This prototype records the link and the count rather than shipping the images.

https://drive.example.org/assets/ISM-MXU-0077/photos

Source: Satellite / GIS. Surveyed by M. Farouk on ⁦13 Mar 2024⁩. Record last updated ⁦14 Jul 2024⁩.